private void button2_Click(object sender, EventArgs e) { if (b == false) { MessageBox.Show("请先查询!", "警告!"); return; } //判断教工号【是否符合条件,是否被修改】 if (!mTeacher.Id.Equals(textBox1.Text.ToString().Trim())) { if(Util.checkTeacherId(textBox1.Text.ToString().Trim())) mTeacher.Id = textBox1.Text.ToString().Trim();//如果教工号改变则重新为mTeacher的id赋值; else { textBox1.Select(); return; } } //开始为mTeacher赋值 mTeacher.Name = textBox2.Text.ToString().Trim(); if (rb1.Checked) mTeacher.Sex = "男"; else mTeacher.Sex = "女"; mTeacher.Organization = textBox3.Text.ToString().Trim(); mTeacher.Address = textBox4.Text.ToString().Trim(); mTeacher.Phone = textBox5.Text.ToString().Trim(); TeacherDB tdb = new TeacherDB(); tdb.updata(mTeacher); if (tdb.updata(mTeacher) == 0) { MessageBox.Show("修改失败!", "警告!"); return; } else { MessageBox.Show("修改成功!", "消息!"); TeacherSelect._getInstance().resetData(); SalarySelect._getInstance().resetData(); } //如果控件已经存在就删除重建; textBox1.Text = ""; Util.checkView(this); b = false;//查询未完成 }
private void button2_Click(object sender, EventArgs e) { if (b == false) { MessageBox.Show("请先查询!", "警告!"); return; } //判断教工号【是否符合条件,是否被修改】 if (!mTeacher.Id.Equals(textBox1.Text.ToString().Trim())) { if (Util.checkTeacherId(textBox1.Text.ToString().Trim())) mTeacher.Id = textBox1.Text.ToString().Trim();//如果教工号改变则重新为mTeacher的id赋值; else { textBox1.Select(); return; } } int f;//临时变量判断所有值是否全部检查通过; if ((f=Util.checkNum(textBox2.Text.ToString().Trim()))==0) mTeacher.BaseSalary = float.Parse(textBox2.Text.ToString().Trim()); else { if(f==1) MessageBox.Show("请输入正确数值!(基本工资)", "警告!"); else MessageBox.Show("请输入数值!(基本工资)", "警告!"); textBox2.Select(); return; } if ((f=Util.checkNum(textBox3.Text.ToString().Trim()))==0) mTeacher.Allowance = float.Parse(textBox3.Text.ToString().Trim()); else { if (f == 1) MessageBox.Show("请输入正确数值!(津贴)", "警告!"); else MessageBox.Show("请输入数值!(津贴)", "警告!"); textBox3.Select(); return; } if ((f=Util.checkNum(textBox4.Text.ToString().Trim()))==0) mTeacher.Fund = float.Parse(textBox4.Text.ToString().Trim()); else { if (f == 1) MessageBox.Show("请输入正确数值!(公积金)", "警告!"); else MessageBox.Show("请输入数值!(公积金)", "警告!"); textBox4.Select(); return; } if ((f=Util.checkNum(textBox5.Text.ToString().Trim()))==0) mTeacher.Sanitary = float.Parse(textBox5.Text.ToString().Trim()); else { if (f == 1) MessageBox.Show("请输入正确数值!(生活费)", "警告!"); else MessageBox.Show("请输入数值!(生活费)", "警告!"); textBox5.Select(); return; } if ((f=Util.checkNum(textBox6.Text.ToString().Trim()))==0) mTeacher.IncomeTax = float.Parse(textBox6.Text.ToString().Trim()); else { if (f == 1) MessageBox.Show("请输入正确数值!(所得税)", "警告!"); else MessageBox.Show("请输入数值!(所得税)", "警告!"); textBox6.Select(); return; } TeacherDB tdb = new TeacherDB(); if (tdb.updata(mTeacher) == 0) { MessageBox.Show("修改失败!", "警告!"); return; } else { MessageBox.Show("修改成功!", "消息!"); TeacherSelect._getInstance().resetData(); SalarySelect._getInstance().resetData(); } //如果控件已经存在就删除重建; textBox1.Text = ""; Util.checkView(this); }
private void button1_Click(object sender, EventArgs e) { flag = true;//初始化flag //判断教工号格式 if(!Util.checkInputTeacherId(textBox1.Text.ToString().Trim(),label7,1)) flag=false; //判断基本工资 if (!Util.checkSalary(textBox2, label8)) flag = false; //判断津贴 if (!Util.checkSalary(textBox3, label9)) flag = false; //判断公积金 if (!Util.checkSalary(textBox4, label10)) flag = false; //判断生活费 if (!Util.checkSalary(textBox5, label11)) flag = false; //判断所得税 if (!Util.checkSalary(textBox6, label12)) flag = false; if (flag == true) { Teacher mTeacher = new TeacherDB().selectTeacherById(textBox1.Text.ToString().Trim()); mTeacher.BaseSalary = float.Parse(textBox2.Text.ToString().Trim()); mTeacher.Allowance = float.Parse(textBox3.Text.ToString().Trim()); mTeacher.Fund = float.Parse(textBox4.Text.ToString().Trim()); mTeacher.Sanitary = float.Parse(textBox5.Text.ToString().Trim()); mTeacher.IncomeTax = float.Parse(textBox6.Text.ToString().Trim()); TeacherDB tdb = new TeacherDB(); if (tdb.updata(mTeacher) == 0) { MessageBox.Show("插入失败!", "警告!"); return; } else { TeacherSelect._getInstance().resetData(); SalarySelect._getInstance().resetData(); MessageBox.Show("插入成功!", "消息!"); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; label7.Text = ""; label8.Text = ""; label9.Text = ""; label10.Text = ""; label11.Text = ""; label12.Text = ""; } } }