dswage.xsd

中小企业人力资源管理系统

                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [tb_Wage] ([MonthWage], [EmployeeID], [EmployeeName], [BasisWage], [Overtime], [WageAge], [AllAppeared], [Hortation], [Duty], [Absent], [Chastisement], [FosterOld], [Idleness], [MedicalTreatment], [Deal], [Deduct], [FactWage]) VALUES (@MonthWage, @EmployeeID, @EmployeeName, @BasisWage, @Overtime, @WageAge, @AllAppeared, @Hortation, @Duty, @Absent, @Chastisement, @FosterOld, @Idleness, @MedicalTreatment, @Deal, @Deduct, @FactWage);
SELECT MonthWage, EmployeeID, EmployeeName, BasisWage, Overtime, WageAge, AllAppeared, Hortation, Duty, Absent, Chastisement, FosterOld, Idleness, MedicalTreatment, Deal, Deduct, FactWage, ID FROM tb_Wage WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MonthWage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MonthWage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@BasisWage" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BasisWage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Overtime" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Overtime" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@WageAge" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="WageAge" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AllAppeared" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AllAppeared" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Hortation" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Hortation" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Duty" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Duty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Absent" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Absent" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Chastisement" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Chastisement" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@FosterOld" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="FosterOld" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Idleness" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Idleness" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MedicalTreatment" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MedicalTreatment" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Deal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Deal" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Deduct" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Deduct" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@FactWage" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="FactWage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT MonthWage, EmployeeID, EmployeeName, BasisWage, Overtime, WageAge, AllAppeared, Hortation, Duty, Absent, Chastisement, FosterOld, Idleness, MedicalTreatment, Deal, Deduct, FactWage, ID FROM tb_Wage</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [tb_Wage] SET [MonthWage] = @MonthWage, [EmployeeID] = @EmployeeID, [EmployeeName] = @EmployeeName, [BasisWage] = @BasisWage, [Overtime] = @Overtime, [WageAge] = @WageAge, [AllAppeared] = @AllAppeared, [Hortation] = @Hortation, [Duty] = @Duty, [Absent] = @Absent, [Chastisement] = @Chastisement, [FosterOld] = @FosterOld, [Idleness] = @Idleness, [MedicalTreatment] = @MedicalTreatment, [Deal] = @Deal, [Deduct] = @Deduct, [FactWage] = @FactWage 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));
SELECT MonthWage, EmployeeID, EmployeeName, BasisWage, Overtime, WageAge, AllAppeared, Hortation, Duty, Absent, Chastisement, FosterOld, Idleness, MedicalTreatment, Deal, Deduct, FactWage, ID FROM tb_Wage WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MonthWage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MonthWage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@BasisWage" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BasisWage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Overtime" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Overtime" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@WageAge" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="WageAge" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AllAppeared" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AllAppeared" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Hortation" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Hortation" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Duty" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Duty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Absent" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Absent" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Chastisement" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Chastisement" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@FosterOld" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="FosterOld" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Idleness" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Idleness" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>