Torna al Thread

<?xml version="1.0" encoding="utf-8"?> <xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.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="Web.config" AppSettingsPropertyName="StatsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="StatsConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.StatsConnectionString.ConnectionString" Provider="System.Data.SqlClient"> </Connection> </Connections> <Tables> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TabellaMovMagTableAdapter" GeneratorDataComponentClassName="TabellaMovMagTableAdapter" Name="TabellaMovMag" UserDataComponentName="TabellaMovMagTableAdapter"> <MainSource> <DbSource ConnectionRef="StatsConnectionString (Web.config)" DbObjectName="Stats.dbo.TabellaMovMag" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT CodArt, DescArt, PrAq, AlIva, DataMov, CausaleMov, QtMov, CodAna, NET_FILIALE FROM TabellaMovMag WHERE (CausaleMov=@CausaleMov) AND DataMov&lt;=@DataMovFine AND DataMov&gt;=@DataMovInizio AND (NET_FILIALE=@NomeFile) AND CodArt=@CodArt ORDER BY DataMov DESC</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="CausaleMov" ColumnName="CausaleMov" DataSourceName="Stats.dbo.TabellaMovMag" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CausaleMov" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CausaleMov" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="DataMovFine" ColumnName="DataMov" DataSourceName="Stats.dbo.TabellaMovMag" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataMovFine" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DataMov" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="DataMovInizio" ColumnName="DataMov" DataSourceName="Stats.dbo.TabellaMovMag" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataMovInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DataMov" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="NomeFile" ColumnName="NET_FILIALE" DataSourceName="Stats.dbo.TabellaMovMag" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@NomeFile" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="NET_FILIALE" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="CodArt" ColumnName="CodArt" DataSourceName="Stats.dbo.TabellaMovMag" DataTypeServer="nvarchar(30)" DbType="String" Direction="Input" ParameterName="@CodArt" Precision="0" ProviderType="NVarChar" Scale="0" Size="30" SourceColumn="CodArt" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> </SelectCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="CodArt" DataSetColumn="CodArt" /> <Mapping SourceColumn="DescArt" DataSetColumn="DescArt" /> <Mapping SourceColumn="PrAq" DataSetColumn="PrAq" /> <Mapping SourceColumn="AlIva" DataSetColumn="AlIva" /> <Mapping SourceColumn="DataMov" DataSetColumn="DataMov" /> <Mapping SourceColumn="CausaleMov" DataSetColumn="CausaleMov" /> <Mapping SourceColumn="QtMov" DataSetColumn="QtMov" /> <Mapping SourceColumn="CodAna" DataSetColumn="CodAna" /> <Mapping SourceColumn="NET_FILIALE" DataSetColumn="NET_FILIALE" /> </Mappings> <Sources> </Sources> </TableAdapter> </Tables> <Sources> </Sources> </DataSource> </xs:appinfo> </xs:annotation> <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="TabellaMovMag" msprop:Generator_UserTableName="TabellaMovMag" msprop:Generator_RowDeletedName="TabellaMovMagRowDeleted" msprop:Generator_RowChangedName="TabellaMovMagRowChanged" msprop:Generator_RowClassName="TabellaMovMagRow" msprop:Generator_RowChangingName="TabellaMovMagRowChanging" msprop:Generator_RowEvArgName="TabellaMovMagRowChangeEvent" msprop:Generator_RowEvHandlerName="TabellaMovMagRowChangeEventHandler" msprop:Generator_TableClassName="TabellaMovMagDataTable" msprop:Generator_TableVarName="tableTabellaMovMag" msprop:Generator_RowDeletingName="TabellaMovMagRowDeleting" msprop:Generator_TablePropName="TabellaMovMag"> <xs:complexType> <xs:sequence> <xs:element name="CodArt" msprop:Generator_UserColumnName="CodArt" msprop:Generator_ColumnVarNameInTable="columnCodArt" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="DescArt" msprop:Generator_UserColumnName="DescArt" msprop:Generator_ColumnVarNameInTable="columnDescArt" msprop:Generator_ColumnPropNameInRow="DescArt" msprop:Generator_ColumnPropNameInTable="DescArtColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="150" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PrAq" msprop:Generator_UserColumnName="PrAq" msprop:Generator_ColumnVarNameInTable="columnPrAq" msprop:Generator_ColumnPropNameInRow="PrAq" msprop:Generator_ColumnPropNameInTable="PrAqColumn" type="xs:decimal" minOccurs="0" /> <xs:element name="AlIva" msprop:Generator_UserColumnName="AlIva" msprop:Generator_ColumnVarNameInTable="columnAlIva" msprop:Generator_ColumnPropNameInRow="AlIva" msprop:Generator_ColumnPropNameInTable="AlIvaColumn" type="xs:decimal" minOccurs="0" /> <xs:element name="DataMov" msprop:Generator_UserColumnName="DataMov" msprop:Generator_ColumnVarNameInTable="columnDataMov" msprop:Generator_ColumnPropNameInRow="DataMov" msprop:Generator_ColumnPropNameInTable="DataMovColumn" type="xs:dateTime" minOccurs="0" /> <xs:element name="CausaleMov" msprop:Generator_UserColumnName="CausaleMov" msprop:Generator_ColumnVarNameInTable="columnCausaleMov" msprop:Generator_ColumnPropNameInRow="CausaleMov" msprop:Generator_ColumnPropNameInTable="CausaleMovColumn" type="xs:short" minOccurs="0" /> <xs:element name="QtMov" msprop:Generator_UserColumnName="QtMov" msprop:Generator_ColumnVarNameInTable="columnQtMov" msprop:Generator_ColumnPropNameInRow="QtMov" msprop:Generator_ColumnPropNameInTable="QtMovColumn" type="xs:decimal" minOccurs="0" /> <xs:element name="CodAna" msprop:Generator_UserColumnName="CodAna" msprop:Generator_ColumnVarNameInTable="columnCodAna" msprop:Generator_ColumnPropNameInRow="CodAna" msprop:Generator_ColumnPropNameInTable="CodAnaColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="NET_FILIALE" msprop:Generator_UserColumnName="NET_FILIALE" msprop:Generator_ColumnVarNameInTable="columnNET_FILIALE" msprop:Generator_ColumnPropNameInRow="NET_FILIALE" msprop:Generator_ColumnPropNameInTable="NET_FILIALEColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema>
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5