2147 lines
245 KiB
XML
2147 lines
245 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="1" FunctionsComponentName="SP" GeneratorFunctionsComponentClassName="SP" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="SP" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_XPSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_XPSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_XPSConnectionString" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_AnagraficaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_AnagraficaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_AnagraficaConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagClientiTableAdapter" GeneratorDataComponentClassName="AnagClientiTableAdapter" Name="AnagClienti" UserDataComponentName="AnagClientiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.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 ((@IsNull_RagioneSociale = 1 AND [RagioneSociale] IS NULL) OR ([RagioneSociale] = @Original_RagioneSociale)) AND ((@IsNull_piva = 1 AND [piva] IS NULL) OR ([piva] = @Original_piva)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_indirizzo = 1 AND [indirizzo] IS NULL) OR ([indirizzo] = @Original_indirizzo)) 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_provincia = 1 AND [provincia] IS NULL) OR ([provincia] = @Original_provincia)))</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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RagioneSociale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RagioneSociale" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RagioneSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagioneSociale" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_piva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="piva" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_piva" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="piva" 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_indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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_provincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="provincia" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="provincia" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagClienti] ([CodCliente], [RagioneSociale], [piva], [email], [indirizzo], [cap], [localita], [provincia]) VALUES (@CodCliente, @RagioneSociale, @piva, @email, @indirizzo, @cap, @localita, @provincia);
|
|
SELECT CodCliente, RagioneSociale, piva, email, indirizzo, cap, localita, provincia 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="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RagioneSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagioneSociale" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@piva" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="piva" 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="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@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="@provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="provincia" 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, [RagioneSociale] = @RagioneSociale, [piva] = @piva, [email] = @email, [indirizzo] = @indirizzo, [cap] = @cap, [localita] = @localita, [provincia] = @provincia WHERE (([CodCliente] = @Original_CodCliente) AND ((@IsNull_RagioneSociale = 1 AND [RagioneSociale] IS NULL) OR ([RagioneSociale] = @Original_RagioneSociale)) AND ((@IsNull_piva = 1 AND [piva] IS NULL) OR ([piva] = @Original_piva)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_indirizzo = 1 AND [indirizzo] IS NULL) OR ([indirizzo] = @Original_indirizzo)) 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_provincia = 1 AND [provincia] IS NULL) OR ([provincia] = @Original_provincia)));
|
|
SELECT CodCliente, RagioneSociale, piva, email, indirizzo, cap, localita, provincia 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="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RagioneSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagioneSociale" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@piva" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="piva" 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="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@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="@provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="provincia" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RagioneSociale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RagioneSociale" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RagioneSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RagioneSociale" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_piva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="piva" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_piva" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="piva" 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_indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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_provincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="provincia" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="provincia" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="RagioneSociale" DataSetColumn="RagioneSociale" />
|
|
<Mapping SourceColumn="piva" DataSetColumn="piva" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="indirizzo" DataSetColumn="indirizzo" />
|
|
<Mapping SourceColumn="cap" DataSetColumn="cap" />
|
|
<Mapping SourceColumn="localita" DataSetColumn="localita" />
|
|
<Mapping SourceColumn="provincia" DataSetColumn="provincia" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_AnagCliGetByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GeneratorSourceName="FillBy" 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_AnagCliGetByKey</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="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_AnagCliUpdateEmail" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateEmail" Modifier="Public" Name="UpdateEmail" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateEmail">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AnagCliUpdateEmail</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_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="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_AnagCliUpdate" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="updateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AnagCliUpdate</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_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="@RagioneSociale" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@piva" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@indirizzo" 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="5" 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="@provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagTrattamentiTableAdapter" GeneratorDataComponentClassName="AnagTrattamentiTableAdapter" Name="AnagTrattamenti" UserDataComponentName="AnagTrattamentiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.AnagTrattamenti" 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].[AnagTrattamenti] WHERE (([CodTrattamento] = @Original_CodTrattamento) AND ((@IsNull_DescrTrattamento = 1 AND [DescrTrattamento] IS NULL) OR ([DescrTrattamento] = @Original_DescrTrattamento)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrTrattamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrTrattamento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTrattamento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagTrattamenti] ([CodTrattamento], [DescrTrattamento]) VALUES (@CodTrattamento, @DescrTrattamento);
|
|
SELECT CodTrattamento, DescrTrattamento FROM AnagTrattamenti WHERE (CodTrattamento = @CodTrattamento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTrattamento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodTrattamento, DescrTrattamento FROM dbo.AnagTrattamenti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagTrattamenti] SET [CodTrattamento] = @CodTrattamento, [DescrTrattamento] = @DescrTrattamento WHERE (([CodTrattamento] = @Original_CodTrattamento) AND ((@IsNull_DescrTrattamento = 1 AND [DescrTrattamento] IS NULL) OR ([DescrTrattamento] = @Original_DescrTrattamento)));
|
|
SELECT CodTrattamento, DescrTrattamento FROM AnagTrattamenti WHERE (CodTrattamento = @CodTrattamento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTrattamento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrTrattamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrTrattamento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrTrattamento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodTrattamento" DataSetColumn="CodTrattamento" />
|
|
<Mapping SourceColumn="DescrTrattamento" DataSetColumn="DescrTrattamento" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tratt2ObjTableAdapter" GeneratorDataComponentClassName="Tratt2ObjTableAdapter" Name="Tratt2Obj" UserDataComponentName="Tratt2ObjTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Tratt2Obj" 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].[Tratt2Obj] WHERE (([IdxObj] = @Original_IdxObj) AND ([CodTrattamento] = @Original_CodTrattamento) 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_IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" 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].[Tratt2Obj] ([IdxObj], [CodTrattamento], [Note]) VALUES (@IdxObj, @CodTrattamento, @Note);
|
|
SELECT IdxObj, CodTrattamento, Note FROM Tratt2Obj WHERE (CodTrattamento = @CodTrattamento) AND (IdxObj = @IdxObj)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" 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="false">
|
|
<CommandText>SELECT IdxObj, CodTrattamento, Note FROM dbo.Tratt2Obj</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Tratt2Obj] SET [IdxObj] = @IdxObj, [CodTrattamento] = @CodTrattamento, [Note] = @Note WHERE (([IdxObj] = @Original_IdxObj) AND ([CodTrattamento] = @Original_CodTrattamento) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)));
|
|
SELECT IdxObj, CodTrattamento, Note FROM Tratt2Obj WHERE (CodTrattamento = @CodTrattamento) AND (IdxObj = @IdxObj)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" 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_IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTrattamento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTrattamento" 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="IdxObj" DataSetColumn="IdxObj" />
|
|
<Mapping SourceColumn="CodTrattamento" DataSetColumn="CodTrattamento" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_commesseTableAdapter" GeneratorDataComponentClassName="v_commesseTableAdapter" Name="v_commesse" UserDataComponentName="v_commesseTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_commesse" 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_commesse ORDER BY DataArrivo DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Cod" DataSetColumn="Cod" />
|
|
<Mapping SourceColumn="Stato" DataSetColumn="Stato" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="Cliente" DataSetColumn="Cliente" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="DDT" DataSetColumn="DDT" />
|
|
<Mapping SourceColumn="DataDDT" DataSetColumn="DataDDT" />
|
|
<Mapping SourceColumn="DataArrivo" DataSetColumn="DataArrivo" />
|
|
<Mapping SourceColumn="Posizione" DataSetColumn="Posizione" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="Righe" DataSetColumn="Righe" />
|
|
<Mapping SourceColumn="Colli" DataSetColumn="Colli" />
|
|
<Mapping SourceColumn="DataPrevista" DataSetColumn="DataPrevista" />
|
|
<Mapping SourceColumn="Ciclo" DataSetColumn="Ciclo" />
|
|
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
|
|
<Mapping SourceColumn="minStato" DataSetColumn="minStato" />
|
|
<Mapping SourceColumn="maxStato" DataSetColumn="maxStato" />
|
|
<Mapping SourceColumn="minCodStato" DataSetColumn="minCodStato" />
|
|
<Mapping SourceColumn="maxCodStato" DataSetColumn="maxCodStato" />
|
|
<Mapping SourceColumn="emailReq" DataSetColumn="emailReq" />
|
|
<Mapping SourceColumn="emailSent" DataSetColumn="emailSent" />
|
|
<Mapping SourceColumn="Priority" DataSetColumn="Priority" />
|
|
<Mapping SourceColumn="Confirmed" DataSetColumn="Confirmed" />
|
|
<Mapping SourceColumn="NumNote" DataSetColumn="NumNote" />
|
|
<Mapping SourceColumn="NumClos" DataSetColumn="NumClos" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vElComm_getByCod" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCod" GetMethodModifier="Public" GetMethodName="getByCod" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCod" UserSourceName="getByCod">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vElComm_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="@Cod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vElComm_getByCodFiltro" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodFiltro" GetMethodModifier="Public" GetMethodName="getByCodFiltro" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodFiltro" UserSourceName="getByCodFiltro">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vElComm_getByCodFiltro</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="@CodFiltro" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataFiltro" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataFiltroTo" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vElComm_getLastDD" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getLastDD" GetMethodModifier="Public" GetMethodName="getLastDD" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getLastDD" UserSourceName="getLastDD">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vElComm_getLastDD</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="@numDD" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_creaSetObj" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_creaSetObj" Modifier="Public" Name="sp_creaSetObj" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_creaSetObj">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_creaSetObj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodSet" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@NumDDT" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataDDT" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@note" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@emailReq" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_delObj" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_delObj" Modifier="Public" Name="sp_delObj" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="sp_delObj">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_delObj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cod" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObjUpdateMag" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateMag" Modifier="Public" Name="updateMag" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateMag">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObjUpdateMag</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_Cod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" 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="@Ciclo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataDDT" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DDT" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IstObjTableAdapter" GeneratorDataComponentClassName="IstObjTableAdapter" Name="IstObj" UserDataComponentName="IstObjTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_IstObj" 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_IstObj</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
|
|
<Mapping SourceColumn="Posizione" DataSetColumn="Posizione" />
|
|
<Mapping SourceColumn="Livello" DataSetColumn="Livello" />
|
|
<Mapping SourceColumn="Rev" DataSetColumn="Rev" />
|
|
<Mapping SourceColumn="CodObj" DataSetColumn="CodObj" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="DataRif" DataSetColumn="DataRif" />
|
|
<Mapping SourceColumn="IdxObjMamma" DataSetColumn="IdxObjMamma" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="ExtKey" DataSetColumn="ExtKey" />
|
|
<Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
|
|
<Mapping SourceColumn="LeadTime" DataSetColumn="LeadTime" />
|
|
<Mapping SourceColumn="LeadTimeUM" DataSetColumn="LeadTimeUM" />
|
|
<Mapping SourceColumn="UserCreaz" DataSetColumn="UserCreaz" />
|
|
<Mapping SourceColumn="DataCreaz" DataSetColumn="DataCreaz" />
|
|
<Mapping SourceColumn="UserMod" DataSetColumn="UserMod" />
|
|
<Mapping SourceColumn="DataMod" DataSetColumn="DataMod" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="emailReq" DataSetColumn="emailReq" />
|
|
<Mapping SourceColumn="emailSent" DataSetColumn="emailSent" />
|
|
<Mapping SourceColumn="PesoEquiv" DataSetColumn="PesoEquiv" />
|
|
<Mapping SourceColumn="Priority" DataSetColumn="Priority" />
|
|
<Mapping SourceColumn="Confirmed" DataSetColumn="Confirmed" />
|
|
<Mapping SourceColumn="NumNote" DataSetColumn="NumNote" />
|
|
<Mapping SourceColumn="IdxObjRoot" DataSetColumn="IdxObjRoot" />
|
|
<Mapping SourceColumn="NumClos" DataSetColumn="NumClos" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_countSisters" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="countSisters" Modifier="Public" Name="countSisters" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="countSisters">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_countSisters</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="@IdxObjMamma" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_getByIdx" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxObj" GetMethodModifier="Public" GetMethodName="getByIdxObj" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxObj" UserSourceName="getByIdxObj">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_getByIdx</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_lastSister" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="lastSister" Modifier="Public" Name="lastSister" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="lastSister">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_lastSister</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="@IdxObjMamma" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updateConf" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateConf" Modifier="Public" Name="updateConf" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateConf">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updateConf</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Confirmed" 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="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updateDueDateULP" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateDueDateULP" Modifier="Public" Name="updateDueDateULP" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updateDueDateULP">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updateDueDateULP</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="@DueDate" 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="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObjCommon" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updateEmailSent" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateEmailSent" Modifier="Public" Name="updateEmailSent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="updateEmailSent">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updateEmailSent</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updatePrior" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updatePrior" Modifier="Public" Name="updatePrior" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="updatePrior">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updatePrior</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Priority" 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="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updateStato" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateStato" Modifier="Public" Name="updateStato" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="updateStato">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updateStato</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodStato" 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="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updateStatoPesoEqTree" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateStatoPesoEqTree" Modifier="Public" Name="updateStatoPesoEqTree" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="updateStatoPesoEqTree">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updateStatoPesoEqTree</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="@CodStato" 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="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObjCommon" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@EqPeso" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updateStatoTree" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateStatoTree" Modifier="Public" Name="updateStatoTree" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="updateStatoTree">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updateStatoTree</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="@CodStato" 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="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObjCommon" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_IstObj_updEmailReq" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updEmailReq" Modifier="Public" Name="updEmailReq" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy9" UserSourceName="updEmailReq">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IstObj_updEmailReq</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@emailReq" 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="@DataMod" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_righeTableAdapter" GeneratorDataComponentClassName="v_righeTableAdapter" Name="v_righe" UserDataComponentName="v_righeTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_righe" 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 Cod, Stato, CodCliente, Cliente, CodCli, descrizione, DDT, DataDDT, DataArrivo, Posizione, Qta, Peso, Colli, DataPrevista, IdxObjMamma, CodStato, minStato, maxStato FROM dbo.v_righe</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Cod" DataSetColumn="Cod" />
|
|
<Mapping SourceColumn="Stato" DataSetColumn="Stato" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="Cliente" DataSetColumn="Cliente" />
|
|
<Mapping SourceColumn="CodCli" DataSetColumn="CodCli" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="DDT" DataSetColumn="DDT" />
|
|
<Mapping SourceColumn="DataDDT" DataSetColumn="DataDDT" />
|
|
<Mapping SourceColumn="DataArrivo" DataSetColumn="DataArrivo" />
|
|
<Mapping SourceColumn="Posizione" DataSetColumn="Posizione" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="Colli" DataSetColumn="Colli" />
|
|
<Mapping SourceColumn="DataPrevista" DataSetColumn="DataPrevista" />
|
|
<Mapping SourceColumn="IdxObjMamma" DataSetColumn="IdxObjMamma" />
|
|
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
|
|
<Mapping SourceColumn="minStato" DataSetColumn="minStato" />
|
|
<Mapping SourceColumn="maxStato" DataSetColumn="maxStato" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_righe" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodMamma" GetMethodModifier="Public" GetMethodName="getByCodMamma" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodMamma" UserSourceName="getByCodMamma">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT Cliente, Cod, CodCli, CodCliente, CodStato, Colli, DDT, DataArrivo, DataDDT, DataPrevista, IdxObjMamma, Peso, Posizione, Qta, Stato, descrizione, maxStato, minStato FROM v_righe WHERE (IdxObjMamma = @CodMamma)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="CodMamma" ColumnName="IdxObjMamma" DataSourceName="Equa_XPS.dbo.v_righe" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodMamma" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="IdxObjMamma" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_clonaRowObj" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_clonaRowObj" Modifier="Public" Name="sp_clonaRowObj" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_clonaRowObj">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_clonaRowObj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@IdxObj_orig" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_delRow" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_delRow" Modifier="Public" Name="sp_delRow" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="sp_delRow">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_delRow</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cod" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>UPDATE IstObj
|
|
SET Note = @descrizione
|
|
WHERE (IdxObj = @Original_Cod)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="descrizione" ColumnName="Note" DataSourceName="Equa_XPS.dbo.IstObj" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_Cod" ColumnName="IdxObj" DataSourceName="Equa_XPS.dbo.IstObj" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_Cod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_rec4DayTableAdapter" GeneratorDataComponentClassName="sp_rec4DayTableAdapter" Name="sp_rec4Day" UserDataComponentName="sp_rec4DayTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_rec4Day" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_rec4Day</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@dayCod" Precision="0" ProviderType="VarChar" Scale="0" Size="6" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="rec4Day" DataSetColumn="rec4Day" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_ULPTableAdapter" GeneratorDataComponentClassName="v_ULPTableAdapter" Name="v_ULP" UserDataComponentName="v_ULPTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_ULP" 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_ULP</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Cod" DataSetColumn="Cod" />
|
|
<Mapping SourceColumn="Stato" DataSetColumn="Stato" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="Cliente" DataSetColumn="Cliente" />
|
|
<Mapping SourceColumn="CodCli" DataSetColumn="CodCli" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="DDT" DataSetColumn="DDT" />
|
|
<Mapping SourceColumn="DataDDT" DataSetColumn="DataDDT" />
|
|
<Mapping SourceColumn="DataArrivo" DataSetColumn="DataArrivo" />
|
|
<Mapping SourceColumn="Posizione" DataSetColumn="Posizione" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="DataPrevista" DataSetColumn="DataPrevista" />
|
|
<Mapping SourceColumn="IdxObjMamma" DataSetColumn="IdxObjMamma" />
|
|
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
|
|
<Mapping SourceColumn="Confirmed" DataSetColumn="Confirmed" />
|
|
<Mapping SourceColumn="Priority" DataSetColumn="Priority" />
|
|
<Mapping SourceColumn="NumNote" DataSetColumn="NumNote" />
|
|
<Mapping SourceColumn="NumClos" DataSetColumn="NumClos" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vULP_getByCodMamma" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodMamma" GetMethodModifier="Public" GetMethodName="getByCodMamma" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodMamma" UserSourceName="getByCodMamma">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vULP_getByCodMamma</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="@CodMamma" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vULP_getByCodStato" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodStato" GetMethodModifier="Public" GetMethodName="getByCodStato" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodStato" UserSourceName="getByCodStato">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vULP_getByCodStato</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="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vULP_getLastDD" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getLastDD" GetMethodModifier="Public" GetMethodName="getLastDD" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getLastDD" UserSourceName="getLastDD">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vULP_getLastDD</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="@numDD" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vULP_getOnlyOnDate" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getOnlyOnDate" GetMethodModifier="Public" GetMethodName="getOnlyOnDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getOnlyOnDate" UserSourceName="getOnlyOnDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vULP_getOnlyOnDate</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="@DataRif" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MaxStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_vULP_getPreDueDate" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getPreDueDate" GetMethodModifier="Public" GetMethodName="getPreDueDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getPreDueDate" UserSourceName="getPreDueDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vULP_getPreDueDate</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="@DataPrevista" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MaxStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_clonaObj" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_clonaObj" Modifier="Public" Name="sp_clonaObj" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_clonaObj">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_clonaObj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@IdxObj_orig" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_delRow" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_delRow" Modifier="Public" Name="sp_delRow" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="sp_delRow">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_delRow</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cod" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vULP_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="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Qta" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@Peso" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataPrevista" 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_Cod" 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="EventiTableAdapter" GeneratorDataComponentClassName="EventiTableAdapter" Name="Eventi" UserDataComponentName="EventiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Eventi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[Eventi] WHERE (([CodEvento] = @Original_CodEvento) AND ((@IsNull_CodTipoEvento = 1 AND [CodTipoEvento] IS NULL) OR ([CodTipoEvento] = @Original_CodTipoEvento)) AND ((@IsNull_DescrEvento = 1 AND [DescrEvento] IS NULL) OR ([DescrEvento] = @Original_DescrEvento)) AND ((@IsNull_Action = 1 AND [Action] IS NULL) OR ([Action] = @Original_Action)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodTipoEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (@CodEvento, @CodTipoEvento, @DescrEvento, @Action);
|
|
SELECT CodEvento, CodTipoEvento, DescrEvento, Action FROM Eventi WHERE (CodEvento = @CodEvento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodEvento, CodTipoEvento, DescrEvento, Action FROM dbo.Eventi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Eventi] SET [CodEvento] = @CodEvento, [CodTipoEvento] = @CodTipoEvento, [DescrEvento] = @DescrEvento, [Action] = @Action WHERE (([CodEvento] = @Original_CodEvento) AND ((@IsNull_CodTipoEvento = 1 AND [CodTipoEvento] IS NULL) OR ([CodTipoEvento] = @Original_CodTipoEvento)) AND ((@IsNull_DescrEvento = 1 AND [DescrEvento] IS NULL) OR ([DescrEvento] = @Original_DescrEvento)) AND ((@IsNull_Action = 1 AND [Action] IS NULL) OR ([Action] = @Original_Action)));
|
|
SELECT CodEvento, CodTipoEvento, DescrEvento, Action FROM Eventi WHERE (CodEvento = @CodEvento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodTipoEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
|
|
<Mapping SourceColumn="CodTipoEvento" DataSetColumn="CodTipoEvento" />
|
|
<Mapping SourceColumn="DescrEvento" DataSetColumn="DescrEvento" />
|
|
<Mapping SourceColumn="Action" DataSetColumn="Action" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.Eventi" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodEvento" GetMethodModifier="Public" GetMethodName="getByCodEvento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodEvento" UserSourceName="getByCodEvento">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DISTINCT Eventi.CodEvento, Eventi.CodTipoEvento, Eventi.DescrEvento, Eventi.Action
|
|
FROM Eventi INNER JOIN
|
|
TraEv2Stati ON Eventi.CodEvento = TraEv2Stati.CodEvento
|
|
WHERE (TraEv2Stati.CodEvento = @CodEvento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CodEvento" ColumnName="CodEvento" DataSourceName="Equa_XPS.dbo.TraEv2Stati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TraEv2StatiTableAdapter" GeneratorDataComponentClassName="TraEv2StatiTableAdapter" Name="TraEv2Stati" UserDataComponentName="TraEv2StatiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.TraEv2Stati" 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].[TraEv2Stati] WHERE (([CodMappa] = @Original_CodMappa) AND ([CodObj] = @Original_CodObj) AND ([CodStato] = @Original_CodStato) AND ([CodEvento] = @Original_CodEvento) AND ((@IsNull_NextCodStato = 1 AND [NextCodStato] IS NULL) OR ([NextCodStato] = @Original_NextCodStato)) AND ((@IsNull_CmdPlugin = 1 AND [CmdPlugin] IS NULL) OR ([CmdPlugin] = @Original_CmdPlugin)) AND ((@IsNull_text2show = 1 AND [text2show] IS NULL) OR ([text2show] = @Original_text2show)) AND ((@IsNull_descrComando = 1 AND [descrComando] IS NULL) OR ([descrComando] = @Original_descrComando)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NextCodStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NextCodStato" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NextCodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NextCodStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CmdPlugin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CmdPlugin" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CmdPlugin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CmdPlugin" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_text2show" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="text2show" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_text2show" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="text2show" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrComando" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrComando" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrComando" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrComando" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (@CodMappa, @CodObj, @CodStato, @CodEvento, @NextCodStato, @CmdPlugin, @text2show, @descrComando);
|
|
SELECT CodMappa, CodObj, CodStato, CodEvento, NextCodStato, CmdPlugin, text2show, descrComando FROM TraEv2Stati WHERE (CodEvento = @CodEvento) AND (CodMappa = @CodMappa) AND (CodObj = @CodObj) AND (CodStato = @CodStato)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NextCodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NextCodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CmdPlugin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CmdPlugin" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@text2show" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="text2show" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrComando" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrComando" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodMappa, CodObj, CodStato, CodEvento, NextCodStato, CmdPlugin, text2show, descrComando FROM dbo.TraEv2Stati</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[TraEv2Stati] SET [CodMappa] = @CodMappa, [CodObj] = @CodObj, [CodStato] = @CodStato, [CodEvento] = @CodEvento, [NextCodStato] = @NextCodStato, [CmdPlugin] = @CmdPlugin, [text2show] = @text2show, [descrComando] = @descrComando WHERE (([CodMappa] = @Original_CodMappa) AND ([CodObj] = @Original_CodObj) AND ([CodStato] = @Original_CodStato) AND ([CodEvento] = @Original_CodEvento) AND ((@IsNull_NextCodStato = 1 AND [NextCodStato] IS NULL) OR ([NextCodStato] = @Original_NextCodStato)) AND ((@IsNull_CmdPlugin = 1 AND [CmdPlugin] IS NULL) OR ([CmdPlugin] = @Original_CmdPlugin)) AND ((@IsNull_text2show = 1 AND [text2show] IS NULL) OR ([text2show] = @Original_text2show)) AND ((@IsNull_descrComando = 1 AND [descrComando] IS NULL) OR ([descrComando] = @Original_descrComando)));
|
|
SELECT CodMappa, CodObj, CodStato, CodEvento, NextCodStato, CmdPlugin, text2show, descrComando FROM TraEv2Stati WHERE (CodEvento = @CodEvento) AND (CodMappa = @CodMappa) AND (CodObj = @CodObj) AND (CodStato = @CodStato)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NextCodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NextCodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CmdPlugin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CmdPlugin" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@text2show" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="text2show" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrComando" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrComando" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NextCodStato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NextCodStato" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NextCodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NextCodStato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CmdPlugin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CmdPlugin" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CmdPlugin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CmdPlugin" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_text2show" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="text2show" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_text2show" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="text2show" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrComando" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrComando" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrComando" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrComando" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodMappa" DataSetColumn="CodMappa" />
|
|
<Mapping SourceColumn="CodObj" DataSetColumn="CodObj" />
|
|
<Mapping SourceColumn="CodStato" DataSetColumn="CodStato" />
|
|
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
|
|
<Mapping SourceColumn="NextCodStato" DataSetColumn="NextCodStato" />
|
|
<Mapping SourceColumn="CmdPlugin" DataSetColumn="CmdPlugin" />
|
|
<Mapping SourceColumn="text2show" DataSetColumn="text2show" />
|
|
<Mapping SourceColumn="descrComando" DataSetColumn="descrComando" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.TraEv2Stati" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodMappa" GetMethodModifier="Public" GetMethodName="getByCodMappa" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodMappa" UserSourceName="getByCodMappa">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT CodMappa, CodObj, CodStato, CodEvento, NextCodStato, CmdPlugin, text2show, descrComando FROM dbo.TraEv2Stati
|
|
where CodMappa=@CodMappa</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CodMappa" ColumnName="CodMappa" DataSourceName="Equa_XPS.dbo.TraEv2Stati" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.TraEv2Stati" DbObjectType="Table" 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="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT CodMappa, CodObj, CodStato, CodEvento, NextCodStato, CmdPlugin, text2show, descrComando
|
|
FROM TraEv2Stati
|
|
WHERE (CodMappa = @CodMappa) AND (CodObj = @CodObj) AND (CodStato = @CodStato) AND (CodEvento = @CodEvento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CodMappa" ColumnName="CodMappa" DataSourceName="Equa_XPS.dbo.TraEv2Stati" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@CodMappa" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="CodMappa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CodObj" ColumnName="CodObj" DataSourceName="Equa_XPS.dbo.TraEv2Stati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodObj" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CodStato" ColumnName="CodStato" DataSourceName="Equa_XPS.dbo.TraEv2Stati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodStato" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodStato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CodEvento" ColumnName="CodEvento" DataSourceName="Equa_XPS.dbo.TraEv2Stati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_logStatiTableAdapter" GeneratorDataComponentClassName="v_logStatiTableAdapter" Name="v_logStati" UserDataComponentName="v_logStatiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_logStati" 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 IdxObj, CodCliente, Nome, DataRif, Note, ExtKey, DataOra, DescrStato FROM dbo.v_logStati</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="DataRif" DataSetColumn="DataRif" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="ExtKey" DataSetColumn="ExtKey" />
|
|
<Mapping SourceColumn="DataOra" DataSetColumn="DataOra" />
|
|
<Mapping SourceColumn="DescrStato" DataSetColumn="DescrStato" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_logStati" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxObj" GetMethodModifier="Public" GetMethodName="getByIdxObj" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxObj" UserSourceName="getByIdxObj">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT IdxObj, CodCliente, Nome, DataRif, Note, ExtKey, DataOra, DescrStato
|
|
FROM v_logStati
|
|
WHERE (IdxObj = @IdxObj)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="IdxObj" ColumnName="IdxObj" DataSourceName="Equa_XPS.dbo.v_logStati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="IdxObj" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_contaNonSchedTableAdapter" GeneratorDataComponentClassName="sp_contaNonSchedTableAdapter" Name="sp_contaNonSched" UserDataComponentName="sp_contaNonSchedTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_contaNonSched" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_contaNonSched</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@codComune" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="quanti" DataSetColumn="quanti" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_schedaIdentTableAdapter" GeneratorDataComponentClassName="sp_schedaIdentTableAdapter" Name="sp_schedaIdent" UserDataComponentName="sp_schedaIdentTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_schedaIdent" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_schedaIdent</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
|
|
<Mapping SourceColumn="Cliente" DataSetColumn="Cliente" />
|
|
<Mapping SourceColumn="DDT" DataSetColumn="DDT" />
|
|
<Mapping SourceColumn="DDT_del" DataSetColumn="DDT_del" />
|
|
<Mapping SourceColumn="DataArrivo" DataSetColumn="DataArrivo" />
|
|
<Mapping SourceColumn="CodProdotto" DataSetColumn="CodProdotto" />
|
|
<Mapping SourceColumn="ConsegnaPrevista" DataSetColumn="ConsegnaPrevista" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="FosfManganese" DataSetColumn="FosfManganese" />
|
|
<Mapping SourceColumn="Brunitura" DataSetColumn="Brunitura" />
|
|
<Mapping SourceColumn="FosfTeflon" DataSetColumn="FosfTeflon" />
|
|
<Mapping SourceColumn="Sabbiatura" DataSetColumn="Sabbiatura" />
|
|
<Mapping SourceColumn="F1" DataSetColumn="F1" />
|
|
<Mapping SourceColumn="F2" DataSetColumn="F2" />
|
|
<Mapping SourceColumn="FosfZinco" DataSetColumn="FosfZinco" />
|
|
<Mapping SourceColumn="Teflon" DataSetColumn="Teflon" />
|
|
<Mapping SourceColumn="FosfPreVern" DataSetColumn="FosfPreVern" />
|
|
<Mapping SourceColumn="PzRoto" DataSetColumn="PzRoto" />
|
|
<Mapping SourceColumn="Zinchlorex" DataSetColumn="Zinchlorex" />
|
|
<Mapping SourceColumn="PeekVicote" DataSetColumn="PeekVicote" />
|
|
<Mapping SourceColumn="CodCli" DataSetColumn="CodCli" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_ddtTableAdapter" GeneratorDataComponentClassName="sp_ddtTableAdapter" Name="sp_ddt" UserDataComponentName="sp_ddtTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_ddt" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_ddt</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
|
|
<Mapping SourceColumn="DataCreaz" DataSetColumn="DataCreaz" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImpegniSchedulatiTableAdapter" GeneratorDataComponentClassName="ImpegniSchedulatiTableAdapter" Name="ImpegniSchedulati" UserDataComponentName="ImpegniSchedulatiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_impegniSchedulati" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_impegniSchedulati</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="@IdxLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
|
|
<Mapping SourceColumn="IdxLav" DataSetColumn="IdxLav" />
|
|
<Mapping SourceColumn="TotPeso" DataSetColumn="TotPeso" />
|
|
<Mapping SourceColumn="TotPesoEquiv" DataSetColumn="TotPesoEquiv" />
|
|
<Mapping SourceColumn="RatioUnit" DataSetColumn="RatioUnit" />
|
|
<Mapping SourceColumn="NumUnit" DataSetColumn="NumUnit" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagLavTableAdapter" GeneratorDataComponentClassName="AnagLavTableAdapter" Name="AnagLav" UserDataComponentName="AnagLavTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.AnagLav" 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].[AnagLav] WHERE (([IdxLav] = @Original_IdxLav) AND ((@IsNull_DescrLav = 1 AND [DescrLav] IS NULL) OR ([DescrLav] = @Original_DescrLav)) AND ([PesoUnit] = @Original_PesoUnit) AND ([RoundVal] = @Original_RoundVal))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxLav" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrLav" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrLav" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrLav" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PesoUnit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PesoUnit" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_RoundVal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RoundVal" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagLav] ([IdxLav], [DescrLav], [PesoUnit], [RoundVal]) VALUES (@IdxLav, @DescrLav, @PesoUnit, @RoundVal);
|
|
SELECT IdxLav, DescrLav, PesoUnit, RoundVal FROM AnagLav WHERE (IdxLav = @IdxLav)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxLav" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrLav" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PesoUnit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PesoUnit" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RoundVal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RoundVal" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT IdxLav, DescrLav, PesoUnit, RoundVal FROM dbo.AnagLav</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagLav] SET [IdxLav] = @IdxLav, [DescrLav] = @DescrLav, [PesoUnit] = @PesoUnit, [RoundVal] = @RoundVal WHERE (([IdxLav] = @Original_IdxLav) AND ((@IsNull_DescrLav = 1 AND [DescrLav] IS NULL) OR ([DescrLav] = @Original_DescrLav)) AND ([PesoUnit] = @Original_PesoUnit) AND ([RoundVal] = @Original_RoundVal));
|
|
SELECT IdxLav, DescrLav, PesoUnit, RoundVal FROM AnagLav WHERE (IdxLav = @IdxLav)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxLav" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescrLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrLav" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PesoUnit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PesoUnit" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RoundVal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RoundVal" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxLav" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescrLav" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescrLav" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescrLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescrLav" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PesoUnit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PesoUnit" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_RoundVal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RoundVal" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxLav" DataSetColumn="IdxLav" />
|
|
<Mapping SourceColumn="DescrLav" DataSetColumn="DescrLav" />
|
|
<Mapping SourceColumn="PesoUnit" DataSetColumn="PesoUnit" />
|
|
<Mapping SourceColumn="RoundVal" DataSetColumn="RoundVal" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_AnagLav" 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_AnagLav</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="@IdxLav" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.sp_updateAncestorState" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_updateAncestorState" MethodsParameterType="CLR" Modifier="Public" Name="sp_updateAncestorState" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_updateAncestorState">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_updateAncestorState</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@idxObjCommon" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</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="AnagClienti" msprop:Generator_UserTableName="AnagClienti" msprop:Generator_RowEvArgName="AnagClientiRowChangeEvent" msprop:Generator_TableVarName="tableAnagClienti" msprop:Generator_TablePropName="AnagClienti" msprop:Generator_RowDeletingName="AnagClientiRowDeleting" msprop:Generator_RowChangingName="AnagClientiRowChanging" msprop:Generator_RowDeletedName="AnagClientiRowDeleted" msprop:Generator_RowEvHandlerName="AnagClientiRowChangeEventHandler" msprop:Generator_TableClassName="AnagClientiDataTable" msprop:Generator_RowChangedName="AnagClientiRowChanged" msprop:Generator_RowClassName="AnagClientiRow">
|
|
<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="RagioneSociale" msprop:Generator_ColumnVarNameInTable="columnRagioneSociale" msprop:Generator_ColumnPropNameInRow="RagioneSociale" msprop:Generator_ColumnPropNameInTable="RagioneSocialeColumn" msprop:Generator_UserColumnName="RagioneSociale" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="piva" msprop:Generator_ColumnVarNameInTable="columnpiva" msprop:Generator_ColumnPropNameInRow="piva" msprop:Generator_ColumnPropNameInTable="pivaColumn" msprop:Generator_UserColumnName="piva" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="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="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="indirizzo" msprop:Generator_ColumnVarNameInTable="columnindirizzo" msprop:Generator_ColumnPropNameInRow="indirizzo" msprop:Generator_ColumnPropNameInTable="indirizzoColumn" msprop:Generator_UserColumnName="indirizzo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="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="5" />
|
|
</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="provincia" msprop:Generator_ColumnVarNameInTable="columnprovincia" msprop:Generator_ColumnPropNameInRow="provincia" msprop:Generator_ColumnPropNameInTable="provinciaColumn" msprop:Generator_UserColumnName="provincia" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagTrattamenti" msprop:Generator_UserTableName="AnagTrattamenti" msprop:Generator_RowEvArgName="AnagTrattamentiRowChangeEvent" msprop:Generator_TableVarName="tableAnagTrattamenti" msprop:Generator_TablePropName="AnagTrattamenti" msprop:Generator_RowDeletingName="AnagTrattamentiRowDeleting" msprop:Generator_RowChangingName="AnagTrattamentiRowChanging" msprop:Generator_RowDeletedName="AnagTrattamentiRowDeleted" msprop:Generator_RowEvHandlerName="AnagTrattamentiRowChangeEventHandler" msprop:Generator_TableClassName="AnagTrattamentiDataTable" msprop:Generator_RowChangedName="AnagTrattamentiRowChanged" msprop:Generator_RowClassName="AnagTrattamentiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodTrattamento" msprop:Generator_ColumnVarNameInTable="columnCodTrattamento" msprop:Generator_ColumnPropNameInRow="CodTrattamento" msprop:Generator_ColumnPropNameInTable="CodTrattamentoColumn" msprop:Generator_UserColumnName="CodTrattamento">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrTrattamento" msprop:Generator_ColumnVarNameInTable="columnDescrTrattamento" msprop:Generator_ColumnPropNameInRow="DescrTrattamento" msprop:Generator_ColumnPropNameInTable="DescrTrattamentoColumn" msprop:Generator_UserColumnName="DescrTrattamento" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Tratt2Obj" msprop:Generator_UserTableName="Tratt2Obj" msprop:Generator_RowEvArgName="Tratt2ObjRowChangeEvent" msprop:Generator_TableVarName="tableTratt2Obj" msprop:Generator_TablePropName="Tratt2Obj" msprop:Generator_RowDeletingName="Tratt2ObjRowDeleting" msprop:Generator_RowChangingName="Tratt2ObjRowChanging" msprop:Generator_RowDeletedName="Tratt2ObjRowDeleted" msprop:Generator_RowEvHandlerName="Tratt2ObjRowChangeEventHandler" msprop:Generator_TableClassName="Tratt2ObjDataTable" msprop:Generator_RowChangedName="Tratt2ObjRowChanged" msprop:Generator_RowClassName="Tratt2ObjRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodTrattamento" msprop:Generator_ColumnVarNameInTable="columnCodTrattamento" msprop:Generator_ColumnPropNameInRow="CodTrattamento" msprop:Generator_ColumnPropNameInTable="CodTrattamentoColumn" msprop:Generator_UserColumnName="CodTrattamento">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_commesse" msprop:Generator_UserTableName="v_commesse" msprop:Generator_RowEvArgName="v_commesseRowChangeEvent" msprop:Generator_TableVarName="tablev_commesse" msprop:Generator_TablePropName="v_commesse" msprop:Generator_RowDeletingName="v_commesseRowDeleting" msprop:Generator_RowChangingName="v_commesseRowChanging" msprop:Generator_RowDeletedName="v_commesseRowDeleted" msprop:Generator_RowEvHandlerName="v_commesseRowChangeEventHandler" msprop:Generator_TableClassName="v_commesseDataTable" msprop:Generator_RowChangedName="v_commesseRowChanged" msprop:Generator_RowClassName="v_commesseRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Cod" msprop:Generator_ColumnVarNameInTable="columnCod" msprop:Generator_ColumnPropNameInRow="Cod" msprop:Generator_ColumnPropNameInTable="CodColumn" msprop:Generator_UserColumnName="Cod">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Stato" 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="50" />
|
|
</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="Cliente" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" msprop:Generator_UserColumnName="Cliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrizione" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT" msprop:Generator_ColumnVarNameInTable="columnDDT" msprop:Generator_ColumnPropNameInRow="DDT" msprop:Generator_ColumnPropNameInTable="DDTColumn" msprop:Generator_UserColumnName="DDT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataDDT" msprop:Generator_ColumnVarNameInTable="columnDataDDT" msprop:Generator_ColumnPropNameInRow="DataDDT" msprop:Generator_ColumnPropNameInTable="DataDDTColumn" msprop:Generator_UserColumnName="DataDDT" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataArrivo" msprop:Generator_ColumnVarNameInTable="columnDataArrivo" msprop:Generator_ColumnPropNameInRow="DataArrivo" msprop:Generator_ColumnPropNameInTable="DataArrivoColumn" msprop:Generator_UserColumnName="DataArrivo" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Posizione" msprop:Generator_ColumnVarNameInTable="columnPosizione" msprop:Generator_ColumnPropNameInRow="Posizione" msprop:Generator_ColumnPropNameInTable="PosizioneColumn" msprop:Generator_UserColumnName="Posizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Qta" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Peso" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_UserColumnName="Peso" type="xs:double" minOccurs="0" />
|
|
<xs:element name="Righe" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRighe" msprop:Generator_ColumnPropNameInRow="Righe" msprop:Generator_ColumnPropNameInTable="RigheColumn" msprop:Generator_UserColumnName="Righe" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Colli" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnColli" msprop:Generator_ColumnPropNameInRow="Colli" msprop:Generator_ColumnPropNameInTable="ColliColumn" msprop:Generator_UserColumnName="Colli" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DataPrevista" msprop:Generator_ColumnVarNameInTable="columnDataPrevista" msprop:Generator_ColumnPropNameInRow="DataPrevista" msprop:Generator_ColumnPropNameInTable="DataPrevistaColumn" msprop:Generator_UserColumnName="DataPrevista" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Ciclo" msprop:Generator_ColumnVarNameInTable="columnCiclo" msprop:Generator_ColumnPropNameInRow="Ciclo" msprop:Generator_ColumnPropNameInTable="CicloColumn" msprop:Generator_UserColumnName="Ciclo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="minStato" msprop:Generator_ColumnVarNameInTable="columnminStato" msprop:Generator_ColumnPropNameInRow="minStato" msprop:Generator_ColumnPropNameInTable="minStatoColumn" msprop:Generator_UserColumnName="minStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="maxStato" msprop:Generator_ColumnVarNameInTable="columnmaxStato" msprop:Generator_ColumnPropNameInRow="maxStato" msprop:Generator_ColumnPropNameInTable="maxStatoColumn" msprop:Generator_UserColumnName="maxStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="minCodStato" msprop:Generator_ColumnVarNameInTable="columnminCodStato" msprop:Generator_ColumnPropNameInRow="minCodStato" msprop:Generator_ColumnPropNameInTable="minCodStatoColumn" msprop:Generator_UserColumnName="minCodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="maxCodStato" msprop:Generator_ColumnVarNameInTable="columnmaxCodStato" msprop:Generator_ColumnPropNameInRow="maxCodStato" msprop:Generator_ColumnPropNameInTable="maxCodStatoColumn" msprop:Generator_UserColumnName="maxCodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="emailReq" msprop:Generator_ColumnVarNameInTable="columnemailReq" msprop:Generator_ColumnPropNameInRow="emailReq" msprop:Generator_ColumnPropNameInTable="emailReqColumn" msprop:Generator_UserColumnName="emailReq" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="emailSent" msprop:Generator_ColumnVarNameInTable="columnemailSent" msprop:Generator_ColumnPropNameInRow="emailSent" msprop:Generator_ColumnPropNameInTable="emailSentColumn" msprop:Generator_UserColumnName="emailSent" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" msprop:Generator_UserColumnName="Priority" type="xs:boolean" />
|
|
<xs:element name="Confirmed" msprop:Generator_ColumnVarNameInTable="columnConfirmed" msprop:Generator_ColumnPropNameInRow="Confirmed" msprop:Generator_ColumnPropNameInTable="ConfirmedColumn" msprop:Generator_UserColumnName="Confirmed" type="xs:boolean" />
|
|
<xs:element name="NumNote" msprop:Generator_ColumnVarNameInTable="columnNumNote" msprop:Generator_ColumnPropNameInRow="NumNote" msprop:Generator_ColumnPropNameInTable="NumNoteColumn" msprop:Generator_UserColumnName="NumNote" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumClos" msprop:Generator_ColumnVarNameInTable="columnNumClos" msprop:Generator_ColumnPropNameInRow="NumClos" msprop:Generator_ColumnPropNameInTable="NumClosColumn" msprop:Generator_UserColumnName="NumClos" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="IstObj" msprop:Generator_UserTableName="IstObj" msprop:Generator_RowEvArgName="IstObjRowChangeEvent" msprop:Generator_TableVarName="tableIstObj" msprop:Generator_TablePropName="IstObj" msprop:Generator_RowDeletingName="IstObjRowDeleting" msprop:Generator_RowChangingName="IstObjRowChanging" msprop:Generator_RowDeletedName="IstObjRowDeleted" msprop:Generator_RowEvHandlerName="IstObjRowChangeEventHandler" msprop:Generator_TableClassName="IstObjDataTable" msprop:Generator_RowChangedName="IstObjRowChanged" msprop:Generator_RowClassName="IstObjRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliente" 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="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Posizione" msprop:Generator_ColumnVarNameInTable="columnPosizione" msprop:Generator_ColumnPropNameInRow="Posizione" msprop:Generator_ColumnPropNameInTable="PosizioneColumn" msprop:Generator_UserColumnName="Posizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Livello" msprop:Generator_ColumnVarNameInTable="columnLivello" msprop:Generator_ColumnPropNameInRow="Livello" msprop:Generator_ColumnPropNameInTable="LivelloColumn" msprop:Generator_UserColumnName="Livello" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Rev" msprop:Generator_ColumnVarNameInTable="columnRev" msprop:Generator_ColumnPropNameInRow="Rev" msprop:Generator_ColumnPropNameInTable="RevColumn" msprop:Generator_UserColumnName="Rev" type="xs:int" minOccurs="0" />
|
|
<xs:element name="CodObj" msprop:Generator_ColumnVarNameInTable="columnCodObj" msprop:Generator_ColumnPropNameInRow="CodObj" msprop:Generator_ColumnPropNameInTable="CodObjColumn" msprop:Generator_UserColumnName="CodObj" minOccurs="0">
|
|
<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" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataRif" msprop:Generator_ColumnVarNameInTable="columnDataRif" msprop:Generator_ColumnPropNameInRow="DataRif" msprop:Generator_ColumnPropNameInTable="DataRifColumn" msprop:Generator_UserColumnName="DataRif" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="IdxObjMamma" msprop:Generator_ColumnVarNameInTable="columnIdxObjMamma" msprop:Generator_ColumnPropNameInRow="IdxObjMamma" msprop:Generator_ColumnPropNameInTable="IdxObjMammaColumn" msprop:Generator_UserColumnName="IdxObjMamma" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ExtKey" msprop:Generator_ColumnVarNameInTable="columnExtKey" msprop:Generator_ColumnPropNameInRow="ExtKey" msprop:Generator_ColumnPropNameInTable="ExtKeyColumn" msprop:Generator_UserColumnName="ExtKey" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="LeadTime" msprop:Generator_ColumnVarNameInTable="columnLeadTime" msprop:Generator_ColumnPropNameInRow="LeadTime" msprop:Generator_ColumnPropNameInTable="LeadTimeColumn" msprop:Generator_UserColumnName="LeadTime" type="xs:double" minOccurs="0" />
|
|
<xs:element name="LeadTimeUM" msprop:Generator_ColumnVarNameInTable="columnLeadTimeUM" msprop:Generator_ColumnPropNameInRow="LeadTimeUM" msprop:Generator_ColumnPropNameInTable="LeadTimeUMColumn" msprop:Generator_UserColumnName="LeadTimeUM" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UserCreaz" msprop:Generator_ColumnVarNameInTable="columnUserCreaz" msprop:Generator_ColumnPropNameInRow="UserCreaz" msprop:Generator_ColumnPropNameInTable="UserCreazColumn" msprop:Generator_UserColumnName="UserCreaz" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataCreaz" msprop:Generator_ColumnVarNameInTable="columnDataCreaz" msprop:Generator_ColumnPropNameInRow="DataCreaz" msprop:Generator_ColumnPropNameInTable="DataCreazColumn" msprop:Generator_UserColumnName="DataCreaz" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="UserMod" msprop:Generator_ColumnVarNameInTable="columnUserMod" msprop:Generator_ColumnPropNameInRow="UserMod" msprop:Generator_ColumnPropNameInTable="UserModColumn" msprop:Generator_UserColumnName="UserMod" minOccurs="0">
|
|
<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" minOccurs="0" />
|
|
<xs:element name="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Peso" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_UserColumnName="Peso" type="xs:double" minOccurs="0" />
|
|
<xs:element name="emailReq" msprop:Generator_ColumnVarNameInTable="columnemailReq" msprop:Generator_ColumnPropNameInRow="emailReq" msprop:Generator_ColumnPropNameInTable="emailReqColumn" msprop:Generator_UserColumnName="emailReq" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="emailSent" msprop:Generator_ColumnVarNameInTable="columnemailSent" msprop:Generator_ColumnPropNameInRow="emailSent" msprop:Generator_ColumnPropNameInTable="emailSentColumn" msprop:Generator_UserColumnName="emailSent" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="PesoEquiv" msprop:Generator_ColumnVarNameInTable="columnPesoEquiv" msprop:Generator_ColumnPropNameInRow="PesoEquiv" msprop:Generator_ColumnPropNameInTable="PesoEquivColumn" msprop:Generator_UserColumnName="PesoEquiv" type="xs:double" minOccurs="0" />
|
|
<xs:element name="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" msprop:Generator_UserColumnName="Priority" type="xs:boolean" />
|
|
<xs:element name="Confirmed" msprop:Generator_ColumnVarNameInTable="columnConfirmed" msprop:Generator_ColumnPropNameInRow="Confirmed" msprop:Generator_ColumnPropNameInTable="ConfirmedColumn" msprop:Generator_UserColumnName="Confirmed" type="xs:boolean" />
|
|
<xs:element name="NumNote" msprop:Generator_ColumnVarNameInTable="columnNumNote" msprop:Generator_ColumnPropNameInRow="NumNote" msprop:Generator_ColumnPropNameInTable="NumNoteColumn" msprop:Generator_UserColumnName="NumNote" type="xs:int" minOccurs="0" />
|
|
<xs:element name="IdxObjRoot" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnIdxObjRoot" msprop:Generator_ColumnPropNameInRow="IdxObjRoot" msprop:Generator_ColumnPropNameInTable="IdxObjRootColumn" msprop:Generator_UserColumnName="IdxObjRoot" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumClos" msprop:Generator_ColumnVarNameInTable="columnNumClos" msprop:Generator_ColumnPropNameInRow="NumClos" msprop:Generator_ColumnPropNameInTable="NumClosColumn" msprop:Generator_UserColumnName="NumClos" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_righe" msprop:Generator_UserTableName="v_righe" msprop:Generator_RowEvArgName="v_righeRowChangeEvent" msprop:Generator_TableVarName="tablev_righe" msprop:Generator_TablePropName="v_righe" msprop:Generator_RowDeletingName="v_righeRowDeleting" msprop:Generator_RowChangingName="v_righeRowChanging" msprop:Generator_RowDeletedName="v_righeRowDeleted" msprop:Generator_RowEvHandlerName="v_righeRowChangeEventHandler" msprop:Generator_TableClassName="v_righeDataTable" msprop:Generator_RowChangedName="v_righeRowChanged" msprop:Generator_RowClassName="v_righeRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Cod" msprop:Generator_ColumnVarNameInTable="columnCod" msprop:Generator_ColumnPropNameInRow="Cod" msprop:Generator_ColumnPropNameInTable="CodColumn" msprop:Generator_UserColumnName="Cod">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Stato" 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="50" />
|
|
</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="Cliente" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" msprop:Generator_UserColumnName="Cliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCli" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCodCli" msprop:Generator_ColumnPropNameInRow="CodCli" msprop:Generator_ColumnPropNameInTable="CodCliColumn" msprop:Generator_UserColumnName="CodCli" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrizione" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT" msprop:Generator_ColumnVarNameInTable="columnDDT" msprop:Generator_ColumnPropNameInRow="DDT" msprop:Generator_ColumnPropNameInTable="DDTColumn" msprop:Generator_UserColumnName="DDT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataDDT" msprop:Generator_ColumnVarNameInTable="columnDataDDT" msprop:Generator_ColumnPropNameInRow="DataDDT" msprop:Generator_ColumnPropNameInTable="DataDDTColumn" msprop:Generator_UserColumnName="DataDDT" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataArrivo" msprop:Generator_ColumnVarNameInTable="columnDataArrivo" msprop:Generator_ColumnPropNameInRow="DataArrivo" msprop:Generator_ColumnPropNameInTable="DataArrivoColumn" msprop:Generator_UserColumnName="DataArrivo" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Posizione" msprop:Generator_ColumnVarNameInTable="columnPosizione" msprop:Generator_ColumnPropNameInRow="Posizione" msprop:Generator_ColumnPropNameInTable="PosizioneColumn" msprop:Generator_UserColumnName="Posizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Qta" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Peso" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_UserColumnName="Peso" type="xs:double" minOccurs="0" />
|
|
<xs:element name="Colli" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnColli" msprop:Generator_ColumnPropNameInRow="Colli" msprop:Generator_ColumnPropNameInTable="ColliColumn" msprop:Generator_UserColumnName="Colli" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DataPrevista" msprop:Generator_ColumnVarNameInTable="columnDataPrevista" msprop:Generator_ColumnPropNameInRow="DataPrevista" msprop:Generator_ColumnPropNameInTable="DataPrevistaColumn" msprop:Generator_UserColumnName="DataPrevista" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="IdxObjMamma" msprop:Generator_ColumnVarNameInTable="columnIdxObjMamma" msprop:Generator_ColumnPropNameInRow="IdxObjMamma" msprop:Generator_ColumnPropNameInTable="IdxObjMammaColumn" msprop:Generator_UserColumnName="IdxObjMamma" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="minStato" msprop:Generator_ColumnVarNameInTable="columnminStato" msprop:Generator_ColumnPropNameInRow="minStato" msprop:Generator_ColumnPropNameInTable="minStatoColumn" msprop:Generator_UserColumnName="minStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="maxStato" msprop:Generator_ColumnVarNameInTable="columnmaxStato" msprop:Generator_ColumnPropNameInRow="maxStato" msprop:Generator_ColumnPropNameInTable="maxStatoColumn" msprop:Generator_UserColumnName="maxStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="sp_rec4Day" msprop:Generator_UserTableName="sp_rec4Day" msprop:Generator_RowEvArgName="sp_rec4DayRowChangeEvent" msprop:Generator_TableVarName="tablesp_rec4Day" msprop:Generator_TablePropName="sp_rec4Day" msprop:Generator_RowDeletingName="sp_rec4DayRowDeleting" msprop:Generator_RowChangingName="sp_rec4DayRowChanging" msprop:Generator_RowDeletedName="sp_rec4DayRowDeleted" msprop:Generator_RowEvHandlerName="sp_rec4DayRowChangeEventHandler" msprop:Generator_TableClassName="sp_rec4DayDataTable" msprop:Generator_RowChangedName="sp_rec4DayRowChanged" msprop:Generator_RowClassName="sp_rec4DayRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="rec4Day" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnrec4Day" msprop:Generator_ColumnPropNameInRow="rec4Day" msprop:Generator_ColumnPropNameInTable="rec4DayColumn" msprop:Generator_UserColumnName="rec4Day" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_ULP" msprop:Generator_UserTableName="v_ULP" msprop:Generator_RowEvArgName="v_ULPRowChangeEvent" msprop:Generator_TableVarName="tablev_ULP" msprop:Generator_TablePropName="v_ULP" msprop:Generator_RowDeletingName="v_ULPRowDeleting" msprop:Generator_RowChangingName="v_ULPRowChanging" msprop:Generator_RowDeletedName="v_ULPRowDeleted" msprop:Generator_RowEvHandlerName="v_ULPRowChangeEventHandler" msprop:Generator_TableClassName="v_ULPDataTable" msprop:Generator_RowChangedName="v_ULPRowChanged" msprop:Generator_RowClassName="v_ULPRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Cod" msprop:Generator_ColumnVarNameInTable="columnCod" msprop:Generator_ColumnPropNameInRow="Cod" msprop:Generator_ColumnPropNameInTable="CodColumn" msprop:Generator_UserColumnName="Cod">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Stato" 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="50" />
|
|
</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="Cliente" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" msprop:Generator_UserColumnName="Cliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCli" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCodCli" msprop:Generator_ColumnPropNameInRow="CodCli" msprop:Generator_ColumnPropNameInTable="CodCliColumn" msprop:Generator_UserColumnName="CodCli" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrizione" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT" msprop:Generator_ColumnVarNameInTable="columnDDT" msprop:Generator_ColumnPropNameInRow="DDT" msprop:Generator_ColumnPropNameInTable="DDTColumn" msprop:Generator_UserColumnName="DDT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataDDT" msprop:Generator_ColumnVarNameInTable="columnDataDDT" msprop:Generator_ColumnPropNameInRow="DataDDT" msprop:Generator_ColumnPropNameInTable="DataDDTColumn" msprop:Generator_UserColumnName="DataDDT" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataArrivo" msprop:Generator_ColumnVarNameInTable="columnDataArrivo" msprop:Generator_ColumnPropNameInRow="DataArrivo" msprop:Generator_ColumnPropNameInTable="DataArrivoColumn" msprop:Generator_UserColumnName="DataArrivo" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Posizione" msprop:Generator_ColumnVarNameInTable="columnPosizione" msprop:Generator_ColumnPropNameInRow="Posizione" msprop:Generator_ColumnPropNameInTable="PosizioneColumn" msprop:Generator_UserColumnName="Posizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Qta" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Peso" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_UserColumnName="Peso" type="xs:double" minOccurs="0" />
|
|
<xs:element name="DataPrevista" msprop:Generator_ColumnVarNameInTable="columnDataPrevista" msprop:Generator_ColumnPropNameInRow="DataPrevista" msprop:Generator_ColumnPropNameInTable="DataPrevistaColumn" msprop:Generator_UserColumnName="DataPrevista" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="IdxObjMamma" msprop:Generator_ColumnVarNameInTable="columnIdxObjMamma" msprop:Generator_ColumnPropNameInRow="IdxObjMamma" msprop:Generator_ColumnPropNameInTable="IdxObjMammaColumn" msprop:Generator_UserColumnName="IdxObjMamma" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Confirmed" msprop:Generator_ColumnVarNameInTable="columnConfirmed" msprop:Generator_ColumnPropNameInRow="Confirmed" msprop:Generator_ColumnPropNameInTable="ConfirmedColumn" msprop:Generator_UserColumnName="Confirmed" type="xs:boolean" />
|
|
<xs:element name="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" msprop:Generator_UserColumnName="Priority" type="xs:boolean" />
|
|
<xs:element name="NumNote" msprop:Generator_ColumnVarNameInTable="columnNumNote" msprop:Generator_ColumnPropNameInRow="NumNote" msprop:Generator_ColumnPropNameInTable="NumNoteColumn" msprop:Generator_UserColumnName="NumNote" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumClos" msprop:Generator_ColumnVarNameInTable="columnNumClos" msprop:Generator_ColumnPropNameInRow="NumClos" msprop:Generator_ColumnPropNameInTable="NumClosColumn" msprop:Generator_UserColumnName="NumClos" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Eventi" msprop:Generator_UserTableName="Eventi" msprop:Generator_RowEvArgName="EventiRowChangeEvent" msprop:Generator_TableVarName="tableEventi" msprop:Generator_TablePropName="Eventi" msprop:Generator_RowDeletingName="EventiRowDeleting" msprop:Generator_RowChangingName="EventiRowChanging" msprop:Generator_RowDeletedName="EventiRowDeleted" msprop:Generator_RowEvHandlerName="EventiRowChangeEventHandler" msprop:Generator_TableClassName="EventiDataTable" msprop:Generator_RowChangedName="EventiRowChanged" msprop:Generator_RowClassName="EventiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn" msprop:Generator_UserColumnName="CodEvento">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodTipoEvento" msprop:Generator_ColumnVarNameInTable="columnCodTipoEvento" msprop:Generator_ColumnPropNameInRow="CodTipoEvento" msprop:Generator_ColumnPropNameInTable="CodTipoEventoColumn" msprop:Generator_UserColumnName="CodTipoEvento" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrEvento" msprop:Generator_ColumnVarNameInTable="columnDescrEvento" msprop:Generator_ColumnPropNameInRow="DescrEvento" msprop:Generator_ColumnPropNameInTable="DescrEventoColumn" msprop:Generator_UserColumnName="DescrEvento" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Action" msprop:Generator_ColumnVarNameInTable="columnAction" msprop:Generator_ColumnPropNameInRow="Action" msprop:Generator_ColumnPropNameInTable="ActionColumn" msprop:Generator_UserColumnName="Action" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TraEv2Stati" msprop:Generator_UserTableName="TraEv2Stati" msprop:Generator_RowEvArgName="TraEv2StatiRowChangeEvent" msprop:Generator_TableVarName="tableTraEv2Stati" msprop:Generator_TablePropName="TraEv2Stati" msprop:Generator_RowDeletingName="TraEv2StatiRowDeleting" msprop:Generator_RowChangingName="TraEv2StatiRowChanging" msprop:Generator_RowDeletedName="TraEv2StatiRowDeleted" msprop:Generator_RowEvHandlerName="TraEv2StatiRowChangeEventHandler" msprop:Generator_TableClassName="TraEv2StatiDataTable" msprop:Generator_RowChangedName="TraEv2StatiRowChanged" msprop:Generator_RowClassName="TraEv2StatiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodMappa" msprop:Generator_ColumnVarNameInTable="columnCodMappa" msprop:Generator_ColumnPropNameInRow="CodMappa" msprop:Generator_ColumnPropNameInTable="CodMappaColumn" msprop:Generator_UserColumnName="CodMappa">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodObj" msprop:Generator_ColumnVarNameInTable="columnCodObj" msprop:Generator_ColumnPropNameInRow="CodObj" msprop:Generator_ColumnPropNameInTable="CodObjColumn" msprop:Generator_UserColumnName="CodObj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodStato" msprop:Generator_ColumnVarNameInTable="columnCodStato" msprop:Generator_ColumnPropNameInRow="CodStato" msprop:Generator_ColumnPropNameInTable="CodStatoColumn" msprop:Generator_UserColumnName="CodStato">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn" msprop:Generator_UserColumnName="CodEvento">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NextCodStato" msprop:Generator_ColumnVarNameInTable="columnNextCodStato" msprop:Generator_ColumnPropNameInRow="NextCodStato" msprop:Generator_ColumnPropNameInTable="NextCodStatoColumn" msprop:Generator_UserColumnName="NextCodStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CmdPlugin" msprop:Generator_ColumnVarNameInTable="columnCmdPlugin" msprop:Generator_ColumnPropNameInRow="CmdPlugin" msprop:Generator_ColumnPropNameInTable="CmdPluginColumn" msprop:Generator_UserColumnName="CmdPlugin" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="text2show" msprop:Generator_ColumnVarNameInTable="columntext2show" msprop:Generator_ColumnPropNameInRow="text2show" msprop:Generator_ColumnPropNameInTable="text2showColumn" msprop:Generator_UserColumnName="text2show" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrComando" msprop:Generator_ColumnVarNameInTable="columndescrComando" msprop:Generator_ColumnPropNameInRow="descrComando" msprop:Generator_ColumnPropNameInTable="descrComandoColumn" msprop:Generator_UserColumnName="descrComando" 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_logStati" msprop:Generator_UserTableName="v_logStati" msprop:Generator_RowEvArgName="v_logStatiRowChangeEvent" msprop:Generator_TableVarName="tablev_logStati" msprop:Generator_TablePropName="v_logStati" msprop:Generator_RowDeletingName="v_logStatiRowDeleting" msprop:Generator_RowChangingName="v_logStatiRowChanging" msprop:Generator_RowDeletedName="v_logStatiRowDeleted" msprop:Generator_RowEvHandlerName="v_logStatiRowChangeEventHandler" msprop:Generator_TableClassName="v_logStatiDataTable" msprop:Generator_RowChangedName="v_logStatiRowChanged" msprop:Generator_RowClassName="v_logStatiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliente" 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="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataRif" msprop:Generator_ColumnVarNameInTable="columnDataRif" msprop:Generator_ColumnPropNameInRow="DataRif" msprop:Generator_ColumnPropNameInTable="DataRifColumn" msprop:Generator_UserColumnName="DataRif" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="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="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ExtKey" msprop:Generator_ColumnVarNameInTable="columnExtKey" msprop:Generator_ColumnPropNameInRow="ExtKey" msprop:Generator_ColumnPropNameInTable="ExtKeyColumn" msprop:Generator_UserColumnName="ExtKey" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<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="DescrStato" msprop:Generator_ColumnVarNameInTable="columnDescrStato" msprop:Generator_ColumnPropNameInRow="DescrStato" msprop:Generator_ColumnPropNameInTable="DescrStatoColumn" msprop:Generator_UserColumnName="DescrStato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="sp_contaNonSched" msprop:Generator_UserTableName="sp_contaNonSched" msprop:Generator_RowEvArgName="sp_contaNonSchedRowChangeEvent" msprop:Generator_TableVarName="tablesp_contaNonSched" msprop:Generator_TablePropName="sp_contaNonSched" msprop:Generator_RowDeletingName="sp_contaNonSchedRowDeleting" msprop:Generator_RowChangingName="sp_contaNonSchedRowChanging" msprop:Generator_RowDeletedName="sp_contaNonSchedRowDeleted" msprop:Generator_RowEvHandlerName="sp_contaNonSchedRowChangeEventHandler" msprop:Generator_TableClassName="sp_contaNonSchedDataTable" msprop:Generator_RowChangedName="sp_contaNonSchedRowChanged" msprop:Generator_RowClassName="sp_contaNonSchedRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="quanti" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquanti" msprop:Generator_ColumnPropNameInRow="quanti" msprop:Generator_ColumnPropNameInTable="quantiColumn" msprop:Generator_UserColumnName="quanti" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="sp_schedaIdent" msprop:Generator_UserTableName="sp_schedaIdent" msprop:Generator_RowEvArgName="sp_schedaIdentRowChangeEvent" msprop:Generator_TableVarName="tablesp_schedaIdent" msprop:Generator_TablePropName="sp_schedaIdent" msprop:Generator_RowDeletingName="sp_schedaIdentRowDeleting" msprop:Generator_RowChangingName="sp_schedaIdentRowChanging" msprop:Generator_RowDeletedName="sp_schedaIdentRowDeleted" msprop:Generator_RowEvHandlerName="sp_schedaIdentRowChangeEventHandler" msprop:Generator_TableClassName="sp_schedaIdentDataTable" msprop:Generator_RowChangedName="sp_schedaIdentRowChanged" msprop:Generator_RowClassName="sp_schedaIdentRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cliente" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" msprop:Generator_UserColumnName="Cliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="DDT" msprop:Generator_ColumnVarNameInTable="columnDDT" msprop:Generator_ColumnPropNameInTable="DDTColumn" msprop:Generator_UserColumnName="DDT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT_del" msprop:Generator_ColumnVarNameInTable="columnDDT_del" msprop:Generator_ColumnPropNameInRow="DDT_del" msprop:Generator_ColumnPropNameInTable="DDT_delColumn" msprop:Generator_UserColumnName="DDT_del" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataArrivo" msprop:Generator_ColumnVarNameInTable="columnDataArrivo" msprop:Generator_ColumnPropNameInRow="DataArrivo" msprop:Generator_ColumnPropNameInTable="DataArrivoColumn" msprop:Generator_UserColumnName="DataArrivo" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CodProdotto" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="CodProdotto" msprop:Generator_ColumnVarNameInTable="columnCodProdotto" msprop:Generator_ColumnPropNameInTable="CodProdottoColumn" msprop:Generator_UserColumnName="CodProdotto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ConsegnaPrevista" msprop:Generator_ColumnVarNameInTable="columnConsegnaPrevista" msprop:Generator_ColumnPropNameInRow="ConsegnaPrevista" msprop:Generator_ColumnPropNameInTable="ConsegnaPrevistaColumn" msprop:Generator_UserColumnName="ConsegnaPrevista" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Peso" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_UserColumnName="Peso" type="xs:double" minOccurs="0" />
|
|
<xs:element name="FosfManganese" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="FosfManganese" msprop:Generator_ColumnVarNameInTable="columnFosfManganese" msprop:Generator_ColumnPropNameInTable="FosfManganeseColumn" msprop:Generator_UserColumnName="FosfManganese" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Brunitura" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Brunitura" msprop:Generator_ColumnVarNameInTable="columnBrunitura" msprop:Generator_ColumnPropNameInTable="BrunituraColumn" msprop:Generator_UserColumnName="Brunitura" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FosfTeflon" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="FosfTeflon" msprop:Generator_ColumnVarNameInTable="columnFosfTeflon" msprop:Generator_ColumnPropNameInTable="FosfTeflonColumn" msprop:Generator_UserColumnName="FosfTeflon" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Sabbiatura" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Sabbiatura" msprop:Generator_ColumnVarNameInTable="columnSabbiatura" msprop:Generator_ColumnPropNameInTable="SabbiaturaColumn" msprop:Generator_UserColumnName="Sabbiatura" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="F1" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="F1" msprop:Generator_ColumnVarNameInTable="columnF1" msprop:Generator_ColumnPropNameInTable="F1Column" msprop:Generator_UserColumnName="F1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="F2" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="F2" msprop:Generator_ColumnVarNameInTable="columnF2" msprop:Generator_ColumnPropNameInTable="F2Column" msprop:Generator_UserColumnName="F2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FosfZinco" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="FosfZinco" msprop:Generator_ColumnVarNameInTable="columnFosfZinco" msprop:Generator_ColumnPropNameInTable="FosfZincoColumn" msprop:Generator_UserColumnName="FosfZinco" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Teflon" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Teflon" msprop:Generator_ColumnVarNameInTable="columnTeflon" msprop:Generator_ColumnPropNameInTable="TeflonColumn" msprop:Generator_UserColumnName="Teflon" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FosfPreVern" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="FosfPreVern" msprop:Generator_ColumnVarNameInTable="columnFosfPreVern" msprop:Generator_ColumnPropNameInTable="FosfPreVernColumn" msprop:Generator_UserColumnName="FosfPreVern" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PzRoto" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="PzRoto" msprop:Generator_ColumnVarNameInTable="columnPzRoto" msprop:Generator_ColumnPropNameInTable="PzRotoColumn" msprop:Generator_UserColumnName="PzRoto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Zinchlorex" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Zinchlorex" msprop:Generator_ColumnVarNameInTable="columnZinchlorex" msprop:Generator_ColumnPropNameInTable="ZinchlorexColumn" msprop:Generator_UserColumnName="Zinchlorex" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PeekVicote" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="PeekVicote" msprop:Generator_ColumnVarNameInTable="columnPeekVicote" msprop:Generator_ColumnPropNameInTable="PeekVicoteColumn" msprop:Generator_UserColumnName="PeekVicote" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCli" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="CodCli" msprop:Generator_ColumnVarNameInTable="columnCodCli" msprop:Generator_ColumnPropNameInTable="CodCliColumn" msprop:Generator_UserColumnName="CodCli" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</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="Qta" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_UserColumnName="Qta" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="sp_ddt" msprop:Generator_UserTableName="sp_ddt" msprop:Generator_RowEvArgName="sp_ddtRowChangeEvent" msprop:Generator_TableVarName="tablesp_ddt" msprop:Generator_TablePropName="sp_ddt" msprop:Generator_RowDeletingName="sp_ddtRowDeleting" msprop:Generator_RowChangingName="sp_ddtRowChanging" msprop:Generator_RowDeletedName="sp_ddtRowDeleted" msprop:Generator_RowEvHandlerName="sp_ddtRowChangeEventHandler" msprop:Generator_TableClassName="sp_ddtDataTable" msprop:Generator_RowChangedName="sp_ddtRowChanged" msprop:Generator_RowClassName="sp_ddtRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn" msprop:Generator_UserColumnName="IdxObj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataCreaz" msprop:Generator_ColumnVarNameInTable="columnDataCreaz" msprop:Generator_ColumnPropNameInRow="DataCreaz" msprop:Generator_ColumnPropNameInTable="DataCreazColumn" msprop:Generator_UserColumnName="DataCreaz" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ImpegniSchedulati" msprop:Generator_TableClassName="ImpegniSchedulatiDataTable" msprop:Generator_TableVarName="tableImpegniSchedulati" msprop:Generator_RowChangedName="ImpegniSchedulatiRowChanged" msprop:Generator_TablePropName="ImpegniSchedulati" msprop:Generator_RowDeletingName="ImpegniSchedulatiRowDeleting" msprop:Generator_RowChangingName="ImpegniSchedulatiRowChanging" msprop:Generator_RowEvHandlerName="ImpegniSchedulatiRowChangeEventHandler" msprop:Generator_RowDeletedName="ImpegniSchedulatiRowDeleted" msprop:Generator_RowClassName="ImpegniSchedulatiRow" msprop:Generator_UserTableName="ImpegniSchedulati" msprop:Generator_RowEvArgName="ImpegniSchedulatiRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DueDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" />
|
|
<xs:element name="IdxLav" msprop:Generator_ColumnVarNameInTable="columnIdxLav" msprop:Generator_ColumnPropNameInRow="IdxLav" msprop:Generator_ColumnPropNameInTable="IdxLavColumn" msprop:Generator_UserColumnName="IdxLav">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TotPeso" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotPeso" msprop:Generator_ColumnPropNameInRow="TotPeso" msprop:Generator_ColumnPropNameInTable="TotPesoColumn" msprop:Generator_UserColumnName="TotPeso" type="xs:double" minOccurs="0" />
|
|
<xs:element name="TotPesoEquiv" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotPesoEquiv" msprop:Generator_ColumnPropNameInRow="TotPesoEquiv" msprop:Generator_ColumnPropNameInTable="TotPesoEquivColumn" msprop:Generator_UserColumnName="TotPesoEquiv" type="xs:double" minOccurs="0" />
|
|
<xs:element name="RatioUnit" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRatioUnit" msprop:Generator_ColumnPropNameInRow="RatioUnit" msprop:Generator_ColumnPropNameInTable="RatioUnitColumn" msprop:Generator_UserColumnName="RatioUnit" type="xs:double" minOccurs="0" />
|
|
<xs:element name="NumUnit" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNumUnit" msprop:Generator_ColumnPropNameInRow="NumUnit" msprop:Generator_ColumnPropNameInTable="NumUnitColumn" msprop:Generator_UserColumnName="NumUnit" type="xs:double" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagLav" msprop:Generator_TableClassName="AnagLavDataTable" msprop:Generator_TableVarName="tableAnagLav" msprop:Generator_RowChangedName="AnagLavRowChanged" msprop:Generator_TablePropName="AnagLav" msprop:Generator_RowDeletingName="AnagLavRowDeleting" msprop:Generator_RowChangingName="AnagLavRowChanging" msprop:Generator_RowEvHandlerName="AnagLavRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagLavRowDeleted" msprop:Generator_RowClassName="AnagLavRow" msprop:Generator_UserTableName="AnagLav" msprop:Generator_RowEvArgName="AnagLavRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxLav" msprop:Generator_ColumnVarNameInTable="columnIdxLav" msprop:Generator_ColumnPropNameInRow="IdxLav" msprop:Generator_ColumnPropNameInTable="IdxLavColumn" msprop:Generator_UserColumnName="IdxLav">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrLav" msprop:Generator_ColumnVarNameInTable="columnDescrLav" msprop:Generator_ColumnPropNameInRow="DescrLav" msprop:Generator_ColumnPropNameInTable="DescrLavColumn" msprop:Generator_UserColumnName="DescrLav" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PesoUnit" msprop:Generator_ColumnVarNameInTable="columnPesoUnit" msprop:Generator_ColumnPropNameInRow="PesoUnit" msprop:Generator_ColumnPropNameInTable="PesoUnitColumn" msprop:Generator_UserColumnName="PesoUnit" type="xs:double" />
|
|
<xs:element name="RoundVal" msprop:Generator_ColumnVarNameInTable="columnRoundVal" msprop:Generator_ColumnPropNameInRow="RoundVal" msprop:Generator_ColumnPropNameInTable="RoundValColumn" msprop:Generator_UserColumnName="RoundVal" type="xs:double" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagClienti" />
|
|
<xs:field xpath="mstns:CodCliente" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagTrattamenti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagTrattamenti" />
|
|
<xs:field xpath="mstns:CodTrattamento" />
|
|
</xs:unique>
|
|
<xs:unique name="Tratt2Obj_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Tratt2Obj" />
|
|
<xs:field xpath="mstns:IdxObj" />
|
|
<xs:field xpath="mstns:CodTrattamento" />
|
|
</xs:unique>
|
|
<xs:unique name="v_commesse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_commesse" />
|
|
<xs:field xpath="mstns:Cod" />
|
|
</xs:unique>
|
|
<xs:unique name="IstObj_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:IstObj" />
|
|
<xs:field xpath="mstns:IdxObj" />
|
|
</xs:unique>
|
|
<xs:unique name="v_righe_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_righe" />
|
|
<xs:field xpath="mstns:Cod" />
|
|
</xs:unique>
|
|
<xs:unique name="v_ULP_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_ULP" />
|
|
<xs:field xpath="mstns:Cod" />
|
|
</xs:unique>
|
|
<xs:unique name="Eventi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Eventi" />
|
|
<xs:field xpath="mstns:CodEvento" />
|
|
</xs:unique>
|
|
<xs:unique name="TraEv2Stati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TraEv2Stati" />
|
|
<xs:field xpath="mstns:CodMappa" />
|
|
<xs:field xpath="mstns:CodObj" />
|
|
<xs:field xpath="mstns:CodStato" />
|
|
<xs:field xpath="mstns:CodEvento" />
|
|
</xs:unique>
|
|
<xs:unique name="sp_schedaIdent_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:sp_schedaIdent" />
|
|
<xs:field xpath="mstns:IdxObj" />
|
|
</xs:unique>
|
|
<xs:unique name="sp_ddt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:sp_ddt" />
|
|
<xs:field xpath="mstns:IdxObj" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_impegniSchedulatiPK" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ImpegniSchedulati" />
|
|
<xs:field xpath="mstns:DueDate" />
|
|
<xs:field xpath="mstns:IdxLav" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagLav_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagLav" />
|
|
<xs:field xpath="mstns:IdxLav" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_Tratt2Obj_AnagTrattamenti" msdata:parent="AnagTrattamenti" msdata:child="Tratt2Obj" msdata:parentkey="CodTrattamento" msdata:childkey="CodTrattamento" msprop:Generator_UserChildTable="Tratt2Obj" msprop:Generator_ChildPropName="GetTratt2ObjRows" msprop:Generator_UserRelationName="FK_Tratt2Obj_AnagTrattamenti" msprop:Generator_RelationVarName="relationFK_Tratt2Obj_AnagTrattamenti" msprop:Generator_UserParentTable="AnagTrattamenti" msprop:Generator_ParentPropName="AnagTrattamentiRow" />
|
|
<msdata:Relationship name="FK_Tratt2Obj_IstObj" msdata:parent="IstObj" msdata:child="Tratt2Obj" msdata:parentkey="IdxObj" msdata:childkey="IdxObj" msprop:Generator_UserChildTable="Tratt2Obj" msprop:Generator_ChildPropName="GetTratt2ObjRows" msprop:Generator_UserRelationName="FK_Tratt2Obj_IstObj" msprop:Generator_RelationVarName="relationFK_Tratt2Obj_IstObj" msprop:Generator_UserParentTable="IstObj" msprop:Generator_ParentPropName="IstObjRow" />
|
|
<msdata:Relationship name="FK_IstObj_AnagClienti" msdata:parent="AnagClienti" msdata:child="IstObj" msdata:parentkey="CodCliente" msdata:childkey="CodCliente" msprop:Generator_UserChildTable="IstObj" msprop:Generator_ChildPropName="GetIstObjRows" msprop:Generator_UserRelationName="FK_IstObj_AnagClienti" msprop:Generator_RelationVarName="relationFK_IstObj_AnagClienti" msprop:Generator_UserParentTable="AnagClienti" msprop:Generator_ParentPropName="AnagClientiRow" />
|
|
<msdata:Relationship name="FK_TransizioneEventiStati_Eventi" msdata:parent="Eventi" msdata:child="TraEv2Stati" msdata:parentkey="CodEvento" msdata:childkey="CodEvento" msprop:Generator_UserChildTable="TraEv2Stati" msprop:Generator_ChildPropName="GetTraEv2StatiRows" msprop:Generator_UserRelationName="FK_TransizioneEventiStati_Eventi" msprop:Generator_RelationVarName="relationFK_TransizioneEventiStati_Eventi" msprop:Generator_UserParentTable="Eventi" msprop:Generator_ParentPropName="EventiRow" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |