283 lines
23 KiB
XML

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ROCPPImportDataSet" targetNamespace="http://tempuri.org/ROCPPImportDataSet.xsd" xmlns:mstns="http://tempuri.org/ROCPPImportDataSet.xsd" xmlns="http://tempuri.org/ROCPPImportDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ROCPPImportConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ROCPPImportConnectionString (Settings)" PropertyReference="ApplicationSettings.WestinghouseROImport.Properties.Settings.GlobalReference.Default.ROCPPImportConnectionString" Provider="System.Data.OleDb">
</Connection>
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImportARP_tblTableAdapter" GeneratorDataComponentClassName="ImportARP_tblTableAdapter" Name="ImportARP_tbl" UserDataComponentName="ImportARP_tblTableAdapter">
<MainSource>
<DbSource ConnectionRef="ROCPPImportConnectionString (Settings)" DbObjectName="ImportARP_tbl" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>INSERT INTO `ImportARP_tbl` (`Document`, `Alarm`, `PointName`, `Type`, `Value`, `Description`, `SystemID`, `SysTitle`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Document" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Document" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Alarm" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Alarm" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PointName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PointName" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Value" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Value" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SystemID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SystemID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SysTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SysTitle" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>SELECT Document, Alarm, PointName, Type, [Value], Description, SystemID, SysTitle FROM ImportARP_tbl</CommandText>
<Parameters>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Document" DataSetColumn="Document" />
<Mapping SourceColumn="Alarm" DataSetColumn="Alarm" />
<Mapping SourceColumn="PointName" DataSetColumn="PointName" />
<Mapping SourceColumn="Type" DataSetColumn="Type" />
<Mapping SourceColumn="Value" DataSetColumn="Value" />
<Mapping SourceColumn="Description" DataSetColumn="Description" />
<Mapping SourceColumn="SystemID" DataSetColumn="SystemID" />
<Mapping SourceColumn="SysTitle" DataSetColumn="SysTitle" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImportMEL_qryTableAdapter" GeneratorDataComponentClassName="ImportMEL_qryTableAdapter" Name="ImportMEL_qry" UserDataComponentName="ImportMEL_qryTableAdapter">
<MainSource>
<DbSource ConnectionRef="ROCPPImportConnectionString (Settings)" DbObjectName="ImportMEL_qry" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>SELECT SystemID, SystemDesc, ComponentID, CompDesc, FullName, ShortName, Room, Description, CommonDesc FROM ImportMEL_qry</CommandText>
<Parameters>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="SystemID" DataSetColumn="SystemID" />
<Mapping SourceColumn="SystemDesc" DataSetColumn="SystemDesc" />
<Mapping SourceColumn="ComponentID" DataSetColumn="ComponentID" />
<Mapping SourceColumn="CompDesc" DataSetColumn="CompDesc" />
<Mapping SourceColumn="FullName" DataSetColumn="FullName" />
<Mapping SourceColumn="ShortName" DataSetColumn="ShortName" />
<Mapping SourceColumn="Room" DataSetColumn="Room" />
<Mapping SourceColumn="Description" DataSetColumn="Description" />
<Mapping SourceColumn="CommonDesc" DataSetColumn="CommonDesc" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImportSTP_qryTableAdapter" GeneratorDataComponentClassName="ImportSTP_qryTableAdapter" Name="ImportSTP_qry" UserDataComponentName="ImportSTP_qryTableAdapter">
<MainSource>
<DbSource ConnectionRef="ROCPPImportConnectionString (Settings)" DbObjectName="ImportSTP_qry" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>SELECT Parameter, Name, [Value], Description FROM ImportSTP_qry</CommandText>
<Parameters>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Parameter" DataSetColumn="Parameter" />
<Mapping SourceColumn="Name" DataSetColumn="Name" />
<Mapping SourceColumn="Value" DataSetColumn="Value" />
<Mapping SourceColumn="Description" DataSetColumn="Description" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
</Tables>
<Sources>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="ROCPPImportDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ROCPPImportDataSet" msprop:Generator_DataSetName="ROCPPImportDataSet">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="ImportARP_tbl" msprop:Generator_UserTableName="ImportARP_tbl" msprop:Generator_RowDeletedName="ImportARP_tblRowDeleted" msprop:Generator_TableClassName="ImportARP_tblDataTable" msprop:Generator_RowChangedName="ImportARP_tblRowChanged" msprop:Generator_RowClassName="ImportARP_tblRow" msprop:Generator_RowChangingName="ImportARP_tblRowChanging" msprop:Generator_RowEvArgName="ImportARP_tblRowChangeEvent" msprop:Generator_RowEvHandlerName="ImportARP_tblRowChangeEventHandler" msprop:Generator_TablePropName="ImportARP_tbl" msprop:Generator_TableVarName="tableImportARP_tbl" msprop:Generator_RowDeletingName="ImportARP_tblRowDeleting">
<xs:complexType>
<xs:sequence>
<xs:element name="Document" msprop:Generator_UserColumnName="Document" msprop:Generator_ColumnPropNameInRow="Document" msprop:Generator_ColumnVarNameInTable="columnDocument" msprop:Generator_ColumnPropNameInTable="DocumentColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Alarm" msprop:Generator_UserColumnName="Alarm" msprop:Generator_ColumnPropNameInRow="Alarm" msprop:Generator_ColumnVarNameInTable="columnAlarm" msprop:Generator_ColumnPropNameInTable="AlarmColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PointName" msprop:Generator_UserColumnName="PointName" msprop:Generator_ColumnPropNameInRow="PointName" msprop:Generator_ColumnVarNameInTable="columnPointName" msprop:Generator_ColumnPropNameInTable="PointNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Value" msprop:Generator_UserColumnName="Value" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInTable="ValueColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SystemID" msprop:Generator_UserColumnName="SystemID" msprop:Generator_ColumnPropNameInRow="SystemID" msprop:Generator_ColumnVarNameInTable="columnSystemID" msprop:Generator_ColumnPropNameInTable="SystemIDColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SysTitle" msprop:Generator_UserColumnName="SysTitle" msprop:Generator_ColumnPropNameInRow="SysTitle" msprop:Generator_ColumnVarNameInTable="columnSysTitle" msprop:Generator_ColumnPropNameInTable="SysTitleColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ImportMEL_qry" msprop:Generator_UserTableName="ImportMEL_qry" msprop:Generator_RowDeletedName="ImportMEL_qryRowDeleted" msprop:Generator_TableClassName="ImportMEL_qryDataTable" msprop:Generator_RowChangedName="ImportMEL_qryRowChanged" msprop:Generator_RowClassName="ImportMEL_qryRow" msprop:Generator_RowChangingName="ImportMEL_qryRowChanging" msprop:Generator_RowEvArgName="ImportMEL_qryRowChangeEvent" msprop:Generator_RowEvHandlerName="ImportMEL_qryRowChangeEventHandler" msprop:Generator_TablePropName="ImportMEL_qry" msprop:Generator_TableVarName="tableImportMEL_qry" msprop:Generator_RowDeletingName="ImportMEL_qryRowDeleting">
<xs:complexType>
<xs:sequence>
<xs:element name="SystemID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SystemID" msprop:Generator_ColumnPropNameInRow="SystemID" msprop:Generator_ColumnVarNameInTable="columnSystemID" msprop:Generator_ColumnPropNameInTable="SystemIDColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SystemDesc" msprop:Generator_UserColumnName="SystemDesc" msprop:Generator_ColumnPropNameInRow="SystemDesc" msprop:Generator_ColumnVarNameInTable="columnSystemDesc" msprop:Generator_ColumnPropNameInTable="SystemDescColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ComponentID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ComponentID" msprop:Generator_ColumnPropNameInRow="ComponentID" msprop:Generator_ColumnVarNameInTable="columnComponentID" msprop:Generator_ColumnPropNameInTable="ComponentIDColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CompDesc" msprop:Generator_UserColumnName="CompDesc" msprop:Generator_ColumnPropNameInRow="CompDesc" msprop:Generator_ColumnVarNameInTable="columnCompDesc" msprop:Generator_ColumnPropNameInTable="CompDescColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FullName" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ShortName" msprop:Generator_UserColumnName="ShortName" msprop:Generator_ColumnPropNameInRow="ShortName" msprop:Generator_ColumnVarNameInTable="columnShortName" msprop:Generator_ColumnPropNameInTable="ShortNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Room" msprop:Generator_UserColumnName="Room" msprop:Generator_ColumnPropNameInRow="Room" msprop:Generator_ColumnVarNameInTable="columnRoom" msprop:Generator_ColumnPropNameInTable="RoomColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CommonDesc" msprop:Generator_UserColumnName="CommonDesc" msprop:Generator_ColumnPropNameInRow="CommonDesc" msprop:Generator_ColumnVarNameInTable="columnCommonDesc" msprop:Generator_ColumnPropNameInTable="CommonDescColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ImportSTP_qry" msprop:Generator_UserTableName="ImportSTP_qry" msprop:Generator_RowDeletedName="ImportSTP_qryRowDeleted" msprop:Generator_TableClassName="ImportSTP_qryDataTable" msprop:Generator_RowChangedName="ImportSTP_qryRowChanged" msprop:Generator_RowClassName="ImportSTP_qryRow" msprop:Generator_RowChangingName="ImportSTP_qryRowChanging" msprop:Generator_RowEvArgName="ImportSTP_qryRowChangeEvent" msprop:Generator_RowEvHandlerName="ImportSTP_qryRowChangeEventHandler" msprop:Generator_TablePropName="ImportSTP_qry" msprop:Generator_TableVarName="tableImportSTP_qry" msprop:Generator_RowDeletingName="ImportSTP_qryRowDeleting">
<xs:complexType>
<xs:sequence>
<xs:element name="Parameter" msprop:Generator_UserColumnName="Parameter" msprop:Generator_ColumnPropNameInRow="Parameter" msprop:Generator_ColumnVarNameInTable="columnParameter" msprop:Generator_ColumnPropNameInTable="ParameterColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Value" msprop:Generator_UserColumnName="Value" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInTable="ValueColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>