?? salarymanage.cs
字號:
new System.Data.Common.DataTableMapping("Table", "月工資統計表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("日期", "日期"),
new System.Data.Common.DataColumnMapping("職員編號", "職員編號"),
new System.Data.Common.DataColumnMapping("基本工資", "基本工資"),
new System.Data.Common.DataColumnMapping("浮動工資", "浮動工資"),
new System.Data.Common.DataColumnMapping("合同補", "合同補"),
new System.Data.Common.DataColumnMapping("糧副補", "糧副補"),
new System.Data.Common.DataColumnMapping("房補", "房補"),
new System.Data.Common.DataColumnMapping("臨時補", "臨時補"),
new System.Data.Common.DataColumnMapping("職務工資", "職務工資"),
new System.Data.Common.DataColumnMapping("工齡工資", "工齡工資"),
new System.Data.Common.DataColumnMapping("考核工資", "考核工資"),
new System.Data.Common.DataColumnMapping("獎金", "獎金"),
new System.Data.Common.DataColumnMapping("應發金額合計", "應發金額合計"),
new System.Data.Common.DataColumnMapping("房租", "房租"),
new System.Data.Common.DataColumnMapping("水電費", "水電費"),
new System.Data.Common.DataColumnMapping("請假扣除", "請假扣除"),
new System.Data.Common.DataColumnMapping("考勤扣除", "考勤扣除"),
new System.Data.Common.DataColumnMapping("罰款", "罰款"),
new System.Data.Common.DataColumnMapping("住房公積金", "住房公積金"),
new System.Data.Common.DataColumnMapping("醫療保險", "醫療保險"),
new System.Data.Common.DataColumnMapping("養老保險", "養老保險"),
new System.Data.Common.DataColumnMapping("失業保險", "失業保險"),
new System.Data.Common.DataColumnMapping("生育保險", "生育保險"),
new System.Data.Common.DataColumnMapping("工傷保險", "工傷保險"),
new System.Data.Common.DataColumnMapping("應扣金額合計", "應扣金額合計"),
new System.Data.Common.DataColumnMapping("工資合計", "工資合計"),
new System.Data.Common.DataColumnMapping("個人所得稅", "個人所得稅"),
new System.Data.Common.DataColumnMapping("實發金額", "實發金額"),
new System.Data.Common.DataColumnMapping("發放否", "發放否"),
new System.Data.Common.DataColumnMapping("月份", "月份")})});
this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 月工資統計表 WHERE (職員編號 = @Original_職員編號) AND (個人所得稅 = @Original_個人所得稅 OR " +
"@Original_個人所得稅 IS NULL AND 個人所得稅 IS NULL) AND (臨時補 = @Original_臨時補 OR @Original" +
"_臨時補 IS NULL AND 臨時補 IS NULL) AND (住房公積金 = @Original_住房公積金 OR @Original_住房公積金 IS" +
" NULL AND 住房公積金 IS NULL) AND (養老保險 = @Original_養老保險 OR @Original_養老保險 IS NULL AN" +
"D 養老保險 IS NULL) AND (醫療保險 = @Original_醫療保險 OR @Original_醫療保險 IS NULL AND 醫療保險 IS" +
" NULL) AND (發放否 = @Original_發放否 OR @Original_發放否 IS NULL AND 發放否 IS NULL) AND (合" +
"同補 = @Original_合同補 OR @Original_合同補 IS NULL AND 合同補 IS NULL) AND (基本工資 = @Origin" +
"al_基本工資 OR @Original_基本工資 IS NULL AND 基本工資 IS NULL) AND (失業保險 = @Original_失業保險 O" +
"R @Original_失業保險 IS NULL AND 失業保險 IS NULL) AND (獎金 = @Original_獎金 OR @Original_獎" +
"金 IS NULL AND 獎金 IS NULL) AND (實發金額 = @Original_實發金額 OR @Original_實發金額 IS NULL A" +
"ND 實發金額 IS NULL) AND (工傷保險 = @Original_工傷保險 OR @Original_工傷保險 IS NULL AND 工傷保險 I" +
"S NULL) AND (工資合計 = @Original_工資合計 OR @Original_工資合計 IS NULL AND 工資合計 IS NULL) A" +
"ND (工齡工資 = @Original_工齡工資 OR @Original_工齡工資 IS NULL AND 工齡工資 IS NULL) AND (應發金額合" +
"計 = @Original_應發金額合計 OR @Original_應發金額合計 IS NULL AND 應發金額合計 IS NULL) AND (應扣金額合計" +
" = @Original_應扣金額合計 OR @Original_應扣金額合計 IS NULL AND 應扣金額合計 IS NULL) AND (房租 = @O" +
"riginal_房租 OR @Original_房租 IS NULL AND 房租 IS NULL) AND (房補 = @Original_房補 OR @Or" +
"iginal_房補 IS NULL AND 房補 IS NULL) AND (日期 = @Original_日期 OR @Original_日期 IS NULL" +
" AND 日期 IS NULL) AND (月份 = @Original_月份 OR @Original_月份 IS NULL AND 月份 IS NULL) " +
"AND (水電費 = @Original_水電費 OR @Original_水電費 IS NULL AND 水電費 IS NULL) AND (浮動工資 = @" +
"Original_浮動工資 OR @Original_浮動工資 IS NULL AND 浮動工資 IS NULL) AND (生育保險 = @Original_" +
"生育保險 OR @Original_生育保險 IS NULL AND 生育保險 IS NULL) AND (糧副補 = @Original_糧副補 OR @Or" +
"iginal_糧副補 IS NULL AND 糧副補 IS NULL) AND (罰款 = @Original_罰款 OR @Original_罰款 IS NU" +
"LL AND 罰款 IS NULL) AND (考勤扣除 = @Original_考勤扣除 OR @Original_考勤扣除 IS NULL AND 考勤扣除" +
" IS NULL) AND (考核工資 = @Original_考核工資 OR @Original_考核工資 IS NULL AND 考核工資 IS NULL)" +
" AND (職務工資 = @Original_職務工資 OR @Original_職務工資 IS NULL AND 職務工資 IS NULL) AND (請假扣" +
"除 = @Original_請假扣除 OR @Original_請假扣除 IS NULL AND 請假扣除 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_職員編號", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "職員編號", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_個人所得稅", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "個人所得稅", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_臨時補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "臨時補", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_住房公積金", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "住房公積金", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_養老保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "養老保險", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_醫療保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "醫療保險", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_發放否", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "發放否", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_合同補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "合同補", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_基本工資", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "基本工資", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_失業保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "失業保險", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_獎金", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "獎金", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_實發金額", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "實發金額", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_工傷保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工傷保險", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_工資合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工資合計", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_工齡工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工齡工資", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_應發金額合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "應發金額合計", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_應扣金額合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "應扣金額合計", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_房租", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "房租", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_房補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "房補", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_日期", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_月份", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "月份", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_水電費", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "水電費", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_浮動工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "浮動工資", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_生育保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "生育保險", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_糧副補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "糧副補", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_罰款", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "罰款", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_考勤扣除", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "考勤扣除", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_考核工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "考核工資", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_職務工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "職務工資", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_請假扣除", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "請假扣除", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 月工資統計表(日期, 職員編號, 基本工資, 浮動工資, 合同補, 糧副補, 房補, 臨時補, 職務工資, 工齡工資, 考核工資, 獎金, 應發金額合計, 房租, 水電費, 請假扣除, 考勤扣除, 罰款, 住房公積金, 醫療保險, 養老保險, 失業保險, 生育保險, 工傷保險, 應扣金額合計, 工資合計, 個人所得稅, 實發金額, 發放否, 月份) VALUES (@日期, @職員編號, @基本工資, @浮動工資, @合同補, @糧副補, @房補, @臨時補, @職務工資, @工齡工資, @考核工資, @獎金, @應發金額合計, @房租, @水電費, @請假扣除, @考勤扣除, @罰款, @住房公積金, @醫療保險, @養老保險, @失業保險, @生育保險, @工傷保險, @應扣金額合計, @工資合計, @個人所得稅, @實發金額, @發放否, @月份); SELECT 日期, 職員編號, 基本工資, 浮動工資, 合同補, 糧副補, 房補, 臨時補, 職務工資, 工齡工資, 考核工資, 獎金, 應發金額合計, 房租, 水電費, 請假扣除, 考勤扣除, 罰款, 住房公積金, 醫療保險, 養老保險, 失業保險, 生育保險, 工傷保險, 應扣金額合計, 工資合計, 個人所得稅, 實發金額, 發放否, 月份 FROM 月工資統計表 WHERE (職員編號 = @職員編號)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.Int, 4, "日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@職員編號", System.Data.SqlDbType.VarChar, 30, "職員編號"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@基本工資", System.Data.SqlDbType.Float, 8, "基本工資"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@浮動工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "浮動工資", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@合同補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "合同補", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@糧副補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "糧副補", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "房補", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@臨時補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "臨時補", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@職務工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "職務工資", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@工齡工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工齡工資", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@考核工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "考核工資", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@獎金", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "獎金", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@應發金額合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "應發金額合計", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房租", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "房租", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@水電費", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "水電費", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@請假扣除", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "請假扣除", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@考勤扣除", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "考勤扣除", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@罰款", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "罰款", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@住房公積金", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "住房公積金", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@醫療保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "醫療保險", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@養老保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "養老保險", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@失業保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "失業保險", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@生育保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "生育保險", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@工傷保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工傷保險", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@應扣金額合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "應扣金額合計", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@工資合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工資合計", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@個人所得稅", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "個人所得稅", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@實發金額", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "實發金額", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@發放否", System.Data.SqlDbType.VarChar, 10, "發放否"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@月份", System.Data.SqlDbType.Int, 4, "月份"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 日期, 職員編號, 基本工資, 浮動工資, 合同補, 糧副補, 房補, 臨時補, 職務工資, 工齡工資, 考核工資, 獎金, 應發金額合計, 房租," +
" 水電費, 請假扣除, 考勤扣除, 罰款, 住房公積金, 醫療保險, 養老保險, 失業保險, 生育保險, 工傷保險, 應扣金額合計, 工資合計, 個人所得稅, " +
"實發金額, 發放否, 月份 FROM 月工資統計表";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 月工資統計表 SET 日期 = @日期, 職員編號 = @職員編號, 基本工資 = @基本工資, 浮動工資 = @浮動工資, 合同補 = @合同補," +
" 糧副補 = @糧副補, 房補 = @房補, 臨時補 = @臨時補, 職務工資 = @職務工資, 工齡工資 = @工齡工資, 考核工資 = @考核工資, 獎金 " +
"= @獎金, 應發金額合計 = @應發金額合計, 房租 = @房租, 水電費 = @水電費, 請假扣除 = @請假扣除, 考勤扣除 = @考勤扣除, 罰款 = " +
"@罰款, 住房公積金 = @住房公積金, 醫療保險 = @醫療保險, 養老保險 = @養老保險, 失業保險 = @失業保險, 生育保險 = @生育保險, 工傷保" +
"險 = @工傷保險, 應扣金額合計 = @應扣金額合計, 工資合計 = @工資合計, 個人所得稅 = @個人所得稅, 實發金額 = @實發金額, 發放否 = @" +
"發放否, 月份 = @月份 WHERE (職員編號 = @Original_職員編號) AND (個人所得稅 = @Original_個人所得稅 OR @Ori" +
"ginal_個人所得稅 IS NULL AND 個人所得稅 IS NULL) AND (臨時補 = @Original_臨時補 OR @Original_臨時補" +
" IS NULL AND 臨時補 IS NULL) AND (住房公積金 = @Original_住房公積金 OR @Original_住房公積金 IS NUL" +
"L AND 住房公積金 IS NULL) AND (養老保險 = @Original_養老保險 OR @Original_養老保險 IS NULL AND 養老" +
"保險 IS NULL) AND (醫療保險 = @Original_醫療保險 OR @Original_醫療保險 IS NULL AND 醫療保險 IS NUL" +
"L) AND (發放否 = @Original_發放否 OR @Original_發放否 IS NULL AND 發放否 IS NULL) AND (合同補 =" +
" @Original_合同補 OR @Original_合同補 IS NULL AND 合同補 IS NULL) AND (基本工資 = @Original_基" +
"本工資 OR @Original_基本工資 IS NULL AND 基本工資 IS NULL) AND (失業保險 = @Original_失業保險 OR @O" +
"riginal_失業保險 IS NULL AND 失業保險 IS NULL) AND (獎金 = @Original_獎金 OR @Original_獎金 IS" +
" NULL AND 獎金 IS NULL) AND (實發金額 = @Original_實發金額 OR @Original_實發金額 IS NULL AND 實" +
"發金額 IS NULL) AND (工傷保險 = @Original_工傷保險 OR @Original_工傷保險 IS NULL AND 工傷保險 IS NU" +
"LL) AND (工資合計 = @Original_工資合計 OR @Original_工資合計 IS NULL AND 工資合計 IS NULL) AND (" +
"工齡工資 = @Original_工齡工資 OR @Original_工齡工資 IS NULL AND 工齡工資 IS NULL) AND (應發金額合計 = " +
"@Original_應發金額合計 OR @Original_應發金額合計 IS NULL AND 應發金額合計 IS NULL) AND (應扣金額合計 = @" +
"Original_應扣金額合計 OR @Original_應扣金額合計 IS NULL AND 應扣金額合計 IS NULL) AND (房租 = @Origi" +
"nal_房租 OR @Original_房租 IS NULL AND 房租 IS NULL) AND (房補 = @Original_房補 OR @Origin" +
"al_房補 IS NULL AND 房補 IS NULL) AND (日期 = @Original_日期 OR @Original_日期 IS NULL AND" +
" 日期 IS NULL) AND (月份 = @Original_月份 OR @Original_月份 IS NULL AND 月份 IS NULL) AND " +
"(水電費 = @Original_水電費 OR @Original_水電費 IS NULL AND 水電費 IS NULL) AND (浮動工資 = @Orig" +
"inal_浮動工資 OR @Original_浮動工資 IS NULL AND 浮動工資 IS NULL) AND (生育保險 = @Original_生育保險" +
" OR @Original_生育保險 IS NULL AND 生育保險 IS NULL) AND (糧副補 = @Original_糧副補 OR @Origin" +
"al_糧副補 IS NULL AND 糧副補 IS NULL) AND (罰款 = @Original_罰款 OR @Original_罰款 IS NULL A" +
"ND 罰款 IS NULL) AND (考勤扣除 = @Original_考勤扣除 OR @Original_考勤扣除 IS NULL AND 考勤扣除 IS " +
"NULL) AND (考核工資 = @Original_考核工資 OR @Original_考核工資 IS NULL AND 考核工資 IS NULL) AND" +
" (職務工資 = @Original_職務工資 OR @Original_職務工資 IS NULL AND 職務工資 IS NULL) AND (請假扣除 = " +
"@Original_請假扣除 OR @Original_請假扣除 IS NULL AND 請假扣除 IS NULL); SELECT 日期, 職員編號, 基本工" +
"資, 浮動工資, 合同補, 糧副補, 房補, 臨時補, 職務工資, 工齡工資, 考核工資, 獎金, 應發金額合計, 房租, 水電費, 請假扣除, 考勤扣除, 罰" +
"款, 住房公積金, 醫療保險, 養老保險, 失業保險, 生育保險, 工傷保險, 應扣金額合計, 工資合計, 個人所得稅, 實發金額, 發放否, 月份 FROM " +
"月工資統計表 WHERE (職員編號 = @職員編號)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.Int, 4, "日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@職員編號", System.Data.SqlDbType.VarChar, 30, "職員編號"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@基本工資", System.Data.SqlDbType.Float, 8, "基本工資"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@浮動工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "浮動工資", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@合同補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "合同補", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@糧副補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "糧副補", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "房補", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@臨時補", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "臨時補", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@職務工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "職務工資", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@工齡工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "工齡工資", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@考核工資", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "考核工資", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@獎金", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "獎金", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@應發金額合計", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "應發金額合計", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房租", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "房租", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@水電費", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "水電費", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@請假扣除", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "請假扣除", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@考勤扣除", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "考勤扣除", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@罰款", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "罰款", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@住房公積金", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "住房公積金", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@醫療保險", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(26)), ((System.Byte)(2)), "醫療保險", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@養老保險", System.Data.SqlDbT?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -