Samuele Locatelli
1359 lines
212 KiB
XML
1359 lines
212 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_WebScip" targetNamespace="http://tempuri.org/DS_WebScip.xsd" xmlns:mstns="http://tempuri.org/DS_WebScip.xsd" xmlns="http://tempuri.org/DS_WebScip.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ETS_WSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ETS_WSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ETS_Data.Properties.Settings.GlobalReference.Default.ETS_WSConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tmpFileUtTableAdapter" GeneratorDataComponentClassName="tmpFileUtTableAdapter" Name="tmpFileUt" UserDataComponentName="tmpFileUtTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.tmpFileUt" 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].[tmpFileUt] WHERE (([idxFile] = @Original_idxFile) AND ([tempName] = @Original_tempName) AND ([fullName] = @Original_fullName) AND ([userId] = @Original_userId) AND ((@IsNull_DataRic = 1 AND [DataRic] IS NULL) OR ([DataRic] = @Original_DataRic)) AND ((@IsNull_DataDoc = 1 AND [DataDoc] IS NULL) OR ([DataDoc] = @Original_DataDoc)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_Fase = 1 AND [Fase] IS NULL) OR ([Fase] = @Original_Fase)) AND ((@IsNull_Mittente = 1 AND [Mittente] IS NULL) OR ([Mittente] = @Original_Mittente)) AND ((@IsNull_Oggetto = 1 AND [Oggetto] IS NULL) OR ([Oggetto] = @Original_Oggetto)) AND ((@IsNull_InOut = 1 AND [InOut] IS NULL) OR ([InOut] = @Original_InOut)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tempName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tempName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeroCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mittente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mittente" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Mittente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mittente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Oggetto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[tmpFileUt] ([idxFile], [tempName], [fullName], [userId], [DataRic], [DataDoc], [NumeroCommessa], [AnnoCommessa], [Fase], [Mittente], [Oggetto], [InOut]) VALUES (@idxFile, @tempName, @fullName, @userId, @DataRic, @DataDoc, @NumeroCommessa, @AnnoCommessa, @Fase, @Mittente, @Oggetto, @InOut);
|
|
SELECT idxFile, tempName, fullName, userId, DataRic, DataDoc, NumeroCommessa, AnnoCommessa, Fase, Mittente, Oggetto, InOut FROM tmpFileUt WHERE (idxFile = @idxFile)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tempName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tempName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mittente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mittente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxFile, tempName, fullName, userId, DataRic, DataDoc, NumeroCommessa, AnnoCommessa, Fase, Mittente, Oggetto, InOut FROM dbo.tmpFileUt</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[tmpFileUt] SET [idxFile] = @idxFile, [tempName] = @tempName, [fullName] = @fullName, [userId] = @userId, [DataRic] = @DataRic, [DataDoc] = @DataDoc, [NumeroCommessa] = @NumeroCommessa, [AnnoCommessa] = @AnnoCommessa, [Fase] = @Fase, [Mittente] = @Mittente, [Oggetto] = @Oggetto, [InOut] = @InOut WHERE (([idxFile] = @Original_idxFile) AND ([tempName] = @Original_tempName) AND ([fullName] = @Original_fullName) AND ([userId] = @Original_userId) AND ((@IsNull_DataRic = 1 AND [DataRic] IS NULL) OR ([DataRic] = @Original_DataRic)) AND ((@IsNull_DataDoc = 1 AND [DataDoc] IS NULL) OR ([DataDoc] = @Original_DataDoc)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_Fase = 1 AND [Fase] IS NULL) OR ([Fase] = @Original_Fase)) AND ((@IsNull_Mittente = 1 AND [Mittente] IS NULL) OR ([Mittente] = @Original_Mittente)) AND ((@IsNull_Oggetto = 1 AND [Oggetto] IS NULL) OR ([Oggetto] = @Original_Oggetto)) AND ((@IsNull_InOut = 1 AND [InOut] IS NULL) OR ([InOut] = @Original_InOut)));
|
|
SELECT idxFile, tempName, fullName, userId, DataRic, DataDoc, NumeroCommessa, AnnoCommessa, Fase, Mittente, Oggetto, InOut FROM tmpFileUt WHERE (idxFile = @idxFile)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tempName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tempName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mittente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mittente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tempName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tempName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeroCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mittente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mittente" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Mittente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mittente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Oggetto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxFile" DataSetColumn="idxFile" />
|
|
<Mapping SourceColumn="tempName" DataSetColumn="tempName" />
|
|
<Mapping SourceColumn="fullName" DataSetColumn="fullName" />
|
|
<Mapping SourceColumn="userId" DataSetColumn="userId" />
|
|
<Mapping SourceColumn="DataRic" DataSetColumn="DataRic" />
|
|
<Mapping SourceColumn="DataDoc" DataSetColumn="DataDoc" />
|
|
<Mapping SourceColumn="NumeroCommessa" DataSetColumn="NumeroCommessa" />
|
|
<Mapping SourceColumn="AnnoCommessa" DataSetColumn="AnnoCommessa" />
|
|
<Mapping SourceColumn="Fase" DataSetColumn="Fase" />
|
|
<Mapping SourceColumn="Mittente" DataSetColumn="Mittente" />
|
|
<Mapping SourceColumn="Oggetto" DataSetColumn="Oggetto" />
|
|
<Mapping SourceColumn="InOut" DataSetColumn="InOut" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbDocumentiTableAdapter" GeneratorDataComponentClassName="tbDocumentiTableAdapter" Name="tbDocumenti" UserDataComponentName="tbDocumentiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.tbDocumenti" 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 [tbDocumenti] WHERE (([idxFile] = @Original_idxFile) AND ([NomeFile] = @Original_NomeFile) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ([fullPath] = @Original_fullPath) AND ([userId] = @Original_userId) AND ((@IsNull_isRed = 1 AND [isRed] IS NULL) OR ([isRed] = @Original_isRed)) AND ((@IsNull_NrProtocollo = 1 AND [NrProtocollo] IS NULL) OR ([NrProtocollo] = @Original_NrProtocollo)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)) AND ((@IsNull_Anno = 1 AND [Anno] IS NULL) OR ([Anno] = @Original_Anno)) AND ((@IsNull_DataRic = 1 AND [DataRic] IS NULL) OR ([DataRic] = @Original_DataRic)) AND ((@IsNull_DataDoc = 1 AND [DataDoc] IS NULL) OR ([DataDoc] = @Original_DataDoc)) AND ((@IsNull_Commessa = 1 AND [Commessa] IS NULL) OR ([Commessa] = @Original_Commessa)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_Fase = 1 AND [Fase] IS NULL) OR ([Fase] = @Original_Fase)) AND ((@IsNull_Fonte = 1 AND [Fonte] IS NULL) OR ([Fonte] = @Original_Fonte)) AND ((@IsNull_Oggetto = 1 AND [Oggetto] IS NULL) OR ([Oggetto] = @Original_Oggetto)) AND ((@IsNull_InOut = 1 AND [InOut] IS NULL) OR ([InOut] = @Original_InOut)) AND ((@IsNull_Tipologia = 1 AND [Tipologia] IS NULL) OR ([Tipologia] = @Original_Tipologia)) AND ((@IsNull_Riferimenti = 1 AND [Riferimenti] IS NULL) OR ([Riferimenti] = @Original_Riferimenti)) AND ((@IsNull_Attivita = 1 AND [Attivita] IS NULL) OR ([Attivita] = @Original_Attivita)) AND ((@IsNull_Autore = 1 AND [Autore] IS NULL) OR ([Autore] = @Original_Autore)) AND ((@IsNull_SA = 1 AND [SA] IS NULL) OR ([SA] = @Original_SA)) AND ((@IsNull_Redattore = 1 AND [Redattore] IS NULL) OR ([Redattore] = @Original_Redattore)) AND ((@IsNull_SR = 1 AND [SR] IS NULL) OR ([SR] = @Original_SR)) AND ((@IsNull_LegUtente = 1 AND [LegUtente] IS NULL) OR ([LegUtente] = @Original_LegUtente)) AND ((@IsNull_Spunta = 1 AND [Spunta] IS NULL) OR ([Spunta] = @Original_Spunta)) AND ((@IsNull_Num_Fattura = 1 AND [Num_Fattura] IS NULL) OR ([Num_Fattura] = @Original_Num_Fattura)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NomeFile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fullPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullPath" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isRed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NrProtocollo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrProtocollo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NrProtocollo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrProtocollo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Commessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeroCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fonte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Oggetto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipologia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipologia" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipologia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipologia" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Riferimenti" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Riferimenti" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Riferimenti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Riferimenti" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Attivita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Attivita" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Attivita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Attivita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Autore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Autore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Autore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Autore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Redattore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Redattore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Redattore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SR" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LegUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LegUtente" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LegUtente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Spunta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Spunta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Spunta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Spunta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Num_Fattura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Num_Fattura" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Num_Fattura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Num_Fattura" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[tbDocumenti] ([Nome], [fullPath], [userId], [NrProtocollo], [Numero], [Anno], [DataRic], [DataDoc], [NumeroCommessa], [AnnoCommessa], [Fase], [Fonte], [Oggetto], [InOut], [Tipologia], [Riferimenti], [Attivita], [Autore], [SA], [Redattore], [SR], [Annotazioni], [LegUtente], [NoteSystemManager], [Spunta], [Num_Fattura]) VALUES (@Nome, @fullPath, @userId, @NrProtocollo, @Numero, @Anno, @DataRic, @DataDoc, @NumeroCommessa, @AnnoCommessa, @Fase, @Fonte, @Oggetto, @InOut, @Tipologia, @Riferimenti, @Attivita, @Autore, @SA, @Redattore, @SR, @Annotazioni, @LegUtente, @NoteSystemManager, @Spunta, @Num_Fattura);
|
|
SELECT idxFile, Nome, fullPath, userId, NrProtocollo, Numero, Anno, DataRic, DataDoc, Commessa, NumeroCommessa, AnnoCommessa, Fase, Fonte, Oggetto, InOut, Tipologia, Riferimenti, Attivita, Autore, SA, Redattore, SR, Annotazioni, LegUtente, NoteSystemManager, Spunta, Num_Fattura FROM tbDocumenti WHERE (idxFile = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fullPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullPath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NrProtocollo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrProtocollo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipologia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipologia" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Riferimenti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Riferimenti" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Attivita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Attivita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Autore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Autore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Redattore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Annotazioni" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Annotazioni" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LegUtente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoteSystemManager" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="NoteSystemManager" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Spunta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Spunta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Num_Fattura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Num_Fattura" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxFile, NomeFile, Nome, fullPath, userId, isRed, NrProtocollo, Numero, Anno, DataRic, DataDoc, Commessa, NumeroCommessa, AnnoCommessa, Fase,
|
|
Fonte, Oggetto, InOut, Tipologia, Riferimenti, Attivita, Autore, SA, Redattore, SR, Annotazioni, LegUtente, NoteSystemManager, Spunta, Num_Fattura
|
|
FROM tbDocumenti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [tbDocumenti] SET [NomeFile] = @NomeFile, [fullPath] = @fullPath, [userId] = @userId, [isRed] = @isRed, [NrProtocollo] = @NrProtocollo, [Numero] = @Numero, [Anno] = @Anno, [DataRic] = @DataRic, [DataDoc] = @DataDoc, [NumeroCommessa] = @NumeroCommessa, [AnnoCommessa] = @AnnoCommessa, [Fase] = @Fase, [Fonte] = @Fonte, [Oggetto] = @Oggetto, [InOut] = @InOut, [Tipologia] = @Tipologia, [Riferimenti] = @Riferimenti, [Attivita] = @Attivita, [Autore] = @Autore, [SA] = @SA, [Redattore] = @Redattore, [SR] = @SR, [Annotazioni] = @Annotazioni, [LegUtente] = @LegUtente, [NoteSystemManager] = @NoteSystemManager, [Spunta] = @Spunta, [Num_Fattura] = @Num_Fattura WHERE (([idxFile] = @Original_idxFile) AND ([NomeFile] = @Original_NomeFile) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ([fullPath] = @Original_fullPath) AND ([userId] = @Original_userId) AND ((@IsNull_isRed = 1 AND [isRed] IS NULL) OR ([isRed] = @Original_isRed)) AND ((@IsNull_NrProtocollo = 1 AND [NrProtocollo] IS NULL) OR ([NrProtocollo] = @Original_NrProtocollo)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)) AND ((@IsNull_Anno = 1 AND [Anno] IS NULL) OR ([Anno] = @Original_Anno)) AND ((@IsNull_DataRic = 1 AND [DataRic] IS NULL) OR ([DataRic] = @Original_DataRic)) AND ((@IsNull_DataDoc = 1 AND [DataDoc] IS NULL) OR ([DataDoc] = @Original_DataDoc)) AND ((@IsNull_Commessa = 1 AND [Commessa] IS NULL) OR ([Commessa] = @Original_Commessa)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_Fase = 1 AND [Fase] IS NULL) OR ([Fase] = @Original_Fase)) AND ((@IsNull_Fonte = 1 AND [Fonte] IS NULL) OR ([Fonte] = @Original_Fonte)) AND ((@IsNull_Oggetto = 1 AND [Oggetto] IS NULL) OR ([Oggetto] = @Original_Oggetto)) AND ((@IsNull_InOut = 1 AND [InOut] IS NULL) OR ([InOut] = @Original_InOut)) AND ((@IsNull_Tipologia = 1 AND [Tipologia] IS NULL) OR ([Tipologia] = @Original_Tipologia)) AND ((@IsNull_Riferimenti = 1 AND [Riferimenti] IS NULL) OR ([Riferimenti] = @Original_Riferimenti)) AND ((@IsNull_Attivita = 1 AND [Attivita] IS NULL) OR ([Attivita] = @Original_Attivita)) AND ((@IsNull_Autore = 1 AND [Autore] IS NULL) OR ([Autore] = @Original_Autore)) AND ((@IsNull_SA = 1 AND [SA] IS NULL) OR ([SA] = @Original_SA)) AND ((@IsNull_Redattore = 1 AND [Redattore] IS NULL) OR ([Redattore] = @Original_Redattore)) AND ((@IsNull_SR = 1 AND [SR] IS NULL) OR ([SR] = @Original_SR)) AND ((@IsNull_LegUtente = 1 AND [LegUtente] IS NULL) OR ([LegUtente] = @Original_LegUtente)) AND ((@IsNull_Spunta = 1 AND [Spunta] IS NULL) OR ([Spunta] = @Original_Spunta)) AND ((@IsNull_Num_Fattura = 1 AND [Num_Fattura] IS NULL) OR ([Num_Fattura] = @Original_Num_Fattura)));
|
|
SELECT idxFile, NomeFile, Nome, fullPath, userId, isRed, NrProtocollo, Numero, Anno, DataRic, DataDoc, Commessa, NumeroCommessa, AnnoCommessa, Fase, Fonte, Oggetto, InOut, Tipologia, Riferimenti, Attivita, Autore, SA, Redattore, SR, Annotazioni, LegUtente, NoteSystemManager, Spunta, Num_Fattura FROM tbDocumenti WHERE (idxFile = @idxFile)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NomeFile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeFile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fullPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullPath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NrProtocollo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrProtocollo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipologia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipologia" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Riferimenti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Riferimenti" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Attivita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Attivita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Autore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Autore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Redattore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Annotazioni" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Annotazioni" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LegUtente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoteSystemManager" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="NoteSystemManager" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Spunta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Spunta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Num_Fattura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Num_Fattura" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NomeFile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NomeFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fullPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fullPath" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isRed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NrProtocollo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrProtocollo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NrProtocollo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrProtocollo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Anno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Anno" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Commessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeroCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumeroCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnoCommessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnoCommessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fonte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Oggetto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipologia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipologia" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipologia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipologia" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Riferimenti" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Riferimenti" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Riferimenti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Riferimenti" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Attivita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Attivita" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Attivita" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Attivita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Autore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Autore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Autore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Autore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Redattore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Redattore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Redattore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SR" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LegUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LegUtente" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LegUtente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Spunta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Spunta" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Spunta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Spunta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Num_Fattura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Num_Fattura" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Num_Fattura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Num_Fattura" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxFile" ColumnName="idxFile" DataSourceName="ETS_WS.dbo.tbDocumenti" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxFile" DataSetColumn="idxFile" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="fullPath" DataSetColumn="fullPath" />
|
|
<Mapping SourceColumn="userId" DataSetColumn="userId" />
|
|
<Mapping SourceColumn="NrProtocollo" DataSetColumn="NrProtocollo" />
|
|
<Mapping SourceColumn="Numero" DataSetColumn="Numero" />
|
|
<Mapping SourceColumn="Anno" DataSetColumn="Anno" />
|
|
<Mapping SourceColumn="DataRic" DataSetColumn="DataRic" />
|
|
<Mapping SourceColumn="DataDoc" DataSetColumn="DataDoc" />
|
|
<Mapping SourceColumn="Commessa" DataSetColumn="Commessa" />
|
|
<Mapping SourceColumn="NumeroCommessa" DataSetColumn="NumeroCommessa" />
|
|
<Mapping SourceColumn="AnnoCommessa" DataSetColumn="AnnoCommessa" />
|
|
<Mapping SourceColumn="Fase" DataSetColumn="Fase" />
|
|
<Mapping SourceColumn="Fonte" DataSetColumn="Fonte" />
|
|
<Mapping SourceColumn="Oggetto" DataSetColumn="Oggetto" />
|
|
<Mapping SourceColumn="InOut" DataSetColumn="InOut" />
|
|
<Mapping SourceColumn="Tipologia" DataSetColumn="Tipologia" />
|
|
<Mapping SourceColumn="Riferimenti" DataSetColumn="Riferimenti" />
|
|
<Mapping SourceColumn="Attivita" DataSetColumn="Attivita" />
|
|
<Mapping SourceColumn="Autore" DataSetColumn="Autore" />
|
|
<Mapping SourceColumn="SA" DataSetColumn="SA" />
|
|
<Mapping SourceColumn="Redattore" DataSetColumn="Redattore" />
|
|
<Mapping SourceColumn="SR" DataSetColumn="SR" />
|
|
<Mapping SourceColumn="Annotazioni" DataSetColumn="Annotazioni" />
|
|
<Mapping SourceColumn="LegUtente" DataSetColumn="LegUtente" />
|
|
<Mapping SourceColumn="NoteSystemManager" DataSetColumn="NoteSystemManager" />
|
|
<Mapping SourceColumn="Spunta" DataSetColumn="Spunta" />
|
|
<Mapping SourceColumn="Num_Fattura" DataSetColumn="Num_Fattura" />
|
|
<Mapping SourceColumn="NomeFile" DataSetColumn="NomeFile" />
|
|
<Mapping SourceColumn="isRed" DataSetColumn="isRed" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_getByIdxFile" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFile" GetMethodModifier="Public" GetMethodName="getByIdxFile" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFile" UserSourceName="getByIdxFile">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_getByIdxFile</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_getByNrProto" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByNrProto" GetMethodModifier="Public" GetMethodName="getByNrProto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByNrProto" UserSourceName="getByNrProto">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_getByNrProto</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Numero" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_getBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_getBySearch</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inizio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fine" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@searchAll" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isRed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_getBySearch_Count" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getBySearch_Count" Modifier="Public" Name="getBySearch_Count" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getBySearch_Count">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_getBySearch_Count</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inizio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fine" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@showRed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@searchAll" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SortExpression" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_getBySearch_Count_only" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="getBySearch_Count_only" Modifier="Public" Name="getBySearch_Count_only" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="getBySearch_Count_only">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_getBySearch_Count_only</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inizio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fine" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@showRed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@searchAll" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_getBySearch_paged" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch_paged" GetMethodModifier="Public" GetMethodName="getBySearch_paged" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch_paged" UserSourceName="getBySearch_paged">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_getBySearch_paged</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inizio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fine" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@showRed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@searchAll" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SortExpression" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_LettCons_byCommessa" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getLettConsByCommessa" GetMethodModifier="Public" GetMethodName="getLettConsByCommessa" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getLettConsByCommessa" UserSourceName="getLettConsByCommessa">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_LettCons_byCommessa</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumeroCommessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AnnoCommessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_insert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_insert</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@fullPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isProtocollo" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Autore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Redattore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isRed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="InputOutput" ParameterName="@newIdxFile" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_updateFile" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateFile" Modifier="Public" Name="updateFile" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updateFile">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_updateFile</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@fullPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tbDocs_update" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateQuery" Modifier="Public" Name="updateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="updateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tbDocs_update</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@NumeroCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@AnnoCommessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isRed" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagFasiTableAdapter" GeneratorDataComponentClassName="AnagFasiTableAdapter" Name="AnagFasi" UserDataComponentName="AnagFasiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.AnagFasi" 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].[AnagFasi] WHERE (([idxFase] = @Original_idxFase) AND ((@IsNull_codFase = 1 AND [codFase] IS NULL) OR ([codFase] = @Original_codFase)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)) AND ((@IsNull_folderName = 1 AND [folderName] IS NULL) OR ([folderName] = @Original_folderName)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_codFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_folderName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="folderName" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_folderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="folderName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagFasi] ([codFase], [descrizione], [folderName]) VALUES (@codFase, @descrizione, @folderName);
|
|
SELECT idxFase, codFase, descrizione, folderName FROM AnagFasi WHERE (idxFase = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@folderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="folderName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxFase, codFase, descrizione, folderName FROM dbo.AnagFasi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagFasi] SET [codFase] = @codFase, [descrizione] = @descrizione, [folderName] = @folderName WHERE (([idxFase] = @Original_idxFase) AND ((@IsNull_codFase = 1 AND [codFase] IS NULL) OR ([codFase] = @Original_codFase)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)) AND ((@IsNull_folderName = 1 AND [folderName] IS NULL) OR ([folderName] = @Original_folderName)));
|
|
SELECT idxFase, codFase, descrizione, folderName FROM AnagFasi WHERE (idxFase = @idxFase)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@folderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="folderName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_codFase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codFase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_folderName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="folderName" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_folderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="folderName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxFase" ColumnName="idxFase" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFase" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxFase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="codFase" DataSetColumn="codFase" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="folderName" DataSetColumn="folderName" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_fasi_Delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_fasi_Delete</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_fasi_Update" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_fasi_Update</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFase" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codFase" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@folderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagTagsTableAdapter" GeneratorDataComponentClassName="AnagTagsTableAdapter" Name="AnagTags" UserDataComponentName="AnagTagsTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.AnagTags" 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].[AnagTags] WHERE (([idxTag] = @Original_idxTag) AND ([tag] = @Original_tag))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tag" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagTags] ([tag]) VALUES (@tag);
|
|
SELECT idxTag, tag FROM AnagTags WHERE (idxTag = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tag" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxTag, tag FROM dbo.AnagTags</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagTags] SET [tag] = @tag WHERE (([idxTag] = @Original_idxTag) AND ([tag] = @Original_tag));
|
|
SELECT idxTag, tag FROM AnagTags WHERE (idxTag = @idxTag)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tag" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tag" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxTag" ColumnName="idxTag" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxTag" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxTag" DataSetColumn="idxTag" />
|
|
<Mapping SourceColumn="tag" DataSetColumn="tag" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tags_Delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tags_Delete</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxTag" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_tags_Update" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_tags_Update</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxTag" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@tag" 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="Tags2DocTableAdapter" GeneratorDataComponentClassName="Tags2DocTableAdapter" Name="Tags2Doc" UserDataComponentName="Tags2DocTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.Tags2Doc" 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].[Tags2Doc] WHERE (([idxFile] = @Original_idxFile) AND ([idxTag] = @Original_idxTag))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Tags2Doc] ([idxFile], [idxTag]) VALUES (@idxFile, @idxTag);
|
|
SELECT idxFile, idxTag FROM Tags2Doc WHERE (idxFile = @idxFile) AND (idxTag = @idxTag)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxTag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxFile, idxTag FROM dbo.Tags2Doc</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Tags2Doc] SET [idxFile] = @idxFile, [idxTag] = @idxTag WHERE (([idxFile] = @Original_idxFile) AND ([idxTag] = @Original_idxTag));
|
|
SELECT idxFile, idxTag FROM Tags2Doc WHERE (idxFile = @idxFile) AND (idxTag = @idxTag)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxTag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxFile" DataSetColumn="idxFile" />
|
|
<Mapping SourceColumn="idxTag" DataSetColumn="idxTag" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_T2D_deleteByIdxFile" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteByIdxFile" Modifier="Public" Name="deleteByIdxFile" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteByIdxFile">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_T2D_deleteByIdxFile</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_T2D_getByIdxFile" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxFile" GetMethodModifier="Public" GetMethodName="getByIdxFile" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxFile" UserSourceName="getByIdxFile">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_T2D_getByIdxFile</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFile" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbMetaDataSetTableAdapter" GeneratorDataComponentClassName="tbMetaDataSetTableAdapter" Name="tbMetaDataSet" UserDataComponentName="tbMetaDataSetTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.tbMetaDataSet" 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].[tbMetaDataSet] WHERE (([userId] = @Original_userId) AND ([setName] = @Original_setName) AND ((@IsNull_Commessa = 1 AND [Commessa] IS NULL) OR ([Commessa] = @Original_Commessa)) AND ((@IsNull_Fase = 1 AND [Fase] IS NULL) OR ([Fase] = @Original_Fase)) AND ((@IsNull_Fonte = 1 AND [Fonte] IS NULL) OR ([Fonte] = @Original_Fonte)) AND ((@IsNull_Oggetto = 1 AND [Oggetto] IS NULL) OR ([Oggetto] = @Original_Oggetto)) AND ((@IsNull_DataRic = 1 AND [DataRic] IS NULL) OR ([DataRic] = @Original_DataRic)) AND ((@IsNull_DataDoc = 1 AND [DataDoc] IS NULL) OR ([DataDoc] = @Original_DataDoc)) AND ((@IsNull_path = 1 AND [path] IS NULL) OR ([path] = @Original_path)) AND ((@IsNull_InOut = 1 AND [InOut] IS NULL) OR ([InOut] = @Original_InOut)) AND ((@IsNull_isProto = 1 AND [isProto] IS NULL) OR ([isProto] = @Original_isProto)) AND ((@IsNull_isRed = 1 AND [isRed] IS NULL) OR ([isRed] = @Original_isRed)) AND ((@IsNull_tags = 1 AND [tags] IS NULL) OR ([tags] = @Original_tags)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_setName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="setName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Commessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fonte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Oggetto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_path" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_path" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isProto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isProto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isProto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isProto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isRed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tags" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tags" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tags" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tags" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[tbMetaDataSet] ([userId], [setName], [Commessa], [Fase], [Fonte], [Oggetto], [DataRic], [DataDoc], [path], [InOut], [isProto], [isRed], [tags]) VALUES (@userId, @setName, @Commessa, @Fase, @Fonte, @Oggetto, @DataRic, @DataDoc, @path, @InOut, @isProto, @isRed, @tags);
|
|
SELECT userId, setName, Commessa, Fase, Fonte, Oggetto, DataRic, DataDoc, path, InOut, isProto, isRed, tags FROM tbMetaDataSet WHERE (setName = @setName) AND (userId = @userId)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@setName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="setName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@path" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isProto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isProto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tags" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tags" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT userId, setName, Commessa, Fase, Fonte, Oggetto, DataRic, DataDoc, path, InOut, isProto, isRed, tags FROM dbo.tbMetaDataSet</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[tbMetaDataSet] SET [userId] = @userId, [setName] = @setName, [Commessa] = @Commessa, [Fase] = @Fase, [Fonte] = @Fonte, [Oggetto] = @Oggetto, [DataRic] = @DataRic, [DataDoc] = @DataDoc, [path] = @path, [InOut] = @InOut, [isProto] = @isProto, [isRed] = @isRed, [tags] = @tags WHERE (([userId] = @Original_userId) AND ([setName] = @Original_setName) AND ((@IsNull_Commessa = 1 AND [Commessa] IS NULL) OR ([Commessa] = @Original_Commessa)) AND ((@IsNull_Fase = 1 AND [Fase] IS NULL) OR ([Fase] = @Original_Fase)) AND ((@IsNull_Fonte = 1 AND [Fonte] IS NULL) OR ([Fonte] = @Original_Fonte)) AND ((@IsNull_Oggetto = 1 AND [Oggetto] IS NULL) OR ([Oggetto] = @Original_Oggetto)) AND ((@IsNull_DataRic = 1 AND [DataRic] IS NULL) OR ([DataRic] = @Original_DataRic)) AND ((@IsNull_DataDoc = 1 AND [DataDoc] IS NULL) OR ([DataDoc] = @Original_DataDoc)) AND ((@IsNull_path = 1 AND [path] IS NULL) OR ([path] = @Original_path)) AND ((@IsNull_InOut = 1 AND [InOut] IS NULL) OR ([InOut] = @Original_InOut)) AND ((@IsNull_isProto = 1 AND [isProto] IS NULL) OR ([isProto] = @Original_isProto)) AND ((@IsNull_isRed = 1 AND [isRed] IS NULL) OR ([isRed] = @Original_isRed)) AND ((@IsNull_tags = 1 AND [tags] IS NULL) OR ([tags] = @Original_tags)));
|
|
SELECT userId, setName, Commessa, Fase, Fonte, Oggetto, DataRic, DataDoc, path, InOut, isProto, isRed, tags FROM tbMetaDataSet WHERE (setName = @setName) AND (userId = @userId)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@setName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="setName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@path" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isProto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isProto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tags" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tags" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_setName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="setName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Commessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Commessa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Commessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fase" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fase" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fonte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fonte" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fonte" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Oggetto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Oggetto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Oggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataRic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataRic" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataRic" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_path" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_path" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InOut" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InOut" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isProto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isProto" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isProto" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isProto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isRed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isRed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRed" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tags" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tags" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tags" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tags" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="userId" DataSetColumn="userId" />
|
|
<Mapping SourceColumn="setName" DataSetColumn="setName" />
|
|
<Mapping SourceColumn="Commessa" DataSetColumn="Commessa" />
|
|
<Mapping SourceColumn="Fase" DataSetColumn="Fase" />
|
|
<Mapping SourceColumn="Fonte" DataSetColumn="Fonte" />
|
|
<Mapping SourceColumn="Oggetto" DataSetColumn="Oggetto" />
|
|
<Mapping SourceColumn="DataRic" DataSetColumn="DataRic" />
|
|
<Mapping SourceColumn="DataDoc" DataSetColumn="DataDoc" />
|
|
<Mapping SourceColumn="path" DataSetColumn="path" />
|
|
<Mapping SourceColumn="InOut" DataSetColumn="InOut" />
|
|
<Mapping SourceColumn="isProto" DataSetColumn="isProto" />
|
|
<Mapping SourceColumn="isRed" DataSetColumn="isRed" />
|
|
<Mapping SourceColumn="tags" DataSetColumn="tags" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MDS_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_setName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_MDS_GetByUserId_setName" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MDS_GetByUserId_setName</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="@userId" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@setName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_MDS_getByUserId" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUserId" GetMethodModifier="Public" GetMethodName="getByUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUserId" UserSourceName="getByUserId">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MDS_getByUserId</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="@userId" 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_userLoginRefreshDbTableAdapter" GeneratorDataComponentClassName="stp_userLoginRefreshDbTableAdapter" Name="stp_userLoginRefreshDb" UserDataComponentName="stp_userLoginRefreshDbTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_WSConnectionString (Settings)" DbObjectName="ETS_WS.dbo.stp_userLoginRefreshDb" 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_userLoginRefreshDb</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="msecExec" DataSetColumn="msecExec" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_WebScip" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_WebScip" msprop:Generator_UserDSName="DS_WebScip">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="tmpFileUt" msprop:Generator_TableClassName="tmpFileUtDataTable" msprop:Generator_TableVarName="tabletmpFileUt" msprop:Generator_TablePropName="tmpFileUt" msprop:Generator_RowDeletingName="tmpFileUtRowDeleting" msprop:Generator_RowChangingName="tmpFileUtRowChanging" msprop:Generator_RowEvHandlerName="tmpFileUtRowChangeEventHandler" msprop:Generator_RowDeletedName="tmpFileUtRowDeleted" msprop:Generator_UserTableName="tmpFileUt" msprop:Generator_RowChangedName="tmpFileUtRowChanged" msprop:Generator_RowEvArgName="tmpFileUtRowChangeEvent" msprop:Generator_RowClassName="tmpFileUtRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxFile" msprop:Generator_ColumnVarNameInTable="columnidxFile" msprop:Generator_ColumnPropNameInRow="idxFile" msprop:Generator_ColumnPropNameInTable="idxFileColumn" msprop:Generator_UserColumnName="idxFile" type="xs:int" />
|
|
<xs:element name="tempName" msprop:Generator_ColumnVarNameInTable="columntempName" msprop:Generator_ColumnPropNameInRow="tempName" msprop:Generator_ColumnPropNameInTable="tempNameColumn" msprop:Generator_UserColumnName="tempName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="fullName" msprop:Generator_ColumnVarNameInTable="columnfullName" msprop:Generator_ColumnPropNameInRow="fullName" msprop:Generator_ColumnPropNameInTable="fullNameColumn" msprop:Generator_UserColumnName="fullName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="userId" msprop:Generator_ColumnVarNameInTable="columnuserId" msprop:Generator_ColumnPropNameInRow="userId" msprop:Generator_ColumnPropNameInTable="userIdColumn" msprop:Generator_UserColumnName="userId">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataRic" msprop:Generator_ColumnVarNameInTable="columnDataRic" msprop:Generator_ColumnPropNameInRow="DataRic" msprop:Generator_ColumnPropNameInTable="DataRicColumn" msprop:Generator_UserColumnName="DataRic" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataDoc" msprop:Generator_ColumnVarNameInTable="columnDataDoc" msprop:Generator_ColumnPropNameInRow="DataDoc" msprop:Generator_ColumnPropNameInTable="DataDocColumn" msprop:Generator_UserColumnName="DataDoc" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="NumeroCommessa" msprop:Generator_ColumnVarNameInTable="columnNumeroCommessa" msprop:Generator_ColumnPropNameInRow="NumeroCommessa" msprop:Generator_ColumnPropNameInTable="NumeroCommessaColumn" msprop:Generator_UserColumnName="NumeroCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AnnoCommessa" msprop:Generator_ColumnVarNameInTable="columnAnnoCommessa" msprop:Generator_ColumnPropNameInRow="AnnoCommessa" msprop:Generator_ColumnPropNameInTable="AnnoCommessaColumn" msprop:Generator_UserColumnName="AnnoCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Fase" msprop:Generator_ColumnVarNameInTable="columnFase" msprop:Generator_ColumnPropNameInRow="Fase" msprop:Generator_ColumnPropNameInTable="FaseColumn" msprop:Generator_UserColumnName="Fase" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Mittente" msprop:Generator_ColumnVarNameInTable="columnMittente" msprop:Generator_ColumnPropNameInRow="Mittente" msprop:Generator_ColumnPropNameInTable="MittenteColumn" msprop:Generator_UserColumnName="Mittente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Oggetto" msprop:Generator_ColumnVarNameInTable="columnOggetto" msprop:Generator_ColumnPropNameInRow="Oggetto" msprop:Generator_ColumnPropNameInTable="OggettoColumn" msprop:Generator_UserColumnName="Oggetto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="InOut" msprop:Generator_ColumnVarNameInTable="columnInOut" msprop:Generator_ColumnPropNameInRow="InOut" msprop:Generator_ColumnPropNameInTable="InOutColumn" msprop:Generator_UserColumnName="InOut" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="tbDocumenti" msprop:Generator_TableClassName="tbDocumentiDataTable" msprop:Generator_TableVarName="tabletbDocumenti" msprop:Generator_RowChangedName="tbDocumentiRowChanged" msprop:Generator_TablePropName="tbDocumenti" msprop:Generator_RowDeletingName="tbDocumentiRowDeleting" msprop:Generator_RowChangingName="tbDocumentiRowChanging" msprop:Generator_RowEvHandlerName="tbDocumentiRowChangeEventHandler" msprop:Generator_RowDeletedName="tbDocumentiRowDeleted" msprop:Generator_RowClassName="tbDocumentiRow" msprop:Generator_UserTableName="tbDocumenti" msprop:Generator_RowEvArgName="tbDocumentiRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxFile" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxFile" msprop:Generator_ColumnPropNameInRow="idxFile" msprop:Generator_ColumnPropNameInTable="idxFileColumn" msprop:Generator_UserColumnName="idxFile" type="xs:int" />
|
|
<xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="fullPath" msprop:Generator_ColumnVarNameInTable="columnfullPath" msprop:Generator_ColumnPropNameInRow="fullPath" msprop:Generator_ColumnPropNameInTable="fullPathColumn" msprop:Generator_UserColumnName="fullPath">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="userId" msprop:Generator_ColumnVarNameInTable="columnuserId" msprop:Generator_ColumnPropNameInRow="userId" msprop:Generator_ColumnPropNameInTable="userIdColumn" msprop:Generator_UserColumnName="userId">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NrProtocollo" msprop:Generator_ColumnVarNameInTable="columnNrProtocollo" msprop:Generator_ColumnPropNameInRow="NrProtocollo" msprop:Generator_ColumnPropNameInTable="NrProtocolloColumn" msprop:Generator_UserColumnName="NrProtocollo" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" msprop:Generator_UserColumnName="Numero" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Anno" msprop:Generator_ColumnVarNameInTable="columnAnno" msprop:Generator_ColumnPropNameInRow="Anno" msprop:Generator_ColumnPropNameInTable="AnnoColumn" msprop:Generator_UserColumnName="Anno" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DataRic" msprop:Generator_ColumnVarNameInTable="columnDataRic" msprop:Generator_ColumnPropNameInRow="DataRic" msprop:Generator_ColumnPropNameInTable="DataRicColumn" msprop:Generator_UserColumnName="DataRic" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataDoc" msprop:Generator_ColumnVarNameInTable="columnDataDoc" msprop:Generator_ColumnPropNameInRow="DataDoc" msprop:Generator_ColumnPropNameInTable="DataDocColumn" msprop:Generator_UserColumnName="DataDoc" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Commessa" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCommessa" msprop:Generator_ColumnPropNameInRow="Commessa" msprop:Generator_ColumnPropNameInTable="CommessaColumn" msprop:Generator_UserColumnName="Commessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumeroCommessa" msprop:Generator_ColumnVarNameInTable="columnNumeroCommessa" msprop:Generator_ColumnPropNameInRow="NumeroCommessa" msprop:Generator_ColumnPropNameInTable="NumeroCommessaColumn" msprop:Generator_UserColumnName="NumeroCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AnnoCommessa" msprop:Generator_ColumnVarNameInTable="columnAnnoCommessa" msprop:Generator_ColumnPropNameInRow="AnnoCommessa" msprop:Generator_ColumnPropNameInTable="AnnoCommessaColumn" msprop:Generator_UserColumnName="AnnoCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Fase" msprop:Generator_ColumnVarNameInTable="columnFase" msprop:Generator_ColumnPropNameInRow="Fase" msprop:Generator_ColumnPropNameInTable="FaseColumn" msprop:Generator_UserColumnName="Fase" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Fonte" msprop:Generator_ColumnVarNameInTable="columnFonte" msprop:Generator_ColumnPropNameInRow="Fonte" msprop:Generator_ColumnPropNameInTable="FonteColumn" msprop:Generator_UserColumnName="Fonte" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Oggetto" msprop:Generator_ColumnVarNameInTable="columnOggetto" msprop:Generator_ColumnPropNameInRow="Oggetto" msprop:Generator_ColumnPropNameInTable="OggettoColumn" msprop:Generator_UserColumnName="Oggetto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="InOut" msprop:Generator_ColumnVarNameInTable="columnInOut" msprop:Generator_ColumnPropNameInRow="InOut" msprop:Generator_ColumnPropNameInTable="InOutColumn" msprop:Generator_UserColumnName="InOut" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Tipologia" msprop:Generator_ColumnVarNameInTable="columnTipologia" msprop:Generator_ColumnPropNameInRow="Tipologia" msprop:Generator_ColumnPropNameInTable="TipologiaColumn" msprop:Generator_UserColumnName="Tipologia" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Riferimenti" msprop:Generator_ColumnVarNameInTable="columnRiferimenti" msprop:Generator_ColumnPropNameInRow="Riferimenti" msprop:Generator_ColumnPropNameInTable="RiferimentiColumn" msprop:Generator_UserColumnName="Riferimenti" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Attivita" msprop:Generator_ColumnVarNameInTable="columnAttivita" msprop:Generator_ColumnPropNameInRow="Attivita" msprop:Generator_ColumnPropNameInTable="AttivitaColumn" msprop:Generator_UserColumnName="Attivita" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Autore" msprop:Generator_ColumnVarNameInTable="columnAutore" msprop:Generator_ColumnPropNameInRow="Autore" msprop:Generator_ColumnPropNameInTable="AutoreColumn" msprop:Generator_UserColumnName="Autore" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SA" msprop:Generator_ColumnVarNameInTable="columnSA" msprop:Generator_ColumnPropNameInRow="SA" msprop:Generator_ColumnPropNameInTable="SAColumn" msprop:Generator_UserColumnName="SA" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Redattore" msprop:Generator_ColumnVarNameInTable="columnRedattore" msprop:Generator_ColumnPropNameInRow="Redattore" msprop:Generator_ColumnPropNameInTable="RedattoreColumn" msprop:Generator_UserColumnName="Redattore" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SR" msprop:Generator_ColumnVarNameInTable="columnSR" msprop:Generator_ColumnPropNameInRow="SR" msprop:Generator_ColumnPropNameInTable="SRColumn" msprop:Generator_UserColumnName="SR" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Annotazioni" msprop:Generator_ColumnVarNameInTable="columnAnnotazioni" msprop:Generator_ColumnPropNameInRow="Annotazioni" msprop:Generator_ColumnPropNameInTable="AnnotazioniColumn" msprop:Generator_UserColumnName="Annotazioni" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1073741823" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LegUtente" msprop:Generator_ColumnVarNameInTable="columnLegUtente" msprop:Generator_ColumnPropNameInRow="LegUtente" msprop:Generator_ColumnPropNameInTable="LegUtenteColumn" msprop:Generator_UserColumnName="LegUtente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="25" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NoteSystemManager" msprop:Generator_ColumnVarNameInTable="columnNoteSystemManager" msprop:Generator_ColumnPropNameInRow="NoteSystemManager" msprop:Generator_ColumnPropNameInTable="NoteSystemManagerColumn" msprop:Generator_UserColumnName="NoteSystemManager" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1073741823" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Spunta" msprop:Generator_ColumnVarNameInTable="columnSpunta" msprop:Generator_ColumnPropNameInRow="Spunta" msprop:Generator_ColumnPropNameInTable="SpuntaColumn" msprop:Generator_UserColumnName="Spunta" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Num_Fattura" msprop:Generator_ColumnVarNameInTable="columnNum_Fattura" msprop:Generator_ColumnPropNameInRow="Num_Fattura" msprop:Generator_ColumnPropNameInTable="Num_FatturaColumn" msprop:Generator_UserColumnName="Num_Fattura" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NomeFile" msprop:Generator_ColumnVarNameInTable="columnNomeFile" msprop:Generator_ColumnPropNameInRow="NomeFile" msprop:Generator_ColumnPropNameInTable="NomeFileColumn" msprop:Generator_UserColumnName="NomeFile">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="isRed" msprop:Generator_ColumnVarNameInTable="columnisRed" msprop:Generator_ColumnPropNameInRow="isRed" msprop:Generator_ColumnPropNameInTable="isRedColumn" msprop:Generator_UserColumnName="isRed" type="xs:boolean" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagFasi" msprop:Generator_TableClassName="AnagFasiDataTable" msprop:Generator_TableVarName="tableAnagFasi" msprop:Generator_TablePropName="AnagFasi" msprop:Generator_RowDeletingName="AnagFasiRowDeleting" msprop:Generator_RowChangingName="AnagFasiRowChanging" msprop:Generator_RowEvHandlerName="AnagFasiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagFasiRowDeleted" msprop:Generator_UserTableName="AnagFasi" msprop:Generator_RowChangedName="AnagFasiRowChanged" msprop:Generator_RowEvArgName="AnagFasiRowChangeEvent" msprop:Generator_RowClassName="AnagFasiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxFase" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxFase" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_UserColumnName="idxFase" type="xs:int" />
|
|
<xs:element name="codFase" msprop:Generator_ColumnVarNameInTable="columncodFase" msprop:Generator_ColumnPropNameInRow="codFase" msprop:Generator_ColumnPropNameInTable="codFaseColumn" msprop:Generator_UserColumnName="codFase" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrizione" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="folderName" msprop:Generator_ColumnVarNameInTable="columnfolderName" msprop:Generator_ColumnPropNameInRow="folderName" msprop:Generator_ColumnPropNameInTable="folderNameColumn" msprop:Generator_UserColumnName="folderName" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagTags" msprop:Generator_TableClassName="AnagTagsDataTable" msprop:Generator_TableVarName="tableAnagTags" msprop:Generator_TablePropName="AnagTags" msprop:Generator_RowDeletingName="AnagTagsRowDeleting" msprop:Generator_RowChangingName="AnagTagsRowChanging" msprop:Generator_RowEvHandlerName="AnagTagsRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagTagsRowDeleted" msprop:Generator_UserTableName="AnagTags" msprop:Generator_RowChangedName="AnagTagsRowChanged" msprop:Generator_RowEvArgName="AnagTagsRowChangeEvent" msprop:Generator_RowClassName="AnagTagsRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxTag" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxTag" msprop:Generator_ColumnPropNameInRow="idxTag" msprop:Generator_ColumnPropNameInTable="idxTagColumn" msprop:Generator_UserColumnName="idxTag" type="xs:int" />
|
|
<xs:element name="tag" msprop:Generator_ColumnVarNameInTable="columntag" msprop:Generator_ColumnPropNameInRow="tag" msprop:Generator_ColumnPropNameInTable="tagColumn" msprop:Generator_UserColumnName="tag">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Tags2Doc" msprop:Generator_TableClassName="Tags2DocDataTable" msprop:Generator_TableVarName="tableTags2Doc" msprop:Generator_TablePropName="Tags2Doc" msprop:Generator_RowDeletingName="Tags2DocRowDeleting" msprop:Generator_RowChangingName="Tags2DocRowChanging" msprop:Generator_RowEvHandlerName="Tags2DocRowChangeEventHandler" msprop:Generator_RowDeletedName="Tags2DocRowDeleted" msprop:Generator_UserTableName="Tags2Doc" msprop:Generator_RowChangedName="Tags2DocRowChanged" msprop:Generator_RowEvArgName="Tags2DocRowChangeEvent" msprop:Generator_RowClassName="Tags2DocRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxFile" msprop:Generator_ColumnVarNameInTable="columnidxFile" msprop:Generator_ColumnPropNameInRow="idxFile" msprop:Generator_ColumnPropNameInTable="idxFileColumn" msprop:Generator_UserColumnName="idxFile" type="xs:int" />
|
|
<xs:element name="idxTag" msprop:Generator_ColumnVarNameInTable="columnidxTag" msprop:Generator_ColumnPropNameInRow="idxTag" msprop:Generator_ColumnPropNameInTable="idxTagColumn" msprop:Generator_UserColumnName="idxTag" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="tbMetaDataSet" msprop:Generator_TableClassName="tbMetaDataSetDataTable" msprop:Generator_TableVarName="tabletbMetaDataSet" msprop:Generator_RowChangedName="tbMetaDataSetRowChanged" msprop:Generator_TablePropName="tbMetaDataSet" msprop:Generator_RowDeletingName="tbMetaDataSetRowDeleting" msprop:Generator_RowChangingName="tbMetaDataSetRowChanging" msprop:Generator_RowEvHandlerName="tbMetaDataSetRowChangeEventHandler" msprop:Generator_RowDeletedName="tbMetaDataSetRowDeleted" msprop:Generator_RowClassName="tbMetaDataSetRow" msprop:Generator_UserTableName="tbMetaDataSet" msprop:Generator_RowEvArgName="tbMetaDataSetRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="userId" msprop:Generator_ColumnVarNameInTable="columnuserId" msprop:Generator_ColumnPropNameInRow="userId" msprop:Generator_ColumnPropNameInTable="userIdColumn" msprop:Generator_UserColumnName="userId">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="setName" msprop:Generator_ColumnVarNameInTable="columnsetName" msprop:Generator_ColumnPropNameInRow="setName" msprop:Generator_ColumnPropNameInTable="setNameColumn" msprop:Generator_UserColumnName="setName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Commessa" msprop:Generator_ColumnVarNameInTable="columnCommessa" msprop:Generator_ColumnPropNameInRow="Commessa" msprop:Generator_ColumnPropNameInTable="CommessaColumn" msprop:Generator_UserColumnName="Commessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Fase" msprop:Generator_ColumnVarNameInTable="columnFase" msprop:Generator_ColumnPropNameInRow="Fase" msprop:Generator_ColumnPropNameInTable="FaseColumn" msprop:Generator_UserColumnName="Fase" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Fonte" msprop:Generator_ColumnVarNameInTable="columnFonte" msprop:Generator_ColumnPropNameInRow="Fonte" msprop:Generator_ColumnPropNameInTable="FonteColumn" msprop:Generator_UserColumnName="Fonte" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Oggetto" msprop:Generator_ColumnVarNameInTable="columnOggetto" msprop:Generator_ColumnPropNameInRow="Oggetto" msprop:Generator_ColumnPropNameInTable="OggettoColumn" msprop:Generator_UserColumnName="Oggetto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataRic" msprop:Generator_ColumnVarNameInTable="columnDataRic" msprop:Generator_ColumnPropNameInRow="DataRic" msprop:Generator_ColumnPropNameInTable="DataRicColumn" msprop:Generator_UserColumnName="DataRic" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataDoc" msprop:Generator_ColumnVarNameInTable="columnDataDoc" msprop:Generator_ColumnPropNameInRow="DataDoc" msprop:Generator_ColumnPropNameInTable="DataDocColumn" msprop:Generator_UserColumnName="DataDoc" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="path" msprop:Generator_ColumnVarNameInTable="columnpath" msprop:Generator_ColumnPropNameInRow="path" msprop:Generator_ColumnPropNameInTable="pathColumn" msprop:Generator_UserColumnName="path" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="InOut" msprop:Generator_ColumnVarNameInTable="columnInOut" msprop:Generator_ColumnPropNameInRow="InOut" msprop:Generator_ColumnPropNameInTable="InOutColumn" msprop:Generator_UserColumnName="InOut" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="isProto" msprop:Generator_ColumnVarNameInTable="columnisProto" msprop:Generator_ColumnPropNameInRow="isProto" msprop:Generator_ColumnPropNameInTable="isProtoColumn" msprop:Generator_UserColumnName="isProto" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="isRed" msprop:Generator_ColumnVarNameInTable="columnisRed" msprop:Generator_ColumnPropNameInRow="isRed" msprop:Generator_ColumnPropNameInTable="isRedColumn" msprop:Generator_UserColumnName="isRed" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="tags" msprop:Generator_ColumnVarNameInTable="columntags" msprop:Generator_ColumnPropNameInRow="tags" msprop:Generator_ColumnPropNameInTable="tagsColumn" msprop:Generator_UserColumnName="tags" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_userLoginRefreshDb" msprop:Generator_TableClassName="stp_userLoginRefreshDbDataTable" msprop:Generator_TableVarName="tablestp_userLoginRefreshDb" msprop:Generator_RowChangedName="stp_userLoginRefreshDbRowChanged" msprop:Generator_TablePropName="stp_userLoginRefreshDb" msprop:Generator_RowDeletingName="stp_userLoginRefreshDbRowDeleting" msprop:Generator_RowChangingName="stp_userLoginRefreshDbRowChanging" msprop:Generator_RowEvHandlerName="stp_userLoginRefreshDbRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_userLoginRefreshDbRowDeleted" msprop:Generator_RowClassName="stp_userLoginRefreshDbRow" msprop:Generator_UserTableName="stp_userLoginRefreshDb" msprop:Generator_RowEvArgName="stp_userLoginRefreshDbRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="msecExec" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmsecExec" msprop:Generator_ColumnPropNameInRow="msecExec" msprop:Generator_ColumnPropNameInTable="msecExecColumn" msprop:Generator_UserColumnName="msecExec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="32" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:tmpFileUt" />
|
|
<xs:field xpath="mstns:idxFile" />
|
|
</xs:unique>
|
|
<xs:unique name="tbDocumenti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:tbDocumenti" />
|
|
<xs:field xpath="mstns:idxFile" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagFasi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagFasi" />
|
|
<xs:field xpath="mstns:idxFase" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagTags_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagTags" />
|
|
<xs:field xpath="mstns:idxTag" />
|
|
</xs:unique>
|
|
<xs:unique name="Tags2Doc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Tags2Doc" />
|
|
<xs:field xpath="mstns:idxFile" />
|
|
<xs:field xpath="mstns:idxTag" />
|
|
</xs:unique>
|
|
<xs:unique name="tbMetaDataSet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:tbMetaDataSet" />
|
|
<xs:field xpath="mstns:userId" />
|
|
<xs:field xpath="mstns:setName" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_Tags2Doc_AnagTags" msdata:parent="AnagTags" msdata:child="Tags2Doc" msdata:parentkey="idxTag" msdata:childkey="idxTag" msprop:Generator_UserChildTable="Tags2Doc" msprop:Generator_ChildPropName="GetTags2DocRows" msprop:Generator_UserRelationName="FK_Tags2Doc_AnagTags" msprop:Generator_ParentPropName="AnagTagsRow" msprop:Generator_RelationVarName="relationFK_Tags2Doc_AnagTags" msprop:Generator_UserParentTable="AnagTags" />
|
|
<msdata:Relationship name="FK_Tags2Doc_tbDocumenti" msdata:parent="tbDocumenti" msdata:child="Tags2Doc" msdata:parentkey="idxFile" msdata:childkey="idxFile" msprop:Generator_UserChildTable="Tags2Doc" msprop:Generator_ChildPropName="GetTags2DocRows" msprop:Generator_UserRelationName="FK_Tags2Doc_tbDocumenti" msprop:Generator_ParentPropName="tbDocumentiRow" msprop:Generator_RelationVarName="relationFK_Tags2Doc_tbDocumenti" msprop:Generator_UserParentTable="tbDocumenti" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |