ke_junjie
2025-06-04 84620534eb627e95811b971a4b552b6a177829bf
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
using iWare.Wms.Core;
using Furion.DatabaseAccessor;
using Furion.DependencyInjection;
using Microsoft.EntityFrameworkCore;
 
namespace iWare.Wms.Application
{
    /// <summary>
    /// 员工附属机构和职位服务
    /// </summary>
    public class SysEmpExtOrgPosService : ISysEmpExtOrgPosService, ITransient
    {
        private readonly IRepository<SysEmpExtOrgPos> _sysEmpExtOrgPosRep;  // 附属机构表仓储
 
        public SysEmpExtOrgPosService(IRepository<SysEmpExtOrgPos> sysEmpExtOrgPosRep)
        {
            _sysEmpExtOrgPosRep = sysEmpExtOrgPosRep;
        }
 
        /// <summary>
        /// 保存或编辑附属机构相关信息
        /// </summary>
        /// <returns></returns>
        [UnitOfWork]
        public async Task AddOrUpdate(long empId, List<EmpExtOrgPosOutput> extIdList)
        {
            // 先删除
            await DeleteEmpExtInfoByUserId(empId);
 
            var extOrgPos = extIdList.Select(u => new SysEmpExtOrgPos
            {
                SysEmpId = empId,
                SysOrgId = u.OrgId,
                SysPosId = u.PosId
            }).ToList();
            await _sysEmpExtOrgPosRep.InsertAsync(extOrgPos);
        }
 
        /// <summary>
        /// 获取附属机构和职位信息
        /// </summary>
        /// <param name="empId"></param>
        /// <returns></returns>
        public async Task<List<EmpExtOrgPosOutput>> GetEmpExtOrgPosList(long empId)
        {
            return await _sysEmpExtOrgPosRep.DetachedEntities
                                            .Where(u => u.SysEmpId == empId)
                                            .Select(u => new EmpExtOrgPosOutput
                                            {
                                                OrgId = u.SysOrg.Id,
                                                OrgCode = u.SysOrg.Code,
                                                OrgName = u.SysOrg.Name,
                                                PosId = u.SysPos.Id,
                                                PosCode = u.SysPos.Code,
                                                PosName = u.SysPos.Name
                                            }).ToListAsync();
        }
 
        /// <summary>
        /// 根据机构Id判断该附属机构下是否有员工
        /// </summary>
        /// <param name="orgId"></param>
        /// <returns></returns>
        public async Task<bool> HasExtOrgEmp(long orgId)
        {
            return await _sysEmpExtOrgPosRep.DetachedEntities.AnyAsync(u => u.SysOrgId == orgId);
        }
 
        /// <summary>
        /// 根据职位Id判断该附属职位下是否有员工
        /// </summary>
        /// <param name="posId"></param>
        /// <returns></returns>
        public async Task<bool> HasExtPosEmp(long posId)
        {
            return await _sysEmpExtOrgPosRep.DetachedEntities.AnyAsync(u => u.SysPosId == posId);
        }
 
        /// <summary>
        /// 根据员工Id删除对应的员工-附属信息
        /// </summary>
        /// <param name="empId"></param>
        /// <returns></returns>
        public async Task DeleteEmpExtInfoByUserId(long empId)
        {
            var eeoprList = await _sysEmpExtOrgPosRep.AsQueryable(u => u.SysEmpId == empId, false).ToListAsync();
            await _sysEmpExtOrgPosRep.DeleteAsync(eeoprList);
        }
    }
}