Samuele E. Locatelli
1378 lines
157 KiB
XML
1378 lines
157 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Plan" targetNamespace="http://tempuri.org/DS_Plan.xsd" xmlns:mstns="http://tempuri.org/DS_Plan.xsd" xmlns="http://tempuri.org/DS_Plan.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MoonPro_ES3ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MoonPro_ES3ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MapoDb.Properties.Settings.GlobalReference.Default.MoonPro_ES3ConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="planStatsGlobalTableAdapter" GeneratorDataComponentClassName="planStatsGlobalTableAdapter" Name="planStatsGlobal" UserDataComponentName="planStatsGlobalTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_planStatsGlobal" 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_planStatsGlobal</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="NumRows" DataSetColumn="NumRows" />
|
|
<Mapping SourceColumn="NumGrp" DataSetColumn="NumGrp" />
|
|
<Mapping SourceColumn="NumMacc" DataSetColumn="NumMacc" />
|
|
<Mapping SourceColumn="NumCli" DataSetColumn="NumCli" />
|
|
<Mapping SourceColumn="NumArt" DataSetColumn="NumArt" />
|
|
<Mapping SourceColumn="TotOreRich" DataSetColumn="TotOreRich" />
|
|
<Mapping SourceColumn="TotOrePlan" DataSetColumn="TotOrePlan" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PSG_filt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFilt" GetMethodModifier="Public" GetMethodName="getFilt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFilt" UserSourceName="getFilt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PSG_filt</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="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" 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="planStatsArtTableAdapter" GeneratorDataComponentClassName="planStatsArtTableAdapter" Name="planStatsArt" UserDataComponentName="planStatsArtTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_planStatsArt" 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_planStatsArt
|
|
ORDER BY TotOreRich DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="TotOreRich" DataSetColumn="TotOreRich" />
|
|
<Mapping SourceColumn="TotOrePlan" DataSetColumn="TotOrePlan" />
|
|
<Mapping SourceColumn="TotQty" DataSetColumn="TotQty" />
|
|
<Mapping SourceColumn="Disegno" DataSetColumn="Disegno" />
|
|
<Mapping SourceColumn="DescArticolo" DataSetColumn="DescArticolo" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PSA_filt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFilt" GetMethodModifier="Public" GetMethodName="getFilt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFilt" UserSourceName="getFilt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PSA_filt</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="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="planStatsGroupTableAdapter" GeneratorDataComponentClassName="planStatsGroupTableAdapter" Name="planStatsGroup" UserDataComponentName="planStatsGroupTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_planStatsGroup" 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_planStatsGroup
|
|
ORDER BY TotOreRich DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodGruppo" DataSetColumn="CodGruppo" />
|
|
<Mapping SourceColumn="TotOreRich" DataSetColumn="TotOreRich" />
|
|
<Mapping SourceColumn="TotOrePlan" DataSetColumn="TotOrePlan" />
|
|
<Mapping SourceColumn="TotQty" DataSetColumn="TotQty" />
|
|
<Mapping SourceColumn="DescrGruppo" DataSetColumn="DescrGruppo" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="planStatsMaccTableAdapter" GeneratorDataComponentClassName="planStatsMaccTableAdapter" Name="planStatsMacc" UserDataComponentName="planStatsMaccTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_planStatsMacc" 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_planStatsMacc
|
|
ORDER BY TotOreRich DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="TotOreRich" DataSetColumn="TotOreRich" />
|
|
<Mapping SourceColumn="TotOrePlan" DataSetColumn="TotOrePlan" />
|
|
<Mapping SourceColumn="TotQty" DataSetColumn="TotQty" />
|
|
<Mapping SourceColumn="DescrMacc" DataSetColumn="DescrMacc" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PSM_filt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFilt" GetMethodModifier="Public" GetMethodName="getFilt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFilt" UserSourceName="getFilt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PSM_filt</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="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RichiesteTableAdapter" GeneratorDataComponentClassName="RichiesteTableAdapter" Name="Richieste" UserDataComponentName="RichiesteTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_RichiesteAperte" 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 idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, NoteRichiesta, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note, CodCliente, flgPromDirty, DateAllOdlClose,
|
|
DescrGruppo, nomeMacc, DescrMacc, Disegno, DescArticolo, DescCliente, TC50p, TC_Type, TotMinuti, TotQty, QtaRem
|
|
FROM v_RichiesteAperte</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxPromessa" DataSetColumn="idxPromessa" />
|
|
<Mapping SourceColumn="TC_type" DataSetColumn="TC_type" />
|
|
<Mapping SourceColumn="KeyRichiesta" DataSetColumn="KeyRichiesta" />
|
|
<Mapping SourceColumn="KeyBCode" DataSetColumn="KeyBCode" />
|
|
<Mapping SourceColumn="Attivabile" DataSetColumn="Attivabile" />
|
|
<Mapping SourceColumn="IdxODL" DataSetColumn="IdxODL" />
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="NoteRichiesta" DataSetColumn="NoteRichiesta" />
|
|
<Mapping SourceColumn="CodGruppo" DataSetColumn="CodGruppo" />
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="NumPezzi" DataSetColumn="NumPezzi" />
|
|
<Mapping SourceColumn="TCAssegnato" DataSetColumn="TCAssegnato" />
|
|
<Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
|
|
<Mapping SourceColumn="Priorita" DataSetColumn="Priorita" />
|
|
<Mapping SourceColumn="PzPallet" DataSetColumn="PzPallet" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="flgPromDirty" DataSetColumn="flgPromDirty" />
|
|
<Mapping SourceColumn="DateAllOdlClose" DataSetColumn="DateAllOdlClose" />
|
|
<Mapping SourceColumn="DescrGruppo" DataSetColumn="DescrGruppo" />
|
|
<Mapping SourceColumn="nomeMacc" DataSetColumn="nomeMacc" />
|
|
<Mapping SourceColumn="DescrMacc" DataSetColumn="DescrMacc" />
|
|
<Mapping SourceColumn="Disegno" DataSetColumn="Disegno" />
|
|
<Mapping SourceColumn="DescArticolo" DataSetColumn="DescArticolo" />
|
|
<Mapping SourceColumn="DescCliente" DataSetColumn="DescCliente" />
|
|
<Mapping SourceColumn="TC50p" DataSetColumn="TC50p" />
|
|
<Mapping SourceColumn="TC_Type" DataSetColumn="TC_Type" />
|
|
<Mapping SourceColumn="TotMinuti" DataSetColumn="TotMinuti" />
|
|
<Mapping SourceColumn="TotQty" DataSetColumn="TotQty" />
|
|
<Mapping SourceColumn="QtaRem" DataSetColumn="QtaRem" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_IST_alloca" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="allocaIst" Modifier="Public" Name="allocaIst" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="allocaIst">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IST_alloca</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="@idxPromessaIn" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxPromessaOut" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QtyEv" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_IST_approva" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="approvaRich" Modifier="Public" Name="approvaRich" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="approvaRich">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IST_approva</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="@idxPromessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numPezzi" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_IST_grp" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="creaGrp" Modifier="Public" Name="creaGrp" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="creaGrp">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_IST_grp</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="@idxPromessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserMod" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QtaTot" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_Richieste_filt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFilt" GetMethodModifier="Public" GetMethodName="getFilt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFilt" UserSourceName="getFilt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_Richieste_filt</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="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" 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="PromesseINTableAdapter" GeneratorDataComponentClassName="PromesseINTableAdapter" Name="PromesseIN" UserDataComponentName="PromesseINTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.PromesseIN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[PromesseIN] WHERE (([idxPromessa] = @Original_idxPromessa) AND ([KeyRichiesta] = @Original_KeyRichiesta) AND ([KeyBCode] = @Original_KeyBCode) AND ([Attivabile] = @Original_Attivabile) AND ([IdxODL] = @Original_IdxODL) AND ([CodArticolo] = @Original_CodArticolo) AND ([CodGruppo] = @Original_CodGruppo) AND ([IdxMacchina] = @Original_IdxMacchina) AND ([NumPezzi] = @Original_NumPezzi) AND ([TCAssegnato] = @Original_TCAssegnato) AND ([DueDate] = @Original_DueDate) AND ([Priorita] = @Original_Priorita) AND ([PzPallet] = @Original_PzPallet) AND ([Note] = @Original_Note))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxPromessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxPromessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyRichiesta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyRichiesta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyBCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyBCode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Attivabile" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivabile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxODL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxODL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxMacchina" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumPezzi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumPezzi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TCAssegnato" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="TCAssegnato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priorita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PzPallet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PzPallet" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[PromesseIN] ([KeyRichiesta], [KeyBCode], [Attivabile], [IdxODL], [CodArticolo], [CodGruppo], [IdxMacchina], [NumPezzi], [TCAssegnato], [DueDate], [Priorita], [PzPallet], [Note]) VALUES (@KeyRichiesta, @KeyBCode, @Attivabile, @IdxODL, @CodArticolo, @CodGruppo, @IdxMacchina, @NumPezzi, @TCAssegnato, @DueDate, @Priorita, @PzPallet, @Note);
|
|
SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note FROM PromesseIN WHERE (idxPromessa = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyRichiesta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyRichiesta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyBCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyBCode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Attivabile" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivabile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxODL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxODL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumPezzi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumPezzi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TCAssegnato" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="TCAssegnato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priorita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PzPallet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PzPallet" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note FROM dbo.PromesseIN</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[PromesseIN] SET [KeyRichiesta] = @KeyRichiesta, [KeyBCode] = @KeyBCode, [Attivabile] = @Attivabile, [IdxODL] = @IdxODL, [CodArticolo] = @CodArticolo, [CodGruppo] = @CodGruppo, [IdxMacchina] = @IdxMacchina, [NumPezzi] = @NumPezzi, [TCAssegnato] = @TCAssegnato, [DueDate] = @DueDate, [Priorita] = @Priorita, [PzPallet] = @PzPallet, [Note] = @Note WHERE (([idxPromessa] = @Original_idxPromessa) AND ([KeyRichiesta] = @Original_KeyRichiesta) AND ([KeyBCode] = @Original_KeyBCode) AND ([Attivabile] = @Original_Attivabile) AND ([IdxODL] = @Original_IdxODL) AND ([CodArticolo] = @Original_CodArticolo) AND ([CodGruppo] = @Original_CodGruppo) AND ([IdxMacchina] = @Original_IdxMacchina) AND ([NumPezzi] = @Original_NumPezzi) AND ([TCAssegnato] = @Original_TCAssegnato) AND ([DueDate] = @Original_DueDate) AND ([Priorita] = @Original_Priorita) AND ([PzPallet] = @Original_PzPallet) AND ([Note] = @Original_Note));
|
|
SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note FROM PromesseIN WHERE (idxPromessa = @idxPromessa)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyRichiesta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyRichiesta" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyBCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyBCode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Attivabile" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivabile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdxODL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxODL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxMacchina" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumPezzi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumPezzi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TCAssegnato" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="TCAssegnato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priorita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PzPallet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PzPallet" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idxPromessa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idxPromessa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyRichiesta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyRichiesta" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyBCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyBCode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Attivabile" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Attivabile" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxODL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxODL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodArticolo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodGruppo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IdxMacchina" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumPezzi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumPezzi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TCAssegnato" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="TCAssegnato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priorita" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priorita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PzPallet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PzPallet" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idxPromessa" ColumnName="idxPromessa" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idxPromessa" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idxPromessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxPromessa" DataSetColumn="idxPromessa" />
|
|
<Mapping SourceColumn="KeyRichiesta" DataSetColumn="KeyRichiesta" />
|
|
<Mapping SourceColumn="KeyBCode" DataSetColumn="KeyBCode" />
|
|
<Mapping SourceColumn="Attivabile" DataSetColumn="Attivabile" />
|
|
<Mapping SourceColumn="IdxODL" DataSetColumn="IdxODL" />
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="CodGruppo" DataSetColumn="CodGruppo" />
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="NumPezzi" DataSetColumn="NumPezzi" />
|
|
<Mapping SourceColumn="TCAssegnato" DataSetColumn="TCAssegnato" />
|
|
<Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
|
|
<Mapping SourceColumn="Priorita" DataSetColumn="Priorita" />
|
|
<Mapping SourceColumn="PzPallet" DataSetColumn="PzPallet" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_IN_updProc" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updProc" Modifier="Public" Name="updProc" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="updProc">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_IN_updProc</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="PromesseOUTTableAdapter" GeneratorDataComponentClassName="PromesseOUTTableAdapter" Name="PromesseOUT" UserDataComponentName="PromesseOUTTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_PODL_OUT_exp" 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_PODL_OUT_exp</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idxPromessa" DataSetColumn="idxPromessa" />
|
|
<Mapping SourceColumn="KeyRichiesta" DataSetColumn="KeyRichiesta" />
|
|
<Mapping SourceColumn="KeyBCode" DataSetColumn="KeyBCode" />
|
|
<Mapping SourceColumn="Attivabile" DataSetColumn="Attivabile" />
|
|
<Mapping SourceColumn="IdxODL" DataSetColumn="IdxODL" />
|
|
<Mapping SourceColumn="CodArticolo" DataSetColumn="CodArticolo" />
|
|
<Mapping SourceColumn="CodGruppo" DataSetColumn="CodGruppo" />
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="CodMacchina" DataSetColumn="CodMacchina" />
|
|
<Mapping SourceColumn="Nome" DataSetColumn="Nome" />
|
|
<Mapping SourceColumn="NumPezzi" DataSetColumn="NumPezzi" />
|
|
<Mapping SourceColumn="TCAssegnato" DataSetColumn="TCAssegnato" />
|
|
<Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
|
|
<Mapping SourceColumn="Priorita" DataSetColumn="Priorita" />
|
|
<Mapping SourceColumn="PzPallet" DataSetColumn="PzPallet" />
|
|
<Mapping SourceColumn="Note" DataSetColumn="Note" />
|
|
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
|
|
<Mapping SourceColumn="DescrGruppo" DataSetColumn="DescrGruppo" />
|
|
<Mapping SourceColumn="nomeMacc" DataSetColumn="nomeMacc" />
|
|
<Mapping SourceColumn="DescrMacc" DataSetColumn="DescrMacc" />
|
|
<Mapping SourceColumn="Disegno" DataSetColumn="Disegno" />
|
|
<Mapping SourceColumn="DescArticolo" DataSetColumn="DescArticolo" />
|
|
<Mapping SourceColumn="DescCliente" DataSetColumn="DescCliente" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_deleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="deleteQuery" Modifier="Public" Name="deleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="deleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_deleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idxPromessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_getByMaccArt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByMaccArt" GetMethodModifier="Public" GetMethodName="getByMaccArt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByMaccArt" UserSourceName="getByMaccArt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_getByMaccArt</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="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@onlyFree" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_getMaxPrioByMacc" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getMaxPrioByMacc" GetMethodModifier="Public" GetMethodName="getMaxPrioByMacc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getMaxPrioByMacc" UserSourceName="getMaxPrioByMacc">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_getMaxPrioByMacc</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="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@onlyFree" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_insertQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_insertQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@KeyRichiesta" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@KeyBCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Attivabile" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArticolo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NumPezzi" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@TCAssegnato" Precision="18" ProviderType="Decimal" Scale="8" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Priorita" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PzPallet" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_move" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="movePrio" Modifier="Public" Name="movePrio" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="movePrio">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_move</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="@IdxPromessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IncrPrio" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_updAttiva" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updAttiva" Modifier="Public" Name="updAttiva" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updAttiva">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_updAttiva</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="@IdxPromessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Attivabile" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PODL_OUT_updMacchina" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="updMacchina" GetMethodModifier="Public" GetMethodName="updMacchina" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="updMacchina" UserSourceName="updMacchina">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PODL_OUT_updMacchina</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="@IdxPromessa" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" 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="ConfWeekTableAdapter" GeneratorDataComponentClassName="ConfWeekTableAdapter" Name="ConfWeek" UserDataComponentName="ConfWeekTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.ConfWeek" DbObjectType="Table" 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 ConfWeek</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodConfAper" DataSetColumn="CodConfAper" />
|
|
<Mapping SourceColumn="G1" DataSetColumn="G1" />
|
|
<Mapping SourceColumn="G2" DataSetColumn="G2" />
|
|
<Mapping SourceColumn="G3" DataSetColumn="G3" />
|
|
<Mapping SourceColumn="G4" DataSetColumn="G4" />
|
|
<Mapping SourceColumn="G5" DataSetColumn="G5" />
|
|
<Mapping SourceColumn="G6" DataSetColumn="G6" />
|
|
<Mapping SourceColumn="G7" DataSetColumn="G7" />
|
|
<Mapping SourceColumn="OreWeek" DataSetColumn="OreWeek" />
|
|
<Mapping SourceColumn="PercApert" DataSetColumn="PercApert" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CalStopTableAdapter" GeneratorDataComponentClassName="CalStopTableAdapter" Name="CalStop" UserDataComponentName="CalStopTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.CalStop" DbObjectType="Table" 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 CalStop</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DataRif" DataSetColumn="DataRif" />
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_CalS_getByPeriod" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByPeriod" GetMethodModifier="Public" GetMethodName="getByPeriod" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByPeriod" UserSourceName="getByPeriod">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_CalS_getByPeriod</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="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MESE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_CalS_upsert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="upsert" Modifier="Public" Name="upsert" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="upsert">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_CalS_upsert</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="@DataRif" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DescrStop" 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="CalDispTableAdapter" GeneratorDataComponentClassName="CalDispTableAdapter" Name="CalDisp" UserDataComponentName="CalDispTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.CalDisp" DbObjectType="Table" 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 CalDisp</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DataRif" DataSetColumn="DataRif" />
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="OreApertura" DataSetColumn="OreApertura" />
|
|
<Mapping SourceColumn="OreAllocate" DataSetColumn="OreAllocate" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_CalD_getByPeriod" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByPeriod" GetMethodModifier="Public" GetMethodName="getByPeriod" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByPeriod" UserSourceName="getByPeriod">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_CalD_getByPeriod</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="@Anno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Mese" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_CalD_UpdatePeriod" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdatePeriod" Modifier="Public" Name="UpdatePeriod" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdatePeriod">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_CalD_UpdatePeriod</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="@StartDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDate" 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="ConfWeek1TableAdapter" GeneratorDataComponentClassName="ConfWeek1TableAdapter" Name="ConfWeek1" UserDataComponentName="ConfWeek1TableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.ConfWeek" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT *
|
|
FROM ConfWeek</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodConfAper" DataSetColumn="CodConfAper" />
|
|
<Mapping SourceColumn="G1" DataSetColumn="G1" />
|
|
<Mapping SourceColumn="G2" DataSetColumn="G2" />
|
|
<Mapping SourceColumn="G3" DataSetColumn="G3" />
|
|
<Mapping SourceColumn="G4" DataSetColumn="G4" />
|
|
<Mapping SourceColumn="G5" DataSetColumn="G5" />
|
|
<Mapping SourceColumn="G6" DataSetColumn="G6" />
|
|
<Mapping SourceColumn="G7" DataSetColumn="G7" />
|
|
<Mapping SourceColumn="OreWeek" DataSetColumn="OreWeek" />
|
|
<Mapping SourceColumn="PercApert" DataSetColumn="PercApert" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MachineParamsTableAdapter" GeneratorDataComponentClassName="MachineParamsTableAdapter" Name="MachineParams" UserDataComponentName="MachineParamsTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.MachineParams" DbObjectType="Table" 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 MachineParams</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="CodConfAper" DataSetColumn="CodConfAper" />
|
|
<Mapping SourceColumn="OEE" DataSetColumn="OEE" />
|
|
<Mapping SourceColumn="SetupTime" DataSetColumn="SetupTime" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_MacPar_DeleteQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MacPar_DeleteQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_MacPar_insMissing" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insMissing" Modifier="Public" Name="insMissing" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insMissing">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MacPar_insMissing</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>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_MacPar_UpdateQuery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_MacPar_UpdateQuery</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Original_IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodConfAper" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@OEE" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SetupTime" 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="selConfWeekTableAdapter" GeneratorDataComponentClassName="selConfWeekTableAdapter" Name="selConfWeek" UserDataComponentName="selConfWeekTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_selConfWeek" 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_selConfWeek
|
|
</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="planHistStatMacTableAdapter" GeneratorDataComponentClassName="planHistStatMacTableAdapter" Name="planHistStatMac" UserDataComponentName="planHistStatMacTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_HPSM_filt" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_HPSM_filt</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="@IdxMacchina" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxMacchina" DataSetColumn="IdxMacchina" />
|
|
<Mapping SourceColumn="OEE_All" DataSetColumn="OEE_All" />
|
|
<Mapping SourceColumn="OEE_1M" DataSetColumn="OEE_1M" />
|
|
<Mapping SourceColumn="SetUp_All" DataSetColumn="SetUp_All" />
|
|
<Mapping SourceColumn="SetUp_1M" DataSetColumn="SetUp_1M" />
|
|
<Mapping SourceColumn="WeekHrs" DataSetColumn="WeekHrs" />
|
|
<Mapping SourceColumn="WeekHrs_1M" DataSetColumn="WeekHrs_1M" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="planStatsCliTableAdapter" GeneratorDataComponentClassName="planStatsCliTableAdapter" Name="planStatsCli" UserDataComponentName="planStatsCliTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.v_planStatsCli" 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_planStatsCli
|
|
ORDER BY TotOreRich DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="DescCliente" DataSetColumn="DescCliente" />
|
|
<Mapping SourceColumn="TotQty" DataSetColumn="TotQty" />
|
|
<Mapping SourceColumn="TotOreRich" DataSetColumn="TotOreRich" />
|
|
<Mapping SourceColumn="TotOrePlan" DataSetColumn="TotOrePlan" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_ES3ConnectionString (Settings)" DbObjectName="MoonPro_ES3.dbo.stp_PSC_filt" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFilt" GetMethodModifier="Public" GetMethodName="getFilt" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFilt" UserSourceName="getFilt">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PSC_filt</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="@CodGruppo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Plan" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Plan" msprop:Generator_UserDSName="DS_Plan">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="planStatsGlobal" msprop:Generator_TableClassName="planStatsGlobalDataTable" msprop:Generator_TableVarName="tableplanStatsGlobal" msprop:Generator_TablePropName="planStatsGlobal" msprop:Generator_RowDeletingName="planStatsGlobalRowDeleting" msprop:Generator_RowChangingName="planStatsGlobalRowChanging" msprop:Generator_RowEvHandlerName="planStatsGlobalRowChangeEventHandler" msprop:Generator_RowDeletedName="planStatsGlobalRowDeleted" msprop:Generator_UserTableName="planStatsGlobal" msprop:Generator_RowChangedName="planStatsGlobalRowChanged" msprop:Generator_RowEvArgName="planStatsGlobalRowChangeEvent" msprop:Generator_RowClassName="planStatsGlobalRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="NumRows" msprop:Generator_ColumnVarNameInTable="columnNumRows" msprop:Generator_ColumnPropNameInRow="NumRows" msprop:Generator_ColumnPropNameInTable="NumRowsColumn" msprop:Generator_UserColumnName="NumRows" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumGrp" msprop:Generator_ColumnVarNameInTable="columnNumGrp" msprop:Generator_ColumnPropNameInRow="NumGrp" msprop:Generator_ColumnPropNameInTable="NumGrpColumn" msprop:Generator_UserColumnName="NumGrp" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumMacc" msprop:Generator_ColumnVarNameInTable="columnNumMacc" msprop:Generator_ColumnPropNameInRow="NumMacc" msprop:Generator_ColumnPropNameInTable="NumMaccColumn" msprop:Generator_UserColumnName="NumMacc" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumCli" msprop:Generator_ColumnVarNameInTable="columnNumCli" msprop:Generator_ColumnPropNameInRow="NumCli" msprop:Generator_ColumnPropNameInTable="NumCliColumn" msprop:Generator_UserColumnName="NumCli" type="xs:int" minOccurs="0" />
|
|
<xs:element name="NumArt" msprop:Generator_ColumnVarNameInTable="columnNumArt" msprop:Generator_ColumnPropNameInRow="NumArt" msprop:Generator_ColumnPropNameInTable="NumArtColumn" msprop:Generator_UserColumnName="NumArt" type="xs:int" minOccurs="0" />
|
|
<xs:element name="TotOreRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOreRich" msprop:Generator_ColumnPropNameInRow="TotOreRich" msprop:Generator_ColumnPropNameInTable="TotOreRichColumn" msprop:Generator_UserColumnName="TotOreRich" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotOrePlan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOrePlan" msprop:Generator_ColumnPropNameInRow="TotOrePlan" msprop:Generator_ColumnPropNameInTable="TotOrePlanColumn" msprop:Generator_UserColumnName="TotOrePlan" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="planStatsArt" msprop:Generator_TableClassName="planStatsArtDataTable" msprop:Generator_TableVarName="tableplanStatsArt" msprop:Generator_TablePropName="planStatsArt" msprop:Generator_RowDeletingName="planStatsArtRowDeleting" msprop:Generator_RowChangingName="planStatsArtRowChanging" msprop:Generator_RowEvHandlerName="planStatsArtRowChangeEventHandler" msprop:Generator_RowDeletedName="planStatsArtRowDeleted" msprop:Generator_UserTableName="planStatsArt" msprop:Generator_RowChangedName="planStatsArtRowChanged" msprop:Generator_RowEvArgName="planStatsArtRowChangeEvent" msprop:Generator_RowClassName="planStatsArtRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn" msprop:Generator_UserColumnName="CodArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TotOreRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOreRich" msprop:Generator_ColumnPropNameInRow="TotOreRich" msprop:Generator_ColumnPropNameInTable="TotOreRichColumn" msprop:Generator_UserColumnName="TotOreRich" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotOrePlan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOrePlan" msprop:Generator_ColumnPropNameInRow="TotOrePlan" msprop:Generator_ColumnPropNameInTable="TotOrePlanColumn" msprop:Generator_UserColumnName="TotOrePlan" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotQty" msprop:Generator_ColumnVarNameInTable="columnTotQty" msprop:Generator_ColumnPropNameInRow="TotQty" msprop:Generator_ColumnPropNameInTable="TotQtyColumn" msprop:Generator_UserColumnName="TotQty" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Disegno" msprop:Generator_ColumnVarNameInTable="columnDisegno" msprop:Generator_ColumnPropNameInRow="Disegno" msprop:Generator_ColumnPropNameInTable="DisegnoColumn" msprop:Generator_UserColumnName="Disegno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescArticolo" msprop:Generator_ColumnVarNameInTable="columnDescArticolo" msprop:Generator_ColumnPropNameInRow="DescArticolo" msprop:Generator_ColumnPropNameInTable="DescArticoloColumn" msprop:Generator_UserColumnName="DescArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="planStatsGroup" msprop:Generator_TableClassName="planStatsGroupDataTable" msprop:Generator_TableVarName="tableplanStatsGroup" msprop:Generator_TablePropName="planStatsGroup" msprop:Generator_RowDeletingName="planStatsGroupRowDeleting" msprop:Generator_RowChangingName="planStatsGroupRowChanging" msprop:Generator_RowEvHandlerName="planStatsGroupRowChangeEventHandler" msprop:Generator_RowDeletedName="planStatsGroupRowDeleted" msprop:Generator_UserTableName="planStatsGroup" msprop:Generator_RowChangedName="planStatsGroupRowChanged" msprop:Generator_RowEvArgName="planStatsGroupRowChangeEvent" msprop:Generator_RowClassName="planStatsGroupRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodGruppo" msprop:Generator_ColumnVarNameInTable="columnCodGruppo" msprop:Generator_ColumnPropNameInRow="CodGruppo" msprop:Generator_ColumnPropNameInTable="CodGruppoColumn" msprop:Generator_UserColumnName="CodGruppo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TotOreRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOreRich" msprop:Generator_ColumnPropNameInRow="TotOreRich" msprop:Generator_ColumnPropNameInTable="TotOreRichColumn" msprop:Generator_UserColumnName="TotOreRich" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotOrePlan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOrePlan" msprop:Generator_ColumnPropNameInRow="TotOrePlan" msprop:Generator_ColumnPropNameInTable="TotOrePlanColumn" msprop:Generator_UserColumnName="TotOrePlan" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotQty" msprop:Generator_ColumnVarNameInTable="columnTotQty" msprop:Generator_ColumnPropNameInRow="TotQty" msprop:Generator_ColumnPropNameInTable="TotQtyColumn" msprop:Generator_UserColumnName="TotQty" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DescrGruppo" msprop:Generator_ColumnVarNameInTable="columnDescrGruppo" msprop:Generator_ColumnPropNameInRow="DescrGruppo" msprop:Generator_ColumnPropNameInTable="DescrGruppoColumn" msprop:Generator_UserColumnName="DescrGruppo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="planStatsMacc" msprop:Generator_TableClassName="planStatsMaccDataTable" msprop:Generator_TableVarName="tableplanStatsMacc" msprop:Generator_TablePropName="planStatsMacc" msprop:Generator_RowDeletingName="planStatsMaccRowDeleting" msprop:Generator_RowChangingName="planStatsMaccRowChanging" msprop:Generator_RowEvHandlerName="planStatsMaccRowChangeEventHandler" msprop:Generator_RowDeletedName="planStatsMaccRowDeleted" msprop:Generator_UserTableName="planStatsMacc" msprop:Generator_RowChangedName="planStatsMaccRowChanged" msprop:Generator_RowEvArgName="planStatsMaccRowChangeEvent" msprop:Generator_RowClassName="planStatsMaccRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TotOreRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOreRich" msprop:Generator_ColumnPropNameInRow="TotOreRich" msprop:Generator_ColumnPropNameInTable="TotOreRichColumn" msprop:Generator_UserColumnName="TotOreRich" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotOrePlan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOrePlan" msprop:Generator_ColumnPropNameInRow="TotOrePlan" msprop:Generator_ColumnPropNameInTable="TotOrePlanColumn" msprop:Generator_UserColumnName="TotOrePlan" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotQty" msprop:Generator_ColumnVarNameInTable="columnTotQty" msprop:Generator_ColumnPropNameInRow="TotQty" msprop:Generator_ColumnPropNameInTable="TotQtyColumn" msprop:Generator_UserColumnName="TotQty" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DescrMacc" msprop:Generator_ColumnVarNameInTable="columnDescrMacc" msprop:Generator_ColumnPropNameInRow="DescrMacc" msprop:Generator_ColumnPropNameInTable="DescrMaccColumn" msprop:Generator_UserColumnName="DescrMacc" 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="Richieste" msprop:Generator_TableClassName="RichiesteDataTable" msprop:Generator_TableVarName="tableRichieste" msprop:Generator_RowChangedName="RichiesteRowChanged" msprop:Generator_TablePropName="Richieste" msprop:Generator_RowDeletingName="RichiesteRowDeleting" msprop:Generator_RowChangingName="RichiesteRowChanging" msprop:Generator_RowEvHandlerName="RichiesteRowChangeEventHandler" msprop:Generator_RowDeletedName="RichiesteRowDeleted" msprop:Generator_RowClassName="RichiesteRow" msprop:Generator_UserTableName="Richieste" msprop:Generator_RowEvArgName="RichiesteRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxPromessa" msprop:Generator_ColumnVarNameInTable="columnidxPromessa" msprop:Generator_ColumnPropNameInRow="idxPromessa" msprop:Generator_ColumnPropNameInTable="idxPromessaColumn" msprop:Generator_UserColumnName="idxPromessa" type="xs:int" />
|
|
<xs:element name="KeyRichiesta" msprop:Generator_ColumnVarNameInTable="columnKeyRichiesta" msprop:Generator_ColumnPropNameInRow="KeyRichiesta" msprop:Generator_ColumnPropNameInTable="KeyRichiestaColumn" msprop:Generator_UserColumnName="KeyRichiesta">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KeyBCode" msprop:Generator_ColumnVarNameInTable="columnKeyBCode" msprop:Generator_ColumnPropNameInRow="KeyBCode" msprop:Generator_ColumnPropNameInTable="KeyBCodeColumn" msprop:Generator_UserColumnName="KeyBCode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Attivabile" msprop:Generator_ColumnVarNameInTable="columnAttivabile" msprop:Generator_ColumnPropNameInRow="Attivabile" msprop:Generator_ColumnPropNameInTable="AttivabileColumn" msprop:Generator_UserColumnName="Attivabile" type="xs:boolean" />
|
|
<xs:element name="IdxODL" msprop:Generator_ColumnVarNameInTable="columnIdxODL" msprop:Generator_ColumnPropNameInRow="IdxODL" msprop:Generator_ColumnPropNameInTable="IdxODLColumn" msprop:Generator_UserColumnName="IdxODL" type="xs:int" />
|
|
<xs:element name="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn" msprop:Generator_UserColumnName="CodArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NoteRichiesta" msprop:Generator_ColumnVarNameInTable="columnNoteRichiesta" msprop:Generator_ColumnPropNameInRow="NoteRichiesta" msprop:Generator_ColumnPropNameInTable="NoteRichiestaColumn" msprop:Generator_UserColumnName="NoteRichiesta">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodGruppo" msprop:Generator_ColumnVarNameInTable="columnCodGruppo" msprop:Generator_ColumnPropNameInRow="CodGruppo" msprop:Generator_ColumnPropNameInTable="CodGruppoColumn" msprop:Generator_UserColumnName="CodGruppo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumPezzi" msprop:Generator_ColumnVarNameInTable="columnNumPezzi" msprop:Generator_ColumnPropNameInRow="NumPezzi" msprop:Generator_ColumnPropNameInTable="NumPezziColumn" msprop:Generator_UserColumnName="NumPezzi" type="xs:int" />
|
|
<xs:element name="TCAssegnato" msprop:Generator_ColumnVarNameInTable="columnTCAssegnato" msprop:Generator_ColumnPropNameInRow="TCAssegnato" msprop:Generator_ColumnPropNameInTable="TCAssegnatoColumn" msprop:Generator_UserColumnName="TCAssegnato" type="xs:decimal" />
|
|
<xs:element name="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" />
|
|
<xs:element name="Priorita" msprop:Generator_ColumnVarNameInTable="columnPriorita" msprop:Generator_ColumnPropNameInRow="Priorita" msprop:Generator_ColumnPropNameInTable="PrioritaColumn" msprop:Generator_UserColumnName="Priorita" type="xs:int" />
|
|
<xs:element name="PzPallet" msprop:Generator_ColumnVarNameInTable="columnPzPallet" msprop:Generator_ColumnPropNameInRow="PzPallet" msprop:Generator_ColumnPropNameInTable="PzPalletColumn" msprop:Generator_UserColumnName="PzPallet" type="xs:int" />
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_UserColumnName="CodCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="flgPromDirty" msprop:Generator_ColumnVarNameInTable="columnflgPromDirty" msprop:Generator_ColumnPropNameInRow="flgPromDirty" msprop:Generator_ColumnPropNameInTable="flgPromDirtyColumn" msprop:Generator_UserColumnName="flgPromDirty" type="xs:unsignedByte" />
|
|
<xs:element name="DateAllOdlClose" msprop:Generator_ColumnVarNameInTable="columnDateAllOdlClose" msprop:Generator_ColumnPropNameInRow="DateAllOdlClose" msprop:Generator_ColumnPropNameInTable="DateAllOdlCloseColumn" msprop:Generator_UserColumnName="DateAllOdlClose" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DescrGruppo" msprop:Generator_ColumnVarNameInTable="columnDescrGruppo" msprop:Generator_ColumnPropNameInRow="DescrGruppo" msprop:Generator_ColumnPropNameInTable="DescrGruppoColumn" msprop:Generator_UserColumnName="DescrGruppo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeMacc" msprop:Generator_ColumnVarNameInTable="columnnomeMacc" msprop:Generator_ColumnPropNameInRow="nomeMacc" msprop:Generator_ColumnPropNameInTable="nomeMaccColumn" msprop:Generator_UserColumnName="nomeMacc">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrMacc" msprop:Generator_ColumnVarNameInTable="columnDescrMacc" msprop:Generator_ColumnPropNameInRow="DescrMacc" msprop:Generator_ColumnPropNameInTable="DescrMaccColumn" msprop:Generator_UserColumnName="DescrMacc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Disegno" msprop:Generator_ColumnVarNameInTable="columnDisegno" msprop:Generator_ColumnPropNameInRow="Disegno" msprop:Generator_ColumnPropNameInTable="DisegnoColumn" msprop:Generator_UserColumnName="Disegno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescArticolo" msprop:Generator_ColumnVarNameInTable="columnDescArticolo" msprop:Generator_ColumnPropNameInRow="DescArticolo" msprop:Generator_ColumnPropNameInTable="DescArticoloColumn" msprop:Generator_UserColumnName="DescArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescCliente" msprop:Generator_ColumnVarNameInTable="columnDescCliente" msprop:Generator_ColumnPropNameInRow="DescCliente" msprop:Generator_ColumnPropNameInTable="DescClienteColumn" msprop:Generator_UserColumnName="DescCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TC50p" msprop:Generator_ColumnVarNameInTable="columnTC50p" msprop:Generator_ColumnPropNameInRow="TC50p" msprop:Generator_ColumnPropNameInTable="TC50pColumn" msprop:Generator_UserColumnName="TC50p" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TC_Type" msprop:Generator_ColumnVarNameInTable="columnTC_Type" msprop:Generator_ColumnPropNameInRow="TC_Type" msprop:Generator_ColumnPropNameInTable="TC_TypeColumn" msprop:Generator_UserColumnName="TC_Type" type="xs:int" minOccurs="0" />
|
|
<xs:element name="TotMinuti" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotMinuti" msprop:Generator_ColumnPropNameInRow="TotMinuti" msprop:Generator_ColumnPropNameInTable="TotMinutiColumn" msprop:Generator_UserColumnName="TotMinuti" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotQty" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotQty" msprop:Generator_ColumnPropNameInRow="TotQty" msprop:Generator_ColumnPropNameInTable="TotQtyColumn" msprop:Generator_UserColumnName="TotQty" type="xs:int" minOccurs="0" />
|
|
<xs:element name="QtaRem" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnQtaRem" msprop:Generator_ColumnPropNameInRow="QtaRem" msprop:Generator_ColumnPropNameInTable="QtaRemColumn" msprop:Generator_UserColumnName="QtaRem" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="PromesseIN" msprop:Generator_TableClassName="PromesseINDataTable" msprop:Generator_TableVarName="tablePromesseIN" msprop:Generator_TablePropName="PromesseIN" msprop:Generator_RowDeletingName="PromesseINRowDeleting" msprop:Generator_RowChangingName="PromesseINRowChanging" msprop:Generator_RowEvHandlerName="PromesseINRowChangeEventHandler" msprop:Generator_RowDeletedName="PromesseINRowDeleted" msprop:Generator_UserTableName="PromesseIN" msprop:Generator_RowChangedName="PromesseINRowChanged" msprop:Generator_RowEvArgName="PromesseINRowChangeEvent" msprop:Generator_RowClassName="PromesseINRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxPromessa" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxPromessa" msprop:Generator_ColumnPropNameInRow="idxPromessa" msprop:Generator_ColumnPropNameInTable="idxPromessaColumn" msprop:Generator_UserColumnName="idxPromessa" type="xs:int" />
|
|
<xs:element name="KeyRichiesta" msprop:Generator_ColumnVarNameInTable="columnKeyRichiesta" msprop:Generator_ColumnPropNameInRow="KeyRichiesta" msprop:Generator_ColumnPropNameInTable="KeyRichiestaColumn" msprop:Generator_UserColumnName="KeyRichiesta">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KeyBCode" msprop:Generator_ColumnVarNameInTable="columnKeyBCode" msprop:Generator_ColumnPropNameInRow="KeyBCode" msprop:Generator_ColumnPropNameInTable="KeyBCodeColumn" msprop:Generator_UserColumnName="KeyBCode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Attivabile" msprop:Generator_ColumnVarNameInTable="columnAttivabile" msprop:Generator_ColumnPropNameInRow="Attivabile" msprop:Generator_ColumnPropNameInTable="AttivabileColumn" msprop:Generator_UserColumnName="Attivabile" type="xs:boolean" />
|
|
<xs:element name="IdxODL" msprop:Generator_ColumnVarNameInTable="columnIdxODL" msprop:Generator_ColumnPropNameInRow="IdxODL" msprop:Generator_ColumnPropNameInTable="IdxODLColumn" msprop:Generator_UserColumnName="IdxODL" type="xs:int" />
|
|
<xs:element name="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn" msprop:Generator_UserColumnName="CodArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodGruppo" msprop:Generator_ColumnVarNameInTable="columnCodGruppo" msprop:Generator_ColumnPropNameInRow="CodGruppo" msprop:Generator_ColumnPropNameInTable="CodGruppoColumn" msprop:Generator_UserColumnName="CodGruppo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumPezzi" msprop:Generator_ColumnVarNameInTable="columnNumPezzi" msprop:Generator_ColumnPropNameInRow="NumPezzi" msprop:Generator_ColumnPropNameInTable="NumPezziColumn" msprop:Generator_UserColumnName="NumPezzi" type="xs:int" />
|
|
<xs:element name="TCAssegnato" msprop:Generator_ColumnVarNameInTable="columnTCAssegnato" msprop:Generator_ColumnPropNameInRow="TCAssegnato" msprop:Generator_ColumnPropNameInTable="TCAssegnatoColumn" msprop:Generator_UserColumnName="TCAssegnato" type="xs:decimal" />
|
|
<xs:element name="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" />
|
|
<xs:element name="Priorita" msprop:Generator_ColumnVarNameInTable="columnPriorita" msprop:Generator_ColumnPropNameInRow="Priorita" msprop:Generator_ColumnPropNameInTable="PrioritaColumn" msprop:Generator_UserColumnName="Priorita" type="xs:int" />
|
|
<xs:element name="PzPallet" msprop:Generator_ColumnVarNameInTable="columnPzPallet" msprop:Generator_ColumnPropNameInRow="PzPallet" msprop:Generator_ColumnPropNameInTable="PzPalletColumn" msprop:Generator_UserColumnName="PzPallet" type="xs:int" />
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="PromesseOUT" msprop:Generator_TableClassName="PromesseOUTDataTable" msprop:Generator_TableVarName="tablePromesseOUT" msprop:Generator_TablePropName="PromesseOUT" msprop:Generator_RowDeletingName="PromesseOUTRowDeleting" msprop:Generator_RowChangingName="PromesseOUTRowChanging" msprop:Generator_RowEvHandlerName="PromesseOUTRowChangeEventHandler" msprop:Generator_RowDeletedName="PromesseOUTRowDeleted" msprop:Generator_UserTableName="PromesseOUT" msprop:Generator_RowChangedName="PromesseOUTRowChanged" msprop:Generator_RowEvArgName="PromesseOUTRowChangeEvent" msprop:Generator_RowClassName="PromesseOUTRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idxPromessa" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidxPromessa" msprop:Generator_ColumnPropNameInRow="idxPromessa" msprop:Generator_ColumnPropNameInTable="idxPromessaColumn" msprop:Generator_UserColumnName="idxPromessa" type="xs:int" />
|
|
<xs:element name="KeyRichiesta" msprop:Generator_ColumnVarNameInTable="columnKeyRichiesta" msprop:Generator_ColumnPropNameInRow="KeyRichiesta" msprop:Generator_ColumnPropNameInTable="KeyRichiestaColumn" msprop:Generator_UserColumnName="KeyRichiesta">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KeyBCode" msprop:Generator_ColumnVarNameInTable="columnKeyBCode" msprop:Generator_ColumnPropNameInRow="KeyBCode" msprop:Generator_ColumnPropNameInTable="KeyBCodeColumn" msprop:Generator_UserColumnName="KeyBCode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Attivabile" msprop:Generator_ColumnVarNameInTable="columnAttivabile" msprop:Generator_ColumnPropNameInRow="Attivabile" msprop:Generator_ColumnPropNameInTable="AttivabileColumn" msprop:Generator_UserColumnName="Attivabile" type="xs:boolean" />
|
|
<xs:element name="IdxODL" msprop:Generator_ColumnVarNameInTable="columnIdxODL" msprop:Generator_ColumnPropNameInRow="IdxODL" msprop:Generator_ColumnPropNameInTable="IdxODLColumn" msprop:Generator_UserColumnName="IdxODL" type="xs:int" />
|
|
<xs:element name="CodArticolo" msprop:Generator_ColumnVarNameInTable="columnCodArticolo" msprop:Generator_ColumnPropNameInRow="CodArticolo" msprop:Generator_ColumnPropNameInTable="CodArticoloColumn" msprop:Generator_UserColumnName="CodArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodGruppo" msprop:Generator_ColumnVarNameInTable="columnCodGruppo" msprop:Generator_ColumnPropNameInRow="CodGruppo" msprop:Generator_ColumnPropNameInTable="CodGruppoColumn" msprop:Generator_UserColumnName="CodGruppo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodMacchina" msdata:ReadOnly="true" 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="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumPezzi" msprop:Generator_ColumnVarNameInTable="columnNumPezzi" msprop:Generator_ColumnPropNameInRow="NumPezzi" msprop:Generator_ColumnPropNameInTable="NumPezziColumn" msprop:Generator_UserColumnName="NumPezzi" type="xs:int" />
|
|
<xs:element name="TCAssegnato" msprop:Generator_ColumnVarNameInTable="columnTCAssegnato" msprop:Generator_ColumnPropNameInRow="TCAssegnato" msprop:Generator_ColumnPropNameInTable="TCAssegnatoColumn" msprop:Generator_UserColumnName="TCAssegnato" type="xs:decimal" />
|
|
<xs:element name="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" />
|
|
<xs:element name="Priorita" msprop:Generator_ColumnVarNameInTable="columnPriorita" msprop:Generator_ColumnPropNameInRow="Priorita" msprop:Generator_ColumnPropNameInTable="PrioritaColumn" msprop:Generator_UserColumnName="Priorita" type="xs:int" />
|
|
<xs:element name="PzPallet" msprop:Generator_ColumnVarNameInTable="columnPzPallet" msprop:Generator_ColumnPropNameInRow="PzPallet" msprop:Generator_ColumnPropNameInTable="PzPalletColumn" msprop:Generator_UserColumnName="PzPallet" type="xs:int" />
|
|
<xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RagSociale" msprop:Generator_ColumnVarNameInTable="columnRagSociale" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_UserColumnName="RagSociale" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrGruppo" msprop:Generator_ColumnVarNameInTable="columnDescrGruppo" msprop:Generator_ColumnPropNameInRow="DescrGruppo" msprop:Generator_ColumnPropNameInTable="DescrGruppoColumn" msprop:Generator_UserColumnName="DescrGruppo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeMacc" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnomeMacc" msprop:Generator_ColumnPropNameInRow="nomeMacc" msprop:Generator_ColumnPropNameInTable="nomeMaccColumn" msprop:Generator_UserColumnName="nomeMacc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrMacc" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDescrMacc" msprop:Generator_ColumnPropNameInRow="DescrMacc" msprop:Generator_ColumnPropNameInTable="DescrMaccColumn" msprop:Generator_UserColumnName="DescrMacc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Disegno" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDisegno" msprop:Generator_ColumnPropNameInRow="Disegno" msprop:Generator_ColumnPropNameInTable="DisegnoColumn" msprop:Generator_UserColumnName="Disegno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescArticolo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDescArticolo" msprop:Generator_ColumnPropNameInRow="DescArticolo" msprop:Generator_ColumnPropNameInTable="DescArticoloColumn" msprop:Generator_UserColumnName="DescArticolo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescCliente" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDescCliente" msprop:Generator_ColumnPropNameInRow="DescCliente" msprop:Generator_ColumnPropNameInTable="DescClienteColumn" msprop:Generator_UserColumnName="DescCliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_UserColumnName="CodCliente" 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="ConfWeek" msprop:Generator_TableClassName="ConfWeekDataTable" msprop:Generator_TableVarName="tableConfWeek" msprop:Generator_RowChangedName="ConfWeekRowChanged" msprop:Generator_TablePropName="ConfWeek" msprop:Generator_RowDeletingName="ConfWeekRowDeleting" msprop:Generator_RowChangingName="ConfWeekRowChanging" msprop:Generator_RowEvHandlerName="ConfWeekRowChangeEventHandler" msprop:Generator_RowDeletedName="ConfWeekRowDeleted" msprop:Generator_RowClassName="ConfWeekRow" msprop:Generator_UserTableName="ConfWeek" msprop:Generator_RowEvArgName="ConfWeekRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodConfAper" msprop:Generator_ColumnVarNameInTable="columnCodConfAper" msprop:Generator_ColumnPropNameInRow="CodConfAper" msprop:Generator_ColumnPropNameInTable="CodConfAperColumn" msprop:Generator_UserColumnName="CodConfAper">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="G1" msprop:Generator_ColumnVarNameInTable="columnG1" msprop:Generator_ColumnPropNameInRow="G1" msprop:Generator_ColumnPropNameInTable="G1Column" msprop:Generator_UserColumnName="G1" type="xs:int" />
|
|
<xs:element name="G2" msprop:Generator_ColumnVarNameInTable="columnG2" msprop:Generator_ColumnPropNameInRow="G2" msprop:Generator_ColumnPropNameInTable="G2Column" msprop:Generator_UserColumnName="G2" type="xs:int" />
|
|
<xs:element name="G3" msprop:Generator_ColumnVarNameInTable="columnG3" msprop:Generator_ColumnPropNameInRow="G3" msprop:Generator_ColumnPropNameInTable="G3Column" msprop:Generator_UserColumnName="G3" type="xs:int" />
|
|
<xs:element name="G4" msprop:Generator_ColumnVarNameInTable="columnG4" msprop:Generator_ColumnPropNameInRow="G4" msprop:Generator_ColumnPropNameInTable="G4Column" msprop:Generator_UserColumnName="G4" type="xs:int" />
|
|
<xs:element name="G5" msprop:Generator_ColumnVarNameInTable="columnG5" msprop:Generator_ColumnPropNameInRow="G5" msprop:Generator_ColumnPropNameInTable="G5Column" msprop:Generator_UserColumnName="G5" type="xs:int" />
|
|
<xs:element name="G6" msprop:Generator_ColumnVarNameInTable="columnG6" msprop:Generator_ColumnPropNameInRow="G6" msprop:Generator_ColumnPropNameInTable="G6Column" msprop:Generator_UserColumnName="G6" type="xs:int" />
|
|
<xs:element name="G7" msprop:Generator_ColumnVarNameInTable="columnG7" msprop:Generator_ColumnPropNameInRow="G7" msprop:Generator_ColumnPropNameInTable="G7Column" msprop:Generator_UserColumnName="G7" type="xs:int" />
|
|
<xs:element name="OreWeek" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOreWeek" msprop:Generator_ColumnPropNameInRow="OreWeek" msprop:Generator_ColumnPropNameInTable="OreWeekColumn" msprop:Generator_UserColumnName="OreWeek" type="xs:int" minOccurs="0" />
|
|
<xs:element name="PercApert" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPercApert" msprop:Generator_ColumnPropNameInRow="PercApert" msprop:Generator_ColumnPropNameInTable="PercApertColumn" msprop:Generator_UserColumnName="PercApert" type="xs:double" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="CalStop" msprop:Generator_TableClassName="CalStopDataTable" msprop:Generator_TableVarName="tableCalStop" msprop:Generator_TablePropName="CalStop" msprop:Generator_RowDeletingName="CalStopRowDeleting" msprop:Generator_RowChangingName="CalStopRowChanging" msprop:Generator_RowEvHandlerName="CalStopRowChangeEventHandler" msprop:Generator_RowDeletedName="CalStopRowDeleted" msprop:Generator_UserTableName="CalStop" msprop:Generator_RowChangedName="CalStopRowChanged" msprop:Generator_RowEvArgName="CalStopRowChangeEvent" msprop:Generator_RowClassName="CalStopRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DataRif" msprop:Generator_ColumnVarNameInTable="columnDataRif" msprop:Generator_ColumnPropNameInRow="DataRif" msprop:Generator_ColumnPropNameInTable="DataRifColumn" msprop:Generator_UserColumnName="DataRif" type="xs:dateTime" />
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<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="CalDisp" msprop:Generator_TableClassName="CalDispDataTable" msprop:Generator_TableVarName="tableCalDisp" msprop:Generator_TablePropName="CalDisp" msprop:Generator_RowDeletingName="CalDispRowDeleting" msprop:Generator_RowChangingName="CalDispRowChanging" msprop:Generator_RowEvHandlerName="CalDispRowChangeEventHandler" msprop:Generator_RowDeletedName="CalDispRowDeleted" msprop:Generator_UserTableName="CalDisp" msprop:Generator_RowChangedName="CalDispRowChanged" msprop:Generator_RowEvArgName="CalDispRowChangeEvent" msprop:Generator_RowClassName="CalDispRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DataRif" msprop:Generator_ColumnVarNameInTable="columnDataRif" msprop:Generator_ColumnPropNameInRow="DataRif" msprop:Generator_ColumnPropNameInTable="DataRifColumn" msprop:Generator_UserColumnName="DataRif" type="xs:dateTime" />
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OreApertura" msprop:Generator_ColumnVarNameInTable="columnOreApertura" msprop:Generator_ColumnPropNameInRow="OreApertura" msprop:Generator_ColumnPropNameInTable="OreAperturaColumn" msprop:Generator_UserColumnName="OreApertura" type="xs:double" />
|
|
<xs:element name="OreAllocate" msprop:Generator_ColumnVarNameInTable="columnOreAllocate" msprop:Generator_ColumnPropNameInRow="OreAllocate" msprop:Generator_ColumnPropNameInTable="OreAllocateColumn" msprop:Generator_UserColumnName="OreAllocate" type="xs:double" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ConfWeek1" msprop:Generator_TableClassName="ConfWeek1DataTable" msprop:Generator_TableVarName="tableConfWeek1" msprop:Generator_RowChangedName="ConfWeek1RowChanged" msprop:Generator_TablePropName="ConfWeek1" msprop:Generator_RowDeletingName="ConfWeek1RowDeleting" msprop:Generator_RowChangingName="ConfWeek1RowChanging" msprop:Generator_RowEvHandlerName="ConfWeek1RowChangeEventHandler" msprop:Generator_RowDeletedName="ConfWeek1RowDeleted" msprop:Generator_RowClassName="ConfWeek1Row" msprop:Generator_UserTableName="ConfWeek1" msprop:Generator_RowEvArgName="ConfWeek1RowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodConfAper" msprop:Generator_ColumnVarNameInTable="columnCodConfAper" msprop:Generator_ColumnPropNameInRow="CodConfAper" msprop:Generator_ColumnPropNameInTable="CodConfAperColumn" msprop:Generator_UserColumnName="CodConfAper">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="G1" msprop:Generator_ColumnVarNameInTable="columnG1" msprop:Generator_ColumnPropNameInRow="G1" msprop:Generator_ColumnPropNameInTable="G1Column" msprop:Generator_UserColumnName="G1" type="xs:int" />
|
|
<xs:element name="G2" msprop:Generator_ColumnVarNameInTable="columnG2" msprop:Generator_ColumnPropNameInRow="G2" msprop:Generator_ColumnPropNameInTable="G2Column" msprop:Generator_UserColumnName="G2" type="xs:int" />
|
|
<xs:element name="G3" msprop:Generator_ColumnVarNameInTable="columnG3" msprop:Generator_ColumnPropNameInRow="G3" msprop:Generator_ColumnPropNameInTable="G3Column" msprop:Generator_UserColumnName="G3" type="xs:int" />
|
|
<xs:element name="G4" msprop:Generator_ColumnVarNameInTable="columnG4" msprop:Generator_ColumnPropNameInRow="G4" msprop:Generator_ColumnPropNameInTable="G4Column" msprop:Generator_UserColumnName="G4" type="xs:int" />
|
|
<xs:element name="G5" msprop:Generator_ColumnVarNameInTable="columnG5" msprop:Generator_ColumnPropNameInRow="G5" msprop:Generator_ColumnPropNameInTable="G5Column" msprop:Generator_UserColumnName="G5" type="xs:int" />
|
|
<xs:element name="G6" msprop:Generator_ColumnVarNameInTable="columnG6" msprop:Generator_ColumnPropNameInRow="G6" msprop:Generator_ColumnPropNameInTable="G6Column" msprop:Generator_UserColumnName="G6" type="xs:int" />
|
|
<xs:element name="G7" msprop:Generator_ColumnVarNameInTable="columnG7" msprop:Generator_ColumnPropNameInRow="G7" msprop:Generator_ColumnPropNameInTable="G7Column" msprop:Generator_UserColumnName="G7" type="xs:int" />
|
|
<xs:element name="OreWeek" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOreWeek" msprop:Generator_ColumnPropNameInRow="OreWeek" msprop:Generator_ColumnPropNameInTable="OreWeekColumn" msprop:Generator_UserColumnName="OreWeek" type="xs:int" minOccurs="0" />
|
|
<xs:element name="PercApert" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPercApert" msprop:Generator_ColumnPropNameInRow="PercApert" msprop:Generator_ColumnPropNameInTable="PercApertColumn" msprop:Generator_UserColumnName="PercApert" type="xs:double" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="MachineParams" msprop:Generator_TableClassName="MachineParamsDataTable" msprop:Generator_TableVarName="tableMachineParams" msprop:Generator_RowChangedName="MachineParamsRowChanged" msprop:Generator_TablePropName="MachineParams" msprop:Generator_RowDeletingName="MachineParamsRowDeleting" msprop:Generator_RowChangingName="MachineParamsRowChanging" msprop:Generator_RowEvHandlerName="MachineParamsRowChangeEventHandler" msprop:Generator_RowDeletedName="MachineParamsRowDeleted" msprop:Generator_RowClassName="MachineParamsRow" msprop:Generator_UserTableName="MachineParams" msprop:Generator_RowEvArgName="MachineParamsRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodConfAper" msprop:Generator_ColumnVarNameInTable="columnCodConfAper" msprop:Generator_ColumnPropNameInRow="CodConfAper" msprop:Generator_ColumnPropNameInTable="CodConfAperColumn" msprop:Generator_UserColumnName="CodConfAper">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OEE" msprop:Generator_ColumnVarNameInTable="columnOEE" msprop:Generator_ColumnPropNameInRow="OEE" msprop:Generator_ColumnPropNameInTable="OEEColumn" msprop:Generator_UserColumnName="OEE" type="xs:double" />
|
|
<xs:element name="SetupTime" msprop:Generator_ColumnVarNameInTable="columnSetupTime" msprop:Generator_ColumnPropNameInRow="SetupTime" msprop:Generator_ColumnPropNameInTable="SetupTimeColumn" msprop:Generator_UserColumnName="SetupTime" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="selConfWeek" msprop:Generator_TableClassName="selConfWeekDataTable" msprop:Generator_TableVarName="tableselConfWeek" msprop:Generator_TablePropName="selConfWeek" msprop:Generator_RowDeletingName="selConfWeekRowDeleting" msprop:Generator_RowChangingName="selConfWeekRowChanging" msprop:Generator_RowEvHandlerName="selConfWeekRowChangeEventHandler" msprop:Generator_RowDeletedName="selConfWeekRowDeleted" msprop:Generator_UserTableName="selConfWeek" msprop:Generator_RowChangedName="selConfWeekRowChanged" msprop:Generator_RowEvArgName="selConfWeekRowChangeEvent" msprop:Generator_RowClassName="selConfWeekRow">
|
|
<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" 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="24" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="planHistStatMac" msprop:Generator_TableClassName="planHistStatMacDataTable" msprop:Generator_TableVarName="tableplanHistStatMac" msprop:Generator_TablePropName="planHistStatMac" msprop:Generator_RowDeletingName="planHistStatMacRowDeleting" msprop:Generator_RowChangingName="planHistStatMacRowChanging" msprop:Generator_RowEvHandlerName="planHistStatMacRowChangeEventHandler" msprop:Generator_RowDeletedName="planHistStatMacRowDeleted" msprop:Generator_UserTableName="planHistStatMac" msprop:Generator_RowChangedName="planHistStatMacRowChanged" msprop:Generator_RowEvArgName="planHistStatMacRowChangeEvent" msprop:Generator_RowClassName="planHistStatMacRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxMacchina" msprop:Generator_ColumnVarNameInTable="columnIdxMacchina" msprop:Generator_ColumnPropNameInRow="IdxMacchina" msprop:Generator_ColumnPropNameInTable="IdxMacchinaColumn" msprop:Generator_UserColumnName="IdxMacchina">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OEE_All" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOEE_All" msprop:Generator_ColumnPropNameInRow="OEE_All" msprop:Generator_ColumnPropNameInTable="OEE_AllColumn" msprop:Generator_UserColumnName="OEE_All" type="xs:double" minOccurs="0" />
|
|
<xs:element name="OEE_1M" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOEE_1M" msprop:Generator_ColumnPropNameInRow="OEE_1M" msprop:Generator_ColumnPropNameInTable="OEE_1MColumn" msprop:Generator_UserColumnName="OEE_1M" type="xs:double" minOccurs="0" />
|
|
<xs:element name="SetUp_All" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSetUp_All" msprop:Generator_ColumnPropNameInRow="SetUp_All" msprop:Generator_ColumnPropNameInTable="SetUp_AllColumn" msprop:Generator_UserColumnName="SetUp_All" type="xs:double" minOccurs="0" />
|
|
<xs:element name="SetUp_1M" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSetUp_1M" msprop:Generator_ColumnPropNameInRow="SetUp_1M" msprop:Generator_ColumnPropNameInTable="SetUp_1MColumn" msprop:Generator_UserColumnName="SetUp_1M" type="xs:double" minOccurs="0" />
|
|
<xs:element name="WeekHrs" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnWeekHrs" msprop:Generator_ColumnPropNameInRow="WeekHrs" msprop:Generator_ColumnPropNameInTable="WeekHrsColumn" msprop:Generator_UserColumnName="WeekHrs" type="xs:double" minOccurs="0" />
|
|
<xs:element name="WeekHrs_1M" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnWeekHrs_1M" msprop:Generator_ColumnPropNameInRow="WeekHrs_1M" msprop:Generator_ColumnPropNameInTable="WeekHrs_1MColumn" msprop:Generator_UserColumnName="WeekHrs_1M" type="xs:double" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="planStatsCli" msprop:Generator_TableClassName="planStatsCliDataTable" msprop:Generator_TableVarName="tableplanStatsCli" msprop:Generator_RowChangedName="planStatsCliRowChanged" msprop:Generator_TablePropName="planStatsCli" msprop:Generator_RowDeletingName="planStatsCliRowDeleting" msprop:Generator_RowChangingName="planStatsCliRowChanging" msprop:Generator_RowEvHandlerName="planStatsCliRowChangeEventHandler" msprop:Generator_RowDeletedName="planStatsCliRowDeleted" msprop:Generator_RowClassName="planStatsCliRow" msprop:Generator_UserTableName="planStatsCli" msprop:Generator_RowEvArgName="planStatsCliRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_UserColumnName="CodCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescCliente" msprop:Generator_ColumnVarNameInTable="columnDescCliente" msprop:Generator_ColumnPropNameInRow="DescCliente" msprop:Generator_ColumnPropNameInTable="DescClienteColumn" msprop:Generator_UserColumnName="DescCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TotQty" msprop:Generator_ColumnVarNameInTable="columnTotQty" msprop:Generator_ColumnPropNameInRow="TotQty" msprop:Generator_ColumnPropNameInTable="TotQtyColumn" msprop:Generator_UserColumnName="TotQty" type="xs:int" minOccurs="0" />
|
|
<xs:element name="TotOreRich" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOreRich" msprop:Generator_ColumnPropNameInRow="TotOreRich" msprop:Generator_ColumnPropNameInTable="TotOreRichColumn" msprop:Generator_UserColumnName="TotOreRich" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TotOrePlan" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotOrePlan" msprop:Generator_ColumnPropNameInRow="TotOrePlan" msprop:Generator_ColumnPropNameInTable="TotOrePlanColumn" msprop:Generator_UserColumnName="TotOrePlan" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Richieste" />
|
|
<xs:field xpath="mstns:idxPromessa" />
|
|
</xs:unique>
|
|
<xs:unique name="PromesseIN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:PromesseIN" />
|
|
<xs:field xpath="mstns:idxPromessa" />
|
|
</xs:unique>
|
|
<xs:unique name="PromesseOUT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:PromesseOUT" />
|
|
<xs:field xpath="mstns:idxPromessa" />
|
|
</xs:unique>
|
|
<xs:unique name="ConfWeek_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ConfWeek" />
|
|
<xs:field xpath="mstns:CodConfAper" />
|
|
</xs:unique>
|
|
<xs:unique name="CalStop_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:CalStop" />
|
|
<xs:field xpath="mstns:DataRif" />
|
|
<xs:field xpath="mstns:IdxMacchina" />
|
|
</xs:unique>
|
|
<xs:unique name="CalDisp_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:CalDisp" />
|
|
<xs:field xpath="mstns:DataRif" />
|
|
<xs:field xpath="mstns:IdxMacchina" />
|
|
</xs:unique>
|
|
<xs:unique name="ConfWeek1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ConfWeek1" />
|
|
<xs:field xpath="mstns:CodConfAper" />
|
|
</xs:unique>
|
|
<xs:unique name="MachineParams_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:MachineParams" />
|
|
<xs:field xpath="mstns:IdxMacchina" />
|
|
</xs:unique>
|
|
<xs:unique name="selConfWeek_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:selConfWeek" />
|
|
<xs:field xpath="mstns:value" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_MachineParams_ConfWeek" msdata:parent="ConfWeek" msdata:child="MachineParams" msdata:parentkey="CodConfAper" msdata:childkey="CodConfAper" msprop:Generator_UserChildTable="MachineParams" msprop:Generator_ChildPropName="GetMachineParamsRows" msprop:Generator_UserRelationName="FK_MachineParams_ConfWeek" msprop:Generator_RelationVarName="relationFK_MachineParams_ConfWeek" msprop:Generator_UserParentTable="ConfWeek" msprop:Generator_ParentPropName="ConfWeekRow" />
|
|
<msdata:Relationship name="FK_MachineParams_ConfWeek1" msdata:parent="ConfWeek1" msdata:child="MachineParams" msdata:parentkey="CodConfAper" msdata:childkey="CodConfAper" msprop:Generator_UserChildTable="MachineParams" msprop:Generator_ChildPropName="GetMachineParamsRows" msprop:Generator_UserRelationName="FK_MachineParams_ConfWeek1" msprop:Generator_RelationVarName="relationFK_MachineParams_ConfWeek1" msprop:Generator_UserParentTable="ConfWeek1" msprop:Generator_ParentPropName="ConfWeek1Row" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |