320 lines
70 KiB
XML
320 lines
70 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.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="deiniuWMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="deiniuWMSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DeiNiu.wms.win.Properties.Settings.GlobalReference.Default.deiniuWMSConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="t_wmsLocationTableAdapter" GeneratorDataComponentClassName="t_wmsLocationTableAdapter" Name="t_wmsLocation" UserDataComponentName="t_wmsLocationTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="deiniuWMSConnectionString (Settings)" DbObjectName="deiniuWMS.dbo.t_wmsLocation" 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">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [t_wmsLocation] WHERE (([id] = @Original_id) AND ([locationId] = @Original_locationId) AND ((@IsNull_locationId128 = 1 AND [locationId128] IS NULL) OR ([locationId128] = @Original_locationId128)) AND ((@IsNull_warehouse = 1 AND [warehouse] IS NULL) OR ([warehouse] = @Original_warehouse)) AND ((@IsNull_channel = 1 AND [channel] IS NULL) OR ([channel] = @Original_channel)) AND ((@IsNull_shelf = 1 AND [shelf] IS NULL) OR ([shelf] = @Original_shelf)) AND ((@IsNull_layer = 1 AND [layer] IS NULL) OR ([layer] = @Original_layer)) AND ((@IsNull_col = 1 AND [col] IS NULL) OR ([col] = @Original_col)) AND ((@IsNull_elabId = 1 AND [elabId] IS NULL) OR ([elabId] = @Original_elabId)) AND ((@IsNull_elabAddress = 1 AND [elabAddress] IS NULL) OR ([elabAddress] = @Original_elabAddress)) AND ((@IsNull_height = 1 AND [height] IS NULL) OR ([height] = @Original_height)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_weight = 1 AND [weight] IS NULL) OR ([weight] = @Original_weight)) AND ((@IsNull_port = 1 AND [port] IS NULL) OR ([port] = @Original_port)) AND ((@IsNull_part = 1 AND [part] IS NULL) OR ([part] = @Original_part)) AND ((@IsNull_bigPart = 1 AND [bigPart] IS NULL) OR ([bigPart] = @Original_bigPart)) AND ((@IsNull_goodsType = 1 AND [goodsType] IS NULL) OR ([goodsType] = @Original_goodsType)) AND ((@IsNull_whType = 1 AND [whType] IS NULL) OR ([whType] = @Original_whType)) AND ((@IsNull_whGoodsType = 1 AND [whGoodsType] IS NULL) OR ([whGoodsType] = @Original_whGoodsType)) AND ((@IsNull_whVolType = 1 AND [whVolType] IS NULL) OR ([whVolType] = @Original_whVolType)) AND ((@IsNull_volType = 1 AND [volType] IS NULL) OR ([volType] = @Original_volType)) AND ((@IsNull_state = 1 AND [state] IS NULL) OR ([state] = @Original_state)) AND ((@IsNull_tranState = 1 AND [tranState] IS NULL) OR ([tranState] = @Original_tranState)) AND ((@IsNull_transLine = 1 AND [transLine] IS NULL) OR ([transLine] = @Original_transLine)) AND ((@IsNull_operater = 1 AND [operater] IS NULL) OR ([operater] = @Original_operater)) AND ((@IsNull_lastmodified = 1 AND [lastmodified] IS NULL) OR ([lastmodified] = @Original_lastmodified)) AND ((@IsNull_createtime = 1 AND [createtime] IS NULL) OR ([createtime] = @Original_createtime)) AND ((@IsNull_dr = 1 AND [dr] IS NULL) OR ([dr] = @Original_dr)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_locationId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_locationId128" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="locationId128" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_locationId128" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId128" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_warehouse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="warehouse" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_warehouse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="warehouse" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_channel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_channel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_shelf" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shelf" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_shelf" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shelf" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_layer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="layer" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_layer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="layer" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_col" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_col" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_elabId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabId" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_elabId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_elabAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_elabAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="height" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_height" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="height" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="width" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_width" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="width" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="length" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_length" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="length" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="weight" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_weight" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_port" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="port" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_port" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="port" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_part" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bigPart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bigPart" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_bigPart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bigPart" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_goodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="goodsType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_goodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="goodsType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_whType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_whType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_whGoodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whGoodsType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_whGoodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whGoodsType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_whVolType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whVolType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_whVolType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whVolType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_volType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="volType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_volType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="volType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_state" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tranState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tranState" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tranState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tranState" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_transLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="transLine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_transLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="transLine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="operater" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="operater" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lastmodified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lastmodified" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_lastmodified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="lastmodified" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_createtime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="createtime" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_createtime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="createtime" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dr" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_dr" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="dr" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [t_wmsLocation] ([locationId], [locationId128], [warehouse], [channel], [shelf], [layer], [col], [elabId], [elabAddress], [height], [width], [length], [weight], [port], [part], [bigPart], [goodsType], [whType], [whGoodsType], [whVolType], [volType], [state], [tranState], [transLine], [operater], [lastmodified], [createtime], [dr]) VALUES (@locationId, @locationId128, @warehouse, @channel, @shelf, @layer, @col, @elabId, @elabAddress, @height, @width, @length, @weight, @port, @part, @bigPart, @goodsType, @whType, @whGoodsType, @whVolType, @volType, @state, @tranState, @transLine, @operater, @lastmodified, @createtime, @dr);
|
|
SELECT id, locationId, locationId128, warehouse, channel, shelf, layer, col, elabId, elabAddress, height, width, length, weight, port, part, bigPart, goodsType, whType, whGoodsType, whVolType, volType, state, tranState, transLine, operater, lastmodified, createtime, dr FROM t_wmsLocation WHERE (locationId = @locationId)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@locationId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@locationId128" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId128" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@warehouse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="warehouse" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@channel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@shelf" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shelf" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@layer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="layer" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@col" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@elabId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@elabAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@height" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="height" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@width" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="width" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@length" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="length" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@weight" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@port" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="port" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bigPart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bigPart" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@goodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="goodsType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@whType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@whGoodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whGoodsType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@whVolType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whVolType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@volType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="volType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@state" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tranState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tranState" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@transLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="transLine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="operater" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@lastmodified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="lastmodified" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@createtime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="createtime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@dr" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="dr" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT t_wmsLocation.*
|
|
FROM t_wmsLocation</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [t_wmsLocation] SET [locationId] = @locationId, [locationId128] = @locationId128, [warehouse] = @warehouse, [channel] = @channel, [shelf] = @shelf, [layer] = @layer, [col] = @col, [elabId] = @elabId, [elabAddress] = @elabAddress, [height] = @height, [width] = @width, [length] = @length, [weight] = @weight, [port] = @port, [part] = @part, [bigPart] = @bigPart, [goodsType] = @goodsType, [whType] = @whType, [whGoodsType] = @whGoodsType, [whVolType] = @whVolType, [volType] = @volType, [state] = @state, [tranState] = @tranState, [transLine] = @transLine, [operater] = @operater, [lastmodified] = @lastmodified, [createtime] = @createtime, [dr] = @dr WHERE (([id] = @Original_id) AND ([locationId] = @Original_locationId) AND ((@IsNull_locationId128 = 1 AND [locationId128] IS NULL) OR ([locationId128] = @Original_locationId128)) AND ((@IsNull_warehouse = 1 AND [warehouse] IS NULL) OR ([warehouse] = @Original_warehouse)) AND ((@IsNull_channel = 1 AND [channel] IS NULL) OR ([channel] = @Original_channel)) AND ((@IsNull_shelf = 1 AND [shelf] IS NULL) OR ([shelf] = @Original_shelf)) AND ((@IsNull_layer = 1 AND [layer] IS NULL) OR ([layer] = @Original_layer)) AND ((@IsNull_col = 1 AND [col] IS NULL) OR ([col] = @Original_col)) AND ((@IsNull_elabId = 1 AND [elabId] IS NULL) OR ([elabId] = @Original_elabId)) AND ((@IsNull_elabAddress = 1 AND [elabAddress] IS NULL) OR ([elabAddress] = @Original_elabAddress)) AND ((@IsNull_height = 1 AND [height] IS NULL) OR ([height] = @Original_height)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_weight = 1 AND [weight] IS NULL) OR ([weight] = @Original_weight)) AND ((@IsNull_port = 1 AND [port] IS NULL) OR ([port] = @Original_port)) AND ((@IsNull_part = 1 AND [part] IS NULL) OR ([part] = @Original_part)) AND ((@IsNull_bigPart = 1 AND [bigPart] IS NULL) OR ([bigPart] = @Original_bigPart)) AND ((@IsNull_goodsType = 1 AND [goodsType] IS NULL) OR ([goodsType] = @Original_goodsType)) AND ((@IsNull_whType = 1 AND [whType] IS NULL) OR ([whType] = @Original_whType)) AND ((@IsNull_whGoodsType = 1 AND [whGoodsType] IS NULL) OR ([whGoodsType] = @Original_whGoodsType)) AND ((@IsNull_whVolType = 1 AND [whVolType] IS NULL) OR ([whVolType] = @Original_whVolType)) AND ((@IsNull_volType = 1 AND [volType] IS NULL) OR ([volType] = @Original_volType)) AND ((@IsNull_state = 1 AND [state] IS NULL) OR ([state] = @Original_state)) AND ((@IsNull_tranState = 1 AND [tranState] IS NULL) OR ([tranState] = @Original_tranState)) AND ((@IsNull_transLine = 1 AND [transLine] IS NULL) OR ([transLine] = @Original_transLine)) AND ((@IsNull_operater = 1 AND [operater] IS NULL) OR ([operater] = @Original_operater)) AND ((@IsNull_lastmodified = 1 AND [lastmodified] IS NULL) OR ([lastmodified] = @Original_lastmodified)) AND ((@IsNull_createtime = 1 AND [createtime] IS NULL) OR ([createtime] = @Original_createtime)) AND ((@IsNull_dr = 1 AND [dr] IS NULL) OR ([dr] = @Original_dr)));
|
|
SELECT id, locationId, locationId128, warehouse, channel, shelf, layer, col, elabId, elabAddress, height, width, length, weight, port, part, bigPart, goodsType, whType, whGoodsType, whVolType, volType, state, tranState, transLine, operater, lastmodified, createtime, dr FROM t_wmsLocation WHERE (locationId = @locationId)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@locationId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@locationId128" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId128" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@warehouse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="warehouse" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@channel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@shelf" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shelf" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@layer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="layer" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@col" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@elabId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@elabAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@height" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="height" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@width" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="width" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@length" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="length" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@weight" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@port" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="port" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bigPart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bigPart" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@goodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="goodsType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@whType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@whGoodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whGoodsType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@whVolType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whVolType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@volType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="volType" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@state" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tranState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tranState" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@transLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="transLine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="operater" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@lastmodified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="lastmodified" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@createtime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="createtime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@dr" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="dr" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_locationId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_locationId128" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="locationId128" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_locationId128" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="locationId128" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_warehouse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="warehouse" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_warehouse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="warehouse" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_channel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_channel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_shelf" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shelf" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_shelf" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shelf" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_layer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="layer" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_layer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="layer" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_col" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_col" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_elabId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabId" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_elabId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_elabAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_elabAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elabAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="height" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_height" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="height" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="width" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_width" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="width" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="length" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_length" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="length" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="weight" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_weight" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_port" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="port" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_port" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="port" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_part" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bigPart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bigPart" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_bigPart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bigPart" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_goodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="goodsType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_goodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="goodsType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_whType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_whType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_whGoodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whGoodsType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_whGoodsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whGoodsType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_whVolType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whVolType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_whVolType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="whVolType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_volType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="volType" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_volType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="volType" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_state" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tranState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tranState" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tranState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tranState" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_transLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="transLine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_transLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="transLine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="operater" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="operater" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lastmodified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lastmodified" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_lastmodified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="lastmodified" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_createtime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="createtime" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_createtime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="createtime" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dr" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_dr" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="dr" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|
<Mapping SourceColumn="locationId" DataSetColumn="locationId" />
|
|
<Mapping SourceColumn="locationId128" DataSetColumn="locationId128" />
|
|
<Mapping SourceColumn="warehouse" DataSetColumn="warehouse" />
|
|
<Mapping SourceColumn="channel" DataSetColumn="channel" />
|
|
<Mapping SourceColumn="shelf" DataSetColumn="shelf" />
|
|
<Mapping SourceColumn="layer" DataSetColumn="layer" />
|
|
<Mapping SourceColumn="col" DataSetColumn="col" />
|
|
<Mapping SourceColumn="elabId" DataSetColumn="elabId" />
|
|
<Mapping SourceColumn="elabAddress" DataSetColumn="elabAddress" />
|
|
<Mapping SourceColumn="height" DataSetColumn="height" />
|
|
<Mapping SourceColumn="width" DataSetColumn="width" />
|
|
<Mapping SourceColumn="length" DataSetColumn="length" />
|
|
<Mapping SourceColumn="weight" DataSetColumn="weight" />
|
|
<Mapping SourceColumn="port" DataSetColumn="port" />
|
|
<Mapping SourceColumn="part" DataSetColumn="part" />
|
|
<Mapping SourceColumn="bigPart" DataSetColumn="bigPart" />
|
|
<Mapping SourceColumn="goodsType" DataSetColumn="goodsType" />
|
|
<Mapping SourceColumn="whType" DataSetColumn="whType" />
|
|
<Mapping SourceColumn="whGoodsType" DataSetColumn="whGoodsType" />
|
|
<Mapping SourceColumn="whVolType" DataSetColumn="whVolType" />
|
|
<Mapping SourceColumn="volType" DataSetColumn="volType" />
|
|
<Mapping SourceColumn="state" DataSetColumn="state" />
|
|
<Mapping SourceColumn="tranState" DataSetColumn="tranState" />
|
|
<Mapping SourceColumn="transLine" DataSetColumn="transLine" />
|
|
<Mapping SourceColumn="operater" DataSetColumn="operater" />
|
|
<Mapping SourceColumn="lastmodified" DataSetColumn="lastmodified" />
|
|
<Mapping SourceColumn="createtime" DataSetColumn="createtime" />
|
|
<Mapping SourceColumn="dr" DataSetColumn="dr" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="t_wmsLocation" msprop:Generator_TableClassName="t_wmsLocationDataTable" msprop:Generator_TableVarName="tablet_wmsLocation" msprop:Generator_TablePropName="t_wmsLocation" msprop:Generator_RowDeletingName="t_wmsLocationRowDeleting" msprop:Generator_RowChangingName="t_wmsLocationRowChanging" msprop:Generator_RowEvHandlerName="t_wmsLocationRowChangeEventHandler" msprop:Generator_RowDeletedName="t_wmsLocationRowDeleted" msprop:Generator_UserTableName="t_wmsLocation" msprop:Generator_RowChangedName="t_wmsLocationRowChanged" msprop:Generator_RowEvArgName="t_wmsLocationRowChangeEvent" msprop:Generator_RowClassName="t_wmsLocationRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
|
|
<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="locationId128" msprop:Generator_ColumnVarNameInTable="columnlocationId128" msprop:Generator_ColumnPropNameInRow="locationId128" msprop:Generator_ColumnPropNameInTable="locationId128Column" msprop:Generator_UserColumnName="locationId128" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="warehouse" msprop:Generator_ColumnVarNameInTable="columnwarehouse" msprop:Generator_ColumnPropNameInRow="warehouse" msprop:Generator_ColumnPropNameInTable="warehouseColumn" msprop:Generator_UserColumnName="warehouse" type="xs:int" minOccurs="0" />
|
|
<xs:element name="channel" msprop:Generator_ColumnVarNameInTable="columnchannel" msprop:Generator_ColumnPropNameInRow="channel" msprop:Generator_ColumnPropNameInTable="channelColumn" msprop:Generator_UserColumnName="channel" type="xs:int" minOccurs="0" />
|
|
<xs:element name="shelf" msprop:Generator_ColumnVarNameInTable="columnshelf" msprop:Generator_ColumnPropNameInRow="shelf" msprop:Generator_ColumnPropNameInTable="shelfColumn" msprop:Generator_UserColumnName="shelf" type="xs:int" minOccurs="0" />
|
|
<xs:element name="layer" msprop:Generator_ColumnVarNameInTable="columnlayer" msprop:Generator_ColumnPropNameInRow="layer" msprop:Generator_ColumnPropNameInTable="layerColumn" msprop:Generator_UserColumnName="layer" type="xs:int" minOccurs="0" />
|
|
<xs:element name="col" msprop:Generator_ColumnVarNameInTable="columncol" msprop:Generator_ColumnPropNameInRow="col" msprop:Generator_ColumnPropNameInTable="colColumn" msprop:Generator_UserColumnName="col" type="xs:int" minOccurs="0" />
|
|
<xs:element name="elabId" msprop:Generator_ColumnVarNameInTable="columnelabId" msprop:Generator_ColumnPropNameInRow="elabId" msprop:Generator_ColumnPropNameInTable="elabIdColumn" msprop:Generator_UserColumnName="elabId" type="xs:int" minOccurs="0" />
|
|
<xs:element name="elabAddress" msprop:Generator_ColumnVarNameInTable="columnelabAddress" msprop:Generator_ColumnPropNameInRow="elabAddress" msprop:Generator_ColumnPropNameInTable="elabAddressColumn" msprop:Generator_UserColumnName="elabAddress" type="xs:int" minOccurs="0" />
|
|
<xs:element name="height" msprop:Generator_ColumnVarNameInTable="columnheight" msprop:Generator_ColumnPropNameInRow="height" msprop:Generator_ColumnPropNameInTable="heightColumn" msprop:Generator_UserColumnName="height" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="width" msprop:Generator_ColumnVarNameInTable="columnwidth" msprop:Generator_ColumnPropNameInRow="width" msprop:Generator_ColumnPropNameInTable="widthColumn" msprop:Generator_UserColumnName="width" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="length" msprop:Generator_ColumnVarNameInTable="columnlength" msprop:Generator_ColumnPropNameInRow="length" msprop:Generator_ColumnPropNameInTable="lengthColumn" msprop:Generator_UserColumnName="length" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="weight" msprop:Generator_ColumnVarNameInTable="columnweight" msprop:Generator_ColumnPropNameInRow="weight" msprop:Generator_ColumnPropNameInTable="weightColumn" msprop:Generator_UserColumnName="weight" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="port" msprop:Generator_ColumnVarNameInTable="columnport" msprop:Generator_ColumnPropNameInRow="port" msprop:Generator_ColumnPropNameInTable="portColumn" msprop:Generator_UserColumnName="port" type="xs:int" minOccurs="0" />
|
|
<xs:element name="part" msprop:Generator_ColumnVarNameInTable="columnpart" msprop:Generator_ColumnPropNameInRow="part" msprop:Generator_ColumnPropNameInTable="partColumn" msprop:Generator_UserColumnName="part" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="bigPart" msprop:Generator_ColumnVarNameInTable="columnbigPart" msprop:Generator_ColumnPropNameInRow="bigPart" msprop:Generator_ColumnPropNameInTable="bigPartColumn" msprop:Generator_UserColumnName="bigPart" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="goodsType" msprop:Generator_ColumnVarNameInTable="columngoodsType" msprop:Generator_ColumnPropNameInRow="goodsType" msprop:Generator_ColumnPropNameInTable="goodsTypeColumn" msprop:Generator_UserColumnName="goodsType" type="xs:int" minOccurs="0" />
|
|
<xs:element name="whType" msprop:Generator_ColumnVarNameInTable="columnwhType" msprop:Generator_ColumnPropNameInRow="whType" msprop:Generator_ColumnPropNameInTable="whTypeColumn" msprop:Generator_UserColumnName="whType" type="xs:int" minOccurs="0" />
|
|
<xs:element name="whGoodsType" msprop:Generator_ColumnVarNameInTable="columnwhGoodsType" msprop:Generator_ColumnPropNameInRow="whGoodsType" msprop:Generator_ColumnPropNameInTable="whGoodsTypeColumn" msprop:Generator_UserColumnName="whGoodsType" type="xs:int" minOccurs="0" />
|
|
<xs:element name="whVolType" msprop:Generator_ColumnVarNameInTable="columnwhVolType" msprop:Generator_ColumnPropNameInRow="whVolType" msprop:Generator_ColumnPropNameInTable="whVolTypeColumn" msprop:Generator_UserColumnName="whVolType" type="xs:int" minOccurs="0" />
|
|
<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="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:Generator_UserColumnName="state" type="xs:int" minOccurs="0" />
|
|
<xs:element name="tranState" msprop:Generator_ColumnVarNameInTable="columntranState" msprop:Generator_ColumnPropNameInRow="tranState" msprop:Generator_ColumnPropNameInTable="tranStateColumn" msprop:Generator_UserColumnName="tranState" type="xs:int" minOccurs="0" />
|
|
<xs:element name="transLine" msprop:Generator_ColumnVarNameInTable="columntransLine" msprop:Generator_ColumnPropNameInRow="transLine" msprop:Generator_ColumnPropNameInTable="transLineColumn" msprop:Generator_UserColumnName="transLine" type="xs:int" minOccurs="0" />
|
|
<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="lastmodified" msprop:Generator_ColumnVarNameInTable="columnlastmodified" msprop:Generator_ColumnPropNameInRow="lastmodified" msprop:Generator_ColumnPropNameInTable="lastmodifiedColumn" msprop:Generator_UserColumnName="lastmodified" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="createtime" msprop:Generator_ColumnVarNameInTable="columncreatetime" msprop:Generator_ColumnPropNameInRow="createtime" msprop:Generator_ColumnPropNameInTable="createtimeColumn" msprop:Generator_UserColumnName="createtime" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="dr" msprop:Generator_ColumnVarNameInTable="columndr" msprop:Generator_ColumnPropNameInRow="dr" msprop:Generator_ColumnPropNameInTable="drColumn" msprop:Generator_UserColumnName="dr" type="xs:boolean" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:t_wmsLocation" />
|
|
<xs:field xpath="mstns:locationId" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |