/// <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));
}
