<?xml version="1.0" encoding="utf-8"?>
|
<xs:schema id="WeightCollectDataSet1" targetNamespace="http://tempuri.org/WeightCollectDataSet1.xsd" xmlns:mstns="http://tempuri.org/WeightCollectDataSet1.xsd" xmlns="http://tempuri.org/WeightCollectDataSet1.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="WeightCollectConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="WeightCollectConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GSproduction.Properties.Settings.GlobalReference.Default.WeightCollectConnectionString" Provider="System.Data.SqlClient" />
|
</Connections>
|
<Tables>
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BGBarcodeTableAdapter" GeneratorDataComponentClassName="BGBarcodeTableAdapter" Name="BGBarcode" UserDataComponentName="BGBarcodeTableAdapter">
|
<MainSource>
|
<DbSource ConnectionRef="WeightCollectConnectionString (Settings)" DbObjectName="WeightCollect.dbo.BGBarcode" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
<InsertCommand>
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
<CommandText>INSERT INTO [dbo].[BGBarcode] ([ID], [UID], [BarcodeNO], [LinesName], [WorkNo], [Product], [CheckCategory1], [CheckCategory2], [CheckCategory3], [CheckCategory4], [CheckCategory5], [CheckCategory6], [CheckCategory7], [CheckCategory8], [CheckCategory9], [CheckCategory10]) VALUES (@ID, @UID, @BarcodeNO, @LinesName, @WorkNo, @Product, @CheckCategory1, @CheckCategory2, @CheckCategory3, @CheckCategory4, @CheckCategory5, @CheckCategory6, @CheckCategory7, @CheckCategory8, @CheckCategory9, @CheckCategory10)</CommandText>
|
<Parameters>
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ID" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@UID" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@BarcodeNO" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="BarcodeNO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LinesName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LinesName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WorkNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WorkNo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Product" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Product" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CheckCategory3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheckCategory3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CheckCategory5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheckCategory5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory6" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory7" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CheckCategory9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CheckCategory9" SourceColumnNullMapping="false" SourceVersion="Current" />
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CheckCategory10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheckCategory10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
</Parameters>
|
</DbCommand>
|
</InsertCommand>
|
<SelectCommand>
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
<CommandText>SELECT ID, UID, BarcodeNO, LinesName, WorkNo, Product, CheckCategory1, CheckCategory2, CheckCategory3, CheckCategory4, CheckCategory5, CheckCategory6, CheckCategory7, CheckCategory8, CheckCategory9, CheckCategory10 FROM dbo.BGBarcode</CommandText>
|
<Parameters />
|
</DbCommand>
|
</SelectCommand>
|
</DbSource>
|
</MainSource>
|
<Mappings>
|
<Mapping SourceColumn="ID" DataSetColumn="ID" />
|
<Mapping SourceColumn="UID" DataSetColumn="UID" />
|
<Mapping SourceColumn="BarcodeNO" DataSetColumn="BarcodeNO" />
|
<Mapping SourceColumn="LinesName" DataSetColumn="LinesName" />
|
<Mapping SourceColumn="WorkNo" DataSetColumn="WorkNo" />
|
<Mapping SourceColumn="Product" DataSetColumn="Product" />
|
<Mapping SourceColumn="CheckCategory1" DataSetColumn="CheckCategory1" />
|
<Mapping SourceColumn="CheckCategory2" DataSetColumn="CheckCategory2" />
|
<Mapping SourceColumn="CheckCategory3" DataSetColumn="CheckCategory3" />
|
<Mapping SourceColumn="CheckCategory4" DataSetColumn="CheckCategory4" />
|
<Mapping SourceColumn="CheckCategory5" DataSetColumn="CheckCategory5" />
|
<Mapping SourceColumn="CheckCategory6" DataSetColumn="CheckCategory6" />
|
<Mapping SourceColumn="CheckCategory7" DataSetColumn="CheckCategory7" />
|
<Mapping SourceColumn="CheckCategory8" DataSetColumn="CheckCategory8" />
|
<Mapping SourceColumn="CheckCategory9" DataSetColumn="CheckCategory9" />
|
<Mapping SourceColumn="CheckCategory10" DataSetColumn="CheckCategory10" />
|
</Mappings>
|
<Sources />
|
</TableAdapter>
|
</Tables>
|
<Sources />
|
</DataSource>
|
</xs:appinfo>
|
</xs:annotation>
|
<xs:element name="WeightCollectDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="WeightCollectDataSet1" msprop:Generator_UserDSName="WeightCollectDataSet1">
|
<xs:complexType>
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
<xs:element name="BGBarcode" msprop:Generator_TableClassName="BGBarcodeDataTable" msprop:Generator_TableVarName="tableBGBarcode" msprop:Generator_TablePropName="BGBarcode" msprop:Generator_RowDeletingName="BGBarcodeRowDeleting" msprop:Generator_RowChangingName="BGBarcodeRowChanging" msprop:Generator_RowEvHandlerName="BGBarcodeRowChangeEventHandler" msprop:Generator_RowDeletedName="BGBarcodeRowDeleted" msprop:Generator_UserTableName="BGBarcode" msprop:Generator_RowChangedName="BGBarcodeRowChanged" msprop:Generator_RowEvArgName="BGBarcodeRowChangeEvent" msprop:Generator_RowClassName="BGBarcodeRow">
|
<xs:complexType>
|
<xs:sequence>
|
<xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:decimal" />
|
<xs:element name="UID" msprop:Generator_ColumnVarNameInTable="columnUID" msprop:Generator_ColumnPropNameInRow="UID" msprop:Generator_ColumnPropNameInTable="UIDColumn" msprop:Generator_UserColumnName="UID" type="xs:decimal" minOccurs="0" />
|
<xs:element name="BarcodeNO" msprop:Generator_ColumnVarNameInTable="columnBarcodeNO" msprop:Generator_ColumnPropNameInRow="BarcodeNO" msprop:Generator_ColumnPropNameInTable="BarcodeNOColumn" msprop:Generator_UserColumnName="BarcodeNO" type="xs:decimal" minOccurs="0" />
|
<xs:element name="LinesName" msprop:Generator_ColumnVarNameInTable="columnLinesName" msprop:Generator_ColumnPropNameInRow="LinesName" msprop:Generator_ColumnPropNameInTable="LinesNameColumn" msprop:Generator_UserColumnName="LinesName" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="WorkNo" msprop:Generator_ColumnVarNameInTable="columnWorkNo" msprop:Generator_ColumnPropNameInRow="WorkNo" msprop:Generator_ColumnPropNameInTable="WorkNoColumn" msprop:Generator_UserColumnName="WorkNo" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="Product" msprop:Generator_ColumnVarNameInTable="columnProduct" msprop:Generator_ColumnPropNameInRow="Product" msprop:Generator_ColumnPropNameInTable="ProductColumn" msprop:Generator_UserColumnName="Product" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory1" msprop:Generator_ColumnVarNameInTable="columnCheckCategory1" msprop:Generator_ColumnPropNameInRow="CheckCategory1" msprop:Generator_ColumnPropNameInTable="CheckCategory1Column" msprop:Generator_UserColumnName="CheckCategory1" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory2" msprop:Generator_ColumnVarNameInTable="columnCheckCategory2" msprop:Generator_ColumnPropNameInRow="CheckCategory2" msprop:Generator_ColumnPropNameInTable="CheckCategory2Column" msprop:Generator_UserColumnName="CheckCategory2" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory3" msprop:Generator_ColumnVarNameInTable="columnCheckCategory3" msprop:Generator_ColumnPropNameInRow="CheckCategory3" msprop:Generator_ColumnPropNameInTable="CheckCategory3Column" msprop:Generator_UserColumnName="CheckCategory3" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory4" msprop:Generator_ColumnVarNameInTable="columnCheckCategory4" msprop:Generator_ColumnPropNameInRow="CheckCategory4" msprop:Generator_ColumnPropNameInTable="CheckCategory4Column" msprop:Generator_UserColumnName="CheckCategory4" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory5" msprop:Generator_ColumnVarNameInTable="columnCheckCategory5" msprop:Generator_ColumnPropNameInRow="CheckCategory5" msprop:Generator_ColumnPropNameInTable="CheckCategory5Column" msprop:Generator_UserColumnName="CheckCategory5" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory6" msprop:Generator_ColumnVarNameInTable="columnCheckCategory6" msprop:Generator_ColumnPropNameInRow="CheckCategory6" msprop:Generator_ColumnPropNameInTable="CheckCategory6Column" msprop:Generator_UserColumnName="CheckCategory6" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory7" msprop:Generator_ColumnVarNameInTable="columnCheckCategory7" msprop:Generator_ColumnPropNameInRow="CheckCategory7" msprop:Generator_ColumnPropNameInTable="CheckCategory7Column" msprop:Generator_UserColumnName="CheckCategory7" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory8" msprop:Generator_ColumnVarNameInTable="columnCheckCategory8" msprop:Generator_ColumnPropNameInRow="CheckCategory8" msprop:Generator_ColumnPropNameInTable="CheckCategory8Column" msprop:Generator_UserColumnName="CheckCategory8" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory9" msprop:Generator_ColumnVarNameInTable="columnCheckCategory9" msprop:Generator_ColumnPropNameInRow="CheckCategory9" msprop:Generator_ColumnPropNameInTable="CheckCategory9Column" msprop:Generator_UserColumnName="CheckCategory9" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
<xs:element name="CheckCategory10" msprop:Generator_ColumnVarNameInTable="columnCheckCategory10" msprop:Generator_ColumnPropNameInRow="CheckCategory10" msprop:Generator_ColumnPropNameInTable="CheckCategory10Column" msprop:Generator_UserColumnName="CheckCategory10" minOccurs="0">
|
<xs:simpleType>
|
<xs:restriction base="xs:string">
|
<xs:maxLength value="50" />
|
</xs:restriction>
|
</xs:simpleType>
|
</xs:element>
|
</xs:sequence>
|
</xs:complexType>
|
</xs:element>
|
</xs:choice>
|
</xs:complexType>
|
</xs:element>
|
</xs:schema>
|
