//Del: private void btnDel_Click(object sender, EventArgs e) { if (txtProNum.Text == "" || txtDepartName.Text == "" || txtDepartNum.Text == "" || txtProName.Text == "") { MessageBox.Show("专业号、专业名称、系编号、系名称都不能为空!\n 请重新输入!"); } else { ProfessionBLL objProfessionBLL = new ProfessionBLL(); ProfessionModel objProfessionModel = new ProfessionModel(); objProfessionModel.ProNum = txtProNum.Text; if (objProfessionBLL.DelProfession(objProfessionModel) == true) { MessageBox.Show("删除成功!!"); } else { MessageBox.Show("删除失败!"); } } ShowTable(); }
public bool DelProfession(ProfessionModel objProfessionModel) { string SqlString = "delete from profession where ProNum='" + objProfessionModel.ProNum + "'"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); //return (objDataBase.GetExecute(SqlString)); return (objDataBase.GetExecute(SqlString)); }
public bool AddProfessin(ProfessionModel objProfessionModel) { string SqlString = "INSERT INTO Profession(ProNum,ProName,deptNum)VALUES('" + objProfessionModel.ProNum + "','" + objProfessionModel.ProName + "','"+objProfessionModel.DepartNum + "')"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); if (objDataBase.GetExecute(SqlString)) return (true); else return (false); }
public bool UpdateProfession(ProfessionModel objProfessionModel) { string SqlString; //专业编号不可以修改,因它这里它用作搜索条件 ProNum='"+objProfessionModel.ProNum +"', SqlString = "update dbo.profession set ProName='"+objProfessionModel.ProName+"',deptNum='"+ objProfessionModel.DepartNum + "' where ProNum='" + objProfessionModel.ProNum + "'"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); if (objDataBase.GetExecute(SqlString)) return (true); else return (false); }
public bool UpdatejProfession(ProfessionModel objProfessionModel) { ProfessionDAL objProfessionDAL = new ProfessionDAL(); return (objProfessionDAL.UpdateProfession(objProfessionModel)); }
public bool InsertProfession(ProfessionModel objProfessionModel) { ProfessionDAL objProfessionDAL = new ProfessionDAL(); return (objProfessionDAL.AddProfessin(objProfessionModel)); }
public bool DelProfession(ProfessionModel objProfessionModel) { ProfessionDAL objProfessionDAL = new ProfessionDAL(); return (objProfessionDAL.DelProfession(objProfessionModel)); }
//Update: private void btnModify_Click_1(object sender, EventArgs e) { if (txtProNum.Text == "" || txtDepartName.Text == "" || txtDepartNum.Text == "" || txtProName.Text == "") { MessageBox.Show("专业号、专业名称、系编号、系名称都不能为空!\n 请重新输入!"); } else { ProfessionBLL objProfessionBLL = new ProfessionBLL(); ProfessionModel objProfessionModel = new ProfessionModel(); objProfessionModel.ProNum = txtProNum.Text; objProfessionModel.ProName = txtProName.Text; objProfessionModel.DepartNum = txtDepartNum.Text; objProfessionModel.DepartName = txtDepartName.Text; if(objProfessionBLL.UpdatejProfession(objProfessionModel)==true) { MessageBox.Show("修改成功!"); } else MessageBox.Show("修改失败!"); } ShowTable(); }