442 lines
52 KiB
XML
442 lines
52 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Anagrafica" targetNamespace="http://tempuri.org/DS_Anagrafica.xsd" xmlns:mstns="http://tempuri.org/DS_Anagrafica.xsd" xmlns="http://tempuri.org/DS_Anagrafica.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ETS_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" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UtentiTableAdapter" GeneratorDataComponentClassName="UtentiTableAdapter" Name="Utenti" UserDataComponentName="UtentiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.Utenti" 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].[Utenti] WHERE (([UtenteAD] = @Original_UtenteAD) 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_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_sigla = 1 AND [sigla] IS NULL) OR ([sigla] = @Original_sigla)) 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_UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" 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_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_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].[Utenti] ([UtenteAD], [Cognome], [Nome], [email], [sigla], [attivo]) VALUES (@UtenteAD, @Cognome, @Nome, @email, @sigla, @attivo);
|
|
SELECT UtenteAD, Cognome, Nome, email, sigla, attivo FROM Utenti WHERE (UtenteAD = @UtenteAD)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" 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="@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="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 UtenteAD, Cognome, Nome, email, sigla, attivo FROM dbo.Utenti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Utenti] SET [UtenteAD] = @UtenteAD, [Cognome] = @Cognome, [Nome] = @Nome, [email] = @email, [sigla] = @sigla, [attivo] = @attivo WHERE (([UtenteAD] = @Original_UtenteAD) 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_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_sigla = 1 AND [sigla] IS NULL) OR ([sigla] = @Original_sigla)) AND ((@IsNull_attivo = 1 AND [attivo] IS NULL) OR ([attivo] = @Original_attivo)));
|
|
SELECT UtenteAD, Cognome, Nome, email, sigla, attivo FROM Utenti WHERE (UtenteAD = @UtenteAD)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" 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="@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="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_UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" 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_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_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="UtenteAD" DataSetColumn="UtenteAD" />
|
|
<Mapping SourceColumn="Cognome" DataSetColumn="Cognome" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="sigla" DataSetColumn="sigla" />
|
|
<Mapping SourceColumn="attivo" DataSetColumn="attivo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.stp_utenti_byKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_utenti_byKey</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.stp_utenti_CC" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getCapiCommessa" GetMethodModifier="Public" GetMethodName="getCapiCommessa" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getCapiCommessa" UserSourceName="getCapiCommessa">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_utenti_CC</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</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="ETS_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 [dbo].[Diritti] WHERE (([UtenteAD] = @Original_UtenteAD) AND ([codModulo] = @Original_codModulo) AND ([codFunzione] = @Original_codFunzione) AND ((@IsNull_valore = 1 AND [valore] IS NULL) OR ([valore] = @Original_valore)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codModulo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codFunzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFunzione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Diritti] ([UtenteAD], [codModulo], [codFunzione], [valore]) VALUES (@UtenteAD, @codModulo, @codFunzione, @valore);
|
|
SELECT UtenteAD, codModulo, codFunzione, valore FROM Diritti WHERE (UtenteAD = @UtenteAD) AND (codFunzione = @codFunzione) AND (codModulo = @codModulo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codModulo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codFunzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFunzione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT UtenteAD, codModulo, codFunzione, valore FROM dbo.Diritti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Diritti] SET [UtenteAD] = @UtenteAD, [codModulo] = @codModulo, [codFunzione] = @codFunzione, [valore] = @valore WHERE (([UtenteAD] = @Original_UtenteAD) AND ([codModulo] = @Original_codModulo) AND ([codFunzione] = @Original_codFunzione) AND ((@IsNull_valore = 1 AND [valore] IS NULL) OR ([valore] = @Original_valore)));
|
|
SELECT UtenteAD, codModulo, codFunzione, valore FROM Diritti WHERE (UtenteAD = @UtenteAD) AND (codFunzione = @codFunzione) AND (codModulo = @codModulo)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codModulo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@codFunzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFunzione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UtenteAD" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codModulo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_codFunzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="codFunzione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valore" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valore" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="UtenteAD" DataSetColumn="UtenteAD" />
|
|
<Mapping SourceColumn="codModulo" DataSetColumn="codModulo" />
|
|
<Mapping SourceColumn="codFunzione" DataSetColumn="codFunzione" />
|
|
<Mapping SourceColumn="valore" DataSetColumn="valore" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.stp_Dir_getByUserModFun" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUserModFun" GetMethodModifier="Public" GetMethodName="getByUserModFun" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUserModFun" UserSourceName="getByUserModFun">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Dir_getByUserModFun</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UtenteAD" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codModulo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@codFunzione" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FunzioniTableAdapter" GeneratorDataComponentClassName="FunzioniTableAdapter" Name="Funzioni" UserDataComponentName="FunzioniTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.Funzioni" 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].[Funzioni] 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].[Funzioni] ([COD_FUNZIONE], [Descrizione]) VALUES (@COD_FUNZIONE, @Descrizione);
|
|
SELECT COD_FUNZIONE, Descrizione FROM Funzioni 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.Funzioni</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Funzioni] 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 Funzioni 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 />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ModuliTableAdapter" GeneratorDataComponentClassName="ModuliTableAdapter" Name="Moduli" UserDataComponentName="ModuliTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ETS_AnagraficaConnectionString (Settings)" DbObjectName="ETS_Anagrafica.dbo.Moduli" 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].[Moduli] 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].[Moduli] ([COD_MODULO], [DESCRIZIONE]) VALUES (@COD_MODULO, @DESCRIZIONE);
|
|
SELECT COD_MODULO, DESCRIZIONE FROM Moduli 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.Moduli</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Moduli] 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 Moduli 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>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Anagrafica" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Anagrafica" msprop:Generator_UserDSName="DS_Anagrafica">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="Utenti" msprop:Generator_TableClassName="UtentiDataTable" msprop:Generator_TableVarName="tableUtenti" msprop:Generator_TablePropName="Utenti" msprop:Generator_RowDeletingName="UtentiRowDeleting" msprop:Generator_RowChangingName="UtentiRowChanging" msprop:Generator_RowEvHandlerName="UtentiRowChangeEventHandler" msprop:Generator_RowDeletedName="UtentiRowDeleted" msprop:Generator_UserTableName="Utenti" msprop:Generator_RowChangedName="UtentiRowChanged" msprop:Generator_RowEvArgName="UtentiRowChangeEvent" msprop:Generator_RowClassName="UtentiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="UtenteAD" msprop:Generator_ColumnVarNameInTable="columnUtenteAD" msprop:Generator_ColumnPropNameInRow="UtenteAD" msprop:Generator_ColumnPropNameInTable="UtenteADColumn" msprop:Generator_UserColumnName="UtenteAD">
|
|
<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="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="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="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:element name="Diritti" msprop:Generator_TableClassName="DirittiDataTable" msprop:Generator_TableVarName="tableDiritti" msprop:Generator_TablePropName="Diritti" msprop:Generator_RowDeletingName="DirittiRowDeleting" msprop:Generator_RowChangingName="DirittiRowChanging" msprop:Generator_RowEvHandlerName="DirittiRowChangeEventHandler" msprop:Generator_RowDeletedName="DirittiRowDeleted" msprop:Generator_UserTableName="Diritti" msprop:Generator_RowChangedName="DirittiRowChanged" msprop:Generator_RowEvArgName="DirittiRowChangeEvent" msprop:Generator_RowClassName="DirittiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="UtenteAD" msprop:Generator_ColumnVarNameInTable="columnUtenteAD" msprop:Generator_ColumnPropNameInRow="UtenteAD" msprop:Generator_ColumnPropNameInTable="UtenteADColumn" msprop:Generator_UserColumnName="UtenteAD">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codModulo" msprop:Generator_ColumnVarNameInTable="columncodModulo" msprop:Generator_ColumnPropNameInRow="codModulo" msprop:Generator_ColumnPropNameInTable="codModuloColumn" msprop:Generator_UserColumnName="codModulo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codFunzione" msprop:Generator_ColumnVarNameInTable="columncodFunzione" msprop:Generator_ColumnPropNameInRow="codFunzione" msprop:Generator_ColumnPropNameInTable="codFunzioneColumn" msprop:Generator_UserColumnName="codFunzione">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="valore" msprop:Generator_ColumnVarNameInTable="columnvalore" msprop:Generator_ColumnPropNameInRow="valore" msprop:Generator_ColumnPropNameInTable="valoreColumn" msprop:Generator_UserColumnName="valore" 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="Funzioni" msprop:Generator_TableClassName="FunzioniDataTable" msprop:Generator_TableVarName="tableFunzioni" msprop:Generator_TablePropName="Funzioni" msprop:Generator_RowDeletingName="FunzioniRowDeleting" msprop:Generator_RowChangingName="FunzioniRowChanging" msprop:Generator_RowEvHandlerName="FunzioniRowChangeEventHandler" msprop:Generator_RowDeletedName="FunzioniRowDeleted" msprop:Generator_UserTableName="Funzioni" msprop:Generator_RowChangedName="FunzioniRowChanged" msprop:Generator_RowEvArgName="FunzioniRowChangeEvent" msprop:Generator_RowClassName="FunzioniRow">
|
|
<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="Moduli" msprop:Generator_TableClassName="ModuliDataTable" msprop:Generator_TableVarName="tableModuli" msprop:Generator_TablePropName="Moduli" msprop:Generator_RowDeletingName="ModuliRowDeleting" msprop:Generator_RowChangingName="ModuliRowChanging" msprop:Generator_RowEvHandlerName="ModuliRowChangeEventHandler" msprop:Generator_RowDeletedName="ModuliRowDeleted" msprop:Generator_UserTableName="Moduli" msprop:Generator_RowChangedName="ModuliRowChanged" msprop:Generator_RowEvArgName="ModuliRowChangeEvent" msprop:Generator_RowClassName="ModuliRow">
|
|
<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="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="200" />
|
|
</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:Utenti" />
|
|
<xs:field xpath="mstns:UtenteAD" />
|
|
</xs:unique>
|
|
<xs:unique name="Diritti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Diritti" />
|
|
<xs:field xpath="mstns:UtenteAD" />
|
|
<xs:field xpath="mstns:codModulo" />
|
|
<xs:field xpath="mstns:codFunzione" />
|
|
</xs:unique>
|
|
<xs:unique name="Funzioni_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Funzioni" />
|
|
<xs:field xpath="mstns:COD_FUNZIONE" />
|
|
</xs:unique>
|
|
<xs:unique name="Moduli_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Moduli" />
|
|
<xs:field xpath="mstns:COD_MODULO" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_DIRITTI_UTENTE" msdata:parent="Utenti" msdata:child="Diritti" msdata:parentkey="UtenteAD" msdata:childkey="UtenteAD" msprop:Generator_UserChildTable="Diritti" msprop:Generator_ChildPropName="GetDirittiRows" msprop:Generator_UserRelationName="FK_DIRITTI_UTENTE" msprop:Generator_ParentPropName="UtentiRow" msprop:Generator_RelationVarName="relationFK_DIRITTI_UTENTE" msprop:Generator_UserParentTable="Utenti" />
|
|
<msdata:Relationship name="FK_DIRITTI_FUNZIONE" msdata:parent="Funzioni" msdata:child="Diritti" msdata:parentkey="COD_FUNZIONE" msdata:childkey="codFunzione" msprop:Generator_UserChildTable="Diritti" msprop:Generator_ChildPropName="GetDirittiRows" msprop:Generator_UserRelationName="FK_DIRITTI_FUNZIONE" msprop:Generator_RelationVarName="relationFK_DIRITTI_FUNZIONE" msprop:Generator_UserParentTable="Funzioni" msprop:Generator_ParentPropName="FunzioniRow" />
|
|
<msdata:Relationship name="FK_DIRITTI_MODULO" msdata:parent="Moduli" msdata:child="Diritti" msdata:parentkey="COD_MODULO" msdata:childkey="codModulo" msprop:Generator_UserChildTable="Diritti" msprop:Generator_ChildPropName="GetDirittiRows" msprop:Generator_UserRelationName="FK_DIRITTI_MODULO" msprop:Generator_RelationVarName="relationFK_DIRITTI_MODULO" msprop:Generator_UserParentTable="Moduli" msprop:Generator_ParentPropName="ModuliRow" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |