Egalware/WebGIM
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
WebGIM/GIM_dataLayer/DS_Mag.xsd
T
Samuele E. Locatelli 71ac56e4fc Aggiunto progetto Gim_dataLayer come class library
2017-02-08 14:14:24 +01:00

1212 lines
138 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="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="GIMConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="GIMConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.GIMConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GIMConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GIMConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GIM_dataLayer.Properties.Settings.GlobalReference.Default.GIMConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagLocazioniTableAdapter" GeneratorDataComponentClassName="AnagLocazioniTableAdapter" Name="AnagLocazioni" UserDataComponentName="AnagLocazioniTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.AnagLocazioni" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[AnagLocazioni] WHERE (([CodLocazione] = @Original_CodLocazione))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagLocazioni] ([CodLocazione], [Descrizione]) VALUES (@CodLocazione, @Descrizione)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodLocazione, Descrizione FROM dbo.AnagLocazioni</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagLocazioni] SET [CodLocazione] = @CodLocazione, [Descrizione] = @Descrizione WHERE (([CodLocazione] = @Original_CodLocazione))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodLocazione" DataSetColumn="CodLocazione" />
<Mapping SourceColumn="Descrizione" DataSetColumn="Descrizione" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" 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">
<DeleteCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AnLoc_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_CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</DeleteCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" 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">
<InsertCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AnLoc_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="@CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" 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">
<UpdateCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AnLoc_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="@CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Descrizione" 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_CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MagRicTableAdapter" GeneratorDataComponentClassName="MagRicTableAdapter" Name="MagRic" UserDataComponentName="MagRicTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.MagRic" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[MagRic] WHERE (([idxItem] = @Original_idxItem) AND ([CodLocazione] = @Original_CodLocazione))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[MagRic] ([idxItem], [CodLocazione], [Giacenza], [Note], [dtLastUpd]) VALUES (@idxItem, @CodLocazione, @Giacenza, @Note, @dtLastUpd)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Giacenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Giacenza" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtLastUpd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtLastUpd" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxItem, CodLocazione, Giacenza, Note, dtLastUpd FROM dbo.MagRic</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[MagRic] SET [idxItem] = @idxItem, [CodLocazione] = @CodLocazione, [Giacenza] = @Giacenza, [Note] = @Note, [dtLastUpd] = @dtLastUpd WHERE (([idxItem] = @Original_idxItem) AND ([CodLocazione] = @Original_CodLocazione))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Giacenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Giacenza" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtLastUpd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtLastUpd" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodLocazione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodLocazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxItem" DataSetColumn="idxItem" />
<Mapping SourceColumn="CodLocazione" DataSetColumn="CodLocazione" />
<Mapping SourceColumn="Giacenza" DataSetColumn="Giacenza" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="dtLastUpd" DataSetColumn="dtLastUpd" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagItemsTableAdapter" GeneratorDataComponentClassName="AnagItemsTableAdapter" Name="AnagItems" UserDataComponentName="AnagItemsTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.AnagItems" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[AnagItems] WHERE (([idxItem] = @Original_idxItem))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagItems] ([Famiglia], [Descrizione], [NomeCostruttore], [CodCostruttore], [CodSomaschini], [QtaMin], [QtaLotto], [Valore]) VALUES (@Famiglia, @Descrizione, @NomeCostruttore, @CodCostruttore, @CodSomaschini, @QtaMin, @QtaLotto, @Valore)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Famiglia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Famiglia" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NomeCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeCostruttore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCostruttore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSomaschini" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSomaschini" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QtaMin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QtaMin" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QtaLotto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QtaLotto" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Valore" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Valore" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM dbo.AnagItems</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagItems] SET [Famiglia] = @Famiglia, [Descrizione] = @Descrizione, [NomeCostruttore] = @NomeCostruttore, [CodCostruttore] = @CodCostruttore, [CodSomaschini] = @CodSomaschini, [QtaMin] = @QtaMin, [QtaLotto] = @QtaLotto, [Valore] = @Valore WHERE (([idxItem] = @Original_idxItem))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Famiglia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Famiglia" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NomeCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeCostruttore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCostruttore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSomaschini" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSomaschini" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QtaMin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QtaMin" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QtaLotto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QtaLotto" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Valore" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Valore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxItem" DataSetColumn="idxItem" />
<Mapping SourceColumn="Descrizione" DataSetColumn="Descrizione" />
<Mapping SourceColumn="NomeCostruttore" DataSetColumn="NomeCostruttore" />
<Mapping SourceColumn="CodCostruttore" DataSetColumn="CodCostruttore" />
<Mapping SourceColumn="CodSomaschini" DataSetColumn="CodInterno" />
<Mapping SourceColumn="QtaMin" DataSetColumn="QtaMin" />
<Mapping SourceColumn="QtaLotto" DataSetColumn="QtaLotto" />
<Mapping SourceColumn="Famiglia" DataSetColumn="Famiglia" />
<Mapping SourceColumn="Valore" DataSetColumn="Valore" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AnItems_getByTag" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTag" GetMethodModifier="Public" GetMethodName="getByTag" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTag" UserSourceName="getByTag">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AnItems_getByTag</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="@TagCode" 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="StatoMagTableAdapter" GeneratorDataComponentClassName="StatoMagTableAdapter" Name="StatoMag" UserDataComponentName="StatoMagTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_StatoMag" 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_StatoMag</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxItem" DataSetColumn="idxItem" />
<Mapping SourceColumn="Descrizione" DataSetColumn="Descrizione" />
<Mapping SourceColumn="NomeCostruttore" DataSetColumn="NomeCostruttore" />
<Mapping SourceColumn="CodCostruttore" DataSetColumn="CodCostruttore" />
<Mapping SourceColumn="CodSomaschini" DataSetColumn="CodInterno" />
<Mapping SourceColumn="QtaMin" DataSetColumn="QtaMin" />
<Mapping SourceColumn="QtaLotto" DataSetColumn="QtaLotto" />
<Mapping SourceColumn="Valore" DataSetColumn="Valore" />
<Mapping SourceColumn="Giacenza" DataSetColumn="Giacenza" />
<Mapping SourceColumn="CodLocazione" DataSetColumn="CodLocazione" />
<Mapping SourceColumn="DescrLocazione" DataSetColumn="DescrLocazione" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="dtLastUpd" DataSetColumn="dtLastUpd" />
<Mapping SourceColumn="Famiglia" DataSetColumn="Famiglia" />
<Mapping SourceColumn="CodInterno" DataSetColumn="CodInterno" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_StatoMag_delete" 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_StatoMag_delete</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="@Original_idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_StatoMag_getByDescr" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByDescr" GetMethodModifier="Public" GetMethodName="getByDescr" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByDescr" UserSourceName="getByDescr">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_StatoMag_getByDescr</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="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_StatoMag_getByIdxMacchina" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxMacc" GetMethodModifier="Public" GetMethodName="getByIdxMacc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxMacc" UserSourceName="getByIdxMacc">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_StatoMag_getByIdxMacchina</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="@idxMacchina" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_StatoMag_insert" 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_StatoMag_insert</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="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NomeCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodInterno" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QtaMin" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QtaLotto" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Valore" Precision="18" ProviderType="Decimal" Scale="6" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Giacenza" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodLocazione" 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="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_StatoMag_update" 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="true">
<CommandText>dbo.stp_StatoMag_update</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="@Original_idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Famiglia" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NomeCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCostruttore" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodInterno" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QtaMin" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QtaLotto" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Valore" Precision="18" ProviderType="Decimal" Scale="6" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodLocazione" 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="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagTagsTableAdapter" GeneratorDataComponentClassName="AnagTagsTableAdapter" Name="AnagTags" UserDataComponentName="AnagTagsTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.AnagTags" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [AnagTags] WHERE (([TagCode] = @Original_TagCode))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [AnagTags] ([TagCode], [Class], [TagDescr]) VALUES (@TagCode, @Class, @TagDescr)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagDescr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagDescr" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT TagCode, Class, TagDescr
FROM AnagTags</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [AnagTags] SET [TagCode] = @TagCode, [Class] = @Class, [TagDescr] = @TagDescr WHERE (([TagCode] = @Original_TagCode))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagDescr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagDescr" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="TagCode" DataSetColumn="TagCode" />
<Mapping SourceColumn="Class" DataSetColumn="Class" />
<Mapping SourceColumn="TagDescr" DataSetColumn="TagDescr" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AnTag_avail4Item" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="avail4item" GetMethodModifier="Public" GetMethodName="avail4item" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="avail4item" UserSourceName="avail4item">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AnTag_avail4Item</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="@idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AnTag_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_AnTag_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_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AnTag_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_AnTag_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="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AnTag_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_AnTag_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="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TagDescr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AnTag_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_AnTag_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="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TagDescr" 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_TagCode" 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="Tag2ItemTableAdapter" GeneratorDataComponentClassName="Tag2ItemTableAdapter" Name="Tag2Item" UserDataComponentName="Tag2ItemTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.Tag2Item" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Tag2Item] WHERE (([idxItem] = @Original_idxItem) AND ([TagCode] = @Original_TagCode))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Tag2Item] ([idxItem], [TagCode]) VALUES (@idxItem, @TagCode)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxItem, TagCode FROM dbo.Tag2Item</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Tag2Item] SET [idxItem] = @idxItem, [TagCode] = @TagCode WHERE (([idxItem] = @Original_idxItem) AND ([TagCode] = @Original_TagCode))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxItem" DataSetColumn="idxItem" />
<Mapping SourceColumn="TagCode" DataSetColumn="TagCode" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_T2I_getByIdxItem" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByItem" GetMethodModifier="Public" GetMethodName="getByItem" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByItem" UserSourceName="getByItem">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_T2I_getByIdxItem</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="@idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_T2I_getByTag" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTag" GetMethodModifier="Public" GetMethodName="getByTag" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTag" UserSourceName="getByTag">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_T2I_getByTag</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="@TagCode" 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="Tag2MaccTableAdapter" GeneratorDataComponentClassName="Tag2MaccTableAdapter" Name="Tag2Macc" UserDataComponentName="Tag2MaccTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.Tag2Macc" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Tag2Macc] WHERE (([TagCode] = @Original_TagCode) AND ([idxMacchina] = @Original_idxMacchina))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxMacchina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxMacchina" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Tag2Macc] ([TagCode], [idxMacchina]) VALUES (@TagCode, @idxMacchina)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxMacchina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT TagCode, idxMacchina FROM dbo.Tag2Macc</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Tag2Macc] SET [TagCode] = @TagCode, [idxMacchina] = @idxMacchina WHERE (([TagCode] = @Original_TagCode) AND ([idxMacchina] = @Original_idxMacchina))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxMacchina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxMacchina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxMacchina" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="TagCode" DataSetColumn="TagCode" />
<Mapping SourceColumn="idxMacchina" DataSetColumn="idxMacchina" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_T2M_getByTag" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTag" GetMethodModifier="Public" GetMethodName="getByTag" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTag" UserSourceName="getByTag">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_T2M_getByTag</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="@TagCode" 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="AnagMacchineTableAdapter" GeneratorDataComponentClassName="AnagMacchineTableAdapter" Name="AnagMacchine" UserDataComponentName="AnagMacchineTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.AnagMacchine" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[AnagMacchine] WHERE (([idxMacchina] = @Original_idxMacchina))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxMacchina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxMacchina" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagMacchine] ([idxImpianto], [codMacchina], [nomeMacchina], [modello], [matricola], [anno], [kgPeso], [kwConsumo], [funzDal], [funzAl]) VALUES (@idxImpianto, @codMacchina, @nomeMacchina, @modello, @matricola, @anno, @kgPeso, @kwConsumo, @funzDal, @funzAl)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxImpianto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modello" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modello" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matricola" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matricola" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="anno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@kgPeso" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="kgPeso" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@kwConsumo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="kwConsumo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@funzDal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="funzDal" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@funzAl" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="funzAl" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxMacchina, idxImpianto, codMacchina, nomeMacchina, modello, matricola, anno, kgPeso, kwConsumo, funzDal, funzAl FROM dbo.AnagMacchine</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagMacchine] SET [idxImpianto] = @idxImpianto, [codMacchina] = @codMacchina, [nomeMacchina] = @nomeMacchina, [modello] = @modello, [matricola] = @matricola, [anno] = @anno, [kgPeso] = @kgPeso, [kwConsumo] = @kwConsumo, [funzDal] = @funzDal, [funzAl] = @funzAl WHERE (([idxMacchina] = @Original_idxMacchina))</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxImpianto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxImpianto" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modello" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modello" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matricola" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matricola" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="anno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@kgPeso" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="kgPeso" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@kwConsumo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="kwConsumo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@funzDal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="funzDal" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@funzAl" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="funzAl" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxMacchina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxMacchina" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxMacchina" DataSetColumn="idxMacchina" />
<Mapping SourceColumn="idxImpianto" DataSetColumn="idxImpianto" />
<Mapping SourceColumn="codMacchina" DataSetColumn="codMacchina" />
<Mapping SourceColumn="nomeMacchina" DataSetColumn="nomeMacchina" />
<Mapping SourceColumn="modello" DataSetColumn="modello" />
<Mapping SourceColumn="matricola" DataSetColumn="matricola" />
<Mapping SourceColumn="anno" DataSetColumn="anno" />
<Mapping SourceColumn="kgPeso" DataSetColumn="kgPeso" />
<Mapping SourceColumn="kwConsumo" DataSetColumn="kwConsumo" />
<Mapping SourceColumn="funzDal" DataSetColumn="funzDal" />
<Mapping SourceColumn="funzAl" DataSetColumn="funzAl" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_T2M_deleteByTag" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteTag2Macc" Modifier="Public" Name="deleteTag2Macc" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteTag2Macc">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_T2M_deleteByTag</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_TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxMacchina" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_AM_getByTag" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTag" GetMethodModifier="Public" GetMethodName="getByTag" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTag" UserSourceName="getByTag">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AM_getByTag</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="@TagCode" 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="SinonimiTagTableAdapter" GeneratorDataComponentClassName="SinonimiTagTableAdapter" Name="SinonimiTag" UserDataComponentName="SinonimiTagTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.SinonimiTag" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[SinonimiTag] WHERE (([TagCodeOrig] = @Original_TagCodeOrig))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCodeOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCodeOrig" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[SinonimiTag] ([TagCodeOrig], [TagCode]) VALUES (@TagCodeOrig, @TagCode)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCodeOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCodeOrig" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT TagCodeOrig, TagCode FROM dbo.SinonimiTag</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[SinonimiTag] SET [TagCodeOrig] = @TagCodeOrig, [TagCode] = @TagCode WHERE (([TagCodeOrig] = @Original_TagCodeOrig))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCodeOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCodeOrig" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCode" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TagCodeOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TagCodeOrig" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="TagCodeOrig" DataSetColumn="TagCodeOrig" />
<Mapping SourceColumn="TagCode" DataSetColumn="TagCode" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" 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="GetDataBy" UserSourceName="updateQuery">
<UpdateCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_SinTag_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_TagCodeOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MovMagRicTableAdapter" GeneratorDataComponentClassName="MovMagRicTableAdapter" Name="MovMagRic" UserDataComponentName="MovMagRicTableAdapter">
<MainSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_MovMagExpl" 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_MovMagExpl</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxItem" DataSetColumn="idxItem" />
<Mapping SourceColumn="numIntMtz" DataSetColumn="numIntMtz" />
<Mapping SourceColumn="dtMov" DataSetColumn="dtMov" />
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
<Mapping SourceColumn="idxMacchina" DataSetColumn="idxMacchina" />
<Mapping SourceColumn="dtExport" DataSetColumn="dtExport" />
<Mapping SourceColumn="Famiglia" DataSetColumn="Famiglia" />
<Mapping SourceColumn="Descrizione" DataSetColumn="Descrizione" />
<Mapping SourceColumn="NomeCostruttore" DataSetColumn="NomeCostruttore" />
<Mapping SourceColumn="CodCostruttore" DataSetColumn="CodCostruttore" />
<Mapping SourceColumn="CodInterno" DataSetColumn="CodInterno" />
<Mapping SourceColumn="QtaMin" DataSetColumn="QtaMin" />
<Mapping SourceColumn="QtaLotto" DataSetColumn="QtaLotto" />
<Mapping SourceColumn="Valore" DataSetColumn="Valore" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="dtLastUpd" DataSetColumn="dtLastUpd" />
<Mapping SourceColumn="CodLocazione" DataSetColumn="CodLocazione" />
<Mapping SourceColumn="DescrLocazione" DataSetColumn="DescrLocazione" />
</Mappings>
<Sources>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_MovMag_delete" 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_MovMag_delete</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="@Original_idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_numIntMtz" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Original_dtMov" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_MovMag_getByNumInt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByNumInt" GetMethodModifier="Public" GetMethodName="getByNumInt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByNumInt" UserSourceName="getByNumInt">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_MovMag_getByNumInt</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="@numIntMtz" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_MovMag_insert" 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_MovMag_insert</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="@idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numIntMtz" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Qta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_MovMag_update" 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_MovMag_update</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="@Original_idxItem" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_numIntMtz" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Original_dtMov" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Qta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DS_Mag" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Mag" msprop:Generator_UserDSName="DS_Mag">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="AnagLocazioni" msprop:Generator_TableClassName="AnagLocazioniDataTable" msprop:Generator_TableVarName="tableAnagLocazioni" msprop:Generator_RowChangedName="AnagLocazioniRowChanged" msprop:Generator_TablePropName="AnagLocazioni" msprop:Generator_RowDeletingName="AnagLocazioniRowDeleting" msprop:Generator_RowChangingName="AnagLocazioniRowChanging" msprop:Generator_RowEvHandlerName="AnagLocazioniRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagLocazioniRowDeleted" msprop:Generator_RowClassName="AnagLocazioniRow" msprop:Generator_UserTableName="AnagLocazioni" msprop:Generator_RowEvArgName="AnagLocazioniRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="CodLocazione" msprop:Generator_ColumnVarNameInTable="columnCodLocazione" msprop:Generator_ColumnPropNameInRow="CodLocazione" msprop:Generator_ColumnPropNameInTable="CodLocazioneColumn" msprop:Generator_UserColumnName="CodLocazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Descrizione" msprop:Generator_ColumnVarNameInTable="columnDescrizione" msprop:Generator_ColumnPropNameInRow="Descrizione" msprop:Generator_ColumnPropNameInTable="DescrizioneColumn" msprop:Generator_UserColumnName="Descrizione" 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="MagRic" msprop:Generator_TableClassName="MagRicDataTable" msprop:Generator_TableVarName="tableMagRic" msprop:Generator_RowChangedName="MagRicRowChanged" msprop:Generator_TablePropName="MagRic" msprop:Generator_RowDeletingName="MagRicRowDeleting" msprop:Generator_RowChangingName="MagRicRowChanging" msprop:Generator_RowEvHandlerName="MagRicRowChangeEventHandler" msprop:Generator_RowDeletedName="MagRicRowDeleted" msprop:Generator_RowClassName="MagRicRow" msprop:Generator_UserTableName="MagRic" msprop:Generator_RowEvArgName="MagRicRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="idxItem" msprop:Generator_ColumnVarNameInTable="columnidxItem" msprop:Generator_ColumnPropNameInRow="idxItem" msprop:Generator_ColumnPropNameInTable="idxItemColumn" msprop:Generator_UserColumnName="idxItem" type="xs:int" />
<xs:element name="CodLocazione" msprop:Generator_ColumnVarNameInTable="columnCodLocazione" msprop:Generator_ColumnPropNameInRow="CodLocazione" msprop:Generator_ColumnPropNameInTable="CodLocazioneColumn" msprop:Generator_UserColumnName="CodLocazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Giacenza" msprop:Generator_ColumnVarNameInTable="columnGiacenza" msprop:Generator_ColumnPropNameInRow="Giacenza" msprop:Generator_ColumnPropNameInTable="GiacenzaColumn" msprop:Generator_UserColumnName="Giacenza" type="xs:int" />
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtLastUpd" msprop:Generator_ColumnVarNameInTable="columndtLastUpd" msprop:Generator_ColumnPropNameInRow="dtLastUpd" msprop:Generator_ColumnPropNameInTable="dtLastUpdColumn" msprop:Generator_UserColumnName="dtLastUpd" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagItems" msprop:Generator_TableClassName="AnagItemsDataTable" msprop:Generator_TableVarName="tableAnagItems" msprop:Generator_RowChangedName="AnagItemsRowChanged" msprop:Generator_TablePropName="AnagItems" msprop:Generator_RowDeletingName="AnagItemsRowDeleting" msprop:Generator_RowChangingName="AnagItemsRowChanging" msprop:Generator_RowEvHandlerName="AnagItemsRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagItemsRowDeleted" msprop:Generator_RowClassName="AnagItemsRow" msprop:Generator_UserTableName="AnagItems" msprop:Generator_RowEvArgName="AnagItemsRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="idxItem" msprop:Generator_ColumnVarNameInTable="columnidxItem" msprop:Generator_ColumnPropNameInRow="idxItem" msprop:Generator_ColumnPropNameInTable="idxItemColumn" msprop:Generator_UserColumnName="idxItem" type="xs:int" />
<xs:element name="Descrizione" msprop:Generator_ColumnVarNameInTable="columnDescrizione" msprop:Generator_ColumnPropNameInRow="Descrizione" msprop:Generator_ColumnPropNameInTable="DescrizioneColumn" msprop:Generator_UserColumnName="Descrizione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NomeCostruttore" msprop:Generator_ColumnVarNameInTable="columnNomeCostruttore" msprop:Generator_ColumnPropNameInRow="NomeCostruttore" msprop:Generator_ColumnPropNameInTable="NomeCostruttoreColumn" msprop:Generator_UserColumnName="NomeCostruttore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodCostruttore" msprop:Generator_ColumnVarNameInTable="columnCodCostruttore" msprop:Generator_ColumnPropNameInRow="CodCostruttore" msprop:Generator_ColumnPropNameInTable="CodCostruttoreColumn" msprop:Generator_UserColumnName="CodCostruttore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodInterno" msprop:Generator_ColumnVarNameInTable="columnCodInterno" msprop:Generator_ColumnPropNameInRow="CodInterno" msprop:Generator_ColumnPropNameInTable="CodInternoColumn" msprop:Generator_UserColumnName="CodInterno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QtaMin" msprop:Generator_ColumnVarNameInTable="columnQtaMin" msprop:Generator_ColumnPropNameInRow="QtaMin" msprop:Generator_ColumnPropNameInTable="QtaMinColumn" msprop:Generator_UserColumnName="QtaMin" type="xs:int" />
<xs:element name="QtaLotto" msprop:Generator_ColumnVarNameInTable="columnQtaLotto" msprop:Generator_ColumnPropNameInRow="QtaLotto" msprop:Generator_ColumnPropNameInTable="QtaLottoColumn" msprop:Generator_UserColumnName="QtaLotto" type="xs:int" />
<xs:element name="Famiglia" msprop:Generator_ColumnVarNameInTable="columnFamiglia" msprop:Generator_ColumnPropNameInRow="Famiglia" msprop:Generator_ColumnPropNameInTable="FamigliaColumn" msprop:Generator_UserColumnName="Famiglia">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Valore" msprop:Generator_ColumnVarNameInTable="columnValore" msprop:Generator_ColumnPropNameInRow="Valore" msprop:Generator_ColumnPropNameInTable="ValoreColumn" msprop:Generator_UserColumnName="Valore" type="xs:decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="StatoMag" msprop:Generator_TableClassName="StatoMagDataTable" msprop:Generator_TableVarName="tableStatoMag" msprop:Generator_TablePropName="StatoMag" msprop:Generator_RowDeletingName="StatoMagRowDeleting" msprop:Generator_RowChangingName="StatoMagRowChanging" msprop:Generator_RowEvHandlerName="StatoMagRowChangeEventHandler" msprop:Generator_RowDeletedName="StatoMagRowDeleted" msprop:Generator_UserTableName="StatoMag" msprop:Generator_RowChangedName="StatoMagRowChanged" msprop:Generator_RowEvArgName="StatoMagRowChangeEvent" msprop:Generator_RowClassName="StatoMagRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idxItem" msprop:Generator_ColumnVarNameInTable="columnidxItem" msprop:Generator_ColumnPropNameInRow="idxItem" msprop:Generator_ColumnPropNameInTable="idxItemColumn" msprop:Generator_UserColumnName="idxItem" type="xs:int" />
<xs:element name="Famiglia" msdata:Caption="Descrizione" msprop:Generator_ColumnVarNameInTable="columnFamiglia" msprop:Generator_ColumnPropNameInRow="Famiglia" msprop:Generator_ColumnPropNameInTable="FamigliaColumn" msprop:Generator_UserColumnName="Famiglia">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Descrizione" msprop:Generator_ColumnVarNameInTable="columnDescrizione" msprop:Generator_ColumnPropNameInRow="Descrizione" msprop:Generator_ColumnPropNameInTable="DescrizioneColumn" msprop:Generator_UserColumnName="Descrizione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NomeCostruttore" msprop:Generator_ColumnVarNameInTable="columnNomeCostruttore" msprop:Generator_ColumnPropNameInRow="NomeCostruttore" msprop:Generator_ColumnPropNameInTable="NomeCostruttoreColumn" msprop:Generator_UserColumnName="NomeCostruttore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodCostruttore" msprop:Generator_ColumnVarNameInTable="columnCodCostruttore" msprop:Generator_ColumnPropNameInRow="CodCostruttore" msprop:Generator_ColumnPropNameInTable="CodCostruttoreColumn" msprop:Generator_UserColumnName="CodCostruttore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodInterno" msprop:Generator_ColumnVarNameInTable="columnCodInterno" msprop:Generator_ColumnPropNameInRow="CodInterno" msprop:Generator_ColumnPropNameInTable="CodInternoColumn" msprop:Generator_UserColumnName="CodInterno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QtaMin" msprop:Generator_ColumnVarNameInTable="columnQtaMin" msprop:Generator_ColumnPropNameInRow="QtaMin" msprop:Generator_ColumnPropNameInTable="QtaMinColumn" msprop:Generator_UserColumnName="QtaMin" type="xs:int" />
<xs:element name="QtaLotto" msprop:Generator_ColumnVarNameInTable="columnQtaLotto" msprop:Generator_ColumnPropNameInRow="QtaLotto" msprop:Generator_ColumnPropNameInTable="QtaLottoColumn" msprop:Generator_UserColumnName="QtaLotto" type="xs:int" />
<xs:element name="Valore" msprop:Generator_ColumnVarNameInTable="columnValore" msprop:Generator_ColumnPropNameInRow="Valore" msprop:Generator_ColumnPropNameInTable="ValoreColumn" msprop:Generator_UserColumnName="Valore" type="xs:decimal" />
<xs:element name="Giacenza" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnGiacenza" msprop:Generator_ColumnPropNameInRow="Giacenza" msprop:Generator_ColumnPropNameInTable="GiacenzaColumn" msprop:Generator_UserColumnName="Giacenza" type="xs:int" minOccurs="0" />
<xs:element name="CodLocazione" msprop:Generator_ColumnVarNameInTable="columnCodLocazione" msprop:Generator_ColumnPropNameInRow="CodLocazione" msprop:Generator_ColumnPropNameInTable="CodLocazioneColumn" msprop:Generator_UserColumnName="CodLocazione" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrLocazione" msprop:Generator_ColumnVarNameInTable="columnDescrLocazione" msprop:Generator_ColumnPropNameInRow="DescrLocazione" msprop:Generator_ColumnPropNameInTable="DescrLocazioneColumn" msprop:Generator_UserColumnName="DescrLocazione" 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_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtLastUpd" msprop:Generator_ColumnVarNameInTable="columndtLastUpd" msprop:Generator_ColumnPropNameInRow="dtLastUpd" msprop:Generator_ColumnPropNameInTable="dtLastUpdColumn" msprop:Generator_UserColumnName="dtLastUpd" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagTags" msprop:Generator_TableClassName="AnagTagsDataTable" msprop:Generator_TableVarName="tableAnagTags" msprop:Generator_RowChangedName="AnagTagsRowChanged" msprop:Generator_TablePropName="AnagTags" msprop:Generator_RowDeletingName="AnagTagsRowDeleting" msprop:Generator_RowChangingName="AnagTagsRowChanging" msprop:Generator_RowEvHandlerName="AnagTagsRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagTagsRowDeleted" msprop:Generator_RowClassName="AnagTagsRow" msprop:Generator_UserTableName="AnagTags" msprop:Generator_RowEvArgName="AnagTagsRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="TagCode" msprop:Generator_ColumnVarNameInTable="columnTagCode" msprop:Generator_ColumnPropNameInRow="TagCode" msprop:Generator_ColumnPropNameInTable="TagCodeColumn" msprop:Generator_UserColumnName="TagCode">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TagDescr" msprop:Generator_ColumnVarNameInTable="columnTagDescr" msprop:Generator_ColumnPropNameInRow="TagDescr" msprop:Generator_ColumnPropNameInTable="TagDescrColumn" msprop:Generator_UserColumnName="TagDescr">
<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="Tag2Item" msprop:Generator_TableClassName="Tag2ItemDataTable" msprop:Generator_TableVarName="tableTag2Item" msprop:Generator_RowChangedName="Tag2ItemRowChanged" msprop:Generator_TablePropName="Tag2Item" msprop:Generator_RowDeletingName="Tag2ItemRowDeleting" msprop:Generator_RowChangingName="Tag2ItemRowChanging" msprop:Generator_RowEvHandlerName="Tag2ItemRowChangeEventHandler" msprop:Generator_RowDeletedName="Tag2ItemRowDeleted" msprop:Generator_RowClassName="Tag2ItemRow" msprop:Generator_UserTableName="Tag2Item" msprop:Generator_RowEvArgName="Tag2ItemRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="idxItem" msprop:Generator_ColumnVarNameInTable="columnidxItem" msprop:Generator_ColumnPropNameInRow="idxItem" msprop:Generator_ColumnPropNameInTable="idxItemColumn" msprop:Generator_UserColumnName="idxItem" type="xs:int" />
<xs:element name="TagCode" msprop:Generator_ColumnVarNameInTable="columnTagCode" msprop:Generator_ColumnPropNameInRow="TagCode" msprop:Generator_ColumnPropNameInTable="TagCodeColumn" msprop:Generator_UserColumnName="TagCode">
<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="Tag2Macc" msprop:Generator_TableClassName="Tag2MaccDataTable" msprop:Generator_TableVarName="tableTag2Macc" msprop:Generator_RowChangedName="Tag2MaccRowChanged" msprop:Generator_TablePropName="Tag2Macc" msprop:Generator_RowDeletingName="Tag2MaccRowDeleting" msprop:Generator_RowChangingName="Tag2MaccRowChanging" msprop:Generator_RowEvHandlerName="Tag2MaccRowChangeEventHandler" msprop:Generator_RowDeletedName="Tag2MaccRowDeleted" msprop:Generator_RowClassName="Tag2MaccRow" msprop:Generator_UserTableName="Tag2Macc" msprop:Generator_RowEvArgName="Tag2MaccRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="TagCode" msprop:Generator_ColumnVarNameInTable="columnTagCode" msprop:Generator_ColumnPropNameInRow="TagCode" msprop:Generator_ColumnPropNameInTable="TagCodeColumn" msprop:Generator_UserColumnName="TagCode">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxMacchina" msprop:Generator_ColumnVarNameInTable="columnidxMacchina" msprop:Generator_ColumnPropNameInRow="idxMacchina" msprop:Generator_ColumnPropNameInTable="idxMacchinaColumn" msprop:Generator_UserColumnName="idxMacchina" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagMacchine" msprop:Generator_TableClassName="AnagMacchineDataTable" msprop:Generator_TableVarName="tableAnagMacchine" msprop:Generator_RowChangedName="AnagMacchineRowChanged" msprop:Generator_TablePropName="AnagMacchine" msprop:Generator_RowDeletingName="AnagMacchineRowDeleting" msprop:Generator_RowChangingName="AnagMacchineRowChanging" msprop:Generator_RowEvHandlerName="AnagMacchineRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagMacchineRowDeleted" msprop:Generator_RowClassName="AnagMacchineRow" msprop:Generator_UserTableName="AnagMacchine" msprop:Generator_RowEvArgName="AnagMacchineRowChangeEvent">
<xs:complexType>
<xs:sequence>
<xs:element name="idxMacchina" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxMacchina" msprop:Generator_ColumnPropNameInRow="idxMacchina" msprop:Generator_ColumnPropNameInTable="idxMacchinaColumn" msprop:Generator_UserColumnName="idxMacchina" type="xs:int" />
<xs:element name="idxImpianto" msprop:Generator_ColumnVarNameInTable="columnidxImpianto" msprop:Generator_ColumnPropNameInRow="idxImpianto" msprop:Generator_ColumnPropNameInTable="idxImpiantoColumn" msprop:Generator_UserColumnName="idxImpianto" type="xs:int" minOccurs="0" />
<xs:element name="codMacchina" msprop:Generator_ColumnVarNameInTable="columncodMacchina" msprop:Generator_ColumnPropNameInRow="codMacchina" msprop:Generator_ColumnPropNameInTable="codMacchinaColumn" msprop:Generator_UserColumnName="codMacchina" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nomeMacchina" msprop:Generator_ColumnVarNameInTable="columnnomeMacchina" msprop:Generator_ColumnPropNameInRow="nomeMacchina" msprop:Generator_ColumnPropNameInTable="nomeMacchinaColumn" msprop:Generator_UserColumnName="nomeMacchina" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="modello" msprop:Generator_ColumnVarNameInTable="columnmodello" msprop:Generator_ColumnPropNameInRow="modello" msprop:Generator_ColumnPropNameInTable="modelloColumn" msprop:Generator_UserColumnName="modello" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="matricola" msprop:Generator_ColumnVarNameInTable="columnmatricola" msprop:Generator_ColumnPropNameInRow="matricola" msprop:Generator_ColumnPropNameInTable="matricolaColumn" msprop:Generator_UserColumnName="matricola" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="anno" msprop:Generator_ColumnVarNameInTable="columnanno" msprop:Generator_ColumnPropNameInRow="anno" msprop:Generator_ColumnPropNameInTable="annoColumn" msprop:Generator_UserColumnName="anno" type="xs:int" minOccurs="0" />
<xs:element name="kgPeso" msprop:Generator_ColumnVarNameInTable="columnkgPeso" msprop:Generator_ColumnPropNameInRow="kgPeso" msprop:Generator_ColumnPropNameInTable="kgPesoColumn" msprop:Generator_UserColumnName="kgPeso" type="xs:double" />
<xs:element name="kwConsumo" msprop:Generator_ColumnVarNameInTable="columnkwConsumo" msprop:Generator_ColumnPropNameInRow="kwConsumo" msprop:Generator_ColumnPropNameInTable="kwConsumoColumn" msprop:Generator_UserColumnName="kwConsumo" type="xs:double" />
<xs:element name="funzDal" msprop:Generator_ColumnVarNameInTable="columnfunzDal" msprop:Generator_ColumnPropNameInRow="funzDal" msprop:Generator_ColumnPropNameInTable="funzDalColumn" msprop:Generator_UserColumnName="funzDal" type="xs:dateTime" minOccurs="0" />
<xs:element name="funzAl" msprop:Generator_ColumnVarNameInTable="columnfunzAl" msprop:Generator_ColumnPropNameInRow="funzAl" msprop:Generator_ColumnPropNameInTable="funzAlColumn" msprop:Generator_UserColumnName="funzAl" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="SinonimiTag" msprop:Generator_TableClassName="SinonimiTagDataTable" msprop:Generator_TableVarName="tableSinonimiTag" msprop:Generator_TablePropName="SinonimiTag" msprop:Generator_RowDeletingName="SinonimiTagRowDeleting" msprop:Generator_RowChangingName="SinonimiTagRowChanging" msprop:Generator_RowEvHandlerName="SinonimiTagRowChangeEventHandler" msprop:Generator_RowDeletedName="SinonimiTagRowDeleted" msprop:Generator_UserTableName="SinonimiTag" msprop:Generator_RowChangedName="SinonimiTagRowChanged" msprop:Generator_RowEvArgName="SinonimiTagRowChangeEvent" msprop:Generator_RowClassName="SinonimiTagRow">
<xs:complexType>
<xs:sequence>
<xs:element name="TagCodeOrig" msprop:Generator_ColumnVarNameInTable="columnTagCodeOrig" msprop:Generator_ColumnPropNameInRow="TagCodeOrig" msprop:Generator_ColumnPropNameInTable="TagCodeOrigColumn" msprop:Generator_UserColumnName="TagCodeOrig">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TagCode" msprop:Generator_ColumnVarNameInTable="columnTagCode" msprop:Generator_ColumnPropNameInRow="TagCode" msprop:Generator_ColumnPropNameInTable="TagCodeColumn" msprop:Generator_UserColumnName="TagCode">
<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="MovMagRic" msprop:Generator_TableClassName="MovMagRicDataTable" msprop:Generator_TableVarName="tableMovMagRic" msprop:Generator_TablePropName="MovMagRic" msprop:Generator_RowDeletingName="MovMagRicRowDeleting" msprop:Generator_RowChangingName="MovMagRicRowChanging" msprop:Generator_RowEvHandlerName="MovMagRicRowChangeEventHandler" msprop:Generator_RowDeletedName="MovMagRicRowDeleted" msprop:Generator_UserTableName="MovMagRic" msprop:Generator_RowChangedName="MovMagRicRowChanged" msprop:Generator_RowEvArgName="MovMagRicRowChangeEvent" msprop:Generator_RowClassName="MovMagRicRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idxItem" msprop:Generator_ColumnVarNameInTable="columnidxItem" msprop:Generator_ColumnPropNameInRow="idxItem" msprop:Generator_ColumnPropNameInTable="idxItemColumn" msprop:Generator_UserColumnName="idxItem" type="xs:int" />
<xs:element name="numIntMtz" msprop:Generator_ColumnVarNameInTable="columnnumIntMtz" msprop:Generator_ColumnPropNameInRow="numIntMtz" msprop:Generator_ColumnPropNameInTable="numIntMtzColumn" msprop:Generator_UserColumnName="numIntMtz" type="xs:int" />
<xs:element name="dtMov" msprop:Generator_ColumnVarNameInTable="columndtMov" msprop:Generator_ColumnPropNameInRow="dtMov" msprop:Generator_ColumnPropNameInTable="dtMovColumn" msprop:Generator_UserColumnName="dtMov" type="xs:dateTime" />
<xs:element name="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" />
<xs:element name="idxMacchina" msprop:Generator_ColumnVarNameInTable="columnidxMacchina" msprop:Generator_ColumnPropNameInRow="idxMacchina" msprop:Generator_ColumnPropNameInTable="idxMacchinaColumn" msprop:Generator_UserColumnName="idxMacchina" type="xs:int" />
<xs:element name="dtExport" msprop:Generator_ColumnVarNameInTable="columndtExport" msprop:Generator_ColumnPropNameInRow="dtExport" msprop:Generator_ColumnPropNameInTable="dtExportColumn" msprop:Generator_UserColumnName="dtExport" type="xs:dateTime" minOccurs="0" />
<xs:element name="Famiglia" msprop:Generator_ColumnVarNameInTable="columnFamiglia" msprop:Generator_ColumnPropNameInRow="Famiglia" msprop:Generator_ColumnPropNameInTable="FamigliaColumn" msprop:Generator_UserColumnName="Famiglia">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Descrizione" msprop:Generator_ColumnVarNameInTable="columnDescrizione" msprop:Generator_ColumnPropNameInRow="Descrizione" msprop:Generator_ColumnPropNameInTable="DescrizioneColumn" msprop:Generator_UserColumnName="Descrizione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NomeCostruttore" msprop:Generator_ColumnVarNameInTable="columnNomeCostruttore" msprop:Generator_ColumnPropNameInRow="NomeCostruttore" msprop:Generator_ColumnPropNameInTable="NomeCostruttoreColumn" msprop:Generator_UserColumnName="NomeCostruttore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodCostruttore" msprop:Generator_ColumnVarNameInTable="columnCodCostruttore" msprop:Generator_ColumnPropNameInRow="CodCostruttore" msprop:Generator_ColumnPropNameInTable="CodCostruttoreColumn" msprop:Generator_UserColumnName="CodCostruttore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodInterno" msprop:Generator_ColumnVarNameInTable="columnCodInterno" msprop:Generator_ColumnPropNameInRow="CodInterno" msprop:Generator_ColumnPropNameInTable="CodInternoColumn" msprop:Generator_UserColumnName="CodInterno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QtaMin" msprop:Generator_ColumnVarNameInTable="columnQtaMin" msprop:Generator_ColumnPropNameInRow="QtaMin" msprop:Generator_ColumnPropNameInTable="QtaMinColumn" msprop:Generator_UserColumnName="QtaMin" type="xs:int" />
<xs:element name="QtaLotto" msprop:Generator_ColumnVarNameInTable="columnQtaLotto" msprop:Generator_ColumnPropNameInRow="QtaLotto" msprop:Generator_ColumnPropNameInTable="QtaLottoColumn" msprop:Generator_UserColumnName="QtaLotto" type="xs:int" />
<xs:element name="Valore" msprop:Generator_ColumnVarNameInTable="columnValore" msprop:Generator_ColumnPropNameInRow="Valore" msprop:Generator_ColumnPropNameInTable="ValoreColumn" msprop:Generator_UserColumnName="Valore" type="xs:decimal" />
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtLastUpd" msprop:Generator_ColumnVarNameInTable="columndtLastUpd" msprop:Generator_ColumnPropNameInRow="dtLastUpd" msprop:Generator_ColumnPropNameInTable="dtLastUpdColumn" msprop:Generator_UserColumnName="dtLastUpd" type="xs:dateTime" minOccurs="0" />
<xs:element name="CodLocazione" msprop:Generator_ColumnVarNameInTable="columnCodLocazione" msprop:Generator_ColumnPropNameInRow="CodLocazione" msprop:Generator_ColumnPropNameInTable="CodLocazioneColumn" msprop:Generator_UserColumnName="CodLocazione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrLocazione" msprop:Generator_ColumnVarNameInTable="columnDescrLocazione" msprop:Generator_ColumnPropNameInRow="DescrLocazione" msprop:Generator_ColumnPropNameInTable="DescrLocazioneColumn" msprop:Generator_UserColumnName="DescrLocazione" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagLocazioni" />
<xs:field xpath="mstns:CodLocazione" />
</xs:unique>
<xs:unique name="MagRic_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:MagRic" />
<xs:field xpath="mstns:idxItem" />
<xs:field xpath="mstns:CodLocazione" />
</xs:unique>
<xs:unique name="AnagItems_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagItems" />
<xs:field xpath="mstns:idxItem" />
</xs:unique>
<xs:unique name="StatoMag_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:StatoMag" />
<xs:field xpath="mstns:idxItem" />
</xs:unique>
<xs:unique name="AnagTags_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagTags" />
<xs:field xpath="mstns:TagCode" />
</xs:unique>
<xs:unique name="Tag2Item_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Tag2Item" />
<xs:field xpath="mstns:idxItem" />
<xs:field xpath="mstns:TagCode" />
</xs:unique>
<xs:unique name="Tag2Macc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Tag2Macc" />
<xs:field xpath="mstns:TagCode" />
<xs:field xpath="mstns:idxMacchina" />
</xs:unique>
<xs:unique name="AnagMacchine_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagMacchine" />
<xs:field xpath="mstns:idxMacchina" />
</xs:unique>
<xs:unique name="SinonimiTag_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:SinonimiTag" />
<xs:field xpath="mstns:TagCodeOrig" />
</xs:unique>
<xs:unique name="MovMagRic_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:MovMagRic" />
<xs:field xpath="mstns:idxItem" />
<xs:field xpath="mstns:numIntMtz" />
<xs:field xpath="mstns:dtMov" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="FK_MagRic_AnagLocazioni" msdata:parent="AnagLocazioni" msdata:child="MagRic" msdata:parentkey="CodLocazione" msdata:childkey="CodLocazione" msprop:Generator_UserChildTable="MagRic" msprop:Generator_ChildPropName="GetMagRicRows" msprop:Generator_UserRelationName="FK_MagRic_AnagLocazioni" msprop:Generator_RelationVarName="relationFK_MagRic_AnagLocazioni" msprop:Generator_UserParentTable="AnagLocazioni" msprop:Generator_ParentPropName="AnagLocazioniRow" />
<msdata:Relationship name="FK_MagRic_AnagItems" msdata:parent="AnagItems" msdata:child="MagRic" msdata:parentkey="idxItem" msdata:childkey="idxItem" msprop:Generator_UserChildTable="MagRic" msprop:Generator_ChildPropName="GetMagRicRows" msprop:Generator_UserRelationName="FK_MagRic_AnagItems" msprop:Generator_ParentPropName="AnagItemsRow" msprop:Generator_RelationVarName="relationFK_MagRic_AnagItems" msprop:Generator_UserParentTable="AnagItems" />
<msdata:Relationship name="FK_Tag2Item_AnagItems" msdata:parent="AnagItems" msdata:child="Tag2Item" msdata:parentkey="idxItem" msdata:childkey="idxItem" msprop:Generator_UserChildTable="Tag2Item" msprop:Generator_ChildPropName="GetTag2ItemRows" msprop:Generator_UserRelationName="FK_Tag2Item_AnagItems" msprop:Generator_RelationVarName="relationFK_Tag2Item_AnagItems" msprop:Generator_UserParentTable="AnagItems" msprop:Generator_ParentPropName="AnagItemsRow" />
<msdata:Relationship name="FK_Tag2Item_AnagTag" msdata:parent="AnagTags" msdata:child="Tag2Item" msdata:parentkey="TagCode" msdata:childkey="TagCode" msprop:Generator_UserChildTable="Tag2Item" msprop:Generator_ChildPropName="GetTag2ItemRows" msprop:Generator_UserRelationName="FK_Tag2Item_AnagTag" msprop:Generator_RelationVarName="relationFK_Tag2Item_AnagTag" msprop:Generator_UserParentTable="AnagTags" msprop:Generator_ParentPropName="AnagTagRow" />
<msdata:Relationship name="FK_Tag2Macc_AnagTag" msdata:parent="AnagTags" msdata:child="Tag2Macc" msdata:parentkey="TagCode" msdata:childkey="TagCode" msprop:Generator_UserChildTable="Tag2Macc" msprop:Generator_ChildPropName="GetTag2MaccRows" msprop:Generator_UserRelationName="FK_Tag2Macc_AnagTag" msprop:Generator_RelationVarName="relationFK_Tag2Macc_AnagTag" msprop:Generator_UserParentTable="AnagTags" msprop:Generator_ParentPropName="AnagTagRow" />
<msdata:Relationship name="FK_Tag2Macc_AnagMacchine" msdata:parent="AnagMacchine" msdata:child="Tag2Macc" msdata:parentkey="idxMacchina" msdata:childkey="idxMacchina" msprop:Generator_UserChildTable="Tag2Macc" msprop:Generator_ChildPropName="GetTag2MaccRows" msprop:Generator_UserRelationName="FK_Tag2Macc_AnagMacchine" msprop:Generator_ParentPropName="AnagMacchineRow" msprop:Generator_RelationVarName="relationFK_Tag2Macc_AnagMacchine" msprop:Generator_UserParentTable="AnagMacchine" />
<msdata:Relationship name="FK_MovMagRic_AnagItems" msdata:parent="AnagItems" msdata:child="MovMagRic" msdata:parentkey="idxItem" msdata:childkey="idxItem" msprop:Generator_UserChildTable="MovMagRic" msprop:Generator_ChildPropName="GetMovMagRicRows" msprop:Generator_UserRelationName="FK_MovMagRic_AnagItems" msprop:Generator_ParentPropName="AnagItemsRow" msprop:Generator_RelationVarName="relationFK_MovMagRic_AnagItems" msprop:Generator_UserParentTable="AnagItems" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
Reference in New Issue View Git Blame Copy Permalink