Samuele Locatelli
1514 lines
231 KiB
XML
1514 lines
231 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_utilsProjEts" targetNamespace="http://tempuri.org/DS_utilsProjEts.xsd" xmlns:mstns="http://tempuri.org/DS_utilsProjEts.xsd" xmlns="http://tempuri.org/DS_utilsProjEts.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="ETS_PROJConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ETS_PROJConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ETS_Data.Properties.Settings.GlobalReference.Default.ETS_PROJConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selClientiTableAdapter" GeneratorDataComponentClassName="v_selClientiTableAdapter" Name="v_selClienti" UserDataComponentName="v_selClientiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="[ETS-PROJ].dbo.v_selClienti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selClienti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="[ETS-PROJ].dbo.stp_vsc_getBySearchLike" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearchLike" GetMethodModifier="Public" GetMethodName="getBySearchLike" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearchLike" UserSourceName="getBySearchLike">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vsc_getBySearchLike</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="@ricerca" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="[ETS-PROJ].dbo.stp_vsc_getByValue" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByValue" GetMethodModifier="Public" GetMethodName="getByValue" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByValue" UserSourceName="getByValue">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vsc_getByValue</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="@value" 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="v_selProgettiTableAdapter" GeneratorDataComponentClassName="v_selProgettiTableAdapter" Name="v_selProgetti" UserDataComponentName="v_selProgettiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="[ETS-PROJ].dbo.v_selProgetti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, conditio, Attivo FROM dbo.v_selProgetti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSPrj_byConditio" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPrj_byConditio</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="@conditio" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSPrj_byValue" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByValue" GetMethodModifier="Public" GetMethodName="getByValue" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByValue" UserSourceName="getByValue">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPrj_byValue</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="@value" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="[ETS-PROJ].dbo.stp_VSPrj" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getGrouped" GetMethodModifier="Public" GetMethodName="getGrouped" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getGrouped" UserSourceName="getGrouped">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPrj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selCommesseTableAdapter" GeneratorDataComponentClassName="v_selCommesseTableAdapter" Name="v_selCommesse" UserDataComponentName="v_selCommesseTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_selCommesse" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, conditio FROM dbo.v_selCommesse</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_getAttiveBySearchLike" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getAttiveBySearchLike" GetMethodModifier="Public" GetMethodName="getAttiveBySearchLike" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getAttiveBySearchLike" UserSourceName="getAttiveBySearchLike">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_getAttiveBySearchLike</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="@ricerca" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_getAttiveUnusedBySearchLike" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getAttiveUnusedBySearchLike" GetMethodModifier="Public" GetMethodName="getAttiveUnusedBySearchLike" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getAttiveUnusedBySearchLike" UserSourceName="getAttiveUnusedBySearchLike">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_getAttiveUnusedBySearchLike</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="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Sett" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ricerca" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_byConditio" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_byConditio</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="@conditio" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_getBySearchLike" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearchLike" GetMethodModifier="Public" GetMethodName="getBySearchLike" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearchLike" UserSourceName="getBySearchLike">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_getBySearchLike</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="@ricerca" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_getByWeek" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByWeek" GetMethodModifier="Public" GetMethodName="getByWeek" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByWeek" UserSourceName="getByWeek">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_getByWeek</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="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Sett" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_getShortByWeek" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getCommShort" GetMethodModifier="Public" GetMethodName="getCommShort" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getCommShort" UserSourceName="getCommShort">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_getShortByWeek</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="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Sett" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSCom_getShortByIrWeek" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getShortByWeekIR" GetMethodModifier="Public" GetMethodName="getShortByWeekIR" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getShortByWeekIR" UserSourceName="getShortByWeekIR">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCom_getShortByIrWeek</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="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Sett" 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="v_selCCTableAdapter" GeneratorDataComponentClassName="v_selCCTableAdapter" Name="v_selCC" UserDataComponentName="v_selCCTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_selCC" 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 label, value FROM dbo.v_selCC
|
|
ORDER BY label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selCC_allTableAdapter" GeneratorDataComponentClassName="v_selCC_allTableAdapter" Name="v_selCC_all" UserDataComponentName="v_selCC_allTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_selCC_all" 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 value, label FROM dbo.v_selCC_all
|
|
ORDER BY label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selWeekTableAdapter" GeneratorDataComponentClassName="v_selWeekTableAdapter" Name="v_selWeek" UserDataComponentName="v_selWeekTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_selWeek" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT n FROM dbo.v_selWeek</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="n" DataSetColumn="n" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selYearTableAdapter" GeneratorDataComponentClassName="v_selYearTableAdapter" Name="v_selYear" UserDataComponentName="v_selYearTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_selYear" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT n FROM dbo.v_selYear</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="n" DataSetColumn="n" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selFornitoriClaTableAdapter" GeneratorDataComponentClassName="v_selFornitoriClaTableAdapter" Name="v_selFornitoriCla" UserDataComponentName="v_selFornitoriClaTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_selFornitoriCla" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, conditio FROM dbo.v_selFornitoriCla</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_VSF_getBySearchLike" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearchLike" GetMethodModifier="Public" GetMethodName="getBySearchLike" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearchLike" UserSourceName="getBySearchLike">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSF_getBySearchLike</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="@ricerca" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_FattureETSTableAdapter" GeneratorDataComponentClassName="v_FattureETSTableAdapter" Name="v_FattureETS" UserDataComponentName="v_FattureETSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.v_FattureETS" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT NumeroCommessa, AnnoCommessa, Commessa, Emitt, Dest, Tipologia, NrFatt, DataFatt, Importo FROM dbo.v_FattureETS</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="NumeroCommessa" DataSetColumn="NumeroCommessa" />
|
|
<Mapping SourceColumn="AnnoCommessa" DataSetColumn="AnnoCommessa" />
|
|
<Mapping SourceColumn="Commessa" DataSetColumn="Commessa" />
|
|
<Mapping SourceColumn="Emitt" DataSetColumn="Emitt" />
|
|
<Mapping SourceColumn="Dest" DataSetColumn="Dest" />
|
|
<Mapping SourceColumn="Tipologia" DataSetColumn="Tipologia" />
|
|
<Mapping SourceColumn="NrFatt" DataSetColumn="NrFatt" />
|
|
<Mapping SourceColumn="DataFatt" DataSetColumn="DataFatt" />
|
|
<Mapping SourceColumn="Importo" DataSetColumn="Importo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_vFattGetByComm" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCommessa" GetMethodModifier="Public" GetMethodName="getByCommessa" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCommessa" UserSourceName="getByCommessa">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vFattGetByComm</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="@NumeroCommessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AnnoCommessa" 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="Storico_DatiCommessaTableAdapter" GeneratorDataComponentClassName="Storico_DatiCommessaTableAdapter" Name="Storico_DatiCommessa" UserDataComponentName="Storico_DatiCommessaTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.Storico_DatiCommessa" 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].[Storico_DatiCommessa] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_nickname = 1 AND [nickname] IS NULL) OR ([nickname] = @Original_nickname)) AND ((@IsNull_CheckOk = 1 AND [CheckOk] IS NULL) OR ([CheckOk] = @Original_CheckOk)) AND ((@IsNull_CapoCommessa = 1 AND [CapoCommessa] IS NULL) OR ([CapoCommessa] = @Original_CapoCommessa)) AND ((@IsNull_SQC = 1 AND [SQC] IS NULL) OR ([SQC] = @Original_SQC)) AND ((@IsNull_Pubblico = 1 AND [Pubblico] IS NULL) OR ([Pubblico] = @Original_Pubblico)) AND ((@IsNull_EnteProcuratore = 1 AND [EnteProcuratore] IS NULL) OR ([EnteProcuratore] = @Original_EnteProcuratore)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_DataApertura = 1 AND [DataApertura] IS NULL) OR ([DataApertura] = @Original_DataApertura)) AND ((@IsNull_DataScadenza = 1 AND [DataScadenza] IS NULL) OR ([DataScadenza] = @Original_DataScadenza)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_NomeComm = 1 AND [NomeComm] IS NULL) OR ([NomeComm] = @Original_NomeComm)) AND ((@IsNull_ImportoIntegr = 1 AND [ImportoIntegr] IS NULL) OR ([ImportoIntegr] = @Original_ImportoIntegr)) AND ((@IsNull_ImportoFornExt = 1 AND [ImportoFornExt] IS NULL) OR ([ImportoFornExt] = @Original_ImportoFornExt)) AND ((@IsNull_BCWS = 1 AND [BCWS] IS NULL) OR ([BCWS] = @Original_BCWS)) AND ((@IsNull_BCWSFasi = 1 AND [BCWSFasi] IS NULL) OR ([BCWSFasi] = @Original_BCWSFasi)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeroCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nickname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nickname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CheckOk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CheckOk" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CheckOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CheckOk" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CapoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CapoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CapoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CapoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SQC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SQC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SQC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SQC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pubblico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pubblico" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Pubblico" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pubblico" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnteProcuratore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnteProcuratore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnteProcuratore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnteProcuratore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataApertura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataApertura" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataApertura" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataApertura" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataScadenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataScadenza" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataScadenza" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScadenza" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NomeComm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeComm" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NomeComm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeComm" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImportoIntegr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImportoIntegr" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ImportoIntegr" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoIntegr" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImportoFornExt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImportoFornExt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ImportoFornExt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoFornExt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BCWS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BCWS" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_BCWS" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BCWSFasi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BCWSFasi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_BCWSFasi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWSFasi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Storico_DatiCommessa] ([DataEv], [idxFase], [AnnoCommessa], [NumeroCommessa], [nickname], [CheckOk], [CapoCommessa], [SQC], [Pubblico], [EnteProcuratore], [Importo], [DataApertura], [DataScadenza], [rifOfferta], [urlOfferta], [rifOrdine], [urlOrdine], [Indirizzo], [Note], [NomeComm], [ImportoIntegr], [ImportoFornExt], [BCWS], [BCWSFasi], [modificatoDa]) VALUES (@DataEv, @idxFase, @AnnoCommessa, @NumeroCommessa, @nickname, @CheckOk, @CapoCommessa, @SQC, @Pubblico, @EnteProcuratore, @Importo, @DataApertura, @DataScadenza, @rifOfferta, @urlOfferta, @rifOrdine, @urlOrdine, @Indirizzo, @Note, @NomeComm, @ImportoIntegr, @ImportoFornExt, @BCWS, @BCWSFasi, @modificatoDa);
|
|
SELECT idxEv, DataEv, idxFase, AnnoCommessa, NumeroCommessa, nickname, CheckOk, CapoCommessa, SQC, Pubblico, EnteProcuratore, Importo, DataApertura, DataScadenza, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Indirizzo, Note, NomeComm, ImportoIntegr, ImportoFornExt, BCWS, BCWSFasi, modificatoDa FROM Storico_DatiCommessa WHERE (idxEv = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nickname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CheckOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CheckOk" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CapoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CapoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SQC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SQC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Pubblico" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pubblico" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnteProcuratore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnteProcuratore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataApertura" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataApertura" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataScadenza" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScadenza" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NomeComm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeComm" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ImportoIntegr" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoIntegr" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ImportoFornExt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoFornExt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@BCWS" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@BCWSFasi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWSFasi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxEv, DataEv, idxFase, AnnoCommessa, NumeroCommessa, nickname, CheckOk, CapoCommessa, SQC, Pubblico, EnteProcuratore, Importo, DataApertura, DataScadenza, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Indirizzo, Note, NomeComm, ImportoIntegr, ImportoFornExt, BCWS, BCWSFasi, modificatoDa FROM dbo.Storico_DatiCommessa</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Storico_DatiCommessa] SET [DataEv] = @DataEv, [idxFase] = @idxFase, [AnnoCommessa] = @AnnoCommessa, [NumeroCommessa] = @NumeroCommessa, [nickname] = @nickname, [CheckOk] = @CheckOk, [CapoCommessa] = @CapoCommessa, [SQC] = @SQC, [Pubblico] = @Pubblico, [EnteProcuratore] = @EnteProcuratore, [Importo] = @Importo, [DataApertura] = @DataApertura, [DataScadenza] = @DataScadenza, [rifOfferta] = @rifOfferta, [urlOfferta] = @urlOfferta, [rifOrdine] = @rifOrdine, [urlOrdine] = @urlOrdine, [Indirizzo] = @Indirizzo, [Note] = @Note, [NomeComm] = @NomeComm, [ImportoIntegr] = @ImportoIntegr, [ImportoFornExt] = @ImportoFornExt, [BCWS] = @BCWS, [BCWSFasi] = @BCWSFasi, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_nickname = 1 AND [nickname] IS NULL) OR ([nickname] = @Original_nickname)) AND ((@IsNull_CheckOk = 1 AND [CheckOk] IS NULL) OR ([CheckOk] = @Original_CheckOk)) AND ((@IsNull_CapoCommessa = 1 AND [CapoCommessa] IS NULL) OR ([CapoCommessa] = @Original_CapoCommessa)) AND ((@IsNull_SQC = 1 AND [SQC] IS NULL) OR ([SQC] = @Original_SQC)) AND ((@IsNull_Pubblico = 1 AND [Pubblico] IS NULL) OR ([Pubblico] = @Original_Pubblico)) AND ((@IsNull_EnteProcuratore = 1 AND [EnteProcuratore] IS NULL) OR ([EnteProcuratore] = @Original_EnteProcuratore)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_DataApertura = 1 AND [DataApertura] IS NULL) OR ([DataApertura] = @Original_DataApertura)) AND ((@IsNull_DataScadenza = 1 AND [DataScadenza] IS NULL) OR ([DataScadenza] = @Original_DataScadenza)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_NomeComm = 1 AND [NomeComm] IS NULL) OR ([NomeComm] = @Original_NomeComm)) AND ((@IsNull_ImportoIntegr = 1 AND [ImportoIntegr] IS NULL) OR ([ImportoIntegr] = @Original_ImportoIntegr)) AND ((@IsNull_ImportoFornExt = 1 AND [ImportoFornExt] IS NULL) OR ([ImportoFornExt] = @Original_ImportoFornExt)) AND ((@IsNull_BCWS = 1 AND [BCWS] IS NULL) OR ([BCWS] = @Original_BCWS)) AND ((@IsNull_BCWSFasi = 1 AND [BCWSFasi] IS NULL) OR ([BCWSFasi] = @Original_BCWSFasi)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)));
|
|
SELECT idxEv, DataEv, idxFase, AnnoCommessa, NumeroCommessa, nickname, CheckOk, CapoCommessa, SQC, Pubblico, EnteProcuratore, Importo, DataApertura, DataScadenza, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Indirizzo, Note, NomeComm, ImportoIntegr, ImportoFornExt, BCWS, BCWSFasi, modificatoDa FROM Storico_DatiCommessa WHERE (idxEv = @idxEv)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nickname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CheckOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CheckOk" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CapoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CapoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SQC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SQC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Pubblico" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pubblico" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnteProcuratore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnteProcuratore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataApertura" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataApertura" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataScadenza" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScadenza" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NomeComm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeComm" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ImportoIntegr" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoIntegr" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ImportoFornExt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoFornExt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@BCWS" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@BCWSFasi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWSFasi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeroCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nickname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nickname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CheckOk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CheckOk" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CheckOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CheckOk" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CapoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CapoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CapoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CapoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SQC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SQC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SQC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SQC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pubblico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pubblico" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Pubblico" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pubblico" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnteProcuratore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnteProcuratore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnteProcuratore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnteProcuratore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataApertura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataApertura" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataApertura" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataApertura" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataScadenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataScadenza" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataScadenza" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScadenza" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NomeComm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeComm" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NomeComm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeComm" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImportoIntegr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImportoIntegr" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ImportoIntegr" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoIntegr" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImportoFornExt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImportoFornExt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ImportoFornExt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ImportoFornExt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BCWS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BCWS" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_BCWS" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BCWSFasi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BCWSFasi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_BCWSFasi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="BCWSFasi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxEv" ColumnName="idxEv" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxEv" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxEv" DataSetColumn="idxEv" />
|
|
<Mapping SourceColumn="DataEv" DataSetColumn="DataEv" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="AnnoCommessa" DataSetColumn="AnnoCommessa" />
|
|
<Mapping SourceColumn="NumeroCommessa" DataSetColumn="NumeroCommessa" />
|
|
<Mapping SourceColumn="nickname" DataSetColumn="nickname" />
|
|
<Mapping SourceColumn="CheckOk" DataSetColumn="CheckOk" />
|
|
<Mapping SourceColumn="CapoCommessa" DataSetColumn="CapoCommessa" />
|
|
<Mapping SourceColumn="SQC" DataSetColumn="SQC" />
|
|
<Mapping SourceColumn="Pubblico" DataSetColumn="Pubblico" />
|
|
<Mapping SourceColumn="EnteProcuratore" DataSetColumn="EnteProcuratore" />
|
|
<Mapping SourceColumn="Importo" DataSetColumn="Importo" />
|
|
<Mapping SourceColumn="DataApertura" DataSetColumn="DataApertura" />
|
|
<Mapping SourceColumn="DataScadenza" DataSetColumn="DataScadenza" />
|
|
<Mapping SourceColumn="rifOfferta" DataSetColumn="rifOfferta" />
|
|
<Mapping SourceColumn="urlOfferta" DataSetColumn="urlOfferta" />
|
|
<Mapping SourceColumn="rifOrdine" DataSetColumn="rifOrdine" />
|
|
<Mapping SourceColumn="urlOrdine" DataSetColumn="urlOrdine" />
|
|
<Mapping SourceColumn="Indirizzo" DataSetColumn="Indirizzo" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="NomeComm" DataSetColumn="NomeComm" />
|
|
<Mapping SourceColumn="ImportoIntegr" DataSetColumn="ImportoIntegr" />
|
|
<Mapping SourceColumn="ImportoFornExt" DataSetColumn="ImportoFornExt" />
|
|
<Mapping SourceColumn="BCWS" DataSetColumn="BCWS" />
|
|
<Mapping SourceColumn="BCWSFasi" DataSetColumn="BCWSFasi" />
|
|
<Mapping SourceColumn="modificatoDa" DataSetColumn="modificatoDa" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_SDC_getByIdxFase" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFase" GetMethodModifier="Public" GetMethodName="getByIdxFase" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFase" UserSourceName="getByIdxFase">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_SDC_getByIdxFase</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="@idxFase" 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="Storico_DatiCommFornTableAdapter" GeneratorDataComponentClassName="Storico_DatiCommFornTableAdapter" Name="Storico_DatiCommForn" UserDataComponentName="Storico_DatiCommFornTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.Storico_DatiCommForn" 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].[Storico_DatiCommForn] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCF = 1 AND [idxDCF] IS NULL) OR ([idxDCF] = @Original_idxDCF)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_Fornitore = 1 AND [Fornitore] IS NULL) OR ([Fornitore] = @Original_Fornitore)) AND ((@IsNull_Referente = 1 AND [Referente] IS NULL) OR ([Referente] = @Original_Referente)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOrdineForn = 1 AND [rifOrdineForn] IS NULL) OR ([rifOrdineForn] = @Original_rifOrdineForn)) AND ((@IsNull_urlOrdineForn = 1 AND [urlOrdineForn] IS NULL) OR ([urlOrdineForn] = @Original_urlOrdineForn)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxDCF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCF" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxDCF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCF" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fornitore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fornitore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Referente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Referente" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Referente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Referente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOrdineForn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOrdineForn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdineForn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOrdineForn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOrdineForn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdineForn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Storico_DatiCommForn] ([DataEv], [idxDCF], [idxFase], [Fornitore], [Referente], [Importo], [rifOrdineForn], [urlOrdineForn], [Note], [modificatoDa]) VALUES (@DataEv, @idxDCF, @idxFase, @Fornitore, @Referente, @Importo, @rifOrdineForn, @urlOrdineForn, @Note, @modificatoDa);
|
|
SELECT idxEv, DataEv, idxDCF, idxFase, Fornitore, Referente, Importo, rifOrdineForn, urlOrdineForn, Note, modificatoDa FROM Storico_DatiCommForn WHERE (idxEv = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxDCF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCF" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fornitore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Referente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Referente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdineForn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdineForn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxEv, DataEv, idxDCF, idxFase, Fornitore, Referente, Importo, rifOrdineForn, urlOrdineForn, Note, modificatoDa FROM dbo.Storico_DatiCommForn</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Storico_DatiCommForn] SET [DataEv] = @DataEv, [idxDCF] = @idxDCF, [idxFase] = @idxFase, [Fornitore] = @Fornitore, [Referente] = @Referente, [Importo] = @Importo, [rifOrdineForn] = @rifOrdineForn, [urlOrdineForn] = @urlOrdineForn, [Note] = @Note, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCF = 1 AND [idxDCF] IS NULL) OR ([idxDCF] = @Original_idxDCF)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_Fornitore = 1 AND [Fornitore] IS NULL) OR ([Fornitore] = @Original_Fornitore)) AND ((@IsNull_Referente = 1 AND [Referente] IS NULL) OR ([Referente] = @Original_Referente)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOrdineForn = 1 AND [rifOrdineForn] IS NULL) OR ([rifOrdineForn] = @Original_rifOrdineForn)) AND ((@IsNull_urlOrdineForn = 1 AND [urlOrdineForn] IS NULL) OR ([urlOrdineForn] = @Original_urlOrdineForn)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)));
|
|
SELECT idxEv, DataEv, idxDCF, idxFase, Fornitore, Referente, Importo, rifOrdineForn, urlOrdineForn, Note, modificatoDa FROM Storico_DatiCommForn WHERE (idxEv = @idxEv)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxDCF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCF" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fornitore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Referente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Referente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdineForn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdineForn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxDCF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCF" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxDCF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCF" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fornitore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fornitore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Referente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Referente" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Referente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Referente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOrdineForn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOrdineForn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdineForn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOrdineForn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOrdineForn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOrdineForn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdineForn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxEv" ColumnName="idxEv" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxEv" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxEv" DataSetColumn="idxEv" />
|
|
<Mapping SourceColumn="DataEv" DataSetColumn="DataEv" />
|
|
<Mapping SourceColumn="idxDCF" DataSetColumn="idxDCF" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="Fornitore" DataSetColumn="Fornitore" />
|
|
<Mapping SourceColumn="Referente" DataSetColumn="Referente" />
|
|
<Mapping SourceColumn="Importo" DataSetColumn="Importo" />
|
|
<Mapping SourceColumn="rifOrdineForn" DataSetColumn="rifOrdineForn" />
|
|
<Mapping SourceColumn="urlOrdineForn" DataSetColumn="urlOrdineForn" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="modificatoDa" DataSetColumn="modificatoDa" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_SDCF_getByIdxFase" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFase" GetMethodModifier="Public" GetMethodName="getByIdxFase" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFase" UserSourceName="getByIdxFase">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_SDCF_getByIdxFase</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="@idxFase" 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="Storico_DatiCommIntegTableAdapter" GeneratorDataComponentClassName="Storico_DatiCommIntegTableAdapter" Name="Storico_DatiCommInteg" UserDataComponentName="Storico_DatiCommIntegTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.Storico_DatiCommInteg" 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].[Storico_DatiCommInteg] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCI = 1 AND [idxDCI] IS NULL) OR ([idxDCI] = @Original_idxDCI)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxDCI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCI" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxDCI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCI" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRif" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Storico_DatiCommInteg] ([DataEv], [idxDCI], [idxFase], [DataRif], [Importo], [rifOfferta], [urlOfferta], [rifOrdine], [urlOrdine], [Note], [modificatoDa]) VALUES (@DataEv, @idxDCI, @idxFase, @DataRif, @Importo, @rifOfferta, @urlOfferta, @rifOrdine, @urlOrdine, @Note, @modificatoDa);
|
|
SELECT idxEv, DataEv, idxDCI, idxFase, DataRif, Importo, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Note, modificatoDa FROM Storico_DatiCommInteg WHERE (idxEv = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxDCI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCI" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxEv, DataEv, idxDCI, idxFase, DataRif, Importo, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Note, modificatoDa FROM dbo.Storico_DatiCommInteg</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Storico_DatiCommInteg] SET [DataEv] = @DataEv, [idxDCI] = @idxDCI, [idxFase] = @idxFase, [DataRif] = @DataRif, [Importo] = @Importo, [rifOfferta] = @rifOfferta, [urlOfferta] = @urlOfferta, [rifOrdine] = @rifOrdine, [urlOrdine] = @urlOrdine, [Note] = @Note, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCI = 1 AND [idxDCI] IS NULL) OR ([idxDCI] = @Original_idxDCI)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)));
|
|
SELECT idxEv, DataEv, idxDCI, idxFase, DataRif, Importo, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Note, modificatoDa FROM Storico_DatiCommInteg WHERE (idxEv = @idxEv)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxDCI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCI" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxDCI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCI" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxDCI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxDCI" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRif" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Importo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Importo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOfferta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOfferta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOfferta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rifOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rifOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rifOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_urlOrdine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_urlOrdine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="urlOrdine" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxEv" ColumnName="idxEv" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxEv" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxEv" DataSetColumn="idxEv" />
|
|
<Mapping SourceColumn="DataEv" DataSetColumn="DataEv" />
|
|
<Mapping SourceColumn="idxDCI" DataSetColumn="idxDCI" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="DataRif" DataSetColumn="DataRif" />
|
|
<Mapping SourceColumn="Importo" DataSetColumn="Importo" />
|
|
<Mapping SourceColumn="rifOfferta" DataSetColumn="rifOfferta" />
|
|
<Mapping SourceColumn="urlOfferta" DataSetColumn="urlOfferta" />
|
|
<Mapping SourceColumn="rifOrdine" DataSetColumn="rifOrdine" />
|
|
<Mapping SourceColumn="urlOrdine" DataSetColumn="urlOrdine" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="modificatoDa" DataSetColumn="modificatoDa" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_SDCI_getByIdxFase" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFase" GetMethodModifier="Public" GetMethodName="getByIdxFase" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFase" UserSourceName="getByIdxFase">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_SDCI_getByIdxFase</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="@idxFase" 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="Storico_DatiFaseTableAdapter" GeneratorDataComponentClassName="Storico_DatiFaseTableAdapter" Name="Storico_DatiFase" UserDataComponentName="Storico_DatiFaseTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.Storico_DatiFase" 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].[Storico_DatiFase] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataScad = 1 AND [DataScad] IS NULL) OR ([DataScad] = @Original_DataScad)) AND ((@IsNull_ScadFixed = 1 AND [ScadFixed] IS NULL) OR ([ScadFixed] = @Original_ScadFixed)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataScad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataScad" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataScad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScad" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScadFixed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScadFixed" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ScadFixed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScadFixed" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Storico_DatiFase] ([DataEv], [idxFase], [DataScad], [ScadFixed], [Note], [modificatoDa]) VALUES (@DataEv, @idxFase, @DataScad, @ScadFixed, @Note, @modificatoDa);
|
|
SELECT idxEv, DataEv, idxFase, DataScad, ScadFixed, Note, modificatoDa FROM Storico_DatiFase WHERE (idxEv = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataScad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScad" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ScadFixed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScadFixed" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxEv, DataEv, idxFase, DataScad, ScadFixed, Note, modificatoDa FROM dbo.Storico_DatiFase</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Storico_DatiFase] SET [DataEv] = @DataEv, [idxFase] = @idxFase, [DataScad] = @DataScad, [ScadFixed] = @ScadFixed, [Note] = @Note, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataScad = 1 AND [DataScad] IS NULL) OR ([DataScad] = @Original_DataScad)) AND ((@IsNull_ScadFixed = 1 AND [ScadFixed] IS NULL) OR ([ScadFixed] = @Original_ScadFixed)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)));
|
|
SELECT idxEv, DataEv, idxFase, DataScad, ScadFixed, Note, modificatoDa FROM Storico_DatiFase WHERE (idxEv = @idxEv)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataScad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScad" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ScadFixed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScadFixed" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataScad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataScad" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataScad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataScad" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScadFixed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScadFixed" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ScadFixed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScadFixed" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxEv" ColumnName="idxEv" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxEv" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxEv" DataSetColumn="idxEv" />
|
|
<Mapping SourceColumn="DataEv" DataSetColumn="DataEv" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="DataScad" DataSetColumn="DataScad" />
|
|
<Mapping SourceColumn="ScadFixed" DataSetColumn="ScadFixed" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="modificatoDa" DataSetColumn="modificatoDa" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_SDF_getByIdxFase" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFase" GetMethodModifier="Public" GetMethodName="getByIdxFase" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFase" UserSourceName="getByIdxFase">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_SDF_getByIdxFase</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="@idxFase" 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="Storico_BdgtRisorseFasiTableAdapter" GeneratorDataComponentClassName="Storico_BdgtRisorseFasiTableAdapter" Name="Storico_BdgtRisorseFasi" UserDataComponentName="Storico_BdgtRisorseFasiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.Storico_BdgtRisorseFasi" 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].[Storico_BdgtRisorseFasi] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_CodTipoRisorsa = 1 AND [CodTipoRisorsa] IS NULL) OR ([CodTipoRisorsa] = @Original_CodTipoRisorsa)) AND ((@IsNull_OreBdgt = 1 AND [OreBdgt] IS NULL) OR ([OreBdgt] = @Original_OreBdgt)) AND ((@IsNull_CostoBdgt = 1 AND [CostoBdgt] IS NULL) OR ([CostoBdgt] = @Original_CostoBdgt)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodTipoRisorsa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodTipoRisorsa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoRisorsa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoRisorsa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OreBdgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OreBdgt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OreBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OreBdgt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CostoBdgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CostoBdgt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostoBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostoBdgt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRif" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Storico_BdgtRisorseFasi] ([DataEv], [idxFase], [CodTipoRisorsa], [OreBdgt], [CostoBdgt], [DataRif], [modificatoDa]) VALUES (@DataEv, @idxFase, @CodTipoRisorsa, @OreBdgt, @CostoBdgt, @DataRif, @modificatoDa);
|
|
SELECT idxEv, DataEv, idxFase, CodTipoRisorsa, OreBdgt, CostoBdgt, DataRif, modificatoDa FROM Storico_BdgtRisorseFasi WHERE (idxEv = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoRisorsa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoRisorsa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OreBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OreBdgt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostoBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostoBdgt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxEv, DataEv, idxFase, CodTipoRisorsa, OreBdgt, CostoBdgt, DataRif, modificatoDa FROM dbo.Storico_BdgtRisorseFasi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Storico_BdgtRisorseFasi] SET [DataEv] = @DataEv, [idxFase] = @idxFase, [CodTipoRisorsa] = @CodTipoRisorsa, [OreBdgt] = @OreBdgt, [CostoBdgt] = @CostoBdgt, [DataRif] = @DataRif, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_CodTipoRisorsa = 1 AND [CodTipoRisorsa] IS NULL) OR ([CodTipoRisorsa] = @Original_CodTipoRisorsa)) AND ((@IsNull_OreBdgt = 1 AND [OreBdgt] IS NULL) OR ([OreBdgt] = @Original_OreBdgt)) AND ((@IsNull_CostoBdgt = 1 AND [CostoBdgt] IS NULL) OR ([CostoBdgt] = @Original_CostoBdgt)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa)));
|
|
SELECT idxEv, DataEv, idxFase, CodTipoRisorsa, OreBdgt, CostoBdgt, DataRif, modificatoDa FROM Storico_BdgtRisorseFasi WHERE (idxEv = @idxEv)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoRisorsa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoRisorsa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OreBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OreBdgt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostoBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostoBdgt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEv" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEv" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodTipoRisorsa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodTipoRisorsa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoRisorsa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoRisorsa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OreBdgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OreBdgt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OreBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OreBdgt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CostoBdgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CostoBdgt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostoBdgt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostoBdgt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRif" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRif" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modificatoDa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_modificatoDa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="modificatoDa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxEv" ColumnName="idxEv" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxEv" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxEv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxEv" DataSetColumn="idxEv" />
|
|
<Mapping SourceColumn="DataEv" DataSetColumn="DataEv" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="CodTipoRisorsa" DataSetColumn="CodTipoRisorsa" />
|
|
<Mapping SourceColumn="OreBdgt" DataSetColumn="OreBdgt" />
|
|
<Mapping SourceColumn="CostoBdgt" DataSetColumn="CostoBdgt" />
|
|
<Mapping SourceColumn="DataRif" DataSetColumn="DataRif" />
|
|
<Mapping SourceColumn="modificatoDa" DataSetColumn="modificatoDa" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_PROJConnectionString (Settings)" DbObjectName="ETS_PROJ.dbo.stp_SBRF_getByIdxFase" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFase" GetMethodModifier="Public" GetMethodName="getByIdxFase" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFase" UserSourceName="getByIdxFase">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_SBRF_getByIdxFase</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="@idxFase" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_utilsProjEts" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_utilsProjEts" msprop:Generator_UserDSName="DS_utilsProjEts">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="v_selClienti" msprop:Generator_TableClassName="v_selClientiDataTable" msprop:Generator_TableVarName="tablev_selClienti" msprop:Generator_RowChangedName="v_selClientiRowChanged" msprop:Generator_TablePropName="v_selClienti" msprop:Generator_RowDeletingName="v_selClientiRowDeleting" msprop:Generator_RowChangingName="v_selClientiRowChanging" msprop:Generator_RowEvHandlerName="v_selClientiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selClientiRowDeleted" msprop:Generator_RowClassName="v_selClientiRow" msprop:Generator_UserTableName="v_selClienti" msprop:Generator_RowEvArgName="v_selClientiRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selProgetti" msprop:Generator_TableClassName="v_selProgettiDataTable" msprop:Generator_TableVarName="tablev_selProgetti" msprop:Generator_RowChangedName="v_selProgettiRowChanged" msprop:Generator_TablePropName="v_selProgetti" msprop:Generator_RowDeletingName="v_selProgettiRowDeleting" msprop:Generator_RowChangingName="v_selProgettiRowChanging" msprop:Generator_RowEvHandlerName="v_selProgettiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selProgettiRowDeleted" msprop:Generator_RowClassName="v_selProgettiRow" msprop:Generator_UserTableName="v_selProgetti" msprop:Generator_RowEvArgName="v_selProgettiRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="303" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio" type="xs:int" />
|
|
<xs:element name="Attivo" msprop:Generator_ColumnVarNameInTable="columnAttivo" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_UserColumnName="Attivo" type="xs:boolean" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCommesse" msprop:Generator_TableClassName="v_selCommesseDataTable" msprop:Generator_TableVarName="tablev_selCommesse" msprop:Generator_TablePropName="v_selCommesse" msprop:Generator_RowDeletingName="v_selCommesseRowDeleting" msprop:Generator_RowChangingName="v_selCommesseRowChanging" msprop:Generator_RowEvHandlerName="v_selCommesseRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selCommesseRowDeleted" msprop:Generator_UserTableName="v_selCommesse" msprop:Generator_RowChangedName="v_selCommesseRowChanged" msprop:Generator_RowEvArgName="v_selCommesseRowChangeEvent" msprop:Generator_RowClassName="v_selCommesseRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCC" msprop:Generator_TableClassName="v_selCCDataTable" msprop:Generator_TableVarName="tablev_selCC" msprop:Generator_RowChangedName="v_selCCRowChanged" msprop:Generator_TablePropName="v_selCC" msprop:Generator_RowDeletingName="v_selCCRowDeleting" msprop:Generator_RowChangingName="v_selCCRowChanging" msprop:Generator_RowEvHandlerName="v_selCCRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selCCRowDeleted" msprop:Generator_RowClassName="v_selCCRow" msprop:Generator_UserTableName="v_selCC" msprop:Generator_RowEvArgName="v_selCCRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="201" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="value" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="201" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCC_all" msprop:Generator_TableClassName="v_selCC_allDataTable" msprop:Generator_TableVarName="tablev_selCC_all" msprop:Generator_RowChangedName="v_selCC_allRowChanged" msprop:Generator_TablePropName="v_selCC_all" msprop:Generator_RowDeletingName="v_selCC_allRowDeleting" msprop:Generator_RowChangingName="v_selCC_allRowChanging" msprop:Generator_RowEvHandlerName="v_selCC_allRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selCC_allRowDeleted" msprop:Generator_RowClassName="v_selCC_allRow" msprop:Generator_UserTableName="v_selCC_all" msprop:Generator_RowEvArgName="v_selCC_allRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selWeek" msprop:Generator_TableClassName="v_selWeekDataTable" msprop:Generator_TableVarName="tablev_selWeek" msprop:Generator_TablePropName="v_selWeek" msprop:Generator_RowDeletingName="v_selWeekRowDeleting" msprop:Generator_RowChangingName="v_selWeekRowChanging" msprop:Generator_RowEvHandlerName="v_selWeekRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selWeekRowDeleted" msprop:Generator_UserTableName="v_selWeek" msprop:Generator_RowChangedName="v_selWeekRowChanged" msprop:Generator_RowEvArgName="v_selWeekRowChangeEvent" msprop:Generator_RowClassName="v_selWeekRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="n" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnn" msprop:Generator_ColumnPropNameInRow="n" msprop:Generator_ColumnPropNameInTable="nColumn" msprop:Generator_UserColumnName="n" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selYear" msprop:Generator_TableClassName="v_selYearDataTable" msprop:Generator_TableVarName="tablev_selYear" msprop:Generator_TablePropName="v_selYear" msprop:Generator_RowDeletingName="v_selYearRowDeleting" msprop:Generator_RowChangingName="v_selYearRowChanging" msprop:Generator_RowEvHandlerName="v_selYearRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selYearRowDeleted" msprop:Generator_UserTableName="v_selYear" msprop:Generator_RowChangedName="v_selYearRowChanged" msprop:Generator_RowEvArgName="v_selYearRowChangeEvent" msprop:Generator_RowClassName="v_selYearRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="n" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnn" msprop:Generator_ColumnPropNameInRow="n" msprop:Generator_ColumnPropNameInTable="nColumn" msprop:Generator_UserColumnName="n" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selFornitoriCla" msprop:Generator_TableClassName="v_selFornitoriClaDataTable" msprop:Generator_TableVarName="tablev_selFornitoriCla" msprop:Generator_RowChangedName="v_selFornitoriClaRowChanged" msprop:Generator_TablePropName="v_selFornitoriCla" msprop:Generator_RowDeletingName="v_selFornitoriClaRowDeleting" msprop:Generator_RowChangingName="v_selFornitoriClaRowChanging" msprop:Generator_RowEvHandlerName="v_selFornitoriClaRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selFornitoriClaRowDeleted" msprop:Generator_RowClassName="v_selFornitoriClaRow" msprop:Generator_UserTableName="v_selFornitoriCla" msprop:Generator_RowEvArgName="v_selFornitoriClaRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="200" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_FattureETS" msprop:Generator_TableClassName="v_FattureETSDataTable" msprop:Generator_TableVarName="tablev_FattureETS" msprop:Generator_TablePropName="v_FattureETS" msprop:Generator_RowDeletingName="v_FattureETSRowDeleting" msprop:Generator_RowChangingName="v_FattureETSRowChanging" msprop:Generator_RowEvHandlerName="v_FattureETSRowChangeEventHandler" msprop:Generator_RowDeletedName="v_FattureETSRowDeleted" msprop:Generator_UserTableName="v_FattureETS" msprop:Generator_RowChangedName="v_FattureETSRowChanged" msprop:Generator_RowEvArgName="v_FattureETSRowChangeEvent" msprop:Generator_RowClassName="v_FattureETSRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="NumeroCommessa" msprop:Generator_ColumnVarNameInTable="columnNumeroCommessa" msprop:Generator_ColumnPropNameInRow="NumeroCommessa" msprop:Generator_ColumnPropNameInTable="NumeroCommessaColumn" msprop:Generator_UserColumnName="NumeroCommessa" type="xs:int" minOccurs="0" />
|
|
<xs:element name="AnnoCommessa" msprop:Generator_ColumnVarNameInTable="columnAnnoCommessa" msprop:Generator_ColumnPropNameInRow="AnnoCommessa" msprop:Generator_ColumnPropNameInTable="AnnoCommessaColumn" msprop:Generator_UserColumnName="AnnoCommessa" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Commessa" msprop:Generator_ColumnVarNameInTable="columnCommessa" msprop:Generator_ColumnPropNameInRow="Commessa" msprop:Generator_ColumnPropNameInTable="CommessaColumn" msprop:Generator_UserColumnName="Commessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Emitt" msprop:Generator_ColumnVarNameInTable="columnEmitt" msprop:Generator_ColumnPropNameInRow="Emitt" msprop:Generator_ColumnPropNameInTable="EmittColumn" msprop:Generator_UserColumnName="Emitt">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Dest" msprop:Generator_ColumnVarNameInTable="columnDest" msprop:Generator_ColumnPropNameInRow="Dest" msprop:Generator_ColumnPropNameInTable="DestColumn" msprop:Generator_UserColumnName="Dest">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="200" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tipologia" msprop:Generator_ColumnVarNameInTable="columnTipologia" msprop:Generator_ColumnPropNameInRow="Tipologia" msprop:Generator_ColumnPropNameInTable="TipologiaColumn" msprop:Generator_UserColumnName="Tipologia" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NrFatt" msprop:Generator_ColumnVarNameInTable="columnNrFatt" msprop:Generator_ColumnPropNameInRow="NrFatt" msprop:Generator_ColumnPropNameInTable="NrFattColumn" msprop:Generator_UserColumnName="NrFatt" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataFatt" msprop:Generator_ColumnVarNameInTable="columnDataFatt" msprop:Generator_ColumnPropNameInRow="DataFatt" msprop:Generator_ColumnPropNameInTable="DataFattColumn" msprop:Generator_UserColumnName="DataFatt" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Importo" msprop:Generator_ColumnVarNameInTable="columnImporto" msprop:Generator_ColumnPropNameInRow="Importo" msprop:Generator_ColumnPropNameInTable="ImportoColumn" msprop:Generator_UserColumnName="Importo" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Storico_DatiCommessa" msprop:Generator_TableClassName="Storico_DatiCommessaDataTable" msprop:Generator_TableVarName="tableStorico_DatiCommessa" msprop:Generator_RowChangedName="Storico_DatiCommessaRowChanged" msprop:Generator_TablePropName="Storico_DatiCommessa" msprop:Generator_RowDeletingName="Storico_DatiCommessaRowDeleting" msprop:Generator_RowChangingName="Storico_DatiCommessaRowChanging" msprop:Generator_RowEvHandlerName="Storico_DatiCommessaRowChangeEventHandler" msprop:Generator_RowDeletedName="Storico_DatiCommessaRowDeleted" msprop:Generator_RowClassName="Storico_DatiCommessaRow" msprop:Generator_UserTableName="Storico_DatiCommessa" msprop:Generator_RowEvArgName="Storico_DatiCommessaRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxEv" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxEv" msprop:Generator_ColumnPropNameInRow="idxEv" msprop:Generator_ColumnPropNameInTable="idxEvColumn" msprop:Generator_UserColumnName="idxEv" type="xs:int" />
|
|
<xs:element name="DataEv" msprop:Generator_ColumnVarNameInTable="columnDataEv" msprop:Generator_ColumnPropNameInRow="DataEv" msprop:Generator_ColumnPropNameInTable="DataEvColumn" msprop:Generator_UserColumnName="DataEv" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_UserColumnName="idxFase" type="xs:int" minOccurs="0" />
|
|
<xs:element name="AnnoCommessa" msprop:Generator_ColumnVarNameInTable="columnAnnoCommessa" msprop:Generator_ColumnPropNameInRow="AnnoCommessa" msprop:Generator_ColumnPropNameInTable="AnnoCommessaColumn" msprop:Generator_UserColumnName="AnnoCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumeroCommessa" msprop:Generator_ColumnVarNameInTable="columnNumeroCommessa" msprop:Generator_ColumnPropNameInRow="NumeroCommessa" msprop:Generator_ColumnPropNameInTable="NumeroCommessaColumn" msprop:Generator_UserColumnName="NumeroCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nickname" msprop:Generator_ColumnVarNameInTable="columnnickname" msprop:Generator_ColumnPropNameInRow="nickname" msprop:Generator_ColumnPropNameInTable="nicknameColumn" msprop:Generator_UserColumnName="nickname" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CheckOk" msprop:Generator_ColumnVarNameInTable="columnCheckOk" msprop:Generator_ColumnPropNameInRow="CheckOk" msprop:Generator_ColumnPropNameInTable="CheckOkColumn" msprop:Generator_UserColumnName="CheckOk" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="CapoCommessa" msprop:Generator_ColumnVarNameInTable="columnCapoCommessa" msprop:Generator_ColumnPropNameInRow="CapoCommessa" msprop:Generator_ColumnPropNameInTable="CapoCommessaColumn" msprop:Generator_UserColumnName="CapoCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SQC" msprop:Generator_ColumnVarNameInTable="columnSQC" msprop:Generator_ColumnPropNameInRow="SQC" msprop:Generator_ColumnPropNameInTable="SQCColumn" msprop:Generator_UserColumnName="SQC" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="Pubblico" msprop:Generator_ColumnVarNameInTable="columnPubblico" msprop:Generator_ColumnPropNameInRow="Pubblico" msprop:Generator_ColumnPropNameInTable="PubblicoColumn" msprop:Generator_UserColumnName="Pubblico" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="EnteProcuratore" msprop:Generator_ColumnVarNameInTable="columnEnteProcuratore" msprop:Generator_ColumnPropNameInRow="EnteProcuratore" msprop:Generator_ColumnPropNameInTable="EnteProcuratoreColumn" msprop:Generator_UserColumnName="EnteProcuratore" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Importo" msprop:Generator_ColumnVarNameInTable="columnImporto" msprop:Generator_ColumnPropNameInRow="Importo" msprop:Generator_ColumnPropNameInTable="ImportoColumn" msprop:Generator_UserColumnName="Importo" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="DataApertura" msprop:Generator_ColumnVarNameInTable="columnDataApertura" msprop:Generator_ColumnPropNameInRow="DataApertura" msprop:Generator_ColumnPropNameInTable="DataAperturaColumn" msprop:Generator_UserColumnName="DataApertura" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataScadenza" msprop:Generator_ColumnVarNameInTable="columnDataScadenza" msprop:Generator_ColumnPropNameInRow="DataScadenza" msprop:Generator_ColumnPropNameInTable="DataScadenzaColumn" msprop:Generator_UserColumnName="DataScadenza" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="rifOfferta" msprop:Generator_ColumnVarNameInTable="columnrifOfferta" msprop:Generator_ColumnPropNameInRow="rifOfferta" msprop:Generator_ColumnPropNameInTable="rifOffertaColumn" msprop:Generator_UserColumnName="rifOfferta" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="urlOfferta" msprop:Generator_ColumnVarNameInTable="columnurlOfferta" msprop:Generator_ColumnPropNameInRow="urlOfferta" msprop:Generator_ColumnPropNameInTable="urlOffertaColumn" msprop:Generator_UserColumnName="urlOfferta" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="rifOrdine" msprop:Generator_ColumnVarNameInTable="columnrifOrdine" msprop:Generator_ColumnPropNameInRow="rifOrdine" msprop:Generator_ColumnPropNameInTable="rifOrdineColumn" msprop:Generator_UserColumnName="rifOrdine" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="urlOrdine" msprop:Generator_ColumnVarNameInTable="columnurlOrdine" msprop:Generator_ColumnPropNameInRow="urlOrdine" msprop:Generator_ColumnPropNameInTable="urlOrdineColumn" msprop:Generator_UserColumnName="urlOrdine" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Indirizzo" msprop:Generator_ColumnVarNameInTable="columnIndirizzo" msprop:Generator_ColumnPropNameInRow="Indirizzo" msprop:Generator_ColumnPropNameInTable="IndirizzoColumn" msprop:Generator_UserColumnName="Indirizzo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NomeComm" msprop:Generator_ColumnVarNameInTable="columnNomeComm" msprop:Generator_ColumnPropNameInRow="NomeComm" msprop:Generator_ColumnPropNameInTable="NomeCommColumn" msprop:Generator_UserColumnName="NomeComm" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ImportoIntegr" msprop:Generator_ColumnVarNameInTable="columnImportoIntegr" msprop:Generator_ColumnPropNameInRow="ImportoIntegr" msprop:Generator_ColumnPropNameInTable="ImportoIntegrColumn" msprop:Generator_UserColumnName="ImportoIntegr" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="ImportoFornExt" msprop:Generator_ColumnVarNameInTable="columnImportoFornExt" msprop:Generator_ColumnPropNameInRow="ImportoFornExt" msprop:Generator_ColumnPropNameInTable="ImportoFornExtColumn" msprop:Generator_UserColumnName="ImportoFornExt" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="BCWS" msprop:Generator_ColumnVarNameInTable="columnBCWS" msprop:Generator_ColumnPropNameInRow="BCWS" msprop:Generator_ColumnPropNameInTable="BCWSColumn" msprop:Generator_UserColumnName="BCWS" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="BCWSFasi" msprop:Generator_ColumnVarNameInTable="columnBCWSFasi" msprop:Generator_ColumnPropNameInRow="BCWSFasi" msprop:Generator_ColumnPropNameInTable="BCWSFasiColumn" msprop:Generator_UserColumnName="BCWSFasi" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="modificatoDa" msprop:Generator_ColumnVarNameInTable="columnmodificatoDa" msprop:Generator_ColumnPropNameInRow="modificatoDa" msprop:Generator_ColumnPropNameInTable="modificatoDaColumn" msprop:Generator_UserColumnName="modificatoDa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Storico_DatiCommForn" msprop:Generator_TableClassName="Storico_DatiCommFornDataTable" msprop:Generator_TableVarName="tableStorico_DatiCommForn" msprop:Generator_RowChangedName="Storico_DatiCommFornRowChanged" msprop:Generator_TablePropName="Storico_DatiCommForn" msprop:Generator_RowDeletingName="Storico_DatiCommFornRowDeleting" msprop:Generator_RowChangingName="Storico_DatiCommFornRowChanging" msprop:Generator_RowEvHandlerName="Storico_DatiCommFornRowChangeEventHandler" msprop:Generator_RowDeletedName="Storico_DatiCommFornRowDeleted" msprop:Generator_RowClassName="Storico_DatiCommFornRow" msprop:Generator_UserTableName="Storico_DatiCommForn" msprop:Generator_RowEvArgName="Storico_DatiCommFornRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxEv" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxEv" msprop:Generator_ColumnPropNameInRow="idxEv" msprop:Generator_ColumnPropNameInTable="idxEvColumn" msprop:Generator_UserColumnName="idxEv" type="xs:int" />
|
|
<xs:element name="DataEv" msprop:Generator_ColumnVarNameInTable="columnDataEv" msprop:Generator_ColumnPropNameInRow="DataEv" msprop:Generator_ColumnPropNameInTable="DataEvColumn" msprop:Generator_UserColumnName="DataEv" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="idxDCF" msprop:Generator_ColumnVarNameInTable="columnidxDCF" msprop:Generator_ColumnPropNameInRow="idxDCF" msprop:Generator_ColumnPropNameInTable="idxDCFColumn" msprop:Generator_UserColumnName="idxDCF" type="xs:int" minOccurs="0" />
|
|
<xs:element name="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_UserColumnName="idxFase" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fornitore" msprop:Generator_ColumnVarNameInTable="columnFornitore" msprop:Generator_ColumnPropNameInRow="Fornitore" msprop:Generator_ColumnPropNameInTable="FornitoreColumn" msprop:Generator_UserColumnName="Fornitore" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Referente" msprop:Generator_ColumnVarNameInTable="columnReferente" msprop:Generator_ColumnPropNameInRow="Referente" msprop:Generator_ColumnPropNameInTable="ReferenteColumn" msprop:Generator_UserColumnName="Referente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Importo" msprop:Generator_ColumnVarNameInTable="columnImporto" msprop:Generator_ColumnPropNameInRow="Importo" msprop:Generator_ColumnPropNameInTable="ImportoColumn" msprop:Generator_UserColumnName="Importo" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="rifOrdineForn" msprop:Generator_ColumnVarNameInTable="columnrifOrdineForn" msprop:Generator_ColumnPropNameInRow="rifOrdineForn" msprop:Generator_ColumnPropNameInTable="rifOrdineFornColumn" msprop:Generator_UserColumnName="rifOrdineForn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="urlOrdineForn" msprop:Generator_ColumnVarNameInTable="columnurlOrdineForn" msprop:Generator_ColumnPropNameInRow="urlOrdineForn" msprop:Generator_ColumnPropNameInTable="urlOrdineFornColumn" msprop:Generator_UserColumnName="urlOrdineForn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="modificatoDa" msprop:Generator_ColumnVarNameInTable="columnmodificatoDa" msprop:Generator_ColumnPropNameInRow="modificatoDa" msprop:Generator_ColumnPropNameInTable="modificatoDaColumn" msprop:Generator_UserColumnName="modificatoDa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Storico_DatiCommInteg" msprop:Generator_TableClassName="Storico_DatiCommIntegDataTable" msprop:Generator_TableVarName="tableStorico_DatiCommInteg" msprop:Generator_RowChangedName="Storico_DatiCommIntegRowChanged" msprop:Generator_TablePropName="Storico_DatiCommInteg" msprop:Generator_RowDeletingName="Storico_DatiCommIntegRowDeleting" msprop:Generator_RowChangingName="Storico_DatiCommIntegRowChanging" msprop:Generator_RowEvHandlerName="Storico_DatiCommIntegRowChangeEventHandler" msprop:Generator_RowDeletedName="Storico_DatiCommIntegRowDeleted" msprop:Generator_RowClassName="Storico_DatiCommIntegRow" msprop:Generator_UserTableName="Storico_DatiCommInteg" msprop:Generator_RowEvArgName="Storico_DatiCommIntegRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxEv" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxEv" msprop:Generator_ColumnPropNameInRow="idxEv" msprop:Generator_ColumnPropNameInTable="idxEvColumn" msprop:Generator_UserColumnName="idxEv" type="xs:int" />
|
|
<xs:element name="DataEv" msprop:Generator_ColumnVarNameInTable="columnDataEv" msprop:Generator_ColumnPropNameInRow="DataEv" msprop:Generator_ColumnPropNameInTable="DataEvColumn" msprop:Generator_UserColumnName="DataEv" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="idxDCI" msprop:Generator_ColumnVarNameInTable="columnidxDCI" msprop:Generator_ColumnPropNameInRow="idxDCI" msprop:Generator_ColumnPropNameInTable="idxDCIColumn" msprop:Generator_UserColumnName="idxDCI" type="xs:int" minOccurs="0" />
|
|
<xs:element name="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_UserColumnName="idxFase" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DataRif" msprop:Generator_ColumnVarNameInTable="columnDataRif" msprop:Generator_ColumnPropNameInRow="DataRif" msprop:Generator_ColumnPropNameInTable="DataRifColumn" msprop:Generator_UserColumnName="DataRif" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Importo" msprop:Generator_ColumnVarNameInTable="columnImporto" msprop:Generator_ColumnPropNameInRow="Importo" msprop:Generator_ColumnPropNameInTable="ImportoColumn" msprop:Generator_UserColumnName="Importo" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="rifOfferta" msprop:Generator_ColumnVarNameInTable="columnrifOfferta" msprop:Generator_ColumnPropNameInRow="rifOfferta" msprop:Generator_ColumnPropNameInTable="rifOffertaColumn" msprop:Generator_UserColumnName="rifOfferta" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="urlOfferta" msprop:Generator_ColumnVarNameInTable="columnurlOfferta" msprop:Generator_ColumnPropNameInRow="urlOfferta" msprop:Generator_ColumnPropNameInTable="urlOffertaColumn" msprop:Generator_UserColumnName="urlOfferta" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="rifOrdine" msprop:Generator_ColumnVarNameInTable="columnrifOrdine" msprop:Generator_ColumnPropNameInRow="rifOrdine" msprop:Generator_ColumnPropNameInTable="rifOrdineColumn" msprop:Generator_UserColumnName="rifOrdine" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="urlOrdine" msprop:Generator_ColumnVarNameInTable="columnurlOrdine" msprop:Generator_ColumnPropNameInRow="urlOrdine" msprop:Generator_ColumnPropNameInTable="urlOrdineColumn" msprop:Generator_UserColumnName="urlOrdine" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="modificatoDa" msprop:Generator_ColumnVarNameInTable="columnmodificatoDa" msprop:Generator_ColumnPropNameInRow="modificatoDa" msprop:Generator_ColumnPropNameInTable="modificatoDaColumn" msprop:Generator_UserColumnName="modificatoDa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Storico_DatiFase" msprop:Generator_TableClassName="Storico_DatiFaseDataTable" msprop:Generator_TableVarName="tableStorico_DatiFase" msprop:Generator_RowChangedName="Storico_DatiFaseRowChanged" msprop:Generator_TablePropName="Storico_DatiFase" msprop:Generator_RowDeletingName="Storico_DatiFaseRowDeleting" msprop:Generator_RowChangingName="Storico_DatiFaseRowChanging" msprop:Generator_RowEvHandlerName="Storico_DatiFaseRowChangeEventHandler" msprop:Generator_RowDeletedName="Storico_DatiFaseRowDeleted" msprop:Generator_RowClassName="Storico_DatiFaseRow" msprop:Generator_UserTableName="Storico_DatiFase" msprop:Generator_RowEvArgName="Storico_DatiFaseRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxEv" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxEv" msprop:Generator_ColumnPropNameInRow="idxEv" msprop:Generator_ColumnPropNameInTable="idxEvColumn" msprop:Generator_UserColumnName="idxEv" type="xs:int" />
|
|
<xs:element name="DataEv" msprop:Generator_ColumnVarNameInTable="columnDataEv" msprop:Generator_ColumnPropNameInRow="DataEv" msprop:Generator_ColumnPropNameInTable="DataEvColumn" msprop:Generator_UserColumnName="DataEv" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_UserColumnName="idxFase" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DataScad" msprop:Generator_ColumnVarNameInTable="columnDataScad" msprop:Generator_ColumnPropNameInRow="DataScad" msprop:Generator_ColumnPropNameInTable="DataScadColumn" msprop:Generator_UserColumnName="DataScad" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="ScadFixed" msprop:Generator_ColumnVarNameInTable="columnScadFixed" msprop:Generator_ColumnPropNameInRow="ScadFixed" msprop:Generator_ColumnPropNameInTable="ScadFixedColumn" msprop:Generator_UserColumnName="ScadFixed" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="modificatoDa" msprop:Generator_ColumnVarNameInTable="columnmodificatoDa" msprop:Generator_ColumnPropNameInRow="modificatoDa" msprop:Generator_ColumnPropNameInTable="modificatoDaColumn" msprop:Generator_UserColumnName="modificatoDa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Storico_BdgtRisorseFasi" msprop:Generator_TableClassName="Storico_BdgtRisorseFasiDataTable" msprop:Generator_TableVarName="tableStorico_BdgtRisorseFasi" msprop:Generator_RowChangedName="Storico_BdgtRisorseFasiRowChanged" msprop:Generator_TablePropName="Storico_BdgtRisorseFasi" msprop:Generator_RowDeletingName="Storico_BdgtRisorseFasiRowDeleting" msprop:Generator_RowChangingName="Storico_BdgtRisorseFasiRowChanging" msprop:Generator_RowEvHandlerName="Storico_BdgtRisorseFasiRowChangeEventHandler" msprop:Generator_RowDeletedName="Storico_BdgtRisorseFasiRowDeleted" msprop:Generator_RowClassName="Storico_BdgtRisorseFasiRow" msprop:Generator_UserTableName="Storico_BdgtRisorseFasi" msprop:Generator_RowEvArgName="Storico_BdgtRisorseFasiRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxEv" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxEv" msprop:Generator_ColumnPropNameInRow="idxEv" msprop:Generator_ColumnPropNameInTable="idxEvColumn" msprop:Generator_UserColumnName="idxEv" type="xs:int" />
|
|
<xs:element name="DataEv" msprop:Generator_ColumnVarNameInTable="columnDataEv" msprop:Generator_ColumnPropNameInRow="DataEv" msprop:Generator_ColumnPropNameInTable="DataEvColumn" msprop:Generator_UserColumnName="DataEv" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_UserColumnName="idxFase" type="xs:int" minOccurs="0" />
|
|
<xs:element name="CodTipoRisorsa" msprop:Generator_ColumnVarNameInTable="columnCodTipoRisorsa" msprop:Generator_ColumnPropNameInRow="CodTipoRisorsa" msprop:Generator_ColumnPropNameInTable="CodTipoRisorsaColumn" msprop:Generator_UserColumnName="CodTipoRisorsa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OreBdgt" msprop:Generator_ColumnVarNameInTable="columnOreBdgt" msprop:Generator_ColumnPropNameInRow="OreBdgt" msprop:Generator_ColumnPropNameInTable="OreBdgtColumn" msprop:Generator_UserColumnName="OreBdgt" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CostoBdgt" msprop:Generator_ColumnVarNameInTable="columnCostoBdgt" msprop:Generator_ColumnPropNameInRow="CostoBdgt" msprop:Generator_ColumnPropNameInTable="CostoBdgtColumn" msprop:Generator_UserColumnName="CostoBdgt" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="DataRif" msprop:Generator_ColumnVarNameInTable="columnDataRif" msprop:Generator_ColumnPropNameInRow="DataRif" msprop:Generator_ColumnPropNameInTable="DataRifColumn" msprop:Generator_UserColumnName="DataRif" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="modificatoDa" msprop:Generator_ColumnVarNameInTable="columnmodificatoDa" msprop:Generator_ColumnPropNameInRow="modificatoDa" msprop:Generator_ColumnPropNameInTable="modificatoDaColumn" msprop:Generator_UserColumnName="modificatoDa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selClienti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selProgetti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selProgetti" />
|
|
<xs:field xpath="mstns:value" />
|
|
<xs:field xpath="mstns:conditio" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selCommesse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selCommesse" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selWeek_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selWeek" />
|
|
<xs:field xpath="mstns:n" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selFornitoriCla_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selFornitoriCla" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="Storico_DatiCommessa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Storico_DatiCommessa" />
|
|
<xs:field xpath="mstns:idxEv" />
|
|
</xs:unique>
|
|
<xs:unique name="Storico_DatiCommForn_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Storico_DatiCommForn" />
|
|
<xs:field xpath="mstns:idxEv" />
|
|
</xs:unique>
|
|
<xs:unique name="Storico_DatiCommInteg_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Storico_DatiCommInteg" />
|
|
<xs:field xpath="mstns:idxEv" />
|
|
</xs:unique>
|
|
<xs:unique name="Storico_DatiFase_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Storico_DatiFase" />
|
|
<xs:field xpath="mstns:idxEv" />
|
|
</xs:unique>
|
|
<xs:unique name="Storico_BdgtRisorseFasi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Storico_BdgtRisorseFasi" />
|
|
<xs:field xpath="mstns:idxEv" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |