| | |
| | | .Where(it => it.TaskInfoUser.TaskInfoId == request.Id) |
| | | .Select(it => new ExportTaskCheckReceiveTaskUsersCommandModel |
| | | { |
| | | UserId = it.TaskInfoUser.EnterpriseEmployee.UserId!.Value, |
| | | Name = it.TaskInfoUser.EnterpriseEmployee.User.Name, |
| | | Identity = it.TaskInfoUser.EnterpriseEmployee.User.Identity, |
| | | ContactPhoneNumber = it.TaskInfoUser.EnterpriseEmployee.User.ContactPhoneNumber, |
| | |
| | | Code = "456" |
| | | }) |
| | | .ToListAsync(cancellationToken); |
| | | if (models.IsNotNull()) |
| | | { |
| | | var userIds = models.DistinctSelect(it => it.UserId); |
| | | var bankCards = await repTaskInfoUserSubmit.Change<UserBankCard>().AsQueryable().AsNoTracking() |
| | | .Where(it => userIds.Contains(it.UserId)) |
| | | .Select(it => new |
| | | { |
| | | it.UserId, |
| | | it.Bank, |
| | | it.Code |
| | | }) |
| | | .ToListAsync(cancellationToken); |
| | | foreach (var model in models) |
| | | { |
| | | var bankCard = bankCards.FirstOrDefault(it => it.UserId == model.UserId); |
| | | model.Bank = bankCard?.Bank; |
| | | model.Code = bankCard?.Code; |
| | | } |
| | | } |
| | | |
| | | var url = await models.ExportExcelToOSS("TaskCheckReceive/Export", "验收记录.xlsx"); |
| | | url = AliyunOSSUtils.GetUrl(url); |
| | | return url; |