Egalware/XPS
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
XPS/XPS_data/DS_XPS.xsd
T
Samuele Locatelli cf80afedef Completo gestione note/urgenze/conferme
2019-04-15 18:53:22 +02:00

1183 lines
155 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DS_XPS" targetNamespace="http://tempuri.org/DS_XPS.xsd" xmlns:mstns="http://tempuri.org/DS_XPS.xsd" xmlns="http://tempuri.org/DS_XPS.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="SP" GeneratorFunctionsComponentClassName="SP" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="SP" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_XPSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_XPSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_XPSConnectionString" Provider="System.Data.SqlClient" />
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_AnagraficaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_AnagraficaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_AnagraficaConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NoteTableAdapter" GeneratorDataComponentClassName="NoteTableAdapter" Name="Note" UserDataComponentName="NoteTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Note" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Note] WHERE (([NumNota] = @Original_NumNota) AND ([IdxObj] = @Original_IdxObj) AND ((@IsNull_CodFase = 1 AND [CodFase] IS NULL) OR ([CodFase] = @Original_CodFase)) AND ((@IsNull_UserNota = 1 AND [UserNota] IS NULL) OR ([UserNota] = @Original_UserNota)) AND ((@IsNull_Data = 1 AND [Data] IS NULL) OR ([Data] = @Original_Data)) AND ((@IsNull_ExtView = 1 AND [ExtView] IS NULL) OR ([ExtView] = @Original_ExtView)) AND ([Nota] = @Original_Nota) AND ([Closed] = @Original_Closed))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodFase" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFase" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ExtView" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Closed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Closed" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Note] ([NumNota], [IdxObj], [CodFase], [UserNota], [Data], [ExtView], [Nota], [Closed]) VALUES (@NumNota, @IdxObj, @CodFase, @UserNota, @Data, @ExtView, @Nota, @Closed);
SELECT NumNota, IdxObj, CodFase, UserNota, Data, ExtView, Nota, Closed FROM Note WHERE (NumNota = @NumNota)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFase" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Closed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Closed" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM dbo.Note</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Note] SET [NumNota] = @NumNota, [IdxObj] = @IdxObj, [CodFase] = @CodFase, [UserNota] = @UserNota, [Data] = @Data, [ExtView] = @ExtView, [Nota] = @Nota, [Closed] = @Closed WHERE (([NumNota] = @Original_NumNota) AND ([IdxObj] = @Original_IdxObj) AND ((@IsNull_CodFase = 1 AND [CodFase] IS NULL) OR ([CodFase] = @Original_CodFase)) AND ((@IsNull_UserNota = 1 AND [UserNota] IS NULL) OR ([UserNota] = @Original_UserNota)) AND ((@IsNull_Data = 1 AND [Data] IS NULL) OR ([Data] = @Original_Data)) AND ((@IsNull_ExtView = 1 AND [ExtView] IS NULL) OR ([ExtView] = @Original_ExtView)) AND ([Nota] = @Original_Nota) AND ([Closed] = @Original_Closed));
SELECT NumNota, IdxObj, CodFase, UserNota, Data, ExtView, Nota, Closed FROM Note WHERE (NumNota = @NumNota)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFase" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Closed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Closed" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodFase" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFase" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ExtView" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Closed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Closed" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="NumNota" DataSetColumn="NumNota" />
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
<Mapping SourceColumn="CodFase" DataSetColumn="CodFase" />
<Mapping SourceColumn="UserNota" DataSetColumn="UserNota" />
<Mapping SourceColumn="Data" DataSetColumn="Data" />
<Mapping SourceColumn="ExtView" DataSetColumn="ExtView" />
<Mapping SourceColumn="Nota" DataSetColumn="Nota" />
<Mapping SourceColumn="Closed" DataSetColumn="Closed" />
</Mappings>
<Sources>
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_note_close" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="closeNote" Modifier="Public" Name="closeNote" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="closeNote">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_note_close</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="@NumNota" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_note_getByIdxObj" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxObj" GetMethodModifier="Public" GetMethodName="getByIdxObj" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxObj" UserSourceName="getByIdxObj">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_note_getByIdxObj</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="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_note_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_note_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="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Step4ObjTableAdapter" GeneratorDataComponentClassName="Step4ObjTableAdapter" Name="Step4Obj" UserDataComponentName="Step4ObjTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Step4Obj" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Step4Obj] WHERE (([IdxObj] = @Original_IdxObj) AND ([IdxStep] = @Original_IdxStep) AND ((@IsNull_IdxStato = 1 AND [IdxStato] IS NULL) OR ([IdxStato] = @Original_IdxStato)) AND ((@IsNull_StartDatePrev = 1 AND [StartDatePrev] IS NULL) OR ([StartDatePrev] = @Original_StartDatePrev)) AND ((@IsNull_DueDatePrev = 1 AND [DueDatePrev] IS NULL) OR ([DueDatePrev] = @Original_DueDatePrev)) AND ((@IsNull_StartDateReal = 1 AND [StartDateReal] IS NULL) OR ([StartDateReal] = @Original_StartDateReal)) AND ((@IsNull_DueDateReal = 1 AND [DueDateReal] IS NULL) OR ([DueDateReal] = @Original_DueDateReal)) AND ((@IsNull_RatioCompl = 1 AND [RatioCompl] IS NULL) OR ([RatioCompl] = @Original_RatioCompl)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStep" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStep" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDatePrev" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDatePrev" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDatePrev" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDatePrev" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDatePrev" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDatePrev" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDateReal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDateReal" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDateReal" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDateReal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDateReal" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDateReal" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RatioCompl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatioCompl" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_RatioCompl" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RatioCompl" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Step4Obj] ([IdxObj], [IdxStep], [IdxStato], [StartDatePrev], [DueDatePrev], [StartDateReal], [DueDateReal], [RatioCompl]) VALUES (@IdxObj, @IdxStep, @IdxStato, @StartDatePrev, @DueDatePrev, @StartDateReal, @DueDateReal, @RatioCompl);
SELECT IdxObj, IdxStep, IdxStato, StartDatePrev, DueDatePrev, StartDateReal, DueDateReal, RatioCompl FROM Step4Obj WHERE (IdxObj = @IdxObj) AND (IdxStep = @IdxStep)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStep" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStep" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDatePrev" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDatePrev" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDateReal" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDateReal" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RatioCompl" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RatioCompl" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT IdxObj, IdxStep, IdxStato, StartDatePrev, DueDatePrev, StartDateReal, DueDateReal, RatioCompl FROM dbo.Step4Obj</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Step4Obj] SET [IdxObj] = @IdxObj, [IdxStep] = @IdxStep, [IdxStato] = @IdxStato, [StartDatePrev] = @StartDatePrev, [DueDatePrev] = @DueDatePrev, [StartDateReal] = @StartDateReal, [DueDateReal] = @DueDateReal, [RatioCompl] = @RatioCompl WHERE (([IdxObj] = @Original_IdxObj) AND ([IdxStep] = @Original_IdxStep) AND ((@IsNull_IdxStato = 1 AND [IdxStato] IS NULL) OR ([IdxStato] = @Original_IdxStato)) AND ((@IsNull_StartDatePrev = 1 AND [StartDatePrev] IS NULL) OR ([StartDatePrev] = @Original_StartDatePrev)) AND ((@IsNull_DueDatePrev = 1 AND [DueDatePrev] IS NULL) OR ([DueDatePrev] = @Original_DueDatePrev)) AND ((@IsNull_StartDateReal = 1 AND [StartDateReal] IS NULL) OR ([StartDateReal] = @Original_StartDateReal)) AND ((@IsNull_DueDateReal = 1 AND [DueDateReal] IS NULL) OR ([DueDateReal] = @Original_DueDateReal)) AND ((@IsNull_RatioCompl = 1 AND [RatioCompl] IS NULL) OR ([RatioCompl] = @Original_RatioCompl)));
SELECT IdxObj, IdxStep, IdxStato, StartDatePrev, DueDatePrev, StartDateReal, DueDateReal, RatioCompl FROM Step4Obj WHERE (IdxObj = @IdxObj) AND (IdxStep = @IdxStep)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStep" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStep" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDatePrev" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDatePrev" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDateReal" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDateReal" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RatioCompl" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RatioCompl" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStep" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStep" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDatePrev" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDatePrev" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDatePrev" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDatePrev" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDatePrev" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDatePrev" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDatePrev" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDateReal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDateReal" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDateReal" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDateReal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDateReal" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDateReal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDateReal" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RatioCompl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatioCompl" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_RatioCompl" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RatioCompl" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
<Mapping SourceColumn="IdxStep" DataSetColumn="IdxStep" />
<Mapping SourceColumn="IdxStato" DataSetColumn="IdxStato" />
<Mapping SourceColumn="StartDatePrev" DataSetColumn="StartDatePrev" />
<Mapping SourceColumn="DueDatePrev" DataSetColumn="DueDatePrev" />
<Mapping SourceColumn="StartDateReal" DataSetColumn="StartDateReal" />
<Mapping SourceColumn="DueDateReal" DataSetColumn="DueDateReal" />
<Mapping SourceColumn="RatioCompl" DataSetColumn="RatioCompl" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Object2SetTableAdapter" GeneratorDataComponentClassName="Object2SetTableAdapter" Name="Object2Set" UserDataComponentName="Object2SetTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Object2Set" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Object2Set] WHERE (([IdxSet] = @Original_IdxSet) AND ([CodObj] = @Original_CodObj) AND ((@IsNull_Qta = 1 AND [Qta] IS NULL) OR ([Qta] = @Original_Qta)) AND ((@IsNull_UserQtyReq = 1 AND [UserQtyReq] IS NULL) OR ([UserQtyReq] = @Original_UserQtyReq)) AND ((@IsNull_Posizione = 1 AND [Posizione] IS NULL) OR ([Posizione] = @Original_Posizione)) AND ((@IsNull_TimeTrackEnab = 1 AND [TimeTrackEnab] IS NULL) OR ([TimeTrackEnab] = @Original_TimeTrackEnab)) AND ((@IsNull_ProcReq = 1 AND [ProcReq] IS NULL) OR ([ProcReq] = @Original_ProcReq)) AND ((@IsNull_ExtView = 1 AND [ExtView] IS NULL) OR ([ExtView] = @Original_ExtView)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxSet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxSet" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserQtyReq" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserQtyReq" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_UserQtyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UserQtyReq" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Posizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Posizione" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Posizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Posizione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeTrackEnab" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeTrackEnab" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TimeTrackEnab" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TimeTrackEnab" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProcReq" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProcReq" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ProcReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProcReq" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ExtView" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Object2Set] ([IdxSet], [CodObj], [Qta], [UserQtyReq], [Posizione], [TimeTrackEnab], [ProcReq], [ExtView]) VALUES (@IdxSet, @CodObj, @Qta, @UserQtyReq, @Posizione, @TimeTrackEnab, @ProcReq, @ExtView);
SELECT IdxSet, CodObj, Qta, UserQtyReq, Posizione, TimeTrackEnab, ProcReq, ExtView FROM Object2Set WHERE (CodObj = @CodObj) AND (IdxSet = @IdxSet)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxSet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxSet" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@UserQtyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UserQtyReq" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Posizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Posizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TimeTrackEnab" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TimeTrackEnab" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ProcReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProcReq" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT IdxSet, CodObj, Qta, UserQtyReq, Posizione, TimeTrackEnab, ProcReq, ExtView FROM dbo.Object2Set</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Object2Set] SET [IdxSet] = @IdxSet, [CodObj] = @CodObj, [Qta] = @Qta, [UserQtyReq] = @UserQtyReq, [Posizione] = @Posizione, [TimeTrackEnab] = @TimeTrackEnab, [ProcReq] = @ProcReq, [ExtView] = @ExtView WHERE (([IdxSet] = @Original_IdxSet) AND ([CodObj] = @Original_CodObj) AND ((@IsNull_Qta = 1 AND [Qta] IS NULL) OR ([Qta] = @Original_Qta)) AND ((@IsNull_UserQtyReq = 1 AND [UserQtyReq] IS NULL) OR ([UserQtyReq] = @Original_UserQtyReq)) AND ((@IsNull_Posizione = 1 AND [Posizione] IS NULL) OR ([Posizione] = @Original_Posizione)) AND ((@IsNull_TimeTrackEnab = 1 AND [TimeTrackEnab] IS NULL) OR ([TimeTrackEnab] = @Original_TimeTrackEnab)) AND ((@IsNull_ProcReq = 1 AND [ProcReq] IS NULL) OR ([ProcReq] = @Original_ProcReq)) AND ((@IsNull_ExtView = 1 AND [ExtView] IS NULL) OR ([ExtView] = @Original_ExtView)));
SELECT IdxSet, CodObj, Qta, UserQtyReq, Posizione, TimeTrackEnab, ProcReq, ExtView FROM Object2Set WHERE (CodObj = @CodObj) AND (IdxSet = @IdxSet)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxSet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxSet" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@UserQtyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UserQtyReq" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Posizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Posizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TimeTrackEnab" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TimeTrackEnab" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ProcReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProcReq" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxSet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxSet" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qta" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserQtyReq" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserQtyReq" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_UserQtyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UserQtyReq" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Posizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Posizione" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Posizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Posizione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeTrackEnab" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeTrackEnab" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TimeTrackEnab" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TimeTrackEnab" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProcReq" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProcReq" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ProcReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProcReq" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ExtView" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ExtView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ExtView" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="IdxSet" DataSetColumn="IdxSet" />
<Mapping SourceColumn="CodObj" DataSetColumn="CodObj" />
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
<Mapping SourceColumn="UserQtyReq" DataSetColumn="UserQtyReq" />
<Mapping SourceColumn="Posizione" DataSetColumn="Posizione" />
<Mapping SourceColumn="TimeTrackEnab" DataSetColumn="TimeTrackEnab" />
<Mapping SourceColumn="ProcReq" DataSetColumn="ProcReq" />
<Mapping SourceColumn="ExtView" DataSetColumn="ExtView" />
</Mappings>
<Sources>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Object2Set" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxSet" GetMethodModifier="Public" GetMethodName="getByIdxSet" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxSet" UserSourceName="getByIdxSet">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT IdxSet, CodObj, Qta, UserQtyReq, Posizione, TimeTrackEnab, ProcReq, ExtView
FROM Object2Set
WHERE (IdxSet = @IdxSet)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="IdxSet" ColumnName="IdxSet" DataSourceName="Equa_XPS.dbo.Object2Set" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@IdxSet" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="IdxSet" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UMTableAdapter" GeneratorDataComponentClassName="UMTableAdapter" Name="UM" UserDataComponentName="UMTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.UM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[UM] WHERE (([UM] = @Original_UM) AND ((@IsNull_DescrUM = 1 AND [DescrUM] IS NULL) OR ([DescrUM] = @Original_DescrUM)) AND ((@IsNull_FattoreSI = 1 AND [FattoreSI] IS NULL) OR ([FattoreSI] = @Original_FattoreSI)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UM" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrUM" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrUM" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FattoreSI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FattoreSI" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FattoreSI" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FattoreSI" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[UM] ([UM], [DescrUM], [FattoreSI]) VALUES (@UM, @DescrUM, @FattoreSI);
SELECT UM, DescrUM, FattoreSI FROM UM WHERE (UM = @UM)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UM" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrUM" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FattoreSI" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FattoreSI" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT UM, DescrUM, FattoreSI FROM dbo.UM</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[UM] SET [UM] = @UM, [DescrUM] = @DescrUM, [FattoreSI] = @FattoreSI WHERE (([UM] = @Original_UM) AND ((@IsNull_DescrUM = 1 AND [DescrUM] IS NULL) OR ([DescrUM] = @Original_DescrUM)) AND ((@IsNull_FattoreSI = 1 AND [FattoreSI] IS NULL) OR ([FattoreSI] = @Original_FattoreSI)));
SELECT UM, DescrUM, FattoreSI FROM UM WHERE (UM = @UM)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UM" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrUM" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FattoreSI" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FattoreSI" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UM" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrUM" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrUM" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FattoreSI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FattoreSI" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FattoreSI" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FattoreSI" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="UM" DataSetColumn="UM" />
<Mapping SourceColumn="DescrUM" DataSetColumn="DescrUM" />
<Mapping SourceColumn="FattoreSI" DataSetColumn="FattoreSI" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EventiTableAdapter" GeneratorDataComponentClassName="EventiTableAdapter" Name="Eventi" UserDataComponentName="EventiTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Eventi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Eventi] WHERE (([CodEvento] = @Original_CodEvento) AND ((@IsNull_CodTipoEvento = 1 AND [CodTipoEvento] IS NULL) OR ([CodTipoEvento] = @Original_CodTipoEvento)) AND ((@IsNull_DescrEvento = 1 AND [DescrEvento] IS NULL) OR ([DescrEvento] = @Original_DescrEvento)) AND ((@IsNull_Action = 1 AND [Action] IS NULL) OR ([Action] = @Original_Action)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodTipoEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (@CodEvento, @CodTipoEvento, @DescrEvento, @Action);
SELECT CodEvento, CodTipoEvento, DescrEvento, Action FROM Eventi WHERE (CodEvento = @CodEvento)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodEvento, CodTipoEvento, DescrEvento, Action FROM dbo.Eventi</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Eventi] SET [CodEvento] = @CodEvento, [CodTipoEvento] = @CodTipoEvento, [DescrEvento] = @DescrEvento, [Action] = @Action WHERE (([CodEvento] = @Original_CodEvento) AND ((@IsNull_CodTipoEvento = 1 AND [CodTipoEvento] IS NULL) OR ([CodTipoEvento] = @Original_CodTipoEvento)) AND ((@IsNull_DescrEvento = 1 AND [DescrEvento] IS NULL) OR ([DescrEvento] = @Original_DescrEvento)) AND ((@IsNull_Action = 1 AND [Action] IS NULL) OR ([Action] = @Original_Action)));
SELECT CodEvento, CodTipoEvento, DescrEvento, Action FROM Eventi WHERE (CodEvento = @CodEvento)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodTipoEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
<Mapping SourceColumn="CodTipoEvento" DataSetColumn="CodTipoEvento" />
<Mapping SourceColumn="DescrEvento" DataSetColumn="DescrEvento" />
<Mapping SourceColumn="Action" DataSetColumn="Action" />
</Mappings>
<Sources>
<DbSource ConnectionRef="Equa_XPSConnectionString (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="Text" ModifiedByUser="true">
<CommandText>DELETE FROM [dbo].[Eventi] WHERE ([idxEvento] = @Original_idxEvento)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Original_idxEvento" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Original_idxEvento" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
</DbSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (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="GetDataBy1" UserSourceName="UpdateQuery">
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>UPDATE Eventi
SET CodEvento = @CodEvento, DescrEvento = @DescrEvento, CodTipoEvento = @CodTipoEvento
WHERE (CodEvento = @Original_CodEvento)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="CodEvento" ColumnName="CodEvento" DataSourceName="Equa_XPS.dbo.Eventi" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="DescrEvento" ColumnName="DescrEvento" DataSourceName="Equa_XPS.dbo.Eventi" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="CodTipoEvento" ColumnName="CodTipoEvento" DataSourceName="Equa_XPS.dbo.Eventi" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Original_CodEvento" ColumnName="CodEvento" DataSourceName="Equa_XPS.dbo.Eventi" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipoEventiTableAdapter" GeneratorDataComponentClassName="TipoEventiTableAdapter" Name="TipoEventi" UserDataComponentName="TipoEventiTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.TipoEventi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[TipoEventi] WHERE (([CodTipoEvento] = @Original_CodTipoEvento) AND ((@IsNull_DescrTipoEv = 1 AND [DescrTipoEv] IS NULL) OR ([DescrTipoEv] = @Original_DescrTipoEv)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrTipoEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrTipoEv" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrTipoEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTipoEv" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[TipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (@CodTipoEvento, @DescrTipoEv);
SELECT CodTipoEvento, DescrTipoEv FROM TipoEventi WHERE (CodTipoEvento = @CodTipoEvento)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrTipoEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTipoEv" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodTipoEvento, DescrTipoEv FROM dbo.TipoEventi</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[TipoEventi] SET [CodTipoEvento] = @CodTipoEvento, [DescrTipoEv] = @DescrTipoEv WHERE (([CodTipoEvento] = @Original_CodTipoEvento) AND ((@IsNull_DescrTipoEv = 1 AND [DescrTipoEv] IS NULL) OR ([DescrTipoEv] = @Original_DescrTipoEv)));
SELECT CodTipoEvento, DescrTipoEv FROM TipoEventi WHERE (CodTipoEvento = @CodTipoEvento)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrTipoEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTipoEv" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrTipoEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrTipoEv" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrTipoEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTipoEv" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodTipoEvento" DataSetColumn="CodTipoEvento" />
<Mapping SourceColumn="DescrTipoEv" DataSetColumn="DescrTipoEv" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_ev2statiTableAdapter" GeneratorDataComponentClassName="v_ev2statiTableAdapter" Name="v_ev2stati" UserDataComponentName="v_ev2statiTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_ev2stati" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodMappa, IdxTipoObj, DescrObj, CodStato, StatoCurr, CodEvento, DescrEvento, NextCodStato, StatoNext FROM dbo.v_ev2stati</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodMappa" DataSetColumn="CodMappa" />
<Mapping SourceColumn="IdxTipoObj" DataSetColumn="IdxTipoObj" />
<Mapping SourceColumn="DescrObj" DataSetColumn="DescrObj" />
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
<Mapping SourceColumn="StatoCurr" DataSetColumn="StatoCurr" />
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
<Mapping SourceColumn="DescrEvento" DataSetColumn="DescrEvento" />
<Mapping SourceColumn="NextCodStato" DataSetColumn="NextCodStato" />
<Mapping SourceColumn="StatoNext" DataSetColumn="StatoNext" />
</Mappings>
<Sources>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_ev2stati" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFiltered" GetMethodModifier="Public" GetMethodName="getFiltered" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFiltered" UserSourceName="getFiltered">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT CodEvento, CodMappa, CodStato, DescrEvento, DescrObj, IdxTipoObj, NextCodStato, StatoCurr, StatoNext FROM v_ev2stati WHERE (CodEvento = @CodEvento) AND (IdxTipoObj = @IdxTipoObj) AND (CodMappa = @CodMappa)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="CodEvento" ColumnName="CodEvento" DataSourceName="Equa_XPS.dbo.v_ev2stati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="IdxTipoObj" ColumnName="IdxTipoObj" DataSourceName="Equa_XPS.dbo.v_ev2stati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@IdxTipoObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="IdxTipoObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="CodMappa" ColumnName="CodMappa" DataSourceName="Equa_XPS.dbo.v_ev2stati" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (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="GetDataBy" UserSourceName="InsertQuery">
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>INSERT INTO TransizioneEventiStati
(CodMappa, CodStato, IdxTipoObj, CodEvento, NextCodStato)
VALUES (@CodMappa,@CodStato,@IdxTipoObj,@CodEvento,@NextCodStato)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="CodMappa" ColumnName="CodMappa" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@CodMappa" Precision="0" Scale="0" Size="1024" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="CodStato" ColumnName="CodStato" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@CodStato" Precision="0" Scale="0" Size="1024" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="IdxTipoObj" ColumnName="IdxTipoObj" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@IdxTipoObj" Precision="0" Scale="0" Size="1024" SourceColumn="IdxTipoObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="CodEvento" ColumnName="CodEvento" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@CodEvento" Precision="0" Scale="0" Size="1024" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="NextCodStato" ColumnName="NextCodStato" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@NextCodStato" Precision="0" Scale="0" Size="1024" SourceColumn="NextCodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagStatiTableAdapter" GeneratorDataComponentClassName="AnagStatiTableAdapter" Name="AnagStati" UserDataComponentName="AnagStatiTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.AnagStati" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[AnagStati] WHERE (([CodStato] = @Original_CodStato) AND ([FamStato] = @Original_FamStato) AND ((@IsNull_DescrStato = 1 AND [DescrStato] IS NULL) OR ([DescrStato] = @Original_DescrStato)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (@CodStato, @FamStato, @DescrStato);
SELECT CodStato, FamStato, DescrStato FROM AnagStati WHERE (CodStato = @CodStato)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodStato, FamStato, DescrStato FROM dbo.AnagStati</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagStati] SET [CodStato] = @CodStato, [FamStato] = @FamStato, [DescrStato] = @DescrStato WHERE (([CodStato] = @Original_CodStato) AND ([FamStato] = @Original_FamStato) AND ((@IsNull_DescrStato = 1 AND [DescrStato] IS NULL) OR ([DescrStato] = @Original_DescrStato)));
SELECT CodStato, FamStato, DescrStato FROM AnagStati WHERE (CodStato = @CodStato)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrStato" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
<Mapping SourceColumn="FamStato" DataSetColumn="FamStato" />
<Mapping SourceColumn="DescrStato" DataSetColumn="DescrStato" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagObjTableAdapter" GeneratorDataComponentClassName="AnagObjTableAdapter" Name="AnagObj" UserDataComponentName="AnagObjTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.AnagObj" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[AnagObj] WHERE (([CodObj] = @Original_CodObj) AND ((@IsNull_DescrObj = 1 AND [DescrObj] IS NULL) OR ([DescrObj] = @Original_DescrObj)) AND ((@IsNull_FamStato = 1 AND [FamStato] IS NULL) OR ([FamStato] = @Original_FamStato)) AND ((@IsNull_Concreto = 1 AND [Concreto] IS NULL) OR ([Concreto] = @Original_Concreto)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrObj" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrObj" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FamStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Concreto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Concreto" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Concreto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Concreto" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagObj] ([CodObj], [DescrObj], [FamStato], [Concreto]) VALUES (@CodObj, @DescrObj, @FamStato, @Concreto);
SELECT CodObj, DescrObj, FamStato, Concreto FROM AnagObj WHERE (CodObj = @CodObj)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Concreto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Concreto" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodObj, DescrObj, FamStato, Concreto FROM dbo.AnagObj</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagObj] SET [CodObj] = @CodObj, [DescrObj] = @DescrObj, [FamStato] = @FamStato, [Concreto] = @Concreto WHERE (([CodObj] = @Original_CodObj) AND ((@IsNull_DescrObj = 1 AND [DescrObj] IS NULL) OR ([DescrObj] = @Original_DescrObj)) AND ((@IsNull_FamStato = 1 AND [FamStato] IS NULL) OR ([FamStato] = @Original_FamStato)) AND ((@IsNull_Concreto = 1 AND [Concreto] IS NULL) OR ([Concreto] = @Original_Concreto)));
SELECT CodObj, DescrObj, FamStato, Concreto FROM AnagObj WHERE (CodObj = @CodObj)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrObj" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Concreto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Concreto" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrObj" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrObj" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrObj" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FamStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Concreto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Concreto" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Concreto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Concreto" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodObj" DataSetColumn="CodObj" />
<Mapping SourceColumn="DescrObj" DataSetColumn="DescrObj" />
<Mapping SourceColumn="FamStato" DataSetColumn="FamStato" />
<Mapping SourceColumn="Concreto" DataSetColumn="Concreto" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagMappeTableAdapter" GeneratorDataComponentClassName="AnagMappeTableAdapter" Name="AnagMappe" UserDataComponentName="AnagMappeTableAdapter">
<MainSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.AnagMappe" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[AnagMappe] WHERE (([CodMappa] = @Original_CodMappa) AND ((@IsNull_DescrMappa = 1 AND [DescrMappa] IS NULL) OR ([DescrMappa] = @Original_DescrMappa)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrMappa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrMappa" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagMappe] ([CodMappa], [DescrMappa]) VALUES (@CodMappa, @DescrMappa);
SELECT CodMappa, DescrMappa FROM AnagMappe WHERE (CodMappa = @CodMappa)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT CodMappa, DescrMappa FROM dbo.AnagMappe</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagMappe] SET [CodMappa] = @CodMappa, [DescrMappa] = @DescrMappa WHERE (([CodMappa] = @Original_CodMappa) AND ((@IsNull_DescrMappa = 1 AND [DescrMappa] IS NULL) OR ([DescrMappa] = @Original_DescrMappa)));
SELECT CodMappa, DescrMappa FROM AnagMappe WHERE (CodMappa = @CodMappa)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrMappa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrMappa" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CodMappa" DataSetColumn="CodMappa" />
<Mapping SourceColumn="DescrMappa" DataSetColumn="DescrMappa" />
</Mappings>
<Sources>
<DbSource ConnectionRef="Equa_XPSConnectionString (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="Text" ModifiedByUser="true">
<CommandText>DELETE FROM AnagMappe
WHERE (CodMappa = @Original_CodMappa)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Original_CodMappa" ColumnName="CodMappa" DataSourceName="Equa_XPS.dbo.AnagMappe" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@Original_CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
</DbSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (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="GetDataBy1" UserSourceName="UpdateQuery">
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>UPDATE AnagMappe
SET CodMappa = @CodMappa, DescrMappa = @DescrMappa
WHERE (CodMappa = @Original_CodMappa)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="CodMappa" ColumnName="CodMappa" DataSourceName="Equa_XPS.dbo.AnagMappe" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="DescrMappa" ColumnName="DescrMappa" DataSourceName="Equa_XPS.dbo.AnagMappe" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@DescrMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="DescrMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Original_CodMappa" ColumnName="CodMappa" DataSourceName="Equa_XPS.dbo.AnagMappe" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@Original_CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_clonaTransizEventi" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_clonaTransizEventi" MethodsParameterType="CLR" Modifier="Public" Name="sp_clonaTransizEventi" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_clonaTransizEventi">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_clonaTransizEventi</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxTipoObjFrom" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxTipoObjTo" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_clonaStati" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_clonaStati" MethodsParameterType="CLR" Modifier="Public" Name="sp_clonaStati" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="sp_clonaStati">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_clonaStati</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxTipoObjFrom" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxTipoObjTo" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS_prod.dbo.stp_CaricaAnagCliSwing" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="stp_CaricaAnagCliSwing" MethodsParameterType="CLR" Modifier="Public" Name="stp_CaricaAnagCliSwing" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="stp_CaricaAnagCliSwing">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_CaricaAnagCliSwing</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="InputOutput" ParameterName="@esito" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DS_XPS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_XPS" msprop:Generator_UserDSName="DS_XPS">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Note" msprop:Generator_UserTableName="Note" msprop:Generator_RowEvArgName="NoteRowChangeEvent" msprop:Generator_TableVarName="tableNote" msprop:Generator_TablePropName="Note" msprop:Generator_RowDeletingName="NoteRowDeleting" msprop:Generator_RowChangingName="NoteRowChanging" msprop:Generator_RowDeletedName="NoteRowDeleted" msprop:Generator_RowEvHandlerName="NoteRowChangeEventHandler" msprop:Generator_TableClassName="NoteDataTable" msprop:Generator_RowChangedName="NoteRowChanged" msprop:Generator_RowClassName="NoteRow">
<xs:complexType>
<xs:sequence>
<xs:element name="NumNota" msprop:Generator_ColumnVarNameInTable="columnNumNota" msprop:Generator_ColumnPropNameInRow="NumNota" msprop:Generator_ColumnPropNameInTable="NumNotaColumn" msprop:Generator_UserColumnName="NumNota" type="xs:int" />
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodFase" msprop:Generator_ColumnVarNameInTable="columnCodFase" msprop:Generator_ColumnPropNameInRow="CodFase" msprop:Generator_ColumnPropNameInTable="CodFaseColumn" msprop:Generator_UserColumnName="CodFase" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="UserNota" msprop:Generator_ColumnVarNameInTable="columnUserNota" msprop:Generator_ColumnPropNameInRow="UserNota" msprop:Generator_ColumnPropNameInTable="UserNotaColumn" msprop:Generator_UserColumnName="UserNota" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" minOccurs="0" />
<xs:element name="ExtView" msprop:Generator_ColumnVarNameInTable="columnExtView" msprop:Generator_ColumnPropNameInRow="ExtView" msprop:Generator_ColumnPropNameInTable="ExtViewColumn" msprop:Generator_UserColumnName="ExtView" type="xs:boolean" minOccurs="0" />
<xs:element name="Nota" msprop:Generator_ColumnVarNameInTable="columnNota" msprop:Generator_ColumnPropNameInRow="Nota" msprop:Generator_ColumnPropNameInTable="NotaColumn" msprop:Generator_UserColumnName="Nota">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Closed" msprop:Generator_ColumnVarNameInTable="columnClosed" msprop:Generator_ColumnPropNameInRow="Closed" msprop:Generator_ColumnPropNameInTable="ClosedColumn" msprop:Generator_UserColumnName="Closed" type="xs:boolean" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Step4Obj" msprop:Generator_UserTableName="Step4Obj" msprop:Generator_RowEvArgName="Step4ObjRowChangeEvent" msprop:Generator_TableVarName="tableStep4Obj" msprop:Generator_TablePropName="Step4Obj" msprop:Generator_RowDeletingName="Step4ObjRowDeleting" msprop:Generator_RowChangingName="Step4ObjRowChanging" msprop:Generator_RowDeletedName="Step4ObjRowDeleted" msprop:Generator_RowEvHandlerName="Step4ObjRowChangeEventHandler" msprop:Generator_TableClassName="Step4ObjDataTable" msprop:Generator_RowChangedName="Step4ObjRowChanged" msprop:Generator_RowClassName="Step4ObjRow">
<xs:complexType>
<xs:sequence>
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IdxStep" msprop:Generator_ColumnVarNameInTable="columnIdxStep" msprop:Generator_ColumnPropNameInRow="IdxStep" msprop:Generator_ColumnPropNameInTable="IdxStepColumn" msprop:Generator_UserColumnName="IdxStep" type="xs:int" />
<xs:element name="IdxStato" msprop:Generator_ColumnVarNameInTable="columnIdxStato" msprop:Generator_ColumnPropNameInRow="IdxStato" msprop:Generator_ColumnPropNameInTable="IdxStatoColumn" msprop:Generator_UserColumnName="IdxStato" type="xs:int" minOccurs="0" />
<xs:element name="StartDatePrev" msprop:Generator_ColumnVarNameInTable="columnStartDatePrev" msprop:Generator_ColumnPropNameInRow="StartDatePrev" msprop:Generator_ColumnPropNameInTable="StartDatePrevColumn" msprop:Generator_UserColumnName="StartDatePrev" type="xs:dateTime" minOccurs="0" />
<xs:element name="DueDatePrev" msprop:Generator_ColumnVarNameInTable="columnDueDatePrev" msprop:Generator_ColumnPropNameInRow="DueDatePrev" msprop:Generator_ColumnPropNameInTable="DueDatePrevColumn" msprop:Generator_UserColumnName="DueDatePrev" type="xs:dateTime" minOccurs="0" />
<xs:element name="StartDateReal" msprop:Generator_ColumnVarNameInTable="columnStartDateReal" msprop:Generator_ColumnPropNameInRow="StartDateReal" msprop:Generator_ColumnPropNameInTable="StartDateRealColumn" msprop:Generator_UserColumnName="StartDateReal" type="xs:dateTime" minOccurs="0" />
<xs:element name="DueDateReal" msprop:Generator_ColumnVarNameInTable="columnDueDateReal" msprop:Generator_ColumnPropNameInRow="DueDateReal" msprop:Generator_ColumnPropNameInTable="DueDateRealColumn" msprop:Generator_UserColumnName="DueDateReal" type="xs:dateTime" minOccurs="0" />
<xs:element name="RatioCompl" msprop:Generator_ColumnVarNameInTable="columnRatioCompl" msprop:Generator_ColumnPropNameInRow="RatioCompl" msprop:Generator_ColumnPropNameInTable="RatioComplColumn" msprop:Generator_UserColumnName="RatioCompl" type="xs:double" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Object2Set" msprop:Generator_UserTableName="Object2Set" msprop:Generator_RowEvArgName="Object2SetRowChangeEvent" msprop:Generator_TableVarName="tableObject2Set" msprop:Generator_TablePropName="Object2Set" msprop:Generator_RowDeletingName="Object2SetRowDeleting" msprop:Generator_RowChangingName="Object2SetRowChanging" msprop:Generator_RowDeletedName="Object2SetRowDeleted" msprop:Generator_RowEvHandlerName="Object2SetRowChangeEventHandler" msprop:Generator_TableClassName="Object2SetDataTable" msprop:Generator_RowChangedName="Object2SetRowChanged" msprop:Generator_RowClassName="Object2SetRow">
<xs:complexType>
<xs:sequence>
<xs:element name="IdxSet" msprop:Generator_ColumnVarNameInTable="columnIdxSet" msprop:Generator_ColumnPropNameInRow="IdxSet" msprop:Generator_ColumnPropNameInTable="IdxSetColumn" msprop:Generator_UserColumnName="IdxSet">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodObj" msprop:Generator_ColumnVarNameInTable="columnCodObj" msprop:Generator_ColumnPropNameInRow="CodObj" msprop:Generator_ColumnPropNameInTable="CodObjColumn" msprop:Generator_UserColumnName="CodObj">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
<xs:element name="UserQtyReq" msprop:Generator_ColumnVarNameInTable="columnUserQtyReq" msprop:Generator_ColumnPropNameInRow="UserQtyReq" msprop:Generator_ColumnPropNameInTable="UserQtyReqColumn" msprop:Generator_UserColumnName="UserQtyReq" type="xs:boolean" minOccurs="0" />
<xs:element name="Posizione" msprop:Generator_ColumnVarNameInTable="columnPosizione" msprop:Generator_ColumnPropNameInRow="Posizione" msprop:Generator_ColumnPropNameInTable="PosizioneColumn" msprop:Generator_UserColumnName="Posizione" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TimeTrackEnab" msprop:Generator_ColumnVarNameInTable="columnTimeTrackEnab" msprop:Generator_ColumnPropNameInRow="TimeTrackEnab" msprop:Generator_ColumnPropNameInTable="TimeTrackEnabColumn" msprop:Generator_UserColumnName="TimeTrackEnab" type="xs:boolean" minOccurs="0" />
<xs:element name="ProcReq" msprop:Generator_ColumnVarNameInTable="columnProcReq" msprop:Generator_ColumnPropNameInRow="ProcReq" msprop:Generator_ColumnPropNameInTable="ProcReqColumn" msprop:Generator_UserColumnName="ProcReq" type="xs:boolean" minOccurs="0" />
<xs:element name="ExtView" msprop:Generator_ColumnVarNameInTable="columnExtView" msprop:Generator_ColumnPropNameInRow="ExtView" msprop:Generator_ColumnPropNameInTable="ExtViewColumn" msprop:Generator_UserColumnName="ExtView" type="xs:boolean" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="UM" msprop:Generator_UserTableName="UM" msprop:Generator_RowEvArgName="UMRowChangeEvent" msprop:Generator_TableVarName="tableUM" msprop:Generator_TablePropName="UM" msprop:Generator_RowDeletingName="UMRowDeleting" msprop:Generator_RowChangingName="UMRowChanging" msprop:Generator_RowDeletedName="UMRowDeleted" msprop:Generator_RowEvHandlerName="UMRowChangeEventHandler" msprop:Generator_TableClassName="UMDataTable" msprop:Generator_RowChangedName="UMRowChanged" msprop:Generator_RowClassName="UMRow">
<xs:complexType>
<xs:sequence>
<xs:element name="UM" msprop:Generator_ColumnVarNameInTable="columnUM" msprop:Generator_ColumnPropNameInRow="UM" msprop:Generator_ColumnPropNameInTable="UMColumn" msprop:Generator_UserColumnName="UM">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrUM" msprop:Generator_ColumnVarNameInTable="columnDescrUM" msprop:Generator_ColumnPropNameInRow="DescrUM" msprop:Generator_ColumnPropNameInTable="DescrUMColumn" msprop:Generator_UserColumnName="DescrUM" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FattoreSI" msprop:Generator_ColumnVarNameInTable="columnFattoreSI" msprop:Generator_ColumnPropNameInRow="FattoreSI" msprop:Generator_ColumnPropNameInTable="FattoreSIColumn" msprop:Generator_UserColumnName="FattoreSI" type="xs:double" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Eventi" msprop:Generator_UserTableName="Eventi" msprop:Generator_RowEvArgName="EventiRowChangeEvent" msprop:Generator_TableVarName="tableEventi" msprop:Generator_TablePropName="Eventi" msprop:Generator_RowDeletingName="EventiRowDeleting" msprop:Generator_RowChangingName="EventiRowChanging" msprop:Generator_RowDeletedName="EventiRowDeleted" msprop:Generator_RowEvHandlerName="EventiRowChangeEventHandler" msprop:Generator_TableClassName="EventiDataTable" msprop:Generator_RowChangedName="EventiRowChanged" msprop:Generator_RowClassName="EventiRow">
<xs:complexType>
<xs:sequence>
<xs:element name="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn" msprop:Generator_UserColumnName="CodEvento">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodTipoEvento" msprop:Generator_ColumnVarNameInTable="columnCodTipoEvento" msprop:Generator_ColumnPropNameInRow="CodTipoEvento" msprop:Generator_ColumnPropNameInTable="CodTipoEventoColumn" msprop:Generator_UserColumnName="CodTipoEvento" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrEvento" msprop:Generator_ColumnVarNameInTable="columnDescrEvento" msprop:Generator_ColumnPropNameInRow="DescrEvento" msprop:Generator_ColumnPropNameInTable="DescrEventoColumn" msprop:Generator_UserColumnName="DescrEvento" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Action" msprop:Generator_ColumnVarNameInTable="columnAction" msprop:Generator_ColumnPropNameInRow="Action" msprop:Generator_ColumnPropNameInTable="ActionColumn" msprop:Generator_UserColumnName="Action" 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="TipoEventi" msprop:Generator_UserTableName="TipoEventi" msprop:Generator_RowEvArgName="TipoEventiRowChangeEvent" msprop:Generator_TableVarName="tableTipoEventi" msprop:Generator_TablePropName="TipoEventi" msprop:Generator_RowDeletingName="TipoEventiRowDeleting" msprop:Generator_RowChangingName="TipoEventiRowChanging" msprop:Generator_RowDeletedName="TipoEventiRowDeleted" msprop:Generator_RowEvHandlerName="TipoEventiRowChangeEventHandler" msprop:Generator_TableClassName="TipoEventiDataTable" msprop:Generator_RowChangedName="TipoEventiRowChanged" msprop:Generator_RowClassName="TipoEventiRow">
<xs:complexType>
<xs:sequence>
<xs:element name="CodTipoEvento" msprop:Generator_ColumnVarNameInTable="columnCodTipoEvento" msprop:Generator_ColumnPropNameInRow="CodTipoEvento" msprop:Generator_ColumnPropNameInTable="CodTipoEventoColumn" msprop:Generator_UserColumnName="CodTipoEvento">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrTipoEv" msprop:Generator_ColumnVarNameInTable="columnDescrTipoEv" msprop:Generator_ColumnPropNameInRow="DescrTipoEv" msprop:Generator_ColumnPropNameInTable="DescrTipoEvColumn" msprop:Generator_UserColumnName="DescrTipoEv" 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="v_ev2stati" msprop:Generator_UserTableName="v_ev2stati" msprop:Generator_RowEvArgName="v_ev2statiRowChangeEvent" msprop:Generator_TableVarName="tablev_ev2stati" msprop:Generator_TablePropName="v_ev2stati" msprop:Generator_RowDeletingName="v_ev2statiRowDeleting" msprop:Generator_RowChangingName="v_ev2statiRowChanging" msprop:Generator_RowDeletedName="v_ev2statiRowDeleted" msprop:Generator_RowEvHandlerName="v_ev2statiRowChangeEventHandler" msprop:Generator_TableClassName="v_ev2statiDataTable" msprop:Generator_RowChangedName="v_ev2statiRowChanged" msprop:Generator_RowClassName="v_ev2statiRow">
<xs:complexType>
<xs:sequence>
<xs:element name="CodMappa" msprop:Generator_ColumnVarNameInTable="columnCodMappa" msprop:Generator_ColumnPropNameInRow="CodMappa" msprop:Generator_ColumnPropNameInTable="CodMappaColumn" msprop:Generator_UserColumnName="CodMappa">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IdxTipoObj" msprop:Generator_ColumnVarNameInTable="columnIdxTipoObj" msprop:Generator_ColumnPropNameInRow="IdxTipoObj" msprop:Generator_ColumnPropNameInTable="IdxTipoObjColumn" msprop:Generator_UserColumnName="IdxTipoObj">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrObj" msprop:Generator_ColumnVarNameInTable="columnDescrObj" msprop:Generator_ColumnPropNameInRow="DescrObj" msprop:Generator_ColumnPropNameInTable="DescrObjColumn" msprop:Generator_UserColumnName="DescrObj" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StatoCurr" msprop:Generator_ColumnVarNameInTable="columnStatoCurr" msprop:Generator_ColumnPropNameInRow="StatoCurr" msprop:Generator_ColumnPropNameInTable="StatoCurrColumn" msprop:Generator_UserColumnName="StatoCurr" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn" msprop:Generator_UserColumnName="CodEvento">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrEvento" msprop:Generator_ColumnVarNameInTable="columnDescrEvento" msprop:Generator_ColumnPropNameInRow="DescrEvento" msprop:Generator_ColumnPropNameInTable="DescrEventoColumn" msprop:Generator_UserColumnName="DescrEvento" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NextCodStato" msprop:Generator_ColumnVarNameInTable="columnNextCodStato" msprop:Generator_ColumnPropNameInRow="NextCodStato" msprop:Generator_ColumnPropNameInTable="NextCodStatoColumn" msprop:Generator_UserColumnName="NextCodStato" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StatoNext" msprop:Generator_ColumnVarNameInTable="columnStatoNext" msprop:Generator_ColumnPropNameInRow="StatoNext" msprop:Generator_ColumnPropNameInTable="StatoNextColumn" msprop:Generator_UserColumnName="StatoNext" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagStati" msprop:Generator_UserTableName="AnagStati" msprop:Generator_RowEvArgName="AnagStatiRowChangeEvent" msprop:Generator_TableVarName="tableAnagStati" msprop:Generator_TablePropName="AnagStati" msprop:Generator_RowDeletingName="AnagStatiRowDeleting" msprop:Generator_RowChangingName="AnagStatiRowChanging" msprop:Generator_RowDeletedName="AnagStatiRowDeleted" msprop:Generator_RowEvHandlerName="AnagStatiRowChangeEventHandler" msprop:Generator_TableClassName="AnagStatiDataTable" msprop:Generator_RowChangedName="AnagStatiRowChanged" msprop:Generator_RowClassName="AnagStatiRow">
<xs:complexType>
<xs:sequence>
<xs:element name="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FamStato" msprop:Generator_ColumnVarNameInTable="columnFamStato" msprop:Generator_ColumnPropNameInRow="FamStato" msprop:Generator_ColumnPropNameInTable="FamStatoColumn" msprop:Generator_UserColumnName="FamStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrStato" msprop:Generator_ColumnVarNameInTable="columnDescrStato" msprop:Generator_ColumnPropNameInRow="DescrStato" msprop:Generator_ColumnPropNameInTable="DescrStatoColumn" msprop:Generator_UserColumnName="DescrStato" 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="AnagObj" msprop:Generator_UserTableName="AnagObj" msprop:Generator_RowEvArgName="AnagObjRowChangeEvent" msprop:Generator_TableVarName="tableAnagObj" msprop:Generator_TablePropName="AnagObj" msprop:Generator_RowDeletingName="AnagObjRowDeleting" msprop:Generator_RowChangingName="AnagObjRowChanging" msprop:Generator_RowDeletedName="AnagObjRowDeleted" msprop:Generator_RowEvHandlerName="AnagObjRowChangeEventHandler" msprop:Generator_TableClassName="AnagObjDataTable" msprop:Generator_RowChangedName="AnagObjRowChanged" msprop:Generator_RowClassName="AnagObjRow">
<xs:complexType>
<xs:sequence>
<xs:element name="CodObj" msprop:Generator_ColumnVarNameInTable="columnCodObj" msprop:Generator_ColumnPropNameInRow="CodObj" msprop:Generator_ColumnPropNameInTable="CodObjColumn" msprop:Generator_UserColumnName="CodObj">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrObj" msprop:Generator_ColumnVarNameInTable="columnDescrObj" msprop:Generator_ColumnPropNameInRow="DescrObj" msprop:Generator_ColumnPropNameInTable="DescrObjColumn" msprop:Generator_UserColumnName="DescrObj" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FamStato" msprop:Generator_ColumnVarNameInTable="columnFamStato" msprop:Generator_ColumnPropNameInRow="FamStato" msprop:Generator_ColumnPropNameInTable="FamStatoColumn" msprop:Generator_UserColumnName="FamStato" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Concreto" msprop:Generator_ColumnVarNameInTable="columnConcreto" msprop:Generator_ColumnPropNameInRow="Concreto" msprop:Generator_ColumnPropNameInTable="ConcretoColumn" msprop:Generator_UserColumnName="Concreto" type="xs:boolean" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagMappe" msprop:Generator_TableClassName="AnagMappeDataTable" msprop:Generator_RowEvArgName="AnagMappeRowChangeEvent" msprop:Generator_TableVarName="tableAnagMappe" msprop:Generator_TablePropName="AnagMappe" msprop:Generator_RowDeletingName="AnagMappeRowDeleting" msprop:Generator_RowChangingName="AnagMappeRowChanging" msprop:Generator_RowEvHandlerName="AnagMappeRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagMappeRowDeleted" msprop:Generator_UserTableName="AnagMappe" msprop:Generator_RowChangedName="AnagMappeRowChanged" msprop:Generator_RowClassName="AnagMappeRow">
<xs:complexType>
<xs:sequence>
<xs:element name="CodMappa" msprop:Generator_ColumnVarNameInTable="columnCodMappa" msprop:Generator_ColumnPropNameInRow="CodMappa" msprop:Generator_ColumnPropNameInTable="CodMappaColumn" msprop:Generator_UserColumnName="CodMappa">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DescrMappa" msprop:Generator_ColumnVarNameInTable="columnDescrMappa" msprop:Generator_ColumnPropNameInRow="DescrMappa" msprop:Generator_ColumnPropNameInTable="DescrMappaColumn" msprop:Generator_UserColumnName="DescrMappa" 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:Note" />
<xs:field xpath="mstns:NumNota" />
</xs:unique>
<xs:unique name="Step4Obj_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Step4Obj" />
<xs:field xpath="mstns:IdxObj" />
<xs:field xpath="mstns:IdxStep" />
</xs:unique>
<xs:unique name="Object2Set_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Object2Set" />
<xs:field xpath="mstns:IdxSet" />
<xs:field xpath="mstns:CodObj" />
</xs:unique>
<xs:unique name="UM_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:UM" />
<xs:field xpath="mstns:UM" />
</xs:unique>
<xs:unique name="Eventi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Eventi" />
<xs:field xpath="mstns:CodEvento" />
</xs:unique>
<xs:unique name="TipoEventi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:TipoEventi" />
<xs:field xpath="mstns:CodTipoEvento" />
</xs:unique>
<xs:unique name="v_ev2stati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:v_ev2stati" />
<xs:field xpath="mstns:CodMappa" />
<xs:field xpath="mstns:IdxTipoObj" />
<xs:field xpath="mstns:CodStato" />
<xs:field xpath="mstns:CodEvento" />
</xs:unique>
<xs:unique name="AnagStati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagStati" />
<xs:field xpath="mstns:CodStato" />
</xs:unique>
<xs:unique name="AnagObj_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagObj" />
<xs:field xpath="mstns:CodObj" />
</xs:unique>
<xs:unique name="AnagMappe_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagMappe" />
<xs:field xpath="mstns:CodMappa" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="FK_Eventi_TipoEventi" msdata:parent="TipoEventi" msdata:child="Eventi" msdata:parentkey="CodTipoEvento" msdata:childkey="CodTipoEvento" msprop:Generator_UserChildTable="Eventi" msprop:Generator_ChildPropName="GetEventiRows" msprop:Generator_UserRelationName="FK_Eventi_TipoEventi" msprop:Generator_RelationVarName="relationFK_Eventi_TipoEventi" msprop:Generator_UserParentTable="TipoEventi" msprop:Generator_ParentPropName="TipoEventiRow" />
<msdata:Relationship name="FK_ObjectSet_AnagTipoObj" msdata:parent="AnagObj" msdata:child="Object2Set" msdata:parentkey="CodObj" msdata:childkey="CodObj" msprop:Generator_UserChildTable="Object2Set" msprop:Generator_ChildPropName="GetObject2SetRows" msprop:Generator_UserRelationName="FK_ObjectSet_AnagTipoObj" msprop:Generator_RelationVarName="relationFK_ObjectSet_AnagTipoObj" msprop:Generator_UserParentTable="AnagObj" msprop:Generator_ParentPropName="AnagObjRow" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
Reference in New Issue View Git Blame Copy Permalink