samuele
1f7b3ff79f
git-svn-id: https://keyhammer.ath.cx/svn/GMW/trunk@483 365432ac-a1b5-4ffd-bb28-6d3099d32164
1636 lines
191 KiB
XML
1636 lines
191 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="GMWDataSet" targetNamespace="http://tempuri.org/GMWDataSet.xsd" xmlns:mstns="http://tempuri.org/GMWDataSet.xsd" xmlns="http://tempuri.org/GMWDataSet.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" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GMWConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GMWConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GMW_Reports.Properties.Settings.GlobalReference.Default.GMWConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagArticoliTableAdapter" GeneratorDataComponentClassName="AnagArticoliTableAdapter" Name="AnagArticoli" UserDataComponentName="AnagArticoliTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagArticoli" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagArticoli] WHERE (([CodArticolo] = @Original_CodArticolo) AND ((@IsNull_DescrArticolo = 1 AND [DescrArticolo] IS NULL) OR ([DescrArticolo] = @Original_DescrArticolo)) AND ((@IsNull_Figura = 1 AND [Figura] IS NULL) OR ([Figura] = @Original_Figura)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrArticolo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrArticolo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Figura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Figura" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Figura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Figura" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagArticoli] ([CodArticolo], [DescrArticolo], [Figura]) VALUES (@CodArticolo, @DescrArticolo, @Figura);
|
|
SELECT CodArticolo, DescrArticolo, Figura FROM AnagArticoli WHERE (CodArticolo = @CodArticolo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Figura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Figura" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodArticolo, DescrArticolo, Figura FROM dbo.AnagArticoli</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagArticoli] SET [CodArticolo] = @CodArticolo, [DescrArticolo] = @DescrArticolo, [Figura] = @Figura WHERE (([CodArticolo] = @Original_CodArticolo) AND ((@IsNull_DescrArticolo = 1 AND [DescrArticolo] IS NULL) OR ([DescrArticolo] = @Original_DescrArticolo)) AND ((@IsNull_Figura = 1 AND [Figura] IS NULL) OR ([Figura] = @Original_Figura)));
|
|
SELECT CodArticolo, DescrArticolo, Figura FROM AnagArticoli WHERE (CodArticolo = @CodArticolo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Figura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Figura" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrArticolo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrArticolo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Figura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Figura" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Figura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Figura" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="DescrArticolo" DataSetColumn="DescrArticolo" />
|
|
<Mapping SourceColumn="Figura" DataSetColumn="Figura" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagBilanceTableAdapter" GeneratorDataComponentClassName="AnagBilanceTableAdapter" Name="AnagBilance" UserDataComponentName="AnagBilanceTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagBilance" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagBilance] WHERE (([CodBilancia] = @Original_CodBilancia) AND ((@IsNull_DescrImpianto = 1 AND [DescrImpianto] IS NULL) OR ([DescrImpianto] = @Original_DescrImpianto)) AND ((@IsNull_CodCompany = 1 AND [CodCompany] IS NULL) OR ([CodCompany] = @Original_CodCompany)) AND ((@IsNull_CodSito = 1 AND [CodSito] IS NULL) OR ([CodSito] = @Original_CodSito)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodBilancia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodBilancia" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrImpianto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodCompany" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodSito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagBilance] ([CodBilancia], [DescrImpianto], [CodCompany], [CodSito]) VALUES (@CodBilancia, @DescrImpianto, @CodCompany, @CodSito);
|
|
SELECT CodBilancia, DescrImpianto, CodCompany, CodSito FROM AnagBilance WHERE (CodBilancia = @CodBilancia)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodBilancia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodBilancia" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodBilancia, DescrImpianto, CodCompany, CodSito FROM dbo.AnagBilance</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagBilance] SET [CodBilancia] = @CodBilancia, [DescrImpianto] = @DescrImpianto, [CodCompany] = @CodCompany, [CodSito] = @CodSito WHERE (([CodBilancia] = @Original_CodBilancia) AND ((@IsNull_DescrImpianto = 1 AND [DescrImpianto] IS NULL) OR ([DescrImpianto] = @Original_DescrImpianto)) AND ((@IsNull_CodCompany = 1 AND [CodCompany] IS NULL) OR ([CodCompany] = @Original_CodCompany)) AND ((@IsNull_CodSito = 1 AND [CodSito] IS NULL) OR ([CodSito] = @Original_CodSito)));
|
|
SELECT CodBilancia, DescrImpianto, CodCompany, CodSito FROM AnagBilance WHERE (CodBilancia = @CodBilancia)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodBilancia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodBilancia" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodBilancia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodBilancia" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrImpianto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodCompany" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodSito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodBilancia" DataSetColumn="CodBilancia" />
|
|
<Mapping SourceColumn="DescrImpianto" DataSetColumn="DescrImpianto" />
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="CodSito" DataSetColumn="CodSito" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagCompanyTableAdapter" GeneratorDataComponentClassName="AnagCompanyTableAdapter" Name="AnagCompany" UserDataComponentName="AnagCompanyTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagCompany" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagCompany] WHERE (([CodCompany] = @Original_CodCompany) AND ((@IsNull_DescrCompany = 1 AND [DescrCompany] IS NULL) OR ([DescrCompany] = @Original_DescrCompany)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrCompany" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrCompany" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagCompany] ([CodCompany], [DescrCompany]) VALUES (@CodCompany, @DescrCompany);
|
|
SELECT CodCompany, DescrCompany FROM AnagCompany WHERE (CodCompany = @CodCompany)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodCompany, DescrCompany FROM dbo.AnagCompany</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagCompany] SET [CodCompany] = @CodCompany, [DescrCompany] = @DescrCompany WHERE (([CodCompany] = @Original_CodCompany) AND ((@IsNull_DescrCompany = 1 AND [DescrCompany] IS NULL) OR ([DescrCompany] = @Original_DescrCompany)));
|
|
SELECT CodCompany, DescrCompany FROM AnagCompany WHERE (CodCompany = @CodCompany)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrCompany" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrCompany" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="DescrCompany" DataSetColumn="DescrCompany" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagImpiantiTableAdapter" GeneratorDataComponentClassName="AnagImpiantiTableAdapter" Name="AnagImpianti" UserDataComponentName="AnagImpiantiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagImpianti" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagImpianti] WHERE (([CodImpianto] = @Original_CodImpianto) AND ((@IsNull_DescrImpianto = 1 AND [DescrImpianto] IS NULL) OR ([DescrImpianto] = @Original_DescrImpianto)) AND ((@IsNull_CodCompany = 1 AND [CodCompany] IS NULL) OR ([CodCompany] = @Original_CodCompany)) AND ((@IsNull_CodSito = 1 AND [CodSito] IS NULL) OR ([CodSito] = @Original_CodSito)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrImpianto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodCompany" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodSito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagImpianti] ([CodImpianto], [DescrImpianto], [CodCompany], [CodSito]) VALUES (@CodImpianto, @DescrImpianto, @CodCompany, @CodSito);
|
|
SELECT CodImpianto, DescrImpianto, CodCompany, CodSito FROM AnagImpianti WHERE (CodImpianto = @CodImpianto)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodImpianto, DescrImpianto, CodCompany, CodSito FROM dbo.AnagImpianti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagImpianti] SET [CodImpianto] = @CodImpianto, [DescrImpianto] = @DescrImpianto, [CodCompany] = @CodCompany, [CodSito] = @CodSito WHERE (([CodImpianto] = @Original_CodImpianto) AND ((@IsNull_DescrImpianto = 1 AND [DescrImpianto] IS NULL) OR ([DescrImpianto] = @Original_DescrImpianto)) AND ((@IsNull_CodCompany = 1 AND [CodCompany] IS NULL) OR ([CodCompany] = @Original_CodCompany)) AND ((@IsNull_CodSito = 1 AND [CodSito] IS NULL) OR ([CodSito] = @Original_CodSito)));
|
|
SELECT CodImpianto, DescrImpianto, CodCompany, CodSito FROM AnagImpianti WHERE (CodImpianto = @CodImpianto)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrImpianto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodCompany" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodSito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodImpianto" DataSetColumn="CodImpianto" />
|
|
<Mapping SourceColumn="DescrImpianto" DataSetColumn="DescrImpianto" />
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="CodSito" DataSetColumn="CodSito" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagOdpTableAdapter" GeneratorDataComponentClassName="AnagOdpTableAdapter" Name="AnagOdp" UserDataComponentName="AnagOdpTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagOdp" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagOdp] WHERE (([CodCompany] = @Original_CodCompany) AND ([ODP] = @Original_ODP) AND ([CodArticolo] = @Original_CodArticolo) AND ([CodDisegno] = @Original_CodDisegno) AND ([Esponente] = @Original_Esponente) AND ([Magazzino] = @Original_Magazzino) AND ([Ubicazione] = @Original_Ubicazione) AND ([CreateDate] = @Original_CreateDate) AND ([ModDate] = @Original_ModDate))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodDisegno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDisegno" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Esponente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Esponente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Magazzino" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Magazzino" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ubicazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ubicazione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagOdp] ([CodCompany], [ODP], [CodArticolo], [CodDisegno], [Esponente], [Magazzino], [Ubicazione], [CreateDate], [ModDate]) VALUES (@CodCompany, @ODP, @CodArticolo, @CodDisegno, @Esponente, @Magazzino, @Ubicazione, @CreateDate, @ModDate);
|
|
SELECT CodCompany, ODP, CodArticolo, CodDisegno, Esponente, Magazzino, Ubicazione, CreateDate, ModDate FROM AnagOdp WHERE (CodCompany = @CodCompany) AND (ODP = @ODP)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodDisegno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDisegno" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Esponente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Esponente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Magazzino" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Magazzino" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ubicazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ubicazione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodCompany, ODP, CodArticolo, CodDisegno, Esponente, Magazzino, Ubicazione, CreateDate, ModDate FROM dbo.AnagOdp</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagOdp] SET [CodCompany] = @CodCompany, [ODP] = @ODP, [CodArticolo] = @CodArticolo, [CodDisegno] = @CodDisegno, [Esponente] = @Esponente, [Magazzino] = @Magazzino, [Ubicazione] = @Ubicazione, [CreateDate] = @CreateDate, [ModDate] = @ModDate WHERE (([CodCompany] = @Original_CodCompany) AND ([ODP] = @Original_ODP) AND ([CodArticolo] = @Original_CodArticolo) AND ([CodDisegno] = @Original_CodDisegno) AND ([Esponente] = @Original_Esponente) AND ([Magazzino] = @Original_Magazzino) AND ([Ubicazione] = @Original_Ubicazione) AND ([CreateDate] = @Original_CreateDate) AND ([ModDate] = @Original_ModDate));
|
|
SELECT CodCompany, ODP, CodArticolo, CodDisegno, Esponente, Magazzino, Ubicazione, CreateDate, ModDate FROM AnagOdp WHERE (CodCompany = @CodCompany) AND (ODP = @ODP)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodDisegno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDisegno" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Esponente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Esponente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Magazzino" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Magazzino" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ubicazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ubicazione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodDisegno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDisegno" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Esponente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Esponente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Magazzino" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Magazzino" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ubicazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ubicazione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="ODP" DataSetColumn="ODP" />
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="CodDisegno" DataSetColumn="CodDisegno" />
|
|
<Mapping SourceColumn="Esponente" DataSetColumn="Esponente" />
|
|
<Mapping SourceColumn="Magazzino" DataSetColumn="Magazzino" />
|
|
<Mapping SourceColumn="Ubicazione" DataSetColumn="Ubicazione" />
|
|
<Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagSitiTableAdapter" GeneratorDataComponentClassName="AnagSitiTableAdapter" Name="AnagSiti" UserDataComponentName="AnagSitiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagSiti" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagSiti] WHERE (([CodCompany] = @Original_CodCompany) AND ([CodSito] = @Original_CodSito) AND ((@IsNull_DescrSito = 1 AND [DescrSito] IS NULL) OR ([DescrSito] = @Original_DescrSito)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrSito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrSito" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagSiti] ([CodCompany], [CodSito], [DescrSito]) VALUES (@CodCompany, @CodSito, @DescrSito);
|
|
SELECT CodCompany, CodSito, DescrSito FROM AnagSiti WHERE (CodCompany = @CodCompany) AND (CodSito = @CodSito)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodCompany, CodSito, DescrSito FROM dbo.AnagSiti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagSiti] SET [CodCompany] = @CodCompany, [CodSito] = @CodSito, [DescrSito] = @DescrSito WHERE (([CodCompany] = @Original_CodCompany) AND ([CodSito] = @Original_CodSito) AND ((@IsNull_DescrSito = 1 AND [DescrSito] IS NULL) OR ([DescrSito] = @Original_DescrSito)));
|
|
SELECT CodCompany, CodSito, DescrSito FROM AnagSiti WHERE (CodCompany = @CodCompany) AND (CodSito = @CodSito)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSito" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrSito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrSito" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrSito" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSito" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="CodSito" DataSetColumn="CodSito" />
|
|
<Mapping SourceColumn="DescrSito" DataSetColumn="DescrSito" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagStatiTableAdapter" GeneratorDataComponentClassName="AnagStatiTableAdapter" Name="AnagStati" UserDataComponentName="AnagStatiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagStati" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagStati] WHERE (([IdxStato] = @Original_IdxStato) AND ((@IsNull_DescrStato = 1 AND [DescrStato] IS NULL) OR ([DescrStato] = @Original_DescrStato)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagStati] ([IdxStato], [DescrStato]) VALUES (@IdxStato, @DescrStato);
|
|
SELECT IdxStato, DescrStato FROM AnagStati WHERE (IdxStato = @IdxStato)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT IdxStato, DescrStato FROM dbo.AnagStati</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagStati] SET [IdxStato] = @IdxStato, [DescrStato] = @DescrStato WHERE (([IdxStato] = @Original_IdxStato) AND ((@IsNull_DescrStato = 1 AND [DescrStato] IS NULL) OR ([DescrStato] = @Original_DescrStato)));
|
|
SELECT IdxStato, DescrStato FROM AnagStati WHERE (IdxStato = @IdxStato)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxStato" DataSetColumn="IdxStato" />
|
|
<Mapping SourceColumn="DescrStato" DataSetColumn="DescrStato" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContatoriUdcTableAdapter" GeneratorDataComponentClassName="ContatoriUdcTableAdapter" Name="ContatoriUdc" UserDataComponentName="ContatoriUdcTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.ContatoriUdc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[ContatoriUdc] WHERE (([CodCompany] = @Original_CodCompany) AND ([Flusso] = @Original_Flusso) AND ([Anno] = @Original_Anno) AND ((@IsNull_LastIdx = 1 AND [LastIdx] IS NULL) OR ([LastIdx] = @Original_LastIdx)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Flusso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Flusso" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Anno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastIdx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastIdx" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LastIdx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastIdx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[ContatoriUdc] ([CodCompany], [Flusso], [Anno], [LastIdx]) VALUES (@CodCompany, @Flusso, @Anno, @LastIdx);
|
|
SELECT CodCompany, Flusso, Anno, LastIdx FROM ContatoriUdc WHERE (Anno = @Anno) AND (CodCompany = @CodCompany) AND (Flusso = @Flusso)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Flusso" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Anno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LastIdx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastIdx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodCompany, Flusso, Anno, LastIdx FROM dbo.ContatoriUdc</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[ContatoriUdc] SET [CodCompany] = @CodCompany, [Flusso] = @Flusso, [Anno] = @Anno, [LastIdx] = @LastIdx WHERE (([CodCompany] = @Original_CodCompany) AND ([Flusso] = @Original_Flusso) AND ([Anno] = @Original_Anno) AND ((@IsNull_LastIdx = 1 AND [LastIdx] IS NULL) OR ([LastIdx] = @Original_LastIdx)));
|
|
SELECT CodCompany, Flusso, Anno, LastIdx FROM ContatoriUdc WHERE (Anno = @Anno) AND (CodCompany = @CodCompany) AND (Flusso = @Flusso)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Flusso" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Anno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LastIdx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastIdx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Flusso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Flusso" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Anno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastIdx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastIdx" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LastIdx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastIdx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="Flusso" DataSetColumn="Flusso" />
|
|
<Mapping SourceColumn="Anno" DataSetColumn="Anno" />
|
|
<Mapping SourceColumn="LastIdx" DataSetColumn="LastIdx" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Impianti2ArticoliTableAdapter" GeneratorDataComponentClassName="Impianti2ArticoliTableAdapter" Name="Impianti2Articoli" UserDataComponentName="Impianti2ArticoliTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.Impianti2Articoli" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[Impianti2Articoli] WHERE (([CodImpianto] = @Original_CodImpianto) AND ([CodArticolo] = @Original_CodArticolo) AND ([InizioProd] = @Original_InizioProd) AND ((@IsNull_FineProd = 1 AND [FineProd] IS NULL) OR ([FineProd] = @Original_FineProd)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_InizioProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InizioProd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FineProd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FineProd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FineProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FineProd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Impianti2Articoli] ([CodImpianto], [CodArticolo], [InizioProd], [FineProd]) VALUES (@CodImpianto, @CodArticolo, @InizioProd, @FineProd);
|
|
SELECT CodImpianto, CodArticolo, InizioProd, FineProd FROM Impianti2Articoli WHERE (CodArticolo = @CodArticolo) AND (CodImpianto = @CodImpianto) AND (InizioProd = @InizioProd)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InizioProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InizioProd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FineProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FineProd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodImpianto, CodArticolo, InizioProd, FineProd FROM dbo.Impianti2Articoli</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Impianti2Articoli] SET [CodImpianto] = @CodImpianto, [CodArticolo] = @CodArticolo, [InizioProd] = @InizioProd, [FineProd] = @FineProd WHERE (([CodImpianto] = @Original_CodImpianto) AND ([CodArticolo] = @Original_CodArticolo) AND ([InizioProd] = @Original_InizioProd) AND ((@IsNull_FineProd = 1 AND [FineProd] IS NULL) OR ([FineProd] = @Original_FineProd)));
|
|
SELECT CodImpianto, CodArticolo, InizioProd, FineProd FROM Impianti2Articoli WHERE (CodArticolo = @CodArticolo) AND (CodImpianto = @CodImpianto) AND (InizioProd = @InizioProd)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InizioProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InizioProd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FineProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FineProd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodImpianto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImpianto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_InizioProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InizioProd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FineProd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FineProd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FineProd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FineProd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodImpianto" DataSetColumn="CodImpianto" />
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="InizioProd" DataSetColumn="InizioProd" />
|
|
<Mapping SourceColumn="FineProd" DataSetColumn="FineProd" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TabStatoOdpUdcTableAdapter" GeneratorDataComponentClassName="TabStatoOdpUdcTableAdapter" Name="TabStatoOdpUdc" UserDataComponentName="TabStatoOdpUdcTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.TabStatoOdpUdc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[TabStatoOdpUdc] WHERE (([CodCompany] = @Original_CodCompany) AND ([ODP] = @Original_ODP) AND ([UDC] = @Original_UDC) AND ((@IsNull_Tara = 1 AND [Tara] IS NULL) OR ([Tara] = @Original_Tara)) AND ((@IsNull_IdxStato = 1 AND [IdxStato] IS NULL) OR ([IdxStato] = @Original_IdxStato)) AND ((@IsNull_Qta = 1 AND [Qta] IS NULL) OR ([Qta] = @Original_Qta)) AND ((@IsNull_CodImballo = 1 AND [CodImballo] IS NULL) OR ([CodImballo] = @Original_CodImballo)) AND ((@IsNull_CreateDate = 1 AND [CreateDate] IS NULL) OR ([CreateDate] = @Original_CreateDate)) AND ((@IsNull_ModDate = 1 AND [ModDate] IS NULL) OR ([ModDate] = @Original_ModDate)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tara" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Tara" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tara" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Qta" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodImballo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodImballo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodImballo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImballo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreateDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[TabStatoOdpUdc] ([CodCompany], [ODP], [UDC], [Tara], [IdxStato], [Qta], [CodImballo], [CreateDate], [ModDate]) VALUES (@CodCompany, @ODP, @UDC, @Tara, @IdxStato, @Qta, @CodImballo, @CreateDate, @ModDate);
|
|
SELECT CodCompany, ODP, UDC, Tara, IdxStato, Qta, CodImballo, CreateDate, ModDate FROM TabStatoOdpUdc WHERE (CodCompany = @CodCompany) AND (ODP = @ODP) AND (UDC = @UDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Tara" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tara" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Qta" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodImballo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImballo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodCompany, ODP, UDC, Tara, IdxStato, Qta, CodImballo, CreateDate, ModDate FROM dbo.TabStatoOdpUdc</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[TabStatoOdpUdc] SET [CodCompany] = @CodCompany, [ODP] = @ODP, [UDC] = @UDC, [Tara] = @Tara, [IdxStato] = @IdxStato, [Qta] = @Qta, [CodImballo] = @CodImballo, [CreateDate] = @CreateDate, [ModDate] = @ModDate WHERE (([CodCompany] = @Original_CodCompany) AND ([ODP] = @Original_ODP) AND ([UDC] = @Original_UDC) AND ((@IsNull_Tara = 1 AND [Tara] IS NULL) OR ([Tara] = @Original_Tara)) AND ((@IsNull_IdxStato = 1 AND [IdxStato] IS NULL) OR ([IdxStato] = @Original_IdxStato)) AND ((@IsNull_Qta = 1 AND [Qta] IS NULL) OR ([Qta] = @Original_Qta)) AND ((@IsNull_CodImballo = 1 AND [CodImballo] IS NULL) OR ([CodImballo] = @Original_CodImballo)) AND ((@IsNull_CreateDate = 1 AND [CreateDate] IS NULL) OR ([CreateDate] = @Original_CreateDate)) AND ((@IsNull_ModDate = 1 AND [ModDate] IS NULL) OR ([ModDate] = @Original_ModDate)));
|
|
SELECT CodCompany, ODP, UDC, Tara, IdxStato, Qta, CodImballo, CreateDate, ModDate FROM TabStatoOdpUdc WHERE (CodCompany = @CodCompany) AND (ODP = @ODP) AND (UDC = @UDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Tara" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tara" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Qta" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodImballo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImballo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCompany" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ODP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODP" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tara" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Tara" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tara" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Qta" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodImballo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodImballo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodImballo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodImballo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreateDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="ODP" DataSetColumn="ODP" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
|
|
<Mapping SourceColumn="IdxStato" DataSetColumn="IdxStato" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="CodImballo" DataSetColumn="CodImballo" />
|
|
<Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_getStatoByUdcTableAdapter" GeneratorDataComponentClassName="stp_getStatoByUdcTableAdapter" Name="stp_getStatoByUdc" UserDataComponentName="stp_getStatoByUdcTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_getStatoByUdc" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_getStatoByUdc</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="ODP" DataSetColumn="ODP" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
|
|
<Mapping SourceColumn="IdxStato" DataSetColumn="IdxStato" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="CodImballo" DataSetColumn="CodImballo" />
|
|
<Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_insNewOdpUdcTableAdapter" GeneratorDataComponentClassName="stp_insNewOdpUdcTableAdapter" Name="stp_insNewOdpUdc" UserDataComponentName="stp_insNewOdpUdcTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_insNewOdpUdc" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_insNewOdpUdc</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="VarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodSito" Precision="0" ProviderType="VarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Anno" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ODP" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@Tara" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="ODP" DataSetColumn="ODP" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
|
|
<Mapping SourceColumn="IdxStato" DataSetColumn="IdxStato" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="CodImballo" DataSetColumn="CodImballo" />
|
|
<Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_updateByBilanciaTableAdapter" GeneratorDataComponentClassName="stp_updateByBilanciaTableAdapter" Name="stp_updateByBilancia" UserDataComponentName="stp_updateByBilanciaTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_updateByBilancia" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_updateByBilancia</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="VarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@qta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCompany" DataSetColumn="CodCompany" />
|
|
<Mapping SourceColumn="ODP" DataSetColumn="ODP" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
|
|
<Mapping SourceColumn="IdxStato" DataSetColumn="IdxStato" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="CodImballo" DataSetColumn="CodImballo" />
|
|
<Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prtCartByUDCTableAdapter" GeneratorDataComponentClassName="stp_prtCartByUDCTableAdapter" Name="stp_prtCartByUDC" UserDataComponentName="stp_prtCartByUDCTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_prtCartByUDC" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_prtCartByUDC</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="CodCS" DataSetColumn="CodCS" />
|
|
<Mapping SourceColumn="codcliente" DataSetColumn="codcliente" />
|
|
<Mapping SourceColumn="ragsociale" DataSetColumn="ragsociale" />
|
|
<Mapping SourceColumn="particolare" DataSetColumn="particolare" />
|
|
<Mapping SourceColumn="descparticolare" DataSetColumn="descparticolare" />
|
|
<Mapping SourceColumn="disegnogrezzo" DataSetColumn="disegnogrezzo" />
|
|
<Mapping SourceColumn="esponente" DataSetColumn="esponente" />
|
|
<Mapping SourceColumn="codimpianto" DataSetColumn="codimpianto" />
|
|
<Mapping SourceColumn="descimpianto" DataSetColumn="descimpianto" />
|
|
<Mapping SourceColumn="codstampo" DataSetColumn="codstampo" />
|
|
<Mapping SourceColumn="figura" DataSetColumn="figura" />
|
|
<Mapping SourceColumn="datafus" DataSetColumn="datafus" />
|
|
<Mapping SourceColumn="turnofus" DataSetColumn="turnofus" />
|
|
<Mapping SourceColumn="codimballo" DataSetColumn="codimballo" />
|
|
<Mapping SourceColumn="codsoggetto" DataSetColumn="codsoggetto" />
|
|
<Mapping SourceColumn="numcont" DataSetColumn="numcont" />
|
|
<Mapping SourceColumn="tara" DataSetColumn="tara" />
|
|
<Mapping SourceColumn="qta" DataSetColumn="qta" />
|
|
<Mapping SourceColumn="codstato" DataSetColumn="codstato" />
|
|
<Mapping SourceColumn="idxposizione" DataSetColumn="idxposizione" />
|
|
<Mapping SourceColumn="pesotot" DataSetColumn="pesotot" />
|
|
<Mapping SourceColumn="pesocad" DataSetColumn="pesocad" />
|
|
<Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
<Mapping SourceColumn="cognome" DataSetColumn="cognome" />
|
|
<Mapping SourceColumn="nome" DataSetColumn="nome" />
|
|
<Mapping SourceColumn="descstato" DataSetColumn="descstato" />
|
|
<Mapping SourceColumn="descimballo" DataSetColumn="descimballo" />
|
|
<Mapping SourceColumn="CodFamiglia" DataSetColumn="CodFamiglia" />
|
|
<Mapping SourceColumn="DescFamiglia" DataSetColumn="DescFamiglia" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prtCartMatPrimaByUDCTableAdapter" GeneratorDataComponentClassName="stp_prtCartMatPrimaByUDCTableAdapter" Name="stp_prtCartMatPrimaByUDC" UserDataComponentName="stp_prtCartMatPrimaByUDCTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_prtCartMatPrimaByUDC" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_prtCartMatPrimaByUDC</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="nRapQual" DataSetColumn="nRapQual" />
|
|
<Mapping SourceColumn="DataRapQual" DataSetColumn="DataRapQual" />
|
|
<Mapping SourceColumn="ProgUDC" DataSetColumn="ProgUDC" />
|
|
<Mapping SourceColumn="CodFor" DataSetColumn="CodFor" />
|
|
<Mapping SourceColumn="DestTerz" DataSetColumn="DestTerz" />
|
|
<Mapping SourceColumn="CodLega" DataSetColumn="CodLega" />
|
|
<Mapping SourceColumn="DataPrelFus" DataSetColumn="DataPrelFus" />
|
|
<Mapping SourceColumn="TurnoPrelFus" DataSetColumn="TurnoPrelFus" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="DestLega" DataSetColumn="DestLega" />
|
|
<Mapping SourceColumn="LegaScaric" DataSetColumn="LegaScaric" />
|
|
<Mapping SourceColumn="BenesQual" DataSetColumn="BenesQual" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="DescFornitore" DataSetColumn="DescFornitore" />
|
|
<Mapping SourceColumn="DescFornitore2" DataSetColumn="DescFornitore2" />
|
|
<Mapping SourceColumn="CodLega2" DataSetColumn="CodLega2" />
|
|
<Mapping SourceColumn="DescLega" DataSetColumn="DescLega" />
|
|
<Mapping SourceColumn="DescLega2" DataSetColumn="DescLega2" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.f_padLeft" DbObjectType="Function" GenerateShortCommands="true" GeneratorSourceName="f_padLeft" MethodsParameterType="CLR" Modifier="Public" Name="f_padLeft" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="f_padLeft">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.f_padLeft</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@string" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@desired_length" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@pad_character" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.staccaNewIdx" DbObjectType="Function" GenerateShortCommands="true" GeneratorSourceName="staccaNewIdx" MethodsParameterType="CLR" Modifier="Public" Name="staccaNewIdx" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="staccaNewIdx">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.staccaNewIdx</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodCompany" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Anno" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="GMWDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="GMWDataSet" msprop:Generator_DataSetName="GMWDataSet" msprop:EnableTableAdapterManager="True">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="AnagArticoli" msprop:Generator_UserTableName="AnagArticoli" msprop:Generator_RowDeletedName="AnagArticoliRowDeleted" msprop:Generator_RowChangedName="AnagArticoliRowChanged" msprop:Generator_RowClassName="AnagArticoliRow" msprop:Generator_RowChangingName="AnagArticoliRowChanging" msprop:Generator_RowEvArgName="AnagArticoliRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagArticoliRowChangeEventHandler" msprop:Generator_TableClassName="AnagArticoliDataTable" msprop:Generator_TableVarName="tableAnagArticoli" msprop:Generator_RowDeletingName="AnagArticoliRowDeleting" msprop:Generator_TablePropName="AnagArticoli">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodArticolo" msprop:Generator_UserColumnName="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrArticolo" msprop:Generator_UserColumnName="DescrArticolo" msprop:Generator_ColumnVarNameInTable="columnDescrArticolo" msprop:Generator_ColumnPropNameInRow="DescrArticolo" msprop:Generator_ColumnPropNameInTable="DescrArticoloColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Figura" msprop:Generator_UserColumnName="Figura" msprop:Generator_ColumnVarNameInTable="columnFigura" msprop:Generator_ColumnPropNameInRow="Figura" msprop:Generator_ColumnPropNameInTable="FiguraColumn" 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:element name="AnagBilance" msprop:Generator_UserTableName="AnagBilance" msprop:Generator_RowDeletedName="AnagBilanceRowDeleted" msprop:Generator_RowChangedName="AnagBilanceRowChanged" msprop:Generator_RowClassName="AnagBilanceRow" msprop:Generator_RowChangingName="AnagBilanceRowChanging" msprop:Generator_RowEvArgName="AnagBilanceRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagBilanceRowChangeEventHandler" msprop:Generator_TableClassName="AnagBilanceDataTable" msprop:Generator_TableVarName="tableAnagBilance" msprop:Generator_RowDeletingName="AnagBilanceRowDeleting" msprop:Generator_TablePropName="AnagBilance">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodBilancia" msprop:Generator_UserColumnName="CodBilancia" msprop:Generator_ColumnVarNameInTable="columnCodBilancia" msprop:Generator_ColumnPropNameInRow="CodBilancia" msprop:Generator_ColumnPropNameInTable="CodBilanciaColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrImpianto" msprop:Generator_UserColumnName="DescrImpianto" msprop:Generator_ColumnVarNameInTable="columnDescrImpianto" msprop:Generator_ColumnPropNameInRow="DescrImpianto" msprop:Generator_ColumnPropNameInTable="DescrImpiantoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodSito" msprop:Generator_UserColumnName="CodSito" msprop:Generator_ColumnVarNameInTable="columnCodSito" msprop:Generator_ColumnPropNameInRow="CodSito" msprop:Generator_ColumnPropNameInTable="CodSitoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagCompany" msprop:Generator_UserTableName="AnagCompany" msprop:Generator_RowDeletedName="AnagCompanyRowDeleted" msprop:Generator_RowChangedName="AnagCompanyRowChanged" msprop:Generator_RowClassName="AnagCompanyRow" msprop:Generator_RowChangingName="AnagCompanyRowChanging" msprop:Generator_RowEvArgName="AnagCompanyRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagCompanyRowChangeEventHandler" msprop:Generator_TableClassName="AnagCompanyDataTable" msprop:Generator_TableVarName="tableAnagCompany" msprop:Generator_RowDeletingName="AnagCompanyRowDeleting" msprop:Generator_TablePropName="AnagCompany">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrCompany" msprop:Generator_UserColumnName="DescrCompany" msprop:Generator_ColumnVarNameInTable="columnDescrCompany" msprop:Generator_ColumnPropNameInRow="DescrCompany" msprop:Generator_ColumnPropNameInTable="DescrCompanyColumn" 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:element name="AnagImpianti" msprop:Generator_UserTableName="AnagImpianti" msprop:Generator_RowDeletedName="AnagImpiantiRowDeleted" msprop:Generator_RowChangedName="AnagImpiantiRowChanged" msprop:Generator_RowClassName="AnagImpiantiRow" msprop:Generator_RowChangingName="AnagImpiantiRowChanging" msprop:Generator_RowEvArgName="AnagImpiantiRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagImpiantiRowChangeEventHandler" msprop:Generator_TableClassName="AnagImpiantiDataTable" msprop:Generator_TableVarName="tableAnagImpianti" msprop:Generator_RowDeletingName="AnagImpiantiRowDeleting" msprop:Generator_TablePropName="AnagImpianti">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodImpianto" msprop:Generator_UserColumnName="CodImpianto" msprop:Generator_ColumnVarNameInTable="columnCodImpianto" msprop:Generator_ColumnPropNameInRow="CodImpianto" msprop:Generator_ColumnPropNameInTable="CodImpiantoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrImpianto" msprop:Generator_UserColumnName="DescrImpianto" msprop:Generator_ColumnVarNameInTable="columnDescrImpianto" msprop:Generator_ColumnPropNameInRow="DescrImpianto" msprop:Generator_ColumnPropNameInTable="DescrImpiantoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodSito" msprop:Generator_UserColumnName="CodSito" msprop:Generator_ColumnVarNameInTable="columnCodSito" msprop:Generator_ColumnPropNameInRow="CodSito" msprop:Generator_ColumnPropNameInTable="CodSitoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagOdp" msprop:Generator_UserTableName="AnagOdp" msprop:Generator_RowDeletedName="AnagOdpRowDeleted" msprop:Generator_RowChangedName="AnagOdpRowChanged" msprop:Generator_RowClassName="AnagOdpRow" msprop:Generator_RowChangingName="AnagOdpRowChanging" msprop:Generator_RowEvArgName="AnagOdpRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagOdpRowChangeEventHandler" msprop:Generator_TableClassName="AnagOdpDataTable" msprop:Generator_TableVarName="tableAnagOdp" msprop:Generator_RowDeletingName="AnagOdpRowDeleting" msprop:Generator_TablePropName="AnagOdp">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ODP" msprop:Generator_UserColumnName="ODP" msprop:Generator_ColumnVarNameInTable="columnODP" msprop:Generator_ColumnPropNameInRow="ODP" msprop:Generator_ColumnPropNameInTable="ODPColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodArticolo" msprop:Generator_UserColumnName="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodDisegno" msprop:Generator_UserColumnName="CodDisegno" msprop:Generator_ColumnVarNameInTable="columnCodDisegno" msprop:Generator_ColumnPropNameInRow="CodDisegno" msprop:Generator_ColumnPropNameInTable="CodDisegnoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Esponente" msprop:Generator_UserColumnName="Esponente" msprop:Generator_ColumnVarNameInTable="columnEsponente" msprop:Generator_ColumnPropNameInRow="Esponente" msprop:Generator_ColumnPropNameInTable="EsponenteColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Magazzino" msprop:Generator_UserColumnName="Magazzino" msprop:Generator_ColumnVarNameInTable="columnMagazzino" msprop:Generator_ColumnPropNameInRow="Magazzino" msprop:Generator_ColumnPropNameInTable="MagazzinoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Ubicazione" msprop:Generator_UserColumnName="Ubicazione" msprop:Generator_ColumnVarNameInTable="columnUbicazione" msprop:Generator_ColumnPropNameInRow="Ubicazione" msprop:Generator_ColumnPropNameInTable="UbicazioneColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" />
|
|
<xs:element name="ModDate" msprop:Generator_UserColumnName="ModDate" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" type="xs:dateTime" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagSiti" msprop:Generator_UserTableName="AnagSiti" msprop:Generator_RowDeletedName="AnagSitiRowDeleted" msprop:Generator_RowChangedName="AnagSitiRowChanged" msprop:Generator_RowClassName="AnagSitiRow" msprop:Generator_RowChangingName="AnagSitiRowChanging" msprop:Generator_RowEvArgName="AnagSitiRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagSitiRowChangeEventHandler" msprop:Generator_TableClassName="AnagSitiDataTable" msprop:Generator_TableVarName="tableAnagSiti" msprop:Generator_RowDeletingName="AnagSitiRowDeleting" msprop:Generator_TablePropName="AnagSiti">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodSito" msprop:Generator_UserColumnName="CodSito" msprop:Generator_ColumnVarNameInTable="columnCodSito" msprop:Generator_ColumnPropNameInRow="CodSito" msprop:Generator_ColumnPropNameInTable="CodSitoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrSito" msprop:Generator_UserColumnName="DescrSito" msprop:Generator_ColumnVarNameInTable="columnDescrSito" msprop:Generator_ColumnPropNameInRow="DescrSito" msprop:Generator_ColumnPropNameInTable="DescrSitoColumn" 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:element name="AnagStati" msprop:Generator_UserTableName="AnagStati" msprop:Generator_RowDeletedName="AnagStatiRowDeleted" msprop:Generator_RowChangedName="AnagStatiRowChanged" msprop:Generator_RowClassName="AnagStatiRow" msprop:Generator_RowChangingName="AnagStatiRowChanging" msprop:Generator_RowEvArgName="AnagStatiRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagStatiRowChangeEventHandler" msprop:Generator_TableClassName="AnagStatiDataTable" msprop:Generator_TableVarName="tableAnagStati" msprop:Generator_RowDeletingName="AnagStatiRowDeleting" msprop:Generator_TablePropName="AnagStati">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxStato" msprop:Generator_UserColumnName="IdxStato" msprop:Generator_ColumnVarNameInTable="columnIdxStato" msprop:Generator_ColumnPropNameInRow="IdxStato" msprop:Generator_ColumnPropNameInTable="IdxStatoColumn" type="xs:int" />
|
|
<xs:element name="DescrStato" msprop:Generator_UserColumnName="DescrStato" msprop:Generator_ColumnVarNameInTable="columnDescrStato" msprop:Generator_ColumnPropNameInRow="DescrStato" msprop:Generator_ColumnPropNameInTable="DescrStatoColumn" 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:element name="ContatoriUdc" msprop:Generator_UserTableName="ContatoriUdc" msprop:Generator_RowDeletedName="ContatoriUdcRowDeleted" msprop:Generator_RowChangedName="ContatoriUdcRowChanged" msprop:Generator_RowClassName="ContatoriUdcRow" msprop:Generator_RowChangingName="ContatoriUdcRowChanging" msprop:Generator_RowEvArgName="ContatoriUdcRowChangeEvent" msprop:Generator_RowEvHandlerName="ContatoriUdcRowChangeEventHandler" msprop:Generator_TableClassName="ContatoriUdcDataTable" msprop:Generator_TableVarName="tableContatoriUdc" msprop:Generator_RowDeletingName="ContatoriUdcRowDeleting" msprop:Generator_TablePropName="ContatoriUdc">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Flusso" msprop:Generator_UserColumnName="Flusso" msprop:Generator_ColumnVarNameInTable="columnFlusso" msprop:Generator_ColumnPropNameInRow="Flusso" msprop:Generator_ColumnPropNameInTable="FlussoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Anno" msprop:Generator_UserColumnName="Anno" msprop:Generator_ColumnVarNameInTable="columnAnno" msprop:Generator_ColumnPropNameInRow="Anno" msprop:Generator_ColumnPropNameInTable="AnnoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LastIdx" msprop:Generator_UserColumnName="LastIdx" msprop:Generator_ColumnVarNameInTable="columnLastIdx" msprop:Generator_ColumnPropNameInRow="LastIdx" msprop:Generator_ColumnPropNameInTable="LastIdxColumn" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Impianti2Articoli" msprop:Generator_UserTableName="Impianti2Articoli" msprop:Generator_RowDeletedName="Impianti2ArticoliRowDeleted" msprop:Generator_RowChangedName="Impianti2ArticoliRowChanged" msprop:Generator_RowClassName="Impianti2ArticoliRow" msprop:Generator_RowChangingName="Impianti2ArticoliRowChanging" msprop:Generator_RowEvArgName="Impianti2ArticoliRowChangeEvent" msprop:Generator_RowEvHandlerName="Impianti2ArticoliRowChangeEventHandler" msprop:Generator_TableClassName="Impianti2ArticoliDataTable" msprop:Generator_TableVarName="tableImpianti2Articoli" msprop:Generator_RowDeletingName="Impianti2ArticoliRowDeleting" msprop:Generator_TablePropName="Impianti2Articoli">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodImpianto" msprop:Generator_UserColumnName="CodImpianto" msprop:Generator_ColumnVarNameInTable="columnCodImpianto" msprop:Generator_ColumnPropNameInRow="CodImpianto" msprop:Generator_ColumnPropNameInTable="CodImpiantoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodArticolo" msprop:Generator_UserColumnName="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="InizioProd" msprop:Generator_UserColumnName="InizioProd" msprop:Generator_ColumnVarNameInTable="columnInizioProd" msprop:Generator_ColumnPropNameInRow="InizioProd" msprop:Generator_ColumnPropNameInTable="InizioProdColumn" type="xs:dateTime" />
|
|
<xs:element name="FineProd" msprop:Generator_UserColumnName="FineProd" msprop:Generator_ColumnVarNameInTable="columnFineProd" msprop:Generator_ColumnPropNameInRow="FineProd" msprop:Generator_ColumnPropNameInTable="FineProdColumn" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TabStatoOdpUdc" msprop:Generator_UserTableName="TabStatoOdpUdc" msprop:Generator_RowDeletedName="TabStatoOdpUdcRowDeleted" msprop:Generator_RowChangedName="TabStatoOdpUdcRowChanged" msprop:Generator_RowClassName="TabStatoOdpUdcRow" msprop:Generator_RowChangingName="TabStatoOdpUdcRowChanging" msprop:Generator_RowEvArgName="TabStatoOdpUdcRowChangeEvent" msprop:Generator_RowEvHandlerName="TabStatoOdpUdcRowChangeEventHandler" msprop:Generator_TableClassName="TabStatoOdpUdcDataTable" msprop:Generator_TableVarName="tableTabStatoOdpUdc" msprop:Generator_RowDeletingName="TabStatoOdpUdcRowDeleting" msprop:Generator_TablePropName="TabStatoOdpUdc">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ODP" msprop:Generator_UserColumnName="ODP" msprop:Generator_ColumnVarNameInTable="columnODP" msprop:Generator_ColumnPropNameInRow="ODP" msprop:Generator_ColumnPropNameInTable="ODPColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tara" msprop:Generator_UserColumnName="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="IdxStato" msprop:Generator_UserColumnName="IdxStato" msprop:Generator_ColumnVarNameInTable="columnIdxStato" msprop:Generator_ColumnPropNameInRow="IdxStato" msprop:Generator_ColumnPropNameInTable="IdxStatoColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Qta" msprop:Generator_UserColumnName="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CodImballo" msprop:Generator_UserColumnName="CodImballo" msprop:Generator_ColumnVarNameInTable="columnCodImballo" msprop:Generator_ColumnPropNameInRow="CodImballo" msprop:Generator_ColumnPropNameInTable="CodImballoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="ModDate" msprop:Generator_UserColumnName="ModDate" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_getStatoByUdc" msprop:Generator_UserTableName="stp_getStatoByUdc" msprop:Generator_RowDeletedName="stp_getStatoByUdcRowDeleted" msprop:Generator_RowChangedName="stp_getStatoByUdcRowChanged" msprop:Generator_RowClassName="stp_getStatoByUdcRow" msprop:Generator_RowChangingName="stp_getStatoByUdcRowChanging" msprop:Generator_RowEvArgName="stp_getStatoByUdcRowChangeEvent" msprop:Generator_RowEvHandlerName="stp_getStatoByUdcRowChangeEventHandler" msprop:Generator_TableClassName="stp_getStatoByUdcDataTable" msprop:Generator_TableVarName="tablestp_getStatoByUdc" msprop:Generator_RowDeletingName="stp_getStatoByUdcRowDeleting" msprop:Generator_TablePropName="stp_getStatoByUdc">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ODP" msprop:Generator_UserColumnName="ODP" msprop:Generator_ColumnVarNameInTable="columnODP" msprop:Generator_ColumnPropNameInRow="ODP" msprop:Generator_ColumnPropNameInTable="ODPColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tara" msprop:Generator_UserColumnName="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="IdxStato" msprop:Generator_UserColumnName="IdxStato" msprop:Generator_ColumnVarNameInTable="columnIdxStato" msprop:Generator_ColumnPropNameInRow="IdxStato" msprop:Generator_ColumnPropNameInTable="IdxStatoColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Qta" msprop:Generator_UserColumnName="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CodImballo" msprop:Generator_UserColumnName="CodImballo" msprop:Generator_ColumnVarNameInTable="columnCodImballo" msprop:Generator_ColumnPropNameInRow="CodImballo" msprop:Generator_ColumnPropNameInTable="CodImballoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="ModDate" msprop:Generator_UserColumnName="ModDate" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_insNewOdpUdc" msprop:Generator_UserTableName="stp_insNewOdpUdc" msprop:Generator_RowDeletedName="stp_insNewOdpUdcRowDeleted" msprop:Generator_RowChangedName="stp_insNewOdpUdcRowChanged" msprop:Generator_RowClassName="stp_insNewOdpUdcRow" msprop:Generator_RowChangingName="stp_insNewOdpUdcRowChanging" msprop:Generator_RowEvArgName="stp_insNewOdpUdcRowChangeEvent" msprop:Generator_RowEvHandlerName="stp_insNewOdpUdcRowChangeEventHandler" msprop:Generator_TableClassName="stp_insNewOdpUdcDataTable" msprop:Generator_TableVarName="tablestp_insNewOdpUdc" msprop:Generator_RowDeletingName="stp_insNewOdpUdcRowDeleting" msprop:Generator_TablePropName="stp_insNewOdpUdc">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ODP" msprop:Generator_UserColumnName="ODP" msprop:Generator_ColumnVarNameInTable="columnODP" msprop:Generator_ColumnPropNameInRow="ODP" msprop:Generator_ColumnPropNameInTable="ODPColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tara" msprop:Generator_UserColumnName="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="IdxStato" msprop:Generator_UserColumnName="IdxStato" msprop:Generator_ColumnVarNameInTable="columnIdxStato" msprop:Generator_ColumnPropNameInRow="IdxStato" msprop:Generator_ColumnPropNameInTable="IdxStatoColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Qta" msprop:Generator_UserColumnName="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CodImballo" msprop:Generator_UserColumnName="CodImballo" msprop:Generator_ColumnVarNameInTable="columnCodImballo" msprop:Generator_ColumnPropNameInRow="CodImballo" msprop:Generator_ColumnPropNameInTable="CodImballoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="ModDate" msprop:Generator_UserColumnName="ModDate" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_updateByBilancia" msprop:Generator_UserTableName="stp_updateByBilancia" msprop:Generator_RowDeletedName="stp_updateByBilanciaRowDeleted" msprop:Generator_RowChangedName="stp_updateByBilanciaRowChanged" msprop:Generator_RowClassName="stp_updateByBilanciaRow" msprop:Generator_RowChangingName="stp_updateByBilanciaRowChanging" msprop:Generator_RowEvArgName="stp_updateByBilanciaRowChangeEvent" msprop:Generator_RowEvHandlerName="stp_updateByBilanciaRowChangeEventHandler" msprop:Generator_TableClassName="stp_updateByBilanciaDataTable" msprop:Generator_TableVarName="tablestp_updateByBilancia" msprop:Generator_RowDeletingName="stp_updateByBilanciaRowDeleting" msprop:Generator_TablePropName="stp_updateByBilancia">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCompany" msprop:Generator_UserColumnName="CodCompany" msprop:Generator_ColumnVarNameInTable="columnCodCompany" msprop:Generator_ColumnPropNameInRow="CodCompany" msprop:Generator_ColumnPropNameInTable="CodCompanyColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ODP" msprop:Generator_UserColumnName="ODP" msprop:Generator_ColumnVarNameInTable="columnODP" msprop:Generator_ColumnPropNameInRow="ODP" msprop:Generator_ColumnPropNameInTable="ODPColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tara" msprop:Generator_UserColumnName="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="IdxStato" msprop:Generator_UserColumnName="IdxStato" msprop:Generator_ColumnVarNameInTable="columnIdxStato" msprop:Generator_ColumnPropNameInRow="IdxStato" msprop:Generator_ColumnPropNameInTable="IdxStatoColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Qta" msprop:Generator_UserColumnName="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CodImballo" msprop:Generator_UserColumnName="CodImballo" msprop:Generator_ColumnVarNameInTable="columnCodImballo" msprop:Generator_ColumnPropNameInRow="CodImballo" msprop:Generator_ColumnPropNameInTable="CodImballoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="ModDate" msprop:Generator_UserColumnName="ModDate" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prtCartByUDC" msprop:Generator_UserTableName="stp_prtCartByUDC" msprop:Generator_RowDeletedName="stp_prtCartByUDCRowDeleted" msprop:Generator_TableClassName="stp_prtCartByUDCDataTable" msprop:Generator_RowChangedName="stp_prtCartByUDCRowChanged" msprop:Generator_RowClassName="stp_prtCartByUDCRow" msprop:Generator_RowChangingName="stp_prtCartByUDCRowChanging" msprop:Generator_RowEvArgName="stp_prtCartByUDCRowChangeEvent" msprop:Generator_RowEvHandlerName="stp_prtCartByUDCRowChangeEventHandler" msprop:Generator_TablePropName="stp_prtCartByUDC" msprop:Generator_TableVarName="tablestp_prtCartByUDC" msprop:Generator_RowDeletingName="stp_prtCartByUDCRowDeleting">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInTable="UDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCS" msprop:Generator_UserColumnName="CodCS" msprop:Generator_ColumnPropNameInRow="CodCS" msprop:Generator_ColumnVarNameInTable="columnCodCS" msprop:Generator_ColumnPropNameInTable="CodCSColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codcliente" msdata:ReadOnly="true" msprop:Generator_UserColumnName="codcliente" msprop:Generator_ColumnPropNameInRow="codcliente" msprop:Generator_ColumnVarNameInTable="columncodcliente" msprop:Generator_ColumnPropNameInTable="codclienteColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ragsociale" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ragsociale" msprop:Generator_ColumnPropNameInRow="ragsociale" msprop:Generator_ColumnVarNameInTable="columnragsociale" msprop:Generator_ColumnPropNameInTable="ragsocialeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="particolare" msdata:ReadOnly="true" msprop:Generator_UserColumnName="particolare" msprop:Generator_ColumnPropNameInRow="particolare" msprop:Generator_ColumnVarNameInTable="columnparticolare" msprop:Generator_ColumnPropNameInTable="particolareColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descparticolare" msdata:ReadOnly="true" msprop:Generator_UserColumnName="descparticolare" msprop:Generator_ColumnPropNameInRow="descparticolare" msprop:Generator_ColumnVarNameInTable="columndescparticolare" msprop:Generator_ColumnPropNameInTable="descparticolareColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="disegnogrezzo" msdata:ReadOnly="true" msprop:Generator_UserColumnName="disegnogrezzo" msprop:Generator_ColumnPropNameInRow="disegnogrezzo" msprop:Generator_ColumnVarNameInTable="columndisegnogrezzo" msprop:Generator_ColumnPropNameInTable="disegnogrezzoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="esponente" msdata:ReadOnly="true" msprop:Generator_UserColumnName="esponente" msprop:Generator_ColumnPropNameInRow="esponente" msprop:Generator_ColumnVarNameInTable="columnesponente" msprop:Generator_ColumnPropNameInTable="esponenteColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codimpianto" msdata:ReadOnly="true" msprop:Generator_UserColumnName="codimpianto" msprop:Generator_ColumnPropNameInRow="codimpianto" msprop:Generator_ColumnVarNameInTable="columncodimpianto" msprop:Generator_ColumnPropNameInTable="codimpiantoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descimpianto" msdata:ReadOnly="true" msprop:Generator_UserColumnName="descimpianto" msprop:Generator_ColumnPropNameInRow="descimpianto" msprop:Generator_ColumnVarNameInTable="columndescimpianto" msprop:Generator_ColumnPropNameInTable="descimpiantoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codstampo" msdata:ReadOnly="true" msprop:Generator_UserColumnName="codstampo" msprop:Generator_ColumnPropNameInRow="codstampo" msprop:Generator_ColumnVarNameInTable="columncodstampo" msprop:Generator_ColumnPropNameInTable="codstampoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="figura" msdata:ReadOnly="true" msprop:Generator_UserColumnName="figura" msprop:Generator_ColumnPropNameInRow="figura" msprop:Generator_ColumnVarNameInTable="columnfigura" msprop:Generator_ColumnPropNameInTable="figuraColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="datafus" msdata:ReadOnly="true" msprop:Generator_UserColumnName="datafus" msprop:Generator_ColumnPropNameInRow="datafus" msprop:Generator_ColumnVarNameInTable="columndatafus" msprop:Generator_ColumnPropNameInTable="datafusColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="turnofus" msdata:ReadOnly="true" msprop:Generator_UserColumnName="turnofus" msprop:Generator_ColumnPropNameInRow="turnofus" msprop:Generator_ColumnVarNameInTable="columnturnofus" msprop:Generator_ColumnPropNameInTable="turnofusColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="codimballo" msdata:ReadOnly="true" msprop:Generator_UserColumnName="codimballo" msprop:Generator_ColumnPropNameInRow="codimballo" msprop:Generator_ColumnVarNameInTable="columncodimballo" msprop:Generator_ColumnPropNameInTable="codimballoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codsoggetto" msdata:ReadOnly="true" msprop:Generator_UserColumnName="codsoggetto" msprop:Generator_ColumnPropNameInRow="codsoggetto" msprop:Generator_ColumnVarNameInTable="columncodsoggetto" msprop:Generator_ColumnPropNameInTable="codsoggettoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="17" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="numcont" msdata:ReadOnly="true" msprop:Generator_UserColumnName="numcont" msprop:Generator_ColumnPropNameInRow="numcont" msprop:Generator_ColumnVarNameInTable="columnnumcont" msprop:Generator_ColumnPropNameInTable="numcontColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="tara" msdata:ReadOnly="true" msprop:Generator_UserColumnName="tara" msprop:Generator_ColumnPropNameInRow="tara" msprop:Generator_ColumnVarNameInTable="columntara" msprop:Generator_ColumnPropNameInTable="taraColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="qta" msdata:ReadOnly="true" msprop:Generator_UserColumnName="qta" msprop:Generator_ColumnPropNameInRow="qta" msprop:Generator_ColumnVarNameInTable="columnqta" msprop:Generator_ColumnPropNameInTable="qtaColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="codstato" msdata:ReadOnly="true" msprop:Generator_UserColumnName="codstato" msprop:Generator_ColumnPropNameInRow="codstato" msprop:Generator_ColumnVarNameInTable="columncodstato" msprop:Generator_ColumnPropNameInTable="codstatoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxposizione" msdata:ReadOnly="true" msprop:Generator_UserColumnName="idxposizione" msprop:Generator_ColumnPropNameInRow="idxposizione" msprop:Generator_ColumnVarNameInTable="columnidxposizione" msprop:Generator_ColumnPropNameInTable="idxposizioneColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="pesotot" msdata:ReadOnly="true" msprop:Generator_UserColumnName="pesotot" msprop:Generator_ColumnPropNameInRow="pesotot" msprop:Generator_ColumnVarNameInTable="columnpesotot" msprop:Generator_ColumnPropNameInTable="pesototColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="pesocad" msdata:ReadOnly="true" msprop:Generator_UserColumnName="pesocad" msprop:Generator_ColumnPropNameInRow="pesocad" msprop:Generator_ColumnVarNameInTable="columnpesocad" msprop:Generator_ColumnPropNameInTable="pesocadColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="ModDate" msprop:Generator_UserColumnName="ModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="cognome" msdata:ReadOnly="true" msprop:Generator_UserColumnName="cognome" msprop:Generator_ColumnPropNameInRow="cognome" msprop:Generator_ColumnVarNameInTable="columncognome" msprop:Generator_ColumnPropNameInTable="cognomeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="40" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nome" msdata:ReadOnly="true" msprop:Generator_UserColumnName="nome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_ColumnPropNameInTable="nomeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="40" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descstato" msdata:ReadOnly="true" msprop:Generator_UserColumnName="descstato" msprop:Generator_ColumnPropNameInRow="descstato" msprop:Generator_ColumnVarNameInTable="columndescstato" msprop:Generator_ColumnPropNameInTable="descstatoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descimballo" msdata:ReadOnly="true" msprop:Generator_UserColumnName="descimballo" msprop:Generator_ColumnPropNameInRow="descimballo" msprop:Generator_ColumnVarNameInTable="columndescimballo" msprop:Generator_ColumnPropNameInTable="descimballoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodFamiglia" msprop:Generator_UserColumnName="CodFamiglia" msprop:Generator_ColumnPropNameInRow="CodFamiglia" msprop:Generator_ColumnVarNameInTable="columnCodFamiglia" msprop:Generator_ColumnPropNameInTable="CodFamigliaColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescFamiglia" msprop:Generator_UserColumnName="DescFamiglia" msprop:Generator_ColumnPropNameInRow="DescFamiglia" msprop:Generator_ColumnVarNameInTable="columnDescFamiglia" msprop:Generator_ColumnPropNameInTable="DescFamigliaColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prtCartMatPrimaByUDC" msprop:Generator_UserTableName="stp_prtCartMatPrimaByUDC" msprop:Generator_RowDeletedName="stp_prtCartMatPrimaByUDCRowDeleted" msprop:Generator_TableClassName="stp_prtCartMatPrimaByUDCDataTable" msprop:Generator_RowChangedName="stp_prtCartMatPrimaByUDCRowChanged" msprop:Generator_RowClassName="stp_prtCartMatPrimaByUDCRow" msprop:Generator_RowChangingName="stp_prtCartMatPrimaByUDCRowChanging" msprop:Generator_RowEvArgName="stp_prtCartMatPrimaByUDCRowChangeEvent" msprop:Generator_RowEvHandlerName="stp_prtCartMatPrimaByUDCRowChangeEventHandler" msprop:Generator_TablePropName="stp_prtCartMatPrimaByUDC" msprop:Generator_TableVarName="tablestp_prtCartMatPrimaByUDC" msprop:Generator_RowDeletingName="stp_prtCartMatPrimaByUDCRowDeleting">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="nRapQual" msprop:Generator_UserColumnName="nRapQual" msprop:Generator_ColumnPropNameInRow="nRapQual" msprop:Generator_ColumnVarNameInTable="columnnRapQual" msprop:Generator_ColumnPropNameInTable="nRapQualColumn" type="xs:decimal" />
|
|
<xs:element name="DataRapQual" msprop:Generator_UserColumnName="DataRapQual" msprop:Generator_ColumnPropNameInRow="DataRapQual" msprop:Generator_ColumnVarNameInTable="columnDataRapQual" msprop:Generator_ColumnPropNameInTable="DataRapQualColumn" type="xs:decimal" />
|
|
<xs:element name="ProgUDC" msprop:Generator_UserColumnName="ProgUDC" msprop:Generator_ColumnPropNameInRow="ProgUDC" msprop:Generator_ColumnVarNameInTable="columnProgUDC" msprop:Generator_ColumnPropNameInTable="ProgUDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodFor" msprop:Generator_UserColumnName="CodFor" msprop:Generator_ColumnPropNameInRow="CodFor" msprop:Generator_ColumnVarNameInTable="columnCodFor" msprop:Generator_ColumnPropNameInTable="CodForColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DestTerz" msprop:Generator_UserColumnName="DestTerz" msprop:Generator_ColumnPropNameInRow="DestTerz" msprop:Generator_ColumnVarNameInTable="columnDestTerz" msprop:Generator_ColumnPropNameInTable="DestTerzColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodLega" msprop:Generator_UserColumnName="CodLega" msprop:Generator_ColumnPropNameInRow="CodLega" msprop:Generator_ColumnVarNameInTable="columnCodLega" msprop:Generator_ColumnPropNameInTable="CodLegaColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataPrelFus" msprop:Generator_UserColumnName="DataPrelFus" msprop:Generator_ColumnPropNameInRow="DataPrelFus" msprop:Generator_ColumnVarNameInTable="columnDataPrelFus" msprop:Generator_ColumnPropNameInTable="DataPrelFusColumn" type="xs:decimal" />
|
|
<xs:element name="TurnoPrelFus" msprop:Generator_UserColumnName="TurnoPrelFus" msprop:Generator_ColumnPropNameInRow="TurnoPrelFus" msprop:Generator_ColumnVarNameInTable="columnTurnoPrelFus" msprop:Generator_ColumnPropNameInTable="TurnoPrelFusColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Qta" msprop:Generator_UserColumnName="Qta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInTable="QtaColumn" type="xs:decimal" />
|
|
<xs:element name="DestLega" msprop:Generator_UserColumnName="DestLega" msprop:Generator_ColumnPropNameInRow="DestLega" msprop:Generator_ColumnVarNameInTable="columnDestLega" msprop:Generator_ColumnPropNameInTable="DestLegaColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LegaScaric" msprop:Generator_UserColumnName="LegaScaric" msprop:Generator_ColumnPropNameInRow="LegaScaric" msprop:Generator_ColumnVarNameInTable="columnLegaScaric" msprop:Generator_ColumnPropNameInTable="LegaScaricColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="BenesQual" msprop:Generator_UserColumnName="BenesQual" msprop:Generator_ColumnPropNameInRow="BenesQual" msprop:Generator_ColumnVarNameInTable="columnBenesQual" msprop:Generator_ColumnPropNameInTable="BenesQualColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInTable="UDCColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescFornitore" msprop:Generator_UserColumnName="DescFornitore" msprop:Generator_ColumnPropNameInRow="DescFornitore" msprop:Generator_ColumnVarNameInTable="columnDescFornitore" msprop:Generator_ColumnPropNameInTable="DescFornitoreColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescFornitore2" msprop:Generator_UserColumnName="DescFornitore2" msprop:Generator_ColumnPropNameInRow="DescFornitore2" msprop:Generator_ColumnVarNameInTable="columnDescFornitore2" msprop:Generator_ColumnPropNameInTable="DescFornitore2Column" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodLega2" msprop:Generator_UserColumnName="CodLega2" msprop:Generator_ColumnPropNameInRow="CodLega2" msprop:Generator_ColumnVarNameInTable="columnCodLega2" msprop:Generator_ColumnPropNameInTable="CodLega2Column" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="12" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescLega" msprop:Generator_UserColumnName="DescLega" msprop:Generator_ColumnPropNameInRow="DescLega" msprop:Generator_ColumnVarNameInTable="columnDescLega" msprop:Generator_ColumnPropNameInTable="DescLegaColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="25" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescLega2" msprop:Generator_UserColumnName="DescLega2" msprop:Generator_ColumnPropNameInRow="DescLega2" msprop:Generator_ColumnVarNameInTable="columnDescLega2" msprop:Generator_ColumnPropNameInTable="DescLega2Column" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="25" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagArticoli" />
|
|
<xs:field xpath="mstns:CodArticolo" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagBilance_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagBilance" />
|
|
<xs:field xpath="mstns:CodBilancia" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagCompany_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagCompany" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagImpianti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagImpianti" />
|
|
<xs:field xpath="mstns:CodImpianto" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagOdp_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagOdp" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:ODP" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagSiti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagSiti" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:CodSito" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagStati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagStati" />
|
|
<xs:field xpath="mstns:IdxStato" />
|
|
</xs:unique>
|
|
<xs:unique name="ContatoriUdc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ContatoriUdc" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:Flusso" />
|
|
<xs:field xpath="mstns:Anno" />
|
|
</xs:unique>
|
|
<xs:unique name="Impianti2Articoli_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Impianti2Articoli" />
|
|
<xs:field xpath="mstns:CodImpianto" />
|
|
<xs:field xpath="mstns:CodArticolo" />
|
|
<xs:field xpath="mstns:InizioProd" />
|
|
</xs:unique>
|
|
<xs:unique name="TabStatoOdpUdc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TabStatoOdpUdc" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:ODP" />
|
|
<xs:field xpath="mstns:UDC" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_getStatoByUdc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_getStatoByUdc" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:ODP" />
|
|
<xs:field xpath="mstns:UDC" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_insNewOdpUdc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_insNewOdpUdc" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:ODP" />
|
|
<xs:field xpath="mstns:UDC" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_updateByBilancia_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_updateByBilancia" />
|
|
<xs:field xpath="mstns:CodCompany" />
|
|
<xs:field xpath="mstns:ODP" />
|
|
<xs:field xpath="mstns:UDC" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_prtCartByUDC_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_prtCartByUDC" />
|
|
<xs:field xpath="mstns:UDC" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_prtCartMatPrimaByUDC_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_prtCartMatPrimaByUDC" />
|
|
<xs:field xpath="mstns:ProgUDC" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_AnagBilance_AnagSiti" msdata:parent="AnagSiti" msdata:child="AnagBilance" msdata:parentkey="CodCompany CodSito" msdata:childkey="CodCompany CodSito" msprop:Generator_UserRelationName="FK_AnagBilance_AnagSiti" msprop:Generator_RelationVarName="relationFK_AnagBilance_AnagSiti" msprop:Generator_UserChildTable="AnagBilance" msprop:Generator_UserParentTable="AnagSiti" msprop:Generator_ParentPropName="AnagSitiRowParent" msprop:Generator_ChildPropName="GetAnagBilanceRows" />
|
|
<msdata:Relationship name="FK_AnagImpianti_AnagSiti" msdata:parent="AnagSiti" msdata:child="AnagImpianti" msdata:parentkey="CodCompany CodSito" msdata:childkey="CodCompany CodSito" msprop:Generator_UserRelationName="FK_AnagImpianti_AnagSiti" msprop:Generator_RelationVarName="relationFK_AnagImpianti_AnagSiti" msprop:Generator_UserChildTable="AnagImpianti" msprop:Generator_UserParentTable="AnagSiti" msprop:Generator_ParentPropName="AnagSitiRowParent" msprop:Generator_ChildPropName="GetAnagImpiantiRows" />
|
|
<msdata:Relationship name="FK_AnagOdp_AnagCompany" msdata:parent="AnagCompany" msdata:child="AnagOdp" msdata:parentkey="CodCompany" msdata:childkey="CodCompany" msprop:Generator_UserRelationName="FK_AnagOdp_AnagCompany" msprop:Generator_RelationVarName="relationFK_AnagOdp_AnagCompany" msprop:Generator_UserChildTable="AnagOdp" msprop:Generator_UserParentTable="AnagCompany" msprop:Generator_ParentPropName="AnagCompanyRow" msprop:Generator_ChildPropName="GetAnagOdpRows" />
|
|
<msdata:Relationship name="FK_AnagSiti_AnagCompany" msdata:parent="AnagCompany" msdata:child="AnagSiti" msdata:parentkey="CodCompany" msdata:childkey="CodCompany" msprop:Generator_UserRelationName="FK_AnagSiti_AnagCompany" msprop:Generator_RelationVarName="relationFK_AnagSiti_AnagCompany" msprop:Generator_UserChildTable="AnagSiti" msprop:Generator_UserParentTable="AnagCompany" msprop:Generator_ParentPropName="AnagCompanyRow" msprop:Generator_ChildPropName="GetAnagSitiRows" />
|
|
<msdata:Relationship name="FK_Impianti2Articoli_AnagArticoli" msdata:parent="AnagArticoli" msdata:child="Impianti2Articoli" msdata:parentkey="CodArticolo" msdata:childkey="CodArticolo" msprop:Generator_UserRelationName="FK_Impianti2Articoli_AnagArticoli" msprop:Generator_RelationVarName="relationFK_Impianti2Articoli_AnagArticoli" msprop:Generator_UserChildTable="Impianti2Articoli" msprop:Generator_UserParentTable="AnagArticoli" msprop:Generator_ParentPropName="AnagArticoliRow" msprop:Generator_ChildPropName="GetImpianti2ArticoliRows" />
|
|
<msdata:Relationship name="FK_Impianti2Articoli_AnagImpianti" msdata:parent="AnagImpianti" msdata:child="Impianti2Articoli" msdata:parentkey="CodImpianto" msdata:childkey="CodImpianto" msprop:Generator_UserRelationName="FK_Impianti2Articoli_AnagImpianti" msprop:Generator_RelationVarName="relationFK_Impianti2Articoli_AnagImpianti" msprop:Generator_UserChildTable="Impianti2Articoli" msprop:Generator_UserParentTable="AnagImpianti" msprop:Generator_ParentPropName="AnagImpiantiRow" msprop:Generator_ChildPropName="GetImpianti2ArticoliRows" />
|
|
<msdata:Relationship name="FK_TabStatoOdpUdc_AnagOdp" msdata:parent="AnagOdp" msdata:child="TabStatoOdpUdc" msdata:parentkey="CodCompany ODP" msdata:childkey="CodCompany ODP" msprop:Generator_UserRelationName="FK_TabStatoOdpUdc_AnagOdp" msprop:Generator_RelationVarName="relationFK_TabStatoOdpUdc_AnagOdp" msprop:Generator_UserChildTable="TabStatoOdpUdc" msprop:Generator_UserParentTable="AnagOdp" msprop:Generator_ParentPropName="AnagOdpRowParent" msprop:Generator_ChildPropName="GetTabStatoOdpUdcRows" />
|
|
<msdata:Relationship name="FK_TabStatoOdpUdc_AnagStati" msdata:parent="AnagStati" msdata:child="TabStatoOdpUdc" msdata:parentkey="IdxStato" msdata:childkey="IdxStato" msprop:Generator_UserRelationName="FK_TabStatoOdpUdc_AnagStati" msprop:Generator_RelationVarName="relationFK_TabStatoOdpUdc_AnagStati" msprop:Generator_UserChildTable="TabStatoOdpUdc" msprop:Generator_UserParentTable="AnagStati" msprop:Generator_ParentPropName="AnagStatiRow" msprop:Generator_ChildPropName="GetTabStatoOdpUdcRows" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |