194 lines
16 KiB
XML
194 lines
16 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_applicazione" targetNamespace="http://tempuri.org/DS_applicazione.xsd" xmlns:mstns="http://tempuri.org/DS_applicazione.xsd" xmlns="http://tempuri.org/DS_applicazione.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SteamWare_XPSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SteamWare_XPSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PrintLocalReport.Properties.Settings.GlobalReference.Default.SteamWare_XPSConnectionString" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SteamWare_XPSConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SteamWare_XPSConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PrintLocalReport.Properties.Settings.GlobalReference.Default.SteamWare_XPSConnectionString1" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_schedaIdentTableAdapter" GeneratorDataComponentClassName="sp_schedaIdentTableAdapter" Name="sp_schedaIdent" UserDataComponentName="sp_schedaIdentTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="SteamWare_XPSConnectionString1 (Settings)" DbObjectName="SteamWare_XPS.dbo.sp_schedaIdent" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.sp_schedaIdent</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="varchar" DbType="AnsiString" Direction="Input" ParameterName="@IdxObj" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxObj" DataSetColumn="IdxObj" />
|
|
<Mapping SourceColumn="Cliente" DataSetColumn="Cliente" />
|
|
<Mapping SourceColumn="DDT" DataSetColumn="DDT" />
|
|
<Mapping SourceColumn="DDT_del" DataSetColumn="DDT_del" />
|
|
<Mapping SourceColumn="DataArrivo" DataSetColumn="DataArrivo" />
|
|
<Mapping SourceColumn="CodProdotto" DataSetColumn="CodProdotto" />
|
|
<Mapping SourceColumn="ConsegnaPrevista" DataSetColumn="ConsegnaPrevista" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="FosfManganese" DataSetColumn="FosfManganese" />
|
|
<Mapping SourceColumn="Brunitura" DataSetColumn="Brunitura" />
|
|
<Mapping SourceColumn="FosfTeflon" DataSetColumn="FosfTeflon" />
|
|
<Mapping SourceColumn="Sabbiatura" DataSetColumn="Sabbiatura" />
|
|
<Mapping SourceColumn="F1" DataSetColumn="F1" />
|
|
<Mapping SourceColumn="F2" DataSetColumn="F2" />
|
|
<Mapping SourceColumn="FosfZinco" DataSetColumn="FosfZinco" />
|
|
<Mapping SourceColumn="Teflon" DataSetColumn="Teflon" />
|
|
<Mapping SourceColumn="FosfPreVern" DataSetColumn="FosfPreVern" />
|
|
<Mapping SourceColumn="PzRoto" DataSetColumn="PzRoto" />
|
|
<Mapping SourceColumn="Zinchlorex" DataSetColumn="Zinchlorex" />
|
|
<Mapping SourceColumn="PeekVicote" DataSetColumn="PeekVicote" />
|
|
<Mapping SourceColumn="CodCli" DataSetColumn="CodCli" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_applicazione" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DS_applicazione" msprop:Generator_DataSetName="DS_applicazione" msprop:EnableTableAdapterManager="true">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="sp_schedaIdent" msprop:Generator_UserTableName="sp_schedaIdent" msprop:Generator_RowDeletedName="sp_schedaIdentRowDeleted" msprop:Generator_TableClassName="sp_schedaIdentDataTable" msprop:Generator_RowChangedName="sp_schedaIdentRowChanged" msprop:Generator_RowClassName="sp_schedaIdentRow" msprop:Generator_RowChangingName="sp_schedaIdentRowChanging" msprop:Generator_RowEvArgName="sp_schedaIdentRowChangeEvent" msprop:Generator_RowEvHandlerName="sp_schedaIdentRowChangeEventHandler" msprop:Generator_TablePropName="sp_schedaIdent" msprop:Generator_TableVarName="tablesp_schedaIdent" msprop:Generator_RowDeletingName="sp_schedaIdentRowDeleting">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxObj" msprop:Generator_UserColumnName="IdxObj" msprop:Generator_ColumnPropNameInRow="IdxObj" msprop:Generator_ColumnVarNameInTable="columnIdxObj" msprop:Generator_ColumnPropNameInTable="IdxObjColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cliente" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Cliente" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT" msprop:Generator_UserColumnName="DDT" msprop:Generator_ColumnPropNameInRow="DDT" msprop:Generator_ColumnVarNameInTable="columnDDT" msprop:Generator_ColumnPropNameInTable="DDTColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DDT_del" msprop:Generator_UserColumnName="DDT_del" msprop:Generator_ColumnPropNameInRow="DDT_del" msprop:Generator_ColumnVarNameInTable="columnDDT_del" msprop:Generator_ColumnPropNameInTable="DDT_delColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="DataArrivo" msprop:Generator_UserColumnName="DataArrivo" msprop:Generator_ColumnPropNameInRow="DataArrivo" msprop:Generator_ColumnVarNameInTable="columnDataArrivo" msprop:Generator_ColumnPropNameInTable="DataArrivoColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CodProdotto" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CodProdotto" msprop:Generator_ColumnPropNameInRow="CodProdotto" msprop:Generator_ColumnVarNameInTable="columnCodProdotto" msprop:Generator_ColumnPropNameInTable="CodProdottoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ConsegnaPrevista" msprop:Generator_UserColumnName="ConsegnaPrevista" msprop:Generator_ColumnPropNameInRow="ConsegnaPrevista" msprop:Generator_ColumnVarNameInTable="columnConsegnaPrevista" msprop:Generator_ColumnPropNameInTable="ConsegnaPrevistaColumn" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Peso" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Peso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_ColumnPropNameInTable="PesoColumn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="FosfManganese" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FosfManganese" msprop:Generator_ColumnPropNameInRow="FosfManganese" msprop:Generator_ColumnVarNameInTable="columnFosfManganese" msprop:Generator_ColumnPropNameInTable="FosfManganeseColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Brunitura" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Brunitura" msprop:Generator_ColumnPropNameInRow="Brunitura" msprop:Generator_ColumnVarNameInTable="columnBrunitura" msprop:Generator_ColumnPropNameInTable="BrunituraColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FosfTeflon" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FosfTeflon" msprop:Generator_ColumnPropNameInRow="FosfTeflon" msprop:Generator_ColumnVarNameInTable="columnFosfTeflon" msprop:Generator_ColumnPropNameInTable="FosfTeflonColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Sabbiatura" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Sabbiatura" msprop:Generator_ColumnPropNameInRow="Sabbiatura" msprop:Generator_ColumnVarNameInTable="columnSabbiatura" msprop:Generator_ColumnPropNameInTable="SabbiaturaColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="F1" msdata:ReadOnly="true" msprop:Generator_UserColumnName="F1" msprop:Generator_ColumnPropNameInRow="F1" msprop:Generator_ColumnVarNameInTable="columnF1" msprop:Generator_ColumnPropNameInTable="F1Column" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="F2" msdata:ReadOnly="true" msprop:Generator_UserColumnName="F2" msprop:Generator_ColumnPropNameInRow="F2" msprop:Generator_ColumnVarNameInTable="columnF2" msprop:Generator_ColumnPropNameInTable="F2Column" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FosfZinco" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FosfZinco" msprop:Generator_ColumnPropNameInRow="FosfZinco" msprop:Generator_ColumnVarNameInTable="columnFosfZinco" msprop:Generator_ColumnPropNameInTable="FosfZincoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Teflon" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Teflon" msprop:Generator_ColumnPropNameInRow="Teflon" msprop:Generator_ColumnVarNameInTable="columnTeflon" msprop:Generator_ColumnPropNameInTable="TeflonColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FosfPreVern" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FosfPreVern" msprop:Generator_ColumnPropNameInRow="FosfPreVern" msprop:Generator_ColumnVarNameInTable="columnFosfPreVern" msprop:Generator_ColumnPropNameInTable="FosfPreVernColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PzRoto" msdata:ReadOnly="true" msprop:Generator_UserColumnName="PzRoto" msprop:Generator_ColumnPropNameInRow="PzRoto" msprop:Generator_ColumnVarNameInTable="columnPzRoto" msprop:Generator_ColumnPropNameInTable="PzRotoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Zinchlorex" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Zinchlorex" msprop:Generator_ColumnPropNameInRow="Zinchlorex" msprop:Generator_ColumnVarNameInTable="columnZinchlorex" msprop:Generator_ColumnPropNameInTable="ZinchlorexColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PeekVicote" msdata:ReadOnly="true" msprop:Generator_UserColumnName="PeekVicote" msprop:Generator_ColumnPropNameInRow="PeekVicote" msprop:Generator_ColumnVarNameInTable="columnPeekVicote" msprop:Generator_ColumnPropNameInTable="PeekVicoteColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCli" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CodCli" msprop:Generator_ColumnPropNameInRow="CodCli" msprop:Generator_ColumnVarNameInTable="columnCodCli" msprop:Generator_ColumnPropNameInTable="CodCliColumn" 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:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:sp_schedaIdent" />
|
|
<xs:field xpath="mstns:IdxObj" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |