public int UpdateGradeInfo(Grade grade)
{
int rowsAffected = 0;
using(GradesDataAccess gradesDataAccess = new GradesDataAccess())
{
rowsAffected = gradesDataAccess.UpdateGradeInfo(grade);
}
return rowsAffected;
}
public int InsertGradeInfo(Grade grade)
{
int rowsAffected = 0;
try
{
DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper("InsertGrade_Info");
dbCommandWrapper.AddInParameter("@info_gradeName",DbType.String,grade.GradeName);
dbCommandWrapper.AddInParameter("@info_gradeRemark",DbType.String,grade.GradeRemark);
dbCommandWrapper.AddInParameter("@info_gradeNumber",DbType.Int32,grade.GradeID);
dbCommandWrapper.AddInParameter("@gradeType",DbType.String,grade.GradeType);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
db.ExecuteNonQuery(dbCommandWrapper);
rowsAffected = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
catch(Exception ex)
{
throw ex;
}
return rowsAffected;
}
//修改年级信息
private void simpleButton_GradeModify_Click(object sender, System.EventArgs e)
{
// if(DialogResult.Yes !=
// MessageBox.Show("确认修改?","系统信息!",
// MessageBoxButtons.OK,MessageBoxIcon.Warning))
// return;
string message = "是否确认修改？";
string caption = "消息提示框!";
DialogResult messageResult = MessageBox.Show(message,caption,MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if ( messageResult != DialogResult.Yes )
return;
int rowsAffected = 0;
Grade grade = new Grade();
grade.GradeID = gradeID;
grade.GradeName = comboBoxEdit_GradeModify.SelectedItem.ToString();
grade.GradeRemark = comboBoxEdit_GradeRemarkModify.SelectedItem.ToString();
if(grade.GradeName!=string.Empty)
{
try
{
rowsAffected = new GradeSystem().UpdateGradeInfo(grade);
if(rowsAffected>0)
{
MessageBox.Show(radioGroup_Grade.SelectedIndex == 0?"年级名称修改成功":"部门名称修改成功","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Information);
gradeDataBinding();
// gradeModifyInfoReset();
}
else if(rowsAffected == -1)
{
MessageBox.Show("年级名称已存在,请重试","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("年级信息修改失败,请重试","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
catch(Exception ex)
{
MessageBox.Show("年级信息修改失败,请重试","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE);
}
}
else
{
MessageBox.Show("请先选择要修改的年级","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
//保存年级信息
private void simpleButton_GradeInfoSave_Click(object sender, System.EventArgs e)
{
if(textEdit_GradeName.Text.Trim() != string.Empty)//检查数据是否合法
{
Grade grade = new Grade();
grade.GradeName = textEdit_GradeName.Text.Trim();
if (comboBoxEdit_gradeNumber.SelectedItem.ToString().Equals("已到达年级最大容量"))
{
MessageBox.Show("年级容量已经到达最大容量，无法进行添加操作！");
return;
}
if (radioGroup_Grade.SelectedIndex == 0) grade.GradeID = Convert.ToInt32(comboBoxEdit_gradeNumber.SelectedItem);
else grade.GradeID = 0;
grade.GradeRemark = comboBoxEdit_GradeRemark.SelectedItem.ToString();
grade.GradeType = radioGroup_Grade.SelectedIndex.ToString();
int rowsAffected = 0;
try
{
rowsAffected = new GradeSystem().InsertGradeInfo(grade);
if(rowsAffected > 0)
{
//清空文本框
resetGradeInfoAdd();
MessageBox.Show("插入成功.","系统信息!",MessageBoxButtons.OK,MessageBoxIcon.Information);
gradeDataBinding();//重新绑定年级信息
}
else if(rowsAffected == -1)
{
string info = radioGroup_Grade.SelectedIndex == 0 ? "年级" : "部门";
MessageBox.Show(info+"名称重复,请更改名称后重试","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("插入失败,请重试","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
catch(Exception ex)
{
MessageBox.Show("插入失败,请重试","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Information);
CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE);
}
}
else
{
MessageBox.Show("*号为必须填写内容,请检查输入","系统信息!",
MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
public int UpdateGradeInfo(Grade grade)
{
return new GradeRules().UpdateGradeInfo(grade);
}
public int InsertGradeInfo(Grade grade)
{
return new GradeRules().InsertGradeInfo(grade);
}
