Samuele E. Locatelli
2333 lines
288 KiB
XML
2333 lines
288 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Applicazione" targetNamespace="http://tempuri.org/DS_Applicazione.xsd" xmlns:mstns="http://tempuri.org/DS_Applicazione.xsd" xmlns="http://tempuri.org/DS_Applicazione.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="WebSCRConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="WebSCRConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WebSCR_data.Properties.Settings.GlobalReference.Default.WebSCRConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagSquadreTableAdapter" GeneratorDataComponentClassName="AnagSquadreTableAdapter" Name="AnagSquadre" UserDataComponentName="AnagSquadreTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.AnagSquadre" 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].[AnagSquadre] WHERE (([CodSquadra] = @Original_CodSquadra) AND ([DescrSquadra] = @Original_DescrSquadra) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform) AND ([Attiva] = @Original_Attiva) AND ([CssColor] = @Original_CssColor))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSquadra" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Attiva" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attiva" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CssColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CssColor" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagSquadre] ([CodSquadra], [DescrSquadra], [NumOp], [Elettrod], [Clima], [Inform], [Attiva], [CssColor]) VALUES (@CodSquadra, @DescrSquadra, @NumOp, @Elettrod, @Clima, @Inform, @Attiva, @CssColor);
|
|
SELECT CodSquadra, DescrSquadra, NumOp, Elettrod, Clima, Inform, Attiva, CssColor FROM AnagSquadre WHERE (CodSquadra = @CodSquadra)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSquadra" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Attiva" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attiva" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CssColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CssColor" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM dbo.AnagSquadre</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagSquadre] SET [CodSquadra] = @CodSquadra, [DescrSquadra] = @DescrSquadra, [NumOp] = @NumOp, [Elettrod] = @Elettrod, [Clima] = @Clima, [Inform] = @Inform, [Attiva] = @Attiva, [CssColor] = @CssColor WHERE (([CodSquadra] = @Original_CodSquadra) AND ([DescrSquadra] = @Original_DescrSquadra) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform) AND ([Attiva] = @Original_Attiva) AND ([CssColor] = @Original_CssColor));
|
|
SELECT CodSquadra, DescrSquadra, NumOp, Elettrod, Clima, Inform, Attiva, CssColor FROM AnagSquadre WHERE (CodSquadra = @CodSquadra)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSquadra" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Attiva" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attiva" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CssColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CssColor" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrSquadra" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Attiva" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attiva" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CssColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CssColor" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="DescrSquadra" DataSetColumn="DescrSquadra" />
|
|
<Mapping SourceColumn="NumOp" DataSetColumn="NumOp" />
|
|
<Mapping SourceColumn="Elettrod" DataSetColumn="Elettrod" />
|
|
<Mapping SourceColumn="Clima" DataSetColumn="Clima" />
|
|
<Mapping SourceColumn="Inform" DataSetColumn="Inform" />
|
|
<Mapping SourceColumn="Attiva" DataSetColumn="Attiva" />
|
|
<Mapping SourceColumn="CssColor" DataSetColumn="CssColor" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AS_DeleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AS_getAttive" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getAttive" GetMethodModifier="Public" GetMethodName="getAttive" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getAttive" UserSourceName="getAttive">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AS_getAttive</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AS_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AS_getByKey</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
|
|
<InsertCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AS_InsertQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescrSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AS_UpdateQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescrSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Attiva" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagZoneTableAdapter" GeneratorDataComponentClassName="AnagZoneTableAdapter" Name="AnagZone" UserDataComponentName="AnagZoneTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.AnagZone" 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 [AnagZone] WHERE (([idxZona] = @Original_idxZona) AND ([Cap] = @Original_Cap) AND ([Localita] = @Original_Localita) AND ([Prov] = @Original_Prov) AND ([Tempo] = @Original_Tempo) AND ([Zona] = @Original_Zona))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxZona" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxZona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tempo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tempo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Zona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [AnagZone] ([Cap], [Localita], [Prov], [Tempo], [Zona]) VALUES (@Cap, @Localita, @Prov, @Tempo, @Zona);
|
|
SELECT idxZona, Cap, Localita, Prov, Tempo, Zona FROM AnagZone WHERE (idxZona = SCOPE_IDENTITY()) ORDER BY Zona</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tempo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tempo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Zona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM AnagZone ORDER BY Zona</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [AnagZone] SET [Cap] = @Cap, [Localita] = @Localita, [Prov] = @Prov, [Tempo] = @Tempo, [Zona] = @Zona WHERE (([idxZona] = @Original_idxZona) AND ([Cap] = @Original_Cap) AND ([Localita] = @Original_Localita) AND ([Prov] = @Original_Prov) AND ([Tempo] = @Original_Tempo) AND ([Zona] = @Original_Zona));
|
|
SELECT idxZona, Cap, Localita, Prov, Tempo, Zona FROM AnagZone WHERE (idxZona = @idxZona) ORDER BY Zona</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tempo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tempo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Zona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxZona" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxZona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tempo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tempo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Zona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxZona" ColumnName="idxZona" DataSourceName="WebSCR.dbo.AnagZone" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxZona" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxZona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxZona" DataSetColumn="idxZona" />
|
|
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
|
|
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
|
|
<Mapping SourceColumn="Prov" DataSetColumn="Prov" />
|
|
<Mapping SourceColumn="Tempo" DataSetColumn="Tempo" />
|
|
<Mapping SourceColumn="Zona" DataSetColumn="Zona" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AZ_DeleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxZona" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
|
|
<InsertCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AZ_InsertQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Tempo" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AZ_UpdateQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Tempo" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxZona" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagTipoConsegneTableAdapter" GeneratorDataComponentClassName="AnagTipoConsegneTableAdapter" Name="AnagTipoConsegne" UserDataComponentName="AnagTipoConsegneTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.AnagTipoConsegne" 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].[AnagTipoConsegne] WHERE (([CodConsegna] = @Original_CodConsegna) AND ([DescrConsegna] = @Original_DescrConsegna) AND ([MinutiStd] = @Original_MinutiStd) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodConsegna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrConsegna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MinutiStd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinutiStd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagTipoConsegne] ([CodConsegna], [DescrConsegna], [MinutiStd], [NumOp], [Elettrod], [Clima], [Inform]) VALUES (@CodConsegna, @DescrConsegna, @MinutiStd, @NumOp, @Elettrod, @Clima, @Inform);
|
|
SELECT CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform FROM AnagTipoConsegne WHERE (CodConsegna = @CodConsegna)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodConsegna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrConsegna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MinutiStd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinutiStd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform FROM dbo.AnagTipoConsegne</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagTipoConsegne] SET [CodConsegna] = @CodConsegna, [DescrConsegna] = @DescrConsegna, [MinutiStd] = @MinutiStd, [NumOp] = @NumOp, [Elettrod] = @Elettrod, [Clima] = @Clima, [Inform] = @Inform WHERE (([CodConsegna] = @Original_CodConsegna) AND ([DescrConsegna] = @Original_DescrConsegna) AND ([MinutiStd] = @Original_MinutiStd) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform));
|
|
SELECT CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform FROM AnagTipoConsegne WHERE (CodConsegna = @CodConsegna)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodConsegna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrConsegna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MinutiStd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinutiStd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodConsegna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrConsegna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MinutiStd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinutiStd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Elettrod" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Elettrod" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Clima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Clima" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Inform" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Inform" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodConsegna" DataSetColumn="CodConsegna" />
|
|
<Mapping SourceColumn="DescrConsegna" DataSetColumn="DescrConsegna" />
|
|
<Mapping SourceColumn="MinutiStd" DataSetColumn="MinutiStd" />
|
|
<Mapping SourceColumn="NumOp" DataSetColumn="NumOp" />
|
|
<Mapping SourceColumn="Elettrod" DataSetColumn="Elettrod" />
|
|
<Mapping SourceColumn="Clima" DataSetColumn="Clima" />
|
|
<Mapping SourceColumn="Inform" DataSetColumn="Inform" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ATC_DeleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ATC_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ATC_getByKey</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
|
|
<InsertCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ATC_InsertQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescrConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MinutiStd" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ATC_UpdateQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescrConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MinutiStd" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Elettrod" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Clima" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Inform" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagClientiTableAdapter" GeneratorDataComponentClassName="AnagClientiTableAdapter" Name="AnagClienti" UserDataComponentName="AnagClientiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.AnagClienti" 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].[AnagClienti] WHERE (([CodCliente] = @Original_CodCliente) AND ([RagSoc] = @Original_RagSoc) AND ((@IsNull_CodFis = 1 AND [CodFis] IS NULL) OR ([CodFis] = @Original_CodFis)) AND ((@IsNull_Tel = 1 AND [Tel] IS NULL) OR ([Tel] = @Original_Tel)) AND ((@IsNull_Cell = 1 AND [Cell] IS NULL) OR ([Cell] = @Original_Cell)) AND ([EnableSMS] = @Original_EnableSMS) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Indir = 1 AND [Indir] IS NULL) OR ([Indir] = @Original_Indir)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Prov = 1 AND [Prov] IS NULL) OR ([Prov] = @Original_Prov)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RagSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagSoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodFis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodFis" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodFis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFis" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tel" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cell" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cell" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EnableSMS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EnableSMS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indir" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indir" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Indir" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indir" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Localita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prov" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prov" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagClienti] ([CodCliente], [RagSoc], [CodFis], [Tel], [Cell], [EnableSMS], [Email], [Indir], [Cap], [Localita], [Prov], [Note]) VALUES (@CodCliente, @RagSoc, @CodFis, @Tel, @Cell, @EnableSMS, @Email, @Indir, @Cap, @Localita, @Prov, @Note);
|
|
SELECT CodCliente, RagSoc, CodFis, Tel, Cell, EnableSMS, Email, Indir, Cap, Localita, Prov, Note FROM AnagClienti WHERE (CodCliente = @CodCliente)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RagSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagSoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodFis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFis" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tel" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EnableSMS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EnableSMS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Indir" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indir" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM dbo.AnagClienti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagClienti] SET [CodCliente] = @CodCliente, [RagSoc] = @RagSoc, [CodFis] = @CodFis, [Tel] = @Tel, [Cell] = @Cell, [EnableSMS] = @EnableSMS, [Email] = @Email, [Indir] = @Indir, [Cap] = @Cap, [Localita] = @Localita, [Prov] = @Prov, [Note] = @Note WHERE (([CodCliente] = @Original_CodCliente) AND ([RagSoc] = @Original_RagSoc) AND ((@IsNull_CodFis = 1 AND [CodFis] IS NULL) OR ([CodFis] = @Original_CodFis)) AND ((@IsNull_Tel = 1 AND [Tel] IS NULL) OR ([Tel] = @Original_Tel)) AND ((@IsNull_Cell = 1 AND [Cell] IS NULL) OR ([Cell] = @Original_Cell)) AND ([EnableSMS] = @Original_EnableSMS) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Indir = 1 AND [Indir] IS NULL) OR ([Indir] = @Original_Indir)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Prov = 1 AND [Prov] IS NULL) OR ([Prov] = @Original_Prov)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)));
|
|
SELECT CodCliente, RagSoc, CodFis, Tel, Cell, EnableSMS, Email, Indir, Cap, Localita, Prov, Note FROM AnagClienti WHERE (CodCliente = @CodCliente)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RagSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagSoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodFis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFis" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tel" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EnableSMS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EnableSMS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Indir" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indir" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" 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="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RagSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagSoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodFis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodFis" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodFis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodFis" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tel" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cell" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cell" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EnableSMS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EnableSMS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indir" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indir" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Indir" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Indir" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cap" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Localita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Localita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prov" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prov" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prov" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="CodFis" DataSetColumn="CodFis" />
|
|
<Mapping SourceColumn="Tel" DataSetColumn="Tel" />
|
|
<Mapping SourceColumn="Cell" DataSetColumn="Cell" />
|
|
<Mapping SourceColumn="Email" DataSetColumn="Email" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="RagSoc" DataSetColumn="RagSoc" />
|
|
<Mapping SourceColumn="EnableSMS" DataSetColumn="EnableSMS" />
|
|
<Mapping SourceColumn="Indir" DataSetColumn="Indir" />
|
|
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
|
|
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
|
|
<Mapping SourceColumn="Prov" DataSetColumn="Prov" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AC_GetByCod" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AC_GetByCod</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AC_GetLast" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getLast" GetMethodModifier="Public" GetMethodName="getLast" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getLast" UserSourceName="getLast">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AC_GetLast</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AC_upsert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="upsert" Modifier="Public" Name="upsert" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="upsert">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AC_upsert</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RagSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodFis" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Tel" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cell" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@EnableSMS" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Indir" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Localita" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Prov" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImpegniTableAdapter" GeneratorDataComponentClassName="ImpegniTableAdapter" Name="Impegni" UserDataComponentName="ImpegniTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_elencoImpegni" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM v_elencoImpegni</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxImpegno" DataSetColumn="IdxImpegno" />
|
|
<Mapping SourceColumn="DataOra" DataSetColumn="DataOra" />
|
|
<Mapping SourceColumn="TipoOrario" DataSetColumn="TipoOrario" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="RagSoc" DataSetColumn="RagSoc" />
|
|
<Mapping SourceColumn="CodFis" DataSetColumn="CodFis" />
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="DescrSquadra" DataSetColumn="DescrSquadra" />
|
|
<Mapping SourceColumn="Elettrod" DataSetColumn="Elettrod" />
|
|
<Mapping SourceColumn="Clima" DataSetColumn="Clima" />
|
|
<Mapping SourceColumn="Inform" DataSetColumn="Inform" />
|
|
<Mapping SourceColumn="Indir" DataSetColumn="Indir" />
|
|
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
|
|
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
|
|
<Mapping SourceColumn="Prov" DataSetColumn="Prov" />
|
|
<Mapping SourceColumn="idxZona" DataSetColumn="idxZona" />
|
|
<Mapping SourceColumn="MinTotCons" DataSetColumn="MinTotCons" />
|
|
<Mapping SourceColumn="MinViaggio" DataSetColumn="MinViaggio" />
|
|
<Mapping SourceColumn="FinePrev" DataSetColumn="FinePrev" />
|
|
<Mapping SourceColumn="NoteGen" DataSetColumn="NoteGen" />
|
|
<Mapping SourceColumn="RifOC" DataSetColumn="RifOC" />
|
|
<Mapping SourceColumn="UrlDoc" DataSetColumn="UrlDoc" />
|
|
<Mapping SourceColumn="NumOp" DataSetColumn="NumOp" />
|
|
<Mapping SourceColumn="RitUsato" DataSetColumn="RitUsato" />
|
|
<Mapping SourceColumn="Ascensore" DataSetColumn="Ascensore" />
|
|
<Mapping SourceColumn="PianoCons" DataSetColumn="PianoCons" />
|
|
<Mapping SourceColumn="UserMod" DataSetColumn="UserMod" />
|
|
<Mapping SourceColumn="DataMod" DataSetColumn="DataMod" />
|
|
<Mapping SourceColumn="STATO" DataSetColumn="STATO" />
|
|
<Mapping SourceColumn="InizioInt" DataSetColumn="InizioInt" />
|
|
<Mapping SourceColumn="FineInt" DataSetColumn="FineInt" />
|
|
<Mapping SourceColumn="NoteInt" DataSetColumn="NoteInt" />
|
|
<Mapping SourceColumn="LatInizio" DataSetColumn="LatInizio" />
|
|
<Mapping SourceColumn="LonInizio" DataSetColumn="LonInizio" />
|
|
<Mapping SourceColumn="LatFin" DataSetColumn="LatFine" />
|
|
<Mapping SourceColumn="LonFine" DataSetColumn="LonFine" />
|
|
<Mapping SourceColumn="LatFine" DataSetColumn="LatFine" />
|
|
<Mapping SourceColumn="DataCreaz" DataSetColumn="DataCreaz" />
|
|
<Mapping SourceColumn="DescrImp" DataSetColumn="DescrImp" />
|
|
<Mapping SourceColumn="IntAperto" DataSetColumn="IntAperto" />
|
|
<Mapping SourceColumn="DettImpegno" DataSetColumn="DettImpegno" />
|
|
<Mapping SourceColumn="Tel" DataSetColumn="Tel" />
|
|
<Mapping SourceColumn="AnnoOC" DataSetColumn="AnnoOC" />
|
|
<Mapping SourceColumn="DataOraComFrom" DataSetColumn="DataOraComFrom" />
|
|
<Mapping SourceColumn="DataOraComTo" DataSetColumn="DataOraComTo" />
|
|
<Mapping SourceColumn="MatrOp" DataSetColumn="MatrOp" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_getByCodCli" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCli" GetMethodModifier="Public" GetMethodName="getByCli" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCli" UserSourceName="getByCli">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_getByCodCli</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_getByKey</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_getBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_getBySearch</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataRif" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumGg" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RecAgeDd" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_getBySearchCronologico" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearchCron" GetMethodModifier="Public" GetMethodName="getBySearchCron" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearchCron" UserSourceName="getBySearchCron">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_getBySearchCronologico</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="@Stato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataCreaz" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_insertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_insertQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataOra" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MinTotCons" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RifOC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" 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="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LastMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_recFineInt" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="recFineInt" Modifier="Public" Name="recFineInt" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="recFineInt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_recFineInt</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="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@FineInt" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@LatFine" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@LonFine" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_recStartInt" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="recStartInt" Modifier="Public" Name="recStartInt" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="recStartInt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_recStartInt</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="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@InizioInt" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@LatInizio" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@LonInizio" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_updateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="updateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_updateQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TipoOrario" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RifOC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NoteGen" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UrlDoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RitUsato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Ascensore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PianoCons" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IntAperto" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataOra" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataOraComFrom" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataOraComTo" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_updNoteInt" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updNoteInt" Modifier="Public" Name="updNoteInt" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="updNoteInt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_updNoteInt</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="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NoteInt" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IntAperto" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LastMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Imp_updStart" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updStart" Modifier="Public" Name="updStart" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="updStart">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Imp_updStart</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="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataOraNew" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LastMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DispImpTotTableAdapter" GeneratorDataComponentClassName="DispImpTotTableAdapter" Name="DispImpTot" UserDataComponentName="DispImpTotTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_DispImpTot" 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 Data, NumOp, ScoreDisp, ScoreZona FROM v_DispImpTot</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
<Mapping SourceColumn="NumOp" DataSetColumn="NumOp" />
|
|
<Mapping SourceColumn="ScoreDisp" DataSetColumn="ScoreDisp" />
|
|
<Mapping SourceColumn="ScoreZona" DataSetColumn="ScoreZona" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DispImpTot_getByDataRange" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByDataRange" GetMethodModifier="Public" GetMethodName="getByDataRange" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByDataRange" UserSourceName="getByDataRange">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DispImpTot_getByDataRange</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataFrom" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumGG" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Zona" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DispImpSquadreTableAdapter" GeneratorDataComponentClassName="DispImpSquadreTableAdapter" Name="DispImpSquadre" UserDataComponentName="DispImpSquadreTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_DispImpSquadre" 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 Data, CodSquadra, OreDisp, OreImp FROM dbo.v_DispImpSquadre</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="OreDisp" DataSetColumn="OreDisp" />
|
|
<Mapping SourceColumn="OreImp" DataSetColumn="OreImp" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_ImpegniCalTableAdapter" GeneratorDataComponentClassName="v_ImpegniCalTableAdapter" Name="v_ImpegniCal" UserDataComponentName="v_ImpegniCalTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_ImpegniCal" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM dbo.v_ImpegniCal</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxImpegno" DataSetColumn="IdxImpegno" />
|
|
<Mapping SourceColumn="NomeImpegno" DataSetColumn="NomeImpegno" />
|
|
<Mapping SourceColumn="Inizio" DataSetColumn="Inizio" />
|
|
<Mapping SourceColumn="Fine" DataSetColumn="Fine" />
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="CssColor" DataSetColumn="CssColor" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ImpCal_getByDay" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByDate" GetMethodModifier="Public" GetMethodName="getByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByDate" UserSourceName="getByDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ImpCal_getByDay</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DisponibilitaTableAdapter" GeneratorDataComponentClassName="DisponibilitaTableAdapter" Name="Disponibilita" UserDataComponentName="DisponibilitaTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.Disponibilita" 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].[Disponibilita] WHERE (([Data] = @Original_Data) AND ([CodSquadra] = @Original_CodSquadra) AND ([OreDisp] = @Original_OreDisp) AND ([NumOp] = @Original_NumOp) AND ((@IsNull_MinDisp = 1 AND [MinDisp] IS NULL) OR ([MinDisp] = @Original_MinDisp)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OreDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OreDisp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinDisp" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MinDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinDisp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Disponibilita] ([Data], [CodSquadra], [OreDisp], [NumOp]) VALUES (@Data, @CodSquadra, @OreDisp, @NumOp);
|
|
SELECT Data, CodSquadra, OreDisp, NumOp, MinDisp FROM Disponibilita WHERE (CodSquadra = @CodSquadra) AND (Data = @Data)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OreDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OreDisp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Data, CodSquadra, OreDisp, NumOp, MinDisp FROM dbo.Disponibilita</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Disponibilita] SET [Data] = @Data, [CodSquadra] = @CodSquadra, [OreDisp] = @OreDisp, [NumOp] = @NumOp WHERE (([Data] = @Original_Data) AND ([CodSquadra] = @Original_CodSquadra) AND ([OreDisp] = @Original_OreDisp) AND ([NumOp] = @Original_NumOp) AND ((@IsNull_MinDisp = 1 AND [MinDisp] IS NULL) OR ([MinDisp] = @Original_MinDisp)));
|
|
SELECT Data, CodSquadra, OreDisp, NumOp, MinDisp FROM Disponibilita WHERE (CodSquadra = @CodSquadra) AND (Data = @Data)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OreDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OreDisp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodSquadra" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OreDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OreDisp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumOp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumOp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinDisp" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MinDisp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinDisp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="OreDisp" DataSetColumn="OreDisp" />
|
|
<Mapping SourceColumn="NumOp" DataSetColumn="NumOp" />
|
|
<Mapping SourceColumn="MinDisp" DataSetColumn="MinDisp" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Dis_delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Dis_delete</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_genDispSquadre" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="genDispSquadre" Modifier="Public" Name="genDispSquadre" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="genDispSquadre">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_genDispSquadre</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataFrom" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numDay" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_genDispSquadreGg" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="genDispSquadreGg" Modifier="Public" Name="genDispSquadreGg" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="genDispSquadreGg">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_genDispSquadreGg</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataFrom" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Dis_getByData" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByData" GetMethodModifier="Public" GetMethodName="getByData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByData" UserSourceName="getByData">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Dis_getByData</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_Dis_getByDataNumGg" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByDataNumGg" GetMethodModifier="Public" GetMethodName="getByDataNumGg" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByDataNumGg" UserSourceName="getByDataNumGg">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Dis_getByDataNumGg</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumDay" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DettImpegnoTableAdapter" GeneratorDataComponentClassName="DettImpegnoTableAdapter" Name="DettImpegno" UserDataComponentName="DettImpegnoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_DettImp" 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 IdxImpegno, NumCons, CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform, Minuti, Note FROM dbo.v_DettImp</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxImpegno" DataSetColumn="IdxImpegno" />
|
|
<Mapping SourceColumn="NumCons" DataSetColumn="NumCons" />
|
|
<Mapping SourceColumn="CodConsegna" DataSetColumn="CodConsegna" />
|
|
<Mapping SourceColumn="DescrConsegna" DataSetColumn="DescrConsegna" />
|
|
<Mapping SourceColumn="MinutiStd" DataSetColumn="MinutiStd" />
|
|
<Mapping SourceColumn="NumOp" DataSetColumn="NumOp" />
|
|
<Mapping SourceColumn="Elettrod" DataSetColumn="Elettrod" />
|
|
<Mapping SourceColumn="Clima" DataSetColumn="Clima" />
|
|
<Mapping SourceColumn="Inform" DataSetColumn="Inform" />
|
|
<Mapping SourceColumn="Minuti" DataSetColumn="Minuti" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DettImp_delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DettImp_delete</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_NumCons" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DettImp_getByImpegno" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByImpegno" GetMethodModifier="Public" GetMethodName="getByImpegno" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByImpegno" UserSourceName="getByImpegno">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DettImp_getByImpegno</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="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DettImp_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DettImp_getByKey</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumCons" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DettImp_insert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DettImp_insert</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DettImp_update" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DettImp_update</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_NumCons" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodConsegna" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MatrOp" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_clientiZoneTableAdapter" GeneratorDataComponentClassName="v_clientiZoneTableAdapter" Name="v_clientiZone" UserDataComponentName="v_clientiZoneTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_clientiZone" 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 CodCliente, RagSoc, Indir, Cap, Localita, Prov, Zona FROM dbo.v_clientiZone</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="RagSoc" DataSetColumn="RagSoc" />
|
|
<Mapping SourceColumn="Indir" DataSetColumn="Indir" />
|
|
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
|
|
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
|
|
<Mapping SourceColumn="Prov" DataSetColumn="Prov" />
|
|
<Mapping SourceColumn="Zona" DataSetColumn="Zona" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_vcz_search" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vcz_search</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="@search" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DB2_DOCSTableAdapter" GeneratorDataComponentClassName="DB2_DOCSTableAdapter" Name="DB2_DOCS" UserDataComponentName="DB2_DOCSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.raw.DB2_DOCS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT TIPOPROTOC, NUMERO, ESERPROTOC, NUMEPROTOC, DATAPROTOC, ESERRIFERI, NUMERIFERI, TIPORIFERI, DATARIFERI, NUMEDOCRIF, DATADOCRIF, ESERCOLLEG, CLI_FOR, DESTINATAR, RGSOC_DEST,
|
|
INDIR_DEST, LOCAL_DEST, CAP_DEST, ULT_AGG, ANNOTAZION
|
|
FROM raw.DB2_DOCS</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="TIPOPROTOC" DataSetColumn="TIPOPROTOC" />
|
|
<Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
|
|
<Mapping SourceColumn="ESERPROTOC" DataSetColumn="ESERPROTOC" />
|
|
<Mapping SourceColumn="NUMEPROTOC" DataSetColumn="NUMEPROTOC" />
|
|
<Mapping SourceColumn="DATAPROTOC" DataSetColumn="DATAPROTOC" />
|
|
<Mapping SourceColumn="ESERRIFERI" DataSetColumn="ESERRIFERI" />
|
|
<Mapping SourceColumn="NUMERIFERI" DataSetColumn="NUMERIFERI" />
|
|
<Mapping SourceColumn="TIPORIFERI" DataSetColumn="TIPORIFERI" />
|
|
<Mapping SourceColumn="DATARIFERI" DataSetColumn="DATARIFERI" />
|
|
<Mapping SourceColumn="NUMEDOCRIF" DataSetColumn="NUMEDOCRIF" />
|
|
<Mapping SourceColumn="DATADOCRIF" DataSetColumn="DATADOCRIF" />
|
|
<Mapping SourceColumn="ESERCOLLEG" DataSetColumn="ESERCOLLEG" />
|
|
<Mapping SourceColumn="CLI_FOR" DataSetColumn="CLI_FOR" />
|
|
<Mapping SourceColumn="DESTINATAR" DataSetColumn="DESTINATAR" />
|
|
<Mapping SourceColumn="RGSOC_DEST" DataSetColumn="RGSOC_DEST" />
|
|
<Mapping SourceColumn="INDIR_DEST" DataSetColumn="INDIR_DEST" />
|
|
<Mapping SourceColumn="LOCAL_DEST" DataSetColumn="LOCAL_DEST" />
|
|
<Mapping SourceColumn="CAP_DEST" DataSetColumn="CAP_DEST" />
|
|
<Mapping SourceColumn="ULT_AGG" DataSetColumn="ULT_AGG" />
|
|
<Mapping SourceColumn="ANNOTAZION" DataSetColumn="ANNOTAZION" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DOC_GetByCodCliente" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodCliente" GetMethodModifier="Public" GetMethodName="getByCodCliente" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodCliente" UserSourceName="getByCodCliente">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DOC_GetByCodCliente</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DOC_GetLast" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getLast" GetMethodModifier="Public" GetMethodName="getLast" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getLast" UserSourceName="getLast">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DOC_GetLast</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_DOC_upsert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="upsert" Modifier="Public" Name="upsert" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="upsert">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_DOC_upsert</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="@TIPOPROTOC" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NUMERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="7" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ESERPROTOC" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NUMEPROTOC" Precision="0" ProviderType="NVarChar" Scale="0" Size="7" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DATAPROTOC" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ESERRIFERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NUMERIFERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="7" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TIPORIFERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DATARIFERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NUMEDOCRIF" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DATADOCRIF" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ESERCOLLEG" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CLI_FOR" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DESTINATAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RGSOC_DEST" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@INDIR_DEST" Precision="0" ProviderType="NVarChar" Scale="0" Size="35" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@LOCAL_DEST" Precision="0" ProviderType="NVarChar" Scale="0" Size="35" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CAP_DEST" Precision="0" ProviderType="NVarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ULT_AGG" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ANNOTAZION" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssegnSquadreTableAdapter" GeneratorDataComponentClassName="AssegnSquadreTableAdapter" Name="AssegnSquadre" UserDataComponentName="AssegnSquadreTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_AssSqDip" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DataFrom, CodSquadra, Matr, DataTo, CognomeNome
|
|
FROM v_AssSqDip</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DataFrom" DataSetColumn="DataFrom" />
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="Matr" DataSetColumn="Matr" />
|
|
<Mapping SourceColumn="DataTo" DataSetColumn="DataTo" />
|
|
<Mapping SourceColumn="CognomeNome" DataSetColumn="CognomeNome" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AsSq_delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AsSq_delete</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFrom" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AsSq_GetByCodSqData" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByCodSqData" GetMethodModifier="Public" GetMethodName="GetByCodSqData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByCodSqData" UserSourceName="GetByCodSqData">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AsSq_GetByCodSqData</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="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_AsSq_insert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AsSq_insert</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DipendentiTableAdapter" GeneratorDataComponentClassName="DipendentiTableAdapter" Name="Dipendenti" UserDataComponentName="DipendentiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.Dipendenti" 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].[Dipendenti] WHERE (([Matr] = @Original_Matr) AND ([Cognome] = @Original_Cognome) AND ([Nome] = @Original_Nome) AND ([CognomeNome] = @Original_CognomeNome))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matr" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CognomeNome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CognomeNome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Dipendenti] ([Matr], [Cognome], [Nome]) VALUES (@Matr, @Cognome, @Nome);
|
|
SELECT Matr, Cognome, Nome, CognomeNome FROM Dipendenti WHERE (Matr = @Matr)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matr" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM dbo.Dipendenti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Dipendenti] SET [Matr] = @Matr, [Cognome] = @Cognome, [Nome] = @Nome WHERE (([Matr] = @Original_Matr) AND ([Cognome] = @Original_Cognome) AND ([Nome] = @Original_Nome) AND ([CognomeNome] = @Original_CognomeNome));
|
|
SELECT Matr, Cognome, Nome, CognomeNome FROM Dipendenti WHERE (Matr = @Matr)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matr" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matr" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CognomeNome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CognomeNome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Matr" DataSetColumn="Matr" />
|
|
<Mapping SourceColumn="Cognome" DataSetColumn="Cognome" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="CognomeNome" DataSetColumn="CognomeNome" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_resImpTableAdapter" GeneratorDataComponentClassName="v_resImpTableAdapter" Name="v_resImp" UserDataComponentName="v_resImpTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_resImp" 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 IdxImpegno, TotMin FROM dbo.v_resImp</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxImpegno" DataSetColumn="IdxImpegno" />
|
|
<Mapping SourceColumn="TotMin" DataSetColumn="TotMin" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_resImp_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_resImp_getByKey</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxImpegno" 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="AssegnSlotSquadreDipTableAdapter" GeneratorDataComponentClassName="AssegnSlotSquadreDipTableAdapter" Name="AssegnSlotSquadreDip" UserDataComponentName="AssegnSlotSquadreDipTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.v_ASSD" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM v_ASSD</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
<Mapping SourceColumn="Slot" DataSetColumn="Slot" />
|
|
<Mapping SourceColumn="CodSquadra" DataSetColumn="CodSquadra" />
|
|
<Mapping SourceColumn="Matr" DataSetColumn="Matr" />
|
|
<Mapping SourceColumn="DescrSquadra" DataSetColumn="DescrSquadra" />
|
|
<Mapping SourceColumn="CognomeNome" DataSetColumn="CognomeNome" />
|
|
<Mapping SourceColumn="CssColor" DataSetColumn="CssColor" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ASSD_clonePrevWeek" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="clonePrevWeek" Modifier="Public" Name="clonePrevWeek" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="clonePrevWeek">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASSD_clonePrevWeek</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="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="deleteQuery">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASSD_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_Slot" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ASSD_getByImpegno" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByImpegno" GetMethodModifier="Public" GetMethodName="getByImpegno" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByImpegno" UserSourceName="getByImpegno">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASSD_getByImpegno</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="@IdxImpegno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ASSD_getByDateSlot" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySlotSq" GetMethodModifier="Public" GetMethodName="getBySlotSq" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySlotSq" UserSourceName="getBySlotSq">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASSD_getByDateSlot</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="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Slot" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ASS_getByDateSlot" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getSquadre_byDateSlot" GetMethodModifier="Public" GetMethodName="getSquadre_byDateSlot" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getSquadre_byDateSlot" UserSourceName="getSquadre_byDateSlot">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASS_getByDateSlot</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="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Slot" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ASSD_insMiss" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insMiss" Modifier="Public" Name="insMiss" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="insMiss">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASSD_insMiss</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="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="WebSCRConnectionString (Settings)" DbObjectName="WebSCR.dbo.stp_ASSD_updateSquadra" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateSquadra" Modifier="Public" Name="updateSquadra" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updateSquadra">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ASSD_updateSquadra</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_Slot" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_Matr" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodSquadra" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Applicazione" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Applicazione" msprop:Generator_UserDSName="DS_Applicazione">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="AnagSquadre" msprop:Generator_TableClassName="AnagSquadreDataTable" msprop:Generator_TableVarName="tableAnagSquadre" msprop:Generator_TablePropName="AnagSquadre" msprop:Generator_RowDeletingName="AnagSquadreRowDeleting" msprop:Generator_RowChangingName="AnagSquadreRowChanging" msprop:Generator_RowEvHandlerName="AnagSquadreRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagSquadreRowDeleted" msprop:Generator_UserTableName="AnagSquadre" msprop:Generator_RowChangedName="AnagSquadreRowChanged" msprop:Generator_RowEvArgName="AnagSquadreRowChangeEvent" msprop:Generator_RowClassName="AnagSquadreRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrSquadra" msprop:Generator_ColumnVarNameInTable="columnDescrSquadra" msprop:Generator_ColumnPropNameInRow="DescrSquadra" msprop:Generator_ColumnPropNameInTable="DescrSquadraColumn" msprop:Generator_UserColumnName="DescrSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumOp" msprop:Generator_ColumnVarNameInTable="columnNumOp" msprop:Generator_ColumnPropNameInRow="NumOp" msprop:Generator_ColumnPropNameInTable="NumOpColumn" msprop:Generator_UserColumnName="NumOp" type="xs:int" />
|
|
<xs:element name="Elettrod" msprop:Generator_ColumnVarNameInTable="columnElettrod" msprop:Generator_ColumnPropNameInRow="Elettrod" msprop:Generator_ColumnPropNameInTable="ElettrodColumn" msprop:Generator_UserColumnName="Elettrod" type="xs:boolean" />
|
|
<xs:element name="Clima" msprop:Generator_ColumnVarNameInTable="columnClima" msprop:Generator_ColumnPropNameInRow="Clima" msprop:Generator_ColumnPropNameInTable="ClimaColumn" msprop:Generator_UserColumnName="Clima" type="xs:boolean" />
|
|
<xs:element name="Inform" msprop:Generator_ColumnVarNameInTable="columnInform" msprop:Generator_ColumnPropNameInRow="Inform" msprop:Generator_ColumnPropNameInTable="InformColumn" msprop:Generator_UserColumnName="Inform" type="xs:boolean" />
|
|
<xs:element name="Attiva" msprop:Generator_ColumnVarNameInTable="columnAttiva" msprop:Generator_ColumnPropNameInRow="Attiva" msprop:Generator_ColumnPropNameInTable="AttivaColumn" msprop:Generator_UserColumnName="Attiva" type="xs:boolean" />
|
|
<xs:element name="CssColor" msprop:Generator_ColumnVarNameInTable="columnCssColor" msprop:Generator_ColumnPropNameInRow="CssColor" msprop:Generator_ColumnPropNameInTable="CssColorColumn" msprop:Generator_UserColumnName="CssColor">
|
|
<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="AnagZone" msprop:Generator_TableClassName="AnagZoneDataTable" msprop:Generator_TableVarName="tableAnagZone" msprop:Generator_TablePropName="AnagZone" msprop:Generator_RowDeletingName="AnagZoneRowDeleting" msprop:Generator_RowChangingName="AnagZoneRowChanging" msprop:Generator_RowEvHandlerName="AnagZoneRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagZoneRowDeleted" msprop:Generator_UserTableName="AnagZone" msprop:Generator_RowChangedName="AnagZoneRowChanged" msprop:Generator_RowEvArgName="AnagZoneRowChangeEvent" msprop:Generator_RowClassName="AnagZoneRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxZona" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxZona" msprop:Generator_ColumnPropNameInRow="idxZona" msprop:Generator_ColumnPropNameInTable="idxZonaColumn" msprop:Generator_UserColumnName="idxZona" type="xs:int" />
|
|
<xs:element name="Cap" msprop:Generator_ColumnVarNameInTable="columnCap" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_UserColumnName="Cap">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_UserColumnName="Localita">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Prov" msprop:Generator_ColumnVarNameInTable="columnProv" msprop:Generator_ColumnPropNameInRow="Prov" msprop:Generator_ColumnPropNameInTable="ProvColumn" msprop:Generator_UserColumnName="Prov">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tempo" msprop:Generator_ColumnVarNameInTable="columnTempo" msprop:Generator_ColumnPropNameInRow="Tempo" msprop:Generator_ColumnPropNameInTable="TempoColumn" msprop:Generator_UserColumnName="Tempo" type="xs:int" />
|
|
<xs:element name="Zona" msprop:Generator_ColumnVarNameInTable="columnZona" msprop:Generator_ColumnPropNameInRow="Zona" msprop:Generator_ColumnPropNameInTable="ZonaColumn" msprop:Generator_UserColumnName="Zona">
|
|
<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="AnagTipoConsegne" msprop:Generator_TableClassName="AnagTipoConsegneDataTable" msprop:Generator_TableVarName="tableAnagTipoConsegne" msprop:Generator_TablePropName="AnagTipoConsegne" msprop:Generator_RowDeletingName="AnagTipoConsegneRowDeleting" msprop:Generator_RowChangingName="AnagTipoConsegneRowChanging" msprop:Generator_RowEvHandlerName="AnagTipoConsegneRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagTipoConsegneRowDeleted" msprop:Generator_UserTableName="AnagTipoConsegne" msprop:Generator_RowChangedName="AnagTipoConsegneRowChanged" msprop:Generator_RowEvArgName="AnagTipoConsegneRowChangeEvent" msprop:Generator_RowClassName="AnagTipoConsegneRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodConsegna" msprop:Generator_ColumnVarNameInTable="columnCodConsegna" msprop:Generator_ColumnPropNameInRow="CodConsegna" msprop:Generator_ColumnPropNameInTable="CodConsegnaColumn" msprop:Generator_UserColumnName="CodConsegna">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrConsegna" msprop:Generator_ColumnVarNameInTable="columnDescrConsegna" msprop:Generator_ColumnPropNameInRow="DescrConsegna" msprop:Generator_ColumnPropNameInTable="DescrConsegnaColumn" msprop:Generator_UserColumnName="DescrConsegna">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="MinutiStd" msprop:Generator_ColumnVarNameInTable="columnMinutiStd" msprop:Generator_ColumnPropNameInRow="MinutiStd" msprop:Generator_ColumnPropNameInTable="MinutiStdColumn" msprop:Generator_UserColumnName="MinutiStd" type="xs:int" />
|
|
<xs:element name="NumOp" msprop:Generator_ColumnVarNameInTable="columnNumOp" msprop:Generator_ColumnPropNameInRow="NumOp" msprop:Generator_ColumnPropNameInTable="NumOpColumn" msprop:Generator_UserColumnName="NumOp" type="xs:int" />
|
|
<xs:element name="Elettrod" msprop:Generator_ColumnVarNameInTable="columnElettrod" msprop:Generator_ColumnPropNameInRow="Elettrod" msprop:Generator_ColumnPropNameInTable="ElettrodColumn" msprop:Generator_UserColumnName="Elettrod" type="xs:boolean" />
|
|
<xs:element name="Clima" msprop:Generator_ColumnVarNameInTable="columnClima" msprop:Generator_ColumnPropNameInRow="Clima" msprop:Generator_ColumnPropNameInTable="ClimaColumn" msprop:Generator_UserColumnName="Clima" type="xs:boolean" />
|
|
<xs:element name="Inform" msprop:Generator_ColumnVarNameInTable="columnInform" msprop:Generator_ColumnPropNameInRow="Inform" msprop:Generator_ColumnPropNameInTable="InformColumn" msprop:Generator_UserColumnName="Inform" type="xs:boolean" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagClienti" msprop:Generator_TableClassName="AnagClientiDataTable" msprop:Generator_TableVarName="tableAnagClienti" msprop:Generator_RowChangedName="AnagClientiRowChanged" msprop:Generator_TablePropName="AnagClienti" msprop:Generator_RowDeletingName="AnagClientiRowDeleting" msprop:Generator_RowChangingName="AnagClientiRowChanging" msprop:Generator_RowEvHandlerName="AnagClientiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagClientiRowDeleted" msprop:Generator_RowClassName="AnagClientiRow" msprop:Generator_UserTableName="AnagClienti" msprop:Generator_RowEvArgName="AnagClientiRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_UserColumnName="CodCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodFis" msprop:Generator_ColumnVarNameInTable="columnCodFis" msprop:Generator_ColumnPropNameInRow="CodFis" msprop:Generator_ColumnPropNameInTable="CodFisColumn" msprop:Generator_UserColumnName="CodFis" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tel" msprop:Generator_ColumnVarNameInTable="columnTel" msprop:Generator_ColumnPropNameInRow="Tel" msprop:Generator_ColumnPropNameInTable="TelColumn" msprop:Generator_UserColumnName="Tel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cell" msprop:Generator_ColumnVarNameInTable="columnCell" msprop:Generator_ColumnPropNameInRow="Cell" msprop:Generator_ColumnPropNameInTable="CellColumn" msprop:Generator_UserColumnName="Cell" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" 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="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RagSoc" msprop:Generator_ColumnVarNameInTable="columnRagSoc" msprop:Generator_ColumnPropNameInRow="RagSoc" msprop:Generator_ColumnPropNameInTable="RagSocColumn" msprop:Generator_UserColumnName="RagSoc">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EnableSMS" msprop:Generator_ColumnVarNameInTable="columnEnableSMS" msprop:Generator_ColumnPropNameInRow="EnableSMS" msprop:Generator_ColumnPropNameInTable="EnableSMSColumn" msprop:Generator_UserColumnName="EnableSMS" type="xs:boolean" />
|
|
<xs:element name="Indir" msprop:Generator_ColumnVarNameInTable="columnIndir" msprop:Generator_ColumnPropNameInRow="Indir" msprop:Generator_ColumnPropNameInTable="IndirColumn" msprop:Generator_UserColumnName="Indir" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cap" msprop:Generator_ColumnVarNameInTable="columnCap" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_UserColumnName="Cap" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_UserColumnName="Localita" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Prov" msprop:Generator_ColumnVarNameInTable="columnProv" msprop:Generator_ColumnPropNameInRow="Prov" msprop:Generator_ColumnPropNameInTable="ProvColumn" msprop:Generator_UserColumnName="Prov" 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="Impegni" msprop:Generator_TableClassName="ImpegniDataTable" msprop:Generator_TableVarName="tableImpegni" msprop:Generator_RowChangedName="ImpegniRowChanged" msprop:Generator_TablePropName="Impegni" msprop:Generator_RowDeletingName="ImpegniRowDeleting" msprop:Generator_RowChangingName="ImpegniRowChanging" msprop:Generator_RowEvHandlerName="ImpegniRowChangeEventHandler" msprop:Generator_RowDeletedName="ImpegniRowDeleted" msprop:Generator_RowClassName="ImpegniRow" msprop:Generator_UserTableName="Impegni" msprop:Generator_RowEvArgName="ImpegniRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxImpegno" msprop:Generator_ColumnVarNameInTable="columnIdxImpegno" msprop:Generator_ColumnPropNameInRow="IdxImpegno" msprop:Generator_ColumnPropNameInTable="IdxImpegnoColumn" msprop:Generator_UserColumnName="IdxImpegno" type="xs:int" />
|
|
<xs:element name="DataOraComFrom" msdata:Caption="DataOra" msprop:Generator_ColumnVarNameInTable="columnDataOraComFrom" msprop:Generator_ColumnPropNameInRow="DataOraComFrom" msprop:Generator_ColumnPropNameInTable="DataOraComFromColumn" msprop:Generator_UserColumnName="DataOraComFrom" type="xs:dateTime" />
|
|
<xs:element name="DataOraComTo" msdata:Caption="DataOra" msprop:Generator_ColumnVarNameInTable="columnDataOraComTo" msprop:Generator_ColumnPropNameInRow="DataOraComTo" msprop:Generator_ColumnPropNameInTable="DataOraComToColumn" msprop:Generator_UserColumnName="DataOraComTo" type="xs:dateTime" />
|
|
<xs:element name="DataOra" msprop:Generator_ColumnVarNameInTable="columnDataOra" msprop:Generator_ColumnPropNameInRow="DataOra" msprop:Generator_ColumnPropNameInTable="DataOraColumn" msprop:Generator_UserColumnName="DataOra" type="xs:dateTime" />
|
|
<xs:element name="TipoOrario" msprop:Generator_ColumnVarNameInTable="columnTipoOrario" msprop:Generator_ColumnPropNameInRow="TipoOrario" msprop:Generator_ColumnPropNameInTable="TipoOrarioColumn" msprop:Generator_UserColumnName="TipoOrario">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliente" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_UserColumnName="CodCliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RagSoc" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRagSoc" msprop:Generator_ColumnPropNameInRow="RagSoc" msprop:Generator_ColumnPropNameInTable="RagSocColumn" msprop:Generator_UserColumnName="RagSoc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodFis" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCodFis" msprop:Generator_ColumnPropNameInRow="CodFis" msprop:Generator_ColumnPropNameInTable="CodFisColumn" msprop:Generator_UserColumnName="CodFis" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrSquadra" msprop:Generator_ColumnVarNameInTable="columnDescrSquadra" msprop:Generator_ColumnPropNameInRow="DescrSquadra" msprop:Generator_ColumnPropNameInTable="DescrSquadraColumn" msprop:Generator_UserColumnName="DescrSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Elettrod" msprop:Generator_ColumnVarNameInTable="columnElettrod" msprop:Generator_ColumnPropNameInRow="Elettrod" msprop:Generator_ColumnPropNameInTable="ElettrodColumn" msprop:Generator_UserColumnName="Elettrod" type="xs:boolean" />
|
|
<xs:element name="Clima" msprop:Generator_ColumnVarNameInTable="columnClima" msprop:Generator_ColumnPropNameInRow="Clima" msprop:Generator_ColumnPropNameInTable="ClimaColumn" msprop:Generator_UserColumnName="Clima" type="xs:boolean" />
|
|
<xs:element name="Inform" msprop:Generator_ColumnVarNameInTable="columnInform" msprop:Generator_ColumnPropNameInRow="Inform" msprop:Generator_ColumnPropNameInTable="InformColumn" msprop:Generator_UserColumnName="Inform" type="xs:boolean" />
|
|
<xs:element name="Indir" msprop:Generator_ColumnVarNameInTable="columnIndir" msprop:Generator_ColumnPropNameInRow="Indir" msprop:Generator_ColumnPropNameInTable="IndirColumn" msprop:Generator_UserColumnName="Indir">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cap" msprop:Generator_ColumnVarNameInTable="columnCap" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_UserColumnName="Cap">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_UserColumnName="Localita">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Prov" msprop:Generator_ColumnVarNameInTable="columnProv" msprop:Generator_ColumnPropNameInRow="Prov" msprop:Generator_ColumnPropNameInTable="ProvColumn" msprop:Generator_UserColumnName="Prov">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxZona" msprop:Generator_ColumnVarNameInTable="columnidxZona" msprop:Generator_ColumnPropNameInRow="idxZona" msprop:Generator_ColumnPropNameInTable="idxZonaColumn" msprop:Generator_UserColumnName="idxZona" type="xs:int" />
|
|
<xs:element name="MinTotCons" msprop:Generator_ColumnVarNameInTable="columnMinTotCons" msprop:Generator_ColumnPropNameInRow="MinTotCons" msprop:Generator_ColumnPropNameInTable="MinTotConsColumn" msprop:Generator_UserColumnName="MinTotCons" type="xs:int" />
|
|
<xs:element name="MinViaggio" msprop:Generator_ColumnVarNameInTable="columnMinViaggio" msprop:Generator_ColumnPropNameInRow="MinViaggio" msprop:Generator_ColumnPropNameInTable="MinViaggioColumn" msprop:Generator_UserColumnName="MinViaggio" type="xs:int" />
|
|
<xs:element name="FinePrev" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFinePrev" msprop:Generator_ColumnPropNameInRow="FinePrev" msprop:Generator_ColumnPropNameInTable="FinePrevColumn" msprop:Generator_UserColumnName="FinePrev" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="NoteGen" msprop:Generator_ColumnVarNameInTable="columnNoteGen" msprop:Generator_ColumnPropNameInRow="NoteGen" msprop:Generator_ColumnPropNameInTable="NoteGenColumn" msprop:Generator_UserColumnName="NoteGen">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RifOC" msprop:Generator_ColumnVarNameInTable="columnRifOC" msprop:Generator_ColumnPropNameInRow="RifOC" msprop:Generator_ColumnPropNameInTable="RifOCColumn" msprop:Generator_UserColumnName="RifOC">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UrlDoc" msprop:Generator_ColumnVarNameInTable="columnUrlDoc" msprop:Generator_ColumnPropNameInRow="UrlDoc" msprop:Generator_ColumnPropNameInTable="UrlDocColumn" msprop:Generator_UserColumnName="UrlDoc">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumOp" msprop:Generator_ColumnVarNameInTable="columnNumOp" msprop:Generator_ColumnPropNameInRow="NumOp" msprop:Generator_ColumnPropNameInTable="NumOpColumn" msprop:Generator_UserColumnName="NumOp" type="xs:int" />
|
|
<xs:element name="RitUsato" msprop:Generator_ColumnVarNameInTable="columnRitUsato" msprop:Generator_ColumnPropNameInRow="RitUsato" msprop:Generator_ColumnPropNameInTable="RitUsatoColumn" msprop:Generator_UserColumnName="RitUsato" type="xs:int" />
|
|
<xs:element name="Ascensore" msprop:Generator_ColumnVarNameInTable="columnAscensore" msprop:Generator_ColumnPropNameInRow="Ascensore" msprop:Generator_ColumnPropNameInTable="AscensoreColumn" msprop:Generator_UserColumnName="Ascensore" type="xs:int" />
|
|
<xs:element name="PianoCons" msprop:Generator_ColumnVarNameInTable="columnPianoCons" msprop:Generator_ColumnPropNameInRow="PianoCons" msprop:Generator_ColumnPropNameInTable="PianoConsColumn" msprop:Generator_UserColumnName="PianoCons" type="xs:int" />
|
|
<xs:element name="UserMod" msprop:Generator_ColumnVarNameInTable="columnUserMod" msprop:Generator_ColumnPropNameInRow="UserMod" msprop:Generator_ColumnPropNameInTable="UserModColumn" msprop:Generator_UserColumnName="UserMod">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataMod" msprop:Generator_ColumnVarNameInTable="columnDataMod" msprop:Generator_ColumnPropNameInRow="DataMod" msprop:Generator_ColumnPropNameInTable="DataModColumn" msprop:Generator_UserColumnName="DataMod" type="xs:dateTime" />
|
|
<xs:element name="STATO" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSTATO" msprop:Generator_ColumnPropNameInRow="STATO" msprop:Generator_ColumnPropNameInTable="STATOColumn" msprop:Generator_UserColumnName="STATO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="InizioInt" msprop:Generator_ColumnVarNameInTable="columnInizioInt" msprop:Generator_ColumnPropNameInRow="InizioInt" msprop:Generator_ColumnPropNameInTable="InizioIntColumn" msprop:Generator_UserColumnName="InizioInt" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="FineInt" msprop:Generator_ColumnVarNameInTable="columnFineInt" msprop:Generator_ColumnPropNameInRow="FineInt" msprop:Generator_ColumnPropNameInTable="FineIntColumn" msprop:Generator_UserColumnName="FineInt" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="NoteInt" msprop:Generator_ColumnVarNameInTable="columnNoteInt" msprop:Generator_ColumnPropNameInRow="NoteInt" msprop:Generator_ColumnPropNameInTable="NoteIntColumn" msprop:Generator_UserColumnName="NoteInt" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LatInizio" msprop:Generator_ColumnVarNameInTable="columnLatInizio" msprop:Generator_ColumnPropNameInRow="LatInizio" msprop:Generator_ColumnPropNameInTable="LatInizioColumn" msprop:Generator_UserColumnName="LatInizio" type="xs:double" minOccurs="0" />
|
|
<xs:element name="LonInizio" msprop:Generator_ColumnVarNameInTable="columnLonInizio" msprop:Generator_ColumnPropNameInRow="LonInizio" msprop:Generator_ColumnPropNameInTable="LonInizioColumn" msprop:Generator_UserColumnName="LonInizio" type="xs:double" minOccurs="0" />
|
|
<xs:element name="LatFine" msdata:Caption="LatFin" msprop:Generator_ColumnVarNameInTable="columnLatFine" msprop:Generator_ColumnPropNameInRow="LatFine" msprop:Generator_ColumnPropNameInTable="LatFineColumn" msprop:Generator_UserColumnName="LatFine" type="xs:double" minOccurs="0" />
|
|
<xs:element name="LonFine" msprop:Generator_ColumnVarNameInTable="columnLonFine" msprop:Generator_ColumnPropNameInRow="LonFine" msprop:Generator_ColumnPropNameInTable="LonFineColumn" msprop:Generator_UserColumnName="LonFine" type="xs:double" minOccurs="0" />
|
|
<xs:element name="DataCreaz" msprop:Generator_ColumnVarNameInTable="columnDataCreaz" msprop:Generator_ColumnPropNameInRow="DataCreaz" msprop:Generator_ColumnPropNameInTable="DataCreazColumn" msprop:Generator_UserColumnName="DataCreaz" type="xs:dateTime" />
|
|
<xs:element name="DescrImp" msprop:Generator_ColumnVarNameInTable="columnDescrImp" msprop:Generator_ColumnPropNameInRow="DescrImp" msprop:Generator_ColumnPropNameInTable="DescrImpColumn" msprop:Generator_UserColumnName="DescrImp" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="IntAperto" msprop:Generator_ColumnVarNameInTable="columnIntAperto" msprop:Generator_ColumnPropNameInRow="IntAperto" msprop:Generator_ColumnPropNameInTable="IntApertoColumn" msprop:Generator_UserColumnName="IntAperto" type="xs:boolean" />
|
|
<xs:element name="DettImpegno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDettImpegno" msprop:Generator_ColumnPropNameInRow="DettImpegno" msprop:Generator_ColumnPropNameInTable="DettImpegnoColumn" msprop:Generator_UserColumnName="DettImpegno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tel" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTel" msprop:Generator_ColumnPropNameInRow="Tel" msprop:Generator_ColumnPropNameInTable="TelColumn" msprop:Generator_UserColumnName="Tel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="103" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AnnoOC" msprop:Generator_ColumnVarNameInTable="columnAnnoOC" msprop:Generator_ColumnPropNameInRow="AnnoOC" msprop:Generator_ColumnPropNameInTable="AnnoOCColumn" msprop:Generator_UserColumnName="AnnoOC" type="xs:int" />
|
|
<xs:element name="MatrOp" msprop:Generator_ColumnVarNameInTable="columnMatrOp" msprop:Generator_ColumnPropNameInRow="MatrOp" msprop:Generator_ColumnPropNameInTable="MatrOpColumn" msprop:Generator_UserColumnName="MatrOp">
|
|
<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="DispImpTot" msprop:Generator_TableClassName="DispImpTotDataTable" msprop:Generator_TableVarName="tableDispImpTot" msprop:Generator_TablePropName="DispImpTot" msprop:Generator_RowDeletingName="DispImpTotRowDeleting" msprop:Generator_RowChangingName="DispImpTotRowChanging" msprop:Generator_RowEvHandlerName="DispImpTotRowChangeEventHandler" msprop:Generator_RowDeletedName="DispImpTotRowDeleted" msprop:Generator_UserTableName="DispImpTot" msprop:Generator_RowChangedName="DispImpTotRowChanged" msprop:Generator_RowEvArgName="DispImpTotRowChangeEvent" msprop:Generator_RowClassName="DispImpTotRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" />
|
|
<xs:element name="NumOp" msprop:Generator_ColumnVarNameInTable="columnNumOp" msprop:Generator_ColumnPropNameInRow="NumOp" msprop:Generator_ColumnPropNameInTable="NumOpColumn" msprop:Generator_UserColumnName="NumOp" type="xs:int" />
|
|
<xs:element name="ScoreDisp" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnScoreDisp" msprop:Generator_ColumnPropNameInRow="ScoreDisp" msprop:Generator_ColumnPropNameInTable="ScoreDispColumn" msprop:Generator_UserColumnName="ScoreDisp" type="xs:double" minOccurs="0" />
|
|
<xs:element name="ScoreZona" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnScoreZona" msprop:Generator_ColumnPropNameInRow="ScoreZona" msprop:Generator_ColumnPropNameInTable="ScoreZonaColumn" msprop:Generator_UserColumnName="ScoreZona" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="DispImpSquadre" msprop:Generator_TableClassName="DispImpSquadreDataTable" msprop:Generator_TableVarName="tableDispImpSquadre" msprop:Generator_TablePropName="DispImpSquadre" msprop:Generator_RowDeletingName="DispImpSquadreRowDeleting" msprop:Generator_RowChangingName="DispImpSquadreRowChanging" msprop:Generator_RowEvHandlerName="DispImpSquadreRowChangeEventHandler" msprop:Generator_RowDeletedName="DispImpSquadreRowDeleted" msprop:Generator_UserTableName="DispImpSquadre" msprop:Generator_RowChangedName="DispImpSquadreRowChanged" msprop:Generator_RowEvArgName="DispImpSquadreRowChangeEvent" msprop:Generator_RowClassName="DispImpSquadreRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" />
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OreDisp" msprop:Generator_ColumnVarNameInTable="columnOreDisp" msprop:Generator_ColumnPropNameInRow="OreDisp" msprop:Generator_ColumnPropNameInTable="OreDispColumn" msprop:Generator_UserColumnName="OreDisp" type="xs:int" />
|
|
<xs:element name="OreImp" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOreImp" msprop:Generator_ColumnPropNameInRow="OreImp" msprop:Generator_ColumnPropNameInTable="OreImpColumn" msprop:Generator_UserColumnName="OreImp" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_ImpegniCal" msprop:Generator_TableClassName="v_ImpegniCalDataTable" msprop:Generator_TableVarName="tablev_ImpegniCal" msprop:Generator_RowChangedName="v_ImpegniCalRowChanged" msprop:Generator_TablePropName="v_ImpegniCal" msprop:Generator_RowDeletingName="v_ImpegniCalRowDeleting" msprop:Generator_RowChangingName="v_ImpegniCalRowChanging" msprop:Generator_RowEvHandlerName="v_ImpegniCalRowChangeEventHandler" msprop:Generator_RowDeletedName="v_ImpegniCalRowDeleted" msprop:Generator_RowClassName="v_ImpegniCalRow" msprop:Generator_UserTableName="v_ImpegniCal" msprop:Generator_RowEvArgName="v_ImpegniCalRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxImpegno" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdxImpegno" msprop:Generator_ColumnPropNameInRow="IdxImpegno" msprop:Generator_ColumnPropNameInTable="IdxImpegnoColumn" msprop:Generator_UserColumnName="IdxImpegno" type="xs:int" />
|
|
<xs:element name="NomeImpegno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNomeImpegno" msprop:Generator_ColumnPropNameInRow="NomeImpegno" msprop:Generator_ColumnPropNameInTable="NomeImpegnoColumn" msprop:Generator_UserColumnName="NomeImpegno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Inizio" msprop:Generator_ColumnVarNameInTable="columnInizio" msprop:Generator_ColumnPropNameInRow="Inizio" msprop:Generator_ColumnPropNameInTable="InizioColumn" msprop:Generator_UserColumnName="Inizio" type="xs:dateTime" />
|
|
<xs:element name="Fine" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFine" msprop:Generator_ColumnPropNameInRow="Fine" msprop:Generator_ColumnPropNameInTable="FineColumn" msprop:Generator_UserColumnName="Fine" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CssColor" msprop:Generator_ColumnVarNameInTable="columnCssColor" msprop:Generator_ColumnPropNameInRow="CssColor" msprop:Generator_ColumnPropNameInTable="CssColorColumn" msprop:Generator_UserColumnName="CssColor">
|
|
<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="Disponibilita" msprop:Generator_TableClassName="DisponibilitaDataTable" msprop:Generator_TableVarName="tableDisponibilita" msprop:Generator_RowChangedName="DisponibilitaRowChanged" msprop:Generator_TablePropName="Disponibilita" msprop:Generator_RowDeletingName="DisponibilitaRowDeleting" msprop:Generator_RowChangingName="DisponibilitaRowChanging" msprop:Generator_RowEvHandlerName="DisponibilitaRowChangeEventHandler" msprop:Generator_RowDeletedName="DisponibilitaRowDeleted" msprop:Generator_RowClassName="DisponibilitaRow" msprop:Generator_UserTableName="Disponibilita" msprop:Generator_RowEvArgName="DisponibilitaRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" />
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OreDisp" msprop:Generator_ColumnVarNameInTable="columnOreDisp" msprop:Generator_ColumnPropNameInRow="OreDisp" msprop:Generator_ColumnPropNameInTable="OreDispColumn" msprop:Generator_UserColumnName="OreDisp" type="xs:int" />
|
|
<xs:element name="NumOp" msprop:Generator_ColumnVarNameInTable="columnNumOp" msprop:Generator_ColumnPropNameInRow="NumOp" msprop:Generator_ColumnPropNameInTable="NumOpColumn" msprop:Generator_UserColumnName="NumOp" type="xs:int" />
|
|
<xs:element name="MinDisp" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMinDisp" msprop:Generator_ColumnPropNameInRow="MinDisp" msprop:Generator_ColumnPropNameInTable="MinDispColumn" msprop:Generator_UserColumnName="MinDisp" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="DettImpegno" msprop:Generator_TableClassName="DettImpegnoDataTable" msprop:Generator_TableVarName="tableDettImpegno" msprop:Generator_TablePropName="DettImpegno" msprop:Generator_RowDeletingName="DettImpegnoRowDeleting" msprop:Generator_RowChangingName="DettImpegnoRowChanging" msprop:Generator_RowEvHandlerName="DettImpegnoRowChangeEventHandler" msprop:Generator_RowDeletedName="DettImpegnoRowDeleted" msprop:Generator_UserTableName="DettImpegno" msprop:Generator_RowChangedName="DettImpegnoRowChanged" msprop:Generator_RowEvArgName="DettImpegnoRowChangeEvent" msprop:Generator_RowClassName="DettImpegnoRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxImpegno" msprop:Generator_ColumnVarNameInTable="columnIdxImpegno" msprop:Generator_ColumnPropNameInRow="IdxImpegno" msprop:Generator_ColumnPropNameInTable="IdxImpegnoColumn" msprop:Generator_UserColumnName="IdxImpegno" type="xs:int" />
|
|
<xs:element name="NumCons" msprop:Generator_ColumnVarNameInTable="columnNumCons" msprop:Generator_ColumnPropNameInRow="NumCons" msprop:Generator_ColumnPropNameInTable="NumConsColumn" msprop:Generator_UserColumnName="NumCons" type="xs:int" />
|
|
<xs:element name="CodConsegna" msprop:Generator_ColumnVarNameInTable="columnCodConsegna" msprop:Generator_ColumnPropNameInRow="CodConsegna" msprop:Generator_ColumnPropNameInTable="CodConsegnaColumn" msprop:Generator_UserColumnName="CodConsegna">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrConsegna" msprop:Generator_ColumnVarNameInTable="columnDescrConsegna" msprop:Generator_ColumnPropNameInRow="DescrConsegna" msprop:Generator_ColumnPropNameInTable="DescrConsegnaColumn" msprop:Generator_UserColumnName="DescrConsegna">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="MinutiStd" msprop:Generator_ColumnVarNameInTable="columnMinutiStd" msprop:Generator_ColumnPropNameInRow="MinutiStd" msprop:Generator_ColumnPropNameInTable="MinutiStdColumn" msprop:Generator_UserColumnName="MinutiStd" type="xs:int" />
|
|
<xs:element name="NumOp" msprop:Generator_ColumnVarNameInTable="columnNumOp" msprop:Generator_ColumnPropNameInRow="NumOp" msprop:Generator_ColumnPropNameInTable="NumOpColumn" msprop:Generator_UserColumnName="NumOp" type="xs:int" />
|
|
<xs:element name="Elettrod" msprop:Generator_ColumnVarNameInTable="columnElettrod" msprop:Generator_ColumnPropNameInRow="Elettrod" msprop:Generator_ColumnPropNameInTable="ElettrodColumn" msprop:Generator_UserColumnName="Elettrod" type="xs:boolean" />
|
|
<xs:element name="Clima" msprop:Generator_ColumnVarNameInTable="columnClima" msprop:Generator_ColumnPropNameInRow="Clima" msprop:Generator_ColumnPropNameInTable="ClimaColumn" msprop:Generator_UserColumnName="Clima" type="xs:boolean" />
|
|
<xs:element name="Inform" msprop:Generator_ColumnVarNameInTable="columnInform" msprop:Generator_ColumnPropNameInRow="Inform" msprop:Generator_ColumnPropNameInTable="InformColumn" msprop:Generator_UserColumnName="Inform" type="xs:boolean" />
|
|
<xs:element name="Minuti" msprop:Generator_ColumnVarNameInTable="columnMinuti" msprop:Generator_ColumnPropNameInRow="Minuti" msprop:Generator_ColumnPropNameInTable="MinutiColumn" msprop:Generator_UserColumnName="Minuti" type="xs:int" 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:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_clientiZone" msprop:Generator_TableClassName="v_clientiZoneDataTable" msprop:Generator_TableVarName="tablev_clientiZone" msprop:Generator_RowChangedName="v_clientiZoneRowChanged" msprop:Generator_TablePropName="v_clientiZone" msprop:Generator_RowDeletingName="v_clientiZoneRowDeleting" msprop:Generator_RowChangingName="v_clientiZoneRowChanging" msprop:Generator_RowEvHandlerName="v_clientiZoneRowChangeEventHandler" msprop:Generator_RowDeletedName="v_clientiZoneRowDeleted" msprop:Generator_RowClassName="v_clientiZoneRow" msprop:Generator_UserTableName="v_clientiZone" msprop:Generator_RowEvArgName="v_clientiZoneRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_UserColumnName="CodCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RagSoc" msprop:Generator_ColumnVarNameInTable="columnRagSoc" msprop:Generator_ColumnPropNameInRow="RagSoc" msprop:Generator_ColumnPropNameInTable="RagSocColumn" msprop:Generator_UserColumnName="RagSoc">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Indir" msprop:Generator_ColumnVarNameInTable="columnIndir" msprop:Generator_ColumnPropNameInRow="Indir" msprop:Generator_ColumnPropNameInTable="IndirColumn" msprop:Generator_UserColumnName="Indir" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cap" msprop:Generator_ColumnVarNameInTable="columnCap" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_UserColumnName="Cap" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Localita" msprop:Generator_ColumnVarNameInTable="columnLocalita" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_UserColumnName="Localita" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Prov" msprop:Generator_ColumnVarNameInTable="columnProv" msprop:Generator_ColumnPropNameInRow="Prov" msprop:Generator_ColumnPropNameInTable="ProvColumn" msprop:Generator_UserColumnName="Prov" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Zona" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnZona" msprop:Generator_ColumnPropNameInRow="Zona" msprop:Generator_ColumnPropNameInTable="ZonaColumn" msprop:Generator_UserColumnName="Zona" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="DB2_DOCS" msprop:Generator_TableClassName="DB2_DOCSDataTable" msprop:Generator_TableVarName="tableDB2_DOCS" msprop:Generator_TablePropName="DB2_DOCS" msprop:Generator_RowDeletingName="DB2_DOCSRowDeleting" msprop:Generator_RowChangingName="DB2_DOCSRowChanging" msprop:Generator_RowEvHandlerName="DB2_DOCSRowChangeEventHandler" msprop:Generator_RowDeletedName="DB2_DOCSRowDeleted" msprop:Generator_UserTableName="DB2_DOCS" msprop:Generator_RowChangedName="DB2_DOCSRowChanged" msprop:Generator_RowEvArgName="DB2_DOCSRowChangeEvent" msprop:Generator_RowClassName="DB2_DOCSRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="TIPOPROTOC" msprop:Generator_ColumnVarNameInTable="columnTIPOPROTOC" msprop:Generator_ColumnPropNameInRow="TIPOPROTOC" msprop:Generator_ColumnPropNameInTable="TIPOPROTOCColumn" msprop:Generator_UserColumnName="TIPOPROTOC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" msprop:Generator_UserColumnName="NUMERO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="7" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ESERPROTOC" msprop:Generator_ColumnVarNameInTable="columnESERPROTOC" msprop:Generator_ColumnPropNameInRow="ESERPROTOC" msprop:Generator_ColumnPropNameInTable="ESERPROTOCColumn" msprop:Generator_UserColumnName="ESERPROTOC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NUMEPROTOC" msprop:Generator_ColumnVarNameInTable="columnNUMEPROTOC" msprop:Generator_ColumnPropNameInRow="NUMEPROTOC" msprop:Generator_ColumnPropNameInTable="NUMEPROTOCColumn" msprop:Generator_UserColumnName="NUMEPROTOC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="7" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DATAPROTOC" msprop:Generator_ColumnVarNameInTable="columnDATAPROTOC" msprop:Generator_ColumnPropNameInRow="DATAPROTOC" msprop:Generator_ColumnPropNameInTable="DATAPROTOCColumn" msprop:Generator_UserColumnName="DATAPROTOC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ESERRIFERI" msprop:Generator_ColumnVarNameInTable="columnESERRIFERI" msprop:Generator_ColumnPropNameInRow="ESERRIFERI" msprop:Generator_ColumnPropNameInTable="ESERRIFERIColumn" msprop:Generator_UserColumnName="ESERRIFERI" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NUMERIFERI" msprop:Generator_ColumnVarNameInTable="columnNUMERIFERI" msprop:Generator_ColumnPropNameInRow="NUMERIFERI" msprop:Generator_ColumnPropNameInTable="NUMERIFERIColumn" msprop:Generator_UserColumnName="NUMERIFERI" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="7" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TIPORIFERI" msprop:Generator_ColumnVarNameInTable="columnTIPORIFERI" msprop:Generator_ColumnPropNameInRow="TIPORIFERI" msprop:Generator_ColumnPropNameInTable="TIPORIFERIColumn" msprop:Generator_UserColumnName="TIPORIFERI" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DATARIFERI" msprop:Generator_ColumnVarNameInTable="columnDATARIFERI" msprop:Generator_ColumnPropNameInRow="DATARIFERI" msprop:Generator_ColumnPropNameInTable="DATARIFERIColumn" msprop:Generator_UserColumnName="DATARIFERI" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NUMEDOCRIF" msprop:Generator_ColumnVarNameInTable="columnNUMEDOCRIF" msprop:Generator_ColumnPropNameInRow="NUMEDOCRIF" msprop:Generator_ColumnPropNameInTable="NUMEDOCRIFColumn" msprop:Generator_UserColumnName="NUMEDOCRIF" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DATADOCRIF" msprop:Generator_ColumnVarNameInTable="columnDATADOCRIF" msprop:Generator_ColumnPropNameInRow="DATADOCRIF" msprop:Generator_ColumnPropNameInTable="DATADOCRIFColumn" msprop:Generator_UserColumnName="DATADOCRIF" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ESERCOLLEG" msprop:Generator_ColumnVarNameInTable="columnESERCOLLEG" msprop:Generator_ColumnPropNameInRow="ESERCOLLEG" msprop:Generator_ColumnPropNameInTable="ESERCOLLEGColumn" msprop:Generator_UserColumnName="ESERCOLLEG" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CLI_FOR" msprop:Generator_ColumnVarNameInTable="columnCLI_FOR" msprop:Generator_ColumnPropNameInRow="CLI_FOR" msprop:Generator_ColumnPropNameInTable="CLI_FORColumn" msprop:Generator_UserColumnName="CLI_FOR" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DESTINATAR" msprop:Generator_ColumnVarNameInTable="columnDESTINATAR" msprop:Generator_ColumnPropNameInRow="DESTINATAR" msprop:Generator_ColumnPropNameInTable="DESTINATARColumn" msprop:Generator_UserColumnName="DESTINATAR" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RGSOC_DEST" msprop:Generator_ColumnVarNameInTable="columnRGSOC_DEST" msprop:Generator_ColumnPropNameInRow="RGSOC_DEST" msprop:Generator_ColumnPropNameInTable="RGSOC_DESTColumn" msprop:Generator_UserColumnName="RGSOC_DEST" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="INDIR_DEST" msprop:Generator_ColumnVarNameInTable="columnINDIR_DEST" msprop:Generator_ColumnPropNameInRow="INDIR_DEST" msprop:Generator_ColumnPropNameInTable="INDIR_DESTColumn" msprop:Generator_UserColumnName="INDIR_DEST" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LOCAL_DEST" msprop:Generator_ColumnVarNameInTable="columnLOCAL_DEST" msprop:Generator_ColumnPropNameInRow="LOCAL_DEST" msprop:Generator_ColumnPropNameInTable="LOCAL_DESTColumn" msprop:Generator_UserColumnName="LOCAL_DEST" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CAP_DEST" msprop:Generator_ColumnVarNameInTable="columnCAP_DEST" msprop:Generator_ColumnPropNameInRow="CAP_DEST" msprop:Generator_ColumnPropNameInTable="CAP_DESTColumn" msprop:Generator_UserColumnName="CAP_DEST" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ULT_AGG" msprop:Generator_ColumnVarNameInTable="columnULT_AGG" msprop:Generator_ColumnPropNameInRow="ULT_AGG" msprop:Generator_ColumnPropNameInTable="ULT_AGGColumn" msprop:Generator_UserColumnName="ULT_AGG" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ANNOTAZION" msprop:Generator_ColumnVarNameInTable="columnANNOTAZION" msprop:Generator_ColumnPropNameInRow="ANNOTAZION" msprop:Generator_ColumnPropNameInTable="ANNOTAZIONColumn" msprop:Generator_UserColumnName="ANNOTAZION">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AssegnSquadre" msprop:Generator_TableClassName="AssegnSquadreDataTable" msprop:Generator_TableVarName="tableAssegnSquadre" msprop:Generator_TablePropName="AssegnSquadre" msprop:Generator_RowDeletingName="AssegnSquadreRowDeleting" msprop:Generator_RowChangingName="AssegnSquadreRowChanging" msprop:Generator_RowEvHandlerName="AssegnSquadreRowChangeEventHandler" msprop:Generator_RowDeletedName="AssegnSquadreRowDeleted" msprop:Generator_UserTableName="AssegnSquadre" msprop:Generator_RowChangedName="AssegnSquadreRowChanged" msprop:Generator_RowEvArgName="AssegnSquadreRowChangeEvent" msprop:Generator_RowClassName="AssegnSquadreRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DataFrom" msprop:Generator_ColumnVarNameInTable="columnDataFrom" msprop:Generator_ColumnPropNameInRow="DataFrom" msprop:Generator_ColumnPropNameInTable="DataFromColumn" msprop:Generator_UserColumnName="DataFrom" type="xs:dateTime" />
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Matr" msprop:Generator_ColumnVarNameInTable="columnMatr" msprop:Generator_ColumnPropNameInRow="Matr" msprop:Generator_ColumnPropNameInTable="MatrColumn" msprop:Generator_UserColumnName="Matr">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataTo" msprop:Generator_ColumnVarNameInTable="columnDataTo" msprop:Generator_ColumnPropNameInRow="DataTo" msprop:Generator_ColumnPropNameInTable="DataToColumn" msprop:Generator_UserColumnName="DataTo" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CognomeNome" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCognomeNome" msprop:Generator_ColumnPropNameInRow="CognomeNome" msprop:Generator_ColumnPropNameInTable="CognomeNomeColumn" msprop:Generator_UserColumnName="CognomeNome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Dipendenti" msprop:Generator_TableClassName="DipendentiDataTable" msprop:Generator_TableVarName="tableDipendenti" msprop:Generator_TablePropName="Dipendenti" msprop:Generator_RowDeletingName="DipendentiRowDeleting" msprop:Generator_RowChangingName="DipendentiRowChanging" msprop:Generator_RowEvHandlerName="DipendentiRowChangeEventHandler" msprop:Generator_RowDeletedName="DipendentiRowDeleted" msprop:Generator_UserTableName="Dipendenti" msprop:Generator_RowChangedName="DipendentiRowChanged" msprop:Generator_RowEvArgName="DipendentiRowChangeEvent" msprop:Generator_RowClassName="DipendentiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Matr" msprop:Generator_ColumnVarNameInTable="columnMatr" msprop:Generator_ColumnPropNameInRow="Matr" msprop:Generator_ColumnPropNameInTable="MatrColumn" msprop:Generator_UserColumnName="Matr">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cognome" msprop:Generator_ColumnVarNameInTable="columnCognome" msprop:Generator_ColumnPropNameInRow="Cognome" msprop:Generator_ColumnPropNameInTable="CognomeColumn" msprop:Generator_UserColumnName="Cognome">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CognomeNome" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCognomeNome" msprop:Generator_ColumnPropNameInRow="CognomeNome" msprop:Generator_ColumnPropNameInTable="CognomeNomeColumn" msprop:Generator_UserColumnName="CognomeNome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_resImp" msprop:Generator_TableClassName="v_resImpDataTable" msprop:Generator_TableVarName="tablev_resImp" msprop:Generator_RowChangedName="v_resImpRowChanged" msprop:Generator_TablePropName="v_resImp" msprop:Generator_RowDeletingName="v_resImpRowDeleting" msprop:Generator_RowChangingName="v_resImpRowChanging" msprop:Generator_RowEvHandlerName="v_resImpRowChangeEventHandler" msprop:Generator_RowDeletedName="v_resImpRowDeleted" msprop:Generator_RowClassName="v_resImpRow" msprop:Generator_UserTableName="v_resImp" msprop:Generator_RowEvArgName="v_resImpRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxImpegno" msprop:Generator_ColumnVarNameInTable="columnIdxImpegno" msprop:Generator_ColumnPropNameInRow="IdxImpegno" msprop:Generator_ColumnPropNameInTable="IdxImpegnoColumn" msprop:Generator_UserColumnName="IdxImpegno" type="xs:int" />
|
|
<xs:element name="TotMin" msprop:Generator_ColumnVarNameInTable="columnTotMin" msprop:Generator_ColumnPropNameInRow="TotMin" msprop:Generator_ColumnPropNameInTable="TotMinColumn" msprop:Generator_UserColumnName="TotMin" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AssegnSlotSquadreDip" msprop:Generator_TableClassName="AssegnSlotSquadreDipDataTable" msprop:Generator_TableVarName="tableAssegnSlotSquadreDip" msprop:Generator_RowChangedName="AssegnSlotSquadreDipRowChanged" msprop:Generator_TablePropName="AssegnSlotSquadreDip" msprop:Generator_RowDeletingName="AssegnSlotSquadreDipRowDeleting" msprop:Generator_RowChangingName="AssegnSlotSquadreDipRowChanging" msprop:Generator_RowEvHandlerName="AssegnSlotSquadreDipRowChangeEventHandler" msprop:Generator_RowDeletedName="AssegnSlotSquadreDipRowDeleted" msprop:Generator_RowClassName="AssegnSlotSquadreDipRow" msprop:Generator_UserTableName="AssegnSlotSquadreDip" msprop:Generator_RowEvArgName="AssegnSlotSquadreDipRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" />
|
|
<xs:element name="Slot" msprop:Generator_ColumnVarNameInTable="columnSlot" msprop:Generator_ColumnPropNameInRow="Slot" msprop:Generator_ColumnPropNameInTable="SlotColumn" msprop:Generator_UserColumnName="Slot">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodSquadra" msprop:Generator_ColumnVarNameInTable="columnCodSquadra" msprop:Generator_ColumnPropNameInRow="CodSquadra" msprop:Generator_ColumnPropNameInTable="CodSquadraColumn" msprop:Generator_UserColumnName="CodSquadra">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Matr" msprop:Generator_ColumnVarNameInTable="columnMatr" msprop:Generator_ColumnPropNameInRow="Matr" msprop:Generator_ColumnPropNameInTable="MatrColumn" msprop:Generator_UserColumnName="Matr">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrSquadra" msdata:ReadOnly="true" msdata:Caption="CognomeNome" msprop:Generator_ColumnVarNameInTable="columnDescrSquadra" msprop:Generator_ColumnPropNameInRow="DescrSquadra" msprop:Generator_ColumnPropNameInTable="DescrSquadraColumn" msprop:Generator_UserColumnName="DescrSquadra" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CognomeNome" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCognomeNome" msprop:Generator_ColumnPropNameInRow="CognomeNome" msprop:Generator_ColumnPropNameInTable="CognomeNomeColumn" msprop:Generator_UserColumnName="CognomeNome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CssColor" msprop:Generator_ColumnVarNameInTable="columnCssColor" msprop:Generator_ColumnPropNameInRow="CssColor" msprop:Generator_ColumnPropNameInTable="CssColorColumn" msprop:Generator_UserColumnName="CssColor" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagSquadre" />
|
|
<xs:field xpath="mstns:CodSquadra" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagZone_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagZone" />
|
|
<xs:field xpath="mstns:idxZona" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagTipoConsegne_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagTipoConsegne" />
|
|
<xs:field xpath="mstns:CodConsegna" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagClienti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagClienti" />
|
|
<xs:field xpath="mstns:CodCliente" />
|
|
</xs:unique>
|
|
<xs:unique name="Impegni_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Impegni" />
|
|
<xs:field xpath="mstns:IdxImpegno" />
|
|
</xs:unique>
|
|
<xs:unique name="DispImpSquadre_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:DispImpSquadre" />
|
|
<xs:field xpath="mstns:Data" />
|
|
<xs:field xpath="mstns:CodSquadra" />
|
|
</xs:unique>
|
|
<xs:unique name="v_ImpegniCal_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_ImpegniCal" />
|
|
<xs:field xpath="mstns:IdxImpegno" />
|
|
</xs:unique>
|
|
<xs:unique name="Disponibilita_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Disponibilita" />
|
|
<xs:field xpath="mstns:Data" />
|
|
<xs:field xpath="mstns:CodSquadra" />
|
|
</xs:unique>
|
|
<xs:unique name="DettImpegno_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:DettImpegno" />
|
|
<xs:field xpath="mstns:IdxImpegno" />
|
|
<xs:field xpath="mstns:NumCons" />
|
|
</xs:unique>
|
|
<xs:unique name="v_clientiZone_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_clientiZone" />
|
|
<xs:field xpath="mstns:CodCliente" />
|
|
</xs:unique>
|
|
<xs:unique name="DB2_DOCS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:DB2_DOCS" />
|
|
<xs:field xpath="mstns:NUMERO" />
|
|
</xs:unique>
|
|
<xs:unique name="AssegnSquadre_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AssegnSquadre" />
|
|
<xs:field xpath="mstns:DataFrom" />
|
|
<xs:field xpath="mstns:CodSquadra" />
|
|
<xs:field xpath="mstns:Matr" />
|
|
</xs:unique>
|
|
<xs:unique name="Dipendenti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Dipendenti" />
|
|
<xs:field xpath="mstns:Matr" />
|
|
</xs:unique>
|
|
<xs:unique name="v_resImp_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_resImp" />
|
|
<xs:field xpath="mstns:IdxImpegno" />
|
|
</xs:unique>
|
|
<xs:unique name="AssegnSlotSquadreDip_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AssegnSlotSquadreDip" />
|
|
<xs:field xpath="mstns:Data" />
|
|
<xs:field xpath="mstns:Slot" />
|
|
<xs:field xpath="mstns:CodSquadra" />
|
|
<xs:field xpath="mstns:Matr" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_Disponibilita_AnagSquadre" msdata:parent="AnagSquadre" msdata:child="Disponibilita" msdata:parentkey="CodSquadra" msdata:childkey="CodSquadra" msprop:Generator_UserChildTable="Disponibilita" msprop:Generator_ChildPropName="GetDisponibilitaRows" msprop:Generator_UserRelationName="FK_Disponibilita_AnagSquadre" msprop:Generator_RelationVarName="relationFK_Disponibilita_AnagSquadre" msprop:Generator_UserParentTable="AnagSquadre" msprop:Generator_ParentPropName="AnagSquadreRow" />
|
|
<msdata:Relationship name="FK_AssegnSquadre_Disponibilita" msdata:parent="Disponibilita" msdata:child="AssegnSquadre" msdata:parentkey="Data CodSquadra" msdata:childkey="DataFrom CodSquadra" msprop:Generator_UserChildTable="AssegnSquadre" msprop:Generator_ChildPropName="GetAssegnSquadreRows" msprop:Generator_UserRelationName="FK_AssegnSquadre_Disponibilita" msprop:Generator_ParentPropName="DisponibilitaRowParent" msprop:Generator_RelationVarName="relationFK_AssegnSquadre_Disponibilita" msprop:Generator_UserParentTable="Disponibilita" />
|
|
<msdata:Relationship name="FK_AssegnSquadre_Dipendenti" msdata:parent="Dipendenti" msdata:child="AssegnSquadre" msdata:parentkey="Matr" msdata:childkey="Matr" msprop:Generator_UserChildTable="AssegnSquadre" msprop:Generator_ChildPropName="GetAssegnSquadreRows" msprop:Generator_UserRelationName="FK_AssegnSquadre_Dipendenti" msprop:Generator_RelationVarName="relationFK_AssegnSquadre_Dipendenti" msprop:Generator_UserParentTable="Dipendenti" msprop:Generator_ParentPropName="DipendentiRow" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |