/// <summary> /// 审核任务列表 /// </summary> /// <param name="user"></param> /// <param name="condition"></param> /// <param name="cancellationToken"></param> /// <returns></returns> public async Task <PagingResponseMessage <TasksExamineResponse> > TasksExaminelistAsync(UserInfo user, TaskExamineListRequest condition, CancellationToken cancellationToken = default(CancellationToken)) { var response = new PagingResponseMessage <TasksExamineResponse>(); response.Extension = new List <TasksExamineResponse>(); var taskInfoQuery = _iTaskStore.GetTaskExamineList(condition.PeriodId); if (!string.IsNullOrWhiteSpace(condition.TaskName)) //任务名称 { taskInfoQuery = taskInfoQuery.Where(task => task.TaskName.Contains(condition.TaskName)); } if (condition.ExamineState != null) //审核状态 { taskInfoQuery = taskInfoQuery.Where(task => task.ExamineState == condition.ExamineState); } if (!string.IsNullOrWhiteSpace(condition.CreateUser)) //发布人 { taskInfoQuery = taskInfoQuery.Where(task => task.CreateUser.Contains(condition.CreateUser)); } if (condition.StartTime.HasValue)//发布开始时间 { taskInfoQuery = taskInfoQuery.Where(task => task.CreateTime >= condition.StartTime); } if (condition.EndTime.HasValue)//发布结束时间 { taskInfoQuery = taskInfoQuery.Where(task => task.CreateTime <= condition.EndTime); } response.PageIndex = condition.PageIndex; response.PageSize = condition.PageSize; response.TotalCount = await taskInfoQuery.CountAsync(); var taskInfoList = await taskInfoQuery.Skip(condition.PageIndex *condition.PageSize).Take(condition.PageSize).ToListAsync(); // 19-12-10 查询任务接取人 var taskIds = taskInfoList.Select(a => a.Id); var periodId = condition.PeriodId; var taskUsers = await(from tu in _iTaskStore.GetTaskUsers() where taskIds.Contains(tu.TaskId) join u in _iUserStore.GetUserInfos() on tu.UserId equals u.Id select new TasksExamineResponse.TaskUserDetails4 { TaskId = tu.TaskId, UserId = tu.UserId, UserName = u.UserName, OrganizationName = u.OrganizationName, GroupName = u.GroupName, }) //.OrderBy(a => a.TaskId) //// 20200107-修复-王森 一个格子里面显示两行每行3个总共6个人,多的不显示 //.Take(6) .ToListAsync(cancellationToken); //任务人员关系表 var taskUserIdQuery = _iTaskStore.GetTaskUsers().Where(w => taskIds.Contains(w.TaskId)).Select(s => s.UserId); //参与人员积分(任务对应赛季的积分) var scoreInfoList = await _iTaskStore.GetScoreInfos().Where(w => taskUserIdQuery.Contains(w.UserId) && w.PeriodId == periodId).ToListAsync(); //称号信息 var titleList = await _iTaskStore.GetScoreTitles().Where(w => !w.IsDelete && w.PeriodId == periodId).ToListAsync(); titleList.ForEach(fo => fo.Icon = _config["FileUrl"] + fo.Icon); taskUsers.ForEach(task => { task.ScoreTitle = (titleList.FirstOrDefault(fi => fi.StartScore <= scoreInfoList.First(f => f.UserId == task.UserId).Score&& fi.EndScore >= scoreInfoList.First(f => f.UserId == task.UserId).Score)?.Title) ?? "未知称号"; task.Icon = titleList.FirstOrDefault(fi => fi.StartScore <= scoreInfoList.First(f => f.UserId == task.UserId).Score&& fi.EndScore >= scoreInfoList.First(f => f.UserId == task.UserId).Score)?.Icon; }); taskInfoList.ForEach(fo => fo.TaskUsers = taskUsers.Where(a => a.TaskId == fo.Id)); response.Extension = taskInfoList; return(response); }
public async Task <PagingResponseMessage <TasksExamineResponse> > TasksExaminelist(Models.UserInfo user, [FromBody] TaskExamineListRequest condition) { Logger.Trace($"用户{user?.UserName ?? ""}({user?.Id ?? ""})获取审核任务列表,请求体为:\r\n{JsonHelper.ToJson(condition)}"); var response = new PagingResponseMessage <TasksExamineResponse>(); try { response = await _taskManager.TasksExaminelistAsync(user, condition); } catch (Exception e) { response.Code = ResponseCodeDefines.ServiceError; response.Message = e.Message; Logger.Trace($"用户{user?.UserName ?? ""}({user?.Id ?? ""})获取审核任务列表,失败:{e.Message}错误堆栈信息:\r\n" + (JsonHelper.ToJson(e.StackTrace))); } return(response); }