//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();
}
