Samuele Locatelli
1331 lines
175 KiB
XML
1331 lines
175 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DataLayer_AnagGen" targetNamespace="http://tempuri.org/DataLayer_AnagGen.xsd" xmlns:mstns="http://tempuri.org/DataLayer_AnagGen.xsd" xmlns="http://tempuri.org/DataLayer_AnagGen.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="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Flamma_AnagraficaConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="Flamma_AnagraficaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ETS_Data.Properties.Settings.GlobalReference.Default.Flamma_AnagraficaConnectionString" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ETS_AnagraficaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ETS_AnagraficaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ETS_Data.Properties.Settings.GlobalReference.Default.ETS_AnagraficaConnectionString" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ETS_AnagraficaConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="ETS_AnagraficaConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ETS_Data.Properties.Settings.GlobalReference.Default.ETS_AnagraficaConnectionString1" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CDCTableAdapter" GeneratorDataComponentClassName="CDCTableAdapter" Name="CDC" UserDataComponentName="CDCTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.CDC" 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].[CDC] WHERE (([COD_CDC] = @Original_COD_CDC) AND ((@IsNull_DESCRIZIONE = 1 AND [DESCRIZIONE] IS NULL) OR ([DESCRIZIONE] = @Original_DESCRIZIONE)) AND ((@IsNull_POSIZIONE = 1 AND [POSIZIONE] IS NULL) OR ([POSIZIONE] = @Original_POSIZIONE)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" 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_POSIZIONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="POSIZIONE" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_POSIZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="POSIZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[CDC] ([COD_CDC], [DESCRIZIONE], [POSIZIONE]) VALUES (@COD_CDC, @DESCRIZIONE, @POSIZIONE);
|
|
SELECT COD_CDC, DESCRIZIONE, POSIZIONE FROM CDC WHERE (COD_CDC = @COD_CDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" 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="@POSIZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="POSIZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM dbo.CDC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[CDC] SET [COD_CDC] = @COD_CDC, [DESCRIZIONE] = @DESCRIZIONE, [POSIZIONE] = @POSIZIONE WHERE (([COD_CDC] = @Original_COD_CDC) AND ((@IsNull_DESCRIZIONE = 1 AND [DESCRIZIONE] IS NULL) OR ([DESCRIZIONE] = @Original_DESCRIZIONE)) AND ((@IsNull_POSIZIONE = 1 AND [POSIZIONE] IS NULL) OR ([POSIZIONE] = @Original_POSIZIONE)));
|
|
SELECT COD_CDC, DESCRIZIONE, POSIZIONE FROM CDC WHERE (COD_CDC = @COD_CDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" 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="@POSIZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="POSIZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" 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_POSIZIONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="POSIZIONE" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_POSIZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="POSIZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="COD_CDC" DataSetColumn="COD_CDC" />
|
|
<Mapping SourceColumn="DESCRIZIONE" DataSetColumn="DESCRIZIONE" />
|
|
<Mapping SourceColumn="POSIZIONE" DataSetColumn="POSIZIONE" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.CDC" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCdc" GetMethodModifier="Public" GetMethodName="getByCdc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCdc" UserSourceName="getByCdc">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT COD_CDC, DESCRIZIONE, POSIZIONE
|
|
FROM CDC
|
|
WHERE (COD_CDC = @COD_CDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COD_CDC" ColumnName="COD_CDC" DataSourceName="Flamma_Anagrafica.dbo.CDC" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.CDC" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getEnabledCDC" GetMethodModifier="Public" GetMethodName="getEnabledCDC" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getEnabledCDC" UserSourceName="getEnabledCDC">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DISTINCT CDC.COD_CDC, CDC.DESCRIZIONE, CDC.COD_TIPO, CDC.POSIZIONE
|
|
FROM CDC INNER JOIN
|
|
DIRITTI ON CDC.COD_CDC = DIRITTI.COD_CDC
|
|
WHERE (DIRITTI.USER_NAME = @USER_NAME) AND (DIRITTI.COD_MODULO = @COD_MODULO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="USER_NAME" ColumnName="USER_NAME" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COD_MODULO" ColumnName="COD_MODULO" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.CDC" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetTopCdC" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetTopCdC" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetTopCdC" UserSourceName="GetTopCdC">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DISTINCT CDC.COD_CDC, CDC.DESCRIZIONE, CDC.POSIZIONE
|
|
FROM CDC INNER JOIN
|
|
DIRITTI ON CDC.COD_CDC = DIRITTI.COD_CDC INNER JOIN
|
|
UTENTE ON DIRITTI.USER_NAME = UTENTE.USER_NAME
|
|
WHERE (DIRITTI.USER_NAME = @userName) AND (UTENTE.DOMINIO = @dominio) AND (DIRITTI.COD_MODULO = @codModulo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="userName" ColumnName="USER_NAME" DataSourceName="Flamma_Anagrafica.dbo.DIRITTI" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="dominio" ColumnName="DOMINIO" DataSourceName="Flamma_Anagrafica.dbo.UTENTE" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@dominio" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="codModulo" ColumnName="COD_MODULO" DataSourceName="Flamma_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MODULOTableAdapter" GeneratorDataComponentClassName="MODULOTableAdapter" Name="MODULO" UserDataComponentName="MODULOTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.MODULO" 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].[MODULO] WHERE (([COD_MODULO] = @Original_COD_MODULO) AND ((@IsNull_DESCRIZIONE = 1 AND [DESCRIZIONE] IS NULL) OR ([DESCRIZIONE] = @Original_DESCRIZIONE)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" 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="AnsiString" Direction="Input" ParameterName="@Original_DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[MODULO] ([COD_MODULO], [DESCRIZIONE]) VALUES (@COD_MODULO, @DESCRIZIONE);
|
|
SELECT COD_MODULO, DESCRIZIONE FROM MODULO WHERE (COD_MODULO = @COD_MODULO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT COD_MODULO, DESCRIZIONE FROM dbo.MODULO</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[MODULO] SET [COD_MODULO] = @COD_MODULO, [DESCRIZIONE] = @DESCRIZIONE WHERE (([COD_MODULO] = @Original_COD_MODULO) AND ((@IsNull_DESCRIZIONE = 1 AND [DESCRIZIONE] IS NULL) OR ([DESCRIZIONE] = @Original_DESCRIZIONE)));
|
|
SELECT COD_MODULO, DESCRIZIONE FROM MODULO WHERE (COD_MODULO = @COD_MODULO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" 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="AnsiString" Direction="Input" ParameterName="@Original_DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="COD_MODULO" DataSetColumn="COD_MODULO" />
|
|
<Mapping SourceColumn="DESCRIZIONE" DataSetColumn="DESCRIZIONE" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FUNZIONETableAdapter" GeneratorDataComponentClassName="FUNZIONETableAdapter" Name="FUNZIONE" UserDataComponentName="FUNZIONETableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.FUNZIONE" 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].[FUNZIONE] WHERE (([COD_FUNZIONE] = @Original_COD_FUNZIONE) AND ((@IsNull_Descrizione = 1 AND [Descrizione] IS NULL) OR ([Descrizione] = @Original_Descrizione)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[FUNZIONE] ([COD_FUNZIONE], [Descrizione]) VALUES (@COD_FUNZIONE, @Descrizione);
|
|
SELECT COD_FUNZIONE, Descrizione FROM FUNZIONE WHERE (COD_FUNZIONE = @COD_FUNZIONE)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT COD_FUNZIONE, Descrizione FROM dbo.FUNZIONE</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[FUNZIONE] SET [COD_FUNZIONE] = @COD_FUNZIONE, [Descrizione] = @Descrizione WHERE (([COD_FUNZIONE] = @Original_COD_FUNZIONE) AND ((@IsNull_Descrizione = 1 AND [Descrizione] IS NULL) OR ([Descrizione] = @Original_Descrizione)));
|
|
SELECT COD_FUNZIONE, Descrizione FROM FUNZIONE WHERE (COD_FUNZIONE = @COD_FUNZIONE)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" 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="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="COD_FUNZIONE" DataSetColumn="COD_FUNZIONE" />
|
|
<Mapping SourceColumn="Descrizione" DataSetColumn="Descrizione" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.FUNZIONE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFunByDiritti_999" GetMethodModifier="Public" GetMethodName="getFunByDiritti_999" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFunByDiritti_999" UserSourceName="getFunByDiritti_999">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT FUNZIONE.COD_FUNZIONE, FUNZIONE.Descrizione
|
|
FROM FUNZIONE INNER JOIN
|
|
DIRITTI ON FUNZIONE.COD_FUNZIONE = DIRITTI.COD_FUNZIONE
|
|
WHERE (DIRITTI.VALUE = '999') AND (DIRITTI.COD_MODULO = @cod_modulo) AND (DIRITTI.USER_NAME = @user_name)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="cod_modulo" ColumnName="COD_MODULO" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@cod_modulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="user_name" ColumnName="USER_NAME" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@user_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermessiTableAdapter" GeneratorDataComponentClassName="PermessiTableAdapter" Name="Permessi" UserDataComponentName="PermessiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.Permessi" 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].[Permessi] WHERE (([COD_PERMESSO] = @Original_COD_PERMESSO) AND ([URL] = @Original_URL) AND ((@IsNull_GRUPPO = 1 AND [GRUPPO] IS NULL) OR ([GRUPPO] = @Original_GRUPPO)) AND ((@IsNull_NUMERO = 1 AND [NUMERO] IS NULL) OR ([NUMERO] = @Original_NUMERO)) AND ((@IsNull_NOME = 1 AND [NOME] IS NULL) OR ([NOME] = @Original_NOME)) AND ((@IsNull_DESCRIZIONE = 1 AND [DESCRIZIONE] IS NULL) OR ([DESCRIZIONE] = @Original_DESCRIZIONE)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GRUPPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRUPPO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GRUPPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRUPPO" 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_NOME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" 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="AnsiString" Direction="Input" ParameterName="@Original_DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (@COD_PERMESSO, @URL, @GRUPPO, @NUMERO, @NOME, @DESCRIZIONE);
|
|
SELECT COD_PERMESSO, URL, GRUPPO, NUMERO, NOME, DESCRIZIONE FROM Permessi WHERE (COD_PERMESSO = @COD_PERMESSO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GRUPPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRUPPO" 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="AnsiString" Direction="Input" ParameterName="@NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT COD_PERMESSO, URL, GRUPPO, NUMERO, NOME, DESCRIZIONE FROM dbo.Permessi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Permessi] SET [COD_PERMESSO] = @COD_PERMESSO, [URL] = @URL, [GRUPPO] = @GRUPPO, [NUMERO] = @NUMERO, [NOME] = @NOME, [DESCRIZIONE] = @DESCRIZIONE WHERE (([COD_PERMESSO] = @Original_COD_PERMESSO) AND ([URL] = @Original_URL) AND ((@IsNull_GRUPPO = 1 AND [GRUPPO] IS NULL) OR ([GRUPPO] = @Original_GRUPPO)) AND ((@IsNull_NUMERO = 1 AND [NUMERO] IS NULL) OR ([NUMERO] = @Original_NUMERO)) AND ((@IsNull_NOME = 1 AND [NOME] IS NULL) OR ([NOME] = @Original_NOME)) AND ((@IsNull_DESCRIZIONE = 1 AND [DESCRIZIONE] IS NULL) OR ([DESCRIZIONE] = @Original_DESCRIZIONE)));
|
|
SELECT COD_PERMESSO, URL, GRUPPO, NUMERO, NOME, DESCRIZIONE FROM Permessi WHERE (COD_PERMESSO = @COD_PERMESSO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GRUPPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRUPPO" 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="AnsiString" Direction="Input" ParameterName="@NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GRUPPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRUPPO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GRUPPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRUPPO" 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_NOME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" 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="AnsiString" Direction="Input" ParameterName="@Original_DESCRIZIONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESCRIZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="COD_PERMESSO" DataSetColumn="COD_PERMESSO" />
|
|
<Mapping SourceColumn="URL" DataSetColumn="URL" />
|
|
<Mapping SourceColumn="GRUPPO" DataSetColumn="GRUPPO" />
|
|
<Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
|
|
<Mapping SourceColumn="NOME" DataSetColumn="NOME" />
|
|
<Mapping SourceColumn="DESCRIZIONE" DataSetColumn="DESCRIZIONE" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Permessi2FunzioneTableAdapter" GeneratorDataComponentClassName="Permessi2FunzioneTableAdapter" Name="Permessi2Funzione" UserDataComponentName="Permessi2FunzioneTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.Permessi2Funzione" 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].[Permessi2Funzione] WHERE (([COD_PERMESSO] = @Original_COD_PERMESSO) AND ([COD_FUNZIONE] = @Original_COD_FUNZIONE) AND ((@IsNull_READWRITE = 1 AND [READWRITE] IS NULL) OR ([READWRITE] = @Original_READWRITE)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_READWRITE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="READWRITE" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_READWRITE" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="READWRITE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (@COD_PERMESSO, @COD_FUNZIONE, @READWRITE);
|
|
SELECT COD_PERMESSO, COD_FUNZIONE, READWRITE FROM Permessi2Funzione WHERE (COD_FUNZIONE = @COD_FUNZIONE) AND (COD_PERMESSO = @COD_PERMESSO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@READWRITE" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="READWRITE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT COD_PERMESSO, COD_FUNZIONE, READWRITE FROM dbo.Permessi2Funzione</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Permessi2Funzione] SET [COD_PERMESSO] = @COD_PERMESSO, [COD_FUNZIONE] = @COD_FUNZIONE, [READWRITE] = @READWRITE WHERE (([COD_PERMESSO] = @Original_COD_PERMESSO) AND ([COD_FUNZIONE] = @Original_COD_FUNZIONE) AND ((@IsNull_READWRITE = 1 AND [READWRITE] IS NULL) OR ([READWRITE] = @Original_READWRITE)));
|
|
SELECT COD_PERMESSO, COD_FUNZIONE, READWRITE FROM Permessi2Funzione WHERE (COD_FUNZIONE = @COD_FUNZIONE) AND (COD_PERMESSO = @COD_PERMESSO)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@READWRITE" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="READWRITE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_PERMESSO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_PERMESSO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_READWRITE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="READWRITE" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_READWRITE" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="READWRITE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="COD_PERMESSO" DataSetColumn="COD_PERMESSO" />
|
|
<Mapping SourceColumn="COD_FUNZIONE" DataSetColumn="COD_FUNZIONE" />
|
|
<Mapping SourceColumn="READWRITE" DataSetColumn="READWRITE" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DIRITTITableAdapter" GeneratorDataComponentClassName="DIRITTITableAdapter" Name="DIRITTI" UserDataComponentName="DIRITTITableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.DIRITTI" 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 [DIRITTI] WHERE (([USER_NAME] = @Original_USER_NAME) AND ([COD_CDC] = @Original_COD_CDC) AND ([COD_MODULO] = @Original_COD_MODULO) AND ([COD_FUNZIONE] = @Original_COD_FUNZIONE) AND ((@IsNull_VALUE = 1 AND [VALUE] IS NULL) OR ([VALUE] = @Original_VALUE)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [DIRITTI] ([USER_NAME], [COD_CDC], [COD_MODULO], [COD_FUNZIONE], [VALUE]) VALUES (@USER_NAME, @COD_CDC, @COD_MODULO, @COD_FUNZIONE, @VALUE);
|
|
SELECT USER_NAME, COD_CDC, COD_MODULO, COD_FUNZIONE, VALUE FROM DIRITTI WHERE (COD_CDC = @COD_CDC) AND (COD_FUNZIONE = @COD_FUNZIONE) AND (COD_MODULO = @COD_MODULO) AND (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT USER_NAME, COD_CDC, COD_MODULO, COD_FUNZIONE, VALUE
|
|
FROM DIRITTI</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [DIRITTI] SET [USER_NAME] = @USER_NAME, [COD_CDC] = @COD_CDC, [COD_MODULO] = @COD_MODULO, [COD_FUNZIONE] = @COD_FUNZIONE, [VALUE] = @VALUE WHERE (([USER_NAME] = @Original_USER_NAME) AND ([COD_CDC] = @Original_COD_CDC) AND ([COD_MODULO] = @Original_COD_MODULO) AND ([COD_FUNZIONE] = @Original_COD_FUNZIONE) AND ((@IsNull_VALUE = 1 AND [VALUE] IS NULL) OR ([VALUE] = @Original_VALUE)));
|
|
SELECT USER_NAME, COD_CDC, COD_MODULO, COD_FUNZIONE, VALUE FROM DIRITTI WHERE (COD_CDC = @COD_CDC) AND (COD_FUNZIONE = @COD_FUNZIONE) AND (COD_MODULO = @COD_MODULO) AND (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="COD_CDC" DataSetColumn="COD_CDC" />
|
|
<Mapping SourceColumn="COD_MODULO" DataSetColumn="COD_MODULO" />
|
|
<Mapping SourceColumn="COD_FUNZIONE" DataSetColumn="COD_FUNZIONE" />
|
|
<Mapping SourceColumn="VALUE" DataSetColumn="VALUE" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (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="Text" ModifiedByUser="true">
|
|
<CommandText>DELETE FROM DIRITTI
|
|
WHERE (USER_NAME = @Original_USER_NAME) AND (COD_CDC = @Original_COD_CDC) AND (COD_MODULO = @Original_COD_MODULO) AND
|
|
(COD_FUNZIONE = @Original_COD_FUNZIONE)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_USER_NAME" ColumnName="USER_NAME" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_COD_CDC" ColumnName="COD_CDC" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_COD_MODULO" ColumnName="COD_MODULO" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@Original_COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_COD_FUNZIONE" ColumnName="COD_FUNZIONE" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@Original_COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.DIRITTI" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByUserDominioModulo" GetMethodModifier="Public" GetMethodName="GetByUserDominioModulo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByUserDominioModulo" UserSourceName="GetByUserDominioModulo">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DIRITTI.COD_CDC, DIRITTI.COD_FUNZIONE, DIRITTI.COD_MODULO, DIRITTI.USER_NAME, DIRITTI.VALUE FROM DIRITTI INNER JOIN UTENTE ON DIRITTI.USER_NAME = UTENTE.USER_NAME WHERE (DIRITTI.USER_NAME = @userName) AND (UTENTE.DOMINIO = @dominio) AND (DIRITTI.COD_MODULO = @codModulo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="userName" ColumnName="USER_NAME" DataSourceName="Flamma_Anagrafica.dbo.DIRITTI" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="dominio" ColumnName="DOMINIO" DataSourceName="Flamma_Anagrafica.dbo.UTENTE" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@dominio" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="codModulo" ColumnName="COD_MODULO" DataSourceName="Flamma_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.DIRITTI" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByUserDominioModuloCdc" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetByUserDominioModuloCdc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByUserDominioModuloCdc" UserSourceName="GetByUserDominioModuloCdc">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DIRITTI.COD_CDC, DIRITTI.COD_FUNZIONE, DIRITTI.COD_MODULO, DIRITTI.USER_NAME, DIRITTI.VALUE
|
|
FROM DIRITTI INNER JOIN
|
|
UTENTE ON DIRITTI.USER_NAME = UTENTE.USER_NAME
|
|
WHERE (DIRITTI.USER_NAME = @userName) AND (UTENTE.DOMINIO = @dominio) AND (DIRITTI.COD_MODULO = @codModulo) AND (DIRITTI.COD_CDC = @cdc)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="userName" ColumnName="USER_NAME" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="dominio" ColumnName="DOMINIO" DataSourceName="SteamWare_Anagrafica.dbo.UTENTE" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@dominio" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="codModulo" ColumnName="COD_MODULO" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="cdc" ColumnName="COD_CDC" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@cdc" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.DIRITTI" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByUserModulo" GetMethodModifier="Public" GetMethodName="GetByUserModulo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByUserModulo" UserSourceName="GetByUserModulo">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DIRITTI.COD_CDC, DIRITTI.COD_FUNZIONE, DIRITTI.COD_MODULO, DIRITTI.USER_NAME, DIRITTI.VALUE FROM DIRITTI INNER JOIN UTENTE ON DIRITTI.USER_NAME = UTENTE.USER_NAME WHERE (DIRITTI.USER_NAME = @userName) AND (DIRITTI.COD_MODULO = @codModulo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="userName" ColumnName="USER_NAME" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="codModulo" ColumnName="COD_MODULO" DataSourceName="SteamWare_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UTENTETableAdapter" GeneratorDataComponentClassName="UTENTETableAdapter" Name="UTENTE" UserDataComponentName="UTENTETableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UTENTE" 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 [UTENTE] WHERE (((@IsNull_DOMINIO = 1 AND [DOMINIO] IS NULL) OR ([DOMINIO] = @Original_DOMINIO)) AND ([USER_NAME] = @Original_USER_NAME) AND ((@IsNull_COGNOME = 1 AND [COGNOME] IS NULL) OR ([COGNOME] = @Original_COGNOME)) AND ((@IsNull_NOME = 1 AND [NOME] IS NULL) OR ([NOME] = @Original_NOME)) AND ((@IsNull_COD_SOCIETA = 1 AND [COD_SOCIETA] IS NULL) OR ([COD_SOCIETA] = @Original_COD_SOCIETA)) AND ((@IsNull_MATRICOLA = 1 AND [MATRICOLA] IS NULL) OR ([MATRICOLA] = @Original_MATRICOLA)) AND ((@IsNull_COD_CDC = 1 AND [COD_CDC] IS NULL) OR ([COD_CDC] = @Original_COD_CDC)) AND ((@IsNull_EMAIL = 1 AND [EMAIL] IS NULL) OR ([EMAIL] = @Original_EMAIL)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_COD_LINGUA = 1 AND [COD_LINGUA] IS NULL) OR ([COD_LINGUA] = @Original_COD_LINGUA)) AND ((@IsNull_ATTIVO = 1 AND [ATTIVO] IS NULL) OR ([ATTIVO] = @Original_ATTIVO)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOMINIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOMINIO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOMINIO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COGNOME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COGNOME" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COGNOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COGNOME" 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="AnsiString" Direction="Input" ParameterName="@Original_NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COD_SOCIETA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COD_SOCIETA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_SOCIETA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_SOCIETA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MATRICOLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MATRICOLA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MATRICOLA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MATRICOLA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COD_CDC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SIGLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SIGLA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COD_LINGUA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COD_LINGUA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_LINGUA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_LINGUA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ATTIVO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTIVO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ATTIVO" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ATTIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [UTENTE] ([DOMINIO], [USER_NAME], [COGNOME], [NOME], [COD_SOCIETA], [MATRICOLA], [COD_CDC], [EMAIL], [SIGLA], [COD_LINGUA], [ATTIVO]) VALUES (@DOMINIO, @USER_NAME, @COGNOME, @NOME, @COD_SOCIETA, @MATRICOLA, @COD_CDC, @EMAIL, @SIGLA, @COD_LINGUA, @ATTIVO);
|
|
SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO FROM UTENTE WHERE (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOMINIO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COGNOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COGNOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_SOCIETA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_SOCIETA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MATRICOLA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MATRICOLA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SIGLA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_LINGUA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_LINGUA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ATTIVO" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ATTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO
|
|
FROM UTENTE</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [UTENTE] SET [DOMINIO] = @DOMINIO, [USER_NAME] = @USER_NAME, [COGNOME] = @COGNOME, [NOME] = @NOME, [COD_SOCIETA] = @COD_SOCIETA, [MATRICOLA] = @MATRICOLA, [COD_CDC] = @COD_CDC, [EMAIL] = @EMAIL, [SIGLA] = @SIGLA, [COD_LINGUA] = @COD_LINGUA, [ATTIVO] = @ATTIVO WHERE (((@IsNull_DOMINIO = 1 AND [DOMINIO] IS NULL) OR ([DOMINIO] = @Original_DOMINIO)) AND ([USER_NAME] = @Original_USER_NAME) AND ((@IsNull_COGNOME = 1 AND [COGNOME] IS NULL) OR ([COGNOME] = @Original_COGNOME)) AND ((@IsNull_NOME = 1 AND [NOME] IS NULL) OR ([NOME] = @Original_NOME)) AND ((@IsNull_COD_SOCIETA = 1 AND [COD_SOCIETA] IS NULL) OR ([COD_SOCIETA] = @Original_COD_SOCIETA)) AND ((@IsNull_MATRICOLA = 1 AND [MATRICOLA] IS NULL) OR ([MATRICOLA] = @Original_MATRICOLA)) AND ((@IsNull_COD_CDC = 1 AND [COD_CDC] IS NULL) OR ([COD_CDC] = @Original_COD_CDC)) AND ((@IsNull_EMAIL = 1 AND [EMAIL] IS NULL) OR ([EMAIL] = @Original_EMAIL)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_COD_LINGUA = 1 AND [COD_LINGUA] IS NULL) OR ([COD_LINGUA] = @Original_COD_LINGUA)) AND ((@IsNull_ATTIVO = 1 AND [ATTIVO] IS NULL) OR ([ATTIVO] = @Original_ATTIVO)));
|
|
SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO FROM UTENTE WHERE (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOMINIO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COGNOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COGNOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_SOCIETA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_SOCIETA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MATRICOLA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MATRICOLA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_CDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SIGLA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COD_LINGUA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_LINGUA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ATTIVO" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ATTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOMINIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOMINIO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOMINIO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COGNOME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COGNOME" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COGNOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COGNOME" 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="AnsiString" Direction="Input" ParameterName="@Original_NOME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COD_SOCIETA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COD_SOCIETA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_SOCIETA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_SOCIETA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MATRICOLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MATRICOLA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MATRICOLA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MATRICOLA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COD_CDC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_CDC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SIGLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SIGLA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COD_LINGUA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COD_LINGUA" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COD_LINGUA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COD_LINGUA" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ATTIVO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTIVO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ATTIVO" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ATTIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="MATRICOLA" DataSetColumn="MATRICOLA" />
|
|
<Mapping SourceColumn="COD_SOCIETA" DataSetColumn="COD_SOCIETA" />
|
|
<Mapping SourceColumn="COGNOME" DataSetColumn="COGNOME" />
|
|
<Mapping SourceColumn="NOME" DataSetColumn="NOME" />
|
|
<Mapping SourceColumn="COD_CDC" DataSetColumn="COD_CDC" />
|
|
<Mapping SourceColumn="EMAIL" DataSetColumn="EMAIL" />
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="SIGLA" DataSetColumn="SIGLA" />
|
|
<Mapping SourceColumn="COD_LINGUA" DataSetColumn="COD_LINGUA" />
|
|
<Mapping SourceColumn="ATTIVO" DataSetColumn="ATTIVO" />
|
|
<Mapping SourceColumn="DOMINIO" DataSetColumn="DOMINIO" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.UTENTE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByCognomeNome" GetMethodModifier="Public" GetMethodName="getByCognomeNome" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByCognomeNome" UserSourceName="getByCognomeNome">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM UTENTE
|
|
WHERE (COGNOME + ' ' + NOME) = @ricerca OR (NOME + ' ' + COGNOME = @ricerca)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ricerca" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@ricerca" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UTENTE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByMatricola" GetMethodModifier="Public" GetMethodName="getByMatricola" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByMatricola" UserSourceName="getByMatricola">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT ATTIVO, COD_CDC, COD_LINGUA, COD_SOCIETA, COGNOME, DOMINIO, EMAIL, MATRICOLA, NOME, SIGLA, USER_NAME FROM UTENTE WHERE (MATRICOLA = @MATRICOLA)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="MATRICOLA" ColumnName="MATRICOLA" DataSourceName="Flamma_Anagrafica.dbo.UTENTE" DataTypeServer="varchar(5)" DbType="AnsiString" Direction="Input" ParameterName="@MATRICOLA" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumn="MATRICOLA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UTENTE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByRicercaNomeCognome" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="getByRicercaNomeCognome" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByRicercaNomeCognome" UserSourceName="getByRicercaNomeCognome">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT ATTIVO, COD_CDC, COD_LINGUA, COD_SOCIETA, COGNOME, DOMINIO, EMAIL, MATRICOLA, NOME, SIGLA, USER_NAME FROM UTENTE WHERE (NOME LIKE '%' + @ricerca + '%') OR (COGNOME LIKE '%' + @ricerca + '%')</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="ricerca" ColumnName="NOME" DataSourceName="Flamma_Anagrafica.dbo.UTENTE" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@ricerca" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UTENTE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUserName" GetMethodModifier="Public" GetMethodName="getByUserName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUserName" UserSourceName="getByUserName">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT ATTIVO, COD_CDC, COD_LINGUA, COD_SOCIETA, COGNOME, DOMINIO, EMAIL, MATRICOLA, NOME, SIGLA, USER_NAME FROM UTENTE WHERE (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="USER_NAME" ColumnName="USER_NAME" DataSourceName="Flamma_Anagrafica.dbo.UTENTE" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UTENTE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUtenteDominio" GetMethodModifier="Public" GetMethodName="GetDataByUtenteDominio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUtenteDominio" UserSourceName="GetDataByUtenteDominio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO
|
|
FROM UTENTE
|
|
|
|
WHERE (USER_NAME = @username) AND (DOMINIO = @dominio)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="USER_NAME" DataSourceName="SteamWare_Anagrafica.dbo.UTENTE" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="dominio" ColumnName="DOMINIO" DataSourceName="SteamWare_Anagrafica.dbo.UTENTE" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@dominio" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DOMINIO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UTENTE" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getElencoByDiritti" GetMethodModifier="Public" GetMethodName="getElencoByDiritti" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getElencoByDiritti" UserSourceName="getElencoByDiritti">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT UTENTE.ATTIVO, UTENTE.COD_CDC, UTENTE.COD_LINGUA, UTENTE.COD_SOCIETA, UTENTE.COGNOME, UTENTE.DOMINIO, UTENTE.EMAIL, UTENTE.MATRICOLA, UTENTE.NOME, UTENTE.SIGLA, UTENTE.USER_NAME FROM UTENTE INNER JOIN DIRITTI ON UTENTE.USER_NAME = DIRITTI.USER_NAME WHERE (DIRITTI.COD_MODULO = @COD_MODULO) AND (DIRITTI.COD_FUNZIONE = @COD_FUNZIONE)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COD_MODULO" ColumnName="COD_MODULO" DataSourceName="Flamma_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@COD_MODULO" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_MODULO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COD_FUNZIONE" ColumnName="COD_FUNZIONE" DataSourceName="Flamma_Anagrafica.dbo.DIRITTI" DataTypeServer="nvarchar(31)" DbType="String" Direction="Input" ParameterName="@COD_FUNZIONE" Precision="0" ProviderType="NVarChar" Scale="0" Size="31" SourceColumn="COD_FUNZIONE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LogUpdateDbTableAdapter" GeneratorDataComponentClassName="LogUpdateDbTableAdapter" Name="LogUpdateDb" UserDataComponentName="LogUpdateDbTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.LogUpdateDb" 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].[LogUpdateDb] WHERE (([Versione] = @Original_Versione) AND ((@IsNull_Data = 1 AND [Data] IS NULL) OR ([Data] = @Original_Data)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Versione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Versione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[LogUpdateDb] ([Versione], [Data]) VALUES (@Versione, @Data);
|
|
SELECT Versione, Data FROM LogUpdateDb WHERE (Versione = @Versione)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Versione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Versione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Versione, Data FROM dbo.LogUpdateDb</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[LogUpdateDb] SET [Versione] = @Versione, [Data] = @Data WHERE (([Versione] = @Original_Versione) AND ((@IsNull_Data = 1 AND [Data] IS NULL) OR ([Data] = @Original_Data)));
|
|
SELECT Versione, Data FROM LogUpdateDb WHERE (Versione = @Versione)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Versione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Versione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Versione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Versione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Versione" DataSetColumn="Versione" />
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="getDbVers" Modifier="Public" Name="getDbVers" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getDbVers">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT MAX(Versione) AS Versione
|
|
FROM LogUpdateDb</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserDataExtTableAdapter" GeneratorDataComponentClassName="UserDataExtTableAdapter" Name="UserDataExt" UserDataComponentName="UserDataExtTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UserDataExt" 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].[UserDataExt] WHERE (([User_Name] = @Original_User_Name) AND ((@IsNull_Dominio = 1 AND [Dominio] IS NULL) OR ([Dominio] = @Original_Dominio)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Lingua = 1 AND [Lingua] IS NULL) OR ([Lingua] = @Original_Lingua)) AND ((@IsNull_Cod_Societa = 1 AND [Cod_Societa] IS NULL) OR ([Cod_Societa] = @Original_Cod_Societa)) AND ((@IsNull_Matricola = 1 AND [Matricola] IS NULL) OR ([Matricola] = @Original_Matricola)) AND ((@IsNull_Cod_CDC = 1 AND [Cod_CDC] IS NULL) OR ([Cod_CDC] = @Original_Cod_CDC)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dominio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dominio" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Dominio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Dominio" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lingua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lingua" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Lingua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lingua" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cod_Societa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cod_Societa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cod_Societa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_Societa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Matricola" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Matricola" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Matricola" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matricola" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cod_CDC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cod_CDC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cod_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[UserDataExt] ([User_Name], [Dominio], [Email], [Lingua], [Cod_Societa], [Matricola], [Cod_CDC], [Sigla]) VALUES (@User_Name, @Dominio, @Email, @Lingua, @Cod_Societa, @Matricola, @Cod_CDC, @Sigla);
|
|
SELECT User_Name, Dominio, Email, Lingua, Cod_Societa, Matricola, Cod_CDC, Sigla FROM UserDataExt WHERE (User_Name = @User_Name)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Dominio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Dominio" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Lingua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lingua" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cod_Societa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_Societa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Matricola" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matricola" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cod_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT User_Name, Dominio, Email, Lingua, Cod_Societa, Matricola, Cod_CDC, Sigla FROM dbo.UserDataExt</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[UserDataExt] SET [User_Name] = @User_Name, [Dominio] = @Dominio, [Email] = @Email, [Lingua] = @Lingua, [Cod_Societa] = @Cod_Societa, [Matricola] = @Matricola, [Cod_CDC] = @Cod_CDC, [Sigla] = @Sigla WHERE (([User_Name] = @Original_User_Name) AND ((@IsNull_Dominio = 1 AND [Dominio] IS NULL) OR ([Dominio] = @Original_Dominio)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Lingua = 1 AND [Lingua] IS NULL) OR ([Lingua] = @Original_Lingua)) AND ((@IsNull_Cod_Societa = 1 AND [Cod_Societa] IS NULL) OR ([Cod_Societa] = @Original_Cod_Societa)) AND ((@IsNull_Matricola = 1 AND [Matricola] IS NULL) OR ([Matricola] = @Original_Matricola)) AND ((@IsNull_Cod_CDC = 1 AND [Cod_CDC] IS NULL) OR ([Cod_CDC] = @Original_Cod_CDC)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)));
|
|
SELECT User_Name, Dominio, Email, Lingua, Cod_Societa, Matricola, Cod_CDC, Sigla FROM UserDataExt WHERE (User_Name = @User_Name)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Dominio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Dominio" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Lingua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lingua" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cod_Societa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_Societa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Matricola" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matricola" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cod_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_CDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dominio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dominio" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Dominio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Dominio" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lingua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lingua" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Lingua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lingua" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cod_Societa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cod_Societa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cod_Societa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_Societa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Matricola" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Matricola" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Matricola" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Matricola" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cod_CDC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cod_CDC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cod_CDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cod_CDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="User_Name" DataSetColumn="User_Name" />
|
|
<Mapping SourceColumn="Dominio" DataSetColumn="Dominio" />
|
|
<Mapping SourceColumn="Email" DataSetColumn="Email" />
|
|
<Mapping SourceColumn="Lingua" DataSetColumn="Lingua" />
|
|
<Mapping SourceColumn="Cod_Societa" DataSetColumn="Cod_Societa" />
|
|
<Mapping SourceColumn="Matricola" DataSetColumn="Matricola" />
|
|
<Mapping SourceColumn="Cod_CDC" DataSetColumn="Cod_CDC" />
|
|
<Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserDataTableAdapter" GeneratorDataComponentClassName="UserDataTableAdapter" Name="UserData" UserDataComponentName="UserDataTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UserData" 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].[UserData] WHERE (([User_Name] = @Original_User_Name) AND ((@IsNull_Passwd = 1 AND [Passwd] IS NULL) OR ([Passwd] = @Original_Passwd)) AND ((@IsNull_Cognome = 1 AND [Cognome] IS NULL) OR ([Cognome] = @Original_Cognome)) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_Attivo = 1 AND [Attivo] IS NULL) OR ([Attivo] = @Original_Attivo)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Passwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Passwd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Passwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passwd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cognome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Attivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Attivo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[UserData] ([User_Name], [Passwd], [Cognome], [Nome], [Attivo]) VALUES (@User_Name, @Passwd, @Cognome, @Nome, @Attivo);
|
|
SELECT User_Name, Passwd, Cognome, Nome, Attivo FROM UserData WHERE (User_Name = @User_Name)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Passwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passwd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Attivo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT User_Name, Passwd, Cognome, Nome, Attivo FROM dbo.UserData</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[UserData] SET [User_Name] = @User_Name, [Passwd] = @Passwd, [Cognome] = @Cognome, [Nome] = @Nome, [Attivo] = @Attivo WHERE (([User_Name] = @Original_User_Name) AND ((@IsNull_Passwd = 1 AND [Passwd] IS NULL) OR ([Passwd] = @Original_Passwd)) AND ((@IsNull_Cognome = 1 AND [Cognome] IS NULL) OR ([Cognome] = @Original_Cognome)) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_Attivo = 1 AND [Attivo] IS NULL) OR ([Attivo] = @Original_Attivo)));
|
|
SELECT User_Name, Passwd, Cognome, Nome, Attivo FROM UserData WHERE (User_Name = @User_Name)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Passwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passwd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Attivo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Passwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Passwd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Passwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passwd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cognome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Attivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Attivo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="User_Name" DataSetColumn="User_Name" />
|
|
<Mapping SourceColumn="Passwd" DataSetColumn="Passwd" />
|
|
<Mapping SourceColumn="Cognome" DataSetColumn="Cognome" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="SteamWare_Anagrafica.dbo.UserData" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUserPwd" GetMethodModifier="Public" GetMethodName="getByUserPwd" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUserPwd" UserSourceName="getByUserPwd">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT User_Name, Passwd, Cognome, Nome, Attivo
|
|
FROM UserData
|
|
WHERE (User_Name = @User_Name) AND (Passwd = @Passwd)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="User_Name" ColumnName="User_Name" DataSourceName="SteamWare_Anagrafica.dbo.UserData" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@User_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="User_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Passwd" ColumnName="Passwd" DataSourceName="SteamWare_Anagrafica.dbo.UserData" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Passwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Passwd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DataLayer_AnagGen" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="DataLayer_AnagGen" msprop:Generator_UserDSName="DataLayer_AnagGen">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="CDC" msprop:Generator_UserTableName="CDC" msprop:Generator_RowEvArgName="CDCRowChangeEvent" msprop:Generator_TableVarName="tableCDC" msprop:Generator_TablePropName="CDC" msprop:Generator_RowDeletingName="CDCRowDeleting" msprop:Generator_RowChangingName="CDCRowChanging" msprop:Generator_RowDeletedName="CDCRowDeleted" msprop:Generator_RowEvHandlerName="CDCRowChangeEventHandler" msprop:Generator_TableClassName="CDCDataTable" msprop:Generator_RowChangedName="CDCRowChanged" msprop:Generator_RowClassName="CDCRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="COD_CDC" msprop:Generator_ColumnVarNameInTable="columnCOD_CDC" msprop:Generator_ColumnPropNameInRow="COD_CDC" msprop:Generator_ColumnPropNameInTable="COD_CDCColumn" msprop:Generator_UserColumnName="COD_CDC">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</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="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="POSIZIONE" msprop:Generator_ColumnVarNameInTable="columnPOSIZIONE" msprop:Generator_ColumnPropNameInRow="POSIZIONE" msprop:Generator_ColumnPropNameInTable="POSIZIONEColumn" msprop:Generator_UserColumnName="POSIZIONE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="MODULO" msprop:Generator_UserTableName="MODULO" msprop:Generator_RowEvArgName="MODULORowChangeEvent" msprop:Generator_TableVarName="tableMODULO" msprop:Generator_TablePropName="MODULO" msprop:Generator_RowDeletingName="MODULORowDeleting" msprop:Generator_RowChangingName="MODULORowChanging" msprop:Generator_RowDeletedName="MODULORowDeleted" msprop:Generator_RowEvHandlerName="MODULORowChangeEventHandler" msprop:Generator_TableClassName="MODULODataTable" msprop:Generator_RowChangedName="MODULORowChanged" msprop:Generator_RowClassName="MODULORow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="COD_MODULO" msprop:Generator_ColumnVarNameInTable="columnCOD_MODULO" msprop:Generator_ColumnPropNameInRow="COD_MODULO" msprop:Generator_ColumnPropNameInTable="COD_MODULOColumn" msprop:Generator_UserColumnName="COD_MODULO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="31" />
|
|
</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="200" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="FUNZIONE" msprop:Generator_UserTableName="FUNZIONE" msprop:Generator_RowEvArgName="FUNZIONERowChangeEvent" msprop:Generator_TableVarName="tableFUNZIONE" msprop:Generator_TablePropName="FUNZIONE" msprop:Generator_RowDeletingName="FUNZIONERowDeleting" msprop:Generator_RowChangingName="FUNZIONERowChanging" msprop:Generator_RowDeletedName="FUNZIONERowDeleted" msprop:Generator_RowEvHandlerName="FUNZIONERowChangeEventHandler" msprop:Generator_TableClassName="FUNZIONEDataTable" msprop:Generator_RowChangedName="FUNZIONERowChanged" msprop:Generator_RowClassName="FUNZIONERow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="COD_FUNZIONE" msprop:Generator_ColumnVarNameInTable="columnCOD_FUNZIONE" msprop:Generator_ColumnPropNameInRow="COD_FUNZIONE" msprop:Generator_ColumnPropNameInTable="COD_FUNZIONEColumn" msprop:Generator_UserColumnName="COD_FUNZIONE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</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="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Permessi" msprop:Generator_UserTableName="Permessi" msprop:Generator_RowEvArgName="PermessiRowChangeEvent" msprop:Generator_TableVarName="tablePermessi" msprop:Generator_TablePropName="Permessi" msprop:Generator_RowDeletingName="PermessiRowDeleting" msprop:Generator_RowChangingName="PermessiRowChanging" msprop:Generator_RowDeletedName="PermessiRowDeleted" msprop:Generator_RowEvHandlerName="PermessiRowChangeEventHandler" msprop:Generator_TableClassName="PermessiDataTable" msprop:Generator_RowChangedName="PermessiRowChanged" msprop:Generator_RowClassName="PermessiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="COD_PERMESSO" msprop:Generator_ColumnVarNameInTable="columnCOD_PERMESSO" msprop:Generator_ColumnPropNameInRow="COD_PERMESSO" msprop:Generator_ColumnPropNameInTable="COD_PERMESSOColumn" msprop:Generator_UserColumnName="COD_PERMESSO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnPropNameInTable="URLColumn" msprop:Generator_UserColumnName="URL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="GRUPPO" msprop:Generator_ColumnVarNameInTable="columnGRUPPO" msprop:Generator_ColumnPropNameInRow="GRUPPO" msprop:Generator_ColumnPropNameInTable="GRUPPOColumn" msprop:Generator_UserColumnName="GRUPPO" 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="NOME" msprop:Generator_ColumnVarNameInTable="columnNOME" msprop:Generator_ColumnPropNameInRow="NOME" msprop:Generator_ColumnPropNameInTable="NOMEColumn" msprop:Generator_UserColumnName="NOME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="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="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Permessi2Funzione" msprop:Generator_UserTableName="Permessi2Funzione" msprop:Generator_RowEvArgName="Permessi2FunzioneRowChangeEvent" msprop:Generator_TableVarName="tablePermessi2Funzione" msprop:Generator_TablePropName="Permessi2Funzione" msprop:Generator_RowDeletingName="Permessi2FunzioneRowDeleting" msprop:Generator_RowChangingName="Permessi2FunzioneRowChanging" msprop:Generator_RowDeletedName="Permessi2FunzioneRowDeleted" msprop:Generator_RowEvHandlerName="Permessi2FunzioneRowChangeEventHandler" msprop:Generator_TableClassName="Permessi2FunzioneDataTable" msprop:Generator_RowChangedName="Permessi2FunzioneRowChanged" msprop:Generator_RowClassName="Permessi2FunzioneRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="COD_PERMESSO" msprop:Generator_ColumnVarNameInTable="columnCOD_PERMESSO" msprop:Generator_ColumnPropNameInRow="COD_PERMESSO" msprop:Generator_ColumnPropNameInTable="COD_PERMESSOColumn" msprop:Generator_UserColumnName="COD_PERMESSO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_FUNZIONE" msprop:Generator_ColumnVarNameInTable="columnCOD_FUNZIONE" msprop:Generator_ColumnPropNameInRow="COD_FUNZIONE" msprop:Generator_ColumnPropNameInTable="COD_FUNZIONEColumn" msprop:Generator_UserColumnName="COD_FUNZIONE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="31" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="READWRITE" msprop:Generator_ColumnVarNameInTable="columnREADWRITE" msprop:Generator_ColumnPropNameInRow="READWRITE" msprop:Generator_ColumnPropNameInTable="READWRITEColumn" msprop:Generator_UserColumnName="READWRITE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="DIRITTI" msprop:Generator_UserTableName="DIRITTI" msprop:Generator_RowEvArgName="DIRITTIRowChangeEvent" msprop:Generator_TableVarName="tableDIRITTI" msprop:Generator_TablePropName="DIRITTI" msprop:Generator_RowDeletingName="DIRITTIRowDeleting" msprop:Generator_RowChangingName="DIRITTIRowChanging" msprop:Generator_RowDeletedName="DIRITTIRowDeleted" msprop:Generator_RowEvHandlerName="DIRITTIRowChangeEventHandler" msprop:Generator_TableClassName="DIRITTIDataTable" msprop:Generator_RowChangedName="DIRITTIRowChanged" msprop:Generator_RowClassName="DIRITTIRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="USER_NAME" msprop:Generator_ColumnVarNameInTable="columnUSER_NAME" msprop:Generator_ColumnPropNameInRow="USER_NAME" msprop:Generator_ColumnPropNameInTable="USER_NAMEColumn" msprop:Generator_UserColumnName="USER_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_CDC" msprop:Generator_ColumnVarNameInTable="columnCOD_CDC" msprop:Generator_ColumnPropNameInRow="COD_CDC" msprop:Generator_ColumnPropNameInTable="COD_CDCColumn" msprop:Generator_UserColumnName="COD_CDC">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_MODULO" msprop:Generator_ColumnVarNameInTable="columnCOD_MODULO" msprop:Generator_ColumnPropNameInRow="COD_MODULO" msprop:Generator_ColumnPropNameInTable="COD_MODULOColumn" msprop:Generator_UserColumnName="COD_MODULO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="31" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_FUNZIONE" msprop:Generator_ColumnVarNameInTable="columnCOD_FUNZIONE" msprop:Generator_ColumnPropNameInRow="COD_FUNZIONE" msprop:Generator_ColumnPropNameInTable="COD_FUNZIONEColumn" msprop:Generator_UserColumnName="COD_FUNZIONE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="31" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="VALUE" msprop:Generator_ColumnVarNameInTable="columnVALUE" msprop:Generator_ColumnPropNameInRow="VALUE" msprop:Generator_ColumnPropNameInTable="VALUEColumn" msprop:Generator_UserColumnName="VALUE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="UTENTE" msprop:Generator_UserTableName="UTENTE" msprop:Generator_RowEvArgName="UTENTERowChangeEvent" msprop:Generator_TableVarName="tableUTENTE" msprop:Generator_TablePropName="UTENTE" msprop:Generator_RowDeletingName="UTENTERowDeleting" msprop:Generator_RowChangingName="UTENTERowChanging" msprop:Generator_RowDeletedName="UTENTERowDeleted" msprop:Generator_RowEvHandlerName="UTENTERowChangeEventHandler" msprop:Generator_TableClassName="UTENTEDataTable" msprop:Generator_RowChangedName="UTENTERowChanged" msprop:Generator_RowClassName="UTENTERow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="MATRICOLA" msprop:Generator_ColumnVarNameInTable="columnMATRICOLA" msprop:Generator_ColumnPropNameInRow="MATRICOLA" msprop:Generator_ColumnPropNameInTable="MATRICOLAColumn" msprop:Generator_UserColumnName="MATRICOLA" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_SOCIETA" msprop:Generator_ColumnVarNameInTable="columnCOD_SOCIETA" msprop:Generator_ColumnPropNameInRow="COD_SOCIETA" msprop:Generator_ColumnPropNameInTable="COD_SOCIETAColumn" msprop:Generator_UserColumnName="COD_SOCIETA" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COGNOME" msprop:Generator_ColumnVarNameInTable="columnCOGNOME" msprop:Generator_ColumnPropNameInRow="COGNOME" msprop:Generator_ColumnPropNameInTable="COGNOMEColumn" msprop:Generator_UserColumnName="COGNOME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NOME" msprop:Generator_ColumnVarNameInTable="columnNOME" msprop:Generator_ColumnPropNameInRow="NOME" msprop:Generator_ColumnPropNameInTable="NOMEColumn" msprop:Generator_UserColumnName="NOME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_CDC" msprop:Generator_ColumnVarNameInTable="columnCOD_CDC" msprop:Generator_ColumnPropNameInRow="COD_CDC" msprop:Generator_ColumnPropNameInTable="COD_CDCColumn" msprop:Generator_UserColumnName="COD_CDC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EMAIL" msprop:Generator_ColumnVarNameInTable="columnEMAIL" msprop:Generator_ColumnPropNameInRow="EMAIL" msprop:Generator_ColumnPropNameInTable="EMAILColumn" msprop:Generator_UserColumnName="EMAIL" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="USER_NAME" msprop:Generator_ColumnVarNameInTable="columnUSER_NAME" msprop:Generator_ColumnPropNameInRow="USER_NAME" msprop:Generator_ColumnPropNameInTable="USER_NAMEColumn" msprop:Generator_UserColumnName="USER_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SIGLA" msprop:Generator_ColumnVarNameInTable="columnSIGLA" msprop:Generator_ColumnPropNameInRow="SIGLA" msprop:Generator_ColumnPropNameInTable="SIGLAColumn" msprop:Generator_UserColumnName="SIGLA" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COD_LINGUA" msprop:Generator_ColumnVarNameInTable="columnCOD_LINGUA" msprop:Generator_ColumnPropNameInRow="COD_LINGUA" msprop:Generator_ColumnPropNameInTable="COD_LINGUAColumn" msprop:Generator_UserColumnName="COD_LINGUA" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ATTIVO" msprop:Generator_ColumnVarNameInTable="columnATTIVO" msprop:Generator_ColumnPropNameInRow="ATTIVO" msprop:Generator_ColumnPropNameInTable="ATTIVOColumn" msprop:Generator_UserColumnName="ATTIVO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DOMINIO" msprop:Generator_ColumnVarNameInTable="columnDOMINIO" msprop:Generator_ColumnPropNameInRow="DOMINIO" msprop:Generator_ColumnPropNameInTable="DOMINIOColumn" msprop:Generator_UserColumnName="DOMINIO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="LogUpdateDb" msprop:Generator_UserTableName="LogUpdateDb" msprop:Generator_RowEvArgName="LogUpdateDbRowChangeEvent" msprop:Generator_TableVarName="tableLogUpdateDb" msprop:Generator_TablePropName="LogUpdateDb" msprop:Generator_RowDeletingName="LogUpdateDbRowDeleting" msprop:Generator_RowChangingName="LogUpdateDbRowChanging" msprop:Generator_RowDeletedName="LogUpdateDbRowDeleted" msprop:Generator_RowEvHandlerName="LogUpdateDbRowChangeEventHandler" msprop:Generator_TableClassName="LogUpdateDbDataTable" msprop:Generator_RowChangedName="LogUpdateDbRowChanged" msprop:Generator_RowClassName="LogUpdateDbRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Versione" msprop:Generator_ColumnVarNameInTable="columnVersione" msprop:Generator_ColumnPropNameInRow="Versione" msprop:Generator_ColumnPropNameInTable="VersioneColumn" msprop:Generator_UserColumnName="Versione" type="xs:int" />
|
|
<xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="UserDataExt" msprop:Generator_UserTableName="UserDataExt" msprop:Generator_RowEvArgName="UserDataExtRowChangeEvent" msprop:Generator_TableVarName="tableUserDataExt" msprop:Generator_TablePropName="UserDataExt" msprop:Generator_RowDeletingName="UserDataExtRowDeleting" msprop:Generator_RowChangingName="UserDataExtRowChanging" msprop:Generator_RowDeletedName="UserDataExtRowDeleted" msprop:Generator_RowEvHandlerName="UserDataExtRowChangeEventHandler" msprop:Generator_TableClassName="UserDataExtDataTable" msprop:Generator_RowChangedName="UserDataExtRowChanged" msprop:Generator_RowClassName="UserDataExtRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="User_Name" msprop:Generator_ColumnVarNameInTable="columnUser_Name" msprop:Generator_ColumnPropNameInRow="User_Name" msprop:Generator_ColumnPropNameInTable="User_NameColumn" msprop:Generator_UserColumnName="User_Name">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Dominio" msprop:Generator_ColumnVarNameInTable="columnDominio" msprop:Generator_ColumnPropNameInRow="Dominio" msprop:Generator_ColumnPropNameInTable="DominioColumn" msprop:Generator_UserColumnName="Dominio" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Lingua" msprop:Generator_ColumnVarNameInTable="columnLingua" msprop:Generator_ColumnPropNameInRow="Lingua" msprop:Generator_ColumnPropNameInTable="LinguaColumn" msprop:Generator_UserColumnName="Lingua" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cod_Societa" msprop:Generator_ColumnVarNameInTable="columnCod_Societa" msprop:Generator_ColumnPropNameInRow="Cod_Societa" msprop:Generator_ColumnPropNameInTable="Cod_SocietaColumn" msprop:Generator_UserColumnName="Cod_Societa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Matricola" msprop:Generator_ColumnVarNameInTable="columnMatricola" msprop:Generator_ColumnPropNameInRow="Matricola" msprop:Generator_ColumnPropNameInTable="MatricolaColumn" msprop:Generator_UserColumnName="Matricola" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cod_CDC" msprop:Generator_ColumnVarNameInTable="columnCod_CDC" msprop:Generator_ColumnPropNameInRow="Cod_CDC" msprop:Generator_ColumnPropNameInTable="Cod_CDCColumn" msprop:Generator_UserColumnName="Cod_CDC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn" msprop:Generator_UserColumnName="Sigla" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="UserData" msprop:Generator_UserTableName="UserData" msprop:Generator_RowEvArgName="UserDataRowChangeEvent" msprop:Generator_TableVarName="tableUserData" msprop:Generator_TablePropName="UserData" msprop:Generator_RowDeletingName="UserDataRowDeleting" msprop:Generator_RowChangingName="UserDataRowChanging" msprop:Generator_RowDeletedName="UserDataRowDeleted" msprop:Generator_RowEvHandlerName="UserDataRowChangeEventHandler" msprop:Generator_TableClassName="UserDataDataTable" msprop:Generator_RowChangedName="UserDataRowChanged" msprop:Generator_RowClassName="UserDataRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="User_Name" msprop:Generator_ColumnVarNameInTable="columnUser_Name" msprop:Generator_ColumnPropNameInRow="User_Name" msprop:Generator_ColumnPropNameInTable="User_NameColumn" msprop:Generator_UserColumnName="User_Name">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Passwd" msprop:Generator_ColumnVarNameInTable="columnPasswd" msprop:Generator_ColumnPropNameInRow="Passwd" msprop:Generator_ColumnPropNameInTable="PasswdColumn" msprop:Generator_UserColumnName="Passwd" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cognome" msprop:Generator_ColumnVarNameInTable="columnCognome" msprop:Generator_ColumnPropNameInRow="Cognome" msprop:Generator_ColumnPropNameInTable="CognomeColumn" msprop:Generator_UserColumnName="Cognome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Attivo" msprop:Generator_ColumnVarNameInTable="columnAttivo" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_UserColumnName="Attivo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</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:CDC" />
|
|
<xs:field xpath="mstns:COD_CDC" />
|
|
</xs:unique>
|
|
<xs:unique name="MODULO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:MODULO" />
|
|
<xs:field xpath="mstns:COD_MODULO" />
|
|
</xs:unique>
|
|
<xs:unique name="FUNZIONE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:FUNZIONE" />
|
|
<xs:field xpath="mstns:COD_FUNZIONE" />
|
|
</xs:unique>
|
|
<xs:unique name="Permessi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Permessi" />
|
|
<xs:field xpath="mstns:COD_PERMESSO" />
|
|
</xs:unique>
|
|
<xs:unique name="Permessi2Funzione_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Permessi2Funzione" />
|
|
<xs:field xpath="mstns:COD_PERMESSO" />
|
|
<xs:field xpath="mstns:COD_FUNZIONE" />
|
|
</xs:unique>
|
|
<xs:unique name="DIRITTI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:DIRITTI" />
|
|
<xs:field xpath="mstns:USER_NAME" />
|
|
<xs:field xpath="mstns:COD_CDC" />
|
|
<xs:field xpath="mstns:COD_MODULO" />
|
|
<xs:field xpath="mstns:COD_FUNZIONE" />
|
|
</xs:unique>
|
|
<xs:unique name="UTENTE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:UTENTE" />
|
|
<xs:field xpath="mstns:USER_NAME" />
|
|
</xs:unique>
|
|
<xs:unique name="LogUpdateDb_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:LogUpdateDb" />
|
|
<xs:field xpath="mstns:Versione" />
|
|
</xs:unique>
|
|
<xs:unique name="UserDataExt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:UserDataExt" />
|
|
<xs:field xpath="mstns:User_Name" />
|
|
</xs:unique>
|
|
<xs:unique name="UserData_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:UserData" />
|
|
<xs:field xpath="mstns:User_Name" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_Permessi2Funzion_FUNZIONE" msdata:parent="FUNZIONE" msdata:child="Permessi2Funzione" msdata:parentkey="COD_FUNZIONE" msdata:childkey="COD_FUNZIONE" msprop:Generator_UserChildTable="Permessi2Funzione" msprop:Generator_ChildPropName="GetPermessi2FunzioneRows" msprop:Generator_UserRelationName="FK_Permessi2Funzion_FUNZIONE" msprop:Generator_ParentPropName="FUNZIONERow" msprop:Generator_RelationVarName="relationFK_Permessi2Funzion_FUNZIONE" msprop:Generator_UserParentTable="FUNZIONE" />
|
|
<msdata:Relationship name="FK_Permessi2Funzion_Permessi" msdata:parent="Permessi" msdata:child="Permessi2Funzione" msdata:parentkey="COD_PERMESSO" msdata:childkey="COD_PERMESSO" msprop:Generator_UserChildTable="Permessi2Funzione" msprop:Generator_ChildPropName="GetPermessi2FunzioneRows" msprop:Generator_UserRelationName="FK_Permessi2Funzion_Permessi" msprop:Generator_ParentPropName="PermessiRow" msprop:Generator_RelationVarName="relationFK_Permessi2Funzion_Permessi" msprop:Generator_UserParentTable="Permessi" />
|
|
<msdata:Relationship name="FK_DIRITTI_CDC1" msdata:parent="CDC" msdata:child="DIRITTI" msdata:parentkey="COD_CDC" msdata:childkey="COD_CDC" msprop:Generator_UserChildTable="DIRITTI" msprop:Generator_ChildPropName="GetDIRITTIRows" msprop:Generator_UserRelationName="FK_DIRITTI_CDC1" msprop:Generator_ParentPropName="CDCRow" msprop:Generator_RelationVarName="relationFK_DIRITTI_CDC1" msprop:Generator_UserParentTable="CDC" />
|
|
<msdata:Relationship name="FK_DIRITTI_FUNZIONE" msdata:parent="FUNZIONE" msdata:child="DIRITTI" msdata:parentkey="COD_FUNZIONE" msdata:childkey="COD_FUNZIONE" msprop:Generator_UserChildTable="DIRITTI" msprop:Generator_ChildPropName="_GetDIRITTIRows" msprop:Generator_UserRelationName="FK_DIRITTI_FUNZIONE" msprop:Generator_ParentPropName="FUNZIONERow" msprop:Generator_RelationVarName="relationFK_DIRITTI_FUNZIONE" msprop:Generator_UserParentTable="FUNZIONE" />
|
|
<msdata:Relationship name="FK_DIRITTI_MODULO1" msdata:parent="MODULO" msdata:child="DIRITTI" msdata:parentkey="COD_MODULO" msdata:childkey="COD_MODULO" msprop:Generator_UserChildTable="DIRITTI" msprop:Generator_ChildPropName="_GetDIRITTIRows" msprop:Generator_UserRelationName="FK_DIRITTI_MODULO1" msprop:Generator_ParentPropName="MODULORow" msprop:Generator_RelationVarName="relationFK_DIRITTI_MODULO1" msprop:Generator_UserParentTable="MODULO" />
|
|
<msdata:Relationship name="FK_DIRITTI_UTENTE" msdata:parent="UTENTE" msdata:child="DIRITTI" msdata:parentkey="USER_NAME" msdata:childkey="USER_NAME" msprop:Generator_UserChildTable="DIRITTI" msprop:Generator_ChildPropName="GetDIRITTIRows" msprop:Generator_UserRelationName="FK_DIRITTI_UTENTE" msprop:Generator_ParentPropName="UTENTERow" msprop:Generator_RelationVarName="relationFK_DIRITTI_UTENTE" msprop:Generator_UserParentTable="UTENTE" />
|
|
<msdata:Relationship name="FK_UTENTE_CDC" msdata:parent="CDC" msdata:child="UTENTE" msdata:parentkey="COD_CDC" msdata:childkey="COD_CDC" msprop:Generator_UserChildTable="UTENTE" msprop:Generator_ChildPropName="GetUTENTERows" msprop:Generator_UserRelationName="FK_UTENTE_CDC" msprop:Generator_ParentPropName="CDCRow" msprop:Generator_RelationVarName="relationFK_UTENTE_CDC" msprop:Generator_UserParentTable="CDC" />
|
|
<msdata:Relationship name="FK_UserDataExt_UserData" msdata:parent="UserData" msdata:child="UserDataExt" msdata:parentkey="User_Name" msdata:childkey="User_Name" msprop:Generator_UserChildTable="UserDataExt" msprop:Generator_ChildPropName="GetUserDataExtRows" msprop:Generator_UserRelationName="FK_UserDataExt_UserData" msprop:Generator_ParentPropName="UserDataRow" msprop:Generator_RelationVarName="relationFK_UserDataExt_UserData" msprop:Generator_UserParentTable="UserData" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |