📄 frmsalarymanage.cs
字号:
this.TextBox8.TabIndex = 15;
this.TextBox8.Text = "0";
this.TextBox8.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label8
//
this.Label8.Location = new System.Drawing.Point(8, 49);
this.Label8.Name = "Label8";
this.Label8.Size = new System.Drawing.Size(56, 17);
this.Label8.TabIndex = 14;
this.Label8.Text = "工龄工资";
//
// TextBox7
//
this.TextBox7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.职务工资"));
this.TextBox7.Location = new System.Drawing.Point(440, 27);
this.TextBox7.Name = "TextBox7";
this.TextBox7.Size = new System.Drawing.Size(49, 21);
this.TextBox7.TabIndex = 13;
this.TextBox7.Text = "0";
this.TextBox7.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label7
//
this.Label7.Location = new System.Drawing.Point(438, 11);
this.Label7.Name = "Label7";
this.Label7.Size = new System.Drawing.Size(56, 17);
this.Label7.TabIndex = 12;
this.Label7.Text = "职务工资";
//
// TextBox6
//
this.TextBox6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.临时补"));
this.TextBox6.Location = new System.Drawing.Point(368, 27);
this.TextBox6.Name = "TextBox6";
this.TextBox6.Size = new System.Drawing.Size(49, 21);
this.TextBox6.TabIndex = 11;
this.TextBox6.Text = "0";
this.TextBox6.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label6
//
this.Label6.Location = new System.Drawing.Point(366, 11);
this.Label6.Name = "Label6";
this.Label6.Size = new System.Drawing.Size(56, 17);
this.Label6.TabIndex = 10;
this.Label6.Text = "临时补";
//
// TextBox5
//
this.TextBox5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.房补"));
this.TextBox5.Location = new System.Drawing.Point(296, 27);
this.TextBox5.Name = "TextBox5";
this.TextBox5.Size = new System.Drawing.Size(49, 21);
this.TextBox5.TabIndex = 9;
this.TextBox5.Text = "0";
this.TextBox5.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label5
//
this.Label5.Location = new System.Drawing.Point(296, 11);
this.Label5.Name = "Label5";
this.Label5.Size = new System.Drawing.Size(56, 17);
this.Label5.TabIndex = 8;
this.Label5.Text = "房补";
//
// TextBox4
//
this.TextBox4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.粮副补"));
this.TextBox4.Location = new System.Drawing.Point(224, 27);
this.TextBox4.Name = "TextBox4";
this.TextBox4.Size = new System.Drawing.Size(49, 21);
this.TextBox4.TabIndex = 7;
this.TextBox4.Text = "0";
this.TextBox4.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label4
//
this.Label4.Location = new System.Drawing.Point(224, 11);
this.Label4.Name = "Label4";
this.Label4.Size = new System.Drawing.Size(56, 17);
this.Label4.TabIndex = 6;
this.Label4.Text = "粮副补";
//
// TextBox3
//
this.TextBox3.Location = new System.Drawing.Point(152, 27);
this.TextBox3.Name = "TextBox3";
this.TextBox3.Size = new System.Drawing.Size(49, 21);
this.TextBox3.TabIndex = 5;
this.TextBox3.Text = "0";
this.TextBox3.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label3
//
this.Label3.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.合同补"));
this.Label3.Location = new System.Drawing.Point(152, 11);
this.Label3.Name = "Label3";
this.Label3.Size = new System.Drawing.Size(48, 17);
this.Label3.TabIndex = 4;
this.Label3.Text = "合同补";
//
// TextBox2
//
this.TextBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.浮动工资"));
this.TextBox2.Location = new System.Drawing.Point(79, 27);
this.TextBox2.Name = "TextBox2";
this.TextBox2.Size = new System.Drawing.Size(49, 21);
this.TextBox2.TabIndex = 3;
this.TextBox2.Text = "0";
this.TextBox2.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label2
//
this.Label2.Location = new System.Drawing.Point(75, 11);
this.Label2.Name = "Label2";
this.Label2.Size = new System.Drawing.Size(56, 17);
this.Label2.TabIndex = 2;
this.Label2.Text = "浮动工资";
//
// TextBox1
//
this.TextBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "月工资统计表.基本工资"));
this.TextBox1.Location = new System.Drawing.Point(10, 27);
this.TextBox1.Name = "TextBox1";
this.TextBox1.Size = new System.Drawing.Size(49, 21);
this.TextBox1.TabIndex = 1;
this.TextBox1.Text = "0";
this.TextBox1.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// Label1
//
this.Label1.Location = new System.Drawing.Point(8, 11);
this.Label1.Name = "Label1";
this.Label1.Size = new System.Drawing.Size(56, 17);
this.Label1.TabIndex = 0;
this.Label1.Text = "基本工资";
//
// 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 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 @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 @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 @Original_职务工资 IS NULL AND 职务工资 IS NULL) AND (请假扣除 = @Original_请假扣除 OR @Original_请假扣除 IS NULL AND 请假扣除 IS NULL)";
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.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.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));
//
// SqlUpdateCommand1
//
this.SqlUpdateCommand1.CommandText = "UPDATE 月工资统计表 SET 基本工资 = @基本工资, 浮动工资 = @浮动工资, 合同补 = @合同补, 粮副补 = @粮副补, 房补 = @房补, 临" +
"时补 = @临时补, 职务工资 = @职务工资, 工龄工资 = @工龄工资, 考核工资 = @考核工资, 奖金 = @奖金, 房租 = @房租, 水电费 = @" +
"水电费, 请假扣除 = @请假扣除, 考勤扣除 = @考勤扣除, 罚款 = @罚款, 住房公积金 = @住房公积金, 医疗保险 = @医疗保险, 养老保险 = " +
"@养老保险, 失业保险 = @失业保险, 生育保险 = @生育保险, 工伤保险 = @工伤保险, 职员编号 = @职员编号 WHERE (职员编号 = @Ori" +
"ginal_职员编号) 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 (医疗保险 = @Or" +
"iginal_医疗保险 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_失业保险 I" +
"S NULL AND 失业保险 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 (水电费 = @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 N" +
"ULL) 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 @Ori" +
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -