pref:搜索

sunpengfei

2025-08-05 5a5a0ed1fa93a83537eb36e69fac5a14994dc103

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
using FlexJobApi.Core;
using Furion.DatabaseAccessor;
using MediatR;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace FlexJobApi.User.Application
{
    /// <summary>
    /// 获取运营端用户分页列表
    /// </summary>
    public class GetOperationUserInfosQueryHandler(
            IRepository<UserInfo> repUser,
            IRepository<UserInfoRole> repUserInfoRole
        ) : IRequestHandler<GetOperationUserInfosQuery, PagedListQueryResult<GetOperationUserInfosQueryResultItem>>
    {
        private readonly IRepository<UserInfo> repUser = repUser;
        private readonly IRepository<UserInfoRole> repUserInfoRole = repUserInfoRole;
 
        /// <inheritdoc/>
        public async Task<PagedListQueryResult<GetOperationUserInfosQueryResultItem>> Handle(GetOperationUserInfosQuery request, CancellationToken cancellationToken)
        {
            var q = repUser.AsQueryable().AsNoTracking()
                .OrderByDescending(it => it.Level).ThenByDescending(it => it.CreatedTime)
                .Where(it => it.Type == EnumUserType.Operation);
            if (request.Keywords.IsNotNull())
            {
                q = q.Where(it => 
                    it.UserAuth.Name.Contains(request.Keywords)
                    || it.UserAuth.UserName.Contains(request.Keywords)
                    || it.UserAuth.PhoneNumber.Contains(request.Keywords)
                    || it.Remark.Contains(request.Keywords));
            }
            var result = await q
                .Select(it => new GetOperationUserInfosQueryResultItem
                {
                    Id = it.Id,
                    Name = it.UserAuth.Name,
                    UserName = it.UserAuth.UserName,
                    PhoneNumber = it.UserAuth.PhoneNumber,
                    Remark = it.Remark
                })
                .ToPagedListAsync(request.PageModel, cancellationToken);
            if (result.Data.Any())
            {
                var ids = result.Data.DistinctSelect(it => it.Id);
                var userRoles = await repUserInfoRole.AsQueryable().AsNoTracking()
                    .Include(it => it.Role)
                    .Where(it => ids.Contains(it.UserInfoId))
                    .Select(it => new GetOperationUserInfosQueryResultItemRole
                    {
                        UserInfoId = it.UserInfoId,
                        Id = it.RoleId,
                        Name = it.Role.Name
                    })
                    .ToListAsync(cancellationToken);
                foreach (var item in result.Data)
                {
                    item.Roles = userRoles.Where(it => it.UserInfoId == item.Id).ToList();
                }
            }
            return result;
        }
    }
}