Files
2019-12-12 18:54:13 +01:00

192 lines
22 KiB
XML

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DS_App" targetNamespace="http://tempuri.org/DS_App.xsd" xmlns:mstns="http://tempuri.org/DS_App.xsd" xmlns="http://tempuri.org/DS_App.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="AdmodellingConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AdmodellingConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.AdmodellingConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobsListTableAdapter" GeneratorDataComponentClassName="JobsListTableAdapter" Name="JobsList" UserDataComponentName="JobsListTableAdapter">
<MainSource>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.v_JobsList" 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 JobId, JobDescr, USER_NAME, JStatusID, JsDescr, dtSubmiss, dtStartProc, dtEndProc, uploadSizeKb, uploadPath, downloadSizeKb, downloadPath, dtDownload, dtCleanup FROM dbo.v_JobsList</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
<Mapping SourceColumn="JobDescr" DataSetColumn="JobDescr" />
<Mapping SourceColumn="USER_NAME" DataSetColumn="USER_NAME" />
<Mapping SourceColumn="JStatusID" DataSetColumn="JStatusID" />
<Mapping SourceColumn="JsDescr" DataSetColumn="JsDescr" />
<Mapping SourceColumn="dtSubmiss" DataSetColumn="dtSubmiss" />
<Mapping SourceColumn="dtStartProc" DataSetColumn="dtStartProc" />
<Mapping SourceColumn="dtEndProc" DataSetColumn="dtEndProc" />
<Mapping SourceColumn="uploadSizeKb" DataSetColumn="uploadSizeKb" />
<Mapping SourceColumn="uploadPath" DataSetColumn="uploadPath" />
<Mapping SourceColumn="downloadSizeKb" DataSetColumn="downloadSizeKb" />
<Mapping SourceColumn="downloadPath" DataSetColumn="downloadPath" />
<Mapping SourceColumn="dtDownload" DataSetColumn="dtDownload" />
<Mapping SourceColumn="dtCleanup" DataSetColumn="dtCleanup" />
</Mappings>
<Sources>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_getByUser" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByUser" GetMethodModifier="Public" GetMethodName="getByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByUser" UserSourceName="getByUser">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_getByUser</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="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selectOnly" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_getIncomp" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getIncomp" GetMethodModifier="Public" GetMethodName="getIncomp" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getIncomp" UserSourceName="getIncomp">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_getIncomp</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="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_insertNew" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="insertNew" GetMethodModifier="Public" GetMethodName="insertNew" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="insertNew" UserSourceName="insertNew">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_insertNew</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="@JobDescr" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@USER_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_updateDeleted" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateDeleted" Modifier="Public" Name="updateDeleted" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="updateDeleted">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_updateDeleted</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="@JobId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtCleanup" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_updateDownloaded" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateDownloaded" Modifier="Public" Name="updateDownloaded" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="updateDownloaded">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_updateDownloaded</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="@JobId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtDownload" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_updateProcessed" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateProcessed" Modifier="Public" Name="updateProcessed" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateProcessed">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_updateProcessed</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="@JobId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@JStatusID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtEndProc" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@downloadSizeKb" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@downloadPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="AdmodellingConnectionString (Web.config)" DbObjectName="Admodelling.dbo.stp_JL_updateUpload" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateUpload" Modifier="Public" Name="updateUpload" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updateUpload">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
<CommandText>dbo.stp_JL_updateUpload</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="@JobId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtSubmiss" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@uploadSizeKb" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@uploadPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DS_App" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_App" msprop:Generator_UserDSName="DS_App">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="JobsList" msprop:Generator_TableClassName="JobsListDataTable" msprop:Generator_TableVarName="tableJobsList" msprop:Generator_TablePropName="JobsList" msprop:Generator_RowDeletingName="JobsListRowDeleting" msprop:Generator_RowChangingName="JobsListRowChanging" msprop:Generator_RowEvHandlerName="JobsListRowChangeEventHandler" msprop:Generator_RowDeletedName="JobsListRowDeleted" msprop:Generator_UserTableName="JobsList" msprop:Generator_RowChangedName="JobsListRowChanged" msprop:Generator_RowEvArgName="JobsListRowChangeEvent" msprop:Generator_RowClassName="JobsListRow">
<xs:complexType>
<xs:sequence>
<xs:element name="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" msprop:Generator_UserColumnName="JobId" type="xs:int" />
<xs:element name="JobDescr" msprop:Generator_ColumnVarNameInTable="columnJobDescr" msprop:Generator_ColumnPropNameInRow="JobDescr" msprop:Generator_ColumnPropNameInTable="JobDescrColumn" msprop:Generator_UserColumnName="JobDescr">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="USER_NAME" msprop:Generator_ColumnVarNameInTable="columnUSER_NAME" msprop:Generator_ColumnPropNameInRow="USER_NAME" msprop:Generator_ColumnPropNameInTable="USER_NAMEColumn" msprop:Generator_UserColumnName="USER_NAME">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="JStatusID" msprop:Generator_ColumnVarNameInTable="columnJStatusID" msprop:Generator_ColumnPropNameInRow="JStatusID" msprop:Generator_ColumnPropNameInTable="JStatusIDColumn" msprop:Generator_UserColumnName="JStatusID" type="xs:int" />
<xs:element name="JsDescr" msprop:Generator_ColumnVarNameInTable="columnJsDescr" msprop:Generator_ColumnPropNameInRow="JsDescr" msprop:Generator_ColumnPropNameInTable="JsDescrColumn" msprop:Generator_UserColumnName="JsDescr" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtSubmiss" msprop:Generator_ColumnVarNameInTable="columndtSubmiss" msprop:Generator_ColumnPropNameInRow="dtSubmiss" msprop:Generator_ColumnPropNameInTable="dtSubmissColumn" msprop:Generator_UserColumnName="dtSubmiss" type="xs:dateTime" />
<xs:element name="dtStartProc" msprop:Generator_ColumnVarNameInTable="columndtStartProc" msprop:Generator_ColumnPropNameInRow="dtStartProc" msprop:Generator_ColumnPropNameInTable="dtStartProcColumn" msprop:Generator_UserColumnName="dtStartProc" type="xs:dateTime" minOccurs="0" />
<xs:element name="dtEndProc" msprop:Generator_ColumnVarNameInTable="columndtEndProc" msprop:Generator_ColumnPropNameInRow="dtEndProc" msprop:Generator_ColumnPropNameInTable="dtEndProcColumn" msprop:Generator_UserColumnName="dtEndProc" type="xs:dateTime" minOccurs="0" />
<xs:element name="uploadSizeKb" msprop:Generator_ColumnVarNameInTable="columnuploadSizeKb" msprop:Generator_ColumnPropNameInRow="uploadSizeKb" msprop:Generator_ColumnPropNameInTable="uploadSizeKbColumn" msprop:Generator_UserColumnName="uploadSizeKb" type="xs:int" />
<xs:element name="uploadPath" msprop:Generator_ColumnVarNameInTable="columnuploadPath" msprop:Generator_ColumnPropNameInRow="uploadPath" msprop:Generator_ColumnPropNameInTable="uploadPathColumn" msprop:Generator_UserColumnName="uploadPath">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="downloadSizeKb" msprop:Generator_ColumnVarNameInTable="columndownloadSizeKb" msprop:Generator_ColumnPropNameInRow="downloadSizeKb" msprop:Generator_ColumnPropNameInTable="downloadSizeKbColumn" msprop:Generator_UserColumnName="downloadSizeKb" type="xs:int" />
<xs:element name="downloadPath" msprop:Generator_ColumnVarNameInTable="columndownloadPath" msprop:Generator_ColumnPropNameInRow="downloadPath" msprop:Generator_ColumnPropNameInTable="downloadPathColumn" msprop:Generator_UserColumnName="downloadPath">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtDownload" msprop:Generator_ColumnVarNameInTable="columndtDownload" msprop:Generator_ColumnPropNameInRow="dtDownload" msprop:Generator_ColumnPropNameInTable="dtDownloadColumn" msprop:Generator_UserColumnName="dtDownload" type="xs:dateTime" minOccurs="0" />
<xs:element name="dtCleanup" msprop:Generator_ColumnVarNameInTable="columndtCleanup" msprop:Generator_ColumnPropNameInRow="dtCleanup" msprop:Generator_ColumnPropNameInTable="dtCleanupColumn" msprop:Generator_UserColumnName="dtCleanup" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:JobsList" />
<xs:field xpath="mstns:JobId" />
</xs:unique>
</xs:element>
</xs:schema>