Samuele Locatelli
742 lines
78 KiB
XML
742 lines
78 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_utility" targetNamespace="http://tempuri.org/DS_utility.xsd" xmlns:mstns="http://tempuri.org/DS_utility.xsd" xmlns="http://tempuri.org/DS_utility.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_AnagraficaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_AnagraficaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_AnagraficaConnectionString" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_XPSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_XPSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_XPSConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selUtentiAllTableAdapter" GeneratorDataComponentClassName="v_selUtentiAllTableAdapter" Name="v_selUtentiAll" UserDataComponentName="v_selUtentiAllTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_Anagrafica.dbo.v_selUtentiAll" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, COD_CDC, ATTIVO FROM dbo.v_selUtentiAll</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="COD_CDC" DataSetColumn="COD_CDC" />
|
|
<Mapping SourceColumn="ATTIVO" DataSetColumn="ATTIVO" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UTENTETableAdapter" GeneratorDataComponentClassName="UTENTETableAdapter" Name="UTENTE" UserDataComponentName="UTENTETableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_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 [dbo].[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 [dbo].[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="false">
|
|
<CommandText>SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO FROM dbo.UTENTE</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[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="DOMINIO" DataSetColumn="DOMINIO" />
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="COGNOME" DataSetColumn="COGNOME" />
|
|
<Mapping SourceColumn="NOME" DataSetColumn="NOME" />
|
|
<Mapping SourceColumn="COD_SOCIETA" DataSetColumn="COD_SOCIETA" />
|
|
<Mapping SourceColumn="MATRICOLA" DataSetColumn="MATRICOLA" />
|
|
<Mapping SourceColumn="COD_CDC" DataSetColumn="COD_CDC" />
|
|
<Mapping SourceColumn="EMAIL" DataSetColumn="EMAIL" />
|
|
<Mapping SourceColumn="SIGLA" DataSetColumn="SIGLA" />
|
|
<Mapping SourceColumn="COD_LINGUA" DataSetColumn="COD_LINGUA" />
|
|
<Mapping SourceColumn="ATTIVO" DataSetColumn="ATTIVO" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_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 *
|
|
FROM Utente
|
|
WHERE (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="USER_NAME" ColumnName="USER_NAME" DataSourceName="Equa_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>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selUtentiShortADTableAdapter" GeneratorDataComponentClassName="v_selUtentiShortADTableAdapter" Name="v_selUtentiShortAD" UserDataComponentName="v_selUtentiShortADTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_Anagrafica.dbo.v_selUtentiShortAD" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, COD_CDC, ATTIVO FROM dbo.v_selUtentiShortAD</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="COD_CDC" DataSetColumn="COD_CDC" />
|
|
<Mapping SourceColumn="ATTIVO" DataSetColumn="ATTIVO" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_AnagraficaConnectionString (Settings)" DbObjectName="Equa_Anagrafica.dbo.v_selUtentiShortAD" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByValue" GetMethodModifier="Public" GetMethodName="getByValue" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByValue" UserSourceName="getByValue">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT value, label, COD_CDC, ATTIVO FROM dbo.v_selUtentiShortAD
|
|
where value=@value</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="value" ColumnName="value" DataSourceName="Equa_Anagrafica.dbo.v_selUtentiShortAD" DataTypeServer="nvarchar(81)" DbType="String" Direction="Input" ParameterName="@value" Precision="0" ProviderType="NVarChar" Scale="0" Size="81" SourceColumn="value" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selFiltriTableAdapter" GeneratorDataComponentClassName="v_selFiltriTableAdapter" Name="v_selFiltri" UserDataComponentName="v_selFiltriTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selFiltri" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, conditio FROM dbo.v_selFiltri</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_VSF_getByCond" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSF_getByCond</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="@conditio" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_VSF_getByUrl" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUrl" GetMethodModifier="Public" GetMethodName="getByUrl" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUrl" UserSourceName="getByUrl">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSF_getByUrl</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="@url" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selTipoEventoTableAdapter" GeneratorDataComponentClassName="v_selTipoEventoTableAdapter" Name="v_selTipoEvento" UserDataComponentName="v_selTipoEventoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selTipoEvento" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selTipoEvento</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_dateEsecuzioneTableAdapter" GeneratorDataComponentClassName="v_dateEsecuzioneTableAdapter" Name="v_dateEsecuzione" UserDataComponentName="v_dateEsecuzioneTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_dateEsecuzione" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Data FROM dbo.v_dateEsecuzione</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_dateProxScadenze" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByDataMin" GetMethodModifier="Public" GetMethodName="getByDataMin" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByDataMin" UserSourceName="getByDataMin">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_dateProxScadenze</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataMin" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selStatiTableAdapter" GeneratorDataComponentClassName="v_selStatiTableAdapter" Name="v_selStati" UserDataComponentName="v_selStatiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selStati" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label, conditio FROM dbo.v_selStati</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selStati" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT value, label, conditio FROM dbo.v_selStati
|
|
where conditio=@conditio</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="conditio" ColumnName="conditio" DataSourceName="Equa_XPS.dbo.v_selStati" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@conditio" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="conditio" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.stp_selStatiMinMax" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByPiorita" GetMethodModifier="Public" GetMethodName="getByPiorita" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByPiorita" UserSourceName="getByPiorita">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_selStatiMinMax</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PrioritaStatoMin" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PrioritaStatoMax" 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="v_selClientiTableAdapter" GeneratorDataComponentClassName="v_selClientiTableAdapter" Name="v_selClienti" UserDataComponentName="v_selClientiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selClienti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selClienti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selTipoMappaTableAdapter" GeneratorDataComponentClassName="v_selTipoMappaTableAdapter" Name="v_selTipoMappa" UserDataComponentName="v_selTipoMappaTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selTipoMappa" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selTipoMappa</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selAnagLavTableAdapter" GeneratorDataComponentClassName="v_selAnagLavTableAdapter" Name="v_selAnagLav" UserDataComponentName="v_selAnagLavTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selAnagLav" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selAnagLav</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selSetObjTableAdapter" GeneratorDataComponentClassName="v_selSetObjTableAdapter" Name="v_selSetObj" UserDataComponentName="v_selSetObjTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS.dbo.v_selSetObj" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selSetObj</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_utility" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_utility" msprop:Generator_UserDSName="DS_utility">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="v_selUtentiAll" msprop:Generator_UserTableName="v_selUtentiAll" msprop:Generator_RowEvArgName="v_selUtentiAllRowChangeEvent" msprop:Generator_TableVarName="tablev_selUtentiAll" msprop:Generator_TablePropName="v_selUtentiAll" msprop:Generator_RowDeletingName="v_selUtentiAllRowDeleting" msprop:Generator_RowChangingName="v_selUtentiAllRowChanging" msprop:Generator_RowDeletedName="v_selUtentiAllRowDeleted" msprop:Generator_RowEvHandlerName="v_selUtentiAllRowChangeEventHandler" msprop:Generator_TableClassName="v_selUtentiAllDataTable" msprop:Generator_RowChangedName="v_selUtentiAllRowChanged" msprop:Generator_RowClassName="v_selUtentiAllRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="232" />
|
|
</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="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="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="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: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="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_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="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="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:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selUtentiShortAD" msprop:Generator_UserTableName="v_selUtentiShortAD" msprop:Generator_RowEvArgName="v_selUtentiShortADRowChangeEvent" msprop:Generator_TableVarName="tablev_selUtentiShortAD" msprop:Generator_TablePropName="v_selUtentiShortAD" msprop:Generator_RowDeletingName="v_selUtentiShortADRowDeleting" msprop:Generator_RowChangingName="v_selUtentiShortADRowChanging" msprop:Generator_RowDeletedName="v_selUtentiShortADRowDeleted" msprop:Generator_RowEvHandlerName="v_selUtentiShortADRowChangeEventHandler" msprop:Generator_TableClassName="v_selUtentiShortADDataTable" msprop:Generator_RowChangedName="v_selUtentiShortADRowChanged" msprop:Generator_RowClassName="v_selUtentiShortADRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" 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="81" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="201" />
|
|
</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="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="v_selFiltri" msprop:Generator_UserTableName="v_selFiltri" msprop:Generator_RowEvArgName="v_selFiltriRowChangeEvent" msprop:Generator_TableVarName="tablev_selFiltri" msprop:Generator_TablePropName="v_selFiltri" msprop:Generator_RowDeletingName="v_selFiltriRowDeleting" msprop:Generator_RowChangingName="v_selFiltriRowChanging" msprop:Generator_RowDeletedName="v_selFiltriRowDeleted" msprop:Generator_RowEvHandlerName="v_selFiltriRowChangeEventHandler" msprop:Generator_TableClassName="v_selFiltriDataTable" msprop:Generator_RowChangedName="v_selFiltriRowChanged" msprop:Generator_RowClassName="v_selFiltriRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="31" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selTipoEvento" msprop:Generator_UserTableName="v_selTipoEvento" msprop:Generator_RowEvArgName="v_selTipoEventoRowChangeEvent" msprop:Generator_TableVarName="tablev_selTipoEvento" msprop:Generator_TablePropName="v_selTipoEvento" msprop:Generator_RowDeletingName="v_selTipoEventoRowDeleting" msprop:Generator_RowChangingName="v_selTipoEventoRowChanging" msprop:Generator_RowDeletedName="v_selTipoEventoRowDeleted" msprop:Generator_RowEvHandlerName="v_selTipoEventoRowChangeEventHandler" msprop:Generator_TableClassName="v_selTipoEventoDataTable" msprop:Generator_RowChangedName="v_selTipoEventoRowChanged" msprop:Generator_RowClassName="v_selTipoEventoRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_dateEsecuzione" msprop:Generator_UserTableName="v_dateEsecuzione" msprop:Generator_RowEvArgName="v_dateEsecuzioneRowChangeEvent" msprop:Generator_TableVarName="tablev_dateEsecuzione" msprop:Generator_TablePropName="v_dateEsecuzione" msprop:Generator_RowDeletingName="v_dateEsecuzioneRowDeleting" msprop:Generator_RowChangingName="v_dateEsecuzioneRowChanging" msprop:Generator_RowDeletedName="v_dateEsecuzioneRowDeleted" msprop:Generator_RowEvHandlerName="v_dateEsecuzioneRowChangeEventHandler" msprop:Generator_TableClassName="v_dateEsecuzioneDataTable" msprop:Generator_RowChangedName="v_dateEsecuzioneRowChanged" msprop:Generator_RowClassName="v_dateEsecuzioneRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Data" msdata:ReadOnly="true" 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="v_selStati" msprop:Generator_UserTableName="v_selStati" msprop:Generator_RowEvArgName="v_selStatiRowChangeEvent" msprop:Generator_TableVarName="tablev_selStati" msprop:Generator_TablePropName="v_selStati" msprop:Generator_RowDeletingName="v_selStatiRowDeleting" msprop:Generator_RowChangingName="v_selStatiRowChanging" msprop:Generator_RowDeletedName="v_selStatiRowDeleted" msprop:Generator_RowEvHandlerName="v_selStatiRowChangeEventHandler" msprop:Generator_TableClassName="v_selStatiDataTable" msprop:Generator_RowChangedName="v_selStatiRowChanged" msprop:Generator_RowClassName="v_selStatiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selClienti" msprop:Generator_UserTableName="v_selClienti" msprop:Generator_RowEvArgName="v_selClientiRowChangeEvent" msprop:Generator_TableVarName="tablev_selClienti" msprop:Generator_TablePropName="v_selClienti" msprop:Generator_RowDeletingName="v_selClientiRowDeleting" msprop:Generator_RowChangingName="v_selClientiRowChanging" msprop:Generator_RowDeletedName="v_selClientiRowDeleted" msprop:Generator_RowEvHandlerName="v_selClientiRowChangeEventHandler" msprop:Generator_TableClassName="v_selClientiDataTable" msprop:Generator_RowChangedName="v_selClientiRowChanged" msprop:Generator_RowClassName="v_selClientiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" 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="v_selTipoMappa" msprop:Generator_UserTableName="v_selTipoMappa" msprop:Generator_RowEvArgName="v_selTipoMappaRowChangeEvent" msprop:Generator_TableVarName="tablev_selTipoMappa" msprop:Generator_TablePropName="v_selTipoMappa" msprop:Generator_RowDeletingName="v_selTipoMappaRowDeleting" msprop:Generator_RowChangingName="v_selTipoMappaRowChanging" msprop:Generator_RowDeletedName="v_selTipoMappaRowDeleted" msprop:Generator_RowEvHandlerName="v_selTipoMappaRowChangeEventHandler" msprop:Generator_TableClassName="v_selTipoMappaDataTable" msprop:Generator_RowChangedName="v_selTipoMappaRowChanged" msprop:Generator_RowClassName="v_selTipoMappaRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selAnagLav" msprop:Generator_UserTableName="v_selAnagLav" msprop:Generator_RowEvArgName="v_selAnagLavRowChangeEvent" msprop:Generator_TableVarName="tablev_selAnagLav" msprop:Generator_TablePropName="v_selAnagLav" msprop:Generator_RowDeletingName="v_selAnagLavRowDeleting" msprop:Generator_RowChangingName="v_selAnagLavRowChanging" msprop:Generator_RowDeletedName="v_selAnagLavRowDeleted" msprop:Generator_RowEvHandlerName="v_selAnagLavRowChangeEventHandler" msprop:Generator_TableClassName="v_selAnagLavDataTable" msprop:Generator_RowChangedName="v_selAnagLavRowChanged" msprop:Generator_RowClassName="v_selAnagLavRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selSetObj" msprop:Generator_UserTableName="v_selSetObj" msprop:Generator_RowEvArgName="v_selSetObjRowChangeEvent" msprop:Generator_TableVarName="tablev_selSetObj" msprop:Generator_TablePropName="v_selSetObj" msprop:Generator_RowDeletingName="v_selSetObjRowDeleting" msprop:Generator_RowChangingName="v_selSetObjRowChanging" msprop:Generator_RowDeletedName="v_selSetObjRowDeleted" msprop:Generator_RowEvHandlerName="v_selSetObjRowChangeEventHandler" msprop:Generator_TableClassName="v_selSetObjDataTable" msprop:Generator_RowChangedName="v_selSetObjRowChanged" msprop:Generator_RowClassName="v_selSetObjRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" 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:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selUtentiAll" />
|
|
<xs:field xpath="mstns:value" />
|
|
</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="v_selFiltri_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selFiltri" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selTipoEvento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selTipoEvento" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selStati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selStati" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selClienti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selClienti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selTipoMappa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selTipoMappa" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selAnagLav_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selAnagLav" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selSetObj_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selSetObj" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |