Samuele E. Locatelli
469 lines
57 KiB
XML
469 lines
57 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_SM" targetNamespace="http://tempuri.org/DS_SM.xsd" xmlns:mstns="http://tempuri.org/DS_SM.xsd" xmlns="http://tempuri.org/DS_SM.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="GMWConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GMWConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GMW_data.Properties.Settings.GlobalReference.Default.GMWConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DelibereTableAdapter" GeneratorDataComponentClassName="DelibereTableAdapter" Name="Delibere" UserDataComponentName="DelibereTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.Delibere" 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].[Delibere] WHERE (([CodTipoDelibera] = @Original_CodTipoDelibera) AND ([UDC] = @Original_UDC) AND ([DataDelibera] = @Original_DataDelibera) AND ([CodSoggetto] = @Original_CodSoggetto))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDelibera" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodSoggetto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodSoggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Delibere] ([CodTipoDelibera], [UDC], [DataDelibera], [CodSoggetto]) VALUES (@CodTipoDelibera, @UDC, @DataDelibera, @CodSoggetto);
|
|
SELECT CodTipoDelibera, UDC, DataDelibera, CodSoggetto FROM Delibere WHERE (CodTipoDelibera = @CodTipoDelibera) AND (UDC = @UDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDelibera" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodSoggetto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodSoggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodTipoDelibera, UDC, DataDelibera, CodSoggetto FROM dbo.Delibere</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Delibere] SET [CodTipoDelibera] = @CodTipoDelibera, [UDC] = @UDC, [DataDelibera] = @DataDelibera, [CodSoggetto] = @CodSoggetto WHERE (([CodTipoDelibera] = @Original_CodTipoDelibera) AND ([UDC] = @Original_UDC) AND ([DataDelibera] = @Original_DataDelibera) AND ([CodSoggetto] = @Original_CodSoggetto));
|
|
SELECT CodTipoDelibera, UDC, DataDelibera, CodSoggetto FROM Delibere WHERE (CodTipoDelibera = @CodTipoDelibera) AND (UDC = @UDC)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataDelibera" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodSoggetto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodSoggetto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UDC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UDC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataDelibera" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodSoggetto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodSoggetto" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodTipoDelibera" DataSetColumn="CodTipoDelibera" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="DataDelibera" DataSetColumn="DataDelibera" />
|
|
<Mapping SourceColumn="CodSoggetto" DataSetColumn="CodSoggetto" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagTipoEventoTableAdapter" GeneratorDataComponentClassName="AnagTipoEventoTableAdapter" Name="AnagTipoEvento" UserDataComponentName="AnagTipoEventoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagTipoEvento" 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].[AnagTipoEvento] WHERE (([CodEvento] = @Original_CodEvento) AND ((@IsNull_DescEvento = 1 AND [DescEvento] IS NULL) OR ([DescEvento] = @Original_DescEvento)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagTipoEvento] ([CodEvento], [DescEvento]) VALUES (@CodEvento, @DescEvento);
|
|
SELECT CodEvento, DescEvento FROM AnagTipoEvento WHERE (CodEvento = @CodEvento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodEvento, DescEvento FROM dbo.AnagTipoEvento</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagTipoEvento] SET [CodEvento] = @CodEvento, [DescEvento] = @DescEvento WHERE (([CodEvento] = @Original_CodEvento) AND ((@IsNull_DescEvento = 1 AND [DescEvento] IS NULL) OR ([DescEvento] = @Original_DescEvento)));
|
|
SELECT CodEvento, DescEvento FROM AnagTipoEvento WHERE (CodEvento = @CodEvento)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
|
|
<Mapping SourceColumn="DescEvento" DataSetColumn="DescEvento" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TabTranPosizEventiTableAdapter" GeneratorDataComponentClassName="TabTranPosizEventiTableAdapter" Name="TabTranPosizEventi" UserDataComponentName="TabTranPosizEventiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.TabTranPosizEventi" 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 [TabTranPosizEventi] WHERE (([CodEvento] = @Original_CodEvento) AND ([IdxPosizione] = @Original_IdxPosizione) AND ((@IsNull_IdxPosizioneTo = 1 AND [IdxPosizioneTo] IS NULL) OR ([IdxPosizioneTo] = @Original_IdxPosizioneTo)) AND ((@IsNull_IdxBloccoTo = 1 AND [IdxBloccoTo] IS NULL) OR ([IdxBloccoTo] = @Original_IdxBloccoTo)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxPosizioneTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizioneTo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPosizioneTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizioneTo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxBloccoTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxBloccoTo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxBloccoTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxBloccoTo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [TabTranPosizEventi] ([CodEvento], [IdxPosizione], [IdxPosizioneTo], [IdxBloccoTo]) VALUES (@CodEvento, @IdxPosizione, @IdxPosizioneTo, @IdxBloccoTo);
|
|
SELECT CodEvento, IdxPosizione, IdxPosizioneTo, IdxBloccoTo FROM TabTranPosizEventi WHERE (CodEvento = @CodEvento) AND (IdxPosizione = @IdxPosizione)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxPosizioneTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizioneTo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxBloccoTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxBloccoTo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT CodEvento, IdxPosizione, IdxPosizioneTo, IdxBloccoTo FROM TabTranPosizEventi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [TabTranPosizEventi] SET [CodEvento] = @CodEvento, [IdxPosizione] = @IdxPosizione, [IdxPosizioneTo] = @IdxPosizioneTo, [IdxBloccoTo] = @IdxBloccoTo WHERE (([CodEvento] = @Original_CodEvento) AND ([IdxPosizione] = @Original_IdxPosizione) AND ((@IsNull_IdxPosizioneTo = 1 AND [IdxPosizioneTo] IS NULL) OR ([IdxPosizioneTo] = @Original_IdxPosizioneTo)) AND ((@IsNull_IdxBloccoTo = 1 AND [IdxBloccoTo] IS NULL) OR ([IdxBloccoTo] = @Original_IdxBloccoTo)));
|
|
SELECT CodEvento, IdxPosizione, IdxPosizioneTo, IdxBloccoTo FROM TabTranPosizEventi WHERE (CodEvento = @CodEvento) AND (IdxPosizione = @IdxPosizione)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxPosizioneTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizioneTo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxBloccoTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxBloccoTo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxPosizioneTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizioneTo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPosizioneTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizioneTo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdxBloccoTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxBloccoTo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxBloccoTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxBloccoTo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
|
|
<Mapping SourceColumn="IdxPosizione" DataSetColumn="IdxPosizione" />
|
|
<Mapping SourceColumn="IdxPosizioneTo" DataSetColumn="IdxPosizioneTo" />
|
|
<Mapping SourceColumn="IdxBloccoTo" DataSetColumn="IdxBloccoTo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMW.dbo.stp_TTPE_getByCodEvento" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByEvento" GetMethodModifier="Public" GetMethodName="getByEvento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByEvento" UserSourceName="getByEvento">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_TTPE_getByCodEvento</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="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.stp_TTPE_getByCodEventoPosizione" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByEventoPosizione" GetMethodModifier="Public" GetMethodName="getByEventoPosizione" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByEventoPosizione" UserSourceName="getByEventoPosizione">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_TTPE_getByCodEventoPosizione</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="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxPosizione" 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="AnagPosizioniTableAdapter" GeneratorDataComponentClassName="AnagPosizioniTableAdapter" Name="AnagPosizioni" UserDataComponentName="AnagPosizioniTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagPosizioni" 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].[AnagPosizioni] WHERE (([IdxPosizione] = @Original_IdxPosizione) AND ((@IsNull_DescPosizione = 1 AND [DescPosizione] IS NULL) OR ([DescPosizione] = @Original_DescPosizione)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescPosizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescPosizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescPosizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagPosizioni] ([IdxPosizione], [DescPosizione]) VALUES (@IdxPosizione, @DescPosizione);
|
|
SELECT IdxPosizione, DescPosizione FROM AnagPosizioni WHERE (IdxPosizione = @IdxPosizione)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescPosizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescPosizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT IdxPosizione, DescPosizione FROM dbo.AnagPosizioni</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagPosizioni] SET [IdxPosizione] = @IdxPosizione, [DescPosizione] = @DescPosizione WHERE (([IdxPosizione] = @Original_IdxPosizione) AND ((@IsNull_DescPosizione = 1 AND [DescPosizione] IS NULL) OR ([DescPosizione] = @Original_DescPosizione)));
|
|
SELECT IdxPosizione, DescPosizione FROM AnagPosizioni WHERE (IdxPosizione = @IdxPosizione)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescPosizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescPosizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPosizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescPosizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescPosizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescPosizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescPosizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxPosizione" DataSetColumn="IdxPosizione" />
|
|
<Mapping SourceColumn="DescPosizione" DataSetColumn="DescPosizione" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagTipoDelibereTableAdapter" GeneratorDataComponentClassName="AnagTipoDelibereTableAdapter" Name="AnagTipoDelibere" UserDataComponentName="AnagTipoDelibereTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="GMW.dbo.AnagTipoDelibere" 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].[AnagTipoDelibere] WHERE (([CodTipoDelibera] = @Original_CodTipoDelibera) AND ((@IsNull_DescDelibera = 1 AND [DescDelibera] IS NULL) OR ([DescDelibera] = @Original_DescDelibera)) AND ((@IsNull_CodEvento = 1 AND [CodEvento] IS NULL) OR ([CodEvento] = @Original_CodEvento)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescDelibera" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescDelibera" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagTipoDelibere] ([CodTipoDelibera], [DescDelibera], [CodEvento]) VALUES (@CodTipoDelibera, @DescDelibera, @CodEvento);
|
|
SELECT CodTipoDelibera, DescDelibera, CodEvento FROM AnagTipoDelibere WHERE (CodTipoDelibera = @CodTipoDelibera)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CodTipoDelibera, DescDelibera, CodEvento FROM dbo.AnagTipoDelibere</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagTipoDelibere] SET [CodTipoDelibera] = @CodTipoDelibera, [DescDelibera] = @DescDelibera, [CodEvento] = @CodEvento WHERE (([CodTipoDelibera] = @Original_CodTipoDelibera) AND ((@IsNull_DescDelibera = 1 AND [DescDelibera] IS NULL) OR ([DescDelibera] = @Original_DescDelibera)) AND ((@IsNull_CodEvento = 1 AND [CodEvento] IS NULL) OR ([CodEvento] = @Original_CodEvento)));
|
|
SELECT CodTipoDelibera, DescDelibera, CodEvento FROM AnagTipoDelibere WHERE (CodTipoDelibera = @CodTipoDelibera)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDelibera" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodTipoDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodTipoDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescDelibera" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescDelibera" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescDelibera" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescDelibera" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodEvento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodTipoDelibera" DataSetColumn="CodTipoDelibera" />
|
|
<Mapping SourceColumn="DescDelibera" DataSetColumn="DescDelibera" />
|
|
<Mapping SourceColumn="CodEvento" DataSetColumn="CodEvento" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GMWConnectionString (Settings)" DbObjectName="SP_GMWTest.dbo.stp_ATD_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ATD_getByKey</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="@CodTipoDelibera" 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_SM" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DS_SM" msprop:Generator_DataSetName="DS_SM" msprop:EnableTableAdapterManager="true">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="Delibere" msprop:Generator_UserTableName="Delibere" msprop:Generator_RowDeletedName="DelibereRowDeleted" msprop:Generator_RowChangedName="DelibereRowChanged" msprop:Generator_RowClassName="DelibereRow" msprop:Generator_RowChangingName="DelibereRowChanging" msprop:Generator_RowEvArgName="DelibereRowChangeEvent" msprop:Generator_RowEvHandlerName="DelibereRowChangeEventHandler" msprop:Generator_TableClassName="DelibereDataTable" msprop:Generator_TableVarName="tableDelibere" msprop:Generator_RowDeletingName="DelibereRowDeleting" msprop:Generator_TablePropName="Delibere">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodTipoDelibera" msprop:Generator_UserColumnName="CodTipoDelibera" msprop:Generator_ColumnVarNameInTable="columnCodTipoDelibera" msprop:Generator_ColumnPropNameInRow="CodTipoDelibera" msprop:Generator_ColumnPropNameInTable="CodTipoDeliberaColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_UserColumnName="UDC" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataDelibera" msprop:Generator_UserColumnName="DataDelibera" msprop:Generator_ColumnVarNameInTable="columnDataDelibera" msprop:Generator_ColumnPropNameInRow="DataDelibera" msprop:Generator_ColumnPropNameInTable="DataDeliberaColumn" type="xs:dateTime" />
|
|
<xs:element name="CodSoggetto" msprop:Generator_UserColumnName="CodSoggetto" msprop:Generator_ColumnVarNameInTable="columnCodSoggetto" msprop:Generator_ColumnPropNameInRow="CodSoggetto" msprop:Generator_ColumnPropNameInTable="CodSoggettoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="16" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagTipoEvento" msprop:Generator_UserTableName="AnagTipoEvento" msprop:Generator_RowDeletedName="AnagTipoEventoRowDeleted" msprop:Generator_RowChangedName="AnagTipoEventoRowChanged" msprop:Generator_RowClassName="AnagTipoEventoRow" msprop:Generator_RowChangingName="AnagTipoEventoRowChanging" msprop:Generator_RowEvArgName="AnagTipoEventoRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagTipoEventoRowChangeEventHandler" msprop:Generator_TableClassName="AnagTipoEventoDataTable" msprop:Generator_TableVarName="tableAnagTipoEvento" msprop:Generator_RowDeletingName="AnagTipoEventoRowDeleting" msprop:Generator_TablePropName="AnagTipoEvento">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodEvento" msprop:Generator_UserColumnName="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescEvento" msprop:Generator_UserColumnName="DescEvento" msprop:Generator_ColumnVarNameInTable="columnDescEvento" msprop:Generator_ColumnPropNameInRow="DescEvento" msprop:Generator_ColumnPropNameInTable="DescEventoColumn" 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="TabTranPosizEventi" msprop:Generator_UserTableName="TabTranPosizEventi" msprop:Generator_RowDeletedName="TabTranPosizEventiRowDeleted" msprop:Generator_RowChangedName="TabTranPosizEventiRowChanged" msprop:Generator_RowClassName="TabTranPosizEventiRow" msprop:Generator_RowChangingName="TabTranPosizEventiRowChanging" msprop:Generator_RowEvArgName="TabTranPosizEventiRowChangeEvent" msprop:Generator_RowEvHandlerName="TabTranPosizEventiRowChangeEventHandler" msprop:Generator_TableClassName="TabTranPosizEventiDataTable" msprop:Generator_TableVarName="tableTabTranPosizEventi" msprop:Generator_RowDeletingName="TabTranPosizEventiRowDeleting" msprop:Generator_TablePropName="TabTranPosizEventi">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodEvento" msprop:Generator_UserColumnName="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="IdxPosizione" msprop:Generator_UserColumnName="IdxPosizione" msprop:Generator_ColumnVarNameInTable="columnIdxPosizione" msprop:Generator_ColumnPropNameInRow="IdxPosizione" msprop:Generator_ColumnPropNameInTable="IdxPosizioneColumn" type="xs:int" />
|
|
<xs:element name="IdxPosizioneTo" msprop:Generator_UserColumnName="IdxPosizioneTo" msprop:Generator_ColumnVarNameInTable="columnIdxPosizioneTo" msprop:Generator_ColumnPropNameInRow="IdxPosizioneTo" msprop:Generator_ColumnPropNameInTable="IdxPosizioneToColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="IdxBloccoTo" msprop:Generator_UserColumnName="IdxBloccoTo" msprop:Generator_ColumnPropNameInRow="IdxBloccoTo" msprop:Generator_ColumnVarNameInTable="columnIdxBloccoTo" msprop:Generator_ColumnPropNameInTable="IdxBloccoToColumn" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagPosizioni" msprop:Generator_UserTableName="AnagPosizioni" msprop:Generator_RowDeletedName="AnagPosizioniRowDeleted" msprop:Generator_RowChangedName="AnagPosizioniRowChanged" msprop:Generator_RowClassName="AnagPosizioniRow" msprop:Generator_RowChangingName="AnagPosizioniRowChanging" msprop:Generator_RowEvArgName="AnagPosizioniRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagPosizioniRowChangeEventHandler" msprop:Generator_TableClassName="AnagPosizioniDataTable" msprop:Generator_TableVarName="tableAnagPosizioni" msprop:Generator_RowDeletingName="AnagPosizioniRowDeleting" msprop:Generator_TablePropName="AnagPosizioni">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxPosizione" msprop:Generator_UserColumnName="IdxPosizione" msprop:Generator_ColumnVarNameInTable="columnIdxPosizione" msprop:Generator_ColumnPropNameInRow="IdxPosizione" msprop:Generator_ColumnPropNameInTable="IdxPosizioneColumn" type="xs:int" />
|
|
<xs:element name="DescPosizione" msprop:Generator_UserColumnName="DescPosizione" msprop:Generator_ColumnVarNameInTable="columnDescPosizione" msprop:Generator_ColumnPropNameInRow="DescPosizione" msprop:Generator_ColumnPropNameInTable="DescPosizioneColumn" 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="AnagTipoDelibere" msprop:Generator_UserTableName="AnagTipoDelibere" msprop:Generator_RowDeletedName="AnagTipoDelibereRowDeleted" msprop:Generator_RowChangedName="AnagTipoDelibereRowChanged" msprop:Generator_RowClassName="AnagTipoDelibereRow" msprop:Generator_RowChangingName="AnagTipoDelibereRowChanging" msprop:Generator_RowEvArgName="AnagTipoDelibereRowChangeEvent" msprop:Generator_RowEvHandlerName="AnagTipoDelibereRowChangeEventHandler" msprop:Generator_TableClassName="AnagTipoDelibereDataTable" msprop:Generator_TableVarName="tableAnagTipoDelibere" msprop:Generator_RowDeletingName="AnagTipoDelibereRowDeleting" msprop:Generator_TablePropName="AnagTipoDelibere">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodTipoDelibera" msprop:Generator_UserColumnName="CodTipoDelibera" msprop:Generator_ColumnVarNameInTable="columnCodTipoDelibera" msprop:Generator_ColumnPropNameInRow="CodTipoDelibera" msprop:Generator_ColumnPropNameInTable="CodTipoDeliberaColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDelibera" msprop:Generator_UserColumnName="DescDelibera" msprop:Generator_ColumnVarNameInTable="columnDescDelibera" msprop:Generator_ColumnPropNameInRow="DescDelibera" msprop:Generator_ColumnPropNameInTable="DescDeliberaColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodEvento" msprop:Generator_UserColumnName="CodEvento" msprop:Generator_ColumnVarNameInTable="columnCodEvento" msprop:Generator_ColumnPropNameInRow="CodEvento" msprop:Generator_ColumnPropNameInTable="CodEventoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Delibere" />
|
|
<xs:field xpath="mstns:CodTipoDelibera" />
|
|
<xs:field xpath="mstns:UDC" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagTipoEvento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagTipoEvento" />
|
|
<xs:field xpath="mstns:CodEvento" />
|
|
</xs:unique>
|
|
<xs:unique name="TabTranPosizEventi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TabTranPosizEventi" />
|
|
<xs:field xpath="mstns:CodEvento" />
|
|
<xs:field xpath="mstns:IdxPosizione" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagPosizioni_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagPosizioni" />
|
|
<xs:field xpath="mstns:IdxPosizione" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagTipoDelibere_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagTipoDelibere" />
|
|
<xs:field xpath="mstns:CodTipoDelibera" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_TabTranPosizEventi_AnagTipoEvento" msdata:parent="AnagTipoEvento" msdata:child="TabTranPosizEventi" msdata:parentkey="CodEvento" msdata:childkey="CodEvento" msprop:Generator_UserRelationName="FK_TabTranPosizEventi_AnagTipoEvento" msprop:Generator_RelationVarName="relationFK_TabTranPosizEventi_AnagTipoEvento" msprop:Generator_UserChildTable="TabTranPosizEventi" msprop:Generator_UserParentTable="AnagTipoEvento" msprop:Generator_ParentPropName="AnagTipoEventoRow" msprop:Generator_ChildPropName="GetTabTranPosizEventiRows" />
|
|
<msdata:Relationship name="FK_TabTranPosizEventi_AnagPosizioni" msdata:parent="AnagPosizioni" msdata:child="TabTranPosizEventi" msdata:parentkey="IdxPosizione" msdata:childkey="IdxPosizione" msprop:Generator_UserRelationName="FK_TabTranPosizEventi_AnagPosizioni" msprop:Generator_RelationVarName="relationFK_TabTranPosizEventi_AnagPosizioni" msprop:Generator_UserChildTable="TabTranPosizEventi" msprop:Generator_UserParentTable="AnagPosizioni" msprop:Generator_ParentPropName="AnagPosizioniRow" msprop:Generator_ChildPropName="GetTabTranPosizEventiRows" />
|
|
<msdata:Relationship name="FK_Delibere_AnagTipoDelibere" msdata:parent="AnagTipoDelibere" msdata:child="Delibere" msdata:parentkey="CodTipoDelibera" msdata:childkey="CodTipoDelibera" msprop:Generator_UserRelationName="FK_Delibere_AnagTipoDelibere" msprop:Generator_RelationVarName="relationFK_Delibere_AnagTipoDelibere" msprop:Generator_UserChildTable="Delibere" msprop:Generator_UserParentTable="AnagTipoDelibere" msprop:Generator_ParentPropName="AnagTipoDelibereRow" msprop:Generator_ChildPropName="GetDelibereRows" />
|
|
<msdata:Relationship name="FK_AnagTipoDelibere_AnagTipoEvento" msdata:parent="AnagTipoEvento" msdata:child="AnagTipoDelibere" msdata:parentkey="CodEvento" msdata:childkey="CodEvento" msprop:Generator_UserRelationName="FK_AnagTipoDelibere_AnagTipoEvento" msprop:Generator_RelationVarName="relationFK_AnagTipoDelibere_AnagTipoEvento" msprop:Generator_UserChildTable="AnagTipoDelibere" msprop:Generator_UserParentTable="AnagTipoEvento" msprop:Generator_ParentPropName="AnagTipoEventoRow" msprop:Generator_ChildPropName="GetAnagTipoDelibereRows" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |