Samuele Locatelli
1013 lines
108 KiB
XML
1013 lines
108 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Utility" targetNamespace="http://tempuri.org/DS_Utility.xsd" xmlns:mstns="http://tempuri.org/DS_Utility.xsd" xmlns="http://tempuri.org/DS_Utility.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GPWConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GPWConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GPW_data.Properties.Settings.GlobalReference.Default.GPWConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selDipendentiTableAdapter" GeneratorDataComponentClassName="v_selDipendentiTableAdapter" Name="v_selDipendenti" UserDataComponentName="v_selDipendentiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selDipendenti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM v_selDipendenti
|
|
ORDER BY label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_Dip2Gruppi_delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteFromGruppo" Modifier="Public" Name="deleteFromGruppo" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteFromGruppo">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Dip2Gruppi_delete</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="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_value" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSDip_getByConditio" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSDip_getByConditio</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="bit" DbType="Boolean" Direction="Input" ParameterName="@Conditio" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSDip_getByGruppo" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByGruppo" GetMethodModifier="Public" GetMethodName="getByGruppo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByGruppo" UserSourceName="getByGruppo">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSDip_getByGruppo</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="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@invSel" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSDip_getByRuolo" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByRuolo" GetMethodModifier="Public" GetMethodName="getByRuolo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByRuolo" UserSourceName="getByRuolo">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSDip_getByRuolo</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="@CodRuolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_getLastDaysTableAdapter" GeneratorDataComponentClassName="stp_getLastDaysTableAdapter" Name="stp_getLastDays" UserDataComponentName="stp_getLastDaysTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_getLastDays" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_getLastDays</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@lastDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numD" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_getMinTableAdapter" GeneratorDataComponentClassName="stp_getMinTableAdapter" Name="stp_getMin" UserDataComponentName="stp_getMinTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_getMin" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_getMin</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@interv" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="minuto" DataSetColumn="minuto" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_getHoursTableAdapter" GeneratorDataComponentClassName="stp_getHoursTableAdapter" Name="stp_getHours" UserDataComponentName="stp_getHoursTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_getHours" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_getHours</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="ora" DataSetColumn="ora" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selProgettiTableAdapter" GeneratorDataComponentClassName="v_selProgettiTableAdapter" Name="v_selProgetti" UserDataComponentName="v_selProgettiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selProgetti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT * FROM v_selProgetti</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
|
|
<Mapping SourceColumn="gruppo" DataSetColumn="gruppo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSPrj_byConditio" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPrj_byConditio</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@conditio" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSPrj_byGruppo" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByGruppo" GetMethodModifier="Public" GetMethodName="getByGruppo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByGruppo" UserSourceName="getByGruppo">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPrj_byGruppo</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="@gruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSPrj" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getGrouped" GetMethodModifier="Public" GetMethodName="getGrouped" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getGrouped" UserSourceName="getGrouped">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPrj</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="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selFasiTableAdapter" GeneratorDataComponentClassName="v_selFasiTableAdapter" Name="v_selFasi" UserDataComponentName="v_selFasiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selFasi" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT value, label, conditio FROM v_selFasi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSFasi_ByPrj" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSFasi_ByPrj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@conditio" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selClientiTableAdapter" GeneratorDataComponentClassName="v_selClientiTableAdapter" Name="v_selClienti" UserDataComponentName="v_selClientiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selClienti" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT * FROM v_selClienti
|
|
ORDER BY label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSCli_getByConditio" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSCli_getByConditio</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="bit" DbType="Boolean" Direction="Input" ParameterName="@Conditio" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_statsProjTableAdapter" GeneratorDataComponentClassName="stp_statsProjTableAdapter" Name="stp_statsProj" UserDataComponentName="stp_statsProjTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_statsProj" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_statsProj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxProgetto" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="oreBudget" DataSetColumn="oreBudget" />
|
|
<Mapping SourceColumn="oreTot" DataSetColumn="oreTot" />
|
|
<Mapping SourceColumn="oreMese" DataSetColumn="oreMese" />
|
|
<Mapping SourceColumn="oreMesePrec" DataSetColumn="oreMesePrec" />
|
|
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
|
|
<Mapping SourceColumn="starred" DataSetColumn="starred" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selCodGiustTableAdapter" GeneratorDataComponentClassName="v_selCodGiustTableAdapter" Name="v_selCodGiust" UserDataComponentName="v_selCodGiustTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selCodGiust" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selCodGiust</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="nextValContatoreTableAdapter" GeneratorDataComponentClassName="nextValContatoreTableAdapter" Name="nextValContatore" UserDataComponentName="nextValContatoreTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_nextValContatore" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_nextValContatore</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="@codContatore" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Column1" DataSetColumn="Column1" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selFasiOptTableAdapter" GeneratorDataComponentClassName="v_selFasiOptTableAdapter" Name="v_selFasiOpt" UserDataComponentName="v_selFasiOptTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSFasiOpt_ByPrj" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="getByConditio" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="getByConditio" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSFasiOpt_ByPrj</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@conditio" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloAttivi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="valueGroup" DataSetColumn="valueGroup" />
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnagKeyValueTableAdapter" GeneratorDataComponentClassName="AnagKeyValueTableAdapter" Name="AnagKeyValue" UserDataComponentName="AnagKeyValueTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.AnagKeyValue" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[AnagKeyValue] WHERE (([nomeVar] = @Original_nomeVar) AND ((@IsNull_valInt = 1 AND [valInt] IS NULL) OR ([valInt] = @Original_valInt)) AND ((@IsNull_valFloat = 1 AND [valFloat] IS NULL) OR ([valFloat] = @Original_valFloat)) AND ((@IsNull_valString = 1 AND [valString] IS NULL) OR ([valString] = @Original_valString)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeVar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeVar" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valInt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valInt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_valInt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valInt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valFloat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valFloat" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_valFloat" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="valFloat" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valString" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valString" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valString" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valString" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[AnagKeyValue] ([nomeVar], [valInt], [valFloat], [valString], [descrizione]) VALUES (@nomeVar, @valInt, @valFloat, @valString, @descrizione);
|
|
SELECT nomeVar, valInt, valFloat, valString, descrizione FROM AnagKeyValue WHERE (nomeVar = @nomeVar)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeVar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeVar" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@valInt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valInt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@valFloat" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="valFloat" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valString" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valString" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT nomeVar, valInt, valFloat, valString, descrizione FROM dbo.AnagKeyValue</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[AnagKeyValue] SET [nomeVar] = @nomeVar, [valInt] = @valInt, [valFloat] = @valFloat, [valString] = @valString, [descrizione] = @descrizione WHERE (([nomeVar] = @Original_nomeVar) AND ((@IsNull_valInt = 1 AND [valInt] IS NULL) OR ([valInt] = @Original_valInt)) AND ((@IsNull_valFloat = 1 AND [valFloat] IS NULL) OR ([valFloat] = @Original_valFloat)) AND ((@IsNull_valString = 1 AND [valString] IS NULL) OR ([valString] = @Original_valString)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)));
|
|
SELECT nomeVar, valInt, valFloat, valString, descrizione FROM AnagKeyValue WHERE (nomeVar = @nomeVar)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeVar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeVar" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@valInt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valInt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@valFloat" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="valFloat" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@valString" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valString" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeVar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeVar" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valInt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valInt" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_valInt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valInt" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valFloat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valFloat" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_valFloat" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="valFloat" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valString" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valString" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_valString" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="valString" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="nomeVar" DataSetColumn="nomeVar" />
|
|
<Mapping SourceColumn="valInt" DataSetColumn="valInt" />
|
|
<Mapping SourceColumn="valFloat" DataSetColumn="valFloat" />
|
|
<Mapping SourceColumn="valString" DataSetColumn="valString" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_AKV_getByKey" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByKey" GetMethodModifier="Public" GetMethodName="getByKey" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByKey" UserSourceName="getByKey">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_AKV_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="@nomeVar" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selCodOrarioTableAdapter" GeneratorDataComponentClassName="v_selCodOrarioTableAdapter" Name="v_selCodOrario" UserDataComponentName="v_selCodOrarioTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selCodOrario" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selCodOrario</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selPageSizeTableAdapter" GeneratorDataComponentClassName="v_selPageSizeTableAdapter" Name="v_selPageSize" UserDataComponentName="v_selPageSizeTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selPageSize" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT value, label, ordinal
|
|
FROM v_selPageSize
|
|
ORDER BY ordinal</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="ordinal" DataSetColumn="ordinal" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_VSProjFasi_searchTableAdapter" GeneratorDataComponentClassName="stp_VSProjFasi_searchTableAdapter" Name="stp_VSProjFasi_search" UserDataComponentName="stp_VSProjFasi_searchTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSProjFasi_search" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSProjFasi_search</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="@textSearch" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxProgetto" DataSetColumn="idxProgetto" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="freqProgettiTableAdapter" GeneratorDataComponentClassName="freqProgettiTableAdapter" Name="freqProgetti" UserDataComponentName="freqProgettiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_freqProjByDipPeriodo" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_freqProjByDipPeriodo</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxDipendente" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inizio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fine" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maxRes" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="nomeComm" DataSetColumn="nomeComm" />
|
|
<Mapping SourceColumn="idxFaseComm" DataSetColumn="idxFaseComm" />
|
|
<Mapping SourceColumn="idxFase" DataSetColumn="idxFase" />
|
|
<Mapping SourceColumn="nomeProj" DataSetColumn="nomeProj" />
|
|
<Mapping SourceColumn="nomeFase" DataSetColumn="nomeFase" />
|
|
<Mapping SourceColumn="freq" DataSetColumn="freq" />
|
|
<Mapping SourceColumn="qty" DataSetColumn="qty" />
|
|
<Mapping SourceColumn="tot" DataSetColumn="tot" />
|
|
<Mapping SourceColumn="RowNum" DataSetColumn="RowNum" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selProjFasiTableAdapter" GeneratorDataComponentClassName="v_selProjFasiTableAdapter" Name="v_selProjFasi" UserDataComponentName="v_selProjFasiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSPF_search" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSPF_search</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="@search" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="ordine" DataSetColumn="ordine" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selListValTableAdapter" GeneratorDataComponentClassName="v_selListValTableAdapter" Name="v_selListVal" UserDataComponentName="v_selListValTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selListVal" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selListVal</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_listValues_getValidValues" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTableField" GetMethodModifier="Public" GetMethodName="getByTableField" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTableField" UserSourceName="getByTableField">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_listValues_getValidValues</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="@TableName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@FieldName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selGruppiTableAdapter" GeneratorDataComponentClassName="v_selGruppiTableAdapter" Name="v_selGruppi" UserDataComponentName="v_selGruppiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selGruppi" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT * FROM v_selGruppi ORDER BY label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_VSGrp_getByConditio" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditio" GetMethodModifier="Public" GetMethodName="getByConditio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditio" UserSourceName="getByConditio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSGrp_getByConditio</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Conditio" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selTagFasiTableAdapter" GeneratorDataComponentClassName="v_selTagFasiTableAdapter" Name="v_selTagFasi" UserDataComponentName="v_selTagFasiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.v_selTagFasi" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT value, label FROM dbo.v_selTagFasi</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Utility" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DS_Utility" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Utility">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="v_selDipendenti" msprop:Generator_RowEvHandlerName="v_selDipendentiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selDipendentiRowDeleted" msprop:Generator_RowDeletingName="v_selDipendentiRowDeleting" msprop:Generator_RowEvArgName="v_selDipendentiRowChangeEvent" msprop:Generator_TablePropName="v_selDipendenti" msprop:Generator_RowChangedName="v_selDipendentiRowChanged" msprop:Generator_UserTableName="v_selDipendenti" msprop:Generator_RowChangingName="v_selDipendentiRowChanging" msprop:Generator_RowClassName="v_selDipendentiRow" msprop:Generator_TableClassName="v_selDipendentiDataTable" msprop:Generator_TableVarName="tablev_selDipendenti">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_UserColumnName="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_getLastDays" msprop:Generator_RowEvHandlerName="stp_getLastDaysRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_getLastDaysRowDeleted" msprop:Generator_RowDeletingName="stp_getLastDaysRowDeleting" msprop:Generator_RowEvArgName="stp_getLastDaysRowChangeEvent" msprop:Generator_TablePropName="stp_getLastDays" msprop:Generator_RowChangedName="stp_getLastDaysRowChanged" msprop:Generator_UserTableName="stp_getLastDays" msprop:Generator_RowChangingName="stp_getLastDaysRowChanging" msprop:Generator_RowClassName="stp_getLastDaysRow" msprop:Generator_TableClassName="stp_getLastDaysDataTable" msprop:Generator_TableVarName="tablestp_getLastDays">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Data" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_UserColumnName="Data" msprop:Generator_ColumnVarNameInTable="columnData" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_getMin" msprop:Generator_RowEvHandlerName="stp_getMinRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_getMinRowDeleted" msprop:Generator_RowDeletingName="stp_getMinRowDeleting" msprop:Generator_RowEvArgName="stp_getMinRowChangeEvent" msprop:Generator_TablePropName="stp_getMin" msprop:Generator_RowChangedName="stp_getMinRowChanged" msprop:Generator_UserTableName="stp_getMin" msprop:Generator_RowChangingName="stp_getMinRowChanging" msprop:Generator_RowClassName="stp_getMinRow" msprop:Generator_TableClassName="stp_getMinDataTable" msprop:Generator_TableVarName="tablestp_getMin">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="minuto" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="minutoColumn" msprop:Generator_ColumnPropNameInRow="minuto" msprop:Generator_UserColumnName="minuto" msprop:Generator_ColumnVarNameInTable="columnminuto" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_getHours" msprop:Generator_RowEvHandlerName="stp_getHoursRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_getHoursRowDeleted" msprop:Generator_RowDeletingName="stp_getHoursRowDeleting" msprop:Generator_RowEvArgName="stp_getHoursRowChangeEvent" msprop:Generator_TablePropName="stp_getHours" msprop:Generator_RowChangedName="stp_getHoursRowChanged" msprop:Generator_UserTableName="stp_getHours" msprop:Generator_RowChangingName="stp_getHoursRowChanging" msprop:Generator_RowClassName="stp_getHoursRow" msprop:Generator_TableClassName="stp_getHoursDataTable" msprop:Generator_TableVarName="tablestp_getHours">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="ora" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="oraColumn" msprop:Generator_ColumnPropNameInRow="ora" msprop:Generator_UserColumnName="ora" msprop:Generator_ColumnVarNameInTable="columnora" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selProgetti" msprop:Generator_RowEvHandlerName="v_selProgettiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selProgettiRowDeleted" msprop:Generator_RowDeletingName="v_selProgettiRowDeleting" msprop:Generator_RowEvArgName="v_selProgettiRowChangeEvent" msprop:Generator_TablePropName="v_selProgetti" msprop:Generator_RowChangedName="v_selProgettiRowChanged" msprop:Generator_UserTableName="v_selProgetti" msprop:Generator_RowChangingName="v_selProgettiRowChanging" msprop:Generator_RowClassName="v_selProgettiRow" msprop:Generator_TableClassName="v_selProgettiDataTable" msprop:Generator_TableVarName="tablev_selProgetti">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="303" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_UserColumnName="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" type="xs:int" />
|
|
<xs:element name="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_UserColumnName="Attivo" msprop:Generator_ColumnVarNameInTable="columnAttivo" type="xs:boolean" />
|
|
<xs:element name="gruppo" msprop:Generator_ColumnPropNameInTable="gruppoColumn" msprop:Generator_ColumnPropNameInRow="gruppo" msprop:Generator_UserColumnName="gruppo" msprop:Generator_ColumnVarNameInTable="columngruppo">
|
|
<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_selFasi" msprop:Generator_RowEvHandlerName="v_selFasiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selFasiRowDeleted" msprop:Generator_RowDeletingName="v_selFasiRowDeleting" msprop:Generator_RowEvArgName="v_selFasiRowChangeEvent" msprop:Generator_TablePropName="v_selFasi" msprop:Generator_RowChangedName="v_selFasiRowChanged" msprop:Generator_UserTableName="v_selFasi" msprop:Generator_RowChangingName="v_selFasiRowChanging" msprop:Generator_RowClassName="v_selFasiRow" msprop:Generator_TableClassName="v_selFasiDataTable" msprop:Generator_TableVarName="tablev_selFasi">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_UserColumnName="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selClienti" msprop:Generator_RowEvHandlerName="v_selClientiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selClientiRowDeleted" msprop:Generator_RowDeletingName="v_selClientiRowDeleting" msprop:Generator_RowEvArgName="v_selClientiRowChangeEvent" msprop:Generator_TablePropName="v_selClienti" msprop:Generator_RowChangedName="v_selClientiRowChanged" msprop:Generator_UserTableName="v_selClienti" msprop:Generator_RowChangingName="v_selClientiRowChanging" msprop:Generator_RowClassName="v_selClientiRow" msprop:Generator_TableClassName="v_selClientiDataTable" msprop:Generator_TableVarName="tablev_selClienti">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_UserColumnName="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" type="xs:boolean" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_statsProj" msprop:Generator_RowEvHandlerName="stp_statsProjRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_statsProjRowDeleted" msprop:Generator_RowDeletingName="stp_statsProjRowDeleting" msprop:Generator_RowEvArgName="stp_statsProjRowChangeEvent" msprop:Generator_TablePropName="stp_statsProj" msprop:Generator_RowChangedName="stp_statsProjRowChanged" msprop:Generator_UserTableName="stp_statsProj" msprop:Generator_RowChangingName="stp_statsProjRowChanging" msprop:Generator_RowClassName="stp_statsProjRow" msprop:Generator_TableClassName="stp_statsProjDataTable" msprop:Generator_TableVarName="tablestp_statsProj">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="oreBudget" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="oreBudgetColumn" msprop:Generator_ColumnPropNameInRow="oreBudget" msprop:Generator_UserColumnName="oreBudget" msprop:Generator_ColumnVarNameInTable="columnoreBudget" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="oreTot" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="oreTotColumn" msprop:Generator_ColumnPropNameInRow="oreTot" msprop:Generator_UserColumnName="oreTot" msprop:Generator_ColumnVarNameInTable="columnoreTot" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="oreMese" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="oreMeseColumn" msprop:Generator_ColumnPropNameInRow="oreMese" msprop:Generator_UserColumnName="oreMese" msprop:Generator_ColumnVarNameInTable="columnoreMese" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="oreMesePrec" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="oreMesePrecColumn" msprop:Generator_ColumnPropNameInRow="oreMesePrec" msprop:Generator_UserColumnName="oreMesePrec" msprop:Generator_ColumnVarNameInTable="columnoreMesePrec" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_UserColumnName="Attivo" msprop:Generator_ColumnVarNameInTable="columnAttivo" type="xs:boolean" />
|
|
<xs:element name="starred" msprop:Generator_ColumnPropNameInTable="starredColumn" msprop:Generator_ColumnPropNameInRow="starred" msprop:Generator_UserColumnName="starred" msprop:Generator_ColumnVarNameInTable="columnstarred" type="xs:boolean" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCodGiust" msprop:Generator_RowEvHandlerName="v_selCodGiustRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selCodGiustRowDeleted" msprop:Generator_RowDeletingName="v_selCodGiustRowDeleting" msprop:Generator_RowEvArgName="v_selCodGiustRowChangeEvent" msprop:Generator_TablePropName="v_selCodGiust" msprop:Generator_RowChangedName="v_selCodGiustRowChanged" msprop:Generator_UserTableName="v_selCodGiust" msprop:Generator_RowChangingName="v_selCodGiustRowChanging" msprop:Generator_RowClassName="v_selCodGiustRow" msprop:Generator_TableClassName="v_selCodGiustDataTable" msprop:Generator_TableVarName="tablev_selCodGiust">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" 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="nextValContatore" msprop:Generator_RowEvHandlerName="nextValContatoreRowChangeEventHandler" msprop:Generator_RowDeletedName="nextValContatoreRowDeleted" msprop:Generator_RowDeletingName="nextValContatoreRowDeleting" msprop:Generator_RowEvArgName="nextValContatoreRowChangeEvent" msprop:Generator_TablePropName="nextValContatore" msprop:Generator_RowChangedName="nextValContatoreRowChanged" msprop:Generator_UserTableName="nextValContatore" msprop:Generator_RowChangingName="nextValContatoreRowChanging" msprop:Generator_RowClassName="nextValContatoreRow" msprop:Generator_TableClassName="nextValContatoreDataTable" msprop:Generator_TableVarName="tablenextValContatore">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Column1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="Column1Column" msprop:Generator_ColumnPropNameInRow="Column1" msprop:Generator_UserColumnName="Column1" msprop:Generator_ColumnVarNameInTable="columnColumn1" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selFasiOpt" msprop:Generator_RowEvHandlerName="v_selFasiOptRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selFasiOptRowDeleted" msprop:Generator_RowDeletingName="v_selFasiOptRowDeleting" msprop:Generator_RowEvArgName="v_selFasiOptRowChangeEvent" msprop:Generator_TablePropName="v_selFasiOpt" msprop:Generator_RowChangedName="v_selFasiOptRowChanged" msprop:Generator_UserTableName="v_selFasiOpt" msprop:Generator_RowChangingName="v_selFasiOptRowChanging" msprop:Generator_RowClassName="v_selFasiOptRow" msprop:Generator_TableClassName="v_selFasiOptDataTable" msprop:Generator_TableVarName="tablev_selFasiOpt">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="valueGroup" msprop:Generator_ColumnPropNameInTable="valueGroupColumn" msprop:Generator_ColumnPropNameInRow="valueGroup" msprop:Generator_UserColumnName="valueGroup" msprop:Generator_ColumnVarNameInTable="columnvalueGroup" type="xs:int" />
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_UserColumnName="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AnagKeyValue" msprop:Generator_RowEvHandlerName="AnagKeyValueRowChangeEventHandler" msprop:Generator_RowDeletedName="AnagKeyValueRowDeleted" msprop:Generator_RowDeletingName="AnagKeyValueRowDeleting" msprop:Generator_RowEvArgName="AnagKeyValueRowChangeEvent" msprop:Generator_TablePropName="AnagKeyValue" msprop:Generator_RowChangedName="AnagKeyValueRowChanged" msprop:Generator_UserTableName="AnagKeyValue" msprop:Generator_RowChangingName="AnagKeyValueRowChanging" msprop:Generator_RowClassName="AnagKeyValueRow" msprop:Generator_TableClassName="AnagKeyValueDataTable" msprop:Generator_TableVarName="tableAnagKeyValue">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="nomeVar" msprop:Generator_ColumnPropNameInTable="nomeVarColumn" msprop:Generator_ColumnPropNameInRow="nomeVar" msprop:Generator_UserColumnName="nomeVar" msprop:Generator_ColumnVarNameInTable="columnnomeVar">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="valInt" msprop:Generator_ColumnPropNameInTable="valIntColumn" msprop:Generator_ColumnPropNameInRow="valInt" msprop:Generator_UserColumnName="valInt" msprop:Generator_ColumnVarNameInTable="columnvalInt" type="xs:int" minOccurs="0" />
|
|
<xs:element name="valFloat" msprop:Generator_ColumnPropNameInTable="valFloatColumn" msprop:Generator_ColumnPropNameInRow="valFloat" msprop:Generator_UserColumnName="valFloat" msprop:Generator_ColumnVarNameInTable="columnvalFloat" type="xs:double" minOccurs="0" />
|
|
<xs:element name="valString" msprop:Generator_ColumnPropNameInTable="valStringColumn" msprop:Generator_ColumnPropNameInRow="valString" msprop:Generator_UserColumnName="valString" msprop:Generator_ColumnVarNameInTable="columnvalString" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_UserColumnName="descrizione" msprop:Generator_ColumnVarNameInTable="columndescrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCodOrario" msprop:Generator_RowEvHandlerName="v_selCodOrarioRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selCodOrarioRowDeleted" msprop:Generator_RowDeletingName="v_selCodOrarioRowDeleting" msprop:Generator_RowEvArgName="v_selCodOrarioRowChangeEvent" msprop:Generator_TablePropName="v_selCodOrario" msprop:Generator_RowChangedName="v_selCodOrarioRowChanged" msprop:Generator_UserTableName="v_selCodOrario" msprop:Generator_RowChangingName="v_selCodOrarioRowChanging" msprop:Generator_RowClassName="v_selCodOrarioRow" msprop:Generator_TableClassName="v_selCodOrarioDataTable" msprop:Generator_TableVarName="tablev_selCodOrario">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selPageSize" msprop:Generator_RowEvHandlerName="v_selPageSizeRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selPageSizeRowDeleted" msprop:Generator_RowDeletingName="v_selPageSizeRowDeleting" msprop:Generator_RowEvArgName="v_selPageSizeRowChangeEvent" msprop:Generator_TablePropName="v_selPageSize" msprop:Generator_RowChangedName="v_selPageSizeRowChanged" msprop:Generator_UserTableName="v_selPageSize" msprop:Generator_RowChangingName="v_selPageSizeRowChanging" msprop:Generator_RowClassName="v_selPageSizeRow" msprop:Generator_TableClassName="v_selPageSizeDataTable" msprop:Generator_TableVarName="tablev_selPageSize">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ordinal" msprop:Generator_ColumnPropNameInTable="ordinalColumn" msprop:Generator_ColumnPropNameInRow="ordinal" msprop:Generator_UserColumnName="ordinal" msprop:Generator_ColumnVarNameInTable="columnordinal" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_VSProjFasi_search" msprop:Generator_RowEvHandlerName="stp_VSProjFasi_searchRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_VSProjFasi_searchRowDeleted" msprop:Generator_RowDeletingName="stp_VSProjFasi_searchRowDeleting" msprop:Generator_RowEvArgName="stp_VSProjFasi_searchRowChangeEvent" msprop:Generator_TablePropName="stp_VSProjFasi_search" msprop:Generator_RowChangedName="stp_VSProjFasi_searchRowChanged" msprop:Generator_UserTableName="stp_VSProjFasi_search" msprop:Generator_RowChangingName="stp_VSProjFasi_searchRowChanging" msprop:Generator_RowClassName="stp_VSProjFasi_searchRow" msprop:Generator_TableClassName="stp_VSProjFasi_searchDataTable" msprop:Generator_TableVarName="tablestp_VSProjFasi_search">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxProgetto" msprop:Generator_ColumnPropNameInTable="idxProgettoColumn" msprop:Generator_ColumnPropNameInRow="idxProgetto" msprop:Generator_UserColumnName="idxProgetto" msprop:Generator_ColumnVarNameInTable="columnidxProgetto" type="xs:int" minOccurs="0" />
|
|
<xs:element name="idxFase" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_UserColumnName="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="freqProgetti" msprop:Generator_RowEvHandlerName="freqProgettiRowChangeEventHandler" msprop:Generator_RowDeletedName="freqProgettiRowDeleted" msprop:Generator_RowDeletingName="freqProgettiRowDeleting" msprop:Generator_RowEvArgName="freqProgettiRowChangeEvent" msprop:Generator_TablePropName="freqProgetti" msprop:Generator_RowChangedName="freqProgettiRowChanged" msprop:Generator_UserTableName="freqProgetti" msprop:Generator_RowChangingName="freqProgettiRowChanging" msprop:Generator_RowClassName="freqProgettiRow" msprop:Generator_TableClassName="freqProgettiDataTable" msprop:Generator_TableVarName="tablefreqProgetti">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="nomeComm" msprop:Generator_ColumnPropNameInTable="nomeCommColumn" msprop:Generator_ColumnPropNameInRow="nomeComm" msprop:Generator_UserColumnName="nomeComm" msprop:Generator_ColumnVarNameInTable="columnnomeComm" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxFaseComm" msprop:Generator_ColumnPropNameInTable="idxFaseCommColumn" msprop:Generator_ColumnPropNameInRow="idxFaseComm" msprop:Generator_UserColumnName="idxFaseComm" msprop:Generator_ColumnVarNameInTable="columnidxFaseComm" type="xs:int" minOccurs="0" />
|
|
<xs:element name="idxFase" msprop:Generator_ColumnPropNameInTable="idxFaseColumn" msprop:Generator_ColumnPropNameInRow="idxFase" msprop:Generator_UserColumnName="idxFase" msprop:Generator_ColumnVarNameInTable="columnidxFase" type="xs:int" minOccurs="0" />
|
|
<xs:element name="nomeProj" msprop:Generator_ColumnPropNameInTable="nomeProjColumn" msprop:Generator_ColumnPropNameInRow="nomeProj" msprop:Generator_UserColumnName="nomeProj" msprop:Generator_ColumnVarNameInTable="columnnomeProj" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeFase" msprop:Generator_ColumnPropNameInTable="nomeFaseColumn" msprop:Generator_ColumnPropNameInRow="nomeFase" msprop:Generator_UserColumnName="nomeFase" msprop:Generator_ColumnVarNameInTable="columnnomeFase" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="freq" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="freqColumn" msprop:Generator_ColumnPropNameInRow="freq" msprop:Generator_UserColumnName="freq" msprop:Generator_ColumnVarNameInTable="columnfreq" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="qty" msprop:Generator_ColumnPropNameInTable="qtyColumn" msprop:Generator_ColumnPropNameInRow="qty" msprop:Generator_UserColumnName="qty" msprop:Generator_ColumnVarNameInTable="columnqty" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="tot" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="totColumn" msprop:Generator_ColumnPropNameInRow="tot" msprop:Generator_UserColumnName="tot" msprop:Generator_ColumnVarNameInTable="columntot" type="xs:int" minOccurs="0" />
|
|
<xs:element name="RowNum" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="RowNumColumn" msprop:Generator_ColumnPropNameInRow="RowNum" msprop:Generator_UserColumnName="RowNum" msprop:Generator_ColumnVarNameInTable="columnRowNum" type="xs:long" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selProjFasi" msprop:Generator_RowEvHandlerName="v_selProjFasiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selProjFasiRowDeleted" msprop:Generator_RowDeletingName="v_selProjFasiRowDeleting" msprop:Generator_RowEvArgName="v_selProjFasiRowChangeEvent" msprop:Generator_TablePropName="v_selProjFasi" msprop:Generator_RowChangedName="v_selProjFasiRowChanged" msprop:Generator_UserTableName="v_selProjFasi" msprop:Generator_RowChangingName="v_selProjFasiRowChanging" msprop:Generator_RowClassName="v_selProjFasiRow" msprop:Generator_TableClassName="v_selProjFasiDataTable" msprop:Generator_TableVarName="tablev_selProjFasi">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1315" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ordine" msprop:Generator_ColumnPropNameInTable="ordineColumn" msprop:Generator_ColumnPropNameInRow="ordine" msprop:Generator_UserColumnName="ordine" msprop:Generator_ColumnVarNameInTable="columnordine">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selListVal" msprop:Generator_RowEvHandlerName="v_selListValRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selListValRowDeleted" msprop:Generator_RowDeletingName="v_selListValRowDeleting" msprop:Generator_RowEvArgName="v_selListValRowChangeEvent" msprop:Generator_TablePropName="v_selListVal" msprop:Generator_RowChangedName="v_selListValRowChanged" msprop:Generator_UserTableName="v_selListVal" msprop:Generator_RowChangingName="v_selListValRowChanging" msprop:Generator_RowClassName="v_selListValRow" msprop:Generator_TableClassName="v_selListValDataTable" msprop:Generator_TableVarName="tablev_selListVal">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="112" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" 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_selGruppi" msprop:Generator_RowEvHandlerName="v_selGruppiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selGruppiRowDeleted" msprop:Generator_RowDeletingName="v_selGruppiRowDeleting" msprop:Generator_RowEvArgName="v_selGruppiRowChangeEvent" msprop:Generator_TablePropName="v_selGruppi" msprop:Generator_RowChangedName="v_selGruppiRowChanged" msprop:Generator_UserTableName="v_selGruppi" msprop:Generator_RowChangingName="v_selGruppiRowChanging" msprop:Generator_RowClassName="v_selGruppiRow" msprop:Generator_TableClassName="v_selGruppiDataTable" msprop:Generator_TableVarName="tablev_selGruppi">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_UserColumnName="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selTagFasi" msprop:Generator_RowEvHandlerName="v_selTagFasiRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selTagFasiRowDeleted" msprop:Generator_RowDeletingName="v_selTagFasiRowDeleting" msprop:Generator_RowEvArgName="v_selTagFasiRowChangeEvent" msprop:Generator_TablePropName="v_selTagFasi" msprop:Generator_RowChangedName="v_selTagFasiRowChanged" msprop:Generator_UserTableName="v_selTagFasi" msprop:Generator_RowChangingName="v_selTagFasiRowChanging" msprop:Generator_RowClassName="v_selTagFasiRow" msprop:Generator_TableClassName="v_selTagFasiDataTable" msprop:Generator_TableVarName="tablev_selTagFasi">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_UserColumnName="value" msprop:Generator_ColumnVarNameInTable="columnvalue">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_UserColumnName="label" msprop:Generator_ColumnVarNameInTable="columnlabel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selDipendenti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selProgetti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selProgetti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selFasi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selFasi" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selClienti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selClienti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selCodGiust_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selCodGiust" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selFasiOpt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selFasiOpt" />
|
|
<xs:field xpath="mstns:valueGroup" />
|
|
</xs:unique>
|
|
<xs:unique name="AnagKeyValue_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AnagKeyValue" />
|
|
<xs:field xpath="mstns:nomeVar" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selCodOrario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selCodOrario" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_VSProjFasi_search_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_VSProjFasi_search" />
|
|
<xs:field xpath="mstns:idxFase" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selGruppi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selGruppi" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selTagFasi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selTagFasi" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |