126 lines
12 KiB
XML
126 lines
12 KiB
XML
|
<?xml version="1.0" encoding="utf-8"?>
|
|||
|
|
<xs:schema id="deiniuWMSDataSet1" targetNamespace="http://tempuri.org/deiniuWMSDataSet11.xsd" xmlns:mstns="http://tempuri.org/deiniuWMSDataSet11.xsd" xmlns="http://tempuri.org/deiniuWMSDataSet11.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="deiniuWMSConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="deiniuWMSConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DeiNiu.wms.win.Properties.Settings.GlobalReference.Default.deiniuWMSConnectionString1" Provider="System.Data.SqlClient" />
|
|||
|
|
</Connections>
|
|||
|
|
<Tables>
|
|||
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_tmsPickRequestBulksTableAdapter" GeneratorDataComponentClassName="v_tmsPickRequestBulksTableAdapter" Name="v_tmsPickRequestBulks" UserDataComponentName="v_tmsPickRequestBulksTableAdapter">
|
|||
|
|
<MainSource>
|
|||
|
|
<DbSource ConnectionRef="deiniuWMSConnectionString1 (Settings)" DbObjectName="deiniuWMS.dbo.v_tmsPickRequestBulks" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|||
|
|
<SelectCommand>
|
|||
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|||
|
|
<CommandText>SELECT id, transNo, customerId, pickOrderNo, locationId, volType, count, state, customerName, custAddress, operater, phone1, lineName, lineOrder, bulkBag, bulkBox, bulkCnt, boxCnt FROM dbo.v_tmsPickRequestBulks</CommandText>
|
|||
|
|
<Parameters />
|
|||
|
|
</DbCommand>
|
|||
|
|
</SelectCommand>
|
|||
|
|
</DbSource>
|
|||
|
|
</MainSource>
|
|||
|
|
<Mappings>
|
|||
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|||
|
|
<Mapping SourceColumn="transNo" DataSetColumn="transNo" />
|
|||
|
|
<Mapping SourceColumn="customerId" DataSetColumn="customerId" />
|
|||
|
|
<Mapping SourceColumn="pickOrderNo" DataSetColumn="pickOrderNo" />
|
|||
|
|
<Mapping SourceColumn="locationId" DataSetColumn="locationId" />
|
|||
|
|
<Mapping SourceColumn="volType" DataSetColumn="volType" />
|
|||
|
|
<Mapping SourceColumn="count" DataSetColumn="count" />
|
|||
|
|
<Mapping SourceColumn="state" DataSetColumn="state" />
|
|||
|
|
<Mapping SourceColumn="customerName" DataSetColumn="customerName" />
|
|||
|
|
<Mapping SourceColumn="custAddress" DataSetColumn="custAddress" />
|
|||
|
|
<Mapping SourceColumn="operater" DataSetColumn="operater" />
|
|||
|
|
<Mapping SourceColumn="phone1" DataSetColumn="phone1" />
|
|||
|
|
<Mapping SourceColumn="lineName" DataSetColumn="lineName" />
|
|||
|
|
<Mapping SourceColumn="lineOrder" DataSetColumn="lineOrder" />
|
|||
|
|
<Mapping SourceColumn="bulkBag" DataSetColumn="bulkBag" />
|
|||
|
|
<Mapping SourceColumn="bulkBox" DataSetColumn="bulkBox" />
|
|||
|
|
<Mapping SourceColumn="bulkCnt" DataSetColumn="bulkCnt" />
|
|||
|
|
<Mapping SourceColumn="boxCnt" DataSetColumn="boxCnt" />
|
|||
|
|
</Mappings>
|
|||
|
|
<Sources />
|
|||
|
|
</TableAdapter>
|
|||
|
|
</Tables>
|
|||
|
|
<Sources />
|
|||
|
|
</DataSource>
|
|||
|
|
</xs:appinfo>
|
|||
|
|
</xs:annotation>
|
|||
|
|
<xs:element name="deiniuWMSDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="deiniuWMSDataSet1" msprop:Generator_UserDSName="deiniuWMSDataSet1">
|
|||
|
|
<xs:complexType>
|
|||
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|||
|
|
<xs:element name="v_tmsPickRequestBulks" msprop:Generator_TableClassName="v_tmsPickRequestBulksDataTable" msprop:Generator_TableVarName="tablev_tmsPickRequestBulks" msprop:Generator_TablePropName="v_tmsPickRequestBulks" msprop:Generator_RowDeletingName="v_tmsPickRequestBulksRowDeleting" msprop:Generator_RowChangingName="v_tmsPickRequestBulksRowChanging" msprop:Generator_RowEvHandlerName="v_tmsPickRequestBulksRowChangeEventHandler" msprop:Generator_RowDeletedName="v_tmsPickRequestBulksRowDeleted" msprop:Generator_UserTableName="v_tmsPickRequestBulks" msprop:Generator_RowChangedName="v_tmsPickRequestBulksRowChanged" msprop:Generator_RowEvArgName="v_tmsPickRequestBulksRowChangeEvent" msprop:Generator_RowClassName="v_tmsPickRequestBulksRow">
|
|||
|
|
<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:int" />
|
|||
|
|
<xs:element name="transNo" msprop:Generator_ColumnVarNameInTable="columntransNo" msprop:Generator_ColumnPropNameInRow="transNo" msprop:Generator_ColumnPropNameInTable="transNoColumn" msprop:Generator_UserColumnName="transNo" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="customerId" msprop:Generator_ColumnVarNameInTable="columncustomerId" msprop:Generator_ColumnPropNameInRow="customerId" msprop:Generator_ColumnPropNameInTable="customerIdColumn" msprop:Generator_UserColumnName="customerId" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="pickOrderNo" msprop:Generator_ColumnVarNameInTable="columnpickOrderNo" msprop:Generator_ColumnPropNameInRow="pickOrderNo" msprop:Generator_ColumnPropNameInTable="pickOrderNoColumn" msprop:Generator_UserColumnName="pickOrderNo">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="locationId" msprop:Generator_ColumnVarNameInTable="columnlocationId" msprop:Generator_ColumnPropNameInRow="locationId" msprop:Generator_ColumnPropNameInTable="locationIdColumn" msprop:Generator_UserColumnName="locationId">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="volType" msprop:Generator_ColumnVarNameInTable="columnvolType" msprop:Generator_ColumnPropNameInRow="volType" msprop:Generator_ColumnPropNameInTable="volTypeColumn" msprop:Generator_UserColumnName="volType" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="count" msprop:Generator_ColumnVarNameInTable="columncount" msprop:Generator_ColumnPropNameInRow="count" msprop:Generator_ColumnPropNameInTable="countColumn" msprop:Generator_UserColumnName="count" type="xs:int" />
|
|||
|
|
<xs:element name="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:Generator_UserColumnName="state" type="xs:int" />
|
|||
|
|
<xs:element name="customerName" msprop:Generator_ColumnVarNameInTable="columncustomerName" msprop:Generator_ColumnPropNameInRow="customerName" msprop:Generator_ColumnPropNameInTable="customerNameColumn" msprop:Generator_UserColumnName="customerName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="custAddress" msprop:Generator_ColumnVarNameInTable="columncustAddress" msprop:Generator_ColumnPropNameInRow="custAddress" msprop:Generator_ColumnPropNameInTable="custAddressColumn" msprop:Generator_UserColumnName="custAddress" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="operater" msprop:Generator_ColumnVarNameInTable="columnoperater" msprop:Generator_ColumnPropNameInRow="operater" msprop:Generator_ColumnPropNameInTable="operaterColumn" msprop:Generator_UserColumnName="operater" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="phone1" msprop:Generator_ColumnVarNameInTable="columnphone1" msprop:Generator_ColumnPropNameInRow="phone1" msprop:Generator_ColumnPropNameInTable="phone1Column" msprop:Generator_UserColumnName="phone1" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="200" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="lineName" msprop:Generator_ColumnVarNameInTable="columnlineName" msprop:Generator_ColumnPropNameInRow="lineName" msprop:Generator_ColumnPropNameInTable="lineNameColumn" msprop:Generator_UserColumnName="lineName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="lineOrder" msprop:Generator_ColumnVarNameInTable="columnlineOrder" msprop:Generator_ColumnPropNameInRow="lineOrder" msprop:Generator_ColumnPropNameInTable="lineOrderColumn" msprop:Generator_UserColumnName="lineOrder" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkBag" msprop:Generator_ColumnVarNameInTable="columnbulkBag" msprop:Generator_ColumnPropNameInRow="bulkBag" msprop:Generator_ColumnPropNameInTable="bulkBagColumn" msprop:Generator_UserColumnName="bulkBag" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkBox" msprop:Generator_ColumnVarNameInTable="columnbulkBox" msprop:Generator_ColumnPropNameInRow="bulkBox" msprop:Generator_ColumnPropNameInTable="bulkBoxColumn" msprop:Generator_UserColumnName="bulkBox" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkCnt" msprop:Generator_ColumnVarNameInTable="columnbulkCnt" msprop:Generator_ColumnPropNameInRow="bulkCnt" msprop:Generator_ColumnPropNameInTable="bulkCntColumn" msprop:Generator_UserColumnName="bulkCnt" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="boxCnt" msprop:Generator_ColumnVarNameInTable="columnboxCnt" msprop:Generator_ColumnPropNameInRow="boxCnt" msprop:Generator_ColumnPropNameInTable="boxCntColumn" msprop:Generator_UserColumnName="boxCnt" type="xs:int" minOccurs="0" />
|
|||
|
|
</xs:sequence>
|
|||
|
|
</xs:complexType>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:choice>
|
|||
|
|
</xs:complexType>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:schema>
|