public ActionResult EditUnitQuestion(Course_Question model)
{
Course_UnitQuestionBLL bll = new Course_UnitQuestionBLL();
if (bll.UpdateCourseQuestion(model))
{
return Json(new { Result = true, Msg = "修改成功!" }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { Result = false, Msg = "修改失败!" }, JsonRequestBehavior.AllowGet);
}
}
/// <summary>
/// 更新一条单元活动考试试题记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateCourseQuestion(Course_Question model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update [dbo].[Course_UnitQuestion] set ");
sql.Append("[Content]=@Content,[QTtype]=@QTtype,[Question]=@Question,[Answer]=@Answer,[Credit]=@Credit");
sql.Append(" where [Id]=@Id");
SqlParameter[] cmdParams = new SqlParameter[] {
new SqlParameter("@Id", SqlDbType.Int, 4) { Value = model.Id },
new SqlParameter("@Content", SqlDbType.VarChar, 2000) { Value = model.Content },
new SqlParameter("@QTtype", SqlDbType.Int, 4) { Value = model.QTtype },
new SqlParameter("@Question", SqlDbType.VarChar, 8000) { Value = model.Question },
new SqlParameter("@Answer", SqlDbType.VarChar, 100) { Value = model.Answer },
new SqlParameter("@Credit", SqlDbType.Float, 8) { Value = model.Credit },
};
return MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), cmdParams);
}
/// <summary>
/// 更新一条单元活动考试试题记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCourseQuestion(Course_Question model)
{
return dal.UpdateCourseQuestion(model) > 0;
}
