Samuele E. Locatelli
217 lines
31 KiB
XML
217 lines
31 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Arca" targetNamespace="http://tempuri.org/DS_Arca.xsd" xmlns:mstns="http://tempuri.org/DS_Arca.xsd" xmlns="http://tempuri.org/DS_Arca.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_IS_ArcaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MoonPro_IS_ArcaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MapoDb.Properties.Settings.GlobalReference.Default.MoonPro_IS_ArcaConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GiacenzeTableAdapter" GeneratorDataComponentClassName="GiacenzeTableAdapter" Name="Giacenze" UserDataComponentName="GiacenzeTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_IS_ArcaConnectionString (Settings)" DbObjectName="MoonPro_IS_EdilChim.syn.xMAPO_fn_MGGiacEx_AllaData" 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">
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [syn].[xMAPO_fn_MGGiacEx_AllaData] ([Cd_MGEsercizio], [Cd_MG], [Cd_AR], [Id_DoDB], [Cd_MGUbicazione], [Cd_ARLotto], [Cd_DoSottoCommessa], [Quantita], [Valore], [IniQ], [IniV], [RetQ], [RetV], [CarQ], [CarV], [ScaQ], [ScaV], [CarQA], [CarVA], [CarQP], [CarVP], [CarQT], [CarVT], [ScaQV], [ScaVV], [ScaQP], [ScaVP], [ScaQT], [ScaVT]) VALUES (@Cd_MGEsercizio, @Cd_MG, @Cd_AR, @Id_DoDB, @Cd_MGUbicazione, @Cd_ARLotto, @Cd_DoSottoCommessa, @Quantita, @Valore, @IniQ, @IniV, @RetQ, @RetV, @CarQ, @CarV, @ScaQ, @ScaV, @CarQA, @CarVA, @CarQP, @CarVP, @CarQT, @CarVT, @ScaQV, @ScaVV, @ScaQP, @ScaVP, @ScaQT, @ScaVT)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cd_MGEsercizio" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cd_MGEsercizio" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cd_MG" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cd_MG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cd_AR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cd_AR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_DoDB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_DoDB" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cd_MGUbicazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cd_MGUbicazione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cd_ARLotto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cd_ARLotto" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cd_DoSottoCommessa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cd_DoSottoCommessa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Quantita" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="Quantita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Valore" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Valore" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@IniQ" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="IniQ" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@IniV" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="IniV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetQ" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="RetQ" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RetV" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RetV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarQ" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="CarQ" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarV" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CarV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaQ" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="ScaQ" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaV" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ScaV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarQA" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="CarQA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarVA" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CarVA" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarQP" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="CarQP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarVP" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CarVP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarQT" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="CarQT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CarVT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CarVT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaQV" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="ScaQV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaVV" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ScaVV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaQP" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="ScaQP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaVP" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ScaVP" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaQT" Precision="18" ProviderType="Decimal" Scale="8" Size="0" SourceColumn="ScaQT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ScaVT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ScaVT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Cd_MGEsercizio, Cd_MG, Cd_AR, Id_DoDB, Cd_MGUbicazione, Cd_ARLotto, Cd_DoSottoCommessa, Quantita, Valore, IniQ, IniV, RetQ, RetV, CarQ, CarV, ScaQ, ScaV, CarQA, CarVA, CarQP, CarVP, CarQT, CarVT, ScaQV, ScaVV, ScaQP, ScaVP, ScaQT, ScaVT FROM syn.xMAPO_fn_MGGiacEx_AllaData</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Cd_MGEsercizio" DataSetColumn="Cd_MGEsercizio" />
|
|
<Mapping SourceColumn="Cd_MG" DataSetColumn="Cd_MG" />
|
|
<Mapping SourceColumn="Cd_AR" DataSetColumn="Cd_AR" />
|
|
<Mapping SourceColumn="Id_DoDB" DataSetColumn="Id_DoDB" />
|
|
<Mapping SourceColumn="Cd_MGUbicazione" DataSetColumn="Cd_MGUbicazione" />
|
|
<Mapping SourceColumn="Cd_ARLotto" DataSetColumn="Cd_ARLotto" />
|
|
<Mapping SourceColumn="Cd_DoSottoCommessa" DataSetColumn="Cd_DoSottoCommessa" />
|
|
<Mapping SourceColumn="Quantita" DataSetColumn="Quantita" />
|
|
<Mapping SourceColumn="Valore" DataSetColumn="Valore" />
|
|
<Mapping SourceColumn="IniQ" DataSetColumn="IniQ" />
|
|
<Mapping SourceColumn="IniV" DataSetColumn="IniV" />
|
|
<Mapping SourceColumn="RetQ" DataSetColumn="RetQ" />
|
|
<Mapping SourceColumn="RetV" DataSetColumn="RetV" />
|
|
<Mapping SourceColumn="CarQ" DataSetColumn="CarQ" />
|
|
<Mapping SourceColumn="CarV" DataSetColumn="CarV" />
|
|
<Mapping SourceColumn="ScaQ" DataSetColumn="ScaQ" />
|
|
<Mapping SourceColumn="ScaV" DataSetColumn="ScaV" />
|
|
<Mapping SourceColumn="CarQA" DataSetColumn="CarQA" />
|
|
<Mapping SourceColumn="CarVA" DataSetColumn="CarVA" />
|
|
<Mapping SourceColumn="CarQP" DataSetColumn="CarQP" />
|
|
<Mapping SourceColumn="CarVP" DataSetColumn="CarVP" />
|
|
<Mapping SourceColumn="CarQT" DataSetColumn="CarQT" />
|
|
<Mapping SourceColumn="CarVT" DataSetColumn="CarVT" />
|
|
<Mapping SourceColumn="ScaQV" DataSetColumn="ScaQV" />
|
|
<Mapping SourceColumn="ScaVV" DataSetColumn="ScaVV" />
|
|
<Mapping SourceColumn="ScaQP" DataSetColumn="ScaQP" />
|
|
<Mapping SourceColumn="ScaVP" DataSetColumn="ScaVP" />
|
|
<Mapping SourceColumn="ScaQT" DataSetColumn="ScaQT" />
|
|
<Mapping SourceColumn="ScaVT" DataSetColumn="ScaVT" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_IS_ArcaConnectionString (Settings)" DbObjectName="MoonPro_IS_EdilChim.dbo.stp_GIAC_getByDate" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getBySearch" GetMethodModifier="Public" GetMethodName="getBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getBySearch" UserSourceName="getBySearch">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_GIAC_getByDate</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="@DataGiac" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodArt" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodLotto" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CodMagaz" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@OnlyTest" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_IS_ArcaConnectionString (Settings)" DbObjectName="MoonPro_IS_EdilChim.tmp.stp_IMP_All_Import_Process" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="stp_IMP_All_Import_Process" Modifier="Public" Name="stp_IMP_All_Import_Process" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="stp_IMP_All_Import_Process">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>tmp.stp_IMP_All_Import_Process</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="smallint" DbType="Int16" Direction="Input" ParameterName="@Type" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MaxDayConvert" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MaxDayMerge" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@flgViewLog" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_IS_ArcaConnectionString (Settings)" DbObjectName="MoonPro_IS_EdilChim.tmp.stp_IMP_All_Ordini_Process" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="stp_IMP_All_Ordini_Process" Modifier="Public" Name="stp_IMP_All_Ordini_Process" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="stp_IMP_All_Ordini_Process">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>tmp.stp_IMP_All_Ordini_Process</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="smallint" DbType="Int16" Direction="Input" ParameterName="@Type" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MaxDayConvert" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MaxDayMerge" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Flusso" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@flgViewLog" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Arca" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_Arca" msprop:Generator_UserDSName="DS_Arca">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="Giacenze" msprop:Generator_TableClassName="GiacenzeDataTable" msprop:Generator_TableVarName="tableGiacenze" msprop:Generator_RowChangedName="GiacenzeRowChanged" msprop:Generator_TablePropName="Giacenze" msprop:Generator_RowDeletingName="GiacenzeRowDeleting" msprop:Generator_RowChangingName="GiacenzeRowChanging" msprop:Generator_RowEvHandlerName="GiacenzeRowChangeEventHandler" msprop:Generator_RowDeletedName="GiacenzeRowDeleted" msprop:Generator_RowClassName="GiacenzeRow" msprop:Generator_UserTableName="Giacenze" msprop:Generator_RowEvArgName="GiacenzeRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Cd_MGEsercizio" msprop:Generator_ColumnVarNameInTable="columnCd_MGEsercizio" msprop:Generator_ColumnPropNameInRow="Cd_MGEsercizio" msprop:Generator_ColumnPropNameInTable="Cd_MGEsercizioColumn" msprop:Generator_UserColumnName="Cd_MGEsercizio">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cd_MG" msprop:Generator_ColumnVarNameInTable="columnCd_MG" msprop:Generator_ColumnPropNameInRow="Cd_MG" msprop:Generator_ColumnPropNameInTable="Cd_MGColumn" msprop:Generator_UserColumnName="Cd_MG">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cd_AR" msprop:Generator_ColumnVarNameInTable="columnCd_AR" msprop:Generator_ColumnPropNameInRow="Cd_AR" msprop:Generator_ColumnPropNameInTable="Cd_ARColumn" msprop:Generator_UserColumnName="Cd_AR">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Id_DoDB" msprop:Generator_ColumnVarNameInTable="columnId_DoDB" msprop:Generator_ColumnPropNameInRow="Id_DoDB" msprop:Generator_ColumnPropNameInTable="Id_DoDBColumn" msprop:Generator_UserColumnName="Id_DoDB" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Cd_MGUbicazione" msprop:Generator_ColumnVarNameInTable="columnCd_MGUbicazione" msprop:Generator_ColumnPropNameInRow="Cd_MGUbicazione" msprop:Generator_ColumnPropNameInTable="Cd_MGUbicazioneColumn" msprop:Generator_UserColumnName="Cd_MGUbicazione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cd_ARLotto" msprop:Generator_ColumnVarNameInTable="columnCd_ARLotto" msprop:Generator_ColumnPropNameInRow="Cd_ARLotto" msprop:Generator_ColumnPropNameInTable="Cd_ARLottoColumn" msprop:Generator_UserColumnName="Cd_ARLotto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cd_DoSottoCommessa" msprop:Generator_ColumnVarNameInTable="columnCd_DoSottoCommessa" msprop:Generator_ColumnPropNameInRow="Cd_DoSottoCommessa" msprop:Generator_ColumnPropNameInTable="Cd_DoSottoCommessaColumn" msprop:Generator_UserColumnName="Cd_DoSottoCommessa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Quantita" msprop:Generator_ColumnVarNameInTable="columnQuantita" msprop:Generator_ColumnPropNameInRow="Quantita" msprop:Generator_ColumnPropNameInTable="QuantitaColumn" msprop:Generator_UserColumnName="Quantita" type="xs:decimal" />
|
|
<xs:element name="Valore" msprop:Generator_ColumnVarNameInTable="columnValore" msprop:Generator_ColumnPropNameInRow="Valore" msprop:Generator_ColumnPropNameInTable="ValoreColumn" msprop:Generator_UserColumnName="Valore" type="xs:decimal" />
|
|
<xs:element name="IniQ" msprop:Generator_ColumnVarNameInTable="columnIniQ" msprop:Generator_ColumnPropNameInRow="IniQ" msprop:Generator_ColumnPropNameInTable="IniQColumn" msprop:Generator_UserColumnName="IniQ" type="xs:decimal" />
|
|
<xs:element name="IniV" msprop:Generator_ColumnVarNameInTable="columnIniV" msprop:Generator_ColumnPropNameInRow="IniV" msprop:Generator_ColumnPropNameInTable="IniVColumn" msprop:Generator_UserColumnName="IniV" type="xs:decimal" />
|
|
<xs:element name="RetQ" msprop:Generator_ColumnVarNameInTable="columnRetQ" msprop:Generator_ColumnPropNameInRow="RetQ" msprop:Generator_ColumnPropNameInTable="RetQColumn" msprop:Generator_UserColumnName="RetQ" type="xs:decimal" />
|
|
<xs:element name="RetV" msprop:Generator_ColumnVarNameInTable="columnRetV" msprop:Generator_ColumnPropNameInRow="RetV" msprop:Generator_ColumnPropNameInTable="RetVColumn" msprop:Generator_UserColumnName="RetV" type="xs:decimal" />
|
|
<xs:element name="CarQ" msprop:Generator_ColumnVarNameInTable="columnCarQ" msprop:Generator_ColumnPropNameInRow="CarQ" msprop:Generator_ColumnPropNameInTable="CarQColumn" msprop:Generator_UserColumnName="CarQ" type="xs:decimal" />
|
|
<xs:element name="CarV" msprop:Generator_ColumnVarNameInTable="columnCarV" msprop:Generator_ColumnPropNameInRow="CarV" msprop:Generator_ColumnPropNameInTable="CarVColumn" msprop:Generator_UserColumnName="CarV" type="xs:decimal" />
|
|
<xs:element name="ScaQ" msprop:Generator_ColumnVarNameInTable="columnScaQ" msprop:Generator_ColumnPropNameInRow="ScaQ" msprop:Generator_ColumnPropNameInTable="ScaQColumn" msprop:Generator_UserColumnName="ScaQ" type="xs:decimal" />
|
|
<xs:element name="ScaV" msprop:Generator_ColumnVarNameInTable="columnScaV" msprop:Generator_ColumnPropNameInRow="ScaV" msprop:Generator_ColumnPropNameInTable="ScaVColumn" msprop:Generator_UserColumnName="ScaV" type="xs:decimal" />
|
|
<xs:element name="CarQA" msprop:Generator_ColumnVarNameInTable="columnCarQA" msprop:Generator_ColumnPropNameInRow="CarQA" msprop:Generator_ColumnPropNameInTable="CarQAColumn" msprop:Generator_UserColumnName="CarQA" type="xs:decimal" />
|
|
<xs:element name="CarVA" msprop:Generator_ColumnVarNameInTable="columnCarVA" msprop:Generator_ColumnPropNameInRow="CarVA" msprop:Generator_ColumnPropNameInTable="CarVAColumn" msprop:Generator_UserColumnName="CarVA" type="xs:decimal" />
|
|
<xs:element name="CarQP" msprop:Generator_ColumnVarNameInTable="columnCarQP" msprop:Generator_ColumnPropNameInRow="CarQP" msprop:Generator_ColumnPropNameInTable="CarQPColumn" msprop:Generator_UserColumnName="CarQP" type="xs:decimal" />
|
|
<xs:element name="CarVP" msprop:Generator_ColumnVarNameInTable="columnCarVP" msprop:Generator_ColumnPropNameInRow="CarVP" msprop:Generator_ColumnPropNameInTable="CarVPColumn" msprop:Generator_UserColumnName="CarVP" type="xs:decimal" />
|
|
<xs:element name="CarQT" msprop:Generator_ColumnVarNameInTable="columnCarQT" msprop:Generator_ColumnPropNameInRow="CarQT" msprop:Generator_ColumnPropNameInTable="CarQTColumn" msprop:Generator_UserColumnName="CarQT" type="xs:decimal" />
|
|
<xs:element name="CarVT" msprop:Generator_ColumnVarNameInTable="columnCarVT" msprop:Generator_ColumnPropNameInRow="CarVT" msprop:Generator_ColumnPropNameInTable="CarVTColumn" msprop:Generator_UserColumnName="CarVT" type="xs:decimal" />
|
|
<xs:element name="ScaQV" msprop:Generator_ColumnVarNameInTable="columnScaQV" msprop:Generator_ColumnPropNameInRow="ScaQV" msprop:Generator_ColumnPropNameInTable="ScaQVColumn" msprop:Generator_UserColumnName="ScaQV" type="xs:decimal" />
|
|
<xs:element name="ScaVV" msprop:Generator_ColumnVarNameInTable="columnScaVV" msprop:Generator_ColumnPropNameInRow="ScaVV" msprop:Generator_ColumnPropNameInTable="ScaVVColumn" msprop:Generator_UserColumnName="ScaVV" type="xs:decimal" />
|
|
<xs:element name="ScaQP" msprop:Generator_ColumnVarNameInTable="columnScaQP" msprop:Generator_ColumnPropNameInRow="ScaQP" msprop:Generator_ColumnPropNameInTable="ScaQPColumn" msprop:Generator_UserColumnName="ScaQP" type="xs:decimal" />
|
|
<xs:element name="ScaVP" msprop:Generator_ColumnVarNameInTable="columnScaVP" msprop:Generator_ColumnPropNameInRow="ScaVP" msprop:Generator_ColumnPropNameInTable="ScaVPColumn" msprop:Generator_UserColumnName="ScaVP" type="xs:decimal" />
|
|
<xs:element name="ScaQT" msprop:Generator_ColumnVarNameInTable="columnScaQT" msprop:Generator_ColumnPropNameInRow="ScaQT" msprop:Generator_ColumnPropNameInTable="ScaQTColumn" msprop:Generator_UserColumnName="ScaQT" type="xs:decimal" />
|
|
<xs:element name="ScaVT" msprop:Generator_ColumnVarNameInTable="columnScaVT" msprop:Generator_ColumnPropNameInRow="ScaVT" msprop:Generator_ColumnPropNameInTable="ScaVTColumn" msprop:Generator_UserColumnName="ScaVT" type="xs:decimal" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:schema> |