Egalware/b2bcondomini.it
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
b2bcondomini.it/Data/DS_app.xsd
T
Samuele Locatelli 63fb416b64 Fix gestione descr condomini oltre 30char
2024-07-30 10:07:05 +02:00

2055 lines
244 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DS_app" targetNamespace="http://tempuri.org/DS_app.xsd" xmlns:mstns="http://tempuri.org/DS_app.xsd" xmlns="http://tempuri.org/DS_app.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="B2BCondConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="B2BCondConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Data.Properties.Settings.GlobalReference.Default.B2BCondConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagAmministratoriTableAdapter" GeneratorDataComponentClassName="AnagAmministratoriTableAdapter" Name="AnagAmministratori" UserDataComponentName="AnagAmministratoriTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_AnagAmministratori" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM dbo.v_AnagAmministratori</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxAmm" DataSetColumn="idxAmm" />
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
<Mapping SourceColumn="email" DataSetColumn="email" />
<Mapping SourceColumn="NumCondAttivi" DataSetColumn="NumCondAttivi" />
<Mapping SourceColumn="NumCondInattivi" DataSetColumn="NumCond" />
<Mapping SourceColumn="NumRich" DataSetColumn="NumRich" />
<Mapping SourceColumn="NumInt" DataSetColumn="NumInt" />
<Mapping SourceColumn="ImponibileTot" DataSetColumn="ImponibileTot" />
<Mapping SourceColumn="ImponibileMedio" DataSetColumn="ImponibileMedio" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AA_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AA_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagCondominiTableAdapter" GeneratorDataComponentClassName="AnagCondominiTableAdapter" Name="AnagCondomini" UserDataComponentName="AnagCondominiTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_anagCondomini" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM v_AnagCondomini</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxCond" DataSetColumn="idxCond" />
<Mapping SourceColumn="cod_cond" DataSetColumn="cod_cond" />
<Mapping SourceColumn="nome" DataSetColumn="nome" />
<Mapping SourceColumn="indirizzo" DataSetColumn="indirizzo" />
<Mapping SourceColumn="cap" DataSetColumn="cap" />
<Mapping SourceColumn="citta" DataSetColumn="citta" />
<Mapping SourceColumn="cod_fisc" DataSetColumn="cod_fisc" />
<Mapping SourceColumn="idxAmm" DataSetColumn="idxAmm" />
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
<Mapping SourceColumn="note" DataSetColumn="note" />
<Mapping SourceColumn="nomeFull" DataSetColumn="nomeFull" />
<Mapping SourceColumn="numRich" DataSetColumn="numRich" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AC_deleteQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_getByAmm" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByAmm" GetMethodModifier="Public" GetMethodName="getByAmm" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByAmm" UserSourceName="getByAmm">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AC_getByAmm</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_getByForn" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByForn" GetMethodModifier="Public" GetMethodName="getByForn" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByForn" UserSourceName="getByForn">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AC_getByForn</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="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AC_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_getPBO" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByPBO" GetMethodModifier="Public" GetMethodName="getByPBO" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByPBO" UserSourceName="getByPBO">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AC_getPBO</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="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_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_AC_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="@cod_cond" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="30" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AC_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AC_updateQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cod_cond" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cod_fisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Attivo" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@note" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagAreeTableAdapter" GeneratorDataComponentClassName="AnagAreeTableAdapter" Name="AnagAree" UserDataComponentName="AnagAreeTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_AnagAree" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT * FROM dbo.v_AnagAree order by Area</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxArea" DataSetColumn="idxArea" />
<Mapping SourceColumn="Area" DataSetColumn="Area" />
<Mapping SourceColumn="Note" DataSetColumn="Note" />
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
<Mapping SourceColumn="CssClass" DataSetColumn="CssClass" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AAF_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteRelF2A" Modifier="Public" Name="deleteRelF2A" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteRelF2A">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AAF_deleteQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AAF_getByForn" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByForn" GetMethodModifier="Public" GetMethodName="getByForn" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByForn" UserSourceName="getByForn">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AAF_getByForn</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="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AAF_getUnassigned" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getUnassigned" GetMethodModifier="Public" GetMethodName="getUnassigned" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getUnassigned" UserSourceName="getUnassigned">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AAF_getUnassigned</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="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagFornitoriTableAdapter" GeneratorDataComponentClassName="AnagFornitoriTableAdapter" Name="AnagFornitori" UserDataComponentName="AnagFornitoriTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_AnagFornitori" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT * FROM v_AnagFornitori</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
<Mapping SourceColumn="nome" DataSetColumn="nome" />
<Mapping SourceColumn="indirizzo" DataSetColumn="indirizzo" />
<Mapping SourceColumn="CAP" DataSetColumn="CAP" />
<Mapping SourceColumn="citta" DataSetColumn="citta" />
<Mapping SourceColumn="provincia" DataSetColumn="provincia" />
<Mapping SourceColumn="stato" DataSetColumn="stato" />
<Mapping SourceColumn="pIva" DataSetColumn="pIva" />
<Mapping SourceColumn="cFisc" DataSetColumn="cFisc" />
<Mapping SourceColumn="email" DataSetColumn="email" />
<Mapping SourceColumn="telefono" DataSetColumn="telefono" />
<Mapping SourceColumn="cellulare" DataSetColumn="cellulare" />
<Mapping SourceColumn="iscritta" DataSetColumn="iscritta" />
<Mapping SourceColumn="attivo" DataSetColumn="attivo" />
<Mapping SourceColumn="cssStatoForn" DataSetColumn="cssStatoForn" />
<Mapping SourceColumn="quotaStd" DataSetColumn="quotaStd" />
<Mapping SourceColumn="noteQuota" DataSetColumn="noteQuota" />
<Mapping SourceColumn="numRich" DataSetColumn="numRich" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AF_deleteQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_getByArea" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByArea" GetMethodModifier="Public" GetMethodName="getByArea" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByArea" UserSourceName="getByArea">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AF_getByArea</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="@idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_getByCond" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCond" GetMethodModifier="Public" GetMethodName="getByCond" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCond" UserSourceName="getByCond">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AF_getByCond</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="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AF_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_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_AF_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="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CAP" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@pIva" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cFisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cellulare" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@iscritta" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@attivo" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@quotaStd" Precision="9" ProviderType="Decimal" Scale="3" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@noteQuota" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AF_updateQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CAP" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@pIva" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cFisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cellulare" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@iscritta" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@attivo" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@quotaStd" Precision="9" ProviderType="Decimal" Scale="3" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@noteQuota" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssF2ATableAdapter" GeneratorDataComponentClassName="AssF2ATableAdapter" Name="AssF2A" UserDataComponentName="AssF2ATableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AssF2A" 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 [AssF2A] WHERE (([idxFornitore] = @Original_idxFornitore) AND ([idxArea] = @Original_idxArea) AND ([Attivazione] = @Original_Attivazione))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxArea" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Attivazione" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Attivazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [AssF2A] ([idxFornitore], [idxArea], [Attivazione]) VALUES (@idxFornitore, @idxArea, @Attivazione);
SELECT idxFornitore, idxArea, Attivazione FROM AssF2A WHERE (idxArea = @idxArea) AND (idxFornitore = @idxFornitore)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxArea" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Attivazione" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Attivazione" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM AssF2A</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [AssF2A] SET [idxFornitore] = @idxFornitore, [idxArea] = @idxArea, [Attivazione] = @Attivazione WHERE (([idxFornitore] = @Original_idxFornitore) AND ([idxArea] = @Original_idxArea) AND ([Attivazione] = @Original_Attivazione));
SELECT idxFornitore, idxArea, Attivazione FROM AssF2A WHERE (idxArea = @idxArea) AND (idxFornitore = @idxFornitore)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxArea" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Attivazione" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Attivazione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxArea" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Attivazione" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Attivazione" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
<Mapping SourceColumn="idxArea" DataSetColumn="idxArea" />
<Mapping SourceColumn="Attivazione" DataSetColumn="Attivazione" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AssF2A_insertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="insertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AssF2A_insertQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssF2CTableAdapter" GeneratorDataComponentClassName="AssF2CTableAdapter" Name="AssF2C" UserDataComponentName="AssF2CTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_AssF2C" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM v_AssF2C</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxCond" DataSetColumn="idxCond" />
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
<Mapping SourceColumn="idxArea" DataSetColumn="idxArea" />
<Mapping SourceColumn="Attivazione" DataSetColumn="Attivazione" />
<Mapping SourceColumn="Priorita" DataSetColumn="Priorita" />
<Mapping SourceColumn="cod_cond" DataSetColumn="cod_cond" />
<Mapping SourceColumn="idxAmm" DataSetColumn="idxAmm" />
<Mapping SourceColumn="nomeCond" DataSetColumn="nomeCond" />
<Mapping SourceColumn="indirCond" DataSetColumn="indirCond" />
<Mapping SourceColumn="capCond" DataSetColumn="capCond" />
<Mapping SourceColumn="cittaCond" DataSetColumn="cittaCond" />
<Mapping SourceColumn="Area" DataSetColumn="Area" />
<Mapping SourceColumn="CssClass" DataSetColumn="CssClass" />
<Mapping SourceColumn="nomrForn" DataSetColumn="nomeForn" />
<Mapping SourceColumn="indirizzo" DataSetColumn="indirizzo" />
<Mapping SourceColumn="p_iva" DataSetColumn="p_iva" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AssF2C_getByCond" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCond" GetMethodModifier="Public" GetMethodName="getByCond" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCond" UserSourceName="getByCond">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AssF2C_getByCond</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="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AssF2C_setupMissing" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="setupMissing" Modifier="Public" Name="setupMissing" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="setupMissing">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AssF2C_setupMissing</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="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AssF2C_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="updateQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AssF2C_updateQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Priorita" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PBO_DashStatsTableAdapter" GeneratorDataComponentClassName="PBO_DashStatsTableAdapter" Name="PBO_DashStats" UserDataComponentName="PBO_DashStatsTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_PBO_DashStats" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_PBO_DashStats</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" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="numUsers" DataSetColumn="numUsers" />
<Mapping SourceColumn="reqUsers" DataSetColumn="reqUsers" />
<Mapping SourceColumn="numForn" DataSetColumn="numForn" />
<Mapping SourceColumn="reqForn" DataSetColumn="reqForn" />
<Mapping SourceColumn="numReq" DataSetColumn="numReq" />
<Mapping SourceColumn="reqReq" DataSetColumn="reqReq" />
<Mapping SourceColumn="numInt" DataSetColumn="numInt" />
<Mapping SourceColumn="reqInt" DataSetColumn="reqInt" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencolRichTableAdapter" GeneratorDataComponentClassName="ElencolRichTableAdapter" Name="ElencolRich" UserDataComponentName="ElencolRichTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_ElencolRich" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM v_ElencolRich</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxRichiesta" DataSetColumn="idxRichiesta" />
<Mapping SourceColumn="idxStato" DataSetColumn="idxStato" />
<Mapping SourceColumn="idxCond" DataSetColumn="idxCond" />
<Mapping SourceColumn="idxPriorita" DataSetColumn="idxPriorita" />
<Mapping SourceColumn="idxArea" DataSetColumn="idxArea" />
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
<Mapping SourceColumn="cod_cond" DataSetColumn="cod_cond" />
<Mapping SourceColumn="nom_cond" DataSetColumn="nom_cond" />
<Mapping SourceColumn="indir_cond" DataSetColumn="indir_cond" />
<Mapping SourceColumn="dataIns" DataSetColumn="dataIns" />
<Mapping SourceColumn="dataRich" DataSetColumn="dataRich" />
<Mapping SourceColumn="dataScad" DataSetColumn="dataScad" />
<Mapping SourceColumn="codCollabRich" DataSetColumn="codCollabRich" />
<Mapping SourceColumn="genContatto" DataSetColumn="genContatto" />
<Mapping SourceColumn="telContatto" DataSetColumn="telContatto" />
<Mapping SourceColumn="messaggio" DataSetColumn="messaggio" />
<Mapping SourceColumn="note" DataSetColumn="note" />
<Mapping SourceColumn="iscritta" DataSetColumn="iscritta" />
<Mapping SourceColumn="stato" DataSetColumn="stato" />
<Mapping SourceColumn="cssStato" DataSetColumn="cssStato" />
<Mapping SourceColumn="qtaAzioni" DataSetColumn="qtaAzioni" />
<Mapping SourceColumn="collaboratore" DataSetColumn="collaboratore" />
<Mapping SourceColumn="cssStatoForn" DataSetColumn="cssStatoForn" />
<Mapping SourceColumn="cod_fornitore" DataSetColumn="cod_fornitore" />
<Mapping SourceColumn="freezed" DataSetColumn="freezed" />
<Mapping SourceColumn="dateUnfreeze" DataSetColumn="dateUnfreeze" />
<Mapping SourceColumn="scaduto" DataSetColumn="scaduto" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_getByCond" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCondStato" GetMethodModifier="Public" GetMethodName="getByCondStato" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCondStato" UserSourceName="getByCondStato">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_getByCond</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@isPBO" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@minStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maxStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@freezed" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@scaduto" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_InsertQuery" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="InsertQuery" GeneratorSourceName="InsertQuery" GetMethodModifier="Public" GetMethodName="InsertQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="InsertQuery" UserSourceName="InsertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_InsertQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxPrior" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataIns" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataScad" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codCollabRich" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@genContatto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@telContatto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@messaggio" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_UpdateForn" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateForn" Modifier="Public" Name="UpdateForn" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateForn">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_UpdateForn</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxArea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_UpdateFreezed" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateFreezed" Modifier="Public" Name="UpdateFreezed" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateFreezed">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_UpdateFreezed</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@freezed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_UpdatePrior" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdatePrior" Modifier="Public" Name="UpdatePrior" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdatePrior">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_UpdatePrior</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxPriorita" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataScad" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_UpdateScad" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateScad" Modifier="Public" Name="UpdateScad" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateScad">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_UpdateScad</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataScad" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_UpdateStato" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateStato" Modifier="Public" Name="UpdateStato" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateStato">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_UpdateStato</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_UpdateText" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateText" Modifier="Public" Name="UpdateText" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateText">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_UpdateText</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@messaggio" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@note" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagStatiTableAdapter" GeneratorDataComponentClassName="AnagStatiTableAdapter" Name="AnagStati" UserDataComponentName="AnagStatiTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.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 [AnagStati] WHERE (([idxStato] = @Original_idxStato) AND ([stato] = @Original_stato) AND ([descrizione] = @Original_descrizione) AND ([cssStato] = @Original_cssStato))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssStato" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [AnagStati] ([idxStato], [stato], [descrizione], [cssStato]) VALUES (@idxStato, @stato, @descrizione, @cssStato);
SELECT idxStato, stato, descrizione, cssStato FROM AnagStati WHERE (idxStato = @idxStato)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssStato" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxStato, stato, descrizione, cssStato
FROM AnagStati</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [AnagStati] SET [idxStato] = @idxStato, [stato] = @stato, [descrizione] = @descrizione, [cssStato] = @cssStato WHERE (([idxStato] = @Original_idxStato) AND ([stato] = @Original_stato) AND ([descrizione] = @Original_descrizione) AND ([cssStato] = @Original_cssStato));
SELECT idxStato, stato, descrizione, cssStato FROM AnagStati WHERE (idxStato = @idxStato)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssStato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxStato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssStato" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxStato" DataSetColumn="idxStato" />
<Mapping SourceColumn="stato" DataSetColumn="stato" />
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
<Mapping SourceColumn="cssStato" DataSetColumn="cssStato" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AS_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AS_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatoRichByCondTableAdapter" GeneratorDataComponentClassName="StatoRichByCondTableAdapter" Name="StatoRichByCond" UserDataComponentName="StatoRichByCondTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_StatoRich_getByCond" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_StatoRich_getByCond</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@minStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maxStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="cod_cond" DataSetColumn="cod_cond" />
<Mapping SourceColumn="nom_cond" DataSetColumn="nom_cond" />
<Mapping SourceColumn="nRichieste" DataSetColumn="nRichieste" />
<Mapping SourceColumn="nPreventivi" DataSetColumn="nPreventivi" />
<Mapping SourceColumn="nAperte" DataSetColumn="nAperte" />
<Mapping SourceColumn="nSospese" DataSetColumn="nSospese" />
<Mapping SourceColumn="nConcluse" DataSetColumn="nConcluse" />
<Mapping SourceColumn="nFatturate" DataSetColumn="nFatturate" />
<Mapping SourceColumn="nPagate" DataSetColumn="nPagate" />
<Mapping SourceColumn="nContestate" DataSetColumn="nContestate" />
<Mapping SourceColumn="nProgrammate" DataSetColumn="nProgrammate" />
<Mapping SourceColumn="nCongelate" DataSetColumn="nCongelate" />
<Mapping SourceColumn="nAnnullate" DataSetColumn="nAnnullate" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PAM_DashStatsTableAdapter" GeneratorDataComponentClassName="PAM_DashStatsTableAdapter" Name="PAM_DashStats" UserDataComponentName="PAM_DashStatsTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_PAM_DashStats" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_PAM_DashStats</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="numUsers" DataSetColumn="numUsers" />
<Mapping SourceColumn="reqUsers" DataSetColumn="reqUsers" />
<Mapping SourceColumn="nRichieste" DataSetColumn="nRichieste" />
<Mapping SourceColumn="nPrevReq" DataSetColumn="nPrevReq" />
<Mapping SourceColumn="nPrevAppr" DataSetColumn="nPrevAppr" />
<Mapping SourceColumn="nAperte" DataSetColumn="nAperte" />
<Mapping SourceColumn="nSospese" DataSetColumn="nSospese" />
<Mapping SourceColumn="nConcluse" DataSetColumn="nConcluse" />
<Mapping SourceColumn="nFatturate" DataSetColumn="nFatturate" />
<Mapping SourceColumn="nPagate" DataSetColumn="nPagate" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagPriorTableAdapter" GeneratorDataComponentClassName="AnagPriorTableAdapter" Name="AnagPrior" UserDataComponentName="AnagPriorTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AnagPrior" 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].[AnagPrior] WHERE (([idxPriorita] = @Original_idxPriorita) AND ([descrPriorita] = @Original_descrPriorita) AND ([scadenzaGg] = @Original_scadenzaGg))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxPriorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxPriorita" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrPriorita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrPriorita" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_scadenzaGg" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="scadenzaGg" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagPrior] ([idxPriorita], [descrPriorita], [scadenzaGg]) VALUES (@idxPriorita, @descrPriorita, @scadenzaGg);
SELECT idxPriorita, descrPriorita, scadenzaGg FROM AnagPrior WHERE (idxPriorita = @idxPriorita)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxPriorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxPriorita" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrPriorita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrPriorita" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@scadenzaGg" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="scadenzaGg" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxPriorita, descrPriorita, scadenzaGg FROM dbo.AnagPrior</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagPrior] SET [idxPriorita] = @idxPriorita, [descrPriorita] = @descrPriorita, [scadenzaGg] = @scadenzaGg WHERE (([idxPriorita] = @Original_idxPriorita) AND ([descrPriorita] = @Original_descrPriorita) AND ([scadenzaGg] = @Original_scadenzaGg));
SELECT idxPriorita, descrPriorita, scadenzaGg FROM AnagPrior WHERE (idxPriorita = @idxPriorita)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxPriorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxPriorita" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrPriorita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrPriorita" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@scadenzaGg" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="scadenzaGg" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxPriorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxPriorita" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrPriorita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrPriorita" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_scadenzaGg" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="scadenzaGg" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxPriorita" DataSetColumn="idxPriorita" />
<Mapping SourceColumn="descrPriorita" DataSetColumn="descrPriorita" />
<Mapping SourceColumn="scadenzaGg" DataSetColumn="scadenzaGg" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AP_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AP_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxPriorita" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ER_ActsTableAdapter" GeneratorDataComponentClassName="ER_ActsTableAdapter" Name="ER_Acts" UserDataComponentName="ER_ActsTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_ER_Acts" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT *
FROM v_ER_Acts</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxAzione" DataSetColumn="idxAzione" />
<Mapping SourceColumn="idxRichiesta" DataSetColumn="idxRichiesta" />
<Mapping SourceColumn="dataRif" DataSetColumn="dataRif" />
<Mapping SourceColumn="codAzione" DataSetColumn="codAzione" />
<Mapping SourceColumn="descrAzione" DataSetColumn="descrAzione" />
<Mapping SourceColumn="cssIcon" DataSetColumn="cssIcon" />
<Mapping SourceColumn="classe" DataSetColumn="classe" />
<Mapping SourceColumn="attore" DataSetColumn="attore" />
<Mapping SourceColumn="genAttore" DataSetColumn="genAttore" />
<Mapping SourceColumn="messaggio" DataSetColumn="messaggio" />
<Mapping SourceColumn="cssButton" DataSetColumn="cssButton" />
<Mapping SourceColumn="cssText" DataSetColumn="cssText" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_Acts_getByIdxRich" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxRich" GetMethodModifier="Public" GetMethodName="getByIdxRich" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxRich" UserSourceName="getByIdxRich">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_Acts_getByIdxRich</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="@idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_ER_Acts_InsertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_ER_Acts_InsertQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataRif" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@attore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@messaggio" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PAZ_DashStatsTableAdapter" GeneratorDataComponentClassName="PAZ_DashStatsTableAdapter" Name="PAZ_DashStats" UserDataComponentName="PAZ_DashStatsTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_PAZ_DashStats" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_PAZ_DashStats</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="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="nRichieste" DataSetColumn="nRichieste" />
<Mapping SourceColumn="nPrevReq" DataSetColumn="nPrevReq" />
<Mapping SourceColumn="nPrevAppr" DataSetColumn="nPrevAppr" />
<Mapping SourceColumn="nAperte" DataSetColumn="nAperte" />
<Mapping SourceColumn="nSospese" DataSetColumn="nSospese" />
<Mapping SourceColumn="nConcluse" DataSetColumn="nConcluse" />
<Mapping SourceColumn="nFatturate" DataSetColumn="nFatturate" />
<Mapping SourceColumn="nPagate" DataSetColumn="nPagate" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagActsTableAdapter" GeneratorDataComponentClassName="AnagActsTableAdapter" Name="AnagActs" UserDataComponentName="AnagActsTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AnagActs" 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].[AnagActs] WHERE (([codAzione] = @Original_codAzione) AND ([classe] = @Original_classe) AND ([descrAzione] = @Original_descrAzione) AND ([cssIcon] = @Original_cssIcon) AND ([cssButton] = @Original_cssButton) AND ([cssText] = @Original_cssText))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codAzione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_classe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="classe" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrAzione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssIcon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssIcon" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssButton" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssButton" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssText" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssText" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[AnagActs] ([codAzione], [classe], [descrAzione], [cssIcon], [cssButton], [cssText]) VALUES (@codAzione, @classe, @descrAzione, @cssIcon, @cssButton, @cssText);
SELECT codAzione, classe, descrAzione, cssIcon, cssButton, cssText FROM AnagActs WHERE (codAzione = @codAzione)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codAzione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@classe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="classe" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrAzione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssIcon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssIcon" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssButton" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssButton" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssText" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssText" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT codAzione, classe, descrAzione, cssIcon, cssButton, cssText FROM dbo.AnagActs</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[AnagActs] SET [codAzione] = @codAzione, [classe] = @classe, [descrAzione] = @descrAzione, [cssIcon] = @cssIcon, [cssButton] = @cssButton, [cssText] = @cssText WHERE (([codAzione] = @Original_codAzione) AND ([classe] = @Original_classe) AND ([descrAzione] = @Original_descrAzione) AND ([cssIcon] = @Original_cssIcon) AND ([cssButton] = @Original_cssButton) AND ([cssText] = @Original_cssText));
SELECT codAzione, classe, descrAzione, cssIcon, cssButton, cssText FROM AnagActs WHERE (codAzione = @codAzione)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codAzione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@classe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="classe" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrAzione" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssIcon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssIcon" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssButton" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssButton" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssText" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssText" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codAzione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_classe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="classe" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrAzione" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssIcon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssIcon" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssButton" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssButton" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssText" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssText" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="codAzione" DataSetColumn="codAzione" />
<Mapping SourceColumn="classe" DataSetColumn="classe" />
<Mapping SourceColumn="descrAzione" DataSetColumn="descrAzione" />
<Mapping SourceColumn="cssIcon" DataSetColumn="cssIcon" />
<Mapping SourceColumn="cssButton" DataSetColumn="cssButton" />
<Mapping SourceColumn="cssText" DataSetColumn="cssText" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AAct_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_AAct_getByKey</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codAzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FattureTableAdapter" GeneratorDataComponentClassName="FattureTableAdapter" Name="Fatture" UserDataComponentName="FattureTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.Fatture" 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].[Fatture] WHERE (([idxDoc] = @Original_idxDoc) AND ([idxRichiesta] = @Original_idxRichiesta) AND ([idxFornitore] = @Original_idxFornitore) AND ([numDoc] = @Original_numDoc) AND ([dataFatt] = @Original_dataFatt) AND ([Imponibile] = @Original_Imponibile) AND ((@IsNull_dataPag = 1 AND [dataPag] IS NULL) OR ([dataPag] = @Original_dataPag)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxRichiesta" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dataFatt" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataFatt" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Imponibile" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Imponibile" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataPag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataPag" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dataPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataPag" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Fatture] ([idxRichiesta], [idxFornitore], [numDoc], [dataFatt], [intervento], [Imponibile], [dataPag]) VALUES (@idxRichiesta, @idxFornitore, @numDoc, @dataFatt, @intervento, @Imponibile, @dataPag);
SELECT idxDoc, idxRichiesta, idxFornitore, numDoc, dataFatt, intervento, Imponibile, dataPag FROM Fatture WHERE (idxDoc = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxRichiesta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxRichiesta" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dataFatt" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataFatt" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@intervento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="intervento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Imponibile" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Imponibile" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dataPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataPag" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxDoc, idxRichiesta, idxFornitore, numDoc, dataFatt, intervento, Imponibile, dataPag FROM dbo.Fatture</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Fatture] SET [idxRichiesta] = @idxRichiesta, [idxFornitore] = @idxFornitore, [numDoc] = @numDoc, [dataFatt] = @dataFatt, [intervento] = @intervento, [Imponibile] = @Imponibile, [dataPag] = @dataPag WHERE (([idxDoc] = @Original_idxDoc) AND ([idxRichiesta] = @Original_idxRichiesta) AND ([idxFornitore] = @Original_idxFornitore) AND ([numDoc] = @Original_numDoc) AND ([dataFatt] = @Original_dataFatt) AND ([Imponibile] = @Original_Imponibile) AND ((@IsNull_dataPag = 1 AND [dataPag] IS NULL) OR ([dataPag] = @Original_dataPag)));
SELECT idxDoc, idxRichiesta, idxFornitore, numDoc, dataFatt, intervento, Imponibile, dataPag FROM Fatture WHERE (idxDoc = @idxDoc)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxRichiesta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxRichiesta" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dataFatt" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataFatt" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@intervento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="intervento" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Imponibile" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Imponibile" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dataPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataPag" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxRichiesta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxRichiesta" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dataFatt" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataFatt" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Imponibile" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Imponibile" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataPag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataPag" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dataPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataPag" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="idxDoc" ColumnName="idxDoc" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxDoc" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxDoc" DataSetColumn="idxDoc" />
<Mapping SourceColumn="idxRichiesta" DataSetColumn="idxRichiesta" />
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
<Mapping SourceColumn="numDoc" DataSetColumn="numDoc" />
<Mapping SourceColumn="dataFatt" DataSetColumn="dataFatt" />
<Mapping SourceColumn="intervento" DataSetColumn="intervento" />
<Mapping SourceColumn="Imponibile" DataSetColumn="Imponibile" />
<Mapping SourceColumn="dataPag" DataSetColumn="dataPag" />
</Mappings>
<Sources>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_EF_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EF_deleteQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxDoc" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_EF_getByIdxRich" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxRich" GetMethodModifier="Public" GetMethodName="getByIdxRich" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxRich" UserSourceName="getByIdxRich">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EF_getByIdxRich</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="@idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_EF_getByIdxDoc" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EF_getByIdxDoc</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="@idxDoc" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_EF_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_EF_insertQuery</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxRichiesta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@numDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@dataFatt" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@intervento" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@imponibile" Precision="18" ProviderType="Decimal" Scale="3" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_EF_recPag" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="recPag" Modifier="Public" Name="recPag" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="recPag">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_EF_recPag</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="@idxDoc" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@dataPag" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatoRichByFornTableAdapter" GeneratorDataComponentClassName="StatoRichByFornTableAdapter" Name="StatoRichByForn" UserDataComponentName="StatoRichByFornTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_StatoRich_getByForn" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_StatoRich_getByForn</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@minStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maxStato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="cod_fornitore" DataSetColumn="cod_fornitore" />
<Mapping SourceColumn="nRichieste" DataSetColumn="nRichieste" />
<Mapping SourceColumn="nPreventivi" DataSetColumn="nPreventivi" />
<Mapping SourceColumn="nAperte" DataSetColumn="nAperte" />
<Mapping SourceColumn="nSospese" DataSetColumn="nSospese" />
<Mapping SourceColumn="nConcluse" DataSetColumn="nConcluse" />
<Mapping SourceColumn="nFatturate" DataSetColumn="nFatturate" />
<Mapping SourceColumn="nPagate" DataSetColumn="nPagate" />
<Mapping SourceColumn="nContestate" DataSetColumn="nContestate" />
<Mapping SourceColumn="nProgrammate" DataSetColumn="nProgrammate" />
<Mapping SourceColumn="nCongelate" DataSetColumn="nCongelate" />
<Mapping SourceColumn="nAnnullate" DataSetColumn="nAnnullate" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GruppiCondTableAdapter" GeneratorDataComponentClassName="GruppiCondTableAdapter" Name="GruppiCond" UserDataComponentName="GruppiCondTableAdapter">
<MainSource>
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_GC_getByAmm" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_GC_getByAmm</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="chiave" DataSetColumn="chiave" />
<Mapping SourceColumn="valore" DataSetColumn="valore" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DS_app" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_UserDSName="DS_app" msprop:Generator_DataSetName="DS_app">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="AnagAmministratori" msprop:Generator_RowEvHandlerName="AnagAmministratoriRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagAmministratoriRowDeleted" msprop:Generator_RowDeletingName="AnagAmministratoriRowDeleting" msprop:Generator_RowEvArgName="AnagAmministratoriRowChangeEvent" msprop:Generator_TablePropName="AnagAmministratori" msprop:Generator_RowChangedName="AnagAmministratoriRowChanged" msprop:Generator_RowChangingName="AnagAmministratoriRowChanging" msprop:Generator_TableClassName="AnagAmministratoriDataTable" msprop:Generator_RowClassName="AnagAmministratoriRow" msprop:Generator_TableVarName="tableAnagAmministratori" msprop:Generator_UserTableName="AnagAmministratori">
<xs:complexType>
<xs:sequence>
<xs:element name="idxAmm" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idxAmm" msprop:Generator_ColumnPropNameInTable="idxAmmColumn" msprop:Generator_ColumnVarNameInTable="columnidxAmm" msprop:Generator_UserColumnName="idxAmm" type="xs:int" />
<xs:element name="RagSociale" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_ColumnVarNameInTable="columnRagSociale" msprop:Generator_UserColumnName="RagSociale">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_UserColumnName="email">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NumCondAttivi" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="NumCondAttivi" msprop:Generator_ColumnPropNameInTable="NumCondAttiviColumn" msprop:Generator_ColumnVarNameInTable="columnNumCondAttivi" msprop:Generator_UserColumnName="NumCondAttivi" type="xs:int" minOccurs="0" />
<xs:element name="NumCond" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="NumCond" msprop:Generator_ColumnPropNameInTable="NumCondColumn" msprop:Generator_ColumnVarNameInTable="columnNumCond" msprop:Generator_UserColumnName="NumCond" type="xs:int" minOccurs="0" />
<xs:element name="NumRich" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="NumRich" msprop:Generator_ColumnPropNameInTable="NumRichColumn" msprop:Generator_ColumnVarNameInTable="columnNumRich" msprop:Generator_UserColumnName="NumRich" type="xs:int" minOccurs="0" />
<xs:element name="NumInt" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="NumInt" msprop:Generator_ColumnPropNameInTable="NumIntColumn" msprop:Generator_ColumnVarNameInTable="columnNumInt" msprop:Generator_UserColumnName="NumInt" type="xs:int" minOccurs="0" />
<xs:element name="ImponibileTot" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="ImponibileTot" msprop:Generator_ColumnPropNameInTable="ImponibileTotColumn" msprop:Generator_ColumnVarNameInTable="columnImponibileTot" msprop:Generator_UserColumnName="ImponibileTot" type="xs:decimal" minOccurs="0" />
<xs:element name="ImponibileMedio" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="ImponibileMedio" msprop:Generator_ColumnPropNameInTable="ImponibileMedioColumn" msprop:Generator_ColumnVarNameInTable="columnImponibileMedio" msprop:Generator_UserColumnName="ImponibileMedio" type="xs:decimal" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagCondomini" msprop:Generator_RowEvHandlerName="AnagCondominiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagCondominiRowDeleted" msprop:Generator_RowDeletingName="AnagCondominiRowDeleting" msprop:Generator_RowEvArgName="AnagCondominiRowChangeEvent" msprop:Generator_TablePropName="AnagCondomini" msprop:Generator_RowChangedName="AnagCondominiRowChanged" msprop:Generator_RowChangingName="AnagCondominiRowChanging" msprop:Generator_TableClassName="AnagCondominiDataTable" msprop:Generator_RowClassName="AnagCondominiRow" msprop:Generator_TableVarName="tableAnagCondomini" msprop:Generator_UserTableName="AnagCondomini">
<xs:complexType>
<xs:sequence>
<xs:element name="idxCond" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idxCond" msprop:Generator_ColumnPropNameInTable="idxCondColumn" msprop:Generator_ColumnVarNameInTable="columnidxCond" msprop:Generator_UserColumnName="idxCond" type="xs:int" />
<xs:element name="cod_cond" msprop:Generator_ColumnPropNameInRow="cod_cond" msprop:Generator_ColumnPropNameInTable="cod_condColumn" msprop:Generator_ColumnVarNameInTable="columncod_cond" msprop:Generator_UserColumnName="cod_cond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnPropNameInTable="nomeColumn" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_UserColumnName="nome">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="indirizzo" msprop:Generator_ColumnPropNameInRow="indirizzo" msprop:Generator_ColumnPropNameInTable="indirizzoColumn" msprop:Generator_ColumnVarNameInTable="columnindirizzo" msprop:Generator_UserColumnName="indirizzo">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cap" msprop:Generator_ColumnPropNameInRow="cap" msprop:Generator_ColumnPropNameInTable="capColumn" msprop:Generator_ColumnVarNameInTable="columncap" msprop:Generator_UserColumnName="cap">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="citta" msprop:Generator_ColumnPropNameInRow="citta" msprop:Generator_ColumnPropNameInTable="cittaColumn" msprop:Generator_ColumnVarNameInTable="columncitta" msprop:Generator_UserColumnName="citta">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cod_fisc" msprop:Generator_ColumnPropNameInRow="cod_fisc" msprop:Generator_ColumnPropNameInTable="cod_fiscColumn" msprop:Generator_ColumnVarNameInTable="columncod_fisc" msprop:Generator_UserColumnName="cod_fisc">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxAmm" msprop:Generator_ColumnPropNameInRow="idxAmm" msprop:Generator_ColumnPropNameInTable="idxAmmColumn" msprop:Generator_ColumnVarNameInTable="columnidxAmm" msprop:Generator_UserColumnName="idxAmm" type="xs:int" />
<xs:element name="Attivo" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_ColumnVarNameInTable="columnAttivo" msprop:Generator_UserColumnName="Attivo" type="xs:boolean" />
<xs:element name="note" msprop:Generator_ColumnPropNameInRow="note" msprop:Generator_ColumnPropNameInTable="noteColumn" msprop:Generator_ColumnVarNameInTable="columnnote" msprop:Generator_UserColumnName="note">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nomeFull" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nomeFull" msprop:Generator_ColumnPropNameInTable="nomeFullColumn" msprop:Generator_ColumnVarNameInTable="columnnomeFull" msprop:Generator_UserColumnName="nomeFull" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="83" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="numRich" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numRich" msprop:Generator_ColumnPropNameInTable="numRichColumn" msprop:Generator_ColumnVarNameInTable="columnnumRich" msprop:Generator_UserColumnName="numRich" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagAree" msprop:Generator_RowClassName="AnagAreeRow" msprop:Generator_RowEvHandlerName="AnagAreeRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagAreeRowDeleted" msprop:Generator_RowDeletingName="AnagAreeRowDeleting" msprop:Generator_RowEvArgName="AnagAreeRowChangeEvent" msprop:Generator_TablePropName="AnagAree" msprop:Generator_RowChangedName="AnagAreeRowChanged" msprop:Generator_RowChangingName="AnagAreeRowChanging" msprop:Generator_TableClassName="AnagAreeDataTable" msprop:Generator_UserTableName="AnagAree" msprop:Generator_TableVarName="tableAnagAree">
<xs:complexType>
<xs:sequence>
<xs:element name="idxArea" msprop:Generator_ColumnPropNameInRow="idxArea" msprop:Generator_ColumnPropNameInTable="idxAreaColumn" msprop:Generator_ColumnVarNameInTable="columnidxArea" msprop:Generator_UserColumnName="idxArea" type="xs:int" />
<xs:element name="Area" msprop:Generator_ColumnPropNameInRow="Area" msprop:Generator_ColumnPropNameInTable="AreaColumn" msprop:Generator_ColumnVarNameInTable="columnArea" msprop:Generator_UserColumnName="Area">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Note" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_UserColumnName="Note">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Qta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
<xs:element name="CssClass" msprop:Generator_ColumnPropNameInRow="CssClass" msprop:Generator_ColumnPropNameInTable="CssClassColumn" msprop:Generator_ColumnVarNameInTable="columnCssClass" msprop:Generator_UserColumnName="CssClass">
<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="AnagFornitori" msprop:Generator_RowClassName="AnagFornitoriRow" msprop:Generator_RowEvHandlerName="AnagFornitoriRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagFornitoriRowDeleted" msprop:Generator_RowDeletingName="AnagFornitoriRowDeleting" msprop:Generator_RowEvArgName="AnagFornitoriRowChangeEvent" msprop:Generator_TablePropName="AnagFornitori" msprop:Generator_RowChangedName="AnagFornitoriRowChanged" msprop:Generator_RowChangingName="AnagFornitoriRowChanging" msprop:Generator_TableClassName="AnagFornitoriDataTable" msprop:Generator_UserTableName="AnagFornitori" msprop:Generator_TableVarName="tableAnagFornitori">
<xs:complexType>
<xs:sequence>
<xs:element name="idxFornitore" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
<xs:element name="nome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnPropNameInTable="nomeColumn" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_UserColumnName="nome" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="indirizzo" msprop:Generator_ColumnPropNameInRow="indirizzo" msprop:Generator_ColumnPropNameInTable="indirizzoColumn" msprop:Generator_ColumnVarNameInTable="columnindirizzo" msprop:Generator_UserColumnName="indirizzo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="200" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CAP" msprop:Generator_ColumnPropNameInRow="CAP" msprop:Generator_ColumnPropNameInTable="CAPColumn" msprop:Generator_ColumnVarNameInTable="columnCAP" msprop:Generator_UserColumnName="CAP" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="citta" msprop:Generator_ColumnPropNameInRow="citta" msprop:Generator_ColumnPropNameInTable="cittaColumn" msprop:Generator_ColumnVarNameInTable="columncitta" msprop:Generator_UserColumnName="citta" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="provincia" msprop:Generator_ColumnPropNameInRow="provincia" msprop:Generator_ColumnPropNameInTable="provinciaColumn" msprop:Generator_ColumnVarNameInTable="columnprovincia" msprop:Generator_UserColumnName="provincia" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="stato" msprop:Generator_ColumnPropNameInRow="stato" msprop:Generator_ColumnPropNameInTable="statoColumn" msprop:Generator_ColumnVarNameInTable="columnstato" msprop:Generator_UserColumnName="stato" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="pIva" msprop:Generator_ColumnPropNameInRow="pIva" msprop:Generator_ColumnPropNameInTable="pIvaColumn" msprop:Generator_ColumnVarNameInTable="columnpIva" msprop:Generator_UserColumnName="pIva" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cFisc" msprop:Generator_ColumnPropNameInRow="cFisc" msprop:Generator_ColumnPropNameInTable="cFiscColumn" msprop:Generator_ColumnVarNameInTable="columncFisc" msprop:Generator_UserColumnName="cFisc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_UserColumnName="email" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="telefono" msprop:Generator_ColumnPropNameInRow="telefono" msprop:Generator_ColumnPropNameInTable="telefonoColumn" msprop:Generator_ColumnVarNameInTable="columntelefono" msprop:Generator_UserColumnName="telefono" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cellulare" msprop:Generator_ColumnPropNameInRow="cellulare" msprop:Generator_ColumnPropNameInTable="cellulareColumn" msprop:Generator_ColumnVarNameInTable="columncellulare" msprop:Generator_UserColumnName="cellulare" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="iscritta" msprop:Generator_ColumnPropNameInRow="iscritta" msprop:Generator_ColumnPropNameInTable="iscrittaColumn" msprop:Generator_ColumnVarNameInTable="columniscritta" msprop:Generator_UserColumnName="iscritta" type="xs:boolean" />
<xs:element name="attivo" msprop:Generator_ColumnPropNameInRow="attivo" msprop:Generator_ColumnPropNameInTable="attivoColumn" msprop:Generator_ColumnVarNameInTable="columnattivo" msprop:Generator_UserColumnName="attivo" type="xs:boolean" />
<xs:element name="cssStatoForn" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="cssStatoForn" msprop:Generator_ColumnPropNameInTable="cssStatoFornColumn" msprop:Generator_ColumnVarNameInTable="columncssStatoForn" msprop:Generator_UserColumnName="cssStatoForn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="12" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="quotaStd" msprop:Generator_ColumnPropNameInRow="quotaStd" msprop:Generator_ColumnPropNameInTable="quotaStdColumn" msprop:Generator_ColumnVarNameInTable="columnquotaStd" msprop:Generator_UserColumnName="quotaStd" type="xs:decimal" />
<xs:element name="noteQuota" msprop:Generator_ColumnPropNameInRow="noteQuota" msprop:Generator_ColumnPropNameInTable="noteQuotaColumn" msprop:Generator_ColumnVarNameInTable="columnnoteQuota" msprop:Generator_UserColumnName="noteQuota">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="numRich" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numRich" msprop:Generator_ColumnPropNameInTable="numRichColumn" msprop:Generator_ColumnVarNameInTable="columnnumRich" msprop:Generator_UserColumnName="numRich" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AssF2A" msprop:Generator_RowClassName="AssF2ARow" msprop:Generator_RowEvHandlerName="AssF2ARowChangeEventHandler" msprop:Generator_RowDeletedName="AssF2ARowDeleted" msprop:Generator_RowDeletingName="AssF2ARowDeleting" msprop:Generator_RowEvArgName="AssF2ARowChangeEvent" msprop:Generator_TablePropName="AssF2A" msprop:Generator_RowChangedName="AssF2ARowChanged" msprop:Generator_RowChangingName="AssF2ARowChanging" msprop:Generator_TableClassName="AssF2ADataTable" msprop:Generator_UserTableName="AssF2A" msprop:Generator_TableVarName="tableAssF2A">
<xs:complexType>
<xs:sequence>
<xs:element name="idxFornitore" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
<xs:element name="idxArea" msprop:Generator_ColumnPropNameInRow="idxArea" msprop:Generator_ColumnPropNameInTable="idxAreaColumn" msprop:Generator_ColumnVarNameInTable="columnidxArea" msprop:Generator_UserColumnName="idxArea" type="xs:int" />
<xs:element name="Attivazione" msprop:Generator_ColumnPropNameInRow="Attivazione" msprop:Generator_ColumnPropNameInTable="AttivazioneColumn" msprop:Generator_ColumnVarNameInTable="columnAttivazione" msprop:Generator_UserColumnName="Attivazione" type="xs:dateTime" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AssF2C" msprop:Generator_RowEvHandlerName="AssF2CRowChangeEventHandler" msprop:Generator_RowDeletedName="AssF2CRowDeleted" msprop:Generator_RowDeletingName="AssF2CRowDeleting" msprop:Generator_RowEvArgName="AssF2CRowChangeEvent" msprop:Generator_TablePropName="AssF2C" msprop:Generator_RowChangedName="AssF2CRowChanged" msprop:Generator_RowChangingName="AssF2CRowChanging" msprop:Generator_TableClassName="AssF2CDataTable" msprop:Generator_RowClassName="AssF2CRow" msprop:Generator_TableVarName="tableAssF2C" msprop:Generator_UserTableName="AssF2C">
<xs:complexType>
<xs:sequence>
<xs:element name="idxCond" msprop:Generator_ColumnPropNameInRow="idxCond" msprop:Generator_ColumnPropNameInTable="idxCondColumn" msprop:Generator_ColumnVarNameInTable="columnidxCond" msprop:Generator_UserColumnName="idxCond" type="xs:int" />
<xs:element name="idxFornitore" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
<xs:element name="idxArea" msprop:Generator_ColumnPropNameInRow="idxArea" msprop:Generator_ColumnPropNameInTable="idxAreaColumn" msprop:Generator_ColumnVarNameInTable="columnidxArea" msprop:Generator_UserColumnName="idxArea" type="xs:int" />
<xs:element name="Attivazione" msprop:Generator_ColumnPropNameInRow="Attivazione" msprop:Generator_ColumnPropNameInTable="AttivazioneColumn" msprop:Generator_ColumnVarNameInTable="columnAttivazione" msprop:Generator_UserColumnName="Attivazione" type="xs:dateTime" />
<xs:element name="Priorita" msprop:Generator_ColumnPropNameInRow="Priorita" msprop:Generator_ColumnPropNameInTable="PrioritaColumn" msprop:Generator_ColumnVarNameInTable="columnPriorita" msprop:Generator_UserColumnName="Priorita" type="xs:int" />
<xs:element name="cod_cond" msprop:Generator_ColumnPropNameInRow="cod_cond" msprop:Generator_ColumnPropNameInTable="cod_condColumn" msprop:Generator_ColumnVarNameInTable="columncod_cond" msprop:Generator_UserColumnName="cod_cond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxAmm" msprop:Generator_ColumnPropNameInRow="idxAmm" msprop:Generator_ColumnPropNameInTable="idxAmmColumn" msprop:Generator_ColumnVarNameInTable="columnidxAmm" msprop:Generator_UserColumnName="idxAmm" type="xs:int" />
<xs:element name="nomeCond" msprop:Generator_ColumnPropNameInRow="nomeCond" msprop:Generator_ColumnPropNameInTable="nomeCondColumn" msprop:Generator_ColumnVarNameInTable="columnnomeCond" msprop:Generator_UserColumnName="nomeCond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="indirCond" msprop:Generator_ColumnPropNameInRow="indirCond" msprop:Generator_ColumnPropNameInTable="indirCondColumn" msprop:Generator_ColumnVarNameInTable="columnindirCond" msprop:Generator_UserColumnName="indirCond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="capCond" msprop:Generator_ColumnPropNameInRow="capCond" msprop:Generator_ColumnPropNameInTable="capCondColumn" msprop:Generator_ColumnVarNameInTable="columncapCond" msprop:Generator_UserColumnName="capCond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cittaCond" msprop:Generator_ColumnPropNameInRow="cittaCond" msprop:Generator_ColumnPropNameInTable="cittaCondColumn" msprop:Generator_ColumnVarNameInTable="columncittaCond" msprop:Generator_UserColumnName="cittaCond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Area" msprop:Generator_ColumnPropNameInRow="Area" msprop:Generator_ColumnPropNameInTable="AreaColumn" msprop:Generator_ColumnVarNameInTable="columnArea" msprop:Generator_UserColumnName="Area">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CssClass" msprop:Generator_ColumnPropNameInRow="CssClass" msprop:Generator_ColumnPropNameInTable="CssClassColumn" msprop:Generator_ColumnVarNameInTable="columnCssClass" msprop:Generator_UserColumnName="CssClass">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nomeForn" msdata:Caption="nomrForn" msprop:Generator_ColumnPropNameInRow="nomeForn" msprop:Generator_ColumnPropNameInTable="nomeFornColumn" msprop:Generator_ColumnVarNameInTable="columnnomeForn" msprop:Generator_UserColumnName="nomeForn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="indirizzo" msprop:Generator_ColumnPropNameInRow="indirizzo" msprop:Generator_ColumnPropNameInTable="indirizzoColumn" msprop:Generator_ColumnVarNameInTable="columnindirizzo" msprop:Generator_UserColumnName="indirizzo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="200" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="p_iva" msprop:Generator_ColumnPropNameInRow="p_iva" msprop:Generator_ColumnPropNameInTable="p_ivaColumn" msprop:Generator_ColumnVarNameInTable="columnp_iva" msprop:Generator_UserColumnName="p_iva" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PBO_DashStats" msprop:Generator_RowEvHandlerName="PBO_DashStatsRowChangeEventHandler" msprop:Generator_RowDeletedName="PBO_DashStatsRowDeleted" msprop:Generator_RowDeletingName="PBO_DashStatsRowDeleting" msprop:Generator_RowEvArgName="PBO_DashStatsRowChangeEvent" msprop:Generator_TablePropName="PBO_DashStats" msprop:Generator_RowChangedName="PBO_DashStatsRowChanged" msprop:Generator_RowChangingName="PBO_DashStatsRowChanging" msprop:Generator_TableClassName="PBO_DashStatsDataTable" msprop:Generator_RowClassName="PBO_DashStatsRow" msprop:Generator_TableVarName="tablePBO_DashStats" msprop:Generator_UserTableName="PBO_DashStats">
<xs:complexType>
<xs:sequence>
<xs:element name="numUsers" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numUsers" msprop:Generator_ColumnPropNameInTable="numUsersColumn" msprop:Generator_ColumnVarNameInTable="columnnumUsers" msprop:Generator_UserColumnName="numUsers" type="xs:int" minOccurs="0" />
<xs:element name="reqUsers" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="reqUsers" msprop:Generator_ColumnPropNameInTable="reqUsersColumn" msprop:Generator_ColumnVarNameInTable="columnreqUsers" msprop:Generator_UserColumnName="reqUsers" type="xs:int" minOccurs="0" />
<xs:element name="numForn" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numForn" msprop:Generator_ColumnPropNameInTable="numFornColumn" msprop:Generator_ColumnVarNameInTable="columnnumForn" msprop:Generator_UserColumnName="numForn" type="xs:int" minOccurs="0" />
<xs:element name="reqForn" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="reqForn" msprop:Generator_ColumnPropNameInTable="reqFornColumn" msprop:Generator_ColumnVarNameInTable="columnreqForn" msprop:Generator_UserColumnName="reqForn" type="xs:int" minOccurs="0" />
<xs:element name="numReq" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numReq" msprop:Generator_ColumnPropNameInTable="numReqColumn" msprop:Generator_ColumnVarNameInTable="columnnumReq" msprop:Generator_UserColumnName="numReq" type="xs:int" minOccurs="0" />
<xs:element name="reqReq" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="reqReq" msprop:Generator_ColumnPropNameInTable="reqReqColumn" msprop:Generator_ColumnVarNameInTable="columnreqReq" msprop:Generator_UserColumnName="reqReq" type="xs:int" minOccurs="0" />
<xs:element name="numInt" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numInt" msprop:Generator_ColumnPropNameInTable="numIntColumn" msprop:Generator_ColumnVarNameInTable="columnnumInt" msprop:Generator_UserColumnName="numInt" type="xs:int" minOccurs="0" />
<xs:element name="reqInt" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="reqInt" msprop:Generator_ColumnPropNameInTable="reqIntColumn" msprop:Generator_ColumnVarNameInTable="columnreqInt" msprop:Generator_UserColumnName="reqInt" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ElencolRich" msprop:Generator_RowClassName="ElencolRichRow" msprop:Generator_RowEvHandlerName="ElencolRichRowChangeEventHandler" msprop:Generator_RowDeletedName="ElencolRichRowDeleted" msprop:Generator_RowDeletingName="ElencolRichRowDeleting" msprop:Generator_RowEvArgName="ElencolRichRowChangeEvent" msprop:Generator_TablePropName="ElencolRich" msprop:Generator_RowChangedName="ElencolRichRowChanged" msprop:Generator_RowChangingName="ElencolRichRowChanging" msprop:Generator_TableClassName="ElencolRichDataTable" msprop:Generator_UserTableName="ElencolRich" msprop:Generator_TableVarName="tableElencolRich">
<xs:complexType>
<xs:sequence>
<xs:element name="idxRichiesta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idxRichiesta" msprop:Generator_ColumnPropNameInTable="idxRichiestaColumn" msprop:Generator_ColumnVarNameInTable="columnidxRichiesta" msprop:Generator_UserColumnName="idxRichiesta" type="xs:int" />
<xs:element name="idxStato" msprop:Generator_ColumnPropNameInRow="idxStato" msprop:Generator_ColumnPropNameInTable="idxStatoColumn" msprop:Generator_ColumnVarNameInTable="columnidxStato" msprop:Generator_UserColumnName="idxStato" type="xs:int" />
<xs:element name="idxCond" msprop:Generator_ColumnPropNameInRow="idxCond" msprop:Generator_ColumnPropNameInTable="idxCondColumn" msprop:Generator_ColumnVarNameInTable="columnidxCond" msprop:Generator_UserColumnName="idxCond" type="xs:int" />
<xs:element name="idxPriorita" msprop:Generator_ColumnPropNameInRow="idxPriorita" msprop:Generator_ColumnPropNameInTable="idxPrioritaColumn" msprop:Generator_ColumnVarNameInTable="columnidxPriorita" msprop:Generator_UserColumnName="idxPriorita" type="xs:int" />
<xs:element name="idxArea" msprop:Generator_ColumnPropNameInRow="idxArea" msprop:Generator_ColumnPropNameInTable="idxAreaColumn" msprop:Generator_ColumnVarNameInTable="columnidxArea" msprop:Generator_UserColumnName="idxArea" type="xs:int" />
<xs:element name="idxFornitore" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
<xs:element name="cod_cond" msprop:Generator_ColumnPropNameInRow="cod_cond" msprop:Generator_ColumnPropNameInTable="cod_condColumn" msprop:Generator_ColumnVarNameInTable="columncod_cond" msprop:Generator_UserColumnName="cod_cond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nom_cond" msprop:Generator_ColumnPropNameInRow="nom_cond" msprop:Generator_ColumnPropNameInTable="nom_condColumn" msprop:Generator_ColumnVarNameInTable="columnnom_cond" msprop:Generator_UserColumnName="nom_cond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="indir_cond" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="indir_cond" msprop:Generator_ColumnPropNameInTable="indir_condColumn" msprop:Generator_ColumnVarNameInTable="columnindir_cond" msprop:Generator_UserColumnName="indir_cond" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="158" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dataIns" msprop:Generator_ColumnPropNameInRow="dataIns" msprop:Generator_ColumnPropNameInTable="dataInsColumn" msprop:Generator_ColumnVarNameInTable="columndataIns" msprop:Generator_UserColumnName="dataIns" type="xs:dateTime" />
<xs:element name="dataRich" msprop:Generator_ColumnPropNameInRow="dataRich" msprop:Generator_ColumnPropNameInTable="dataRichColumn" msprop:Generator_ColumnVarNameInTable="columndataRich" msprop:Generator_UserColumnName="dataRich" type="xs:dateTime" />
<xs:element name="dataScad" msprop:Generator_ColumnPropNameInRow="dataScad" msprop:Generator_ColumnPropNameInTable="dataScadColumn" msprop:Generator_ColumnVarNameInTable="columndataScad" msprop:Generator_UserColumnName="dataScad" type="xs:dateTime" />
<xs:element name="codCollabRich" msprop:Generator_ColumnPropNameInRow="codCollabRich" msprop:Generator_ColumnPropNameInTable="codCollabRichColumn" msprop:Generator_ColumnVarNameInTable="columncodCollabRich" msprop:Generator_UserColumnName="codCollabRich">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="genContatto" msprop:Generator_ColumnPropNameInRow="genContatto" msprop:Generator_ColumnPropNameInTable="genContattoColumn" msprop:Generator_ColumnVarNameInTable="columngenContatto" msprop:Generator_UserColumnName="genContatto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="telContatto" msprop:Generator_ColumnPropNameInRow="telContatto" msprop:Generator_ColumnPropNameInTable="telContattoColumn" msprop:Generator_ColumnVarNameInTable="columntelContatto" msprop:Generator_UserColumnName="telContatto">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="messaggio" msprop:Generator_ColumnPropNameInRow="messaggio" msprop:Generator_ColumnPropNameInTable="messaggioColumn" msprop:Generator_ColumnVarNameInTable="columnmessaggio" msprop:Generator_UserColumnName="messaggio">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="note" msprop:Generator_ColumnPropNameInRow="note" msprop:Generator_ColumnPropNameInTable="noteColumn" msprop:Generator_ColumnVarNameInTable="columnnote" msprop:Generator_UserColumnName="note">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="iscritta" msprop:Generator_ColumnPropNameInRow="iscritta" msprop:Generator_ColumnPropNameInTable="iscrittaColumn" msprop:Generator_ColumnVarNameInTable="columniscritta" msprop:Generator_UserColumnName="iscritta" type="xs:int" />
<xs:element name="stato" msprop:Generator_ColumnPropNameInRow="stato" msprop:Generator_ColumnPropNameInTable="statoColumn" msprop:Generator_ColumnVarNameInTable="columnstato" msprop:Generator_UserColumnName="stato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssStato" msprop:Generator_ColumnPropNameInRow="cssStato" msprop:Generator_ColumnPropNameInTable="cssStatoColumn" msprop:Generator_ColumnVarNameInTable="columncssStato" msprop:Generator_UserColumnName="cssStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="qtaAzioni" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="qtaAzioni" msprop:Generator_ColumnPropNameInTable="qtaAzioniColumn" msprop:Generator_ColumnVarNameInTable="columnqtaAzioni" msprop:Generator_UserColumnName="qtaAzioni" type="xs:int" minOccurs="0" />
<xs:element name="collaboratore" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="collaboratore" msprop:Generator_ColumnPropNameInTable="collaboratoreColumn" msprop:Generator_ColumnVarNameInTable="columncollaboratore" msprop:Generator_UserColumnName="collaboratore" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="501" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssStatoForn" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="cssStatoForn" msprop:Generator_ColumnPropNameInTable="cssStatoFornColumn" msprop:Generator_ColumnVarNameInTable="columncssStatoForn" msprop:Generator_UserColumnName="cssStatoForn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="12" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cod_fornitore" msprop:Generator_ColumnPropNameInRow="cod_fornitore" msprop:Generator_ColumnPropNameInTable="cod_fornitoreColumn" msprop:Generator_ColumnVarNameInTable="columncod_fornitore" msprop:Generator_UserColumnName="cod_fornitore" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="freezed" msprop:Generator_ColumnPropNameInRow="freezed" msprop:Generator_ColumnPropNameInTable="freezedColumn" msprop:Generator_ColumnVarNameInTable="columnfreezed" msprop:Generator_UserColumnName="freezed" type="xs:boolean" />
<xs:element name="dateUnfreeze" msprop:Generator_ColumnPropNameInRow="dateUnfreeze" msprop:Generator_ColumnPropNameInTable="dateUnfreezeColumn" msprop:Generator_ColumnVarNameInTable="columndateUnfreeze" msprop:Generator_UserColumnName="dateUnfreeze" type="xs:dateTime" minOccurs="0" />
<xs:element name="scaduto" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="scaduto" msprop:Generator_ColumnPropNameInTable="scadutoColumn" msprop:Generator_ColumnVarNameInTable="columnscaduto" msprop:Generator_UserColumnName="scaduto" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagStati" msprop:Generator_RowClassName="AnagStatiRow" msprop:Generator_RowEvHandlerName="AnagStatiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagStatiRowDeleted" msprop:Generator_RowDeletingName="AnagStatiRowDeleting" msprop:Generator_RowEvArgName="AnagStatiRowChangeEvent" msprop:Generator_TablePropName="AnagStati" msprop:Generator_RowChangedName="AnagStatiRowChanged" msprop:Generator_RowChangingName="AnagStatiRowChanging" msprop:Generator_TableClassName="AnagStatiDataTable" msprop:Generator_UserTableName="AnagStati" msprop:Generator_TableVarName="tableAnagStati">
<xs:complexType>
<xs:sequence>
<xs:element name="idxStato" msprop:Generator_ColumnPropNameInRow="idxStato" msprop:Generator_ColumnPropNameInTable="idxStatoColumn" msprop:Generator_ColumnVarNameInTable="columnidxStato" msprop:Generator_UserColumnName="idxStato" type="xs:int" />
<xs:element name="stato" msprop:Generator_ColumnPropNameInRow="stato" msprop:Generator_ColumnPropNameInTable="statoColumn" msprop:Generator_ColumnVarNameInTable="columnstato" msprop:Generator_UserColumnName="stato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="descrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_UserColumnName="descrizione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssStato" msprop:Generator_ColumnPropNameInRow="cssStato" msprop:Generator_ColumnPropNameInTable="cssStatoColumn" msprop:Generator_ColumnVarNameInTable="columncssStato" msprop:Generator_UserColumnName="cssStato">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="StatoRichByCond" msprop:Generator_RowClassName="StatoRichByCondRow" msprop:Generator_RowEvHandlerName="StatoRichByCondRowChangeEventHandler" msprop:Generator_RowDeletedName="StatoRichByCondRowDeleted" msprop:Generator_RowDeletingName="StatoRichByCondRowDeleting" msprop:Generator_RowEvArgName="StatoRichByCondRowChangeEvent" msprop:Generator_TablePropName="StatoRichByCond" msprop:Generator_RowChangedName="StatoRichByCondRowChanged" msprop:Generator_RowChangingName="StatoRichByCondRowChanging" msprop:Generator_TableClassName="StatoRichByCondDataTable" msprop:Generator_UserTableName="StatoRichByCond" msprop:Generator_TableVarName="tableStatoRichByCond">
<xs:complexType>
<xs:sequence>
<xs:element name="cod_cond" msprop:Generator_ColumnPropNameInRow="cod_cond" msprop:Generator_ColumnPropNameInTable="cod_condColumn" msprop:Generator_ColumnVarNameInTable="columncod_cond" msprop:Generator_UserColumnName="cod_cond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nom_cond" msprop:Generator_ColumnPropNameInRow="nom_cond" msprop:Generator_ColumnPropNameInTable="nom_condColumn" msprop:Generator_ColumnVarNameInTable="columnnom_cond" msprop:Generator_UserColumnName="nom_cond">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nRichieste" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nRichieste" msprop:Generator_ColumnPropNameInTable="nRichiesteColumn" msprop:Generator_ColumnVarNameInTable="columnnRichieste" msprop:Generator_UserColumnName="nRichieste" type="xs:int" minOccurs="0" />
<xs:element name="nPreventivi" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPreventivi" msprop:Generator_ColumnPropNameInTable="nPreventiviColumn" msprop:Generator_ColumnVarNameInTable="columnnPreventivi" msprop:Generator_UserColumnName="nPreventivi" type="xs:int" minOccurs="0" />
<xs:element name="nAperte" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nAperte" msprop:Generator_ColumnPropNameInTable="nAperteColumn" msprop:Generator_ColumnVarNameInTable="columnnAperte" msprop:Generator_UserColumnName="nAperte" type="xs:int" minOccurs="0" />
<xs:element name="nSospese" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nSospese" msprop:Generator_ColumnPropNameInTable="nSospeseColumn" msprop:Generator_ColumnVarNameInTable="columnnSospese" msprop:Generator_UserColumnName="nSospese" type="xs:int" minOccurs="0" />
<xs:element name="nConcluse" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nConcluse" msprop:Generator_ColumnPropNameInTable="nConcluseColumn" msprop:Generator_ColumnVarNameInTable="columnnConcluse" msprop:Generator_UserColumnName="nConcluse" type="xs:int" minOccurs="0" />
<xs:element name="nFatturate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nFatturate" msprop:Generator_ColumnPropNameInTable="nFatturateColumn" msprop:Generator_ColumnVarNameInTable="columnnFatturate" msprop:Generator_UserColumnName="nFatturate" type="xs:int" minOccurs="0" />
<xs:element name="nPagate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPagate" msprop:Generator_ColumnPropNameInTable="nPagateColumn" msprop:Generator_ColumnVarNameInTable="columnnPagate" msprop:Generator_UserColumnName="nPagate" type="xs:int" minOccurs="0" />
<xs:element name="nContestate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nContestate" msprop:Generator_ColumnPropNameInTable="nContestateColumn" msprop:Generator_ColumnVarNameInTable="columnnContestate" msprop:Generator_UserColumnName="nContestate" type="xs:int" minOccurs="0" />
<xs:element name="nProgrammate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nProgrammate" msprop:Generator_ColumnPropNameInTable="nProgrammateColumn" msprop:Generator_ColumnVarNameInTable="columnnProgrammate" msprop:Generator_UserColumnName="nProgrammate" type="xs:int" minOccurs="0" />
<xs:element name="nCongelate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nCongelate" msprop:Generator_ColumnPropNameInTable="nCongelateColumn" msprop:Generator_ColumnVarNameInTable="columnnCongelate" msprop:Generator_UserColumnName="nCongelate" type="xs:int" minOccurs="0" />
<xs:element name="nAnnullate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nAnnullate" msprop:Generator_ColumnPropNameInTable="nAnnullateColumn" msprop:Generator_ColumnVarNameInTable="columnnAnnullate" msprop:Generator_UserColumnName="nAnnullate" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PAM_DashStats" msprop:Generator_RowClassName="PAM_DashStatsRow" msprop:Generator_RowEvHandlerName="PAM_DashStatsRowChangeEventHandler" msprop:Generator_RowDeletedName="PAM_DashStatsRowDeleted" msprop:Generator_RowDeletingName="PAM_DashStatsRowDeleting" msprop:Generator_RowEvArgName="PAM_DashStatsRowChangeEvent" msprop:Generator_TablePropName="PAM_DashStats" msprop:Generator_RowChangedName="PAM_DashStatsRowChanged" msprop:Generator_RowChangingName="PAM_DashStatsRowChanging" msprop:Generator_TableClassName="PAM_DashStatsDataTable" msprop:Generator_UserTableName="PAM_DashStats" msprop:Generator_TableVarName="tablePAM_DashStats">
<xs:complexType>
<xs:sequence>
<xs:element name="numUsers" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="numUsers" msprop:Generator_ColumnPropNameInTable="numUsersColumn" msprop:Generator_ColumnVarNameInTable="columnnumUsers" msprop:Generator_UserColumnName="numUsers" type="xs:int" minOccurs="0" />
<xs:element name="reqUsers" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="reqUsers" msprop:Generator_ColumnPropNameInTable="reqUsersColumn" msprop:Generator_ColumnVarNameInTable="columnreqUsers" msprop:Generator_UserColumnName="reqUsers" type="xs:int" minOccurs="0" />
<xs:element name="nRichieste" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nRichieste" msprop:Generator_ColumnPropNameInTable="nRichiesteColumn" msprop:Generator_ColumnVarNameInTable="columnnRichieste" msprop:Generator_UserColumnName="nRichieste" type="xs:int" minOccurs="0" />
<xs:element name="nPrevReq" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPrevReq" msprop:Generator_ColumnPropNameInTable="nPrevReqColumn" msprop:Generator_ColumnVarNameInTable="columnnPrevReq" msprop:Generator_UserColumnName="nPrevReq" type="xs:int" minOccurs="0" />
<xs:element name="nPrevAppr" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPrevAppr" msprop:Generator_ColumnPropNameInTable="nPrevApprColumn" msprop:Generator_ColumnVarNameInTable="columnnPrevAppr" msprop:Generator_UserColumnName="nPrevAppr" type="xs:int" minOccurs="0" />
<xs:element name="nAperte" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nAperte" msprop:Generator_ColumnPropNameInTable="nAperteColumn" msprop:Generator_ColumnVarNameInTable="columnnAperte" msprop:Generator_UserColumnName="nAperte" type="xs:int" minOccurs="0" />
<xs:element name="nSospese" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nSospese" msprop:Generator_ColumnPropNameInTable="nSospeseColumn" msprop:Generator_ColumnVarNameInTable="columnnSospese" msprop:Generator_UserColumnName="nSospese" type="xs:int" minOccurs="0" />
<xs:element name="nConcluse" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nConcluse" msprop:Generator_ColumnPropNameInTable="nConcluseColumn" msprop:Generator_ColumnVarNameInTable="columnnConcluse" msprop:Generator_UserColumnName="nConcluse" type="xs:int" minOccurs="0" />
<xs:element name="nFatturate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nFatturate" msprop:Generator_ColumnPropNameInTable="nFatturateColumn" msprop:Generator_ColumnVarNameInTable="columnnFatturate" msprop:Generator_UserColumnName="nFatturate" type="xs:int" minOccurs="0" />
<xs:element name="nPagate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPagate" msprop:Generator_ColumnPropNameInTable="nPagateColumn" msprop:Generator_ColumnVarNameInTable="columnnPagate" msprop:Generator_UserColumnName="nPagate" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagPrior" msprop:Generator_RowClassName="AnagPriorRow" msprop:Generator_RowEvHandlerName="AnagPriorRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagPriorRowDeleted" msprop:Generator_RowDeletingName="AnagPriorRowDeleting" msprop:Generator_RowEvArgName="AnagPriorRowChangeEvent" msprop:Generator_TablePropName="AnagPrior" msprop:Generator_RowChangedName="AnagPriorRowChanged" msprop:Generator_RowChangingName="AnagPriorRowChanging" msprop:Generator_TableClassName="AnagPriorDataTable" msprop:Generator_UserTableName="AnagPrior" msprop:Generator_TableVarName="tableAnagPrior">
<xs:complexType>
<xs:sequence>
<xs:element name="idxPriorita" msprop:Generator_ColumnPropNameInRow="idxPriorita" msprop:Generator_ColumnPropNameInTable="idxPrioritaColumn" msprop:Generator_ColumnVarNameInTable="columnidxPriorita" msprop:Generator_UserColumnName="idxPriorita" type="xs:int" />
<xs:element name="descrPriorita" msprop:Generator_ColumnPropNameInRow="descrPriorita" msprop:Generator_ColumnPropNameInTable="descrPrioritaColumn" msprop:Generator_ColumnVarNameInTable="columndescrPriorita" msprop:Generator_UserColumnName="descrPriorita">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="scadenzaGg" msprop:Generator_ColumnPropNameInRow="scadenzaGg" msprop:Generator_ColumnPropNameInTable="scadenzaGgColumn" msprop:Generator_ColumnVarNameInTable="columnscadenzaGg" msprop:Generator_UserColumnName="scadenzaGg" type="xs:double" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ER_Acts" msprop:Generator_RowEvHandlerName="ER_ActsRowChangeEventHandler" msprop:Generator_RowDeletedName="ER_ActsRowDeleted" msprop:Generator_RowDeletingName="ER_ActsRowDeleting" msprop:Generator_RowEvArgName="ER_ActsRowChangeEvent" msprop:Generator_TablePropName="ER_Acts" msprop:Generator_RowChangedName="ER_ActsRowChanged" msprop:Generator_RowChangingName="ER_ActsRowChanging" msprop:Generator_TableClassName="ER_ActsDataTable" msprop:Generator_RowClassName="ER_ActsRow" msprop:Generator_TableVarName="tableER_Acts" msprop:Generator_UserTableName="ER_Acts">
<xs:complexType>
<xs:sequence>
<xs:element name="idxAzione" msprop:Generator_ColumnPropNameInRow="idxAzione" msprop:Generator_ColumnPropNameInTable="idxAzioneColumn" msprop:Generator_ColumnVarNameInTable="columnidxAzione" msprop:Generator_UserColumnName="idxAzione" type="xs:int" />
<xs:element name="idxRichiesta" msprop:Generator_ColumnPropNameInRow="idxRichiesta" msprop:Generator_ColumnPropNameInTable="idxRichiestaColumn" msprop:Generator_ColumnVarNameInTable="columnidxRichiesta" msprop:Generator_UserColumnName="idxRichiesta" type="xs:int" />
<xs:element name="dataRif" msprop:Generator_ColumnPropNameInRow="dataRif" msprop:Generator_ColumnPropNameInTable="dataRifColumn" msprop:Generator_ColumnVarNameInTable="columndataRif" msprop:Generator_UserColumnName="dataRif" type="xs:dateTime" />
<xs:element name="codAzione" msprop:Generator_ColumnPropNameInRow="codAzione" msprop:Generator_ColumnPropNameInTable="codAzioneColumn" msprop:Generator_ColumnVarNameInTable="columncodAzione" msprop:Generator_UserColumnName="codAzione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="descrAzione" msprop:Generator_ColumnPropNameInRow="descrAzione" msprop:Generator_ColumnPropNameInTable="descrAzioneColumn" msprop:Generator_ColumnVarNameInTable="columndescrAzione" msprop:Generator_UserColumnName="descrAzione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssIcon" msprop:Generator_ColumnPropNameInRow="cssIcon" msprop:Generator_ColumnPropNameInTable="cssIconColumn" msprop:Generator_ColumnVarNameInTable="columncssIcon" msprop:Generator_UserColumnName="cssIcon">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="classe" msprop:Generator_ColumnPropNameInRow="classe" msprop:Generator_ColumnPropNameInTable="classeColumn" msprop:Generator_ColumnVarNameInTable="columnclasse" msprop:Generator_UserColumnName="classe">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="attore" msprop:Generator_ColumnPropNameInRow="attore" msprop:Generator_ColumnPropNameInTable="attoreColumn" msprop:Generator_ColumnVarNameInTable="columnattore" msprop:Generator_UserColumnName="attore">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="genAttore" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="genAttore" msprop:Generator_ColumnPropNameInTable="genAttoreColumn" msprop:Generator_ColumnVarNameInTable="columngenAttore" msprop:Generator_UserColumnName="genAttore" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="501" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="messaggio" msprop:Generator_ColumnPropNameInRow="messaggio" msprop:Generator_ColumnPropNameInTable="messaggioColumn" msprop:Generator_ColumnVarNameInTable="columnmessaggio" msprop:Generator_UserColumnName="messaggio">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssButton" msprop:Generator_ColumnPropNameInRow="cssButton" msprop:Generator_ColumnPropNameInTable="cssButtonColumn" msprop:Generator_ColumnVarNameInTable="columncssButton" msprop:Generator_UserColumnName="cssButton">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssText" msprop:Generator_ColumnPropNameInRow="cssText" msprop:Generator_ColumnPropNameInTable="cssTextColumn" msprop:Generator_ColumnVarNameInTable="columncssText" msprop:Generator_UserColumnName="cssText">
<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="PAZ_DashStats" msprop:Generator_RowClassName="PAZ_DashStatsRow" msprop:Generator_RowEvHandlerName="PAZ_DashStatsRowChangeEventHandler" msprop:Generator_RowDeletedName="PAZ_DashStatsRowDeleted" msprop:Generator_RowDeletingName="PAZ_DashStatsRowDeleting" msprop:Generator_RowEvArgName="PAZ_DashStatsRowChangeEvent" msprop:Generator_TablePropName="PAZ_DashStats" msprop:Generator_RowChangedName="PAZ_DashStatsRowChanged" msprop:Generator_RowChangingName="PAZ_DashStatsRowChanging" msprop:Generator_TableClassName="PAZ_DashStatsDataTable" msprop:Generator_UserTableName="PAZ_DashStats" msprop:Generator_TableVarName="tablePAZ_DashStats">
<xs:complexType>
<xs:sequence>
<xs:element name="nRichieste" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nRichieste" msprop:Generator_ColumnPropNameInTable="nRichiesteColumn" msprop:Generator_ColumnVarNameInTable="columnnRichieste" msprop:Generator_UserColumnName="nRichieste" type="xs:int" minOccurs="0" />
<xs:element name="nPrevReq" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPrevReq" msprop:Generator_ColumnPropNameInTable="nPrevReqColumn" msprop:Generator_ColumnVarNameInTable="columnnPrevReq" msprop:Generator_UserColumnName="nPrevReq" type="xs:int" minOccurs="0" />
<xs:element name="nPrevAppr" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPrevAppr" msprop:Generator_ColumnPropNameInTable="nPrevApprColumn" msprop:Generator_ColumnVarNameInTable="columnnPrevAppr" msprop:Generator_UserColumnName="nPrevAppr" type="xs:int" minOccurs="0" />
<xs:element name="nAperte" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nAperte" msprop:Generator_ColumnPropNameInTable="nAperteColumn" msprop:Generator_ColumnVarNameInTable="columnnAperte" msprop:Generator_UserColumnName="nAperte" type="xs:int" minOccurs="0" />
<xs:element name="nSospese" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nSospese" msprop:Generator_ColumnPropNameInTable="nSospeseColumn" msprop:Generator_ColumnVarNameInTable="columnnSospese" msprop:Generator_UserColumnName="nSospese" type="xs:int" minOccurs="0" />
<xs:element name="nConcluse" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nConcluse" msprop:Generator_ColumnPropNameInTable="nConcluseColumn" msprop:Generator_ColumnVarNameInTable="columnnConcluse" msprop:Generator_UserColumnName="nConcluse" type="xs:int" minOccurs="0" />
<xs:element name="nFatturate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nFatturate" msprop:Generator_ColumnPropNameInTable="nFatturateColumn" msprop:Generator_ColumnVarNameInTable="columnnFatturate" msprop:Generator_UserColumnName="nFatturate" type="xs:int" minOccurs="0" />
<xs:element name="nPagate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPagate" msprop:Generator_ColumnPropNameInTable="nPagateColumn" msprop:Generator_ColumnVarNameInTable="columnnPagate" msprop:Generator_UserColumnName="nPagate" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnagActs" msprop:Generator_RowClassName="AnagActsRow" msprop:Generator_RowEvHandlerName="AnagActsRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagActsRowDeleted" msprop:Generator_RowDeletingName="AnagActsRowDeleting" msprop:Generator_RowEvArgName="AnagActsRowChangeEvent" msprop:Generator_TablePropName="AnagActs" msprop:Generator_RowChangedName="AnagActsRowChanged" msprop:Generator_RowChangingName="AnagActsRowChanging" msprop:Generator_TableClassName="AnagActsDataTable" msprop:Generator_UserTableName="AnagActs" msprop:Generator_TableVarName="tableAnagActs">
<xs:complexType>
<xs:sequence>
<xs:element name="codAzione" msprop:Generator_ColumnPropNameInRow="codAzione" msprop:Generator_ColumnPropNameInTable="codAzioneColumn" msprop:Generator_ColumnVarNameInTable="columncodAzione" msprop:Generator_UserColumnName="codAzione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="classe" msprop:Generator_ColumnPropNameInRow="classe" msprop:Generator_ColumnPropNameInTable="classeColumn" msprop:Generator_ColumnVarNameInTable="columnclasse" msprop:Generator_UserColumnName="classe">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="descrAzione" msprop:Generator_ColumnPropNameInRow="descrAzione" msprop:Generator_ColumnPropNameInTable="descrAzioneColumn" msprop:Generator_ColumnVarNameInTable="columndescrAzione" msprop:Generator_UserColumnName="descrAzione">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssIcon" msprop:Generator_ColumnPropNameInRow="cssIcon" msprop:Generator_ColumnPropNameInTable="cssIconColumn" msprop:Generator_ColumnVarNameInTable="columncssIcon" msprop:Generator_UserColumnName="cssIcon">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssButton" msprop:Generator_ColumnPropNameInRow="cssButton" msprop:Generator_ColumnPropNameInTable="cssButtonColumn" msprop:Generator_ColumnVarNameInTable="columncssButton" msprop:Generator_UserColumnName="cssButton">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cssText" msprop:Generator_ColumnPropNameInRow="cssText" msprop:Generator_ColumnPropNameInTable="cssTextColumn" msprop:Generator_ColumnVarNameInTable="columncssText" msprop:Generator_UserColumnName="cssText">
<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="Fatture" msprop:Generator_RowEvHandlerName="FattureRowChangeEventHandler" msprop:Generator_RowDeletedName="FattureRowDeleted" msprop:Generator_RowDeletingName="FattureRowDeleting" msprop:Generator_RowEvArgName="FattureRowChangeEvent" msprop:Generator_TablePropName="Fatture" msprop:Generator_RowChangedName="FattureRowChanged" msprop:Generator_RowChangingName="FattureRowChanging" msprop:Generator_TableClassName="FattureDataTable" msprop:Generator_RowClassName="FattureRow" msprop:Generator_TableVarName="tableFatture" msprop:Generator_UserTableName="Fatture">
<xs:complexType>
<xs:sequence>
<xs:element name="idxDoc" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idxDoc" msprop:Generator_ColumnPropNameInTable="idxDocColumn" msprop:Generator_ColumnVarNameInTable="columnidxDoc" msprop:Generator_UserColumnName="idxDoc" type="xs:int" />
<xs:element name="idxRichiesta" msprop:Generator_ColumnPropNameInRow="idxRichiesta" msprop:Generator_ColumnPropNameInTable="idxRichiestaColumn" msprop:Generator_ColumnVarNameInTable="columnidxRichiesta" msprop:Generator_UserColumnName="idxRichiesta" type="xs:int" />
<xs:element name="idxFornitore" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
<xs:element name="numDoc" msprop:Generator_ColumnPropNameInRow="numDoc" msprop:Generator_ColumnPropNameInTable="numDocColumn" msprop:Generator_ColumnVarNameInTable="columnnumDoc" msprop:Generator_UserColumnName="numDoc">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dataFatt" msprop:Generator_ColumnPropNameInRow="dataFatt" msprop:Generator_ColumnPropNameInTable="dataFattColumn" msprop:Generator_ColumnVarNameInTable="columndataFatt" msprop:Generator_UserColumnName="dataFatt" type="xs:dateTime" />
<xs:element name="intervento" msprop:Generator_ColumnPropNameInRow="intervento" msprop:Generator_ColumnPropNameInTable="interventoColumn" msprop:Generator_ColumnVarNameInTable="columnintervento" msprop:Generator_UserColumnName="intervento">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2147483647" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Imponibile" msprop:Generator_ColumnPropNameInRow="Imponibile" msprop:Generator_ColumnPropNameInTable="ImponibileColumn" msprop:Generator_ColumnVarNameInTable="columnImponibile" msprop:Generator_UserColumnName="Imponibile" type="xs:decimal" />
<xs:element name="dataPag" msprop:Generator_ColumnPropNameInRow="dataPag" msprop:Generator_ColumnPropNameInTable="dataPagColumn" msprop:Generator_ColumnVarNameInTable="columndataPag" msprop:Generator_UserColumnName="dataPag" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="StatoRichByForn" msprop:Generator_RowClassName="StatoRichByFornRow" msprop:Generator_RowEvHandlerName="StatoRichByFornRowChangeEventHandler" msprop:Generator_RowDeletedName="StatoRichByFornRowDeleted" msprop:Generator_RowDeletingName="StatoRichByFornRowDeleting" msprop:Generator_RowEvArgName="StatoRichByFornRowChangeEvent" msprop:Generator_TablePropName="StatoRichByForn" msprop:Generator_RowChangedName="StatoRichByFornRowChanged" msprop:Generator_RowChangingName="StatoRichByFornRowChanging" msprop:Generator_TableClassName="StatoRichByFornDataTable" msprop:Generator_UserTableName="StatoRichByForn" msprop:Generator_TableVarName="tableStatoRichByForn">
<xs:complexType>
<xs:sequence>
<xs:element name="cod_fornitore" msprop:Generator_ColumnPropNameInRow="cod_fornitore" msprop:Generator_ColumnPropNameInTable="cod_fornitoreColumn" msprop:Generator_ColumnVarNameInTable="columncod_fornitore" msprop:Generator_UserColumnName="cod_fornitore" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nRichieste" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nRichieste" msprop:Generator_ColumnPropNameInTable="nRichiesteColumn" msprop:Generator_ColumnVarNameInTable="columnnRichieste" msprop:Generator_UserColumnName="nRichieste" type="xs:int" minOccurs="0" />
<xs:element name="nPreventivi" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPreventivi" msprop:Generator_ColumnPropNameInTable="nPreventiviColumn" msprop:Generator_ColumnVarNameInTable="columnnPreventivi" msprop:Generator_UserColumnName="nPreventivi" type="xs:int" minOccurs="0" />
<xs:element name="nAperte" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nAperte" msprop:Generator_ColumnPropNameInTable="nAperteColumn" msprop:Generator_ColumnVarNameInTable="columnnAperte" msprop:Generator_UserColumnName="nAperte" type="xs:int" minOccurs="0" />
<xs:element name="nSospese" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nSospese" msprop:Generator_ColumnPropNameInTable="nSospeseColumn" msprop:Generator_ColumnVarNameInTable="columnnSospese" msprop:Generator_UserColumnName="nSospese" type="xs:int" minOccurs="0" />
<xs:element name="nConcluse" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nConcluse" msprop:Generator_ColumnPropNameInTable="nConcluseColumn" msprop:Generator_ColumnVarNameInTable="columnnConcluse" msprop:Generator_UserColumnName="nConcluse" type="xs:int" minOccurs="0" />
<xs:element name="nFatturate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nFatturate" msprop:Generator_ColumnPropNameInTable="nFatturateColumn" msprop:Generator_ColumnVarNameInTable="columnnFatturate" msprop:Generator_UserColumnName="nFatturate" type="xs:int" minOccurs="0" />
<xs:element name="nPagate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nPagate" msprop:Generator_ColumnPropNameInTable="nPagateColumn" msprop:Generator_ColumnVarNameInTable="columnnPagate" msprop:Generator_UserColumnName="nPagate" type="xs:int" minOccurs="0" />
<xs:element name="nContestate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nContestate" msprop:Generator_ColumnPropNameInTable="nContestateColumn" msprop:Generator_ColumnVarNameInTable="columnnContestate" msprop:Generator_UserColumnName="nContestate" type="xs:int" minOccurs="0" />
<xs:element name="nProgrammate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nProgrammate" msprop:Generator_ColumnPropNameInTable="nProgrammateColumn" msprop:Generator_ColumnVarNameInTable="columnnProgrammate" msprop:Generator_UserColumnName="nProgrammate" type="xs:int" minOccurs="0" />
<xs:element name="nCongelate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nCongelate" msprop:Generator_ColumnPropNameInTable="nCongelateColumn" msprop:Generator_ColumnVarNameInTable="columnnCongelate" msprop:Generator_UserColumnName="nCongelate" type="xs:int" minOccurs="0" />
<xs:element name="nAnnullate" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="nAnnullate" msprop:Generator_ColumnPropNameInTable="nAnnullateColumn" msprop:Generator_ColumnVarNameInTable="columnnAnnullate" msprop:Generator_UserColumnName="nAnnullate" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="GruppiCond" msprop:Generator_RowClassName="GruppiCondRow" msprop:Generator_RowEvHandlerName="GruppiCondRowChangeEventHandler" msprop:Generator_RowDeletedName="GruppiCondRowDeleted" msprop:Generator_RowDeletingName="GruppiCondRowDeleting" msprop:Generator_RowEvArgName="GruppiCondRowChangeEvent" msprop:Generator_TablePropName="GruppiCond" msprop:Generator_RowChangedName="GruppiCondRowChanged" msprop:Generator_RowChangingName="GruppiCondRowChanging" msprop:Generator_TableClassName="GruppiCondDataTable" msprop:Generator_UserTableName="GruppiCond" msprop:Generator_TableVarName="tableGruppiCond">
<xs:complexType>
<xs:sequence>
<xs:element name="chiave" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="chiave" msprop:Generator_ColumnPropNameInTable="chiaveColumn" msprop:Generator_ColumnVarNameInTable="columnchiave" msprop:Generator_UserColumnName="chiave" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="valore" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="valore" msprop:Generator_ColumnPropNameInTable="valoreColumn" msprop:Generator_ColumnVarNameInTable="columnvalore" msprop:Generator_UserColumnName="valore" 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:AnagAmministratori" />
<xs:field xpath="mstns:idxAmm" />
</xs:unique>
<xs:unique name="AnagCondomini_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagCondomini" />
<xs:field xpath="mstns:idxCond" />
</xs:unique>
<xs:unique name="AnagAree_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagAree" />
<xs:field xpath="mstns:idxArea" />
</xs:unique>
<xs:unique name="AnagFornitori_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagFornitori" />
<xs:field xpath="mstns:idxFornitore" />
</xs:unique>
<xs:unique name="AssF2A_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AssF2A" />
<xs:field xpath="mstns:idxFornitore" />
<xs:field xpath="mstns:idxArea" />
</xs:unique>
<xs:unique name="AssF2C_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AssF2C" />
<xs:field xpath="mstns:idxCond" />
<xs:field xpath="mstns:idxFornitore" />
<xs:field xpath="mstns:idxArea" />
</xs:unique>
<xs:unique name="ElencolRich_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ElencolRich" />
<xs:field xpath="mstns:idxRichiesta" />
</xs:unique>
<xs:unique name="AnagStati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagStati" />
<xs:field xpath="mstns:idxStato" />
</xs:unique>
<xs:unique name="StatoRichByCondKey1">
<xs:selector xpath=".//mstns:StatoRichByCond" />
<xs:field xpath="mstns:cod_cond" />
</xs:unique>
<xs:unique name="AnagPrior_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagPrior" />
<xs:field xpath="mstns:idxPriorita" />
</xs:unique>
<xs:unique name="ER_Acts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ER_Acts" />
<xs:field xpath="mstns:idxAzione" />
</xs:unique>
<xs:unique name="AnagActs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:AnagActs" />
<xs:field xpath="mstns:codAzione" />
</xs:unique>
<xs:unique name="Fatture_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Fatture" />
<xs:field xpath="mstns:idxDoc" />
</xs:unique>
<xs:unique name="StatoRichByFornKey1">
<xs:selector xpath=".//mstns:StatoRichByForn" />
<xs:field xpath="mstns:cod_fornitore" />
</xs:unique>
<xs:unique name="GruppiCondKey1">
<xs:selector xpath=".//mstns:GruppiCond" />
<xs:field xpath="mstns:chiave" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="FK_AnagCondomini_AnagAmministratori" msdata:parent="AnagAmministratori" msdata:child="AnagCondomini" msdata:parentkey="idxAmm" msdata:childkey="idxAmm" msprop:Generator_UserParentTable="AnagAmministratori" msprop:Generator_UserChildTable="AnagCondomini" msprop:Generator_RelationVarName="relationFK_AnagCondomini_AnagAmministratori" msprop:Generator_ChildPropName="GetAnagCondominiRows" msprop:Generator_ParentPropName="AnagAmministratoriRow" msprop:Generator_UserRelationName="FK_AnagCondomini_AnagAmministratori" />
<msdata:Relationship name="RelFornitore2Area_AnagFornitori" msdata:parent="AssF2A" msdata:child="AnagFornitori" msdata:parentkey="idxFornitore" msdata:childkey="idxFornitore" msprop:Generator_UserParentTable="AssF2A" msprop:Generator_UserChildTable="AnagFornitori" msprop:Generator_RelationVarName="relationRelFornitore2Area_AnagFornitori" msprop:Generator_ChildPropName="GetAnagFornitoriRows" msprop:Generator_ParentPropName="AssF2ARow" msprop:Generator_UserRelationName="RelFornitore2Area_AnagFornitori" />
<msdata:Relationship name="AnagAree_RelFornitore2Area" msdata:parent="AnagAree" msdata:child="AssF2A" msdata:parentkey="idxArea" msdata:childkey="idxArea" msprop:Generator_ChildPropName="GetAssF2ARows" msprop:Generator_UserChildTable="AssF2A" msprop:Generator_RelationVarName="relationAnagAree_RelFornitore2Area" msprop:Generator_UserRelationName="AnagAree_RelFornitore2Area" msprop:Generator_UserParentTable="AnagAree" msprop:Generator_ParentPropName="AnagAreeRow" />
<msdata:Relationship name="FK_RelFornitore2Condominio_AnagCondomini" msdata:parent="AnagCondomini" msdata:child="AssF2C" msdata:parentkey="idxCond" msdata:childkey="idxCond" msprop:Generator_UserParentTable="AnagCondomini" msprop:Generator_UserChildTable="AssF2C" msprop:Generator_RelationVarName="relationFK_RelFornitore2Condominio_AnagCondomini" msprop:Generator_ChildPropName="GetAssF2CRows" msprop:Generator_ParentPropName="AnagCondominiRow" msprop:Generator_UserRelationName="FK_RelFornitore2Condominio_AnagCondomini" />
<msdata:Relationship name="FK_RelFornitore2Condominio_AnagFornitori" msdata:parent="AnagFornitori" msdata:child="AssF2C" msdata:parentkey="idxFornitore" msdata:childkey="idxFornitore" msprop:Generator_UserParentTable="AnagFornitori" msprop:Generator_UserChildTable="AssF2C" msprop:Generator_RelationVarName="relationFK_RelFornitore2Condominio_AnagFornitori" msprop:Generator_ChildPropName="GetAssF2CRows" msprop:Generator_ParentPropName="AnagFornitoriRow" msprop:Generator_UserRelationName="FK_RelFornitore2Condominio_AnagFornitori" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
Reference in New Issue View Git Blame Copy Permalink