public ActionResult UpdateCourse() { log.Debug(Constant.DEBUG_START); string idString = ApiQueryUtil.QueryArgByPost("id"); string name = ApiQueryUtil.QueryArgByPost("name"); string description = ApiQueryUtil.QueryArgByPost("description"); ServiceInvokeDTO result = null; try { Course course = new Course(); course.ID = Convert.ToInt32(idString); course.Name = name; course.Description = description; result = itemDataService.UpdateCourse(course); } catch (Exception ex) { log.Error(ex); result = new ServiceInvokeDTO(InvokeCode.SYS_INNER_ERROR); } string json = JsonConvert.SerializeObject(result, Formatting.Indented, Constant.TIME_CONVERTER); log.Debug(Constant.DEBUG_END); return Content(json, Constant.JSON_MIME_TYPE); }
/// <summary> /// 添加实体信息,返回添加成功后的主键ID /// </summary> public int Insert(Course course) { int id = 0; const string sql = @"INSERT INTO Course(Name, Description) VALUES (@Name, @Description); SELECT LAST_INSERT_ID();"; using (DbConnection connection = ConnectionManager.OpenConnection) { id = connection.Query<int>(sql, course).SingleOrDefault<int>(); } return id; }
/// <summary> /// 更新实体信息 /// </summary> public void Update(Course course) { const string sql = @"UPDATE Course SET Name = @Name, Description= @Description WHERE IsDeleted = 0 AND ID = @ID"; using (DbConnection connection = ConnectionManager.OpenConnection) { connection.Execute(sql, course); } }
/// <summary> /// 添加科目信息 /// </summary> public ServiceInvokeDTO AddCourse(Course course) { log.Debug(Constant.DEBUG_START); ServiceInvokeDTO result = null; try { // check name Course dbCourse = courseDAL.GetByName(course.Name); if (dbCourse == null) { courseDAL.Insert(course); result = new ServiceInvokeDTO(InvokeCode.SYS_INVOKE_SUCCESS); } else { result = new ServiceInvokeDTO(InvokeCode.ITEM_COURSE_NAME_EXIST_ERROR); } } catch (Exception ex) { log.Error(ex); throw ex; } log.Debug(Constant.DEBUG_END); return result; }