Samuele E. Locatelli
1339 lines
134 KiB
XML
1339 lines
134 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_utility" targetNamespace="http://tempuri.org/DS_utility.xsd" xmlns:mstns="http://tempuri.org/DS_utility.xsd" xmlns="http://tempuri.org/DS_utility.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="GIMConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="GIMConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.GIMConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GIMConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GIMConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GIM_dataLayer.Properties.Settings.GlobalReference.Default.GIMConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selImpiantiTableAdapter" GeneratorDataComponentClassName="v_selImpiantiTableAdapter" Name="v_selImpianti" UserDataComponentName="v_selImpiantiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selImpianti" 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 FROM dbo.v_selImpianti
|
|
order by label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selImpianti" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getImpiantiValidi" GetMethodModifier="Public" GetMethodName="getImpiantiValidi" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getImpiantiValidi" UserSourceName="getImpiantiValidi">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT label, value FROM v_selImpianti WHERE (value > 1) ORDER BY label</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selMacchineTableAdapter" GeneratorDataComponentClassName="v_selMacchineTableAdapter" Name="v_selMacchine" UserDataComponentName="v_selMacchineTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selMacchine" 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 dbo.v_selMacchine</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="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_VSM_avail4Tag" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="avail4tag" GetMethodModifier="Public" GetMethodName="avail4tag" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="avail4tag" UserSourceName="avail4tag">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSM_avail4Tag</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="@TagCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_VSM_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_VSM_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="int" DbType="Int32" Direction="Input" ParameterName="@conditio" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_VSM_getFull" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFull" GetMethodModifier="Public" GetMethodName="getFull" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFull" UserSourceName="getFull">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_VSM_getFull</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>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selPriorTableAdapter" GeneratorDataComponentClassName="v_selPriorTableAdapter" Name="v_selPrior" UserDataComponentName="v_selPriorTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selPrior" 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 value, label FROM dbo.v_selPrior</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_selAmbitiTableAdapter" GeneratorDataComponentClassName="v_selAmbitiTableAdapter" Name="v_selAmbiti" UserDataComponentName="v_selAmbitiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selAmbiti" 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 value, label
|
|
FROM v_selAmbiti
|
|
ORDER BY label</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_selCausaliMacchineTableAdapter" GeneratorDataComponentClassName="v_selCausaliMacchineTableAdapter" Name="v_selCausaliMacchine" UserDataComponentName="v_selCausaliMacchineTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selCausaliMacchine" 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 value, label, conditio FROM dbo.v_selCausaliMacchine</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="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_vscm_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_vscm_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="int" DbType="Int32" Direction="Input" ParameterName="@conditio" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_vscm_getByConditioAndCurr" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByConditioAndCurr" GetMethodModifier="Public" GetMethodName="getByConditioAndCurr" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByConditioAndCurr" UserSourceName="getByConditioAndCurr">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_vscm_getByConditioAndCurr</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="int" DbType="Int32" Direction="Input" ParameterName="@currVal" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selTipoGuastoTableAdapter" GeneratorDataComponentClassName="v_selTipoGuastoTableAdapter" Name="v_selTipoGuasto" UserDataComponentName="v_selTipoGuastoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selTipoGuasto" 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 value, label FROM dbo.v_selTipoGuasto</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_selSemaforiTableAdapter" GeneratorDataComponentClassName="v_selSemaforiTableAdapter" Name="v_selSemafori" UserDataComponentName="v_selSemaforiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selSemafori" 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 value, label FROM dbo.v_selSemafori</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_selFreqTableAdapter" GeneratorDataComponentClassName="v_selFreqTableAdapter" Name="v_selFreq" UserDataComponentName="v_selFreqTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selFreq" 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 value, label FROM dbo.v_selFreq</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_selStatoTableAdapter" GeneratorDataComponentClassName="v_selStatoTableAdapter" Name="v_selStato" UserDataComponentName="v_selStatoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selStato" 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 value, label FROM dbo.v_selStato</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_selPeriodiTradTableAdapter" GeneratorDataComponentClassName="v_selPeriodiTradTableAdapter" Name="v_selPeriodiTrad" UserDataComponentName="v_selPeriodiTradTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selPeriodiTrad" 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 dbo.v_selPeriodiTrad</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="conditio" DataSetColumn="conditio" />
|
|
<Mapping SourceColumn="unit" DataSetColumn="unit" />
|
|
<Mapping SourceColumn="val" DataSetColumn="val" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_vsp_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_vsp_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" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@tPeriodo" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_elencoImpiantiMacchineTableAdapter" GeneratorDataComponentClassName="v_elencoImpiantiMacchineTableAdapter" Name="v_elencoImpiantiMacchine" UserDataComponentName="v_elencoImpiantiMacchineTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_elencoImpiantiMacchine" 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 codImpianto, nomeImpianto, tipoImpianto, codMacchina, nomeMacchina, modello, matricola, anno, kgPeso, kwConsumo FROM dbo.v_elencoImpiantiMacchine</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="codImpianto" DataSetColumn="codImpianto" />
|
|
<Mapping SourceColumn="nomeImpianto" DataSetColumn="nomeImpianto" />
|
|
<Mapping SourceColumn="tipoImpianto" DataSetColumn="tipoImpianto" />
|
|
<Mapping SourceColumn="codMacchina" DataSetColumn="codMacchina" />
|
|
<Mapping SourceColumn="nomeMacchina" DataSetColumn="nomeMacchina" />
|
|
<Mapping SourceColumn="modello" DataSetColumn="modello" />
|
|
<Mapping SourceColumn="matricola" DataSetColumn="matricola" />
|
|
<Mapping SourceColumn="anno" DataSetColumn="anno" />
|
|
<Mapping SourceColumn="kgPeso" DataSetColumn="kgPeso" />
|
|
<Mapping SourceColumn="kwConsumo" DataSetColumn="kwConsumo" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_elencoIntervFiltTableAdapter" GeneratorDataComponentClassName="v_elencoIntervFiltTableAdapter" Name="v_elencoIntervFilt" UserDataComponentName="v_elencoIntervFiltTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_elencoIntervFilt" 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 numIntMtz, richiesta, codImpianto, nomeImpianto, codMacchina, nomeMacchina, descrizione, inizioIntervento, fineIntervento, descrizioneIntervento, descrCausale, guasto, idxStato, idxImpianto, idxMacchina, isFermo, scheduled FROM v_elencoIntervFilt</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="numIntMtz" DataSetColumn="numIntMtz" />
|
|
<Mapping SourceColumn="richiesta" DataSetColumn="richiesta" />
|
|
<Mapping SourceColumn="codImpianto" DataSetColumn="codImpianto" />
|
|
<Mapping SourceColumn="nomeImpianto" DataSetColumn="nomeImpianto" />
|
|
<Mapping SourceColumn="codMacchina" DataSetColumn="codMacchina" />
|
|
<Mapping SourceColumn="nomeMacchina" DataSetColumn="nomeMacchina" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="inizioIntervento" DataSetColumn="inizioIntervento" />
|
|
<Mapping SourceColumn="fineIntervento" DataSetColumn="fineIntervento" />
|
|
<Mapping SourceColumn="descrizioneIntervento" DataSetColumn="descrizioneIntervento" />
|
|
<Mapping SourceColumn="descrCausale" DataSetColumn="descrCausale" />
|
|
<Mapping SourceColumn="guasto" DataSetColumn="guasto" />
|
|
<Mapping SourceColumn="idxStato" DataSetColumn="idxStato" />
|
|
<Mapping SourceColumn="idxImpianto" DataSetColumn="idxImpianto" />
|
|
<Mapping SourceColumn="idxMacchina" DataSetColumn="idxMacchina" />
|
|
<Mapping SourceColumn="isFermo" DataSetColumn="isFermo" />
|
|
<Mapping SourceColumn="scheduled" DataSetColumn="scheduled" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_elencoIntByIntervDate" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIntervDate" GetMethodModifier="Public" GetMethodName="getByIntervDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIntervDate" UserSourceName="getByIntervDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_elencoIntByIntervDate</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="@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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_elencoIntByIntervDateUserFilt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIntervDateUsernameFilt" GetMethodModifier="Public" GetMethodName="getByIntervDateUsernameFilt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIntervDateUsernameFilt" UserSourceName="getByIntervDateUsernameFilt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_elencoIntByIntervDateUserFilt</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="@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="varchar" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_elencoIntByIntervDateUserFilt_fermaPrev" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByIntervDateUsernameFilt_fermaPrev" GetMethodModifier="Public" GetMethodName="getByIntervDateUsernameFilt_fermaPrev" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByIntervDateUsernameFilt_fermaPrev" UserSourceName="getByIntervDateUsernameFilt_fermaPrev">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_elencoIntByIntervDateUserFilt_fermaPrev</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="@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="varchar" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloMaccFerma" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@includiPreventiva" 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="sp_elencoIntMTBF_MTTRTableAdapter" GeneratorDataComponentClassName="sp_elencoIntMTBF_MTTRTableAdapter" Name="sp_elencoIntMTBF_MTTR" UserDataComponentName="sp_elencoIntMTBF_MTTRTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.sp_elencoIntMTBF_MTTR" 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.sp_elencoIntMTBF_MTTR</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="@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="varchar" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="numInterventi" DataSetColumn="numInterventi" />
|
|
<Mapping SourceColumn="totOreMtz" DataSetColumn="totOreMtz" />
|
|
<Mapping SourceColumn="totOreOfficina" DataSetColumn="totOreOfficina" />
|
|
<Mapping SourceColumn="codImpianto" DataSetColumn="codImpianto" />
|
|
<Mapping SourceColumn="codMacchina" DataSetColumn="codMacchina" />
|
|
<Mapping SourceColumn="nomeImpianto" DataSetColumn="nomeImpianto" />
|
|
<Mapping SourceColumn="nomeMacchina" DataSetColumn="nomeMacchina" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_elencoIntMTBF_MTTR_fermaPrev" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByFermaPrev" GetMethodModifier="Public" GetMethodName="getByFermaPrev" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByFermaPrev" UserSourceName="getByFermaPrev">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_elencoIntMTBF_MTTR_fermaPrev</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="@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="varchar" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@soloMaccFerma" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@includiPreventiva" 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_selFamTableAdapter" GeneratorDataComponentClassName="v_selFamTableAdapter" Name="v_selFam" UserDataComponentName="v_selFamTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selFam" 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 value, label FROM dbo.v_selFam</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_selOperMtzTableAdapter" GeneratorDataComponentClassName="v_selOperMtzTableAdapter" Name="v_selOperMtz" UserDataComponentName="v_selOperMtzTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selOperMtz" 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_selOperMtz</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selOperMtz" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByValue" GetMethodModifier="Public" GetMethodName="getByValue" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByValue" UserSourceName="getByValue">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM v_selOperMtz WHERE (value = @value)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="value" ColumnName="value" DataSourceName="GIM.dbo.v_selOperMtz" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@value" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="value" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_mtzProgPendingExpTableAdapter" GeneratorDataComponentClassName="v_mtzProgPendingExpTableAdapter" Name="v_mtzProgPendingExp" UserDataComponentName="v_mtzProgPendingExpTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_mtzProgPendingExp" 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 idxPending, codImpianto, nomeImpianto, codMacchina, nomeMacchina, data, descrizione, descrPriorita, isFermo, descrTipo, idxTipo, idxMacchina, idxImpianto
|
|
FROM v_mtzProgPendingExp</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxPending" DataSetColumn="idxPending" />
|
|
<Mapping SourceColumn="codImpianto" DataSetColumn="codImpianto" />
|
|
<Mapping SourceColumn="nomeImpianto" DataSetColumn="nomeImpianto" />
|
|
<Mapping SourceColumn="codMacchina" DataSetColumn="codMacchina" />
|
|
<Mapping SourceColumn="nomeMacchina" DataSetColumn="nomeMacchina" />
|
|
<Mapping SourceColumn="data" DataSetColumn="data" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="descrPriorita" DataSetColumn="descrPriorita" />
|
|
<Mapping SourceColumn="isFermo" DataSetColumn="isFermo" />
|
|
<Mapping SourceColumn="descrTipo" DataSetColumn="descrTipo" />
|
|
<Mapping SourceColumn="idxTipo" DataSetColumn="idxTipo" />
|
|
<Mapping SourceColumn="idxMacchina" DataSetColumn="idxMacchina" />
|
|
<Mapping SourceColumn="idxImpianto" DataSetColumn="idxImpianto" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_MPP_getByMaxData" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByDataMax" GetMethodModifier="Public" GetMethodName="getByDataMax" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByDataMax" UserSourceName="getByDataMax">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MPP_getByMaxData</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="@dataMax" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_MPP_getBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MPP_getBySearch</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="@ricerca" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxTipo" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxImpianto" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxMacchina" 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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selAnTipoRisTableAdapter" GeneratorDataComponentClassName="v_selAnTipoRisTableAdapter" Name="v_selAnTipoRis" UserDataComponentName="v_selAnTipoRisTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selAnTipoRis" 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 value, label FROM dbo.v_selAnTipoRis</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_selListValTableAdapter" GeneratorDataComponentClassName="v_selListValTableAdapter" Name="v_selListVal" UserDataComponentName="v_selListValTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.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="false" 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="GIMConnectionString (Settings)" DbObjectName="GIM.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>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_listValues_getValidValuesTrad" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTableFieldLang" GetMethodModifier="Public" GetMethodName="getByTableFieldLang" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTableFieldLang" UserSourceName="getByTableFieldLang">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_listValues_getValidValuesTrad</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" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Lingua" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ListValuesTableAdapter" GeneratorDataComponentClassName="ListValuesTableAdapter" Name="ListValues" UserDataComponentName="ListValuesTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.ListValues" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[ListValues] WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TableName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TableName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FieldName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FieldName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_value" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="value" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[ListValues] ([TableName], [FieldName], [value], [label], [ordinal]) VALUES (@TableName, @FieldName, @value, @label, @ordinal)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TableName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TableName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FieldName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FieldName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@value" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="value" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@label" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="label" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ordinal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ordinal" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT TableName, FieldName, value, label, ordinal FROM dbo.ListValues</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[ListValues] SET [TableName] = @TableName, [FieldName] = @FieldName, [value] = @value, [label] = @label, [ordinal] = @ordinal WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TableName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TableName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FieldName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FieldName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@value" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="value" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@label" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="label" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ordinal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ordinal" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TableName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TableName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FieldName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FieldName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_value" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="value" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="TableName" DataSetColumn="TableName" />
|
|
<Mapping SourceColumn="FieldName" DataSetColumn="FieldName" />
|
|
<Mapping SourceColumn="value" DataSetColumn="value" />
|
|
<Mapping SourceColumn="label" DataSetColumn="label" />
|
|
<Mapping SourceColumn="ordinal" DataSetColumn="ordinal" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_listValues_getByTable" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByTable" GetMethodModifier="Public" GetMethodName="getByTable" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByTable" UserSourceName="getByTable">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_listValues_getByTable</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" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_listValues_getDistTable" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getDistTableName" GetMethodModifier="Public" GetMethodName="getDistTableName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getDistTableName" UserSourceName="getDistTableName">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_listValues_getDistTable</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>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_selCodRicAmmTableAdapter" GeneratorDataComponentClassName="v_selCodRicAmmTableAdapter" Name="v_selCodRicAmm" UserDataComponentName="v_selCodRicAmmTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selCodRicAmm" 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 dbo.v_selCodRicAmm</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="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_scra_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_scra_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>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.stp_scra_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_scra_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="@CODINTERNO" 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_selGrpCodRicAmmTableAdapter" GeneratorDataComponentClassName="v_selGrpCodRicAmmTableAdapter" Name="v_selGrpCodRicAmm" UserDataComponentName="v_selGrpCodRicAmmTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GIMConnectionString (Settings)" DbObjectName="GIM.dbo.v_selGrpCodRicAmm" 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 FROM dbo.v_selGrpCodRicAmm
|
|
ORDER BY label</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_DataSetName="DS_utility" msprop:Generator_UserDSName="DS_utility">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="v_selImpianti" msprop:Generator_UserTableName="v_selImpianti" msprop:Generator_RowEvArgName="v_selImpiantiRowChangeEvent" msprop:Generator_TableVarName="tablev_selImpianti" msprop:Generator_TablePropName="v_selImpianti" msprop:Generator_RowDeletingName="v_selImpiantiRowDeleting" msprop:Generator_RowChangingName="v_selImpiantiRowChanging" msprop:Generator_RowDeletedName="v_selImpiantiRowDeleted" msprop:Generator_RowEvHandlerName="v_selImpiantiRowChangeEventHandler" msprop:Generator_TableClassName="v_selImpiantiDataTable" msprop:Generator_RowChangedName="v_selImpiantiRowChanged" msprop:Generator_RowClassName="v_selImpiantiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="156" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selMacchine" msprop:Generator_UserTableName="v_selMacchine" msprop:Generator_RowEvArgName="v_selMacchineRowChangeEvent" msprop:Generator_TableVarName="tablev_selMacchine" msprop:Generator_TablePropName="v_selMacchine" msprop:Generator_RowDeletingName="v_selMacchineRowDeleting" msprop:Generator_RowChangingName="v_selMacchineRowChanging" msprop:Generator_RowDeletedName="v_selMacchineRowDeleted" msprop:Generator_RowEvHandlerName="v_selMacchineRowChangeEventHandler" msprop:Generator_TableClassName="v_selMacchineDataTable" msprop:Generator_RowChangedName="v_selMacchineRowChanged" msprop:Generator_RowClassName="v_selMacchineRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="213" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selPrior" msprop:Generator_UserTableName="v_selPrior" msprop:Generator_RowEvArgName="v_selPriorRowChangeEvent" msprop:Generator_TableVarName="tablev_selPrior" msprop:Generator_TablePropName="v_selPrior" msprop:Generator_RowDeletingName="v_selPriorRowDeleting" msprop:Generator_RowChangingName="v_selPriorRowChanging" msprop:Generator_RowDeletedName="v_selPriorRowDeleted" msprop:Generator_RowEvHandlerName="v_selPriorRowChangeEventHandler" msprop:Generator_TableClassName="v_selPriorDataTable" msprop:Generator_RowChangedName="v_selPriorRowChanged" msprop:Generator_RowClassName="v_selPriorRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="57" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selAmbiti" msprop:Generator_UserTableName="v_selAmbiti" msprop:Generator_RowEvArgName="v_selAmbitiRowChangeEvent" msprop:Generator_TableVarName="tablev_selAmbiti" msprop:Generator_TablePropName="v_selAmbiti" msprop:Generator_RowDeletingName="v_selAmbitiRowDeleting" msprop:Generator_RowChangingName="v_selAmbitiRowChanging" msprop:Generator_RowDeletedName="v_selAmbitiRowDeleted" msprop:Generator_RowEvHandlerName="v_selAmbitiRowChangeEventHandler" msprop:Generator_TableClassName="v_selAmbitiDataTable" msprop:Generator_RowChangedName="v_selAmbitiRowChanged" msprop:Generator_RowClassName="v_selAmbitiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCausaliMacchine" msprop:Generator_UserTableName="v_selCausaliMacchine" msprop:Generator_RowEvArgName="v_selCausaliMacchineRowChangeEvent" msprop:Generator_TableVarName="tablev_selCausaliMacchine" msprop:Generator_TablePropName="v_selCausaliMacchine" msprop:Generator_RowDeletingName="v_selCausaliMacchineRowDeleting" msprop:Generator_RowChangingName="v_selCausaliMacchineRowChanging" msprop:Generator_RowDeletedName="v_selCausaliMacchineRowDeleted" msprop:Generator_RowEvHandlerName="v_selCausaliMacchineRowChangeEventHandler" msprop:Generator_TableClassName="v_selCausaliMacchineDataTable" msprop:Generator_RowChangedName="v_selCausaliMacchineRowChanged" msprop:Generator_RowClassName="v_selCausaliMacchineRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selTipoGuasto" msprop:Generator_UserTableName="v_selTipoGuasto" msprop:Generator_RowEvArgName="v_selTipoGuastoRowChangeEvent" msprop:Generator_TableVarName="tablev_selTipoGuasto" msprop:Generator_TablePropName="v_selTipoGuasto" msprop:Generator_RowDeletingName="v_selTipoGuastoRowDeleting" msprop:Generator_RowChangingName="v_selTipoGuastoRowChanging" msprop:Generator_RowDeletedName="v_selTipoGuastoRowDeleted" msprop:Generator_RowEvHandlerName="v_selTipoGuastoRowChangeEventHandler" msprop:Generator_TableClassName="v_selTipoGuastoDataTable" msprop:Generator_RowChangedName="v_selTipoGuastoRowChanged" msprop:Generator_RowClassName="v_selTipoGuastoRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selSemafori" msprop:Generator_UserTableName="v_selSemafori" msprop:Generator_RowEvArgName="v_selSemaforiRowChangeEvent" msprop:Generator_TableVarName="tablev_selSemafori" msprop:Generator_TablePropName="v_selSemafori" msprop:Generator_RowDeletingName="v_selSemaforiRowDeleting" msprop:Generator_RowChangingName="v_selSemaforiRowChanging" msprop:Generator_RowDeletedName="v_selSemaforiRowDeleted" msprop:Generator_RowEvHandlerName="v_selSemaforiRowChangeEventHandler" msprop:Generator_TableClassName="v_selSemaforiDataTable" msprop:Generator_RowChangedName="v_selSemaforiRowChanged" msprop:Generator_RowClassName="v_selSemaforiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selFreq" msprop:Generator_UserTableName="v_selFreq" msprop:Generator_RowEvArgName="v_selFreqRowChangeEvent" msprop:Generator_TableVarName="tablev_selFreq" msprop:Generator_TablePropName="v_selFreq" msprop:Generator_RowDeletingName="v_selFreqRowDeleting" msprop:Generator_RowChangingName="v_selFreqRowChanging" msprop:Generator_RowDeletedName="v_selFreqRowDeleted" msprop:Generator_RowEvHandlerName="v_selFreqRowChangeEventHandler" msprop:Generator_TableClassName="v_selFreqDataTable" msprop:Generator_RowChangedName="v_selFreqRowChanged" msprop:Generator_RowClassName="v_selFreqRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selStato" msprop:Generator_UserTableName="v_selStato" msprop:Generator_RowEvArgName="v_selStatoRowChangeEvent" msprop:Generator_TableVarName="tablev_selStato" msprop:Generator_TablePropName="v_selStato" msprop:Generator_RowDeletingName="v_selStatoRowDeleting" msprop:Generator_RowChangingName="v_selStatoRowChanging" msprop:Generator_RowDeletedName="v_selStatoRowDeleted" msprop:Generator_RowEvHandlerName="v_selStatoRowChangeEventHandler" msprop:Generator_TableClassName="v_selStatoDataTable" msprop:Generator_RowChangedName="v_selStatoRowChanged" msprop:Generator_RowClassName="v_selStatoRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selPeriodiTrad" msprop:Generator_UserTableName="v_selPeriodiTrad" msprop:Generator_RowEvArgName="v_selPeriodiTradRowChangeEvent" msprop:Generator_TableVarName="tablev_selPeriodiTrad" msprop:Generator_TablePropName="v_selPeriodiTrad" msprop:Generator_RowDeletingName="v_selPeriodiTradRowDeleting" msprop:Generator_RowChangingName="v_selPeriodiTradRowChanging" msprop:Generator_RowDeletedName="v_selPeriodiTradRowDeleted" msprop:Generator_RowEvHandlerName="v_selPeriodiTradRowChangeEventHandler" msprop:Generator_TableClassName="v_selPeriodiTradDataTable" msprop:Generator_RowChangedName="v_selPeriodiTradRowChanged" msprop:Generator_RowClassName="v_selPeriodiTradRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="unit" msprop:Generator_ColumnVarNameInTable="columnunit" msprop:Generator_ColumnPropNameInRow="unit" msprop:Generator_ColumnPropNameInTable="unitColumn" msprop:Generator_UserColumnName="unit">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="val" msprop:Generator_ColumnVarNameInTable="columnval" msprop:Generator_ColumnPropNameInRow="val" msprop:Generator_ColumnPropNameInTable="valColumn" msprop:Generator_UserColumnName="val" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_elencoImpiantiMacchine" msprop:Generator_UserTableName="v_elencoImpiantiMacchine" msprop:Generator_RowEvArgName="v_elencoImpiantiMacchineRowChangeEvent" msprop:Generator_TableVarName="tablev_elencoImpiantiMacchine" msprop:Generator_TablePropName="v_elencoImpiantiMacchine" msprop:Generator_RowDeletingName="v_elencoImpiantiMacchineRowDeleting" msprop:Generator_RowChangingName="v_elencoImpiantiMacchineRowChanging" msprop:Generator_RowDeletedName="v_elencoImpiantiMacchineRowDeleted" msprop:Generator_RowEvHandlerName="v_elencoImpiantiMacchineRowChangeEventHandler" msprop:Generator_TableClassName="v_elencoImpiantiMacchineDataTable" msprop:Generator_RowChangedName="v_elencoImpiantiMacchineRowChanged" msprop:Generator_RowClassName="v_elencoImpiantiMacchineRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="codImpianto" msprop:Generator_ColumnVarNameInTable="columncodImpianto" msprop:Generator_ColumnPropNameInRow="codImpianto" msprop:Generator_ColumnPropNameInTable="codImpiantoColumn" msprop:Generator_UserColumnName="codImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeImpianto" msprop:Generator_ColumnVarNameInTable="columnnomeImpianto" msprop:Generator_ColumnPropNameInRow="nomeImpianto" msprop:Generator_ColumnPropNameInTable="nomeImpiantoColumn" msprop:Generator_UserColumnName="nomeImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="tipoImpianto" msprop:Generator_ColumnVarNameInTable="columntipoImpianto" msprop:Generator_ColumnPropNameInRow="tipoImpianto" msprop:Generator_ColumnPropNameInTable="tipoImpiantoColumn" msprop:Generator_UserColumnName="tipoImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codMacchina" msprop:Generator_ColumnVarNameInTable="columncodMacchina" msprop:Generator_ColumnPropNameInRow="codMacchina" msprop:Generator_ColumnPropNameInTable="codMacchinaColumn" msprop:Generator_UserColumnName="codMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeMacchina" msprop:Generator_ColumnVarNameInTable="columnnomeMacchina" msprop:Generator_ColumnPropNameInRow="nomeMacchina" msprop:Generator_ColumnPropNameInTable="nomeMacchinaColumn" msprop:Generator_UserColumnName="nomeMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="modello" msprop:Generator_ColumnVarNameInTable="columnmodello" msprop:Generator_ColumnPropNameInRow="modello" msprop:Generator_ColumnPropNameInTable="modelloColumn" msprop:Generator_UserColumnName="modello" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="matricola" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmatricola" msprop:Generator_ColumnPropNameInRow="matricola" msprop:Generator_ColumnPropNameInTable="matricolaColumn" msprop:Generator_UserColumnName="matricola" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="anno" msprop:Generator_ColumnVarNameInTable="columnanno" msprop:Generator_ColumnPropNameInRow="anno" msprop:Generator_ColumnPropNameInTable="annoColumn" msprop:Generator_UserColumnName="anno" type="xs:int" minOccurs="0" />
|
|
<xs:element name="kgPeso" msprop:Generator_ColumnVarNameInTable="columnkgPeso" msprop:Generator_ColumnPropNameInRow="kgPeso" msprop:Generator_ColumnPropNameInTable="kgPesoColumn" msprop:Generator_UserColumnName="kgPeso" type="xs:double" />
|
|
<xs:element name="kwConsumo" msprop:Generator_ColumnVarNameInTable="columnkwConsumo" msprop:Generator_ColumnPropNameInRow="kwConsumo" msprop:Generator_ColumnPropNameInTable="kwConsumoColumn" msprop:Generator_UserColumnName="kwConsumo" type="xs:double" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_elencoIntervFilt" msprop:Generator_UserTableName="v_elencoIntervFilt" msprop:Generator_RowEvArgName="v_elencoIntervFiltRowChangeEvent" msprop:Generator_TableVarName="tablev_elencoIntervFilt" msprop:Generator_TablePropName="v_elencoIntervFilt" msprop:Generator_RowDeletingName="v_elencoIntervFiltRowDeleting" msprop:Generator_RowChangingName="v_elencoIntervFiltRowChanging" msprop:Generator_RowDeletedName="v_elencoIntervFiltRowDeleted" msprop:Generator_RowEvHandlerName="v_elencoIntervFiltRowChangeEventHandler" msprop:Generator_TableClassName="v_elencoIntervFiltDataTable" msprop:Generator_RowChangedName="v_elencoIntervFiltRowChanged" msprop:Generator_RowClassName="v_elencoIntervFiltRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="numIntMtz" msprop:Generator_ColumnVarNameInTable="columnnumIntMtz" msprop:Generator_ColumnPropNameInRow="numIntMtz" msprop:Generator_ColumnPropNameInTable="numIntMtzColumn" msprop:Generator_UserColumnName="numIntMtz" type="xs:int" />
|
|
<xs:element name="richiesta" msprop:Generator_ColumnVarNameInTable="columnrichiesta" msprop:Generator_ColumnPropNameInRow="richiesta" msprop:Generator_ColumnPropNameInTable="richiestaColumn" msprop:Generator_UserColumnName="richiesta" type="xs:dateTime" />
|
|
<xs:element name="codImpianto" msprop:Generator_ColumnVarNameInTable="columncodImpianto" msprop:Generator_ColumnPropNameInRow="codImpianto" msprop:Generator_ColumnPropNameInTable="codImpiantoColumn" msprop:Generator_UserColumnName="codImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeImpianto" msprop:Generator_ColumnVarNameInTable="columnnomeImpianto" msprop:Generator_ColumnPropNameInRow="nomeImpianto" msprop:Generator_ColumnPropNameInTable="nomeImpiantoColumn" msprop:Generator_UserColumnName="nomeImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codMacchina" msprop:Generator_ColumnVarNameInTable="columncodMacchina" msprop:Generator_ColumnPropNameInRow="codMacchina" msprop:Generator_ColumnPropNameInTable="codMacchinaColumn" msprop:Generator_UserColumnName="codMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeMacchina" msprop:Generator_ColumnVarNameInTable="columnnomeMacchina" msprop:Generator_ColumnPropNameInRow="nomeMacchina" msprop:Generator_ColumnPropNameInTable="nomeMacchinaColumn" msprop:Generator_UserColumnName="nomeMacchina" 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_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="inizioIntervento" msprop:Generator_ColumnVarNameInTable="columninizioIntervento" msprop:Generator_ColumnPropNameInRow="inizioIntervento" msprop:Generator_ColumnPropNameInTable="inizioInterventoColumn" msprop:Generator_UserColumnName="inizioIntervento" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="fineIntervento" msprop:Generator_ColumnVarNameInTable="columnfineIntervento" msprop:Generator_ColumnPropNameInRow="fineIntervento" msprop:Generator_ColumnPropNameInTable="fineInterventoColumn" msprop:Generator_UserColumnName="fineIntervento" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="descrizioneIntervento" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndescrizioneIntervento" msprop:Generator_ColumnPropNameInRow="descrizioneIntervento" msprop:Generator_ColumnPropNameInTable="descrizioneInterventoColumn" msprop:Generator_UserColumnName="descrizioneIntervento" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrCausale" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndescrCausale" msprop:Generator_ColumnPropNameInRow="descrCausale" msprop:Generator_ColumnPropNameInTable="descrCausaleColumn" msprop:Generator_UserColumnName="descrCausale" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="minErogati" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnminErogati" msprop:Generator_ColumnPropNameInRow="minErogati" msprop:Generator_ColumnPropNameInTable="minErogatiColumn" msprop:Generator_UserColumnName="minErogati" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="durataMtz" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndurataMtz" msprop:Generator_ColumnPropNameInRow="durataMtz" msprop:Generator_ColumnPropNameInTable="durataMtzColumn" msprop:Generator_UserColumnName="durataMtz" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="durataOff" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndurataOff" msprop:Generator_ColumnPropNameInRow="durataOff" msprop:Generator_ColumnPropNameInTable="durataOffColumn" msprop:Generator_UserColumnName="durataOff" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="guasto" msprop:Generator_ColumnVarNameInTable="columnguasto" msprop:Generator_ColumnPropNameInRow="guasto" msprop:Generator_ColumnPropNameInTable="guastoColumn" msprop:Generator_UserColumnName="guasto" type="xs:dateTime" />
|
|
<xs:element name="idxStato" msprop:Generator_ColumnVarNameInTable="columnidxStato" msprop:Generator_ColumnPropNameInRow="idxStato" msprop:Generator_ColumnPropNameInTable="idxStatoColumn" msprop:Generator_UserColumnName="idxStato" type="xs:int" />
|
|
<xs:element name="idxImpianto" msprop:Generator_ColumnVarNameInTable="columnidxImpianto" msprop:Generator_ColumnPropNameInRow="idxImpianto" msprop:Generator_ColumnPropNameInTable="idxImpiantoColumn" msprop:Generator_UserColumnName="idxImpianto" type="xs:int" />
|
|
<xs:element name="idxMacchina" msprop:Generator_ColumnVarNameInTable="columnidxMacchina" msprop:Generator_ColumnPropNameInRow="idxMacchina" msprop:Generator_ColumnPropNameInTable="idxMacchinaColumn" msprop:Generator_UserColumnName="idxMacchina" type="xs:int" />
|
|
<xs:element name="isFermo" msprop:Generator_ColumnVarNameInTable="columnisFermo" msprop:Generator_ColumnPropNameInRow="isFermo" msprop:Generator_ColumnPropNameInTable="isFermoColumn" msprop:Generator_UserColumnName="isFermo" type="xs:boolean" />
|
|
<xs:element name="scheduled" msprop:Generator_ColumnVarNameInTable="columnscheduled" msprop:Generator_ColumnPropNameInRow="scheduled" msprop:Generator_ColumnPropNameInTable="scheduledColumn" msprop:Generator_UserColumnName="scheduled" type="xs:boolean" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="sp_elencoIntMTBF_MTTR" msprop:Generator_UserTableName="sp_elencoIntMTBF_MTTR" msprop:Generator_RowEvArgName="sp_elencoIntMTBF_MTTRRowChangeEvent" msprop:Generator_TableVarName="tablesp_elencoIntMTBF_MTTR" msprop:Generator_TablePropName="sp_elencoIntMTBF_MTTR" msprop:Generator_RowDeletingName="sp_elencoIntMTBF_MTTRRowDeleting" msprop:Generator_RowChangingName="sp_elencoIntMTBF_MTTRRowChanging" msprop:Generator_RowDeletedName="sp_elencoIntMTBF_MTTRRowDeleted" msprop:Generator_RowEvHandlerName="sp_elencoIntMTBF_MTTRRowChangeEventHandler" msprop:Generator_TableClassName="sp_elencoIntMTBF_MTTRDataTable" msprop:Generator_RowChangedName="sp_elencoIntMTBF_MTTRRowChanged" msprop:Generator_RowClassName="sp_elencoIntMTBF_MTTRRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="numInterventi" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnumInterventi" msprop:Generator_ColumnPropNameInRow="numInterventi" msprop:Generator_ColumnPropNameInTable="numInterventiColumn" msprop:Generator_UserColumnName="numInterventi" type="xs:int" minOccurs="0" />
|
|
<xs:element name="totOreMtz" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntotOreMtz" msprop:Generator_ColumnPropNameInRow="totOreMtz" msprop:Generator_ColumnPropNameInTable="totOreMtzColumn" msprop:Generator_UserColumnName="totOreMtz" type="xs:int" minOccurs="0" />
|
|
<xs:element name="totOreOfficina" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntotOreOfficina" msprop:Generator_ColumnPropNameInRow="totOreOfficina" msprop:Generator_ColumnPropNameInTable="totOreOfficinaColumn" msprop:Generator_UserColumnName="totOreOfficina" type="xs:int" minOccurs="0" />
|
|
<xs:element name="codImpianto" msprop:Generator_ColumnVarNameInTable="columncodImpianto" msprop:Generator_ColumnPropNameInRow="codImpianto" msprop:Generator_ColumnPropNameInTable="codImpiantoColumn" msprop:Generator_UserColumnName="codImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codMacchina" msprop:Generator_ColumnVarNameInTable="columncodMacchina" msprop:Generator_ColumnPropNameInRow="codMacchina" msprop:Generator_ColumnPropNameInTable="codMacchinaColumn" msprop:Generator_UserColumnName="codMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeImpianto" msprop:Generator_ColumnVarNameInTable="columnnomeImpianto" msprop:Generator_ColumnPropNameInRow="nomeImpianto" msprop:Generator_ColumnPropNameInTable="nomeImpiantoColumn" msprop:Generator_UserColumnName="nomeImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeMacchina" msprop:Generator_ColumnVarNameInTable="columnnomeMacchina" msprop:Generator_ColumnPropNameInRow="nomeMacchina" msprop:Generator_ColumnPropNameInTable="nomeMacchinaColumn" msprop:Generator_UserColumnName="nomeMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selFam" msprop:Generator_UserTableName="v_selFam" msprop:Generator_RowEvArgName="v_selFamRowChangeEvent" msprop:Generator_TableVarName="tablev_selFam" msprop:Generator_TablePropName="v_selFam" msprop:Generator_RowDeletingName="v_selFamRowDeleting" msprop:Generator_RowChangingName="v_selFamRowChanging" msprop:Generator_RowDeletedName="v_selFamRowDeleted" msprop:Generator_RowEvHandlerName="v_selFamRowChangeEventHandler" msprop:Generator_TableClassName="v_selFamDataTable" msprop:Generator_RowChangedName="v_selFamRowChanged" msprop:Generator_RowClassName="v_selFamRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" type="xs:int" />
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selOperMtz" msprop:Generator_UserTableName="v_selOperMtz" msprop:Generator_RowEvArgName="v_selOperMtzRowChangeEvent" msprop:Generator_TableVarName="tablev_selOperMtz" msprop:Generator_TablePropName="v_selOperMtz" msprop:Generator_RowDeletingName="v_selOperMtzRowDeleting" msprop:Generator_RowChangingName="v_selOperMtzRowChanging" msprop:Generator_RowDeletedName="v_selOperMtzRowDeleted" msprop:Generator_RowEvHandlerName="v_selOperMtzRowChangeEventHandler" msprop:Generator_TableClassName="v_selOperMtzDataTable" msprop:Generator_RowChangedName="v_selOperMtzRowChanged" msprop:Generator_RowClassName="v_selOperMtzRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="101" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_mtzProgPendingExp" msprop:Generator_UserTableName="v_mtzProgPendingExp" msprop:Generator_RowEvArgName="v_mtzProgPendingExpRowChangeEvent" msprop:Generator_TableVarName="tablev_mtzProgPendingExp" msprop:Generator_TablePropName="v_mtzProgPendingExp" msprop:Generator_RowDeletingName="v_mtzProgPendingExpRowDeleting" msprop:Generator_RowChangingName="v_mtzProgPendingExpRowChanging" msprop:Generator_RowDeletedName="v_mtzProgPendingExpRowDeleted" msprop:Generator_RowEvHandlerName="v_mtzProgPendingExpRowChangeEventHandler" msprop:Generator_TableClassName="v_mtzProgPendingExpDataTable" msprop:Generator_RowChangedName="v_mtzProgPendingExpRowChanged" msprop:Generator_RowClassName="v_mtzProgPendingExpRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxPending" msprop:Generator_ColumnVarNameInTable="columnidxPending" msprop:Generator_ColumnPropNameInRow="idxPending" msprop:Generator_ColumnPropNameInTable="idxPendingColumn" msprop:Generator_UserColumnName="idxPending" type="xs:int" />
|
|
<xs:element name="codImpianto" msprop:Generator_ColumnVarNameInTable="columncodImpianto" msprop:Generator_ColumnPropNameInRow="codImpianto" msprop:Generator_ColumnPropNameInTable="codImpiantoColumn" msprop:Generator_UserColumnName="codImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeImpianto" msprop:Generator_ColumnVarNameInTable="columnnomeImpianto" msprop:Generator_ColumnPropNameInRow="nomeImpianto" msprop:Generator_ColumnPropNameInTable="nomeImpiantoColumn" msprop:Generator_UserColumnName="nomeImpianto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="codMacchina" msprop:Generator_ColumnVarNameInTable="columncodMacchina" msprop:Generator_ColumnPropNameInRow="codMacchina" msprop:Generator_ColumnPropNameInTable="codMacchinaColumn" msprop:Generator_UserColumnName="codMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeMacchina" msprop:Generator_ColumnVarNameInTable="columnnomeMacchina" msprop:Generator_ColumnPropNameInRow="nomeMacchina" msprop:Generator_ColumnPropNameInTable="nomeMacchinaColumn" msprop:Generator_UserColumnName="nomeMacchina" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="data" msprop:Generator_ColumnVarNameInTable="columndata" msprop:Generator_ColumnPropNameInRow="data" msprop:Generator_ColumnPropNameInTable="dataColumn" msprop:Generator_UserColumnName="data" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="descrizione" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descrPriorita" msprop:Generator_ColumnVarNameInTable="columndescrPriorita" msprop:Generator_ColumnPropNameInRow="descrPriorita" msprop:Generator_ColumnPropNameInTable="descrPrioritaColumn" msprop:Generator_UserColumnName="descrPriorita" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="isFermo" msprop:Generator_ColumnVarNameInTable="columnisFermo" msprop:Generator_ColumnPropNameInRow="isFermo" msprop:Generator_ColumnPropNameInTable="isFermoColumn" msprop:Generator_UserColumnName="isFermo" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="descrTipo" msprop:Generator_ColumnVarNameInTable="columndescrTipo" msprop:Generator_ColumnPropNameInRow="descrTipo" msprop:Generator_ColumnPropNameInTable="descrTipoColumn" msprop:Generator_UserColumnName="descrTipo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idxTipo" msprop:Generator_ColumnVarNameInTable="columnidxTipo" msprop:Generator_ColumnPropNameInRow="idxTipo" msprop:Generator_ColumnPropNameInTable="idxTipoColumn" msprop:Generator_UserColumnName="idxTipo" type="xs:int" />
|
|
<xs:element name="idxMacchina" msprop:Generator_ColumnVarNameInTable="columnidxMacchina" msprop:Generator_ColumnPropNameInRow="idxMacchina" msprop:Generator_ColumnPropNameInTable="idxMacchinaColumn" msprop:Generator_UserColumnName="idxMacchina" type="xs:int" />
|
|
<xs:element name="idxImpianto" msprop:Generator_ColumnVarNameInTable="columnidxImpianto" msprop:Generator_ColumnPropNameInRow="idxImpianto" msprop:Generator_ColumnPropNameInTable="idxImpiantoColumn" msprop:Generator_UserColumnName="idxImpianto" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selAnTipoRis" msprop:Generator_TableClassName="v_selAnTipoRisDataTable" msprop:Generator_TableVarName="tablev_selAnTipoRis" msprop:Generator_RowChangedName="v_selAnTipoRisRowChanged" msprop:Generator_TablePropName="v_selAnTipoRis" msprop:Generator_RowDeletingName="v_selAnTipoRisRowDeleting" msprop:Generator_RowChangingName="v_selAnTipoRisRowChanging" msprop:Generator_RowEvHandlerName="v_selAnTipoRisRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selAnTipoRisRowDeleted" msprop:Generator_RowClassName="v_selAnTipoRisRow" msprop:Generator_UserTableName="v_selAnTipoRis" msprop:Generator_RowEvArgName="v_selAnTipoRisRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="63" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selListVal" msprop:Generator_TableClassName="v_selListValDataTable" msprop:Generator_TableVarName="tablev_selListVal" msprop:Generator_TablePropName="v_selListVal" msprop:Generator_RowDeletingName="v_selListValRowDeleting" msprop:Generator_RowChangingName="v_selListValRowChanging" msprop:Generator_RowEvHandlerName="v_selListValRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selListValRowDeleted" msprop:Generator_UserTableName="v_selListVal" msprop:Generator_RowChangedName="v_selListValRowChanged" msprop:Generator_RowEvArgName="v_selListValRowChangeEvent" msprop:Generator_RowClassName="v_selListValRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="112" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ListValues" msprop:Generator_TableClassName="ListValuesDataTable" msprop:Generator_TableVarName="tableListValues" msprop:Generator_TablePropName="ListValues" msprop:Generator_RowDeletingName="ListValuesRowDeleting" msprop:Generator_RowChangingName="ListValuesRowChanging" msprop:Generator_RowEvHandlerName="ListValuesRowChangeEventHandler" msprop:Generator_RowDeletedName="ListValuesRowDeleted" msprop:Generator_UserTableName="ListValues" msprop:Generator_RowChangedName="ListValuesRowChanged" msprop:Generator_RowEvArgName="ListValuesRowChangeEvent" msprop:Generator_RowClassName="ListValuesRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="TableName" msprop:Generator_ColumnVarNameInTable="columnTableName" msprop:Generator_ColumnPropNameInRow="TableName" msprop:Generator_ColumnPropNameInTable="TableNameColumn" msprop:Generator_UserColumnName="TableName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FieldName" msprop:Generator_ColumnVarNameInTable="columnFieldName" msprop:Generator_ColumnPropNameInRow="FieldName" msprop:Generator_ColumnPropNameInTable="FieldNameColumn" msprop:Generator_UserColumnName="FieldName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ordinal" msprop:Generator_ColumnVarNameInTable="columnordinal" msprop:Generator_ColumnPropNameInRow="ordinal" msprop:Generator_ColumnPropNameInTable="ordinalColumn" msprop:Generator_UserColumnName="ordinal" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="v_selCodRicAmm" msprop:Generator_TableClassName="v_selCodRicAmmDataTable" msprop:Generator_TableVarName="tablev_selCodRicAmm" msprop:Generator_TablePropName="v_selCodRicAmm" msprop:Generator_RowDeletingName="v_selCodRicAmmRowDeleting" msprop:Generator_RowChangingName="v_selCodRicAmmRowChanging" msprop:Generator_RowEvHandlerName="v_selCodRicAmmRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selCodRicAmmRowDeleted" msprop:Generator_UserTableName="v_selCodRicAmm" msprop:Generator_RowChangedName="v_selCodRicAmmRowChanged" msprop:Generator_RowEvArgName="v_selCodRicAmmRowChangeEvent" msprop:Generator_RowClassName="v_selCodRicAmmRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="conditio" msprop:Generator_ColumnVarNameInTable="columnconditio" msprop:Generator_ColumnPropNameInRow="conditio" msprop:Generator_ColumnPropNameInTable="conditioColumn" msprop:Generator_UserColumnName="conditio" 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_selGrpCodRicAmm" msprop:Generator_TableClassName="v_selGrpCodRicAmmDataTable" msprop:Generator_TableVarName="tablev_selGrpCodRicAmm" msprop:Generator_TablePropName="v_selGrpCodRicAmm" msprop:Generator_RowDeletingName="v_selGrpCodRicAmmRowDeleting" msprop:Generator_RowChangingName="v_selGrpCodRicAmmRowChanging" msprop:Generator_RowEvHandlerName="v_selGrpCodRicAmmRowChangeEventHandler" msprop:Generator_RowDeletedName="v_selGrpCodRicAmmRowDeleted" msprop:Generator_UserTableName="v_selGrpCodRicAmm" msprop:Generator_RowChangedName="v_selGrpCodRicAmmRowChanged" msprop:Generator_RowEvArgName="v_selGrpCodRicAmmRowChangeEvent" msprop:Generator_RowClassName="v_selGrpCodRicAmmRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="value" msprop:Generator_ColumnVarNameInTable="columnvalue" msprop:Generator_ColumnPropNameInRow="value" msprop:Generator_ColumnPropNameInTable="valueColumn" msprop:Generator_UserColumnName="value" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="label" msprop:Generator_ColumnVarNameInTable="columnlabel" msprop:Generator_ColumnPropNameInRow="label" msprop:Generator_ColumnPropNameInTable="labelColumn" msprop:Generator_UserColumnName="label" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="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_selImpianti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selMacchine_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selMacchine" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selPrior_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selPrior" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selAmbiti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selAmbiti" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selTipoGuasto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selTipoGuasto" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selSemafori_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selSemafori" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selFreq_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selFreq" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selStato_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selStato" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selPeriodiTradKey1">
|
|
<xs:selector xpath=".//mstns:v_selPeriodiTrad" />
|
|
<xs:field xpath="mstns:value" />
|
|
<xs:field xpath="mstns:conditio" />
|
|
</xs:unique>
|
|
<xs:unique name="v_elencoIntervFilt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_elencoIntervFilt" />
|
|
<xs:field xpath="mstns:numIntMtz" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selFam_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selFam" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selOperMtz_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selOperMtz" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selAnTipoRis_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selAnTipoRis" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="ListValues_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ListValues" />
|
|
<xs:field xpath="mstns:TableName" />
|
|
<xs:field xpath="mstns:FieldName" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
<xs:unique name="v_selCodRicAmm_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:v_selCodRicAmm" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |