private void btn_confirm_Click(object sender, EventArgs e)
{
string newtid = tbox_tid.Text.Trim();
string tname = tbox_tname.Text.Trim();
string tsex = cbox_sex.Text;
string tdept = tbox_dep.Text.Trim();
string title = tbox_title.Text.Trim();
string tsalary = tbox_salary.Text.Trim();
string temail = tbox_email.Text.Trim();
string ttel = tbox_email.Text.Trim();
string sql = "update teachers set tid='" + newtid + "',tname='" + tname + "',tsex='" + tsex + "',tdept='" + tdept + "',title='" + title + "',tsalary=" + int.Parse(tsalary) + ",temail='" + temail + "',ttel='" + ttel + "' where tid = '" + oldtid + "'";
if (Ad_TeacherManage.ExecuteSql(sql) != 0)
{
MessageBox.Show("修改成功！");
}
this.pform.Show();
this.Close();
}
private void btn_confirm_Click(object sender, EventArgs e)
{
string tid = tbox_tid.Text.Trim();
string tname = tbox_tname.Text.Trim();
string tsex = cbox_sex.Text;
string tdept = tbox_dep.Text.Trim();
string title = tbox_title.Text.Trim();
string tsalary = tbox_salary.Text.Trim();
string temail = tbox_email.Text.Trim();
string ttel = tbox_tel.Text.Trim();
string ttime = DateTime.Now.ToString();
string sql = "insert into teachers(tid,tname,tsex,tdept,title,tsalary,temail,ttel,ttime) values('" + tid + "','" + tname + "','" + tsex + "','" + tdept + "','" + title + "'," + int.Parse(tsalary) + ",'" + temail + "','" + ttel + "','" + ttime + "')";
if (Ad_TeacherManage.ExecuteSql(sql) != 0)//向源数据库传递并执行SQL语句
{
MessageBox.Show("添加教师信息成功！");
}
this.pform.Show();
this.Close();
}