Samuele E. Locatelli
1832 lines
279 KiB
XML
1832 lines
279 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Odette" targetNamespace="http://tempuri.org/DS_Odette.xsd" xmlns:mstns="http://tempuri.org/DS_Odette.xsd" xmlns="http://tempuri.org/DS_Odette.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GMWConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GMWConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GMW_data.Properties.Settings.GlobalReference.Default.GMWConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BORI202JTableAdapter" GeneratorDataComponentClassName="BORI202JTableAdapter" Name="BORI202J" UserDataComponentName="BORI202JTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW_prod.RawData.BORI202J" 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 [RawData].[BORI202J] WHERE (([CDMFS] = @Original_CDMFS) AND ([GRBOS] = @Original_GRBOS) AND ([DTBOS] = @Original_DTBOS) AND ([NRBOS] = @Original_NRBOS) AND ([CDARS] = @Original_CDARS) AND ([NRRGS] = @Original_NRRGS) AND ([CDINB] = @Original_CDINB) AND ([RA1ND] = @Original_RA1ND) AND ([RA2ND] = @Original_RA2ND) AND ([CAPND] = @Original_CAPND) AND ([CITND] = @Original_CITND) AND ([RASCL] = @Original_RASCL) AND ([INDCL] = @Original_INDCL) AND ([CAPCL] = @Original_CAPCL) AND ([LOCCL] = @Original_LOCCL) AND ([PROCL] = @Original_PROCL) AND ([INEND] = @Original_INEND) AND ([CRAGCL] = @Original_CRAGCL) AND ([TELND] = @Original_TELND) AND ([CCDMOL] = @Original_CCDMOL) AND ([CCDPTR] = @Original_CCDPTR) AND ([EPLAVO] = @Original_EPLAVO) AND ([NRC1B] = @Original_NRC1B) AND ([ECMM01] = @Original_ECMM01) AND ([DEPAR] = @Original_DEPAR) AND ([RCARTC] = @Original_RCARTC) AND ([PERND] = @Original_PERND) AND ([CCDET1] = @Original_CCDET1) AND ([ECDNAE] = @Original_ECDNAE) AND ((@IsNull_ECDNA1 = 1 AND [ECDNA1] IS NULL) OR ([ECDNA1] = @Original_ECDNA1)) AND ([EESPMD] = @Original_EESPMD) AND ([PELDB] = @Original_PELDB) AND ([QTCNS] = @Original_QTCNS) AND ([ECLAQP] = @Original_ECLAQP) AND ([EPNETT] = @Original_EPNETT) AND ([FCDI01] = @Original_FCDI01) AND ([OCDODM] = @Original_OCDODM) AND ([CCFOE1] = @Original_CCFOE1))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CDMFS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDMFS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GRBOS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GRBOS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DTBOS" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DTBOS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NRBOS" Precision="6" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRBOS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CDARS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDARS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NRRGS" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRRGS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CDINB" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDINB" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RA1ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA1ND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RA2ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA2ND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CAPND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CITND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CITND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RASCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RASCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INDCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INDCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CAPCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LOCCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LOCCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PROCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PROCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INEND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INEND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CRAGCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CRAGCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TELND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TELND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCDMOL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDMOL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCDPTR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDPTR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EPLAVO" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPLAVO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NRC1B" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRC1B" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ECMM01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECMM01" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DEPAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DEPAR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RCARTC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RCARTC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PERND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PERND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCDET1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDET1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ECDNAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNAE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ECDNA1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ECDNA1" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ECDNA1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNA1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EESPMD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EESPMD" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PELDB" Precision="7" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PELDB" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_QTCNS" Precision="9" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="QTCNS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ECLAQP" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ECLAQP" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EPNETT" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPNETT" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FCDI01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FCDI01" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OCDODM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OCDODM" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCFOE1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCFOE1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [RawData].[BORI202J] ([CDMFS], [GRBOS], [DTBOS], [NRBOS], [CDARS], [NRRGS], [CDINB], [RA1ND], [RA2ND], [CAPND], [CITND], [RASCL], [INDCL], [CAPCL], [LOCCL], [PROCL], [INEND], [CRAGCL], [TELND], [CCDMOL], [CCDPTR], [EPLAVO], [NRC1B], [ECMM01], [DEPAR], [RCARTC], [PERND], [CCDET1], [ECDNAE], [ECDNA1], [EESPMD], [PELDB], [QTCNS], [ECLAQP], [EPNETT], [FCDI01], [OCDODM], [CCFOE1]) VALUES (@CDMFS, @GRBOS, @DTBOS, @NRBOS, @CDARS, @NRRGS, @CDINB, @RA1ND, @RA2ND, @CAPND, @CITND, @RASCL, @INDCL, @CAPCL, @LOCCL, @PROCL, @INEND, @CRAGCL, @TELND, @CCDMOL, @CCDPTR, @EPLAVO, @NRC1B, @ECMM01, @DEPAR, @RCARTC, @PERND, @CCDET1, @ECDNAE, @ECDNA1, @EESPMD, @PELDB, @QTCNS, @ECLAQP, @EPNETT, @FCDI01, @OCDODM, @CCFOE1);
|
|
SELECT CDMFS, GRBOS, DTBOS, NRBOS, CDARS, NRRGS, CDINB, RA1ND, RA2ND, CAPND, CITND, RASCL, INDCL, CAPCL, LOCCL, PROCL, INEND, CRAGCL, TELND, CCDMOL, CCDPTR, EPLAVO, NRC1B, ECMM01, DEPAR, RCARTC, PERND, CCDET1, ECDNAE, ECDNA1, EESPMD, PELDB, QTCNS, ECLAQP, EPNETT, FCDI01, OCDODM, CCFOE1 FROM RawData.BORI202J WHERE (CDARS = @CDARS) AND (CDMFS = @CDMFS) AND (DTBOS = @DTBOS) AND (GRBOS = @GRBOS) AND (NRBOS = @NRBOS) AND (NRRGS = @NRRGS)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CDMFS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDMFS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GRBOS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GRBOS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DTBOS" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DTBOS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NRBOS" Precision="6" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRBOS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CDARS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDARS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NRRGS" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRRGS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CDINB" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDINB" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RA1ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA1ND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RA2ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA2ND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CAPND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CITND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CITND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RASCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RASCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INDCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INDCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CAPCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LOCCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LOCCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PROCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PROCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INEND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INEND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CRAGCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CRAGCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TELND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TELND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCDMOL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDMOL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCDPTR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDPTR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EPLAVO" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPLAVO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NRC1B" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRC1B" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ECMM01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECMM01" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DEPAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DEPAR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RCARTC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RCARTC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PERND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PERND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCDET1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDET1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ECDNAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNAE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ECDNA1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNA1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EESPMD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EESPMD" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PELDB" Precision="7" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PELDB" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@QTCNS" Precision="9" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="QTCNS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ECLAQP" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ECLAQP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EPNETT" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPNETT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FCDI01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FCDI01" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OCDODM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OCDODM" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCFOE1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCFOE1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM RawData.BORI202J</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [RawData].[BORI202J] SET [CDMFS] = @CDMFS, [GRBOS] = @GRBOS, [DTBOS] = @DTBOS, [NRBOS] = @NRBOS, [CDARS] = @CDARS, [NRRGS] = @NRRGS, [CDINB] = @CDINB, [RA1ND] = @RA1ND, [RA2ND] = @RA2ND, [CAPND] = @CAPND, [CITND] = @CITND, [RASCL] = @RASCL, [INDCL] = @INDCL, [CAPCL] = @CAPCL, [LOCCL] = @LOCCL, [PROCL] = @PROCL, [INEND] = @INEND, [CRAGCL] = @CRAGCL, [TELND] = @TELND, [CCDMOL] = @CCDMOL, [CCDPTR] = @CCDPTR, [EPLAVO] = @EPLAVO, [NRC1B] = @NRC1B, [ECMM01] = @ECMM01, [DEPAR] = @DEPAR, [RCARTC] = @RCARTC, [PERND] = @PERND, [CCDET1] = @CCDET1, [ECDNAE] = @ECDNAE, [ECDNA1] = @ECDNA1, [EESPMD] = @EESPMD, [PELDB] = @PELDB, [QTCNS] = @QTCNS, [ECLAQP] = @ECLAQP, [EPNETT] = @EPNETT, [FCDI01] = @FCDI01, [OCDODM] = @OCDODM, [CCFOE1] = @CCFOE1 WHERE (([CDMFS] = @Original_CDMFS) AND ([GRBOS] = @Original_GRBOS) AND ([DTBOS] = @Original_DTBOS) AND ([NRBOS] = @Original_NRBOS) AND ([CDARS] = @Original_CDARS) AND ([NRRGS] = @Original_NRRGS) AND ([CDINB] = @Original_CDINB) AND ([RA1ND] = @Original_RA1ND) AND ([RA2ND] = @Original_RA2ND) AND ([CAPND] = @Original_CAPND) AND ([CITND] = @Original_CITND) AND ([RASCL] = @Original_RASCL) AND ([INDCL] = @Original_INDCL) AND ([CAPCL] = @Original_CAPCL) AND ([LOCCL] = @Original_LOCCL) AND ([PROCL] = @Original_PROCL) AND ([INEND] = @Original_INEND) AND ([CRAGCL] = @Original_CRAGCL) AND ([TELND] = @Original_TELND) AND ([CCDMOL] = @Original_CCDMOL) AND ([CCDPTR] = @Original_CCDPTR) AND ([EPLAVO] = @Original_EPLAVO) AND ([NRC1B] = @Original_NRC1B) AND ([ECMM01] = @Original_ECMM01) AND ([DEPAR] = @Original_DEPAR) AND ([RCARTC] = @Original_RCARTC) AND ([PERND] = @Original_PERND) AND ([CCDET1] = @Original_CCDET1) AND ([ECDNAE] = @Original_ECDNAE) AND ((@IsNull_ECDNA1 = 1 AND [ECDNA1] IS NULL) OR ([ECDNA1] = @Original_ECDNA1)) AND ([EESPMD] = @Original_EESPMD) AND ([PELDB] = @Original_PELDB) AND ([QTCNS] = @Original_QTCNS) AND ([ECLAQP] = @Original_ECLAQP) AND ([EPNETT] = @Original_EPNETT) AND ([FCDI01] = @Original_FCDI01) AND ([OCDODM] = @Original_OCDODM) AND ([CCFOE1] = @Original_CCFOE1));
|
|
SELECT CDMFS, GRBOS, DTBOS, NRBOS, CDARS, NRRGS, CDINB, RA1ND, RA2ND, CAPND, CITND, RASCL, INDCL, CAPCL, LOCCL, PROCL, INEND, CRAGCL, TELND, CCDMOL, CCDPTR, EPLAVO, NRC1B, ECMM01, DEPAR, RCARTC, PERND, CCDET1, ECDNAE, ECDNA1, EESPMD, PELDB, QTCNS, ECLAQP, EPNETT, FCDI01, OCDODM, CCFOE1 FROM RawData.BORI202J WHERE (CDARS = @CDARS) AND (CDMFS = @CDMFS) AND (DTBOS = @DTBOS) AND (GRBOS = @GRBOS) AND (NRBOS = @NRBOS) AND (NRRGS = @NRRGS)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CDMFS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDMFS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GRBOS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GRBOS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DTBOS" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DTBOS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NRBOS" Precision="6" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRBOS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CDARS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDARS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NRRGS" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRRGS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CDINB" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDINB" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RA1ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA1ND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RA2ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA2ND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CAPND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CITND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CITND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RASCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RASCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INDCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INDCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CAPCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LOCCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LOCCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PROCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PROCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INEND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INEND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CRAGCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CRAGCL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TELND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TELND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCDMOL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDMOL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCDPTR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDPTR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EPLAVO" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPLAVO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NRC1B" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRC1B" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ECMM01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECMM01" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DEPAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DEPAR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RCARTC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RCARTC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PERND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PERND" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCDET1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDET1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ECDNAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNAE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ECDNA1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNA1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EESPMD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EESPMD" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PELDB" Precision="7" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PELDB" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@QTCNS" Precision="9" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="QTCNS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ECLAQP" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ECLAQP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EPNETT" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPNETT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FCDI01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FCDI01" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OCDODM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OCDODM" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CCFOE1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCFOE1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CDMFS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDMFS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GRBOS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GRBOS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DTBOS" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DTBOS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NRBOS" Precision="6" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRBOS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CDARS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDARS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NRRGS" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRRGS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CDINB" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDINB" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RA1ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA1ND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RA2ND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RA2ND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CAPND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CITND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CITND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RASCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RASCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INDCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INDCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CAPCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CAPCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LOCCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LOCCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PROCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PROCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INEND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INEND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CRAGCL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CRAGCL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TELND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TELND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCDMOL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDMOL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCDPTR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDPTR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EPLAVO" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPLAVO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NRC1B" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NRC1B" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ECMM01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECMM01" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DEPAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DEPAR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RCARTC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RCARTC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PERND" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PERND" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCDET1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCDET1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ECDNAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNAE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ECDNA1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ECDNA1" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ECDNA1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ECDNA1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EESPMD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EESPMD" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PELDB" Precision="7" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PELDB" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_QTCNS" Precision="9" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="QTCNS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ECLAQP" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ECLAQP" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EPNETT" Precision="7" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EPNETT" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FCDI01" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FCDI01" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OCDODM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OCDODM" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CCFOE1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CCFOE1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CDMFS" DataSetColumn="CDMFS" />
|
|
<Mapping SourceColumn="GRBOS" DataSetColumn="GRBOS" />
|
|
<Mapping SourceColumn="DTBOS" DataSetColumn="DTBOS" />
|
|
<Mapping SourceColumn="NRBOS" DataSetColumn="NRBOS" />
|
|
<Mapping SourceColumn="CDARS" DataSetColumn="CDARS" />
|
|
<Mapping SourceColumn="NRRGS" DataSetColumn="NRRGS" />
|
|
<Mapping SourceColumn="CDINB" DataSetColumn="CDINB" />
|
|
<Mapping SourceColumn="RA1ND" DataSetColumn="RA1ND" />
|
|
<Mapping SourceColumn="RA2ND" DataSetColumn="RA2ND" />
|
|
<Mapping SourceColumn="CAPND" DataSetColumn="CAPND" />
|
|
<Mapping SourceColumn="CITND" DataSetColumn="CITND" />
|
|
<Mapping SourceColumn="RASCL" DataSetColumn="RASCL" />
|
|
<Mapping SourceColumn="INDCL" DataSetColumn="INDCL" />
|
|
<Mapping SourceColumn="CAPCL" DataSetColumn="CAPCL" />
|
|
<Mapping SourceColumn="LOCCL" DataSetColumn="LOCCL" />
|
|
<Mapping SourceColumn="PROCL" DataSetColumn="PROCL" />
|
|
<Mapping SourceColumn="INEND" DataSetColumn="INEND" />
|
|
<Mapping SourceColumn="CRAGCL" DataSetColumn="CRAGCL" />
|
|
<Mapping SourceColumn="TELND" DataSetColumn="TELND" />
|
|
<Mapping SourceColumn="CCDMOL" DataSetColumn="CCDMOL" />
|
|
<Mapping SourceColumn="CCDPTR" DataSetColumn="CCDPTR" />
|
|
<Mapping SourceColumn="EPLAVO" DataSetColumn="EPLAVO" />
|
|
<Mapping SourceColumn="NRC1B" DataSetColumn="NRC1B" />
|
|
<Mapping SourceColumn="ECMM01" DataSetColumn="ECMM01" />
|
|
<Mapping SourceColumn="DEPAR" DataSetColumn="DEPAR" />
|
|
<Mapping SourceColumn="RCARTC" DataSetColumn="RCARTC" />
|
|
<Mapping SourceColumn="PERND" DataSetColumn="PERND" />
|
|
<Mapping SourceColumn="CCDET1" DataSetColumn="CCDET1" />
|
|
<Mapping SourceColumn="ECDNAE" DataSetColumn="ECDNAE" />
|
|
<Mapping SourceColumn="ECDNA1" DataSetColumn="ECDNA1" />
|
|
<Mapping SourceColumn="EESPMD" DataSetColumn="EESPMD" />
|
|
<Mapping SourceColumn="PELDB" DataSetColumn="PELDB" />
|
|
<Mapping SourceColumn="QTCNS" DataSetColumn="QTCNS" />
|
|
<Mapping SourceColumn="ECLAQP" DataSetColumn="ECLAQP" />
|
|
<Mapping SourceColumn="EPNETT" DataSetColumn="EPNETT" />
|
|
<Mapping SourceColumn="FCDI01" DataSetColumn="FCDI01" />
|
|
<Mapping SourceColumn="OCDODM" DataSetColumn="OCDODM" />
|
|
<Mapping SourceColumn="CCFOE1" DataSetColumn="CCFOE1" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_BORI_caricaDatiBolla" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="caricaDatiBolla" Modifier="Public" Name="caricaDatiBolla" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="caricaDatiBolla">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_BORI_caricaDatiBolla</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="@RaggrMagazz" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@GruppoBolle" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NumeroBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="6" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DataBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Particolare" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_BORI_getByBolla" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByBolla" GetMethodModifier="Public" GetMethodName="getByBolla" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByBolla" UserSourceName="getByBolla">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_BORI_getByBolla</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="numeric" DbType="Decimal" Direction="Input" ParameterName="@numB" Precision="6" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@dataB" Precision="8" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_BORI_getByBollaFull" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKeyFull" GetMethodModifier="Public" GetMethodName="getByKeyFull" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKeyFull" UserSourceName="getByKeyFull">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_BORI_getByBollaFull</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="@RaggrMagazz" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@GruppoBolle" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@NumeroBolla" Precision="6" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@DataBolla" Precision="8" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Particolare" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_BORI_getByBollaPart" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKeyPart" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="getByKeyPart" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKeyPart" UserSourceName="getByKeyPart">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_BORI_getByBollaPart</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="@RaggrMagazz" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@GruppoBolle" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@NumeroBolla" Precision="6" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@DataBolla" Precision="8" ProviderType="Decimal" 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="OdetteTableAdapter" GeneratorDataComponentClassName="OdetteTableAdapter" Name="Odette" UserDataComponentName="OdetteTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.Odette" 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].[Odette] WHERE (([CampoUDC] = @Original_CampoUDC) AND ([Campo1_1] = @Original_Campo1_1) AND ([Campo1_2] = @Original_Campo1_2) AND ([Campo1_3] = @Original_Campo1_3) AND ([Campo1_4] = @Original_Campo1_4) AND ([Campo1_5] = @Original_Campo1_5) AND ([Campo2_1] = @Original_Campo2_1) AND ([Campo2_2] = @Original_Campo2_2) AND ([Campo2_3] = @Original_Campo2_3) AND ([Campo2_4] = @Original_Campo2_4) AND ([Campo2_5] = @Original_Campo2_5) AND ([Campo3_1] = @Original_Campo3_1) AND ([Campo3_2] = @Original_Campo3_2) AND ([Campo3_3] = @Original_Campo3_3) AND ([Campo3_4] = @Original_Campo3_4) AND ([Campo3_5] = @Original_Campo3_5) AND ([Campo4_1] = @Original_Campo4_1) AND ([Campo4_2] = @Original_Campo4_2) AND ([Campo4_3] = @Original_Campo4_3) AND ([Campo4_4] = @Original_Campo4_4) AND ([Campo4_5] = @Original_Campo4_5) AND ([Campo5_1] = @Original_Campo5_1) AND ([Campo5_2] = @Original_Campo5_2) AND ([Campo5_3] = @Original_Campo5_3) AND ([Campo5_4] = @Original_Campo5_4) AND ([Campo5_5] = @Original_Campo5_5) AND ([Campo6_1] = @Original_Campo6_1) AND ([Campo6_2] = @Original_Campo6_2) AND ([Campo6_3] = @Original_Campo6_3) AND ([Campo6_4] = @Original_Campo6_4) AND ([Campo6_5] = @Original_Campo6_5) AND ([Campo7_1] = @Original_Campo7_1) AND ([Campo7_2] = @Original_Campo7_2) AND ([Campo7_3] = @Original_Campo7_3) AND ([Campo7_4] = @Original_Campo7_4) AND ([Campo7_5] = @Original_Campo7_5) AND ([Campo8_1] = @Original_Campo8_1) AND ([Campo8_2] = @Original_Campo8_2) AND ([Campo8_3] = @Original_Campo8_3) AND ([Campo8_4] = @Original_Campo8_4) AND ([Campo8_5] = @Original_Campo8_5) AND ([Campo9_1] = @Original_Campo9_1) AND ([Campo9_2] = @Original_Campo9_2) AND ([Campo9_3] = @Original_Campo9_3) AND ([Campo9_4] = @Original_Campo9_4) AND ([Campo9_5] = @Original_Campo9_5) AND ([Campo10_1] = @Original_Campo10_1) AND ([Campo10_2] = @Original_Campo10_2) AND ([Campo10_3] = @Original_Campo10_3) AND ([Campo10_4] = @Original_Campo10_4) AND ([Campo10_5] = @Original_Campo10_5) AND ([Campo11_1_1] = @Original_Campo11_1_1) AND ([Campo11_1_2] = @Original_Campo11_1_2) AND ([Campo11_1_3] = @Original_Campo11_1_3) AND ([Campo11_1_4] = @Original_Campo11_1_4) AND ([Campo11_1_5] = @Original_Campo11_1_5) AND ([Campo11_2_1] = @Original_Campo11_2_1) AND ([Campo11_2_2] = @Original_Campo11_2_2) AND ([Campo11_2_3] = @Original_Campo11_2_3) AND ([Campo11_2_4] = @Original_Campo11_2_4) AND ([Campo11_2_5] = @Original_Campo11_2_5) AND ([Campo12_1] = @Original_Campo12_1) AND ([Campo12_2] = @Original_Campo12_2) AND ([Campo12_3] = @Original_Campo12_3) AND ([Campo12_4] = @Original_Campo12_4) AND ([Campo12_5] = @Original_Campo12_5) AND ([Campo13_1] = @Original_Campo13_1) AND ([Campo13_2] = @Original_Campo13_2) AND ([Campo13_3] = @Original_Campo13_3) AND ([Campo13_4] = @Original_Campo13_4) AND ([Campo13_5] = @Original_Campo13_5) AND ([Campo14_1] = @Original_Campo14_1) AND ([Campo14_2] = @Original_Campo14_2) AND ([Campo14_3] = @Original_Campo14_3) AND ([Campo14_4] = @Original_Campo14_4) AND ([Campo14_5] = @Original_Campo14_5) AND ([Campo15_1] = @Original_Campo15_1) AND ([Campo15_2] = @Original_Campo15_2) AND ([Campo15_3] = @Original_Campo15_3) AND ([Campo15_4] = @Original_Campo15_4) AND ([Campo15_5] = @Original_Campo15_5) AND ([Campo16_1] = @Original_Campo16_1) AND ([Campo16_2] = @Original_Campo16_2) AND ([Campo16_3] = @Original_Campo16_3) AND ([Campo16_4] = @Original_Campo16_4) AND ([Campo16_5] = @Original_Campo16_5) AND ([StatoOk] = @Original_StatoOk) AND ([CodCS] = @Original_CodCS))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CampoUDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoUDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_StatoOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="StatoOk" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodCS" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodCS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Odette] ([CampoUDC], [Campo1_1], [Campo1_2], [Campo1_3], [Campo1_4], [Campo1_5], [Campo2_1], [Campo2_2], [Campo2_3], [Campo2_4], [Campo2_5], [Campo3_1], [Campo3_2], [Campo3_3], [Campo3_4], [Campo3_5], [Campo4_1], [Campo4_2], [Campo4_3], [Campo4_4], [Campo4_5], [Campo5_1], [Campo5_2], [Campo5_3], [Campo5_4], [Campo5_5], [Campo6_1], [Campo6_2], [Campo6_3], [Campo6_4], [Campo6_5], [Campo7_1], [Campo7_2], [Campo7_3], [Campo7_4], [Campo7_5], [Campo8_1], [Campo8_2], [Campo8_3], [Campo8_4], [Campo8_5], [Campo9_1], [Campo9_2], [Campo9_3], [Campo9_4], [Campo9_5], [Campo10_1], [Campo10_2], [Campo10_3], [Campo10_4], [Campo10_5], [Campo11_1_1], [Campo11_1_2], [Campo11_1_3], [Campo11_1_4], [Campo11_1_5], [Campo11_2_1], [Campo11_2_2], [Campo11_2_3], [Campo11_2_4], [Campo11_2_5], [Campo12_1], [Campo12_2], [Campo12_3], [Campo12_4], [Campo12_5], [Campo13_1], [Campo13_2], [Campo13_3], [Campo13_4], [Campo13_5], [Campo14_1], [Campo14_2], [Campo14_3], [Campo14_4], [Campo14_5], [Campo15_1], [Campo15_2], [Campo15_3], [Campo15_4], [Campo15_5], [Campo16_1], [Campo16_2], [Campo16_3], [Campo16_4], [Campo16_5], [StatoOk], [CodCS]) VALUES (@CampoUDC, @Campo1_1, @Campo1_2, @Campo1_3, @Campo1_4, @Campo1_5, @Campo2_1, @Campo2_2, @Campo2_3, @Campo2_4, @Campo2_5, @Campo3_1, @Campo3_2, @Campo3_3, @Campo3_4, @Campo3_5, @Campo4_1, @Campo4_2, @Campo4_3, @Campo4_4, @Campo4_5, @Campo5_1, @Campo5_2, @Campo5_3, @Campo5_4, @Campo5_5, @Campo6_1, @Campo6_2, @Campo6_3, @Campo6_4, @Campo6_5, @Campo7_1, @Campo7_2, @Campo7_3, @Campo7_4, @Campo7_5, @Campo8_1, @Campo8_2, @Campo8_3, @Campo8_4, @Campo8_5, @Campo9_1, @Campo9_2, @Campo9_3, @Campo9_4, @Campo9_5, @Campo10_1, @Campo10_2, @Campo10_3, @Campo10_4, @Campo10_5, @Campo11_1_1, @Campo11_1_2, @Campo11_1_3, @Campo11_1_4, @Campo11_1_5, @Campo11_2_1, @Campo11_2_2, @Campo11_2_3, @Campo11_2_4, @Campo11_2_5, @Campo12_1, @Campo12_2, @Campo12_3, @Campo12_4, @Campo12_5, @Campo13_1, @Campo13_2, @Campo13_3, @Campo13_4, @Campo13_5, @Campo14_1, @Campo14_2, @Campo14_3, @Campo14_4, @Campo14_5, @Campo15_1, @Campo15_2, @Campo15_3, @Campo15_4, @Campo15_5, @Campo16_1, @Campo16_2, @Campo16_3, @Campo16_4, @Campo16_5, @StatoOk, @CodCS);
|
|
SELECT CampoUDC, Campo1_1, Campo1_2, Campo1_3, Campo1_4, Campo1_5, Campo2_1, Campo2_2, Campo2_3, Campo2_4, Campo2_5, Campo3_1, Campo3_2, Campo3_3, Campo3_4, Campo3_5, Campo4_1, Campo4_2, Campo4_3, Campo4_4, Campo4_5, Campo5_1, Campo5_2, Campo5_3, Campo5_4, Campo5_5, Campo6_1, Campo6_2, Campo6_3, Campo6_4, Campo6_5, Campo7_1, Campo7_2, Campo7_3, Campo7_4, Campo7_5, Campo8_1, Campo8_2, Campo8_3, Campo8_4, Campo8_5, Campo9_1, Campo9_2, Campo9_3, Campo9_4, Campo9_5, Campo10_1, Campo10_2, Campo10_3, Campo10_4, Campo10_5, Campo11_1_1, Campo11_1_2, Campo11_1_3, Campo11_1_4, Campo11_1_5, Campo11_2_1, Campo11_2_2, Campo11_2_3, Campo11_2_4, Campo11_2_5, Campo12_1, Campo12_2, Campo12_3, Campo12_4, Campo12_5, Campo13_1, Campo13_2, Campo13_3, Campo13_4, Campo13_5, Campo14_1, Campo14_2, Campo14_3, Campo14_4, Campo14_5, Campo15_1, Campo15_2, Campo15_3, Campo15_4, Campo15_5, Campo16_1, Campo16_2, Campo16_3, Campo16_4, Campo16_5, StatoOk, CodCS FROM Odette WHERE (CampoUDC = @CampoUDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CampoUDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoUDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@StatoOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="StatoOk" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodCS" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodCS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM dbo.Odette</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Odette] SET [CampoUDC] = @CampoUDC, [Campo1_1] = @Campo1_1, [Campo1_2] = @Campo1_2, [Campo1_3] = @Campo1_3, [Campo1_4] = @Campo1_4, [Campo1_5] = @Campo1_5, [Campo2_1] = @Campo2_1, [Campo2_2] = @Campo2_2, [Campo2_3] = @Campo2_3, [Campo2_4] = @Campo2_4, [Campo2_5] = @Campo2_5, [Campo3_1] = @Campo3_1, [Campo3_2] = @Campo3_2, [Campo3_3] = @Campo3_3, [Campo3_4] = @Campo3_4, [Campo3_5] = @Campo3_5, [Campo4_1] = @Campo4_1, [Campo4_2] = @Campo4_2, [Campo4_3] = @Campo4_3, [Campo4_4] = @Campo4_4, [Campo4_5] = @Campo4_5, [Campo5_1] = @Campo5_1, [Campo5_2] = @Campo5_2, [Campo5_3] = @Campo5_3, [Campo5_4] = @Campo5_4, [Campo5_5] = @Campo5_5, [Campo6_1] = @Campo6_1, [Campo6_2] = @Campo6_2, [Campo6_3] = @Campo6_3, [Campo6_4] = @Campo6_4, [Campo6_5] = @Campo6_5, [Campo7_1] = @Campo7_1, [Campo7_2] = @Campo7_2, [Campo7_3] = @Campo7_3, [Campo7_4] = @Campo7_4, [Campo7_5] = @Campo7_5, [Campo8_1] = @Campo8_1, [Campo8_2] = @Campo8_2, [Campo8_3] = @Campo8_3, [Campo8_4] = @Campo8_4, [Campo8_5] = @Campo8_5, [Campo9_1] = @Campo9_1, [Campo9_2] = @Campo9_2, [Campo9_3] = @Campo9_3, [Campo9_4] = @Campo9_4, [Campo9_5] = @Campo9_5, [Campo10_1] = @Campo10_1, [Campo10_2] = @Campo10_2, [Campo10_3] = @Campo10_3, [Campo10_4] = @Campo10_4, [Campo10_5] = @Campo10_5, [Campo11_1_1] = @Campo11_1_1, [Campo11_1_2] = @Campo11_1_2, [Campo11_1_3] = @Campo11_1_3, [Campo11_1_4] = @Campo11_1_4, [Campo11_1_5] = @Campo11_1_5, [Campo11_2_1] = @Campo11_2_1, [Campo11_2_2] = @Campo11_2_2, [Campo11_2_3] = @Campo11_2_3, [Campo11_2_4] = @Campo11_2_4, [Campo11_2_5] = @Campo11_2_5, [Campo12_1] = @Campo12_1, [Campo12_2] = @Campo12_2, [Campo12_3] = @Campo12_3, [Campo12_4] = @Campo12_4, [Campo12_5] = @Campo12_5, [Campo13_1] = @Campo13_1, [Campo13_2] = @Campo13_2, [Campo13_3] = @Campo13_3, [Campo13_4] = @Campo13_4, [Campo13_5] = @Campo13_5, [Campo14_1] = @Campo14_1, [Campo14_2] = @Campo14_2, [Campo14_3] = @Campo14_3, [Campo14_4] = @Campo14_4, [Campo14_5] = @Campo14_5, [Campo15_1] = @Campo15_1, [Campo15_2] = @Campo15_2, [Campo15_3] = @Campo15_3, [Campo15_4] = @Campo15_4, [Campo15_5] = @Campo15_5, [Campo16_1] = @Campo16_1, [Campo16_2] = @Campo16_2, [Campo16_3] = @Campo16_3, [Campo16_4] = @Campo16_4, [Campo16_5] = @Campo16_5, [StatoOk] = @StatoOk, [CodCS] = @CodCS WHERE (([CampoUDC] = @Original_CampoUDC) AND ([Campo1_1] = @Original_Campo1_1) AND ([Campo1_2] = @Original_Campo1_2) AND ([Campo1_3] = @Original_Campo1_3) AND ([Campo1_4] = @Original_Campo1_4) AND ([Campo1_5] = @Original_Campo1_5) AND ([Campo2_1] = @Original_Campo2_1) AND ([Campo2_2] = @Original_Campo2_2) AND ([Campo2_3] = @Original_Campo2_3) AND ([Campo2_4] = @Original_Campo2_4) AND ([Campo2_5] = @Original_Campo2_5) AND ([Campo3_1] = @Original_Campo3_1) AND ([Campo3_2] = @Original_Campo3_2) AND ([Campo3_3] = @Original_Campo3_3) AND ([Campo3_4] = @Original_Campo3_4) AND ([Campo3_5] = @Original_Campo3_5) AND ([Campo4_1] = @Original_Campo4_1) AND ([Campo4_2] = @Original_Campo4_2) AND ([Campo4_3] = @Original_Campo4_3) AND ([Campo4_4] = @Original_Campo4_4) AND ([Campo4_5] = @Original_Campo4_5) AND ([Campo5_1] = @Original_Campo5_1) AND ([Campo5_2] = @Original_Campo5_2) AND ([Campo5_3] = @Original_Campo5_3) AND ([Campo5_4] = @Original_Campo5_4) AND ([Campo5_5] = @Original_Campo5_5) AND ([Campo6_1] = @Original_Campo6_1) AND ([Campo6_2] = @Original_Campo6_2) AND ([Campo6_3] = @Original_Campo6_3) AND ([Campo6_4] = @Original_Campo6_4) AND ([Campo6_5] = @Original_Campo6_5) AND ([Campo7_1] = @Original_Campo7_1) AND ([Campo7_2] = @Original_Campo7_2) AND ([Campo7_3] = @Original_Campo7_3) AND ([Campo7_4] = @Original_Campo7_4) AND ([Campo7_5] = @Original_Campo7_5) AND ([Campo8_1] = @Original_Campo8_1) AND ([Campo8_2] = @Original_Campo8_2) AND ([Campo8_3] = @Original_Campo8_3) AND ([Campo8_4] = @Original_Campo8_4) AND ([Campo8_5] = @Original_Campo8_5) AND ([Campo9_1] = @Original_Campo9_1) AND ([Campo9_2] = @Original_Campo9_2) AND ([Campo9_3] = @Original_Campo9_3) AND ([Campo9_4] = @Original_Campo9_4) AND ([Campo9_5] = @Original_Campo9_5) AND ([Campo10_1] = @Original_Campo10_1) AND ([Campo10_2] = @Original_Campo10_2) AND ([Campo10_3] = @Original_Campo10_3) AND ([Campo10_4] = @Original_Campo10_4) AND ([Campo10_5] = @Original_Campo10_5) AND ([Campo11_1_1] = @Original_Campo11_1_1) AND ([Campo11_1_2] = @Original_Campo11_1_2) AND ([Campo11_1_3] = @Original_Campo11_1_3) AND ([Campo11_1_4] = @Original_Campo11_1_4) AND ([Campo11_1_5] = @Original_Campo11_1_5) AND ([Campo11_2_1] = @Original_Campo11_2_1) AND ([Campo11_2_2] = @Original_Campo11_2_2) AND ([Campo11_2_3] = @Original_Campo11_2_3) AND ([Campo11_2_4] = @Original_Campo11_2_4) AND ([Campo11_2_5] = @Original_Campo11_2_5) AND ([Campo12_1] = @Original_Campo12_1) AND ([Campo12_2] = @Original_Campo12_2) AND ([Campo12_3] = @Original_Campo12_3) AND ([Campo12_4] = @Original_Campo12_4) AND ([Campo12_5] = @Original_Campo12_5) AND ([Campo13_1] = @Original_Campo13_1) AND ([Campo13_2] = @Original_Campo13_2) AND ([Campo13_3] = @Original_Campo13_3) AND ([Campo13_4] = @Original_Campo13_4) AND ([Campo13_5] = @Original_Campo13_5) AND ([Campo14_1] = @Original_Campo14_1) AND ([Campo14_2] = @Original_Campo14_2) AND ([Campo14_3] = @Original_Campo14_3) AND ([Campo14_4] = @Original_Campo14_4) AND ([Campo14_5] = @Original_Campo14_5) AND ([Campo15_1] = @Original_Campo15_1) AND ([Campo15_2] = @Original_Campo15_2) AND ([Campo15_3] = @Original_Campo15_3) AND ([Campo15_4] = @Original_Campo15_4) AND ([Campo15_5] = @Original_Campo15_5) AND ([Campo16_1] = @Original_Campo16_1) AND ([Campo16_2] = @Original_Campo16_2) AND ([Campo16_3] = @Original_Campo16_3) AND ([Campo16_4] = @Original_Campo16_4) AND ([Campo16_5] = @Original_Campo16_5) AND ([StatoOk] = @Original_StatoOk) AND ([CodCS] = @Original_CodCS));
|
|
SELECT CampoUDC, Campo1_1, Campo1_2, Campo1_3, Campo1_4, Campo1_5, Campo2_1, Campo2_2, Campo2_3, Campo2_4, Campo2_5, Campo3_1, Campo3_2, Campo3_3, Campo3_4, Campo3_5, Campo4_1, Campo4_2, Campo4_3, Campo4_4, Campo4_5, Campo5_1, Campo5_2, Campo5_3, Campo5_4, Campo5_5, Campo6_1, Campo6_2, Campo6_3, Campo6_4, Campo6_5, Campo7_1, Campo7_2, Campo7_3, Campo7_4, Campo7_5, Campo8_1, Campo8_2, Campo8_3, Campo8_4, Campo8_5, Campo9_1, Campo9_2, Campo9_3, Campo9_4, Campo9_5, Campo10_1, Campo10_2, Campo10_3, Campo10_4, Campo10_5, Campo11_1_1, Campo11_1_2, Campo11_1_3, Campo11_1_4, Campo11_1_5, Campo11_2_1, Campo11_2_2, Campo11_2_3, Campo11_2_4, Campo11_2_5, Campo12_1, Campo12_2, Campo12_3, Campo12_4, Campo12_5, Campo13_1, Campo13_2, Campo13_3, Campo13_4, Campo13_5, Campo14_1, Campo14_2, Campo14_3, Campo14_4, Campo14_5, Campo15_1, Campo15_2, Campo15_3, Campo15_4, Campo15_5, Campo16_1, Campo16_2, Campo16_3, Campo16_4, Campo16_5, StatoOk, CodCS FROM Odette WHERE (CampoUDC = @CampoUDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CampoUDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoUDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo3_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo4_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo5_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo6_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo7_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo8_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo9_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo10_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo11_2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo12_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo13_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo14_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo15_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Campo16_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@StatoOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="StatoOk" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodCS" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodCS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CampoUDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoUDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo1_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo2_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo3_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo3_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo4_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo4_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo5_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo5_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo6_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo6_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo7_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo7_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo8_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo8_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo9_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo9_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo10_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo10_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_1_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_1_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo11_2_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo11_2_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo12_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo12_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo13_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo13_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo14_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo14_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo15_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo15_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Campo16_5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Campo16_5" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_StatoOk" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="StatoOk" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodCS" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodCS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CampoUDC" DataSetColumn="CampoUDC" />
|
|
<Mapping SourceColumn="Campo1_1" DataSetColumn="Campo1_1" />
|
|
<Mapping SourceColumn="Campo1_2" DataSetColumn="Campo1_2" />
|
|
<Mapping SourceColumn="Campo1_3" DataSetColumn="Campo1_3" />
|
|
<Mapping SourceColumn="Campo1_4" DataSetColumn="Campo1_4" />
|
|
<Mapping SourceColumn="Campo1_5" DataSetColumn="Campo1_5" />
|
|
<Mapping SourceColumn="Campo2_1" DataSetColumn="Campo2_1" />
|
|
<Mapping SourceColumn="Campo2_2" DataSetColumn="Campo2_2" />
|
|
<Mapping SourceColumn="Campo2_3" DataSetColumn="Campo2_3" />
|
|
<Mapping SourceColumn="Campo2_4" DataSetColumn="Campo2_4" />
|
|
<Mapping SourceColumn="Campo2_5" DataSetColumn="Campo2_5" />
|
|
<Mapping SourceColumn="Campo3_1" DataSetColumn="Campo3_1" />
|
|
<Mapping SourceColumn="Campo3_2" DataSetColumn="Campo3_2" />
|
|
<Mapping SourceColumn="Campo3_3" DataSetColumn="Campo3_3" />
|
|
<Mapping SourceColumn="Campo3_4" DataSetColumn="Campo3_4" />
|
|
<Mapping SourceColumn="Campo3_5" DataSetColumn="Campo3_5" />
|
|
<Mapping SourceColumn="Campo4_1" DataSetColumn="Campo4_1" />
|
|
<Mapping SourceColumn="Campo4_2" DataSetColumn="Campo4_2" />
|
|
<Mapping SourceColumn="Campo4_3" DataSetColumn="Campo4_3" />
|
|
<Mapping SourceColumn="Campo4_4" DataSetColumn="Campo4_4" />
|
|
<Mapping SourceColumn="Campo4_5" DataSetColumn="Campo4_5" />
|
|
<Mapping SourceColumn="Campo5_1" DataSetColumn="Campo5_1" />
|
|
<Mapping SourceColumn="Campo5_2" DataSetColumn="Campo5_2" />
|
|
<Mapping SourceColumn="Campo5_3" DataSetColumn="Campo5_3" />
|
|
<Mapping SourceColumn="Campo5_4" DataSetColumn="Campo5_4" />
|
|
<Mapping SourceColumn="Campo5_5" DataSetColumn="Campo5_5" />
|
|
<Mapping SourceColumn="Campo6_1" DataSetColumn="Campo6_1" />
|
|
<Mapping SourceColumn="Campo6_2" DataSetColumn="Campo6_2" />
|
|
<Mapping SourceColumn="Campo6_3" DataSetColumn="Campo6_3" />
|
|
<Mapping SourceColumn="Campo6_4" DataSetColumn="Campo6_4" />
|
|
<Mapping SourceColumn="Campo6_5" DataSetColumn="Campo6_5" />
|
|
<Mapping SourceColumn="Campo7_1" DataSetColumn="Campo7_1" />
|
|
<Mapping SourceColumn="Campo7_2" DataSetColumn="Campo7_2" />
|
|
<Mapping SourceColumn="Campo7_3" DataSetColumn="Campo7_3" />
|
|
<Mapping SourceColumn="Campo7_4" DataSetColumn="Campo7_4" />
|
|
<Mapping SourceColumn="Campo7_5" DataSetColumn="Campo7_5" />
|
|
<Mapping SourceColumn="Campo8_1" DataSetColumn="Campo8_1" />
|
|
<Mapping SourceColumn="Campo8_2" DataSetColumn="Campo8_2" />
|
|
<Mapping SourceColumn="Campo8_3" DataSetColumn="Campo8_3" />
|
|
<Mapping SourceColumn="Campo8_4" DataSetColumn="Campo8_4" />
|
|
<Mapping SourceColumn="Campo8_5" DataSetColumn="Campo8_5" />
|
|
<Mapping SourceColumn="Campo9_1" DataSetColumn="Campo9_1" />
|
|
<Mapping SourceColumn="Campo9_2" DataSetColumn="Campo9_2" />
|
|
<Mapping SourceColumn="Campo9_3" DataSetColumn="Campo9_3" />
|
|
<Mapping SourceColumn="Campo9_4" DataSetColumn="Campo9_4" />
|
|
<Mapping SourceColumn="Campo9_5" DataSetColumn="Campo9_5" />
|
|
<Mapping SourceColumn="Campo10_1" DataSetColumn="Campo10_1" />
|
|
<Mapping SourceColumn="Campo10_2" DataSetColumn="Campo10_2" />
|
|
<Mapping SourceColumn="Campo10_3" DataSetColumn="Campo10_3" />
|
|
<Mapping SourceColumn="Campo10_4" DataSetColumn="Campo10_4" />
|
|
<Mapping SourceColumn="Campo10_5" DataSetColumn="Campo10_5" />
|
|
<Mapping SourceColumn="Campo11_1_1" DataSetColumn="Campo11_1_1" />
|
|
<Mapping SourceColumn="Campo11_1_2" DataSetColumn="Campo11_1_2" />
|
|
<Mapping SourceColumn="Campo11_1_3" DataSetColumn="Campo11_1_3" />
|
|
<Mapping SourceColumn="Campo11_1_4" DataSetColumn="Campo11_1_4" />
|
|
<Mapping SourceColumn="Campo11_1_5" DataSetColumn="Campo11_1_5" />
|
|
<Mapping SourceColumn="Campo11_2_1" DataSetColumn="Campo11_2_1" />
|
|
<Mapping SourceColumn="Campo11_2_2" DataSetColumn="Campo11_2_2" />
|
|
<Mapping SourceColumn="Campo11_2_3" DataSetColumn="Campo11_2_3" />
|
|
<Mapping SourceColumn="Campo11_2_4" DataSetColumn="Campo11_2_4" />
|
|
<Mapping SourceColumn="Campo11_2_5" DataSetColumn="Campo11_2_5" />
|
|
<Mapping SourceColumn="Campo12_1" DataSetColumn="Campo12_1" />
|
|
<Mapping SourceColumn="Campo12_2" DataSetColumn="Campo12_2" />
|
|
<Mapping SourceColumn="Campo12_3" DataSetColumn="Campo12_3" />
|
|
<Mapping SourceColumn="Campo12_4" DataSetColumn="Campo12_4" />
|
|
<Mapping SourceColumn="Campo12_5" DataSetColumn="Campo12_5" />
|
|
<Mapping SourceColumn="Campo13_1" DataSetColumn="Campo13_1" />
|
|
<Mapping SourceColumn="Campo13_2" DataSetColumn="Campo13_2" />
|
|
<Mapping SourceColumn="Campo13_3" DataSetColumn="Campo13_3" />
|
|
<Mapping SourceColumn="Campo13_4" DataSetColumn="Campo13_4" />
|
|
<Mapping SourceColumn="Campo13_5" DataSetColumn="Campo13_5" />
|
|
<Mapping SourceColumn="Campo14_1" DataSetColumn="Campo14_1" />
|
|
<Mapping SourceColumn="Campo14_2" DataSetColumn="Campo14_2" />
|
|
<Mapping SourceColumn="Campo14_3" DataSetColumn="Campo14_3" />
|
|
<Mapping SourceColumn="Campo14_4" DataSetColumn="Campo14_4" />
|
|
<Mapping SourceColumn="Campo14_5" DataSetColumn="Campo14_5" />
|
|
<Mapping SourceColumn="Campo15_1" DataSetColumn="Campo15_1" />
|
|
<Mapping SourceColumn="Campo15_2" DataSetColumn="Campo15_2" />
|
|
<Mapping SourceColumn="Campo15_3" DataSetColumn="Campo15_3" />
|
|
<Mapping SourceColumn="Campo15_4" DataSetColumn="Campo15_4" />
|
|
<Mapping SourceColumn="Campo15_5" DataSetColumn="Campo15_5" />
|
|
<Mapping SourceColumn="Campo16_1" DataSetColumn="Campo16_1" />
|
|
<Mapping SourceColumn="Campo16_2" DataSetColumn="Campo16_2" />
|
|
<Mapping SourceColumn="Campo16_3" DataSetColumn="Campo16_3" />
|
|
<Mapping SourceColumn="Campo16_4" DataSetColumn="Campo16_4" />
|
|
<Mapping SourceColumn="Campo16_5" DataSetColumn="Campo16_5" />
|
|
<Mapping SourceColumn="StatoOk" DataSetColumn="StatoOk" />
|
|
<Mapping SourceColumn="CodCS" DataSetColumn="CodCS" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_ODETTE_caricaDatiBollaEtichettaOdette" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="caricaDatiBollaEtichettaOdette" Modifier="Public" Name="caricaDatiBollaEtichettaOdette" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="caricaDatiBollaEtichettaOdette">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_caricaDatiBollaEtichettaOdette</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="@CodCS" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@numBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="6" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@dataBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodMag" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@GrpBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Particolare" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_deleteByLDP" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteByLDP" Modifier="Public" Name="deleteByLDP" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="deleteByLDP">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_deleteByLDP</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="@CodLista" Precision="0" ProviderType="NVarChar" Scale="0" Size="12" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="deleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_delete</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_CampoUDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_getByBolla" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByBolla" GetMethodModifier="Public" GetMethodName="getByBolla" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByBolla" UserSourceName="getByBolla">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_getByBolla</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="@CodMag" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@GrpBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@NumBolla" Precision="6" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@DataBolla" Precision="8" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Particolare" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_getByListaPrelievo" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCodLista" GetMethodModifier="Public" GetMethodName="getByCodLista" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCodLista" UserSourceName="getByCodLista">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_getByListaPrelievo</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="@CodLista" Precision="0" ProviderType="NVarChar" Scale="0" Size="12" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_getByUDC" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUdc" GetMethodModifier="Public" GetMethodName="getByUdc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUdc" UserSourceName="getByUdc">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_getByUDC</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="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_setStato" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="setStato" Modifier="Public" Name="setStato" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="setStato">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_setStato</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="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@StatoOk" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_updateLingua" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateLingua" Modifier="Public" Name="updateLingua" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="updateLingua">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_updateLingua</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="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo3_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo4_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo5_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo6_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo7_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo8_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo9_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo10_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo11_1_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo11_2_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo12_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo13_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo14_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo15_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Campo16_1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_ODETTE_updateVal" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateValAs400" Modifier="Public" Name="updateValAs400" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="updateValAs400">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_updateVal</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="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ragSocCli" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@indirCli" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@capCittCli" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ragSocDest" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@indirDest" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@capCittDest" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@pesoNetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@pesoLordo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@numColli" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@disPart" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@descPart" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codPart" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codImb" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codMaz" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codNael" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codAQP" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_ODETTE_upsertUdc" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="upsertUdc" Modifier="Public" Name="upsertUdc" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="upsertUdc">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ODETTE_upsertUdc</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="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodCS" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@numBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="6" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@dataBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodMag" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@GrpBolla" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Particolare" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodLista" Precision="0" ProviderType="NVarChar" Scale="0" Size="12" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IndStabFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@qtaCont" 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="stp_OdetteStatoCreateTableAdapter" GeneratorDataComponentClassName="stp_OdetteStatoCreateTableAdapter" Name="stp_OdetteStatoCreate" UserDataComponentName="stp_OdetteStatoCreateTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_OdetteStatoCreate" 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_OdetteStatoCreate</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="@CodLista" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="OdetteCreate" DataSetColumn="OdetteCreate" />
|
|
<Mapping SourceColumn="OdetteDaCreare" DataSetColumn="OdetteDaCreare" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Odette" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Odette" msprop:Generator_UserDSName="DS_Odette">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="BORI202J" msprop:Generator_UserTableName="BORI202J" msprop:Generator_RowEvArgName="BORI202JRowChangeEvent" msprop:Generator_TableVarName="tableBORI202J" msprop:Generator_TablePropName="BORI202J" msprop:Generator_RowDeletingName="BORI202JRowDeleting" msprop:Generator_RowChangingName="BORI202JRowChanging" msprop:Generator_RowDeletedName="BORI202JRowDeleted" msprop:Generator_RowEvHandlerName="BORI202JRowChangeEventHandler" msprop:Generator_TableClassName="BORI202JDataTable" msprop:Generator_RowChangedName="BORI202JRowChanged" msprop:Generator_RowClassName="BORI202JRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CDMFS" msprop:Generator_ColumnVarNameInTable="columnCDMFS" msprop:Generator_ColumnPropNameInRow="CDMFS" msprop:Generator_ColumnPropNameInTable="CDMFSColumn" msprop:Generator_UserColumnName="CDMFS">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="GRBOS" msprop:Generator_ColumnVarNameInTable="columnGRBOS" msprop:Generator_ColumnPropNameInRow="GRBOS" msprop:Generator_ColumnPropNameInTable="GRBOSColumn" msprop:Generator_UserColumnName="GRBOS">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DTBOS" msprop:Generator_ColumnVarNameInTable="columnDTBOS" msprop:Generator_ColumnPropNameInRow="DTBOS" msprop:Generator_ColumnPropNameInTable="DTBOSColumn" msprop:Generator_UserColumnName="DTBOS" type="xs:decimal" />
|
|
<xs:element name="NRBOS" msprop:Generator_ColumnVarNameInTable="columnNRBOS" msprop:Generator_ColumnPropNameInRow="NRBOS" msprop:Generator_ColumnPropNameInTable="NRBOSColumn" msprop:Generator_UserColumnName="NRBOS" type="xs:decimal" />
|
|
<xs:element name="CDARS" msprop:Generator_ColumnVarNameInTable="columnCDARS" msprop:Generator_ColumnPropNameInRow="CDARS" msprop:Generator_ColumnPropNameInTable="CDARSColumn" msprop:Generator_UserColumnName="CDARS">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NRRGS" msprop:Generator_ColumnVarNameInTable="columnNRRGS" msprop:Generator_ColumnPropNameInRow="NRRGS" msprop:Generator_ColumnPropNameInTable="NRRGSColumn" msprop:Generator_UserColumnName="NRRGS" type="xs:decimal" />
|
|
<xs:element name="CDINB" msprop:Generator_ColumnVarNameInTable="columnCDINB" msprop:Generator_ColumnPropNameInRow="CDINB" msprop:Generator_ColumnPropNameInTable="CDINBColumn" msprop:Generator_UserColumnName="CDINB">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RA1ND" msprop:Generator_ColumnVarNameInTable="columnRA1ND" msprop:Generator_ColumnPropNameInRow="RA1ND" msprop:Generator_ColumnPropNameInTable="RA1NDColumn" msprop:Generator_UserColumnName="RA1ND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RA2ND" msprop:Generator_ColumnVarNameInTable="columnRA2ND" msprop:Generator_ColumnPropNameInRow="RA2ND" msprop:Generator_ColumnPropNameInTable="RA2NDColumn" msprop:Generator_UserColumnName="RA2ND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CAPND" msprop:Generator_ColumnVarNameInTable="columnCAPND" msprop:Generator_ColumnPropNameInRow="CAPND" msprop:Generator_ColumnPropNameInTable="CAPNDColumn" msprop:Generator_UserColumnName="CAPND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CITND" msprop:Generator_ColumnVarNameInTable="columnCITND" msprop:Generator_ColumnPropNameInRow="CITND" msprop:Generator_ColumnPropNameInTable="CITNDColumn" msprop:Generator_UserColumnName="CITND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="25" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RASCL" msprop:Generator_ColumnVarNameInTable="columnRASCL" msprop:Generator_ColumnPropNameInRow="RASCL" msprop:Generator_ColumnPropNameInTable="RASCLColumn" msprop:Generator_UserColumnName="RASCL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="INDCL" msprop:Generator_ColumnVarNameInTable="columnINDCL" msprop:Generator_ColumnPropNameInRow="INDCL" msprop:Generator_ColumnPropNameInTable="INDCLColumn" msprop:Generator_UserColumnName="INDCL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CAPCL" msprop:Generator_ColumnVarNameInTable="columnCAPCL" msprop:Generator_ColumnPropNameInRow="CAPCL" msprop:Generator_ColumnPropNameInTable="CAPCLColumn" msprop:Generator_UserColumnName="CAPCL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LOCCL" msprop:Generator_ColumnVarNameInTable="columnLOCCL" msprop:Generator_ColumnPropNameInRow="LOCCL" msprop:Generator_ColumnPropNameInTable="LOCCLColumn" msprop:Generator_UserColumnName="LOCCL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="25" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PROCL" msprop:Generator_ColumnVarNameInTable="columnPROCL" msprop:Generator_ColumnPropNameInRow="PROCL" msprop:Generator_ColumnPropNameInTable="PROCLColumn" msprop:Generator_UserColumnName="PROCL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="INEND" msprop:Generator_ColumnVarNameInTable="columnINEND" msprop:Generator_ColumnPropNameInRow="INEND" msprop:Generator_ColumnPropNameInTable="INENDColumn" msprop:Generator_UserColumnName="INEND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CRAGCL" msprop:Generator_ColumnVarNameInTable="columnCRAGCL" msprop:Generator_ColumnPropNameInRow="CRAGCL" msprop:Generator_ColumnPropNameInTable="CRAGCLColumn" msprop:Generator_UserColumnName="CRAGCL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TELND" msprop:Generator_ColumnVarNameInTable="columnTELND" msprop:Generator_ColumnPropNameInRow="TELND" msprop:Generator_ColumnPropNameInTable="TELNDColumn" msprop:Generator_UserColumnName="TELND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CCDMOL" msprop:Generator_ColumnVarNameInTable="columnCCDMOL" msprop:Generator_ColumnPropNameInRow="CCDMOL" msprop:Generator_ColumnPropNameInTable="CCDMOLColumn" msprop:Generator_UserColumnName="CCDMOL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CCDPTR" msprop:Generator_ColumnVarNameInTable="columnCCDPTR" msprop:Generator_ColumnPropNameInRow="CCDPTR" msprop:Generator_ColumnPropNameInTable="CCDPTRColumn" msprop:Generator_UserColumnName="CCDPTR">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EPLAVO" msprop:Generator_ColumnVarNameInTable="columnEPLAVO" msprop:Generator_ColumnPropNameInRow="EPLAVO" msprop:Generator_ColumnPropNameInTable="EPLAVOColumn" msprop:Generator_UserColumnName="EPLAVO" type="xs:decimal" />
|
|
<xs:element name="NRC1B" msprop:Generator_ColumnVarNameInTable="columnNRC1B" msprop:Generator_ColumnPropNameInRow="NRC1B" msprop:Generator_ColumnPropNameInTable="NRC1BColumn" msprop:Generator_UserColumnName="NRC1B" type="xs:decimal" />
|
|
<xs:element name="ECMM01" msprop:Generator_ColumnVarNameInTable="columnECMM01" msprop:Generator_ColumnPropNameInRow="ECMM01" msprop:Generator_ColumnPropNameInTable="ECMM01Column" msprop:Generator_UserColumnName="ECMM01">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DEPAR" msprop:Generator_ColumnVarNameInTable="columnDEPAR" msprop:Generator_ColumnPropNameInRow="DEPAR" msprop:Generator_ColumnPropNameInTable="DEPARColumn" msprop:Generator_UserColumnName="DEPAR">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RCARTC" msprop:Generator_ColumnVarNameInTable="columnRCARTC" msprop:Generator_ColumnPropNameInRow="RCARTC" msprop:Generator_ColumnPropNameInTable="RCARTCColumn" msprop:Generator_UserColumnName="RCARTC">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PERND" msprop:Generator_ColumnVarNameInTable="columnPERND" msprop:Generator_ColumnPropNameInRow="PERND" msprop:Generator_ColumnPropNameInTable="PERNDColumn" msprop:Generator_UserColumnName="PERND">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CCDET1" msprop:Generator_ColumnVarNameInTable="columnCCDET1" msprop:Generator_ColumnPropNameInRow="CCDET1" msprop:Generator_ColumnPropNameInTable="CCDET1Column" msprop:Generator_UserColumnName="CCDET1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ECDNAE" msprop:Generator_ColumnVarNameInTable="columnECDNAE" msprop:Generator_ColumnPropNameInRow="ECDNAE" msprop:Generator_ColumnPropNameInTable="ECDNAEColumn" msprop:Generator_UserColumnName="ECDNAE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ECDNA1" msprop:Generator_ColumnVarNameInTable="columnECDNA1" msprop:Generator_ColumnPropNameInRow="ECDNA1" msprop:Generator_ColumnPropNameInTable="ECDNA1Column" msprop:Generator_UserColumnName="ECDNA1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EESPMD" msprop:Generator_ColumnVarNameInTable="columnEESPMD" msprop:Generator_ColumnPropNameInRow="EESPMD" msprop:Generator_ColumnPropNameInTable="EESPMDColumn" msprop:Generator_UserColumnName="EESPMD">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PELDB" msprop:Generator_ColumnVarNameInTable="columnPELDB" msprop:Generator_ColumnPropNameInRow="PELDB" msprop:Generator_ColumnPropNameInTable="PELDBColumn" msprop:Generator_UserColumnName="PELDB" type="xs:decimal" />
|
|
<xs:element name="QTCNS" msprop:Generator_ColumnVarNameInTable="columnQTCNS" msprop:Generator_ColumnPropNameInRow="QTCNS" msprop:Generator_ColumnPropNameInTable="QTCNSColumn" msprop:Generator_UserColumnName="QTCNS" type="xs:decimal" />
|
|
<xs:element name="ECLAQP" msprop:Generator_ColumnVarNameInTable="columnECLAQP" msprop:Generator_ColumnPropNameInRow="ECLAQP" msprop:Generator_ColumnPropNameInTable="ECLAQPColumn" msprop:Generator_UserColumnName="ECLAQP">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EPNETT" msprop:Generator_ColumnVarNameInTable="columnEPNETT" msprop:Generator_ColumnPropNameInRow="EPNETT" msprop:Generator_ColumnPropNameInTable="EPNETTColumn" msprop:Generator_UserColumnName="EPNETT" type="xs:decimal" />
|
|
<xs:element name="FCDI01" msprop:Generator_ColumnVarNameInTable="columnFCDI01" msprop:Generator_ColumnPropNameInRow="FCDI01" msprop:Generator_ColumnPropNameInTable="FCDI01Column" msprop:Generator_UserColumnName="FCDI01">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="35" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OCDODM" msprop:Generator_ColumnVarNameInTable="columnOCDODM" msprop:Generator_ColumnPropNameInRow="OCDODM" msprop:Generator_ColumnPropNameInTable="OCDODMColumn" msprop:Generator_UserColumnName="OCDODM">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CCFOE1" msprop:Generator_ColumnVarNameInTable="columnCCFOE1" msprop:Generator_ColumnPropNameInRow="CCFOE1" msprop:Generator_ColumnPropNameInTable="CCFOE1Column" msprop:Generator_UserColumnName="CCFOE1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Odette" msprop:Generator_UserTableName="Odette" msprop:Generator_RowEvArgName="OdetteRowChangeEvent" msprop:Generator_TableVarName="tableOdette" msprop:Generator_TablePropName="Odette" msprop:Generator_RowDeletingName="OdetteRowDeleting" msprop:Generator_RowChangingName="OdetteRowChanging" msprop:Generator_RowDeletedName="OdetteRowDeleted" msprop:Generator_RowEvHandlerName="OdetteRowChangeEventHandler" msprop:Generator_TableClassName="OdetteDataTable" msprop:Generator_RowChangedName="OdetteRowChanged" msprop:Generator_RowClassName="OdetteRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CampoUDC" msprop:Generator_ColumnVarNameInTable="columnCampoUDC" msprop:Generator_ColumnPropNameInRow="CampoUDC" msprop:Generator_ColumnPropNameInTable="CampoUDCColumn" msprop:Generator_UserColumnName="CampoUDC">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_1" msprop:Generator_ColumnVarNameInTable="columnCampo1_1" msprop:Generator_ColumnPropNameInRow="Campo1_1" msprop:Generator_ColumnPropNameInTable="Campo1_1Column" msprop:Generator_UserColumnName="Campo1_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_2" msprop:Generator_ColumnVarNameInTable="columnCampo1_2" msprop:Generator_ColumnPropNameInRow="Campo1_2" msprop:Generator_ColumnPropNameInTable="Campo1_2Column" msprop:Generator_UserColumnName="Campo1_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_3" msprop:Generator_ColumnVarNameInTable="columnCampo1_3" msprop:Generator_ColumnPropNameInRow="Campo1_3" msprop:Generator_ColumnPropNameInTable="Campo1_3Column" msprop:Generator_UserColumnName="Campo1_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_4" msprop:Generator_ColumnVarNameInTable="columnCampo1_4" msprop:Generator_ColumnPropNameInRow="Campo1_4" msprop:Generator_ColumnPropNameInTable="Campo1_4Column" msprop:Generator_UserColumnName="Campo1_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_5" msprop:Generator_ColumnVarNameInTable="columnCampo1_5" msprop:Generator_ColumnPropNameInRow="Campo1_5" msprop:Generator_ColumnPropNameInTable="Campo1_5Column" msprop:Generator_UserColumnName="Campo1_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_1" msprop:Generator_ColumnVarNameInTable="columnCampo2_1" msprop:Generator_ColumnPropNameInRow="Campo2_1" msprop:Generator_ColumnPropNameInTable="Campo2_1Column" msprop:Generator_UserColumnName="Campo2_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_2" msprop:Generator_ColumnVarNameInTable="columnCampo2_2" msprop:Generator_ColumnPropNameInRow="Campo2_2" msprop:Generator_ColumnPropNameInTable="Campo2_2Column" msprop:Generator_UserColumnName="Campo2_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_3" msprop:Generator_ColumnVarNameInTable="columnCampo2_3" msprop:Generator_ColumnPropNameInRow="Campo2_3" msprop:Generator_ColumnPropNameInTable="Campo2_3Column" msprop:Generator_UserColumnName="Campo2_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_4" msprop:Generator_ColumnVarNameInTable="columnCampo2_4" msprop:Generator_ColumnPropNameInRow="Campo2_4" msprop:Generator_ColumnPropNameInTable="Campo2_4Column" msprop:Generator_UserColumnName="Campo2_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_5" msprop:Generator_ColumnVarNameInTable="columnCampo2_5" msprop:Generator_ColumnPropNameInRow="Campo2_5" msprop:Generator_ColumnPropNameInTable="Campo2_5Column" msprop:Generator_UserColumnName="Campo2_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_1" msprop:Generator_ColumnVarNameInTable="columnCampo3_1" msprop:Generator_ColumnPropNameInRow="Campo3_1" msprop:Generator_ColumnPropNameInTable="Campo3_1Column" msprop:Generator_UserColumnName="Campo3_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_2" msprop:Generator_ColumnVarNameInTable="columnCampo3_2" msprop:Generator_ColumnPropNameInRow="Campo3_2" msprop:Generator_ColumnPropNameInTable="Campo3_2Column" msprop:Generator_UserColumnName="Campo3_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_3" msprop:Generator_ColumnVarNameInTable="columnCampo3_3" msprop:Generator_ColumnPropNameInRow="Campo3_3" msprop:Generator_ColumnPropNameInTable="Campo3_3Column" msprop:Generator_UserColumnName="Campo3_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_4" msprop:Generator_ColumnVarNameInTable="columnCampo3_4" msprop:Generator_ColumnPropNameInRow="Campo3_4" msprop:Generator_ColumnPropNameInTable="Campo3_4Column" msprop:Generator_UserColumnName="Campo3_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_5" msprop:Generator_ColumnVarNameInTable="columnCampo3_5" msprop:Generator_ColumnPropNameInRow="Campo3_5" msprop:Generator_ColumnPropNameInTable="Campo3_5Column" msprop:Generator_UserColumnName="Campo3_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_1" msprop:Generator_ColumnVarNameInTable="columnCampo4_1" msprop:Generator_ColumnPropNameInRow="Campo4_1" msprop:Generator_ColumnPropNameInTable="Campo4_1Column" msprop:Generator_UserColumnName="Campo4_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_2" msprop:Generator_ColumnVarNameInTable="columnCampo4_2" msprop:Generator_ColumnPropNameInRow="Campo4_2" msprop:Generator_ColumnPropNameInTable="Campo4_2Column" msprop:Generator_UserColumnName="Campo4_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_3" msprop:Generator_ColumnVarNameInTable="columnCampo4_3" msprop:Generator_ColumnPropNameInRow="Campo4_3" msprop:Generator_ColumnPropNameInTable="Campo4_3Column" msprop:Generator_UserColumnName="Campo4_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_4" msprop:Generator_ColumnVarNameInTable="columnCampo4_4" msprop:Generator_ColumnPropNameInRow="Campo4_4" msprop:Generator_ColumnPropNameInTable="Campo4_4Column" msprop:Generator_UserColumnName="Campo4_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_5" msprop:Generator_ColumnVarNameInTable="columnCampo4_5" msprop:Generator_ColumnPropNameInRow="Campo4_5" msprop:Generator_ColumnPropNameInTable="Campo4_5Column" msprop:Generator_UserColumnName="Campo4_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_1" msprop:Generator_ColumnVarNameInTable="columnCampo5_1" msprop:Generator_ColumnPropNameInRow="Campo5_1" msprop:Generator_ColumnPropNameInTable="Campo5_1Column" msprop:Generator_UserColumnName="Campo5_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_2" msprop:Generator_ColumnVarNameInTable="columnCampo5_2" msprop:Generator_ColumnPropNameInRow="Campo5_2" msprop:Generator_ColumnPropNameInTable="Campo5_2Column" msprop:Generator_UserColumnName="Campo5_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_3" msprop:Generator_ColumnVarNameInTable="columnCampo5_3" msprop:Generator_ColumnPropNameInRow="Campo5_3" msprop:Generator_ColumnPropNameInTable="Campo5_3Column" msprop:Generator_UserColumnName="Campo5_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_4" msprop:Generator_ColumnVarNameInTable="columnCampo5_4" msprop:Generator_ColumnPropNameInRow="Campo5_4" msprop:Generator_ColumnPropNameInTable="Campo5_4Column" msprop:Generator_UserColumnName="Campo5_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_5" msprop:Generator_ColumnVarNameInTable="columnCampo5_5" msprop:Generator_ColumnPropNameInRow="Campo5_5" msprop:Generator_ColumnPropNameInTable="Campo5_5Column" msprop:Generator_UserColumnName="Campo5_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_1" msprop:Generator_ColumnVarNameInTable="columnCampo6_1" msprop:Generator_ColumnPropNameInRow="Campo6_1" msprop:Generator_ColumnPropNameInTable="Campo6_1Column" msprop:Generator_UserColumnName="Campo6_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_2" msprop:Generator_ColumnVarNameInTable="columnCampo6_2" msprop:Generator_ColumnPropNameInRow="Campo6_2" msprop:Generator_ColumnPropNameInTable="Campo6_2Column" msprop:Generator_UserColumnName="Campo6_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_3" msprop:Generator_ColumnVarNameInTable="columnCampo6_3" msprop:Generator_ColumnPropNameInRow="Campo6_3" msprop:Generator_ColumnPropNameInTable="Campo6_3Column" msprop:Generator_UserColumnName="Campo6_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_4" msprop:Generator_ColumnVarNameInTable="columnCampo6_4" msprop:Generator_ColumnPropNameInRow="Campo6_4" msprop:Generator_ColumnPropNameInTable="Campo6_4Column" msprop:Generator_UserColumnName="Campo6_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_5" msprop:Generator_ColumnVarNameInTable="columnCampo6_5" msprop:Generator_ColumnPropNameInRow="Campo6_5" msprop:Generator_ColumnPropNameInTable="Campo6_5Column" msprop:Generator_UserColumnName="Campo6_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_1" msprop:Generator_ColumnVarNameInTable="columnCampo7_1" msprop:Generator_ColumnPropNameInRow="Campo7_1" msprop:Generator_ColumnPropNameInTable="Campo7_1Column" msprop:Generator_UserColumnName="Campo7_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_2" msprop:Generator_ColumnVarNameInTable="columnCampo7_2" msprop:Generator_ColumnPropNameInRow="Campo7_2" msprop:Generator_ColumnPropNameInTable="Campo7_2Column" msprop:Generator_UserColumnName="Campo7_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_3" msprop:Generator_ColumnVarNameInTable="columnCampo7_3" msprop:Generator_ColumnPropNameInRow="Campo7_3" msprop:Generator_ColumnPropNameInTable="Campo7_3Column" msprop:Generator_UserColumnName="Campo7_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_4" msprop:Generator_ColumnVarNameInTable="columnCampo7_4" msprop:Generator_ColumnPropNameInRow="Campo7_4" msprop:Generator_ColumnPropNameInTable="Campo7_4Column" msprop:Generator_UserColumnName="Campo7_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_5" msprop:Generator_ColumnVarNameInTable="columnCampo7_5" msprop:Generator_ColumnPropNameInRow="Campo7_5" msprop:Generator_ColumnPropNameInTable="Campo7_5Column" msprop:Generator_UserColumnName="Campo7_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_1" msprop:Generator_ColumnVarNameInTable="columnCampo8_1" msprop:Generator_ColumnPropNameInRow="Campo8_1" msprop:Generator_ColumnPropNameInTable="Campo8_1Column" msprop:Generator_UserColumnName="Campo8_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_2" msprop:Generator_ColumnVarNameInTable="columnCampo8_2" msprop:Generator_ColumnPropNameInRow="Campo8_2" msprop:Generator_ColumnPropNameInTable="Campo8_2Column" msprop:Generator_UserColumnName="Campo8_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_3" msprop:Generator_ColumnVarNameInTable="columnCampo8_3" msprop:Generator_ColumnPropNameInRow="Campo8_3" msprop:Generator_ColumnPropNameInTable="Campo8_3Column" msprop:Generator_UserColumnName="Campo8_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_4" msprop:Generator_ColumnVarNameInTable="columnCampo8_4" msprop:Generator_ColumnPropNameInRow="Campo8_4" msprop:Generator_ColumnPropNameInTable="Campo8_4Column" msprop:Generator_UserColumnName="Campo8_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_5" msprop:Generator_ColumnVarNameInTable="columnCampo8_5" msprop:Generator_ColumnPropNameInRow="Campo8_5" msprop:Generator_ColumnPropNameInTable="Campo8_5Column" msprop:Generator_UserColumnName="Campo8_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_1" msprop:Generator_ColumnVarNameInTable="columnCampo9_1" msprop:Generator_ColumnPropNameInRow="Campo9_1" msprop:Generator_ColumnPropNameInTable="Campo9_1Column" msprop:Generator_UserColumnName="Campo9_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_2" msprop:Generator_ColumnVarNameInTable="columnCampo9_2" msprop:Generator_ColumnPropNameInRow="Campo9_2" msprop:Generator_ColumnPropNameInTable="Campo9_2Column" msprop:Generator_UserColumnName="Campo9_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_3" msprop:Generator_ColumnVarNameInTable="columnCampo9_3" msprop:Generator_ColumnPropNameInRow="Campo9_3" msprop:Generator_ColumnPropNameInTable="Campo9_3Column" msprop:Generator_UserColumnName="Campo9_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_4" msprop:Generator_ColumnVarNameInTable="columnCampo9_4" msprop:Generator_ColumnPropNameInRow="Campo9_4" msprop:Generator_ColumnPropNameInTable="Campo9_4Column" msprop:Generator_UserColumnName="Campo9_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_5" msprop:Generator_ColumnVarNameInTable="columnCampo9_5" msprop:Generator_ColumnPropNameInRow="Campo9_5" msprop:Generator_ColumnPropNameInTable="Campo9_5Column" msprop:Generator_UserColumnName="Campo9_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_1" msprop:Generator_ColumnVarNameInTable="columnCampo10_1" msprop:Generator_ColumnPropNameInRow="Campo10_1" msprop:Generator_ColumnPropNameInTable="Campo10_1Column" msprop:Generator_UserColumnName="Campo10_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_2" msprop:Generator_ColumnVarNameInTable="columnCampo10_2" msprop:Generator_ColumnPropNameInRow="Campo10_2" msprop:Generator_ColumnPropNameInTable="Campo10_2Column" msprop:Generator_UserColumnName="Campo10_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_3" msprop:Generator_ColumnVarNameInTable="columnCampo10_3" msprop:Generator_ColumnPropNameInRow="Campo10_3" msprop:Generator_ColumnPropNameInTable="Campo10_3Column" msprop:Generator_UserColumnName="Campo10_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_4" msprop:Generator_ColumnVarNameInTable="columnCampo10_4" msprop:Generator_ColumnPropNameInRow="Campo10_4" msprop:Generator_ColumnPropNameInTable="Campo10_4Column" msprop:Generator_UserColumnName="Campo10_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_5" msprop:Generator_ColumnVarNameInTable="columnCampo10_5" msprop:Generator_ColumnPropNameInRow="Campo10_5" msprop:Generator_ColumnPropNameInTable="Campo10_5Column" msprop:Generator_UserColumnName="Campo10_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_1" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_1" msprop:Generator_ColumnPropNameInRow="Campo11_1_1" msprop:Generator_ColumnPropNameInTable="Campo11_1_1Column" msprop:Generator_UserColumnName="Campo11_1_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_2" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_2" msprop:Generator_ColumnPropNameInRow="Campo11_1_2" msprop:Generator_ColumnPropNameInTable="Campo11_1_2Column" msprop:Generator_UserColumnName="Campo11_1_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_3" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_3" msprop:Generator_ColumnPropNameInRow="Campo11_1_3" msprop:Generator_ColumnPropNameInTable="Campo11_1_3Column" msprop:Generator_UserColumnName="Campo11_1_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_4" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_4" msprop:Generator_ColumnPropNameInRow="Campo11_1_4" msprop:Generator_ColumnPropNameInTable="Campo11_1_4Column" msprop:Generator_UserColumnName="Campo11_1_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_5" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_5" msprop:Generator_ColumnPropNameInRow="Campo11_1_5" msprop:Generator_ColumnPropNameInTable="Campo11_1_5Column" msprop:Generator_UserColumnName="Campo11_1_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_1" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_1" msprop:Generator_ColumnPropNameInRow="Campo11_2_1" msprop:Generator_ColumnPropNameInTable="Campo11_2_1Column" msprop:Generator_UserColumnName="Campo11_2_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_2" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_2" msprop:Generator_ColumnPropNameInRow="Campo11_2_2" msprop:Generator_ColumnPropNameInTable="Campo11_2_2Column" msprop:Generator_UserColumnName="Campo11_2_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_3" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_3" msprop:Generator_ColumnPropNameInRow="Campo11_2_3" msprop:Generator_ColumnPropNameInTable="Campo11_2_3Column" msprop:Generator_UserColumnName="Campo11_2_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_4" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_4" msprop:Generator_ColumnPropNameInRow="Campo11_2_4" msprop:Generator_ColumnPropNameInTable="Campo11_2_4Column" msprop:Generator_UserColumnName="Campo11_2_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_5" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_5" msprop:Generator_ColumnPropNameInRow="Campo11_2_5" msprop:Generator_ColumnPropNameInTable="Campo11_2_5Column" msprop:Generator_UserColumnName="Campo11_2_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_1" msprop:Generator_ColumnVarNameInTable="columnCampo12_1" msprop:Generator_ColumnPropNameInRow="Campo12_1" msprop:Generator_ColumnPropNameInTable="Campo12_1Column" msprop:Generator_UserColumnName="Campo12_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_2" msprop:Generator_ColumnVarNameInTable="columnCampo12_2" msprop:Generator_ColumnPropNameInRow="Campo12_2" msprop:Generator_ColumnPropNameInTable="Campo12_2Column" msprop:Generator_UserColumnName="Campo12_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_3" msprop:Generator_ColumnVarNameInTable="columnCampo12_3" msprop:Generator_ColumnPropNameInRow="Campo12_3" msprop:Generator_ColumnPropNameInTable="Campo12_3Column" msprop:Generator_UserColumnName="Campo12_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_4" msprop:Generator_ColumnVarNameInTable="columnCampo12_4" msprop:Generator_ColumnPropNameInRow="Campo12_4" msprop:Generator_ColumnPropNameInTable="Campo12_4Column" msprop:Generator_UserColumnName="Campo12_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_5" msprop:Generator_ColumnVarNameInTable="columnCampo12_5" msprop:Generator_ColumnPropNameInRow="Campo12_5" msprop:Generator_ColumnPropNameInTable="Campo12_5Column" msprop:Generator_UserColumnName="Campo12_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_1" msprop:Generator_ColumnVarNameInTable="columnCampo13_1" msprop:Generator_ColumnPropNameInRow="Campo13_1" msprop:Generator_ColumnPropNameInTable="Campo13_1Column" msprop:Generator_UserColumnName="Campo13_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_2" msprop:Generator_ColumnVarNameInTable="columnCampo13_2" msprop:Generator_ColumnPropNameInRow="Campo13_2" msprop:Generator_ColumnPropNameInTable="Campo13_2Column" msprop:Generator_UserColumnName="Campo13_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_3" msprop:Generator_ColumnVarNameInTable="columnCampo13_3" msprop:Generator_ColumnPropNameInRow="Campo13_3" msprop:Generator_ColumnPropNameInTable="Campo13_3Column" msprop:Generator_UserColumnName="Campo13_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_4" msprop:Generator_ColumnVarNameInTable="columnCampo13_4" msprop:Generator_ColumnPropNameInRow="Campo13_4" msprop:Generator_ColumnPropNameInTable="Campo13_4Column" msprop:Generator_UserColumnName="Campo13_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_5" msprop:Generator_ColumnVarNameInTable="columnCampo13_5" msprop:Generator_ColumnPropNameInRow="Campo13_5" msprop:Generator_ColumnPropNameInTable="Campo13_5Column" msprop:Generator_UserColumnName="Campo13_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_1" msprop:Generator_ColumnVarNameInTable="columnCampo14_1" msprop:Generator_ColumnPropNameInRow="Campo14_1" msprop:Generator_ColumnPropNameInTable="Campo14_1Column" msprop:Generator_UserColumnName="Campo14_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_2" msprop:Generator_ColumnVarNameInTable="columnCampo14_2" msprop:Generator_ColumnPropNameInRow="Campo14_2" msprop:Generator_ColumnPropNameInTable="Campo14_2Column" msprop:Generator_UserColumnName="Campo14_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_3" msprop:Generator_ColumnVarNameInTable="columnCampo14_3" msprop:Generator_ColumnPropNameInRow="Campo14_3" msprop:Generator_ColumnPropNameInTable="Campo14_3Column" msprop:Generator_UserColumnName="Campo14_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_4" msprop:Generator_ColumnVarNameInTable="columnCampo14_4" msprop:Generator_ColumnPropNameInRow="Campo14_4" msprop:Generator_ColumnPropNameInTable="Campo14_4Column" msprop:Generator_UserColumnName="Campo14_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_5" msprop:Generator_ColumnVarNameInTable="columnCampo14_5" msprop:Generator_ColumnPropNameInRow="Campo14_5" msprop:Generator_ColumnPropNameInTable="Campo14_5Column" msprop:Generator_UserColumnName="Campo14_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_1" msprop:Generator_ColumnVarNameInTable="columnCampo15_1" msprop:Generator_ColumnPropNameInRow="Campo15_1" msprop:Generator_ColumnPropNameInTable="Campo15_1Column" msprop:Generator_UserColumnName="Campo15_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_2" msprop:Generator_ColumnVarNameInTable="columnCampo15_2" msprop:Generator_ColumnPropNameInRow="Campo15_2" msprop:Generator_ColumnPropNameInTable="Campo15_2Column" msprop:Generator_UserColumnName="Campo15_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_3" msprop:Generator_ColumnVarNameInTable="columnCampo15_3" msprop:Generator_ColumnPropNameInRow="Campo15_3" msprop:Generator_ColumnPropNameInTable="Campo15_3Column" msprop:Generator_UserColumnName="Campo15_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_4" msprop:Generator_ColumnVarNameInTable="columnCampo15_4" msprop:Generator_ColumnPropNameInRow="Campo15_4" msprop:Generator_ColumnPropNameInTable="Campo15_4Column" msprop:Generator_UserColumnName="Campo15_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_5" msprop:Generator_ColumnVarNameInTable="columnCampo15_5" msprop:Generator_ColumnPropNameInRow="Campo15_5" msprop:Generator_ColumnPropNameInTable="Campo15_5Column" msprop:Generator_UserColumnName="Campo15_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_1" msprop:Generator_ColumnVarNameInTable="columnCampo16_1" msprop:Generator_ColumnPropNameInRow="Campo16_1" msprop:Generator_ColumnPropNameInTable="Campo16_1Column" msprop:Generator_UserColumnName="Campo16_1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_2" msprop:Generator_ColumnVarNameInTable="columnCampo16_2" msprop:Generator_ColumnPropNameInRow="Campo16_2" msprop:Generator_ColumnPropNameInTable="Campo16_2Column" msprop:Generator_UserColumnName="Campo16_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_3" msprop:Generator_ColumnVarNameInTable="columnCampo16_3" msprop:Generator_ColumnPropNameInRow="Campo16_3" msprop:Generator_ColumnPropNameInTable="Campo16_3Column" msprop:Generator_UserColumnName="Campo16_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_4" msprop:Generator_ColumnVarNameInTable="columnCampo16_4" msprop:Generator_ColumnPropNameInRow="Campo16_4" msprop:Generator_ColumnPropNameInTable="Campo16_4Column" msprop:Generator_UserColumnName="Campo16_4">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_5" msprop:Generator_ColumnVarNameInTable="columnCampo16_5" msprop:Generator_ColumnPropNameInRow="Campo16_5" msprop:Generator_ColumnPropNameInTable="Campo16_5Column" msprop:Generator_UserColumnName="Campo16_5">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="StatoOk" msprop:Generator_ColumnVarNameInTable="columnStatoOk" msprop:Generator_ColumnPropNameInRow="StatoOk" msprop:Generator_ColumnPropNameInTable="StatoOkColumn" msprop:Generator_UserColumnName="StatoOk" type="xs:boolean" />
|
|
<xs:element name="CodCS" msprop:Generator_ColumnVarNameInTable="columnCodCS" msprop:Generator_ColumnPropNameInRow="CodCS" msprop:Generator_ColumnPropNameInTable="CodCSColumn" msprop:Generator_UserColumnName="CodCS">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_OdetteStatoCreate" msprop:Generator_UserTableName="stp_OdetteStatoCreate" msprop:Generator_RowEvArgName="stp_OdetteStatoCreateRowChangeEvent" msprop:Generator_TableVarName="tablestp_OdetteStatoCreate" msprop:Generator_TablePropName="stp_OdetteStatoCreate" msprop:Generator_RowDeletingName="stp_OdetteStatoCreateRowDeleting" msprop:Generator_RowChangingName="stp_OdetteStatoCreateRowChanging" msprop:Generator_RowDeletedName="stp_OdetteStatoCreateRowDeleted" msprop:Generator_RowEvHandlerName="stp_OdetteStatoCreateRowChangeEventHandler" msprop:Generator_TableClassName="stp_OdetteStatoCreateDataTable" msprop:Generator_RowChangedName="stp_OdetteStatoCreateRowChanged" msprop:Generator_RowClassName="stp_OdetteStatoCreateRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="OdetteCreate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOdetteCreate" msprop:Generator_ColumnPropNameInRow="OdetteCreate" msprop:Generator_ColumnPropNameInTable="OdetteCreateColumn" msprop:Generator_UserColumnName="OdetteCreate" type="xs:int" minOccurs="0" />
|
|
<xs:element name="OdetteDaCreare" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOdetteDaCreare" msprop:Generator_ColumnPropNameInRow="OdetteDaCreare" msprop:Generator_ColumnPropNameInTable="OdetteDaCreareColumn" msprop:Generator_UserColumnName="OdetteDaCreare" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:BORI202J" />
|
|
<xs:field xpath="mstns:CDMFS" />
|
|
<xs:field xpath="mstns:GRBOS" />
|
|
<xs:field xpath="mstns:DTBOS" />
|
|
<xs:field xpath="mstns:NRBOS" />
|
|
<xs:field xpath="mstns:CDARS" />
|
|
<xs:field xpath="mstns:NRRGS" />
|
|
</xs:unique>
|
|
<xs:unique name="Odette_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Odette" />
|
|
<xs:field xpath="mstns:CampoUDC" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |