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 = "";
}
}
}
