Egalware/SteamWare
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
fixEmptyRedisVal
SteamWare/SteamWareLib/DS_logging.xsd
T
Samuele E. Locatelli 2a1510ff43 Ricreato repository... SU GOGS
2018-03-17 09:47:02 +01:00

708 lines
90 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DS_logging" targetNamespace="http://tempuri.org/DS_logging.xsd" xmlns:mstns="http://tempuri.org/DS_logging.xsd" xmlns="http://tempuri.org/DS_logging.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="loggerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="loggerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SteamWare.Properties.Settings.GlobalReference.Default.loggerConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="T_anagFiltroTableAdapter" GeneratorDataComponentClassName="T_anagFiltroTableAdapter" Name="T_anagFiltro" UserDataComponentName="T_anagFiltroTableAdapter">
<MainSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.T_anagFiltro" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[T_anagFiltro] WHERE (([idxFiltro] = @Original_idxFiltro) AND ((@IsNull_filtro = 1 AND [filtro] IS NULL) OR ([filtro] = @Original_filtro)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_filtro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="filtro" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_filtro" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filtro" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[T_anagFiltro] ([filtro]) VALUES (@filtro);
SELECT idxFiltro, filtro FROM T_anagFiltro WHERE (idxFiltro = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filtro" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxFiltro, filtro FROM dbo.T_anagFiltro</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[T_anagFiltro] SET [filtro] = @filtro WHERE (([idxFiltro] = @Original_idxFiltro) AND ((@IsNull_filtro = 1 AND [filtro] IS NULL) OR ([filtro] = @Original_filtro)));
SELECT idxFiltro, filtro FROM T_anagFiltro WHERE (idxFiltro = @idxFiltro)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filtro" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_filtro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="filtro" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_filtro" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filtro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="idxFiltro" ColumnName="idxFiltro" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxFiltro" DataSetColumn="idxFiltro" />
<Mapping SourceColumn="filtro" DataSetColumn="filtro" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="T_logUtenteTableAdapter" GeneratorDataComponentClassName="T_logUtenteTableAdapter" Name="T_logUtente" UserDataComponentName="T_logUtenteTableAdapter">
<MainSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.T_logUtente" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[T_logUtente] WHERE (([idxNota] = @Original_idxNota) AND ((@IsNull_dataNota = 1 AND [dataNota] IS NULL) OR ([dataNota] = @Original_dataNota)) AND ((@IsNull_userNota = 1 AND [userNota] IS NULL) OR ([userNota] = @Original_userNota)) AND ((@IsNull_nota = 1 AND [nota] IS NULL) OR ([nota] = @Original_nota)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_val = 1 AND [val] IS NULL) OR ([val] = @Original_val)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataNota" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_userNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="userNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_val" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_val" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[T_logUtente] ([dataNota], [userNota], [nota], [idxFiltro], [val]) VALUES (@dataNota, @userNota, @nota, @idxFiltro, @val);
SELECT idxNota, dataNota, userNota, nota, idxFiltro, val FROM T_logUtente WHERE (idxNota = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataNota" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@val" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxNota, dataNota, userNota, nota, idxFiltro, val FROM dbo.T_logUtente</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[T_logUtente] SET [dataNota] = @dataNota, [userNota] = @userNota, [nota] = @nota, [idxFiltro] = @idxFiltro, [val] = @val WHERE (([idxNota] = @Original_idxNota) AND ((@IsNull_dataNota = 1 AND [dataNota] IS NULL) OR ([dataNota] = @Original_dataNota)) AND ((@IsNull_userNota = 1 AND [userNota] IS NULL) OR ([userNota] = @Original_userNota)) AND ((@IsNull_nota = 1 AND [nota] IS NULL) OR ([nota] = @Original_nota)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_val = 1 AND [val] IS NULL) OR ([val] = @Original_val)));
SELECT idxNota, dataNota, userNota, nota, idxFiltro, val FROM T_logUtente WHERE (idxNota = @idxNota)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataNota" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@val" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataNota" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_userNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="userNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userNota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nota" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_val" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_val" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="idxNota" ColumnName="idxNota" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxNota" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxNota" DataSetColumn="idxNota" />
<Mapping SourceColumn="dataNota" DataSetColumn="dataNota" />
<Mapping SourceColumn="userNota" DataSetColumn="userNota" />
<Mapping SourceColumn="nota" DataSetColumn="nota" />
<Mapping SourceColumn="idxFiltro" DataSetColumn="idxFiltro" />
<Mapping SourceColumn="val" DataSetColumn="val" />
</Mappings>
<Sources>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.T_logUtente" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByFiltro" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="getByFiltro" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByFiltro" UserSourceName="getByFiltro">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT T_logUtente.idxNota, T_logUtente.dataNota, T_logUtente.userNota, T_logUtente.nota, T_logUtente.idxFiltro, T_logUtente.val
FROM T_logUtente INNER JOIN
T_anagFiltro ON T_logUtente.idxFiltro = T_anagFiltro.idxFiltro
WHERE (T_anagFiltro.filtro LIKE @filtro + '%')</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="filtro" ColumnName="filtro" DataSourceName="Flamma_SC.dbo.T_anagFiltro" DataTypeServer="nvarchar(300)" DbType="String" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumn="filtro" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.sp_insLogUtFull" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_insLogUtFull" Modifier="Public" Name="sp_insLogUtFull" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_insLogUtFull">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_insLogUtFull</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@userNota" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nota" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@val" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="VarChar" Scale="0" Size="300" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="InputOutput" ParameterName="@idxNota" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_logUtenteTableAdapter" GeneratorDataComponentClassName="v_logUtenteTableAdapter" Name="v_logUtente" UserDataComponentName="v_logUtenteTableAdapter">
<MainSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.v_logUtente" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxNota, filtro, dataNota, userNota, nota, val, numRec FROM dbo.v_logUtente</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxNota" DataSetColumn="idxNota" />
<Mapping SourceColumn="filtro" DataSetColumn="filtro" />
<Mapping SourceColumn="dataNota" DataSetColumn="dataNota" />
<Mapping SourceColumn="userNota" DataSetColumn="userNota" />
<Mapping SourceColumn="nota" DataSetColumn="nota" />
<Mapping SourceColumn="val" DataSetColumn="val" />
<Mapping SourceColumn="numRec" DataSetColumn="numRec" />
</Mappings>
<Sources>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.S_v_logUtente" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByFiltro" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="getByFiltro" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByFiltro" UserSourceName="getByFiltro">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.S_v_logUtente</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="T_anagRecordTableAdapter" GeneratorDataComponentClassName="T_anagRecordTableAdapter" Name="T_anagRecord" UserDataComponentName="T_anagRecordTableAdapter">
<MainSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.T_anagRecord" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[T_anagRecord] WHERE (([idxTipoRec] = @Original_idxTipoRec) AND ((@IsNull_descrRec = 1 AND [descrRec] IS NULL) OR ([descrRec] = @Original_descrRec)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrRec" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrRec" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrRec" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[T_anagRecord] ([descrRec]) VALUES (@descrRec);
SELECT idxTipoRec, descrRec FROM T_anagRecord WHERE (idxTipoRec = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrRec" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrRec" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxTipoRec, descrRec FROM dbo.T_anagRecord</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[T_anagRecord] SET [descrRec] = @descrRec WHERE (([idxTipoRec] = @Original_idxTipoRec) AND ((@IsNull_descrRec = 1 AND [descrRec] IS NULL) OR ([descrRec] = @Original_descrRec)));
SELECT idxTipoRec, descrRec FROM T_anagRecord WHERE (idxTipoRec = @idxTipoRec)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrRec" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrRec" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrRec" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrRec" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrRec" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="idxTipoRec" ColumnName="idxTipoRec" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxTipoRec" DataSetColumn="idxTipoRec" />
<Mapping SourceColumn="descrRec" DataSetColumn="descrRec" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="T_logRecordsTableAdapter" GeneratorDataComponentClassName="T_logRecordsTableAdapter" Name="T_logRecords" UserDataComponentName="T_logRecordsTableAdapter">
<MainSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.T_logRecords" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[T_logRecords] WHERE (([idxRecord] = @Original_idxRecord) AND ([dataOra] = @Original_dataOra) AND ([userEv] = @Original_userEv) AND ((@IsNull_pagina = 1 AND [pagina] IS NULL) OR ([pagina] = @Original_pagina)) AND ((@IsNull_idxTipoRec = 1 AND [idxTipoRec] IS NULL) OR ([idxTipoRec] = @Original_idxTipoRec)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_valOrig = 1 AND [valOrig] IS NULL) OR ([valOrig] = @Original_valOrig)) AND ((@IsNull_valNew = 1 AND [valNew] IS NULL) OR ([valNew] = @Original_valNew)) AND ((@IsNull_idxNota = 1 AND [idxNota] IS NULL) OR ([idxNota] = @Original_idxNota)) AND ((@IsNull_cestinato = 1 AND [cestinato] IS NULL) OR ([cestinato] = @Original_cestinato)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxRecord" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxRecord" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataOra" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataOra" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userEv" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pagina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pagina" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pagina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pagina" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valOrig" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valOrig" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valOrig" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valNew" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valNew" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valNew" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valNew" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cestinato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cestinato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_cestinato" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="cestinato" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[T_logRecords] ([dataOra], [userEv], [pagina], [idxTipoRec], [idxFiltro], [valOrig], [valNew], [idxNota], [cestinato]) VALUES (@dataOra, @userEv, @pagina, @idxTipoRec, @idxFiltro, @valOrig, @valNew, @idxNota, @cestinato);
SELECT idxRecord, dataOra, userEv, pagina, idxTipoRec, idxFiltro, valOrig, valNew, idxNota, cestinato FROM T_logRecords WHERE (idxRecord = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataOra" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataOra" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userEv" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pagina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pagina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valOrig" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valNew" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valNew" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@cestinato" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="cestinato" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT * FROM dbo.T_logRecords</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[T_logRecords] SET [dataOra] = @dataOra, [userEv] = @userEv, [pagina] = @pagina, [idxTipoRec] = @idxTipoRec, [idxFiltro] = @idxFiltro, [valOrig] = @valOrig, [valNew] = @valNew, [idxNota] = @idxNota, [cestinato] = @cestinato WHERE (([idxRecord] = @Original_idxRecord) AND ([dataOra] = @Original_dataOra) AND ([userEv] = @Original_userEv) AND ((@IsNull_pagina = 1 AND [pagina] IS NULL) OR ([pagina] = @Original_pagina)) AND ((@IsNull_idxTipoRec = 1 AND [idxTipoRec] IS NULL) OR ([idxTipoRec] = @Original_idxTipoRec)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_valOrig = 1 AND [valOrig] IS NULL) OR ([valOrig] = @Original_valOrig)) AND ((@IsNull_valNew = 1 AND [valNew] IS NULL) OR ([valNew] = @Original_valNew)) AND ((@IsNull_idxNota = 1 AND [idxNota] IS NULL) OR ([idxNota] = @Original_idxNota)) AND ((@IsNull_cestinato = 1 AND [cestinato] IS NULL) OR ([cestinato] = @Original_cestinato)));
SELECT idxRecord, dataOra, userEv, pagina, idxTipoRec, idxFiltro, valOrig, valNew, idxNota, cestinato FROM T_logRecords WHERE (idxRecord = @idxRecord)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataOra" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataOra" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userEv" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pagina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pagina" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valOrig" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valNew" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valNew" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@cestinato" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="cestinato" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxRecord" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxRecord" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataOra" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataOra" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userEv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userEv" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pagina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pagina" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pagina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pagina" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxTipoRec" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxTipoRec" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxFiltro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxFiltro" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valOrig" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valOrig" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valOrig" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valOrig" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valNew" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valNew" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valNew" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valNew" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxNota" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxNota" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cestinato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cestinato" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_cestinato" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="cestinato" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="idxRecord" ColumnName="idxRecord" DataSourceName="Flamma_SC.dbo.T_logRecords" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxRecord" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxRecord" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="dataOra" DataSetColumn="dataOra" />
<Mapping SourceColumn="userEv" DataSetColumn="userEv" />
<Mapping SourceColumn="pagina" DataSetColumn="pagina" />
<Mapping SourceColumn="idxTipoRec" DataSetColumn="idxTipoRec" />
<Mapping SourceColumn="idxFiltro" DataSetColumn="idxFiltro" />
<Mapping SourceColumn="valOrig" DataSetColumn="valOrig" />
<Mapping SourceColumn="valNew" DataSetColumn="valNew" />
<Mapping SourceColumn="idxNota" DataSetColumn="idxNota" />
<Mapping SourceColumn="cestinato" DataSetColumn="cestinato" />
<Mapping SourceColumn="idxRecord" DataSetColumn="idxRecord" />
</Mappings>
<Sources>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.sp_cestinaLogRecFiltro" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_cestinaLogRecFiltro" Modifier="Public" Name="sp_cestinaLogRecFiltro" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_cestinaLogRecFiltro">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_cestinaLogRecFiltro</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.sp_cestinaLogRecUt" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_cestinaLogRecUt" Modifier="Public" Name="sp_cestinaLogRecUt" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="sp_cestinaLogRecUt">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_cestinaLogRecUt</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@userEv" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.sp_deleteLogMaxData" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_deleteLogMaxData" Modifier="Public" Name="sp_deleteLogMaxData" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="sp_deleteLogMaxData">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_deleteLogMaxData</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataMax" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.sp_deleteLogUser" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_deleteLogUser" Modifier="Public" Name="sp_deleteLogUser" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="sp_deleteLogUser">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_deleteLogUser</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@userEv" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="logger.dbo.sp_insRecFull" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_insRecFull" Modifier="Public" Name="sp_insRecFull" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="sp_insRecFull">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_insRecFull</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@userEv" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pagina" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@valOrig" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@valNew" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@evento" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="VarChar" Scale="0" Size="300" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.sp_setLastRec2nota" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_setLastRec2nota" Modifier="Public" Name="sp_setLastRec2nota" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="sp_setLastRec2nota">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_setLastRec2nota</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="VarChar" Scale="0" Size="300" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxNota" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.sp_setRec2nota" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_setRec2nota" Modifier="Public" Name="sp_setRec2nota" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="sp_setRec2nota">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.sp_setRec2nota</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxRecord" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idxNota" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_logRecordsTableAdapter" GeneratorDataComponentClassName="v_logRecordsTableAdapter" Name="v_logRecords" UserDataComponentName="v_logRecordsTableAdapter">
<MainSource>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.v_logRecords" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idxRecord, dataOra, userEv, SIGLA, pagina, descrRec, filtro, valOrig, valNew, idxNota, cestinato FROM dbo.v_logRecords</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idxRecord" DataSetColumn="idxRecord" />
<Mapping SourceColumn="dataOra" DataSetColumn="dataOra" />
<Mapping SourceColumn="userEv" DataSetColumn="userEv" />
<Mapping SourceColumn="SIGLA" DataSetColumn="SIGLA" />
<Mapping SourceColumn="pagina" DataSetColumn="pagina" />
<Mapping SourceColumn="descrRec" DataSetColumn="descrRec" />
<Mapping SourceColumn="filtro" DataSetColumn="filtro" />
<Mapping SourceColumn="valOrig" DataSetColumn="valOrig" />
<Mapping SourceColumn="valNew" DataSetColumn="valNew" />
<Mapping SourceColumn="idxNota" DataSetColumn="idxNota" />
<Mapping SourceColumn="cestinato" DataSetColumn="cestinato" />
</Mappings>
<Sources>
<DbSource ConnectionRef="loggerConnectionString (Settings)" DbObjectName="Flamma_SC.dbo.S_v_logRecords" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByFiltro" GetMethodModifier="Public" GetMethodName="getByFiltro" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByFiltro" UserSourceName="getByFiltro">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.S_v_logRecords</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@filtro" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DS_logging" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DS_logging" msprop:Generator_DataSetName="DS_logging">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="T_anagFiltro" msprop:Generator_UserTableName="T_anagFiltro" msprop:Generator_RowDeletedName="T_anagFiltroRowDeleted" msprop:Generator_RowChangedName="T_anagFiltroRowChanged" msprop:Generator_RowClassName="T_anagFiltroRow" msprop:Generator_RowChangingName="T_anagFiltroRowChanging" msprop:Generator_RowEvArgName="T_anagFiltroRowChangeEvent" msprop:Generator_RowEvHandlerName="T_anagFiltroRowChangeEventHandler" msprop:Generator_TableClassName="T_anagFiltroDataTable" msprop:Generator_TableVarName="tableT_anagFiltro" msprop:Generator_RowDeletingName="T_anagFiltroRowDeleting" msprop:Generator_TablePropName="T_anagFiltro">
<xs:complexType>
<xs:sequence>
<xs:element name="idxFiltro" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="idxFiltro" msprop:Generator_ColumnPropNameInRow="idxFiltro" msprop:Generator_ColumnVarNameInTable="columnidxFiltro" msprop:Generator_ColumnPropNameInTable="idxFiltroColumn" type="xs:int" />
<xs:element name="filtro" msprop:Generator_UserColumnName="filtro" msprop:Generator_ColumnPropNameInRow="filtro" msprop:Generator_ColumnVarNameInTable="columnfiltro" msprop:Generator_ColumnPropNameInTable="filtroColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="T_logUtente" msprop:Generator_UserTableName="T_logUtente" msprop:Generator_RowDeletedName="T_logUtenteRowDeleted" msprop:Generator_RowChangedName="T_logUtenteRowChanged" msprop:Generator_RowClassName="T_logUtenteRow" msprop:Generator_RowChangingName="T_logUtenteRowChanging" msprop:Generator_RowEvArgName="T_logUtenteRowChangeEvent" msprop:Generator_RowEvHandlerName="T_logUtenteRowChangeEventHandler" msprop:Generator_TableClassName="T_logUtenteDataTable" msprop:Generator_TableVarName="tableT_logUtente" msprop:Generator_RowDeletingName="T_logUtenteRowDeleting" msprop:Generator_TablePropName="T_logUtente">
<xs:complexType>
<xs:sequence>
<xs:element name="idxNota" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="idxNota" msprop:Generator_ColumnVarNameInTable="columnidxNota" msprop:Generator_ColumnPropNameInRow="idxNota" msprop:Generator_ColumnPropNameInTable="idxNotaColumn" type="xs:int" />
<xs:element name="dataNota" msprop:Generator_UserColumnName="dataNota" msprop:Generator_ColumnVarNameInTable="columndataNota" msprop:Generator_ColumnPropNameInRow="dataNota" msprop:Generator_ColumnPropNameInTable="dataNotaColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="userNota" msprop:Generator_UserColumnName="userNota" msprop:Generator_ColumnVarNameInTable="columnuserNota" msprop:Generator_ColumnPropNameInRow="userNota" msprop:Generator_ColumnPropNameInTable="userNotaColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nota" msprop:Generator_UserColumnName="nota" msprop:Generator_ColumnVarNameInTable="columnnota" msprop:Generator_ColumnPropNameInRow="nota" msprop:Generator_ColumnPropNameInTable="notaColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxFiltro" msprop:Generator_UserColumnName="idxFiltro" msprop:Generator_ColumnVarNameInTable="columnidxFiltro" msprop:Generator_ColumnPropNameInRow="idxFiltro" msprop:Generator_ColumnPropNameInTable="idxFiltroColumn" type="xs:int" minOccurs="0" />
<xs:element name="val" msprop:Generator_UserColumnName="val" msprop:Generator_ColumnVarNameInTable="columnval" msprop:Generator_ColumnPropNameInRow="val" msprop:Generator_ColumnPropNameInTable="valColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="v_logUtente" msprop:Generator_UserTableName="v_logUtente" msprop:Generator_RowDeletedName="v_logUtenteRowDeleted" msprop:Generator_RowChangedName="v_logUtenteRowChanged" msprop:Generator_RowClassName="v_logUtenteRow" msprop:Generator_RowChangingName="v_logUtenteRowChanging" msprop:Generator_RowEvArgName="v_logUtenteRowChangeEvent" msprop:Generator_RowEvHandlerName="v_logUtenteRowChangeEventHandler" msprop:Generator_TableClassName="v_logUtenteDataTable" msprop:Generator_TableVarName="tablev_logUtente" msprop:Generator_RowDeletingName="v_logUtenteRowDeleting" msprop:Generator_TablePropName="v_logUtente">
<xs:complexType>
<xs:sequence>
<xs:element name="idxNota" msprop:Generator_UserColumnName="idxNota" msprop:Generator_ColumnVarNameInTable="columnidxNota" msprop:Generator_ColumnPropNameInRow="idxNota" msprop:Generator_ColumnPropNameInTable="idxNotaColumn" type="xs:int" />
<xs:element name="filtro" msdata:ReadOnly="true" msprop:Generator_UserColumnName="filtro" msprop:Generator_ColumnVarNameInTable="columnfiltro" msprop:Generator_ColumnPropNameInRow="filtro" msprop:Generator_ColumnPropNameInTable="filtroColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dataNota" msprop:Generator_UserColumnName="dataNota" msprop:Generator_ColumnVarNameInTable="columndataNota" msprop:Generator_ColumnPropNameInRow="dataNota" msprop:Generator_ColumnPropNameInTable="dataNotaColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="userNota" msprop:Generator_UserColumnName="userNota" msprop:Generator_ColumnVarNameInTable="columnuserNota" msprop:Generator_ColumnPropNameInRow="userNota" msprop:Generator_ColumnPropNameInTable="userNotaColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="nota" msprop:Generator_UserColumnName="nota" msprop:Generator_ColumnVarNameInTable="columnnota" msprop:Generator_ColumnPropNameInRow="nota" msprop:Generator_ColumnPropNameInTable="notaColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="val" msprop:Generator_UserColumnName="val" msprop:Generator_ColumnVarNameInTable="columnval" msprop:Generator_ColumnPropNameInRow="val" msprop:Generator_ColumnPropNameInTable="valColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="numRec" msprop:Generator_UserColumnName="numRec" msprop:Generator_ColumnVarNameInTable="columnnumRec" msprop:Generator_ColumnPropNameInRow="numRec" msprop:Generator_ColumnPropNameInTable="numRecColumn" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="T_anagRecord" msprop:Generator_UserTableName="T_anagRecord" msprop:Generator_RowDeletedName="T_anagRecordRowDeleted" msprop:Generator_RowChangedName="T_anagRecordRowChanged" msprop:Generator_RowClassName="T_anagRecordRow" msprop:Generator_RowChangingName="T_anagRecordRowChanging" msprop:Generator_RowEvArgName="T_anagRecordRowChangeEvent" msprop:Generator_RowEvHandlerName="T_anagRecordRowChangeEventHandler" msprop:Generator_TableClassName="T_anagRecordDataTable" msprop:Generator_TableVarName="tableT_anagRecord" msprop:Generator_RowDeletingName="T_anagRecordRowDeleting" msprop:Generator_TablePropName="T_anagRecord">
<xs:complexType>
<xs:sequence>
<xs:element name="idxTipoRec" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="idxTipoRec" msprop:Generator_ColumnVarNameInTable="columnidxTipoRec" msprop:Generator_ColumnPropNameInRow="idxTipoRec" msprop:Generator_ColumnPropNameInTable="idxTipoRecColumn" type="xs:int" />
<xs:element name="descrRec" msprop:Generator_UserColumnName="descrRec" msprop:Generator_ColumnVarNameInTable="columndescrRec" msprop:Generator_ColumnPropNameInRow="descrRec" msprop:Generator_ColumnPropNameInTable="descrRecColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="T_logRecords" msprop:Generator_UserTableName="T_logRecords" msprop:Generator_RowDeletedName="T_logRecordsRowDeleted" msprop:Generator_RowChangedName="T_logRecordsRowChanged" msprop:Generator_RowClassName="T_logRecordsRow" msprop:Generator_RowChangingName="T_logRecordsRowChanging" msprop:Generator_RowEvArgName="T_logRecordsRowChangeEvent" msprop:Generator_RowEvHandlerName="T_logRecordsRowChangeEventHandler" msprop:Generator_TableClassName="T_logRecordsDataTable" msprop:Generator_TableVarName="tableT_logRecords" msprop:Generator_RowDeletingName="T_logRecordsRowDeleting" msprop:Generator_TablePropName="T_logRecords">
<xs:complexType>
<xs:sequence>
<xs:element name="dataOra" msprop:Generator_UserColumnName="dataOra" msprop:Generator_ColumnVarNameInTable="columndataOra" msprop:Generator_ColumnPropNameInRow="dataOra" msprop:Generator_ColumnPropNameInTable="dataOraColumn" type="xs:dateTime" />
<xs:element name="userEv" msprop:Generator_UserColumnName="userEv" msprop:Generator_ColumnVarNameInTable="columnuserEv" msprop:Generator_ColumnPropNameInRow="userEv" msprop:Generator_ColumnPropNameInTable="userEvColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="pagina" msprop:Generator_UserColumnName="pagina" msprop:Generator_ColumnVarNameInTable="columnpagina" msprop:Generator_ColumnPropNameInRow="pagina" msprop:Generator_ColumnPropNameInTable="paginaColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxTipoRec" msprop:Generator_UserColumnName="idxTipoRec" msprop:Generator_ColumnVarNameInTable="columnidxTipoRec" msprop:Generator_ColumnPropNameInRow="idxTipoRec" msprop:Generator_ColumnPropNameInTable="idxTipoRecColumn" type="xs:int" minOccurs="0" />
<xs:element name="idxFiltro" msprop:Generator_UserColumnName="idxFiltro" msprop:Generator_ColumnVarNameInTable="columnidxFiltro" msprop:Generator_ColumnPropNameInRow="idxFiltro" msprop:Generator_ColumnPropNameInTable="idxFiltroColumn" type="xs:int" minOccurs="0" />
<xs:element name="valOrig" msprop:Generator_UserColumnName="valOrig" msprop:Generator_ColumnVarNameInTable="columnvalOrig" msprop:Generator_ColumnPropNameInRow="valOrig" msprop:Generator_ColumnPropNameInTable="valOrigColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="valNew" msprop:Generator_UserColumnName="valNew" msprop:Generator_ColumnVarNameInTable="columnvalNew" msprop:Generator_ColumnPropNameInRow="valNew" msprop:Generator_ColumnPropNameInTable="valNewColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxNota" msprop:Generator_UserColumnName="idxNota" msprop:Generator_ColumnVarNameInTable="columnidxNota" msprop:Generator_ColumnPropNameInRow="idxNota" msprop:Generator_ColumnPropNameInTable="idxNotaColumn" type="xs:int" minOccurs="0" />
<xs:element name="cestinato" msprop:Generator_UserColumnName="cestinato" msprop:Generator_ColumnVarNameInTable="columncestinato" msprop:Generator_ColumnPropNameInRow="cestinato" msprop:Generator_ColumnPropNameInTable="cestinatoColumn" type="xs:boolean" minOccurs="0" />
<xs:element name="idxRecord" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="idxRecord" msprop:Generator_ColumnVarNameInTable="columnidxRecord" msprop:Generator_ColumnPropNameInRow="idxRecord" msprop:Generator_ColumnPropNameInTable="idxRecordColumn" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="v_logRecords" msprop:Generator_UserTableName="v_logRecords" msprop:Generator_RowDeletedName="v_logRecordsRowDeleted" msprop:Generator_RowChangedName="v_logRecordsRowChanged" msprop:Generator_RowClassName="v_logRecordsRow" msprop:Generator_RowChangingName="v_logRecordsRowChanging" msprop:Generator_RowEvArgName="v_logRecordsRowChangeEvent" msprop:Generator_RowEvHandlerName="v_logRecordsRowChangeEventHandler" msprop:Generator_TableClassName="v_logRecordsDataTable" msprop:Generator_TableVarName="tablev_logRecords" msprop:Generator_RowDeletingName="v_logRecordsRowDeleting" msprop:Generator_TablePropName="v_logRecords">
<xs:complexType>
<xs:sequence>
<xs:element name="idxRecord" msprop:Generator_UserColumnName="idxRecord" msprop:Generator_ColumnVarNameInTable="columnidxRecord" msprop:Generator_ColumnPropNameInRow="idxRecord" msprop:Generator_ColumnPropNameInTable="idxRecordColumn" type="xs:int" />
<xs:element name="dataOra" msprop:Generator_UserColumnName="dataOra" msprop:Generator_ColumnVarNameInTable="columndataOra" msprop:Generator_ColumnPropNameInRow="dataOra" msprop:Generator_ColumnPropNameInTable="dataOraColumn" type="xs:dateTime" />
<xs:element name="userEv" msprop:Generator_UserColumnName="userEv" msprop:Generator_ColumnVarNameInTable="columnuserEv" msprop:Generator_ColumnPropNameInRow="userEv" msprop:Generator_ColumnPropNameInTable="userEvColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SIGLA" msprop:Generator_UserColumnName="SIGLA" msprop:Generator_ColumnVarNameInTable="columnSIGLA" msprop:Generator_ColumnPropNameInRow="SIGLA" msprop:Generator_ColumnPropNameInTable="SIGLAColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="pagina" msprop:Generator_UserColumnName="pagina" msprop:Generator_ColumnVarNameInTable="columnpagina" msprop:Generator_ColumnPropNameInRow="pagina" msprop:Generator_ColumnPropNameInTable="paginaColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="descrRec" msprop:Generator_UserColumnName="descrRec" msprop:Generator_ColumnVarNameInTable="columndescrRec" msprop:Generator_ColumnPropNameInRow="descrRec" msprop:Generator_ColumnPropNameInTable="descrRecColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="filtro" msprop:Generator_UserColumnName="filtro" msprop:Generator_ColumnVarNameInTable="columnfiltro" msprop:Generator_ColumnPropNameInRow="filtro" msprop:Generator_ColumnPropNameInTable="filtroColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="300" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="valOrig" msprop:Generator_UserColumnName="valOrig" msprop:Generator_ColumnVarNameInTable="columnvalOrig" msprop:Generator_ColumnPropNameInRow="valOrig" msprop:Generator_ColumnPropNameInTable="valOrigColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="valNew" msprop:Generator_UserColumnName="valNew" msprop:Generator_ColumnVarNameInTable="columnvalNew" msprop:Generator_ColumnPropNameInRow="valNew" msprop:Generator_ColumnPropNameInTable="valNewColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idxNota" msprop:Generator_UserColumnName="idxNota" msprop:Generator_ColumnVarNameInTable="columnidxNota" msprop:Generator_ColumnPropNameInRow="idxNota" msprop:Generator_ColumnPropNameInTable="idxNotaColumn" type="xs:int" minOccurs="0" />
<xs:element name="cestinato" msprop:Generator_UserColumnName="cestinato" msprop:Generator_ColumnVarNameInTable="columncestinato" msprop:Generator_ColumnPropNameInRow="cestinato" msprop:Generator_ColumnPropNameInTable="cestinatoColumn" type="xs:boolean" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:T_anagFiltro" />
<xs:field xpath="mstns:idxFiltro" />
</xs:unique>
<xs:unique name="T_logUtente_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:T_logUtente" />
<xs:field xpath="mstns:idxNota" />
</xs:unique>
<xs:unique name="v_logUtente_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:v_logUtente" />
<xs:field xpath="mstns:idxNota" />
</xs:unique>
<xs:unique name="T_anagRecord_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:T_anagRecord" />
<xs:field xpath="mstns:idxTipoRec" />
</xs:unique>
<xs:unique name="T_logRecords_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:T_logRecords" />
<xs:field xpath="mstns:idxRecord" />
</xs:unique>
<xs:unique name="v_logRecords_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:v_logRecords" />
<xs:field xpath="mstns:idxRecord" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="FK_T_logEventi_T_logUtente1" msdata:parent="T_logUtente" msdata:child="T_logRecords" msdata:parentkey="idxNota" msdata:childkey="idxNota" msprop:Generator_UserRelationName="FK_T_logEventi_T_logUtente1" msprop:Generator_RelationVarName="relationFK_T_logEventi_T_logUtente1" msprop:Generator_UserChildTable="T_logRecords" msprop:Generator_UserParentTable="T_logUtente" msprop:Generator_ParentPropName="T_logUtenteRow" msprop:Generator_ChildPropName="_GetT_logRecordsRows" />
<msdata:Relationship name="FK_T_logRecords_T_anagFiltro1" msdata:parent="T_anagFiltro" msdata:child="T_logRecords" msdata:parentkey="idxFiltro" msdata:childkey="idxFiltro" msprop:Generator_UserRelationName="FK_T_logRecords_T_anagFiltro1" msprop:Generator_RelationVarName="relationFK_T_logRecords_T_anagFiltro1" msprop:Generator_UserChildTable="T_logRecords" msprop:Generator_UserParentTable="T_anagFiltro" msprop:Generator_ParentPropName="T_anagFiltroRow" msprop:Generator_ChildPropName="GetT_logRecordsRows" />
<msdata:Relationship name="FK_T_logRecords_T_angrRecord1" msdata:parent="T_anagRecord" msdata:child="T_logRecords" msdata:parentkey="idxTipoRec" msdata:childkey="idxTipoRec" msprop:Generator_UserRelationName="FK_T_logRecords_T_angrRecord1" msprop:Generator_RelationVarName="relationFK_T_logRecords_T_angrRecord1" msprop:Generator_UserChildTable="T_logRecords" msprop:Generator_UserParentTable="T_anagRecord" msprop:Generator_ParentPropName="T_anagRecordRow" msprop:Generator_ChildPropName="_GetT_logRecordsRows" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
Reference in New Issue View Git Blame Copy Permalink