/// <summary> /// /// </summary> /// <param name="sortGradeCourse"></param> /// <param name="sys_PayGrade">薪酬级别</param> /// <param name="sortIds">体系</param> /// <returns></returns> public JsonResult SubmitSys_SortGradeCourse(Sys_SortGradeCourse sortGradeCourse, string sys_PayGrade = "", string sortIds = "") { if (sortGradeCourse.Id == 0) { //添加 _sysPayGradeBL.AddSys_SortGradeCourse(sortGradeCourse);//添加课程 // loopAddSortGradeCourse(sortGradeCourse, sys_PayGrade, sortIds); if (sortGradeCourse.Id > 0) { return(Json(new { result = 1, content = "保存成功!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { result = 0, content = "保存失败" }, JsonRequestBehavior.AllowGet)); } } else { //修改 bool newid = _sysPayGradeBL.UpdateSys_SortGradeCourse(sortGradeCourse); if (newid) { _sysPayGradeBL.DeleteSys_SortLinkGrade(sortGradeCourse.Id);//删除所有 loopAddSortGradeCourse(sortGradeCourse, sys_PayGrade, sortIds); return(Json(new { result = 1, content = "保存成功" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { result = 0, content = "保存失败" }, JsonRequestBehavior.AllowGet)); } } }
private void loopAddSortGradeCourse(Sys_SortGradeCourse sortGradeCourse, string sys_PayGrade, string sortIds) { string[] payGradeArray = sys_PayGrade.Split(','); string[] sortIdsArray = sortIds.Split(','); foreach (var item in payGradeArray) { foreach (var itemSort in sortIdsArray) { if (!string.IsNullOrEmpty(item) && !string.IsNullOrEmpty(itemSort)) { _sysPayGradeBL.AddSys_SortLinkGrade(new Sys_SortLinkGrade() { GradeID = int.Parse(item), SortID = int.Parse(itemSort), CourseId = sortGradeCourse.Id }); } } } }
/// <summary> /// Update 胜任力课程 /// </summary> /// <returns></returns> public bool UpdateSys_SortGradeCourse(Sys_SortGradeCourse model) { using (var conn = OpenConnection()) { const string sqlwhere = @"update Sys_SortGradeCourse set Name=@Name,OpenLeavel=@OpenLeavel, Type=@Type,IsMust=@IsMust,IsDelete=@IsDelete where Id=@CourseId"; var param = new { CourseId = model.Id, Name = model.Name, OpenLeavel = model.OpenLeavel, Type = model.Type, IsMust = model.IsMust, IsDelete = model.IsDelete }; return(conn.Execute(sqlwhere, param) > 0); } }
/// <summary> /// ADD 胜任力课程 /// </summary> /// <returns></returns> public int AddSys_SortGradeCourse(Sys_SortGradeCourse model) { using (IDbConnection connection = OpenConnection()) { const string strSql = @"insert into Sys_SortGradeCourse(Name,OpenLeavel,Type,IsMust,IsDelete) values(@Name,@OpenLeavel,@Type,@IsMust,0) SELECT @@Identity AS ID"; var param = new { Name = model.Name, OpenLeavel = model.OpenLeavel, Type = model.Type, IsMust = model.IsMust }; decimal id = connection.Query <decimal>(strSql, param) .FirstOrDefault(); model.Id = decimal.ToInt32(id); } return(model.Id); }
/// <summary> /// ADD 胜任力课程 /// </summary> /// <returns></returns> public int AddSys_SortGradeCourse(Sys_SortGradeCourse model) { return(payGradeDB.AddSys_SortGradeCourse(model)); }
/// <summary> /// Update 胜任力课程 /// </summary> /// <returns></returns> public bool UpdateSys_SortGradeCourse(Sys_SortGradeCourse model) { return(payGradeDB.UpdateSys_SortGradeCourse(model)); }