public ActionResult EditCourseDetail(Course_TestRate model) { Course_DetailBLL bll = new Course_DetailBLL(); if (bll.UpdateTestRate(model)) { return Json(new { Result = true, Msg = "设定成功!" }, JsonRequestBehavior.AllowGet); } else { return Json(new { Result = false, Msg = "设定失败!" }, JsonRequestBehavior.AllowGet); } }
private void ConvertToTestRateModel(IDataReader reader, Course_TestRate model) { if (reader["TrainingId"] != DBNull.Value) model.TrainingId = Convert.ToInt32(reader["TrainingId"]); if (reader["ReadingRate"] != DBNull.Value) model.ReadingRate = Convert.ToDouble(reader["ReadingRate"]); if (reader["DisscusRate"] != DBNull.Value) model.DisscusRate = Convert.ToDouble(reader["DisscusRate"]); if (reader["HomeWorkRate"] != DBNull.Value) model.HomeWorkRate = Convert.ToDouble(reader["HomeWorkRate"]); if (reader["QuestionRate"] != DBNull.Value) model.QuestionRate = Convert.ToDouble(reader["QuestionRate"]); if (reader["TestingRate"] != DBNull.Value) model.TestingRate = Convert.ToDouble(reader["TestingRate"]); if (reader["CommentRate"] != DBNull.Value) model.CommentRate = Convert.ToDouble(reader["CommentRate"]); }
/// <summary> /// 取得一条考核比例记录 /// </summary> /// <param name="id"></param> /// <param name="where"></param> /// <returns></returns> public Course_TestRate GetTestRateModel(int TrainingId, string where) { string sql = "select * from [dbo].[Course_Detail] where [TrainingId]=@TrainingId"; if (!string.IsNullOrEmpty(where)) sql += " and " + where; SqlParameter[] cmdParams = new SqlParameter[]{ new SqlParameter("@TrainingId", SqlDbType.Int, 4) { Value = TrainingId } }; using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql, cmdParams)) { if (reader.Read()) { Course_TestRate model = new Course_TestRate(); ConvertToTestRateModel(reader, model); return model; } else { return null; } } }
/// <summary> /// 更新一条考核比例记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateTestRate(Course_TestRate model) { StringBuilder sql = new StringBuilder(); sql.Append("update [dbo].[Course_Detail] set "); sql.Append("[ReadingRate]=@ReadingRate,[DisscusRate]=@DisscusRate,[HomeWorkRate]=@HomeWorkRate,[QuestionRate]=@QuestionRate,[TestingRate]=@TestingRate,[CommentRate]=@CommentRate"); sql.Append(" where [TrainingId]=@TrainingId"); SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@TrainingId", SqlDbType.Int, 4) { Value = model.TrainingId }, new SqlParameter("@ReadingRate", SqlDbType.Float, 8) { Value = model.ReadingRate }, new SqlParameter("@DisscusRate", SqlDbType.Float, 8) { Value = model.DisscusRate }, new SqlParameter("@HomeWorkRate", SqlDbType.Float, 8) { Value = model.HomeWorkRate }, new SqlParameter("@QuestionRate", SqlDbType.Float, 8) { Value = model.QuestionRate }, new SqlParameter("@TestingRate", SqlDbType.Float, 8) { Value = model.TestingRate }, new SqlParameter("@CommentRate", SqlDbType.Float, 8) { Value = model.CommentRate } }; return MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), cmdParams); }
/// <summary> /// 更新一条考核比例记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateTestRate(Course_TestRate model) { return dal.UpdateTestRate(model) > 0; }