salarymanage.cs

Visual C#.NET数据库开发经典案例解析,这里有1到3的案例

																									  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