//添加、修改 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("增加失败!"); } }