Samuele E. Locatelli
317 lines
36 KiB
XML
317 lines
36 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_export" targetNamespace="http://tempuri.org/DS_export.xsd" xmlns:mstns="http://tempuri.org/DS_export.xsd" xmlns="http://tempuri.org/DS_export.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="GPWConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GPWConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GPW_data.Properties.Settings.GlobalReference.Default.GPWConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TimbratureZucchettiTableAdapter" GeneratorDataComponentClassName="TimbratureZucchettiTableAdapter" Name="TimbratureZucchetti" UserDataComponentName="TimbratureZucchettiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.export.stp_TimbratureZucchetti" 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>export.stp_TimbratureZucchetti</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="@dataFrom" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataTo" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Dipendente" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Timbratrice" Precision="0" ProviderType="Char" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="dataOra" DataSetColumn="dataOra" />
|
|
<Mapping SourceColumn="idxDipendente" DataSetColumn="idxDipendente" />
|
|
<Mapping SourceColumn="entrata" DataSetColumn="entrata" />
|
|
<Mapping SourceColumn="Approv" DataSetColumn="Approv" />
|
|
<Mapping SourceColumn="Timbratrice" DataSetColumn="Timbratrice" />
|
|
<Mapping SourceColumn="Badge" DataSetColumn="Badge" />
|
|
<Mapping SourceColumn="Data" DataSetColumn="Data" />
|
|
<Mapping SourceColumn="Ora" DataSetColumn="Ora" />
|
|
<Mapping SourceColumn="EntrataUscita" DataSetColumn="EntrataUscita" />
|
|
<Mapping SourceColumn="campoExport" DataSetColumn="campoExport" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RegAtt_pivotTableAdapter" GeneratorDataComponentClassName="RegAtt_pivotTableAdapter" Name="RegAtt_pivot" UserDataComponentName="RegAtt_pivotTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_RA_pivot_getByIdxDipData" 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_RA_pivot_getByIdxDipData</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="@idxDipendente" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataFrom" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dataTo" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
|
|
<Mapping SourceColumn="nomeProj" DataSetColumn="nomeProj" />
|
|
<Mapping SourceColumn="nomeFase" DataSetColumn="nomeFase" />
|
|
<Mapping SourceColumn="Cognome" DataSetColumn="CognomeNome" />
|
|
<Mapping SourceColumn="inizio" DataSetColumn="inizio" />
|
|
<Mapping SourceColumn="fine" DataSetColumn="fine" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="oreTot" DataSetColumn="oreTot" />
|
|
<Mapping SourceColumn="importo" DataSetColumn="importo" />
|
|
<Mapping SourceColumn="CognomeNome" DataSetColumn="CognomeNome" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencoReportTableAdapter" GeneratorDataComponentClassName="ElencoReportTableAdapter" Name="ElencoReport" UserDataComponentName="ElencoReportTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.ElencoReport" 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].[ElencoReport] WHERE (([IdxRep] = @Original_IdxRep) AND ([Area] = @Original_Area) AND ((@IsNull_nome = 1 AND [nome] IS NULL) OR ([nome] = @Original_nome)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)) AND ((@IsNull_cssClass = 1 AND [cssClass] IS NULL) OR ([cssClass] = @Original_cssClass)) AND ((@IsNull_ReportUrl = 1 AND [ReportUrl] IS NULL) OR ([ReportUrl] = @Original_ReportUrl)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxRep" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxRep" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Area" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Area" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cssClass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cssClass" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssClass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssClass" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReportUrl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReportUrl" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReportUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReportUrl" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[ElencoReport] ([Area], [nome], [descrizione], [cssClass], [ReportUrl]) VALUES (@Area, @nome, @descrizione, @cssClass, @ReportUrl);
|
|
SELECT IdxRep, Area, nome, descrizione, cssClass, ReportUrl FROM ElencoReport WHERE (IdxRep = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Area" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Area" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssClass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssClass" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReportUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReportUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT IdxRep, Area, nome, descrizione, cssClass, ReportUrl FROM dbo.ElencoReport</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[ElencoReport] SET [Area] = @Area, [nome] = @nome, [descrizione] = @descrizione, [cssClass] = @cssClass, [ReportUrl] = @ReportUrl WHERE (([IdxRep] = @Original_IdxRep) AND ([Area] = @Original_Area) AND ((@IsNull_nome = 1 AND [nome] IS NULL) OR ([nome] = @Original_nome)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)) AND ((@IsNull_cssClass = 1 AND [cssClass] IS NULL) OR ([cssClass] = @Original_cssClass)) AND ((@IsNull_ReportUrl = 1 AND [ReportUrl] IS NULL) OR ([ReportUrl] = @Original_ReportUrl)));
|
|
SELECT IdxRep, Area, nome, descrizione, cssClass, ReportUrl FROM ElencoReport WHERE (IdxRep = @IdxRep)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Area" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Area" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cssClass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssClass" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReportUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReportUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxRep" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxRep" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Area" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Area" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nome" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descrizione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descrizione" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descrizione" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cssClass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cssClass" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cssClass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cssClass" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReportUrl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReportUrl" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReportUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReportUrl" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="IdxRep" ColumnName="IdxRep" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxRep" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdxRep" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxRep" DataSetColumn="IdxRep" />
|
|
<Mapping SourceColumn="Area" DataSetColumn="Area" />
|
|
<Mapping SourceColumn="nome" DataSetColumn="nome" />
|
|
<Mapping SourceColumn="descrizione" DataSetColumn="descrizione" />
|
|
<Mapping SourceColumn="cssClass" DataSetColumn="cssClass" />
|
|
<Mapping SourceColumn="ReportUrl" DataSetColumn="ReportUrl" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="GPWConnectionString (Settings)" DbObjectName="GPW.dbo.stp_ER_getByArea" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByArea" GetMethodModifier="Public" GetMethodName="getByArea" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByArea" UserSourceName="getByArea">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_ER_getByArea</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="@Area" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_export" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_export" msprop:Generator_UserDSName="DS_export">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="TimbratureZucchetti" msprop:Generator_TableClassName="TimbratureZucchettiDataTable" msprop:Generator_TableVarName="tableTimbratureZucchetti" msprop:Generator_TablePropName="TimbratureZucchetti" msprop:Generator_RowDeletingName="TimbratureZucchettiRowDeleting" msprop:Generator_RowChangingName="TimbratureZucchettiRowChanging" msprop:Generator_RowEvHandlerName="TimbratureZucchettiRowChangeEventHandler" msprop:Generator_RowDeletedName="TimbratureZucchettiRowDeleted" msprop:Generator_UserTableName="TimbratureZucchetti" msprop:Generator_RowChangedName="TimbratureZucchettiRowChanged" msprop:Generator_RowEvArgName="TimbratureZucchettiRowChangeEvent" msprop:Generator_RowClassName="TimbratureZucchettiRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="dataOra" msprop:Generator_ColumnVarNameInTable="columndataOra" msprop:Generator_ColumnPropNameInRow="dataOra" msprop:Generator_ColumnPropNameInTable="dataOraColumn" msprop:Generator_UserColumnName="dataOra" type="xs:dateTime" />
|
|
<xs:element name="idxDipendente" msprop:Generator_ColumnVarNameInTable="columnidxDipendente" msprop:Generator_ColumnPropNameInRow="idxDipendente" msprop:Generator_ColumnPropNameInTable="idxDipendenteColumn" msprop:Generator_UserColumnName="idxDipendente" type="xs:int" />
|
|
<xs:element name="entrata" msprop:Generator_ColumnVarNameInTable="columnentrata" msprop:Generator_ColumnPropNameInRow="entrata" msprop:Generator_ColumnPropNameInTable="entrataColumn" msprop:Generator_UserColumnName="entrata" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="Approv" msprop:Generator_ColumnVarNameInTable="columnApprov" msprop:Generator_ColumnPropNameInRow="Approv" msprop:Generator_ColumnPropNameInTable="ApprovColumn" msprop:Generator_UserColumnName="Approv" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="Timbratrice" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTimbratrice" msprop:Generator_ColumnPropNameInRow="Timbratrice" msprop:Generator_ColumnPropNameInTable="TimbratriceColumn" msprop:Generator_UserColumnName="Timbratrice" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Badge" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnBadge" msprop:Generator_ColumnPropNameInRow="Badge" msprop:Generator_ColumnPropNameInTable="BadgeColumn" msprop:Generator_UserColumnName="Badge" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Data" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Ora" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOra" msprop:Generator_ColumnPropNameInRow="Ora" msprop:Generator_ColumnPropNameInTable="OraColumn" msprop:Generator_UserColumnName="Ora" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EntrataUscita" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEntrataUscita" msprop:Generator_ColumnPropNameInRow="EntrataUscita" msprop:Generator_ColumnPropNameInTable="EntrataUscitaColumn" msprop:Generator_UserColumnName="EntrataUscita" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="campoExport" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncampoExport" msprop:Generator_ColumnPropNameInRow="campoExport" msprop:Generator_ColumnPropNameInTable="campoExportColumn" msprop:Generator_UserColumnName="campoExport" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="RegAtt_pivot" msprop:Generator_TableClassName="RegAtt_pivotDataTable" msprop:Generator_TableVarName="tableRegAtt_pivot" msprop:Generator_TablePropName="RegAtt_pivot" msprop:Generator_RowDeletingName="RegAtt_pivotRowDeleting" msprop:Generator_RowChangingName="RegAtt_pivotRowChanging" msprop:Generator_RowEvHandlerName="RegAtt_pivotRowChangeEventHandler" msprop:Generator_RowDeletedName="RegAtt_pivotRowDeleted" msprop:Generator_UserTableName="RegAtt_pivot" msprop:Generator_RowChangedName="RegAtt_pivotRowChanged" msprop:Generator_RowEvArgName="RegAtt_pivotRowChangeEvent" msprop:Generator_RowClassName="RegAtt_pivotRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<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="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeProj" msprop:Generator_ColumnVarNameInTable="columnnomeProj" msprop:Generator_ColumnPropNameInRow="nomeProj" msprop:Generator_ColumnPropNameInTable="nomeProjColumn" msprop:Generator_UserColumnName="nomeProj">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nomeFase" msprop:Generator_ColumnVarNameInTable="columnnomeFase" msprop:Generator_ColumnPropNameInRow="nomeFase" msprop:Generator_ColumnPropNameInTable="nomeFaseColumn" msprop:Generator_UserColumnName="nomeFase" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CognomeNome" msprop:Generator_ColumnVarNameInTable="columnCognomeNome" msprop:Generator_ColumnPropNameInRow="CognomeNome" msprop:Generator_ColumnPropNameInTable="CognomeNomeColumn" msprop:Generator_UserColumnName="CognomeNome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="inizio" msprop:Generator_ColumnVarNameInTable="columninizio" msprop:Generator_ColumnPropNameInRow="inizio" msprop:Generator_ColumnPropNameInTable="inizioColumn" msprop:Generator_UserColumnName="inizio" type="xs:dateTime" />
|
|
<xs:element name="fine" msprop:Generator_ColumnVarNameInTable="columnfine" msprop:Generator_ColumnPropNameInRow="fine" msprop:Generator_ColumnPropNameInTable="fineColumn" msprop:Generator_UserColumnName="fine" type="xs:dateTime" />
|
|
<xs:element name="descrizione" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="oreTot" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnoreTot" msprop:Generator_ColumnPropNameInRow="oreTot" msprop:Generator_ColumnPropNameInTable="oreTotColumn" msprop:Generator_UserColumnName="oreTot" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="importo" msprop:Generator_ColumnVarNameInTable="columnimporto" msprop:Generator_ColumnPropNameInRow="importo" msprop:Generator_ColumnPropNameInTable="importoColumn" msprop:Generator_UserColumnName="importo" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ElencoReport" msprop:Generator_TableClassName="ElencoReportDataTable" msprop:Generator_TableVarName="tableElencoReport" msprop:Generator_TablePropName="ElencoReport" msprop:Generator_RowDeletingName="ElencoReportRowDeleting" msprop:Generator_RowChangingName="ElencoReportRowChanging" msprop:Generator_RowEvHandlerName="ElencoReportRowChangeEventHandler" msprop:Generator_RowDeletedName="ElencoReportRowDeleted" msprop:Generator_UserTableName="ElencoReport" msprop:Generator_RowChangedName="ElencoReportRowChanged" msprop:Generator_RowEvArgName="ElencoReportRowChangeEvent" msprop:Generator_RowClassName="ElencoReportRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxRep" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdxRep" msprop:Generator_ColumnPropNameInRow="IdxRep" msprop:Generator_ColumnPropNameInTable="IdxRepColumn" msprop:Generator_UserColumnName="IdxRep" type="xs:int" />
|
|
<xs:element name="Area" msprop:Generator_ColumnVarNameInTable="columnArea" msprop:Generator_ColumnPropNameInRow="Area" msprop:Generator_ColumnPropNameInTable="AreaColumn" msprop:Generator_UserColumnName="Area">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</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="descrizione" msprop:Generator_ColumnVarNameInTable="columndescrizione" msprop:Generator_ColumnPropNameInRow="descrizione" msprop:Generator_ColumnPropNameInTable="descrizioneColumn" msprop:Generator_UserColumnName="descrizione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cssClass" msprop:Generator_ColumnVarNameInTable="columncssClass" msprop:Generator_ColumnPropNameInRow="cssClass" msprop:Generator_ColumnPropNameInTable="cssClassColumn" msprop:Generator_UserColumnName="cssClass" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ReportUrl" msprop:Generator_ColumnVarNameInTable="columnReportUrl" msprop:Generator_ColumnPropNameInRow="ReportUrl" msprop:Generator_ColumnPropNameInTable="ReportUrlColumn" msprop:Generator_UserColumnName="ReportUrl" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TimbratureZucchetti" />
|
|
<xs:field xpath="mstns:dataOra" />
|
|
<xs:field xpath="mstns:idxDipendente" />
|
|
</xs:unique>
|
|
<xs:unique name="ElencoReport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ElencoReport" />
|
|
<xs:field xpath="mstns:IdxRep" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |