//添加、修改
protected void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "添加")
{
Teacher model = new Teacher();
model.Pwd = txtPwd.Value.Trim();
model.TeacherCode = txtTeacherCode.Value.Trim();
model.TeacherName = txtTeacherName.Value.Trim();
if (TeacherBLL.IsTrue(model.TeacherCode))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该教工号已经存在，不能重复！');</script>");
return;
}
else
{
if (TeacherBLL.AddTeacher(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');window.location.replace('TeacherManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败！');</script>");
return;
}
}
}
else
{
Teacher model = TeacherBLL.GetIdByTeacher(Convert.ToInt32(Request.QueryString["uid"]));
model.Pwd = txtPwd.Value.Trim();
model.TeacherCode = txtTeacherCode.Value.Trim();
model.TeacherName = txtTeacherName.Value.Trim();
if (TeacherBLL.IsTrue(model.TeacherCode, model.TeacherId))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该教工号已经存在，不能重复！');</script>");
return;
}
else
{
if (TeacherBLL.UpdateTeacher(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');window.location.replace('TeacherManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败！');</script>");
return;
}
}
}
}
protected void bt_Save_Click(object sender, EventArgs e)
{
string tid = tb_tid.Text.Trim();
string TPwd = generateMd5(tb_tpwd.Text.ToString());
string tname = tb_name.Text.Trim();
string tphnoe = tb_phone.Text.Trim();
int IsAdmin = 0;
int TeacherState = 1;
DateTime TeacherCreateTime = DateTime.Now;
int b = db.proc_selectExistTeaByTId(tid);
if (b >= 1)
{
errAlert("该工号已经存在，请核对！");
// Response.Write("<script>alert('该工号已经存在，请核对！')</script>");
}
else
{
//db.proc_InsertTeacher(tid,TPwd,tname,tphnoe,IsAdmin,TeacherState,TeacherCreateTime);
//db.SubmitChanges();
Teacher teacher = new Teacher()
{
TId = tid,
TPwd = TPwd,
TName = tname,
TPhone = tphnoe,
IsAdmin = 0,
TeacherState = TeacherState,
TeacherCreateDate = TeacherCreateTime,
isExamTeacher = 0
};
if (teacherBll.AddTeacher(teacher) > 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "succeed", "<script>window.alert('添加教师成功！');window.location='ManageTeacher.aspx';</script>");
}
}
}
private void btnAddban_Click(object sender, EventArgs e)
{
TeacherBLL teacher = new TeacherBLL();
TeachersModel model = new TeachersModel();
if (string.IsNullOrEmpty(txtbanName.Text))
{
MessageBox.Show("班主姓名不能为空");
this.txtbanName.Text = "";
return;
}
if (string.IsNullOrEmpty(txtbanTel.Text))
{
MessageBox.Show("班主电话不能为空");
this.txtbanTel.Text = "";
return;
}
if (txtbanTel.Text.Length != 11)
{
MessageBox.Show("手机号必须11位");
}
if (string.IsNullOrEmpty(txtdidian.Text))
{
MessageBox.Show("班主籍贯不能为空");
this.txtdidian.Text = "";
return;
}
model.Teacher_Name = this.txtbanName.Text;
model.Teacher_Tel = this.txtbanTel.Text;
model.Teacher_Sex = this.cmbbansex.SelectedItem.ToString();
model.Teacher_InDate = this.daTimeru.Value;
model.Teacher_Birthday = this.daTimechu.Value;
model.Teacher_Origin = this.txtdidian.Text;
teacher.AddTeacher(model);
GetAllTeacher();
}
private void btnAdd_Click(object sender, EventArgs e)
{
#region sql语句进行添加，已注释
//TeacherBLL objTeacherBLL = new TeacherBLL();
//TeacherModel Teacher = new TeacherModel();
//Teacher.TeaNum = txtNum.Text ;
//Teacher.TeaName = txtName.Text;
//Teacher.TeaSex = cmbSex.Text;
//Teacher.TeaAdress = txtAdress.Text;
//Teacher.TeaPhone = txtPhone.Text;
//Teacher.TeaTitle = txtTitle.Text;
//if(objTeacherBLL.AddTeacher(Teacher)==true)
// MessageBox.Show("数据添加成功");
//else
// MessageBox.Show("数据添加失败");
//dgvTeacherInfo.DataSource = objTeacherBLL.ShowTeacher();
#endregion
#region //存储过程 已注释
////SqlConnection objConn = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=StuManageSystem_2008;Integrated Security=True");
////objConn.Open();
////SqlCommand objSqlCommand = new SqlCommand();
//objSqlCommand.Connection = objConn;
//objSqlCommand.CommandType = CommandType.StoredProcedure;
//objSqlCommand.CommandText = "Teachers";
//objSqlCommand.Parameters.Add("@TeaName", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaName"].Value = txtName.Text;
//objSqlCommand.Parameters.Add("@Sex", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaSex"].Value = txtSex.Text;
//objSqlCommand.Parameters.Add("@TeaAdress", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaAdress"].Value = txtAdress.Text;
//objSqlCommand.Parameters.Add("@TeaPhone", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaPhone"].Value = txtPhone.Text;
//objSqlCommand.Parameters.Add("@TeaTitle", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaTitle"].Value = txtTitle.Text;
//if (objSqlCommand.EndExecuteNonQuery() > 0)
// MessageBox.Show("添加成功");
//else MessageBox.Show("添加失败");
//objConn.Close();
//调用类的后半段
//string SqlString = "select*from dbo.Teacher";
// dgvTeacherInfo.DataSource = objDataBase.GetDataSet(SqlString).Tables[0];
//SqlCommand objSqlCommand = new SqlCommand();
//objSqlCommand.CommandType = CommandType.StoredProcedure;
//objSqlCommand.CommandText = "studentInsert";
//objSqlCommand.Parameters.AddWithValue("@TeaNum", txtNum.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaName", txtName.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaSex", cmbSex.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaAdress ", txtAdress.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaPhone", txtPhone.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaTitle", txtTitle.Text);
//SQLClass1 objdatabase = new SQLClass1();
//if (objdatabase.GetExecute1(objSqlCommand))
// MessageBox.Show("添加成功");
//else
// MessageBox.Show("添加失败");
//showDGV();
#endregion
if (txtTeaNum.Text=="" || txtTeaName.Text == "")
{
MessageBox.Show("工号和姓名都不能为空！\n 请重新输入！");
}
else
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaAdress = txtTeaAddress.Text;
objTeacherModel.TeaName = txtTeaName.Text;
objTeacherModel.TeaNum = txtTeaNum.Text;
objTeacherModel.TeaPhone = txtTeaPhone.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
objTeacherModel.TeaSex = cbxTeaSex.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
if (objTeacherBLL.AddTeacher(objTeacherModel) == true)
{
MessageBox.Show("增加成功！");
}
else
MessageBox.Show("增加失败！");
}
}