/// <summary> /// 通过岗位ID与技能ID获取岗位模型ID /// </summary> /// <param name="postId"></param> /// <param name="abilityId"></param> /// <returns></returns> public Ab_PostAbility GetPostAbilityRecordId(int postId, int abilityId, int userId) { var data = _dataAccess.FetchListBySql <dynamic>(string.Format(@"select RecordId ,( select count(0) from Len_LearningRecord where LearnPath = 2 and LearnProcess = 2 and SourceId = Ab_PostAbility.RecordId and CourseId not in ( select CourseId from Ab_PostElectiveCourse where PostId = {0} and AbilityId = {1}) and UserId = {2} ) as completeCount ,( select count(0) from Ab_AbilityResource where AbilityId = {1} and ResourceType = 0 and IsDelete = 0 and ResourceId not in ( select CourseId from Ab_PostElectiveCourse where PostId = {0} and AbilityId = {1}) ) as allCount from Ab_PostAbility where postId = {0} and AbilityId = {1} and IsDelete = 0" , postId, abilityId, userId)).FirstOrDefault(); int allCount = (int)data.allCount; int completeCount = (int)data.completeCount; Ab_PostAbility model = new Ab_PostAbility { RecordId = data.RecordId, MySprintPercent = allCount == 0 ? 0 : completeCount * 100 / allCount }; return(model); }
public JsonResult SavePostAbilites(int postId, string abids) { int[] abilityIds = abids.GetArray(); var list = new List <Ab_PostAbility>(); foreach (int abilityId in abilityIds) { var pa = new Ab_PostAbility(); pa.PostId = postId; pa.AbilityId = abilityId; list.Add(pa); } _postAbilityManager.SavePostAbilities(list); return(Json(new { result = 1, msg = Exampaper.SaveSuccess }, JsonRequestBehavior.AllowGet)); }