/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
if (txtGradeCheckApplyReasonTitle.Text.Trim().Length == 0)
{
Javascript.GoHistory(-1, "请输入重修重考原因标题：）", Page);
}
else
{
DalOperationAboutGradeCheckApplyReason dal = new DalOperationAboutGradeCheckApplyReason();
StudentsGradeCheckApplyReason model = new StudentsGradeCheckApplyReason();
model.gradeCheckApplyReasonTitle = txtGradeCheckApplyReasonTitle.Text.Trim();
model.gradeCheckApplyReasonRemark = txtGradeCheckApplyReasonRemark.Text.Trim();
try
{
dal.Add(model);//添加
Javascript.RefreshParentWindow("添加重修重考原因成功！", "/Administrator/StudentManager.aspx?fragment=3", Page);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
Javascript.GoHistory(-1, "添加重修重考原因失败,请检查格式是否有误：(", Page);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(StudentsGradeCheckApplyReason model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into usta_StudentsGradeCheckApplyReason(");
strSql.Append("gradeCheckApplyReasonTitle,gradeCheckApplyReasonRemark)");
strSql.Append(" values (");
strSql.Append("@gradeCheckApplyReasonTitle,@gradeCheckApplyReasonRemark);");
SqlParameter[] parameters = {
new SqlParameter("@gradeCheckApplyReasonTitle", SqlDbType.NVarChar,50),
new SqlParameter("@gradeCheckApplyReasonRemark", SqlDbType.NVarChar,200)};
parameters[0].Value = model.gradeCheckApplyReasonTitle;
parameters[1].Value = model.gradeCheckApplyReasonRemark;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(StudentsGradeCheckApplyReason model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update usta_StudentsGradeCheckApplyReason set ");
strSql.Append("gradeCheckApplyReasonTitle=@gradeCheckApplyReasonTitle,");
strSql.Append("gradeCheckApplyReasonRemark=@gradeCheckApplyReasonRemark");
strSql.Append(" where gradeCheckApplyReasonId=@gradeCheckApplyReasonId");
SqlParameter[] parameters = {
new SqlParameter("@gradeCheckApplyReasonTitle", SqlDbType.NVarChar,50),
new SqlParameter("@gradeCheckApplyReasonRemark", SqlDbType.NVarChar,200),
new SqlParameter("@gradeCheckApplyReasonId", SqlDbType.Int,4)};
parameters[0].Value = model.gradeCheckApplyReasonTitle;
parameters[1].Value = model.gradeCheckApplyReasonRemark;
parameters[2].Value = model.gradeCheckApplyReasonId;
int rows = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
