Egalware/MoonPro.net
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
MoonPro.net/MagData/DS_Mag.xsd
T
Samuele Locatelli 46ba6078e3 MP-IO: 
- Inizio modifiche x nuova registrazione RegGiacenze
2022-11-28 19:58:30 +01:00

1735 lines
190 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DS_Mag" targetNamespace="http://tempuri.org/DS_Mag.xsd" xmlns:mstns="http://tempuri.org/DS_Mag.xsd" xmlns="http://tempuri.org/DS_Mag.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MoonPro_MAGConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MoonPro_MAGConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MagData.Properties.Settings.GlobalReference.Default.MoonPro_MAGConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencoLottiTableAdapter" GeneratorDataComponentClassName="ElencoLottiTableAdapter" Name="ElencoLotti" UserDataComponentName="ElencoLottiTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_ElencoLotti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT * FROM v_ElencoLotti</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Lotto" DataSetColumn="Lotto" />
<Mapping SourceColumn="IdxODL" DataSetColumn="IdxODL" />
<Mapping SourceColumn="RifExt" DataSetColumn="RifExt" />
<Mapping SourceColumn="TipoLotto" DataSetColumn="TipoLotto" />
<Mapping SourceColumn="CodArt" DataSetColumn="CodArt" />
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
<Mapping SourceColumn="Origine" DataSetColumn="Origine" />
<Mapping SourceColumn="DtCrea" DataSetColumn="DtCrea" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="QtaOrig" DataSetColumn="QtaOrig" />
<Mapping SourceColumn="NumUdc" DataSetColumn="NumUdc" />
<Mapping SourceColumn="QtaCurr" DataSetColumn="QtaCurr" />
<Mapping SourceColumn="DtMod" DataSetColumn="DtMod" />
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
<Mapping SourceColumn="DescrArt" DataSetColumn="DescrArt" />
<Mapping SourceColumn="CodArtExt" DataSetColumn="CodArtExt" />
<Mapping SourceColumn="DescStato" DataSetColumn="DescStato" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_getAncestor" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getAncestor" GetMethodModifier="Public" GetMethodName="getAncestor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getAncestor" UserSourceName="getAncestor">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_getAncestor</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="nvarchar" DbType="String" Direction="Input" ParameterName="@LottoOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_getBuiltByHashList" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBuiltByHashList" GetMethodModifier="Public" GetMethodName="getBuiltByHashList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBuiltByHashList" UserSourceName="getBuiltByHashList">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_getBuiltByHashList</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="nvarchar" DbType="String" Direction="Input" ParameterName="@elLotti" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_getByHashList" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByHashList" GetMethodModifier="Public" GetMethodName="getByHashList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByHashList" UserSourceName="getByHashList">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_getByHashList</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="nvarchar" DbType="String" Direction="Input" ParameterName="@elLotti" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_getByKey</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Lotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TipoLotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_getByODL" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByOdl" GetMethodModifier="Public" GetMethodName="getByOdl" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByOdl" UserSourceName="getByOdl">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_getByODL</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="int" DbType="Int32" Direction="Input" ParameterName="@IdxODL" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_getBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_getBySearch</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="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchVal" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_InsertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="insertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_InsertQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@TipoLotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArt" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Origine" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RifExt" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@elLotti" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EL_UpdateQty" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQty" Modifier="Public" Name="updateQty" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="updateQty">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EL_UpdateQty</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_Lotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@QtaOrig" Precision="18" ProviderType="Decimal" Scale="9" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumUdc" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencoUdcTableAdapter" GeneratorDataComponentClassName="ElencoUdcTableAdapter" Name="ElencoUdc" UserDataComponentName="ElencoUdcTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_ElencoUdc" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM v_ElencoUdc</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
<Mapping SourceColumn="Lotto" DataSetColumn="Lotto" />
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
<Mapping SourceColumn="CodPost" DataSetColumn="CodPost" />
<Mapping SourceColumn="DtRec" DataSetColumn="DtRec" />
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
<Mapping SourceColumn="NumCont" DataSetColumn="NumCont" />
<Mapping SourceColumn="CodSoggetto" DataSetColumn="CodSoggetto" />
<Mapping SourceColumn="PesoTot" DataSetColumn="PesoTot" />
<Mapping SourceColumn="PesoCad" DataSetColumn="PesoCad" />
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
<Mapping SourceColumn="CodImballo" DataSetColumn="CodImballo" />
<Mapping SourceColumn="IdxPosizione" DataSetColumn="IdxPosizione" />
<Mapping SourceColumn="DtMod" DataSetColumn="DtMod" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="TipoLotto" DataSetColumn="TipoLotto" />
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
<Mapping SourceColumn="Origine" DataSetColumn="Origine" />
<Mapping SourceColumn="DtCrea" DataSetColumn="DtCrea" />
<Mapping SourceColumn="NoteLotto" DataSetColumn="NoteLotto" />
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
<Mapping SourceColumn="Indirizzo" DataSetColumn="Indirizzo" />
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
<Mapping SourceColumn="Provincia" DataSetColumn="Provincia" />
<Mapping SourceColumn="Nazione" DataSetColumn="Nazione" />
<Mapping SourceColumn="CodArt" DataSetColumn="CodArt" />
<Mapping SourceColumn="DescrArt" DataSetColumn="DescrArt" />
<Mapping SourceColumn="CodArtExt" DataSetColumn="CodArtExt" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EU_getByAL" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByAL" GetMethodModifier="Public" GetMethodName="getByAL" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByAL" UserSourceName="getByAL">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EU_getByAL</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="nvarchar" DbType="String" Direction="Input" ParameterName="@AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EU_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EU_getByKey</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="nvarchar" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EU_getByLotto" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByLotto" GetMethodModifier="Public" GetMethodName="getByLotto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByLotto" UserSourceName="getByLotto">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EU_getByLotto</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Lotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EU_getByIdxOdl" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByOdl" GetMethodModifier="Public" GetMethodName="getByOdl" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByOdl" UserSourceName="getByOdl">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EU_getByIdxOdl</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="int" DbType="Int32" Direction="Input" ParameterName="@IdxOdl" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EU_getByPackList" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByPackList" GetMethodModifier="Public" GetMethodName="getByPackList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByPackList" UserSourceName="getByPackList">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EU_getByPackList</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="int" DbType="Int32" Direction="Input" ParameterName="@PackListID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EU_InsertQuery" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="insertQuery" GeneratorSourceName="insertQuery" GetMethodModifier="Public" GetMethodName="insertQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="insertQuery" UserSourceName="insertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EU_InsertQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Lotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodPost" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Qta" Precision="18" ProviderType="Decimal" Scale="9" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumCont" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSoggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@PesoTot" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@PesoCad" Precision="53" ProviderType="Float" Scale="0" Size="8" 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" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodImballo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxPosizione" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagArtTableAdapter" GeneratorDataComponentClassName="AnagArtTableAdapter" Name="AnagArt" UserDataComponentName="AnagArtTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_AnagArt" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM dbo.v_AnagArt
</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodArt" DataSetColumn="CodArt" />
<Mapping SourceColumn="DescrArt" DataSetColumn="DescrArt" />
<Mapping SourceColumn="CodArtExt" DataSetColumn="CodArtExt" />
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_AA_getDiBaByHashList" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByHashList" GetMethodModifier="Public" GetMethodName="getByHashList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByHashList" UserSourceName="getByHashList">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AA_getDiBaByHashList</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="nvarchar" DbType="String" Direction="Input" ParameterName="@elLotti" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_AA_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AA_getByKey</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArt" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ODLTableAdapter" GeneratorDataComponentClassName="ODLTableAdapter" Name="ODL" UserDataComponentName="ODLTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_ODL" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM dbo.v_ODL
</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="IdxODL" DataSetColumn="IdxODL" />
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
<Mapping SourceColumn="NumPezzi" DataSetColumn="NumPezzi" />
<Mapping SourceColumn="TCAssegnato" DataSetColumn="TCAssegnato" />
<Mapping SourceColumn="DataInizio" DataSetColumn="DataInizio" />
<Mapping SourceColumn="DataFine" DataSetColumn="DataFine" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="NeedAppr" DataSetColumn="NeedAppr" />
<Mapping SourceColumn="UserAppr" DataSetColumn="UserAppr" />
<Mapping SourceColumn="DataAppr" DataSetColumn="DataAppr" />
<Mapping SourceColumn="TCRichAttr" DataSetColumn="TCRichAttr" />
<Mapping SourceColumn="KeyRichiesta" DataSetColumn="KeyRichiesta" />
<Mapping SourceColumn="PzPallet" DataSetColumn="PzPallet" />
<Mapping SourceColumn="provvisorio" DataSetColumn="provvisorio" />
<Mapping SourceColumn="MatrOpr" DataSetColumn="MatrOpr" />
<Mapping SourceColumn="CommessaAs400" DataSetColumn="CommessaAs400" />
<Mapping SourceColumn="ToAs400" DataSetColumn="ToAs400" />
<Mapping SourceColumn="CodCli" DataSetColumn="CodCli" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ODL_getLastByIdxMacc" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getLastByMacc" GetMethodModifier="Public" GetMethodName="getLastByMacc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getLastByMacc" UserSourceName="getLastByMacc">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ODL_getLastByIdxMacc</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="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ODL_getOpenByPost" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getOpenByPost" GetMethodModifier="Public" GetMethodName="getOpenByPost" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getOpenByPost" UserSourceName="getOpenByPost">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ODL_getOpenByPost</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodPost" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Elencopost2QueueTableAdapter" GeneratorDataComponentClassName="Elencopost2QueueTableAdapter" Name="Elencopost2Queue" UserDataComponentName="Elencopost2QueueTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.ElencoPost2Queue" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM dbo.ElencoPost2Queue
</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodPost" DataSetColumn="CodPost" />
<Mapping SourceColumn="PrintQueue" DataSetColumn="PrintQueue" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EP2Q_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EP2Q_getByKey</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodPost" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencoALTableAdapter" GeneratorDataComponentClassName="ElencoALTableAdapter" Name="ElencoAL" UserDataComponentName="ElencoALTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_ElencoAL" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT * FROM v_ElencoAL</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="AL" DataSetColumn="AL" />
<Mapping SourceColumn="Descr" DataSetColumn="Descr" />
<Mapping SourceColumn="PackListID" DataSetColumn="PackListID" />
<Mapping SourceColumn="Status" DataSetColumn="Status" />
<Mapping SourceColumn="DtRec" DataSetColumn="DtRec" />
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
<Mapping SourceColumn="CodSoggetto" DataSetColumn="CodSoggetto" />
<Mapping SourceColumn="QtaUdc" DataSetColumn="QtaUdc" />
<Mapping SourceColumn="NumUdc" DataSetColumn="NumUdc" />
<Mapping SourceColumn="PesoUdc" DataSetColumn="PesoUdc" />
<Mapping SourceColumn="TaraUdc" DataSetColumn="TaraUdc" />
<Mapping SourceColumn="CurrState" DataSetColumn="CurrState" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_deleteQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_getByKey</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="nvarchar" DbType="String" Direction="Input" ParameterName="@AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_getByPackList" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByPackList" GetMethodModifier="Public" GetMethodName="getByPackList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByPackList" UserSourceName="getByPackList">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_getByPackList</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="int" DbType="Int32" Direction="Input" ParameterName="@PackListID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_getBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_getBySearch</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="bit" DbType="Boolean" Direction="Input" ParameterName="@FiltDate" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DayRef" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchVal" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_getByUDC" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUdc" GetMethodModifier="Public" GetMethodName="getByUdc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUdc" UserSourceName="getByUdc">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_getByUDC</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="nvarchar" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_insertQuery" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="insertQuery" GetMethodModifier="Public" GetMethodName="insertQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="insertQuery" UserSourceName="insertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_insertQuery</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="datetime" DbType="DateTime" Direction="Input" ParameterName="@DayRef" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSoggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Descr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PackListID" Precision="10" ProviderType="Int" Scale="0" Size="4" 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>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_updatePList" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updatePList" Modifier="Public" Name="updatePList" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="updatePList">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_updatePList</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PackListID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_updateQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Descr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@Peso" Precision="53" ProviderType="Float" Scale="0" Size="8" 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>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EAL_updateStatus" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateStatus" Modifier="Public" Name="updateStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updateStatus">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EAL_updateStatus</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Status" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagClientiTableAdapter" GeneratorDataComponentClassName="AnagClientiTableAdapter" Name="AnagClienti" UserDataComponentName="AnagClientiTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_AnagClienti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM v_AnagClienti</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
<Mapping SourceColumn="Indirizzo" DataSetColumn="Indirizzo" />
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
<Mapping SourceColumn="Provincia" DataSetColumn="Provincia" />
<Mapping SourceColumn="Nazione" DataSetColumn="Nazione" />
<Mapping SourceColumn="IsCli" DataSetColumn="IsCli" />
<Mapping SourceColumn="IsFor" DataSetColumn="IsFor" />
<Mapping SourceColumn="Azienda" DataSetColumn="Azienda" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ACF_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ACF_deleteQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ACF_getBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ACF_getBySearch</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="nvarchar" DbType="String" Direction="Input" ParameterName="@searchVal" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@showCli" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@showFor" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ACF_insertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ACF_insertQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RagSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsCli" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsFor" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ACF_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ACF_updateQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RagSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsCli" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsFor" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencoAL2UDCTableAdapter" GeneratorDataComponentClassName="ElencoAL2UDCTableAdapter" Name="ElencoAL2UDC" UserDataComponentName="ElencoAL2UDCTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.ElencoAL2UDC" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[ElencoAL2UDC] WHERE (([AL] = @Original_AL) AND ([UDC] = @Original_UDC) AND ([OrderListID] = @Original_OrderListID))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AL" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderListID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderListID" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[ElencoAL2UDC] ([AL], [UDC], [OrderListID]) VALUES (@AL, @UDC, @OrderListID);
SELECT AL, UDC, OrderListID FROM ElencoAL2UDC WHERE (AL = @AL) AND (UDC = @UDC)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AL" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderListID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderListID" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT * FROM dbo.ElencoAL2UDC</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[ElencoAL2UDC] SET [AL] = @AL, [UDC] = @UDC, [OrderListID] = @OrderListID WHERE (([AL] = @Original_AL) AND ([UDC] = @Original_UDC) AND ([OrderListID] = @Original_OrderListID));
SELECT AL, UDC, OrderListID FROM ElencoAL2UDC WHERE (AL = @AL) AND (UDC = @UDC)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AL" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderListID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderListID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AL" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderListID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderListID" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="AL" DataSetColumn="AL" />
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
<Mapping SourceColumn="OrderListID" DataSetColumn="OrderListID" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EA2U_resetAL" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="resetAL" Modifier="Public" Name="resetAL" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="resetAL">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EA2U_resetAL</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="nvarchar" DbType="String" Direction="Input" ParameterName="@AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_EA2U_upsertQuery" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="upsertQuery" GetMethodModifier="Public" GetMethodName="upsertQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="upsertQuery" UserSourceName="upsertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EA2U_upsertQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@AL" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@OrderListID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagArticoli2ClientiTableAdapter" GeneratorDataComponentClassName="AnagArticoli2ClientiTableAdapter" Name="AnagArticoli2Clienti" UserDataComponentName="AnagArticoli2ClientiTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.AnagArticoli2Clienti" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT * FROM AnagArticoli2Clienti</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodArt" DataSetColumn="CodArt" />
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
<Mapping SourceColumn="CodArtCliente" DataSetColumn="CodArtCliente" />
<Mapping SourceColumn="DescrArtCliente" DataSetColumn="DescrArtCliente" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_AA2C_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodArt" GetMethodModifier="Public" GetMethodName="getByCodArt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodArt" UserSourceName="getByCodArt">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AA2C_getByKey</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArt" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MacchineTableAdapter" GeneratorDataComponentClassName="MacchineTableAdapter" Name="Macchine" UserDataComponentName="MacchineTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.v_Macchine" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT *
FROM dbo.v_Macchine
</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
<Mapping SourceColumn="CodMacchina" DataSetColumn="CodMacchina" />
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
<Mapping SourceColumn="Descrizione" DataSetColumn="Descrizione" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="url" DataSetColumn="url" />
<Mapping SourceColumn="locazione" DataSetColumn="locazione" />
<Mapping SourceColumn="css" DataSetColumn="css" />
<Mapping SourceColumn="RowNum" DataSetColumn="RowNum" />
<Mapping SourceColumn="ColNum" DataSetColumn="ColNum" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagDestinClientiTableAdapter" GeneratorDataComponentClassName="AnagDestinClientiTableAdapter" Name="AnagDestinClienti" UserDataComponentName="AnagDestinClientiTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.AnagDestinClienti" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [AnagDestinClienti] WHERE (([CodCliente] = @Original_CodCliente) AND ([CodDestinazione] = @Original_CodDestinazione) AND ([DescDestinazione] = @Original_DescDestinazione) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Provincia = 1 AND [Provincia] IS NULL) OR ([Provincia] = @Original_Provincia)) AND ((@IsNull_Nazione = 1 AND [Nazione] IS NULL) OR ([Nazione] = @Original_Nazione)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDestinazione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDestinazione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Localita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Provincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Provincia" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Provincia" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nazione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nazione" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagClienti] ([CodCliente], [RagSociale], [Indirizzo], [Localita], [Cap], [Provincia], [Nazione], [IsCli], [IsFor]) VALUES (@CodCliente, @RagSociale, @Indirizzo, @Localita, @Cap, @Provincia, @Nazione, @IsCli, @IsFor);
SELECT CodCliente, RagSociale, Indirizzo, Localita, Cap, Provincia, Nazione, IsCli, IsFor FROM AnagClienti WHERE (CodCliente = @CodCliente)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RagSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagSociale" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Provincia" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsCli" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsCli" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsFor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsFor" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT * FROM AnagDestinClienti</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [AnagDestinClienti] SET [CodCliente] = @CodCliente, [CodDestinazione] = @CodDestinazione, [DescDestinazione] = @DescDestinazione, [Indirizzo] = @Indirizzo, [Cap] = @Cap, [Localita] = @Localita, [Provincia] = @Provincia, [Nazione] = @Nazione WHERE (([CodCliente] = @Original_CodCliente) AND ([CodDestinazione] = @Original_CodDestinazione) AND ([DescDestinazione] = @Original_DescDestinazione) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Provincia = 1 AND [Provincia] IS NULL) OR ([Provincia] = @Original_Provincia)) AND ((@IsNull_Nazione = 1 AND [Nazione] IS NULL) OR ([Nazione] = @Original_Nazione)));
SELECT CodCliente, CodDestinazione, DescDestinazione, Indirizzo, Cap, Localita, Provincia, Nazione FROM AnagDestinClienti WHERE (CodCliente = @CodCliente) AND (CodDestinazione = @CodDestinazione)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDestinazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDestinazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Provincia" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodDestinazione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDestinazione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Localita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Provincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Provincia" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Provincia" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nazione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nazione" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
<Mapping SourceColumn="CodDestinazione" DataSetColumn="CodDestinazione" />
<Mapping SourceColumn="DescDestinazione" DataSetColumn="DescDestinazione" />
<Mapping SourceColumn="Indirizzo" DataSetColumn="Indirizzo" />
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
<Mapping SourceColumn="Provincia" DataSetColumn="Provincia" />
<Mapping SourceColumn="Nazione" DataSetColumn="Nazione" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ADC_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ADC_deleteQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ADC_getByCodCli" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodCli" GetMethodModifier="Public" GetMethodName="getByCodCli" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodCli" UserSourceName="getByCodCli">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ADC_getByCodCli</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ACF_insertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="true">
<CommandText>dbo.stp_ADC_insertQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_ADC_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ADC_updateQuery</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="nvarchar" DbType="String" Direction="Input" ParameterName="@CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Nazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodDestinazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RegGiacenzeTableAdapter" GeneratorDataComponentClassName="RegGiacenzeTableAdapter" Name="RegGiacenze" UserDataComponentName="RegGiacenzeTableAdapter">
<MainSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.RegGiacenze" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT *
FROM RegGiacenze</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="IdxRG" DataSetColumn="IdxRG" />
<Mapping SourceColumn="IdxOdl" DataSetColumn="IdxOdl" />
<Mapping SourceColumn="IdentRG" DataSetColumn="IdentRG" />
<Mapping SourceColumn="Product" DataSetColumn="Product" />
<Mapping SourceColumn="Variety" DataSetColumn="Variety" />
<Mapping SourceColumn="Supplier" DataSetColumn="Supplier" />
<Mapping SourceColumn="ExtDoc" DataSetColumn="ExtDoc" />
<Mapping SourceColumn="DateRif" DataSetColumn="DateRif" />
<Mapping SourceColumn="QtyTot" DataSetColumn="QtyTot" />
<Mapping SourceColumn="NumPack" DataSetColumn="NumPack" />
<Mapping SourceColumn="Notes" DataSetColumn="Notes" />
</Mappings>
<Sources>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_RG_DeleteByOdl" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DeleteByOdl" Modifier="Public" Name="DeleteByOdl" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DeleteByOdl">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_RG_DeleteByOdl</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="int" DbType="Int32" Direction="Input" ParameterName="@IdxOdl" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_RG_InsertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_RG_InsertQuery</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="int" DbType="Int32" Direction="Input" ParameterName="@IdxOdl" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdentRG" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Product" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Variety" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Supplier" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ExtDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DateRif" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@QtyTot" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumPack" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DS_Mag" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DS_Mag" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Mag">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="ElencoLotti" msprop:Generator_RowEvHandlerName="ElencoLottiRowChangeEventHandler" msprop:Generator_RowDeletedName="ElencoLottiRowDeleted" msprop:Generator_RowDeletingName="ElencoLottiRowDeleting" msprop:Generator_RowEvArgName="ElencoLottiRowChangeEvent" msprop:Generator_TablePropName="ElencoLotti" msprop:Generator_RowChangedName="ElencoLottiRowChanged" msprop:Generator_UserTableName="ElencoLotti" msprop:Generator_RowChangingName="ElencoLottiRowChanging" msprop:Generator_RowClassName="ElencoLottiRow" msprop:Generator_TableClassName="ElencoLottiDataTable" msprop:Generator_TableVarName="tableElencoLotti">
<xs:complexType>
<xs:sequence>
<xs:element name="Lotto" msprop:Generator_ColumnPropNameInTable="LottoColumn" msprop:Generator_ColumnPropNameInRow="Lotto" msprop:Generator_UserColumnName="Lotto" msprop:Generator_ColumnVarNameInTable="columnLotto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IdxODL" msprop:Generator_ColumnPropNameInTable="IdxODLColumn" msprop:Generator_ColumnPropNameInRow="IdxODL" msprop:Generator_UserColumnName="IdxODL" msprop:Generator_ColumnVarNameInTable="columnIdxODL" type="xs:int" />
<xs:element name="RifExt" msprop:Generator_ColumnPropNameInTable="RifExtColumn" msprop:Generator_ColumnPropNameInRow="RifExt" msprop:Generator_UserColumnName="RifExt" msprop:Generator_ColumnVarNameInTable="columnRifExt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TipoLotto" msprop:Generator_ColumnPropNameInTable="TipoLottoColumn" msprop:Generator_ColumnPropNameInRow="TipoLotto" msprop:Generator_UserColumnName="TipoLotto" msprop:Generator_ColumnVarNameInTable="columnTipoLotto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_UserColumnName="CodArt" msprop:Generator_ColumnVarNameInTable="columnCodArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_UserColumnName="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Origine" msprop:Generator_ColumnPropNameInTable="OrigineColumn" msprop:Generator_ColumnPropNameInRow="Origine" msprop:Generator_UserColumnName="Origine" msprop:Generator_ColumnVarNameInTable="columnOrigine">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DtCrea" msprop:Generator_ColumnPropNameInTable="DtCreaColumn" msprop:Generator_ColumnPropNameInRow="DtCrea" msprop:Generator_UserColumnName="DtCrea" msprop:Generator_ColumnVarNameInTable="columnDtCrea" type="xs:dateTime" />
<xs:element name="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QtaOrig" msprop:Generator_ColumnPropNameInTable="QtaOrigColumn" msprop:Generator_ColumnPropNameInRow="QtaOrig" msprop:Generator_UserColumnName="QtaOrig" msprop:Generator_ColumnVarNameInTable="columnQtaOrig" type="xs:decimal" />
<xs:element name="NumUdc" msprop:Generator_ColumnPropNameInTable="NumUdcColumn" msprop:Generator_ColumnPropNameInRow="NumUdc" msprop:Generator_UserColumnName="NumUdc" msprop:Generator_ColumnVarNameInTable="columnNumUdc" type="xs:int" />
<xs:element name="QtaCurr" msprop:Generator_ColumnPropNameInTable="QtaCurrColumn" msprop:Generator_ColumnPropNameInRow="QtaCurr" msprop:Generator_UserColumnName="QtaCurr" msprop:Generator_ColumnVarNameInTable="columnQtaCurr" type="xs:decimal" />
<xs:element name="DtMod" msprop:Generator_ColumnPropNameInTable="DtModColumn" msprop:Generator_ColumnPropNameInRow="DtMod" msprop:Generator_UserColumnName="DtMod" msprop:Generator_ColumnVarNameInTable="columnDtMod" type="xs:dateTime" />
<xs:element name="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_UserColumnName="Attivo" msprop:Generator_ColumnVarNameInTable="columnAttivo" type="xs:boolean" />
<xs:element name="DescrArt" msprop:Generator_ColumnPropNameInTable="DescrArtColumn" msprop:Generator_ColumnPropNameInRow="DescrArt" msprop:Generator_UserColumnName="DescrArt" msprop:Generator_ColumnVarNameInTable="columnDescrArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodArtExt" msprop:Generator_ColumnPropNameInTable="CodArtExtColumn" msprop:Generator_ColumnPropNameInRow="CodArtExt" msprop:Generator_UserColumnName="CodArtExt" msprop:Generator_ColumnVarNameInTable="columnCodArtExt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescStato" msprop:Generator_ColumnPropNameInTable="DescStatoColumn" msprop:Generator_ColumnPropNameInRow="DescStato" msprop:Generator_UserColumnName="DescStato" msprop:Generator_ColumnVarNameInTable="columnDescStato" 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="ElencoUdc" msprop:Generator_RowEvHandlerName="ElencoUdcRowChangeEventHandler" msprop:Generator_RowDeletedName="ElencoUdcRowDeleted" msprop:Generator_RowDeletingName="ElencoUdcRowDeleting" msprop:Generator_RowEvArgName="ElencoUdcRowChangeEvent" msprop:Generator_TablePropName="ElencoUdc" msprop:Generator_RowChangedName="ElencoUdcRowChanged" msprop:Generator_UserTableName="ElencoUdc" msprop:Generator_RowChangingName="ElencoUdcRowChanging" msprop:Generator_RowClassName="ElencoUdcRow" msprop:Generator_TableClassName="ElencoUdcDataTable" msprop:Generator_TableVarName="tableElencoUdc">
<xs:complexType>
<xs:sequence>
<xs:element name="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Lotto" msprop:Generator_ColumnPropNameInTable="LottoColumn" msprop:Generator_ColumnPropNameInRow="Lotto" msprop:Generator_UserColumnName="Lotto" msprop:Generator_ColumnVarNameInTable="columnLotto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_UserColumnName="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodPost" msprop:Generator_ColumnPropNameInTable="CodPostColumn" msprop:Generator_ColumnPropNameInRow="CodPost" msprop:Generator_UserColumnName="CodPost" msprop:Generator_ColumnVarNameInTable="columnCodPost" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DtRec" msprop:Generator_ColumnPropNameInTable="DtRecColumn" msprop:Generator_ColumnPropNameInRow="DtRec" msprop:Generator_UserColumnName="DtRec" msprop:Generator_ColumnVarNameInTable="columnDtRec" type="xs:dateTime" minOccurs="0" />
<xs:element name="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_UserColumnName="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" type="xs:decimal" minOccurs="0" />
<xs:element name="NumCont" msprop:Generator_ColumnPropNameInTable="NumContColumn" msprop:Generator_ColumnPropNameInRow="NumCont" msprop:Generator_UserColumnName="NumCont" msprop:Generator_ColumnVarNameInTable="columnNumCont" type="xs:int" minOccurs="0" />
<xs:element name="CodSoggetto" msprop:Generator_ColumnPropNameInTable="CodSoggettoColumn" msprop:Generator_ColumnPropNameInRow="CodSoggetto" msprop:Generator_UserColumnName="CodSoggetto" msprop:Generator_ColumnVarNameInTable="columnCodSoggetto" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PesoTot" msprop:Generator_ColumnPropNameInTable="PesoTotColumn" msprop:Generator_ColumnPropNameInRow="PesoTot" msprop:Generator_UserColumnName="PesoTot" msprop:Generator_ColumnVarNameInTable="columnPesoTot" type="xs:decimal" minOccurs="0" />
<xs:element name="PesoCad" msprop:Generator_ColumnPropNameInTable="PesoCadColumn" msprop:Generator_ColumnPropNameInRow="PesoCad" msprop:Generator_UserColumnName="PesoCad" msprop:Generator_ColumnVarNameInTable="columnPesoCad" type="xs:decimal" minOccurs="0" />
<xs:element name="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_UserColumnName="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" type="xs:decimal" minOccurs="0" />
<xs:element name="CodImballo" msprop:Generator_ColumnPropNameInTable="CodImballoColumn" msprop:Generator_ColumnPropNameInRow="CodImballo" msprop:Generator_UserColumnName="CodImballo" msprop:Generator_ColumnVarNameInTable="columnCodImballo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IdxPosizione" msprop:Generator_ColumnPropNameInTable="IdxPosizioneColumn" msprop:Generator_ColumnPropNameInRow="IdxPosizione" msprop:Generator_UserColumnName="IdxPosizione" msprop:Generator_ColumnVarNameInTable="columnIdxPosizione" type="xs:int" minOccurs="0" />
<xs:element name="DtMod" msprop:Generator_ColumnPropNameInTable="DtModColumn" msprop:Generator_ColumnPropNameInRow="DtMod" msprop:Generator_UserColumnName="DtMod" msprop:Generator_ColumnVarNameInTable="columnDtMod" type="xs:dateTime" minOccurs="0" />
<xs:element name="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TipoLotto" msprop:Generator_ColumnPropNameInTable="TipoLottoColumn" msprop:Generator_ColumnPropNameInRow="TipoLotto" msprop:Generator_UserColumnName="TipoLotto" msprop:Generator_ColumnVarNameInTable="columnTipoLotto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_UserColumnName="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Origine" msprop:Generator_ColumnPropNameInTable="OrigineColumn" msprop:Generator_ColumnPropNameInRow="Origine" msprop:Generator_UserColumnName="Origine" msprop:Generator_ColumnVarNameInTable="columnOrigine">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DtCrea" msprop:Generator_ColumnPropNameInTable="DtCreaColumn" msprop:Generator_ColumnPropNameInRow="DtCrea" msprop:Generator_UserColumnName="DtCrea" msprop:Generator_ColumnVarNameInTable="columnDtCrea" type="xs:dateTime" />
<xs:element name="NoteLotto" msprop:Generator_ColumnPropNameInTable="NoteLottoColumn" msprop:Generator_ColumnPropNameInRow="NoteLotto" msprop:Generator_UserColumnName="NoteLotto" msprop:Generator_ColumnVarNameInTable="columnNoteLotto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_UserColumnName="RagSociale" msprop:Generator_ColumnVarNameInTable="columnRagSociale">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Indirizzo" msprop:Generator_ColumnPropNameInTable="IndirizzoColumn" msprop:Generator_ColumnPropNameInRow="Indirizzo" msprop:Generator_UserColumnName="Indirizzo" msprop:Generator_ColumnVarNameInTable="columnIndirizzo">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_UserColumnName="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_UserColumnName="Cap" msprop:Generator_ColumnVarNameInTable="columnCap">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Provincia" msprop:Generator_ColumnPropNameInTable="ProvinciaColumn" msprop:Generator_ColumnPropNameInRow="Provincia" msprop:Generator_UserColumnName="Provincia" msprop:Generator_ColumnVarNameInTable="columnProvincia">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Nazione" msprop:Generator_ColumnPropNameInTable="NazioneColumn" msprop:Generator_ColumnPropNameInRow="Nazione" msprop:Generator_UserColumnName="Nazione" msprop:Generator_ColumnVarNameInTable="columnNazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_UserColumnName="CodArt" msprop:Generator_ColumnVarNameInTable="columnCodArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrArt" msprop:Generator_ColumnPropNameInTable="DescrArtColumn" msprop:Generator_ColumnPropNameInRow="DescrArt" msprop:Generator_UserColumnName="DescrArt" msprop:Generator_ColumnVarNameInTable="columnDescrArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodArtExt" msprop:Generator_ColumnPropNameInTable="CodArtExtColumn" msprop:Generator_ColumnPropNameInRow="CodArtExt" msprop:Generator_UserColumnName="CodArtExt" msprop:Generator_ColumnVarNameInTable="columnCodArtExt">
<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="AnagArt" msprop:Generator_RowEvHandlerName="AnagArtRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagArtRowDeleted" msprop:Generator_RowDeletingName="AnagArtRowDeleting" msprop:Generator_RowEvArgName="AnagArtRowChangeEvent" msprop:Generator_TablePropName="AnagArt" msprop:Generator_RowChangedName="AnagArtRowChanged" msprop:Generator_UserTableName="AnagArt" msprop:Generator_RowChangingName="AnagArtRowChanging" msprop:Generator_RowClassName="AnagArtRow" msprop:Generator_TableClassName="AnagArtDataTable" msprop:Generator_TableVarName="tableAnagArt">
<xs:complexType>
<xs:sequence>
<xs:element name="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_UserColumnName="CodArt" msprop:Generator_ColumnVarNameInTable="columnCodArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrArt" msprop:Generator_ColumnPropNameInTable="DescrArtColumn" msprop:Generator_ColumnPropNameInRow="DescrArt" msprop:Generator_UserColumnName="DescrArt" msprop:Generator_ColumnVarNameInTable="columnDescrArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodArtExt" msprop:Generator_ColumnPropNameInTable="CodArtExtColumn" msprop:Generator_ColumnPropNameInRow="CodArtExt" msprop:Generator_UserColumnName="CodArtExt" msprop:Generator_ColumnVarNameInTable="columnCodArtExt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_UserColumnName="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato">
<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="ODL" msprop:Generator_RowEvHandlerName="ODLRowChangeEventHandler" msprop:Generator_RowDeletedName="ODLRowDeleted" msprop:Generator_RowDeletingName="ODLRowDeleting" msprop:Generator_RowEvArgName="ODLRowChangeEvent" msprop:Generator_TablePropName="ODL" msprop:Generator_RowChangedName="ODLRowChanged" msprop:Generator_UserTableName="ODL" msprop:Generator_RowChangingName="ODLRowChanging" msprop:Generator_RowClassName="ODLRow" msprop:Generator_TableClassName="ODLDataTable" msprop:Generator_TableVarName="tableODL">
<xs:complexType>
<xs:sequence>
<xs:element name="IdxODL" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdxODLColumn" msprop:Generator_ColumnPropNameInRow="IdxODL" msprop:Generator_UserColumnName="IdxODL" msprop:Generator_ColumnVarNameInTable="columnIdxODL" type="xs:int" />
<xs:element name="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_UserColumnName="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_UserColumnName="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NumPezzi" msprop:Generator_ColumnPropNameInTable="NumPezziColumn" msprop:Generator_ColumnPropNameInRow="NumPezzi" msprop:Generator_UserColumnName="NumPezzi" msprop:Generator_ColumnVarNameInTable="columnNumPezzi" type="xs:int" />
<xs:element name="TCAssegnato" msprop:Generator_ColumnPropNameInTable="TCAssegnatoColumn" msprop:Generator_ColumnPropNameInRow="TCAssegnato" msprop:Generator_UserColumnName="TCAssegnato" msprop:Generator_ColumnVarNameInTable="columnTCAssegnato" type="xs:decimal" />
<xs:element name="DataInizio" msprop:Generator_ColumnPropNameInTable="DataInizioColumn" msprop:Generator_ColumnPropNameInRow="DataInizio" msprop:Generator_UserColumnName="DataInizio" msprop:Generator_ColumnVarNameInTable="columnDataInizio" type="xs:dateTime" minOccurs="0" />
<xs:element name="DataFine" msprop:Generator_ColumnPropNameInTable="DataFineColumn" msprop:Generator_ColumnPropNameInRow="DataFine" msprop:Generator_UserColumnName="DataFine" msprop:Generator_ColumnVarNameInTable="columnDataFine" type="xs:dateTime" minOccurs="0" />
<xs:element name="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NeedAppr" msprop:Generator_ColumnPropNameInTable="NeedApprColumn" msprop:Generator_ColumnPropNameInRow="NeedAppr" msprop:Generator_UserColumnName="NeedAppr" msprop:Generator_ColumnVarNameInTable="columnNeedAppr" type="xs:boolean" />
<xs:element name="UserAppr" msprop:Generator_ColumnPropNameInTable="UserApprColumn" msprop:Generator_ColumnPropNameInRow="UserAppr" msprop:Generator_UserColumnName="UserAppr" msprop:Generator_ColumnVarNameInTable="columnUserAppr" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DataAppr" msprop:Generator_ColumnPropNameInTable="DataApprColumn" msprop:Generator_ColumnPropNameInRow="DataAppr" msprop:Generator_UserColumnName="DataAppr" msprop:Generator_ColumnVarNameInTable="columnDataAppr" type="xs:dateTime" minOccurs="0" />
<xs:element name="TCRichAttr" msprop:Generator_ColumnPropNameInTable="TCRichAttrColumn" msprop:Generator_ColumnPropNameInRow="TCRichAttr" msprop:Generator_UserColumnName="TCRichAttr" msprop:Generator_ColumnVarNameInTable="columnTCRichAttr" type="xs:decimal" minOccurs="0" />
<xs:element name="KeyRichiesta" msprop:Generator_ColumnPropNameInTable="KeyRichiestaColumn" msprop:Generator_ColumnPropNameInRow="KeyRichiesta" msprop:Generator_UserColumnName="KeyRichiesta" msprop:Generator_ColumnVarNameInTable="columnKeyRichiesta">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PzPallet" msprop:Generator_ColumnPropNameInTable="PzPalletColumn" msprop:Generator_ColumnPropNameInRow="PzPallet" msprop:Generator_UserColumnName="PzPallet" msprop:Generator_ColumnVarNameInTable="columnPzPallet" type="xs:int" />
<xs:element name="provvisorio" msprop:Generator_ColumnPropNameInTable="provvisorioColumn" msprop:Generator_ColumnPropNameInRow="provvisorio" msprop:Generator_UserColumnName="provvisorio" msprop:Generator_ColumnVarNameInTable="columnprovvisorio" type="xs:boolean" />
<xs:element name="MatrOpr" msprop:Generator_ColumnPropNameInTable="MatrOprColumn" msprop:Generator_ColumnPropNameInRow="MatrOpr" msprop:Generator_UserColumnName="MatrOpr" msprop:Generator_ColumnVarNameInTable="columnMatrOpr" type="xs:int" />
<xs:element name="CommessaAs400" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="CommessaAs400Column" msprop:Generator_ColumnPropNameInRow="CommessaAs400" msprop:Generator_UserColumnName="CommessaAs400" msprop:Generator_ColumnVarNameInTable="columnCommessaAs400" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ToAs400" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="ToAs400Column" msprop:Generator_ColumnPropNameInRow="ToAs400" msprop:Generator_UserColumnName="ToAs400" msprop:Generator_ColumnVarNameInTable="columnToAs400" type="xs:int" minOccurs="0" />
<xs:element name="CodCli" msprop:Generator_ColumnPropNameInTable="CodCliColumn" msprop:Generator_ColumnPropNameInRow="CodCli" msprop:Generator_UserColumnName="CodCli" msprop:Generator_ColumnVarNameInTable="columnCodCli">
<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="Elencopost2Queue" msprop:Generator_RowEvHandlerName="Elencopost2QueueRowChangeEventHandler" msprop:Generator_RowDeletedName="Elencopost2QueueRowDeleted" msprop:Generator_RowDeletingName="Elencopost2QueueRowDeleting" msprop:Generator_RowEvArgName="Elencopost2QueueRowChangeEvent" msprop:Generator_TablePropName="Elencopost2Queue" msprop:Generator_RowChangedName="Elencopost2QueueRowChanged" msprop:Generator_UserTableName="Elencopost2Queue" msprop:Generator_RowChangingName="Elencopost2QueueRowChanging" msprop:Generator_RowClassName="Elencopost2QueueRow" msprop:Generator_TableClassName="Elencopost2QueueDataTable" msprop:Generator_TableVarName="tableElencopost2Queue">
<xs:complexType>
<xs:sequence>
<xs:element name="CodPost" msprop:Generator_ColumnPropNameInTable="CodPostColumn" msprop:Generator_ColumnPropNameInRow="CodPost" msprop:Generator_UserColumnName="CodPost" msprop:Generator_ColumnVarNameInTable="columnCodPost">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PrintQueue" msprop:Generator_ColumnPropNameInTable="PrintQueueColumn" msprop:Generator_ColumnPropNameInRow="PrintQueue" msprop:Generator_UserColumnName="PrintQueue" msprop:Generator_ColumnVarNameInTable="columnPrintQueue">
<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="ElencoAL" msprop:Generator_RowEvHandlerName="ElencoALRowChangeEventHandler" msprop:Generator_RowDeletedName="ElencoALRowDeleted" msprop:Generator_RowDeletingName="ElencoALRowDeleting" msprop:Generator_RowEvArgName="ElencoALRowChangeEvent" msprop:Generator_TablePropName="ElencoAL" msprop:Generator_RowChangedName="ElencoALRowChanged" msprop:Generator_UserTableName="ElencoAL" msprop:Generator_RowChangingName="ElencoALRowChanging" msprop:Generator_RowClassName="ElencoALRow" msprop:Generator_TableClassName="ElencoALDataTable" msprop:Generator_TableVarName="tableElencoAL">
<xs:complexType>
<xs:sequence>
<xs:element name="AL" msprop:Generator_ColumnPropNameInTable="ALColumn" msprop:Generator_ColumnPropNameInRow="AL" msprop:Generator_UserColumnName="AL" msprop:Generator_ColumnVarNameInTable="columnAL">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Descr" msprop:Generator_ColumnPropNameInTable="DescrColumn" msprop:Generator_ColumnPropNameInRow="Descr" msprop:Generator_UserColumnName="Descr" msprop:Generator_ColumnVarNameInTable="columnDescr">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PackListID" msprop:Generator_ColumnPropNameInTable="PackListIDColumn" msprop:Generator_ColumnPropNameInRow="PackListID" msprop:Generator_UserColumnName="PackListID" msprop:Generator_ColumnVarNameInTable="columnPackListID" type="xs:int" />
<xs:element name="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" type="xs:int" />
<xs:element name="DtRec" msprop:Generator_ColumnPropNameInTable="DtRecColumn" msprop:Generator_ColumnPropNameInRow="DtRec" msprop:Generator_UserColumnName="DtRec" msprop:Generator_ColumnVarNameInTable="columnDtRec" type="xs:dateTime" />
<xs:element name="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_UserColumnName="Peso" msprop:Generator_ColumnVarNameInTable="columnPeso" type="xs:decimal" />
<xs:element name="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_UserColumnName="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" type="xs:decimal" />
<xs:element name="CodSoggetto" msprop:Generator_ColumnPropNameInTable="CodSoggettoColumn" msprop:Generator_ColumnPropNameInRow="CodSoggetto" msprop:Generator_UserColumnName="CodSoggetto" msprop:Generator_ColumnVarNameInTable="columnCodSoggetto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QtaUdc" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="QtaUdcColumn" msprop:Generator_ColumnPropNameInRow="QtaUdc" msprop:Generator_UserColumnName="QtaUdc" msprop:Generator_ColumnVarNameInTable="columnQtaUdc" type="xs:decimal" minOccurs="0" />
<xs:element name="NumUdc" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="NumUdcColumn" msprop:Generator_ColumnPropNameInRow="NumUdc" msprop:Generator_UserColumnName="NumUdc" msprop:Generator_ColumnVarNameInTable="columnNumUdc" type="xs:int" minOccurs="0" />
<xs:element name="PesoUdc" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="PesoUdcColumn" msprop:Generator_ColumnPropNameInRow="PesoUdc" msprop:Generator_UserColumnName="PesoUdc" msprop:Generator_ColumnVarNameInTable="columnPesoUdc" type="xs:decimal" minOccurs="0" />
<xs:element name="TaraUdc" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="TaraUdcColumn" msprop:Generator_ColumnPropNameInRow="TaraUdc" msprop:Generator_UserColumnName="TaraUdc" msprop:Generator_ColumnVarNameInTable="columnTaraUdc" type="xs:decimal" minOccurs="0" />
<xs:element name="CurrState" msprop:Generator_ColumnPropNameInTable="CurrStateColumn" msprop:Generator_ColumnPropNameInRow="CurrState" msprop:Generator_UserColumnName="CurrState" msprop:Generator_ColumnVarNameInTable="columnCurrState" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagClienti" msprop:Generator_RowEvHandlerName="AnagClientiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagClientiRowDeleted" msprop:Generator_RowDeletingName="AnagClientiRowDeleting" msprop:Generator_RowEvArgName="AnagClientiRowChangeEvent" msprop:Generator_TablePropName="AnagClienti" msprop:Generator_RowChangedName="AnagClientiRowChanged" msprop:Generator_UserTableName="AnagClienti" msprop:Generator_RowChangingName="AnagClientiRowChanging" msprop:Generator_RowClassName="AnagClientiRow" msprop:Generator_TableClassName="AnagClientiDataTable" msprop:Generator_TableVarName="tableAnagClienti">
<xs:complexType>
<xs:sequence>
<xs:element name="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_UserColumnName="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_UserColumnName="RagSociale" msprop:Generator_ColumnVarNameInTable="columnRagSociale">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Indirizzo" msprop:Generator_ColumnPropNameInTable="IndirizzoColumn" msprop:Generator_ColumnPropNameInRow="Indirizzo" msprop:Generator_UserColumnName="Indirizzo" msprop:Generator_ColumnVarNameInTable="columnIndirizzo">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_UserColumnName="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_UserColumnName="Cap" msprop:Generator_ColumnVarNameInTable="columnCap">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Provincia" msprop:Generator_ColumnPropNameInTable="ProvinciaColumn" msprop:Generator_ColumnPropNameInRow="Provincia" msprop:Generator_UserColumnName="Provincia" msprop:Generator_ColumnVarNameInTable="columnProvincia">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Nazione" msprop:Generator_ColumnPropNameInTable="NazioneColumn" msprop:Generator_ColumnPropNameInRow="Nazione" msprop:Generator_UserColumnName="Nazione" msprop:Generator_ColumnVarNameInTable="columnNazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IsCli" msprop:Generator_ColumnPropNameInTable="IsCliColumn" msprop:Generator_ColumnPropNameInRow="IsCli" msprop:Generator_UserColumnName="IsCli" msprop:Generator_ColumnVarNameInTable="columnIsCli" type="xs:boolean" />
<xs:element name="IsFor" msprop:Generator_ColumnPropNameInTable="IsForColumn" msprop:Generator_ColumnPropNameInRow="IsFor" msprop:Generator_UserColumnName="IsFor" msprop:Generator_ColumnVarNameInTable="columnIsFor" type="xs:boolean" />
<xs:element name="Azienda" msprop:Generator_UserColumnName="Azienda" msprop:Generator_ColumnPropNameInTable="AziendaColumn" msprop:Generator_ColumnPropNameInRow="Azienda" msprop:Generator_ColumnVarNameInTable="columnAzienda">
<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="ElencoAL2UDC" msprop:Generator_RowEvHandlerName="ElencoAL2UDCRowChangeEventHandler" msprop:Generator_RowDeletedName="ElencoAL2UDCRowDeleted" msprop:Generator_RowDeletingName="ElencoAL2UDCRowDeleting" msprop:Generator_RowEvArgName="ElencoAL2UDCRowChangeEvent" msprop:Generator_TablePropName="ElencoAL2UDC" msprop:Generator_RowChangedName="ElencoAL2UDCRowChanged" msprop:Generator_UserTableName="ElencoAL2UDC" msprop:Generator_RowChangingName="ElencoAL2UDCRowChanging" msprop:Generator_RowClassName="ElencoAL2UDCRow" msprop:Generator_TableClassName="ElencoAL2UDCDataTable" msprop:Generator_TableVarName="tableElencoAL2UDC">
<xs:complexType>
<xs:sequence>
<xs:element name="AL" msprop:Generator_ColumnPropNameInTable="ALColumn" msprop:Generator_ColumnPropNameInRow="AL" msprop:Generator_UserColumnName="AL" msprop:Generator_ColumnVarNameInTable="columnAL">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="OrderListID" msprop:Generator_ColumnPropNameInTable="OrderListIDColumn" msprop:Generator_ColumnPropNameInRow="OrderListID" msprop:Generator_UserColumnName="OrderListID" msprop:Generator_ColumnVarNameInTable="columnOrderListID" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagArticoli2Clienti" msprop:Generator_RowEvHandlerName="AnagArticoli2ClientiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagArticoli2ClientiRowDeleted" msprop:Generator_RowDeletingName="AnagArticoli2ClientiRowDeleting" msprop:Generator_RowEvArgName="AnagArticoli2ClientiRowChangeEvent" msprop:Generator_TablePropName="AnagArticoli2Clienti" msprop:Generator_RowChangedName="AnagArticoli2ClientiRowChanged" msprop:Generator_UserTableName="AnagArticoli2Clienti" msprop:Generator_RowChangingName="AnagArticoli2ClientiRowChanging" msprop:Generator_RowClassName="AnagArticoli2ClientiRow" msprop:Generator_TableClassName="AnagArticoli2ClientiDataTable" msprop:Generator_TableVarName="tableAnagArticoli2Clienti">
<xs:complexType>
<xs:sequence>
<xs:element name="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_UserColumnName="CodArt" msprop:Generator_ColumnVarNameInTable="columnCodArt">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_UserColumnName="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodArtCliente" msprop:Generator_ColumnPropNameInTable="CodArtClienteColumn" msprop:Generator_ColumnPropNameInRow="CodArtCliente" msprop:Generator_UserColumnName="CodArtCliente" msprop:Generator_ColumnVarNameInTable="columnCodArtCliente">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrArtCliente" msprop:Generator_ColumnPropNameInTable="DescrArtClienteColumn" msprop:Generator_ColumnPropNameInRow="DescrArtCliente" msprop:Generator_UserColumnName="DescrArtCliente" msprop:Generator_ColumnVarNameInTable="columnDescrArtCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Macchine" msprop:Generator_RowEvHandlerName="MacchineRowChangeEventHandler" msprop:Generator_RowDeletedName="MacchineRowDeleted" msprop:Generator_RowDeletingName="MacchineRowDeleting" msprop:Generator_RowEvArgName="MacchineRowChangeEvent" msprop:Generator_TablePropName="Macchine" msprop:Generator_RowChangedName="MacchineRowChanged" msprop:Generator_UserTableName="Macchine" msprop:Generator_RowChangingName="MacchineRowChanging" msprop:Generator_RowClassName="MacchineRow" msprop:Generator_TableClassName="MacchineDataTable" msprop:Generator_TableVarName="tableMacchine">
<xs:complexType>
<xs:sequence>
<xs:element name="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_UserColumnName="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodMacchina" msprop:Generator_ColumnPropNameInTable="CodMacchinaColumn" msprop:Generator_ColumnPropNameInRow="CodMacchina" msprop:Generator_UserColumnName="CodMacchina" msprop:Generator_ColumnVarNameInTable="columnCodMacchina" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Descrizione" msprop:Generator_ColumnPropNameInTable="DescrizioneColumn" msprop:Generator_ColumnPropNameInRow="Descrizione" msprop:Generator_UserColumnName="Descrizione" msprop:Generator_ColumnVarNameInTable="columnDescrizione" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="url" msprop:Generator_ColumnPropNameInTable="urlColumn" msprop:Generator_ColumnPropNameInRow="url" msprop:Generator_UserColumnName="url" msprop:Generator_ColumnVarNameInTable="columnurl" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="locazione" msprop:Generator_ColumnPropNameInTable="locazioneColumn" msprop:Generator_ColumnPropNameInRow="locazione" msprop:Generator_UserColumnName="locazione" msprop:Generator_ColumnVarNameInTable="columnlocazione" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="css" msprop:Generator_ColumnPropNameInTable="cssColumn" msprop:Generator_ColumnPropNameInRow="css" msprop:Generator_UserColumnName="css" msprop:Generator_ColumnVarNameInTable="columncss">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="RowNum" msprop:Generator_ColumnPropNameInTable="RowNumColumn" msprop:Generator_ColumnPropNameInRow="RowNum" msprop:Generator_UserColumnName="RowNum" msprop:Generator_ColumnVarNameInTable="columnRowNum" type="xs:int" />
<xs:element name="ColNum" msprop:Generator_ColumnPropNameInTable="ColNumColumn" msprop:Generator_ColumnPropNameInRow="ColNum" msprop:Generator_UserColumnName="ColNum" msprop:Generator_ColumnVarNameInTable="columnColNum" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagDestinClienti" msprop:Generator_RowEvHandlerName="AnagDestinClientiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagDestinClientiRowDeleted" msprop:Generator_RowDeletingName="AnagDestinClientiRowDeleting" msprop:Generator_RowEvArgName="AnagDestinClientiRowChangeEvent" msprop:Generator_TablePropName="AnagDestinClienti" msprop:Generator_RowChangedName="AnagDestinClientiRowChanged" msprop:Generator_UserTableName="AnagDestinClienti" msprop:Generator_RowChangingName="AnagDestinClientiRowChanging" msprop:Generator_RowClassName="AnagDestinClientiRow" msprop:Generator_TableClassName="AnagDestinClientiDataTable" msprop:Generator_TableVarName="tableAnagDestinClienti">
<xs:complexType>
<xs:sequence>
<xs:element name="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_UserColumnName="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodDestinazione" msprop:Generator_ColumnPropNameInTable="CodDestinazioneColumn" msprop:Generator_ColumnPropNameInRow="CodDestinazione" msprop:Generator_UserColumnName="CodDestinazione" msprop:Generator_ColumnVarNameInTable="columnCodDestinazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescDestinazione" msprop:Generator_ColumnPropNameInTable="DescDestinazioneColumn" msprop:Generator_ColumnPropNameInRow="DescDestinazione" msprop:Generator_UserColumnName="DescDestinazione" msprop:Generator_ColumnVarNameInTable="columnDescDestinazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Indirizzo" msprop:Generator_ColumnPropNameInTable="IndirizzoColumn" msprop:Generator_ColumnPropNameInRow="Indirizzo" msprop:Generator_UserColumnName="Indirizzo" msprop:Generator_ColumnVarNameInTable="columnIndirizzo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_UserColumnName="Cap" msprop:Generator_ColumnVarNameInTable="columnCap" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_UserColumnName="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Provincia" msprop:Generator_ColumnPropNameInTable="ProvinciaColumn" msprop:Generator_ColumnPropNameInRow="Provincia" msprop:Generator_UserColumnName="Provincia" msprop:Generator_ColumnVarNameInTable="columnProvincia" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Nazione" msprop:Generator_ColumnPropNameInTable="NazioneColumn" msprop:Generator_ColumnPropNameInRow="Nazione" msprop:Generator_UserColumnName="Nazione" msprop:Generator_ColumnVarNameInTable="columnNazione" 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="RegGiacenze" msprop:Generator_RowEvHandlerName="RegGiacenzeRowChangeEventHandler" msprop:Generator_RowDeletedName="RegGiacenzeRowDeleted" msprop:Generator_RowDeletingName="RegGiacenzeRowDeleting" msprop:Generator_RowEvArgName="RegGiacenzeRowChangeEvent" msprop:Generator_TablePropName="RegGiacenze" msprop:Generator_RowChangedName="RegGiacenzeRowChanged" msprop:Generator_RowChangingName="RegGiacenzeRowChanging" msprop:Generator_TableClassName="RegGiacenzeDataTable" msprop:Generator_RowClassName="RegGiacenzeRow" msprop:Generator_TableVarName="tableRegGiacenze" msprop:Generator_UserTableName="RegGiacenze">
<xs:complexType>
<xs:sequence>
<xs:element name="IdxRG" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdxRG" msprop:Generator_ColumnPropNameInTable="IdxRGColumn" msprop:Generator_ColumnVarNameInTable="columnIdxRG" msprop:Generator_UserColumnName="IdxRG" type="xs:int" />
<xs:element name="IdxOdl" msprop:Generator_ColumnPropNameInRow="IdxOdl" msprop:Generator_ColumnPropNameInTable="IdxOdlColumn" msprop:Generator_ColumnVarNameInTable="columnIdxOdl" msprop:Generator_UserColumnName="IdxOdl" type="xs:int" />
<xs:element name="IdentRG" msprop:Generator_ColumnPropNameInRow="IdentRG" msprop:Generator_ColumnPropNameInTable="IdentRGColumn" msprop:Generator_ColumnVarNameInTable="columnIdentRG" msprop:Generator_UserColumnName="IdentRG">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Product" msprop:Generator_ColumnPropNameInRow="Product" msprop:Generator_ColumnPropNameInTable="ProductColumn" msprop:Generator_ColumnVarNameInTable="columnProduct" msprop:Generator_UserColumnName="Product">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Variety" msprop:Generator_ColumnPropNameInRow="Variety" msprop:Generator_ColumnPropNameInTable="VarietyColumn" msprop:Generator_ColumnVarNameInTable="columnVariety" msprop:Generator_UserColumnName="Variety">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Supplier" msprop:Generator_ColumnPropNameInRow="Supplier" msprop:Generator_ColumnPropNameInTable="SupplierColumn" msprop:Generator_ColumnVarNameInTable="columnSupplier" msprop:Generator_UserColumnName="Supplier">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ExtDoc" msprop:Generator_ColumnPropNameInRow="ExtDoc" msprop:Generator_ColumnPropNameInTable="ExtDocColumn" msprop:Generator_ColumnVarNameInTable="columnExtDoc" msprop:Generator_UserColumnName="ExtDoc">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DateRif" msprop:Generator_ColumnPropNameInRow="DateRif" msprop:Generator_ColumnPropNameInTable="DateRifColumn" msprop:Generator_ColumnVarNameInTable="columnDateRif" msprop:Generator_UserColumnName="DateRif" type="xs:dateTime" />
<xs:element name="QtyTot" msprop:Generator_ColumnPropNameInRow="QtyTot" msprop:Generator_ColumnPropNameInTable="QtyTotColumn" msprop:Generator_ColumnVarNameInTable="columnQtyTot" msprop:Generator_UserColumnName="QtyTot" type="xs:double" />
<xs:element name="NumPack" msprop:Generator_ColumnPropNameInRow="NumPack" msprop:Generator_ColumnPropNameInTable="NumPackColumn" msprop:Generator_ColumnVarNameInTable="columnNumPack" msprop:Generator_UserColumnName="NumPack" type="xs:int" />
<xs:element name="Notes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_UserColumnName="Notes">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</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:ElencoLotti" />
<xs:field xpath="mstns:Lotto" />
</xs:unique>
<xs:unique name="ElencoUdc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ElencoUdc" />
<xs:field xpath="mstns:UDC" />
</xs:unique>
<xs:unique name="AnagArt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagArt" />
<xs:field xpath="mstns:CodArt" />
</xs:unique>
<xs:unique name="ODL_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ODL" />
<xs:field xpath="mstns:IdxODL" />
</xs:unique>
<xs:unique name="Elencopost2Queue_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Elencopost2Queue" />
<xs:field xpath="mstns:CodPost" />
</xs:unique>
<xs:unique name="ElencoAL_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ElencoAL" />
<xs:field xpath="mstns:AL" />
</xs:unique>
<xs:unique name="AnagClienti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagClienti" />
<xs:field xpath="mstns:CodCliente" />
</xs:unique>
<xs:unique name="ElencoAL2UDC_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ElencoAL2UDC" />
<xs:field xpath="mstns:AL" />
<xs:field xpath="mstns:UDC" />
</xs:unique>
<xs:unique name="AnagArticoli2Clienti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagArticoli2Clienti" />
<xs:field xpath="mstns:CodArt" />
</xs:unique>
<xs:unique name="Macchine_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Macchine" />
<xs:field xpath="mstns:IdxMacchina" />
</xs:unique>
<xs:unique name="AnagDestinClienti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagDestinClienti" />
<xs:field xpath="mstns:CodCliente" />
<xs:field xpath="mstns:CodDestinazione" />
</xs:unique>
<xs:unique name="RegGiacenze_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:RegGiacenze" />
<xs:field xpath="mstns:IdxRG" />
</xs:unique>
</xs:element>
</xs:schema>
Reference in New Issue View Git Blame Copy Permalink