Samuele E. Locatelli
909 lines
108 KiB
XML
909 lines
108 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_User" targetNamespace="http://tempuri.org/DS_User.xsd" xmlns:mstns="http://tempuri.org/DS_User.xsd" xmlns="http://tempuri.org/DS_User.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="B2BCondConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="B2BCondConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Data.Properties.Settings.GlobalReference.Default.B2BCondConnectionString" 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="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.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 (([USER_NAME] = @Original_USER_NAME) AND ([cognome] = @Original_cognome) AND ([nome] = @Original_nome) AND ([email] = @Original_email) AND ([authKey] = @Original_authKey) AND ([numAuth] = @Original_numAuth) AND ([attivo] = @Original_attivo) AND ([CodGruppo] = @Original_CodGruppo) AND ([resetAuthKeyReq] = @Original_resetAuthKeyReq) AND ([TipoUser] = @Original_TipoUser))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_authKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="authKey" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numAuth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numAuth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="attivo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_resetAuthKeyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="resetAuthKeyReq" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TipoUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoUser" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Utenti] ([USER_NAME], [cognome], [nome], [email], [authKey], [numAuth], [attivo], [CodGruppo], [resetAuthKeyReq], [TipoUser]) VALUES (@USER_NAME, @cognome, @nome, @email, @authKey, @numAuth, @attivo, @CodGruppo, @resetAuthKeyReq, @TipoUser);
|
|
SELECT USER_NAME, cognome, nome, email, authKey, numAuth, attivo, CodGruppo, resetAuthKeyReq, TipoUser FROM Utenti WHERE (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@authKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="authKey" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numAuth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numAuth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="attivo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@resetAuthKeyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="resetAuthKeyReq" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TipoUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoUser" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT USER_NAME, cognome, nome, email, authKey, numAuth, attivo, CodGruppo, resetAuthKeyReq, TipoUser FROM dbo.Utenti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Utenti] SET [USER_NAME] = @USER_NAME, [cognome] = @cognome, [nome] = @nome, [email] = @email, [authKey] = @authKey, [numAuth] = @numAuth, [attivo] = @attivo, [CodGruppo] = @CodGruppo, [resetAuthKeyReq] = @resetAuthKeyReq, [TipoUser] = @TipoUser WHERE (([USER_NAME] = @Original_USER_NAME) AND ([cognome] = @Original_cognome) AND ([nome] = @Original_nome) AND ([email] = @Original_email) AND ([authKey] = @Original_authKey) AND ([numAuth] = @Original_numAuth) AND ([attivo] = @Original_attivo) AND ([CodGruppo] = @Original_CodGruppo) AND ([resetAuthKeyReq] = @Original_resetAuthKeyReq) AND ([TipoUser] = @Original_TipoUser));
|
|
SELECT USER_NAME, cognome, nome, email, authKey, numAuth, attivo, CodGruppo, resetAuthKeyReq, TipoUser FROM Utenti WHERE (USER_NAME = @USER_NAME)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@authKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="authKey" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numAuth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numAuth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="attivo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@resetAuthKeyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="resetAuthKeyReq" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TipoUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoUser" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_authKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="authKey" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numAuth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numAuth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="attivo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_resetAuthKeyReq" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="resetAuthKeyReq" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TipoUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoUser" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="cognome" DataSetColumn="cognome" />
|
|
<Mapping SourceColumn="nome" DataSetColumn="nome" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="authKey" DataSetColumn="authKey" />
|
|
<Mapping SourceColumn="numAuth" DataSetColumn="numAuth" />
|
|
<Mapping SourceColumn="attivo" DataSetColumn="attivo" />
|
|
<Mapping SourceColumn="CodGruppo" DataSetColumn="CodGruppo" />
|
|
<Mapping SourceColumn="resetAuthKeyReq" DataSetColumn="resetAuthKeyReq" />
|
|
<Mapping SourceColumn="TipoUser" DataSetColumn="TipoUser" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2A_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteRelAU2A" Modifier="Public" Name="deleteRelAU2A" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteRelAU2A">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2A_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2F_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteRelAU2F" Modifier="Public" Name="deleteRelAU2F" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="deleteRelAU2F">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2F_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_Utenti_getByEmail" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByEmail" GetMethodModifier="Public" GetMethodName="getByEmail" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByEmail" UserSourceName="getByEmail">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Utenti_getByEmail</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="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_Utenti_getByAmm" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxAmm" GetMethodModifier="Public" GetMethodName="getByIdxAmm" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxAmm" UserSourceName="getByIdxAmm">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Utenti_getByAmm</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="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_Utenti_getByForn" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIdxForn" GetMethodModifier="Public" GetMethodName="getByIdxForn" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIdxForn" UserSourceName="getByIdxForn">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Utenti_getByForn</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="@idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_Utenti_getUnassByEmail" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getUnassByEmail" GetMethodModifier="Public" GetMethodName="getUnassByEmail" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getUnassByEmail" UserSourceName="getUnassByEmail">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Utenti_getUnassByEmail</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="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2A_initUser" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="initUserAmm" Modifier="Public" Name="initUserAmm" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="initUserAmm">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2A_initUser</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="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2F_initUser" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="initUserForn" Modifier="Public" Name="initUserForn" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="initUserForn">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2F_initUser</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="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxForn" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_Utenti_InsertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Utenti_InsertQuery</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="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@cognome" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@authKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numAuth" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodGruppo" 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="AssU2ATableAdapter" GeneratorDataComponentClassName="AssU2ATableAdapter" Name="AssU2A" UserDataComponentName="AssU2ATableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AssU2A" 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].[AssU2A] WHERE (([USER_NAME] = @Original_USER_NAME) AND ([idxAmm] = @Original_idxAmm))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AssU2A] ([USER_NAME], [idxAmm]) VALUES (@USER_NAME, @idxAmm);
|
|
SELECT USER_NAME, idxAmm FROM AssU2A WHERE (USER_NAME = @USER_NAME) AND (idxAmm = @idxAmm)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT USER_NAME, idxAmm FROM dbo.AssU2A</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AssU2A] SET [USER_NAME] = @USER_NAME, [idxAmm] = @idxAmm WHERE (([USER_NAME] = @Original_USER_NAME) AND ([idxAmm] = @Original_idxAmm));
|
|
SELECT USER_NAME, idxAmm FROM AssU2A WHERE (USER_NAME = @USER_NAME) AND (idxAmm = @idxAmm)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="idxAmm" DataSetColumn="idxAmm" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2A_getByUser" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUser" GetMethodModifier="Public" GetMethodName="getByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUser" UserSourceName="getByUser">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2A_getByUser</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="@USER_NAME" 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="AssU2CTableAdapter" GeneratorDataComponentClassName="AssU2CTableAdapter" Name="AssU2C" UserDataComponentName="AssU2CTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AssU2C" 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].[AssU2C] WHERE (([USER_NAME] = @Original_USER_NAME) AND ([idxCond] = @Original_idxCond))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AssU2C] ([USER_NAME], [idxCond]) VALUES (@USER_NAME, @idxCond);
|
|
SELECT USER_NAME, idxCond FROM AssU2C WHERE (USER_NAME = @USER_NAME) AND (idxCond = @idxCond)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT USER_NAME, idxCond FROM dbo.AssU2C</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AssU2C] SET [USER_NAME] = @USER_NAME, [idxCond] = @idxCond WHERE (([USER_NAME] = @Original_USER_NAME) AND ([idxCond] = @Original_idxCond));
|
|
SELECT USER_NAME, idxCond FROM AssU2C WHERE (USER_NAME = @USER_NAME) AND (idxCond = @idxCond)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="idxCond" DataSetColumn="idxCond" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2C_getByUser" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUser" GetMethodModifier="Public" GetMethodName="getByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUser" UserSourceName="getByUser">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2C_getByUser</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="@USER_NAME" 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="AssU2FTableAdapter" GeneratorDataComponentClassName="AssU2FTableAdapter" Name="AssU2F" UserDataComponentName="AssU2FTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AssU2F" 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].[AssU2F] WHERE (([USER_NAME] = @Original_USER_NAME) AND ([idxFornitore] = @Original_idxFornitore))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AssU2F] ([USER_NAME], [idxFornitore]) VALUES (@USER_NAME, @idxFornitore);
|
|
SELECT USER_NAME, idxFornitore FROM AssU2F WHERE (USER_NAME = @USER_NAME) AND (idxFornitore = @idxFornitore)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT USER_NAME, idxFornitore FROM dbo.AssU2F</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AssU2F] SET [USER_NAME] = @USER_NAME, [idxFornitore] = @idxFornitore WHERE (([USER_NAME] = @Original_USER_NAME) AND ([idxFornitore] = @Original_idxFornitore));
|
|
SELECT USER_NAME, idxFornitore FROM AssU2F WHERE (USER_NAME = @USER_NAME) AND (idxFornitore = @idxFornitore)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USER_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFornitore" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
|
|
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2F_getByUser" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUser" GetMethodModifier="Public" GetMethodName="getByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUser" UserSourceName="getByUser">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2F_getByUser</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="@USER_NAME" 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="AnagCondominiTableAdapter" GeneratorDataComponentClassName="AnagCondominiTableAdapter" Name="AnagCondomini" UserDataComponentName="AnagCondominiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.AnagCondomini" 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].[AnagCondomini] WHERE (([idxCond] = @Original_idxCond) AND ([cod_cond] = @Original_cod_cond) AND ([nome] = @Original_nome) AND ([indirizzo] = @Original_indirizzo) AND ([cap] = @Original_cap) AND ([citta] = @Original_citta) AND ([cod_fisc] = @Original_cod_fisc) AND ([idxAmm] = @Original_idxAmm) AND ([Attivo] = @Original_Attivo))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cod_cond" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_cond" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cap" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="citta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cod_fisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_fisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagCondomini] ([cod_cond], [nome], [indirizzo], [cap], [citta], [cod_fisc], [idxAmm], [Attivo]) VALUES (@cod_cond, @nome, @indirizzo, @cap, @citta, @cod_fisc, @idxAmm, @Attivo);
|
|
SELECT idxCond, cod_cond, nome, indirizzo, cap, citta, cod_fisc, idxAmm, Attivo FROM AnagCondomini WHERE (idxCond = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cod_cond" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_cond" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cap" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="citta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cod_fisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_fisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxCond, cod_cond, nome, indirizzo, cap, citta, cod_fisc, idxAmm, Attivo FROM dbo.AnagCondomini</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagCondomini] SET [cod_cond] = @cod_cond, [nome] = @nome, [indirizzo] = @indirizzo, [cap] = @cap, [citta] = @citta, [cod_fisc] = @cod_fisc, [idxAmm] = @idxAmm, [Attivo] = @Attivo WHERE (([idxCond] = @Original_idxCond) AND ([cod_cond] = @Original_cod_cond) AND ([nome] = @Original_nome) AND ([indirizzo] = @Original_indirizzo) AND ([cap] = @Original_cap) AND ([citta] = @Original_citta) AND ([cod_fisc] = @Original_cod_fisc) AND ([idxAmm] = @Original_idxAmm) AND ([Attivo] = @Original_Attivo));
|
|
SELECT idxCond, cod_cond, nome, indirizzo, cap, citta, cod_fisc, idxAmm, Attivo FROM AnagCondomini WHERE (idxCond = @idxCond)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cod_cond" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_cond" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cap" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="citta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cod_fisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_fisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxCond" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cod_cond" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_cond" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_indirizzo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cap" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_citta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="citta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cod_fisc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cod_fisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxAmm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxAmm" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Attivo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxCond" ColumnName="idxCond" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxCond" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxCond" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxCond" DataSetColumn="idxCond" />
|
|
<Mapping SourceColumn="cod_cond" DataSetColumn="cod_cond" />
|
|
<Mapping SourceColumn="nome" DataSetColumn="nome" />
|
|
<Mapping SourceColumn="indirizzo" DataSetColumn="indirizzo" />
|
|
<Mapping SourceColumn="cap" DataSetColumn="cap" />
|
|
<Mapping SourceColumn="citta" DataSetColumn="citta" />
|
|
<Mapping SourceColumn="cod_fisc" DataSetColumn="cod_fisc" />
|
|
<Mapping SourceColumn="idxAmm" DataSetColumn="idxAmm" />
|
|
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagAmministratoriTableAdapter" GeneratorDataComponentClassName="AnagAmministratoriTableAdapter" Name="AnagAmministratori" UserDataComponentName="AnagAmministratoriTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_AnagAmministratori" 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="true">
|
|
<CommandText>SELECT *
|
|
FROM dbo.v_AnagAmministratori</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxAmm" DataSetColumn="idxAmm" />
|
|
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="NumCondAttivi" DataSetColumn="NumCondAttivi" />
|
|
<Mapping SourceColumn="NumCond" DataSetColumn="NumCond" />
|
|
<Mapping SourceColumn="NumRich" DataSetColumn="NumRich" />
|
|
<Mapping SourceColumn="NumInt" DataSetColumn="NumInt" />
|
|
<Mapping SourceColumn="ImponibileTot" DataSetColumn="ImponibileTot" />
|
|
<Mapping SourceColumn="ImponibileMedio" DataSetColumn="ImponibileMedio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2A_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteRelAU2A" Modifier="Public" Name="deleteRelAU2A" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteRelAU2A">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2A_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxAmm" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AA_getByUA" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUserAss" GetMethodModifier="Public" GetMethodName="getByUserAss" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUserAss" UserSourceName="getByUserAss">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AA_getByUA</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="@USER_NAME" 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="AnagFornitoriTableAdapter" GeneratorDataComponentClassName="AnagFornitoriTableAdapter" Name="AnagFornitori" UserDataComponentName="AnagFornitoriTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.v_AnagFornitori" 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="true">
|
|
<CommandText>SELECT *
|
|
FROM dbo.v_AnagFornitori</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxFornitore" DataSetColumn="idxFornitore" />
|
|
<Mapping SourceColumn="nome" DataSetColumn="nome" />
|
|
<Mapping SourceColumn="indirizzo" DataSetColumn="indirizzo" />
|
|
<Mapping SourceColumn="iscritta" DataSetColumn="iscritta" />
|
|
<Mapping SourceColumn="attivo" DataSetColumn="attivo" />
|
|
<Mapping SourceColumn="CAP" DataSetColumn="CAP" />
|
|
<Mapping SourceColumn="citta" DataSetColumn="citta" />
|
|
<Mapping SourceColumn="provincia" DataSetColumn="provincia" />
|
|
<Mapping SourceColumn="stato" DataSetColumn="stato" />
|
|
<Mapping SourceColumn="pIva" DataSetColumn="pIva" />
|
|
<Mapping SourceColumn="cFisc" DataSetColumn="cFisc" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="telefono" DataSetColumn="telefono" />
|
|
<Mapping SourceColumn="cellulare" DataSetColumn="cellulare" />
|
|
<Mapping SourceColumn="cssStatoForn" DataSetColumn="cssStatoForn" />
|
|
<Mapping SourceColumn="quotaStd" DataSetColumn="quotaStd" />
|
|
<Mapping SourceColumn="noteQuota" DataSetColumn="noteQuota" />
|
|
<Mapping SourceColumn="numRich" DataSetColumn="numRich" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AU2F_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteRelAU2F" Modifier="Public" Name="deleteRelAU2F" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteRelAU2F">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AU2F_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxFornitore" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="B2BCondConnectionString (Settings)" DbObjectName="B2BCond.dbo.stp_AF_getByUA" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUserAss" GetMethodModifier="Public" GetMethodName="getByUserAss" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUserAss" UserSourceName="getByUserAss">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AF_getByUA</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="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_User" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_User" msprop:Generator_UserDSName="DS_User">
|
|
<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="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">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</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">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</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">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="authKey" msprop:Generator_ColumnVarNameInTable="columnauthKey" msprop:Generator_ColumnPropNameInRow="authKey" msprop:Generator_ColumnPropNameInTable="authKeyColumn" msprop:Generator_UserColumnName="authKey">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="numAuth" msprop:Generator_ColumnVarNameInTable="columnnumAuth" msprop:Generator_ColumnPropNameInRow="numAuth" msprop:Generator_ColumnPropNameInTable="numAuthColumn" msprop:Generator_UserColumnName="numAuth" type="xs:int" />
|
|
<xs:element name="attivo" msprop:Generator_ColumnVarNameInTable="columnattivo" msprop:Generator_ColumnPropNameInRow="attivo" msprop:Generator_ColumnPropNameInTable="attivoColumn" msprop:Generator_UserColumnName="attivo" type="xs:boolean" />
|
|
<xs:element name="CodGruppo" msprop:Generator_ColumnVarNameInTable="columnCodGruppo" msprop:Generator_ColumnPropNameInRow="CodGruppo" msprop:Generator_ColumnPropNameInTable="CodGruppoColumn" msprop:Generator_UserColumnName="CodGruppo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="resetAuthKeyReq" msprop:Generator_ColumnVarNameInTable="columnresetAuthKeyReq" msprop:Generator_ColumnPropNameInRow="resetAuthKeyReq" msprop:Generator_ColumnPropNameInTable="resetAuthKeyReqColumn" msprop:Generator_UserColumnName="resetAuthKeyReq" type="xs:boolean" />
|
|
<xs:element name="TipoUser" msprop:Generator_ColumnVarNameInTable="columnTipoUser" msprop:Generator_ColumnPropNameInRow="TipoUser" msprop:Generator_ColumnPropNameInTable="TipoUserColumn" msprop:Generator_UserColumnName="TipoUser">
|
|
<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="AssU2A" msprop:Generator_TableClassName="AssU2ADataTable" msprop:Generator_TableVarName="tableAssU2A" msprop:Generator_TablePropName="AssU2A" msprop:Generator_RowDeletingName="AssU2ARowDeleting" msprop:Generator_RowChangingName="AssU2ARowChanging" msprop:Generator_RowEvHandlerName="AssU2ARowChangeEventHandler" msprop:Generator_RowDeletedName="AssU2ARowDeleted" msprop:Generator_UserTableName="AssU2A" msprop:Generator_RowChangedName="AssU2ARowChanged" msprop:Generator_RowEvArgName="AssU2ARowChangeEvent" msprop:Generator_RowClassName="AssU2ARow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="USER_NAME" msprop:Generator_ColumnVarNameInTable="columnUSER_NAME" msprop:Generator_ColumnPropNameInRow="USER_NAME" msprop:Generator_ColumnPropNameInTable="USER_NAMEColumn" msprop:Generator_UserColumnName="USER_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxAmm" msprop:Generator_ColumnVarNameInTable="columnidxAmm" msprop:Generator_ColumnPropNameInRow="idxAmm" msprop:Generator_ColumnPropNameInTable="idxAmmColumn" msprop:Generator_UserColumnName="idxAmm" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AssU2C" msprop:Generator_TableClassName="AssU2CDataTable" msprop:Generator_TableVarName="tableAssU2C" msprop:Generator_TablePropName="AssU2C" msprop:Generator_RowDeletingName="AssU2CRowDeleting" msprop:Generator_RowChangingName="AssU2CRowChanging" msprop:Generator_RowEvHandlerName="AssU2CRowChangeEventHandler" msprop:Generator_RowDeletedName="AssU2CRowDeleted" msprop:Generator_UserTableName="AssU2C" msprop:Generator_RowChangedName="AssU2CRowChanged" msprop:Generator_RowEvArgName="AssU2CRowChangeEvent" msprop:Generator_RowClassName="AssU2CRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="USER_NAME" msprop:Generator_ColumnVarNameInTable="columnUSER_NAME" msprop:Generator_ColumnPropNameInRow="USER_NAME" msprop:Generator_ColumnPropNameInTable="USER_NAMEColumn" msprop:Generator_UserColumnName="USER_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxCond" msprop:Generator_ColumnVarNameInTable="columnidxCond" msprop:Generator_ColumnPropNameInRow="idxCond" msprop:Generator_ColumnPropNameInTable="idxCondColumn" msprop:Generator_UserColumnName="idxCond" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AssU2F" msprop:Generator_TableClassName="AssU2FDataTable" msprop:Generator_TableVarName="tableAssU2F" msprop:Generator_TablePropName="AssU2F" msprop:Generator_RowDeletingName="AssU2FRowDeleting" msprop:Generator_RowChangingName="AssU2FRowChanging" msprop:Generator_RowEvHandlerName="AssU2FRowChangeEventHandler" msprop:Generator_RowDeletedName="AssU2FRowDeleted" msprop:Generator_UserTableName="AssU2F" msprop:Generator_RowChangedName="AssU2FRowChanged" msprop:Generator_RowEvArgName="AssU2FRowChangeEvent" msprop:Generator_RowClassName="AssU2FRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="USER_NAME" msprop:Generator_ColumnVarNameInTable="columnUSER_NAME" msprop:Generator_ColumnPropNameInRow="USER_NAME" msprop:Generator_ColumnPropNameInTable="USER_NAMEColumn" msprop:Generator_UserColumnName="USER_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxFornitore" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagCondomini" msprop:Generator_TableClassName="AnagCondominiDataTable" msprop:Generator_TableVarName="tableAnagCondomini" msprop:Generator_TablePropName="AnagCondomini" msprop:Generator_RowDeletingName="AnagCondominiRowDeleting" msprop:Generator_RowChangingName="AnagCondominiRowChanging" msprop:Generator_RowEvHandlerName="AnagCondominiRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagCondominiRowDeleted" msprop:Generator_UserTableName="AnagCondomini" msprop:Generator_RowChangedName="AnagCondominiRowChanged" msprop:Generator_RowEvArgName="AnagCondominiRowChangeEvent" msprop:Generator_RowClassName="AnagCondominiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxCond" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxCond" msprop:Generator_ColumnPropNameInRow="idxCond" msprop:Generator_ColumnPropNameInTable="idxCondColumn" msprop:Generator_UserColumnName="idxCond" type="xs:int" />
|
|
<xs:element name="cod_cond" msprop:Generator_ColumnVarNameInTable="columncod_cond" msprop:Generator_ColumnPropNameInRow="cod_cond" msprop:Generator_ColumnPropNameInTable="cod_condColumn" msprop:Generator_UserColumnName="cod_cond">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</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">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="indirizzo" msprop:Generator_ColumnVarNameInTable="columnindirizzo" msprop:Generator_ColumnPropNameInRow="indirizzo" msprop:Generator_ColumnPropNameInTable="indirizzoColumn" msprop:Generator_UserColumnName="indirizzo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cap" msprop:Generator_ColumnVarNameInTable="columncap" msprop:Generator_ColumnPropNameInRow="cap" msprop:Generator_ColumnPropNameInTable="capColumn" msprop:Generator_UserColumnName="cap">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="citta" msprop:Generator_ColumnVarNameInTable="columncitta" msprop:Generator_ColumnPropNameInRow="citta" msprop:Generator_ColumnPropNameInTable="cittaColumn" msprop:Generator_UserColumnName="citta">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cod_fisc" msprop:Generator_ColumnVarNameInTable="columncod_fisc" msprop:Generator_ColumnPropNameInRow="cod_fisc" msprop:Generator_ColumnPropNameInTable="cod_fiscColumn" msprop:Generator_UserColumnName="cod_fisc">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxAmm" msprop:Generator_ColumnVarNameInTable="columnidxAmm" msprop:Generator_ColumnPropNameInRow="idxAmm" msprop:Generator_ColumnPropNameInTable="idxAmmColumn" msprop:Generator_UserColumnName="idxAmm" type="xs:int" />
|
|
<xs:element name="Attivo" msprop:Generator_ColumnVarNameInTable="columnAttivo" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_UserColumnName="Attivo" type="xs:boolean" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagAmministratori" msprop:Generator_TableClassName="AnagAmministratoriDataTable" msprop:Generator_TableVarName="tableAnagAmministratori" msprop:Generator_TablePropName="AnagAmministratori" msprop:Generator_RowDeletingName="AnagAmministratoriRowDeleting" msprop:Generator_RowChangingName="AnagAmministratoriRowChanging" msprop:Generator_RowEvHandlerName="AnagAmministratoriRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagAmministratoriRowDeleted" msprop:Generator_UserTableName="AnagAmministratori" msprop:Generator_RowChangedName="AnagAmministratoriRowChanged" msprop:Generator_RowEvArgName="AnagAmministratoriRowChangeEvent" msprop:Generator_RowClassName="AnagAmministratoriRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxAmm" msprop:Generator_ColumnVarNameInTable="columnidxAmm" msprop:Generator_ColumnPropNameInRow="idxAmm" msprop:Generator_ColumnPropNameInTable="idxAmmColumn" msprop:Generator_UserColumnName="idxAmm" type="xs:int" />
|
|
<xs:element name="RagSociale" msprop:Generator_ColumnVarNameInTable="columnRagSociale" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_UserColumnName="RagSociale">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</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">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumCondAttivi" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNumCondAttivi" msprop:Generator_ColumnPropNameInRow="NumCondAttivi" msprop:Generator_ColumnPropNameInTable="NumCondAttiviColumn" msprop:Generator_UserColumnName="NumCondAttivi" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumCond" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNumCond" msprop:Generator_ColumnPropNameInRow="NumCond" msprop:Generator_ColumnPropNameInTable="NumCondColumn" msprop:Generator_UserColumnName="NumCond" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNumRich" msprop:Generator_ColumnPropNameInRow="NumRich" msprop:Generator_ColumnPropNameInTable="NumRichColumn" msprop:Generator_UserColumnName="NumRich" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumInt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNumInt" msprop:Generator_ColumnPropNameInRow="NumInt" msprop:Generator_ColumnPropNameInTable="NumIntColumn" msprop:Generator_UserColumnName="NumInt" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ImponibileTot" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnImponibileTot" msprop:Generator_ColumnPropNameInRow="ImponibileTot" msprop:Generator_ColumnPropNameInTable="ImponibileTotColumn" msprop:Generator_UserColumnName="ImponibileTot" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="ImponibileMedio" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnImponibileMedio" msprop:Generator_ColumnPropNameInRow="ImponibileMedio" msprop:Generator_ColumnPropNameInTable="ImponibileMedioColumn" msprop:Generator_UserColumnName="ImponibileMedio" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagFornitori" msprop:Generator_TableClassName="AnagFornitoriDataTable" msprop:Generator_TableVarName="tableAnagFornitori" msprop:Generator_TablePropName="AnagFornitori" msprop:Generator_RowDeletingName="AnagFornitoriRowDeleting" msprop:Generator_RowChangingName="AnagFornitoriRowChanging" msprop:Generator_RowEvHandlerName="AnagFornitoriRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagFornitoriRowDeleted" msprop:Generator_UserTableName="AnagFornitori" msprop:Generator_RowChangedName="AnagFornitoriRowChanged" msprop:Generator_RowEvArgName="AnagFornitoriRowChangeEvent" msprop:Generator_RowClassName="AnagFornitoriRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxFornitore" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxFornitore" msprop:Generator_ColumnPropNameInRow="idxFornitore" msprop:Generator_ColumnPropNameInTable="idxFornitoreColumn" msprop:Generator_UserColumnName="idxFornitore" type="xs:int" />
|
|
<xs:element name="nome" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnPropNameInTable="nomeColumn" msprop:Generator_UserColumnName="nome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="indirizzo" msprop:Generator_ColumnVarNameInTable="columnindirizzo" msprop:Generator_ColumnPropNameInRow="indirizzo" msprop:Generator_ColumnPropNameInTable="indirizzoColumn" msprop:Generator_UserColumnName="indirizzo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="200" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="iscritta" msprop:Generator_ColumnVarNameInTable="columniscritta" msprop:Generator_ColumnPropNameInRow="iscritta" msprop:Generator_ColumnPropNameInTable="iscrittaColumn" msprop:Generator_UserColumnName="iscritta" type="xs:boolean" />
|
|
<xs:element name="attivo" msprop:Generator_ColumnVarNameInTable="columnattivo" msprop:Generator_ColumnPropNameInRow="attivo" msprop:Generator_ColumnPropNameInTable="attivoColumn" msprop:Generator_UserColumnName="attivo" type="xs:boolean" />
|
|
<xs:element name="CAP" msprop:Generator_ColumnVarNameInTable="columnCAP" msprop:Generator_ColumnPropNameInRow="CAP" msprop:Generator_ColumnPropNameInTable="CAPColumn" msprop:Generator_UserColumnName="CAP" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="citta" msprop:Generator_ColumnVarNameInTable="columncitta" msprop:Generator_ColumnPropNameInRow="citta" msprop:Generator_ColumnPropNameInTable="cittaColumn" msprop:Generator_UserColumnName="citta" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="provincia" msprop:Generator_ColumnVarNameInTable="columnprovincia" msprop:Generator_ColumnPropNameInRow="provincia" msprop:Generator_ColumnPropNameInTable="provinciaColumn" msprop:Generator_UserColumnName="provincia" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="stato" msprop:Generator_ColumnVarNameInTable="columnstato" msprop:Generator_ColumnPropNameInRow="stato" msprop:Generator_ColumnPropNameInTable="statoColumn" msprop:Generator_UserColumnName="stato" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="pIva" msprop:Generator_ColumnVarNameInTable="columnpIva" msprop:Generator_ColumnPropNameInRow="pIva" msprop:Generator_ColumnPropNameInTable="pIvaColumn" msprop:Generator_UserColumnName="pIva" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cFisc" msprop:Generator_ColumnVarNameInTable="columncFisc" msprop:Generator_ColumnPropNameInRow="cFisc" msprop:Generator_ColumnPropNameInTable="cFiscColumn" msprop:Generator_UserColumnName="cFisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</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="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="telefono" msprop:Generator_ColumnVarNameInTable="columntelefono" msprop:Generator_ColumnPropNameInRow="telefono" msprop:Generator_ColumnPropNameInTable="telefonoColumn" msprop:Generator_UserColumnName="telefono" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cellulare" msprop:Generator_ColumnVarNameInTable="columncellulare" msprop:Generator_ColumnPropNameInRow="cellulare" msprop:Generator_ColumnPropNameInTable="cellulareColumn" msprop:Generator_UserColumnName="cellulare" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cssStatoForn" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncssStatoForn" msprop:Generator_ColumnPropNameInRow="cssStatoForn" msprop:Generator_ColumnPropNameInTable="cssStatoFornColumn" msprop:Generator_UserColumnName="cssStatoForn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="12" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="quotaStd" msprop:Generator_ColumnVarNameInTable="columnquotaStd" msprop:Generator_ColumnPropNameInRow="quotaStd" msprop:Generator_ColumnPropNameInTable="quotaStdColumn" msprop:Generator_UserColumnName="quotaStd" type="xs:decimal" />
|
|
<xs:element name="noteQuota" msprop:Generator_ColumnVarNameInTable="columnnoteQuota" msprop:Generator_ColumnPropNameInRow="noteQuota" msprop:Generator_ColumnPropNameInTable="noteQuotaColumn" msprop:Generator_UserColumnName="noteQuota">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="numRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnumRich" msprop:Generator_ColumnPropNameInRow="numRich" msprop:Generator_ColumnPropNameInTable="numRichColumn" msprop:Generator_UserColumnName="numRich" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Utenti" />
|
|
<xs:field xpath="mstns:USER_NAME" />
|
|
</xs:unique>
|
|
<xs:unique name="AssU2A_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AssU2A" />
|
|
<xs:field xpath="mstns:USER_NAME" />
|
|
<xs:field xpath="mstns:idxAmm" />
|
|
</xs:unique>
|
|
<xs:unique name="AssU2C_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AssU2C" />
|
|
<xs:field xpath="mstns:USER_NAME" />
|
|
<xs:field xpath="mstns:idxCond" />
|
|
</xs:unique>
|
|
<xs:unique name="AssU2F_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AssU2F" />
|
|
<xs:field xpath="mstns:USER_NAME" />
|
|
<xs:field xpath="mstns:idxFornitore" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagCondomini_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagCondomini" />
|
|
<xs:field xpath="mstns:idxCond" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagAmministratori_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagAmministratori" />
|
|
<xs:field xpath="mstns:idxAmm" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagFornitori_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagFornitori" />
|
|
<xs:field xpath="mstns:idxFornitore" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_AssU2A_Utenti" msdata:parent="Utenti" msdata:child="AssU2A" msdata:parentkey="USER_NAME" msdata:childkey="USER_NAME" msprop:Generator_UserChildTable="AssU2A" msprop:Generator_ChildPropName="GetAssU2ARows" msprop:Generator_UserRelationName="FK_AssU2A_Utenti" msprop:Generator_ParentPropName="UtentiRow" msprop:Generator_RelationVarName="relationFK_AssU2A_Utenti" msprop:Generator_UserParentTable="Utenti" />
|
|
<msdata:Relationship name="FK_AssU2C_Utenti" msdata:parent="Utenti" msdata:child="AssU2C" msdata:parentkey="USER_NAME" msdata:childkey="USER_NAME" msprop:Generator_UserChildTable="AssU2C" msprop:Generator_ChildPropName="GetAssU2CRows" msprop:Generator_UserRelationName="FK_AssU2C_Utenti" msprop:Generator_ParentPropName="UtentiRow" msprop:Generator_RelationVarName="relationFK_AssU2C_Utenti" msprop:Generator_UserParentTable="Utenti" />
|
|
<msdata:Relationship name="FK_AssU2F_Utenti" msdata:parent="Utenti" msdata:child="AssU2F" msdata:parentkey="USER_NAME" msdata:childkey="USER_NAME" msprop:Generator_UserChildTable="AssU2F" msprop:Generator_ChildPropName="GetAssU2FRows" msprop:Generator_UserRelationName="FK_AssU2F_Utenti" msprop:Generator_ParentPropName="UtentiRow" msprop:Generator_RelationVarName="relationFK_AssU2F_Utenti" msprop:Generator_UserParentTable="Utenti" />
|
|
<msdata:Relationship name="FK_AssU2C_AnagCondomini" msdata:parent="AnagCondomini" msdata:child="AssU2C" msdata:parentkey="idxCond" msdata:childkey="idxCond" msprop:Generator_UserChildTable="AssU2C" msprop:Generator_ChildPropName="GetAssU2CRows" msprop:Generator_UserRelationName="FK_AssU2C_AnagCondomini" msprop:Generator_RelationVarName="relationFK_AssU2C_AnagCondomini" msprop:Generator_UserParentTable="AnagCondomini" msprop:Generator_ParentPropName="AnagCondominiRow" />
|
|
<msdata:Relationship name="FK_AssU2A_AnagAmministratori" msdata:parent="AnagAmministratori" msdata:child="AssU2A" msdata:parentkey="idxAmm" msdata:childkey="idxAmm" msprop:Generator_UserChildTable="AssU2A" msprop:Generator_ChildPropName="GetAssU2ARows" msprop:Generator_UserRelationName="FK_AssU2A_AnagAmministratori" msprop:Generator_RelationVarName="relationFK_AssU2A_AnagAmministratori" msprop:Generator_UserParentTable="AnagAmministratori" msprop:Generator_ParentPropName="AnagAmministratoriRow" />
|
|
<msdata:Relationship name="FK_AnagCondomini_AnagAmministratori" msdata:parent="AnagAmministratori" msdata:child="AnagCondomini" msdata:parentkey="idxAmm" msdata:childkey="idxAmm" msprop:Generator_UserChildTable="AnagCondomini" msprop:Generator_ChildPropName="GetAnagCondominiRows" msprop:Generator_UserRelationName="FK_AnagCondomini_AnagAmministratori" msprop:Generator_RelationVarName="relationFK_AnagCondomini_AnagAmministratori" msprop:Generator_UserParentTable="AnagAmministratori" msprop:Generator_ParentPropName="AnagAmministratoriRow" />
|
|
<msdata:Relationship name="FK_AssU2F_AnagFornitori" msdata:parent="AnagFornitori" msdata:child="AssU2F" msdata:parentkey="idxFornitore" msdata:childkey="idxFornitore" msprop:Generator_UserChildTable="AssU2F" msprop:Generator_ChildPropName="GetAssU2FRows" msprop:Generator_UserRelationName="FK_AssU2F_AnagFornitori" msprop:Generator_RelationVarName="relationFK_AssU2F_AnagFornitori" msprop:Generator_UserParentTable="AnagFornitori" msprop:Generator_ParentPropName="AnagFornitoriRow" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |