dswage.xsd

基于SQLSERVER C#2.0的企业ERP管理系统

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsWage" targetNamespace="http://tempuri.org/dsWage.xsd" xmlns:mstns="http://tempuri.org/dsWage.xsd" xmlns="http://tempuri.org/dsWage.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="db_HRP_DataConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="db_HRP_DataConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HRP.Properties.Settings.GlobalReference.Default.db_HRP_DataConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tb_WageTableAdapter" GeneratorDataComponentClassName="tb_WageTableAdapter" Name="tb_Wage" UserDataComponentName="tb_WageTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_HRP_DataConnectionString (Settings)" DbObjectName="dbo.tb_Wage" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [tb_Wage] WHERE (((@IsNull_MonthWage = 1 AND [MonthWage] IS NULL) OR ([MonthWage] = @Original_MonthWage)) AND ((@IsNull_EmployeeID = 1 AND [EmployeeID] IS NULL) OR ([EmployeeID] = @Original_EmployeeID)) AND ((@IsNull_EmployeeName = 1 AND [EmployeeName] IS NULL) OR ([EmployeeName] = @Original_EmployeeName)) AND ((@IsNull_BasisWage = 1 AND [BasisWage] IS NULL) OR ([BasisWage] = @Original_BasisWage)) AND ((@IsNull_Overtime = 1 AND [Overtime] IS NULL) OR ([Overtime] = @Original_Overtime)) AND ((@IsNull_WageAge = 1 AND [WageAge] IS NULL) OR ([WageAge] = @Original_WageAge)) AND ((@IsNull_AllAppeared = 1 AND [AllAppeared] IS NULL) OR ([AllAppeared] = @Original_AllAppeared)) AND ((@IsNull_Hortation = 1 AND [Hortation] IS NULL) OR ([Hortation] = @Original_Hortation)) AND ((@IsNull_Duty = 1 AND [Duty] IS NULL) OR ([Duty] = @Original_Duty)) AND ((@IsNull_Absent = 1 AND [Absent] IS NULL) OR ([Absent] = @Original_Absent)) AND ((@IsNull_Chastisement = 1 AND [Chastisement] IS NULL) OR ([Chastisement] = @Original_Chastisement)) AND ((@IsNull_FosterOld = 1 AND [FosterOld] IS NULL) OR ([FosterOld] = @Original_FosterOld)) AND ((@IsNull_Idleness = 1 AND [Idleness] IS NULL) OR ([Idleness] = @Original_Idleness)) AND ((@IsNull_MedicalTreatment = 1 AND [MedicalTreatment] IS NULL) OR ([MedicalTreatment] = @Original_MedicalTreatment)) AND ((@IsNull_Deal = 1 AND [Deal] IS NULL) OR ([Deal] = @Original_Deal)) AND ((@IsNull_Deduct = 1 AND [Deduct] IS NULL) OR ([Deduct] = @Original_Deduct)) AND ((@IsNull_FactWage = 1 AND [FactWage] IS NULL) OR ([FactWage] = @Original_FactWage)) AND ([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MonthWage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MonthWage" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MonthWage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MonthWage" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmployeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasisWage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasisWage" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_BasisWage" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BasisWage" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Overtime" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Overtime" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WageAge" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WageAge" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_WageAge" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="WageAge" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllAppeared" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllAppeared" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AllAppeared" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AllAppeared" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hortation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hortation" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Hortation" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Hortation" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Duty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Duty" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Duty" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Duty" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Absent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Absent" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Absent" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Absent" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Chastisement" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Chastisement" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Chastisement" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Chastisement" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FosterOld" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FosterOld" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_FosterOld" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="FosterOld" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Idleness" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Idleness" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Idleness" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Idleness" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MedicalTreatment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MedicalTreatment" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_MedicalTreatment" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MedicalTreatment" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Deal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Deal" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Deal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Deal" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Deduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Deduct" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Deduct" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Deduct" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FactWage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FactWage" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_FactWage" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="FactWage" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>