SysUserLdapService.cs 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. // 大名科技(天津)有限公司 版权所有
  2. //
  3. // 此源代码遵循位于源代码树根目录中的 LICENSE 文件的许可证
  4. //
  5. // 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动
  6. //
  7. // 任何基于本项目二次开发而产生的一切法律纠纷和责任,均与作者无关
  8. using Furion.Localization;
  9. namespace Admin.NET.Core.Service;
  10. /// <summary>
  11. /// 用户域账号对照服务
  12. /// </summary>
  13. [ApiDescriptionSettings(Order = 490)]
  14. public class SysUserLdapService : IDynamicApiController, ITransient
  15. {
  16. private readonly SqlSugarRepository<SysUserLdap> _sysUserLdapRep;
  17. private readonly ISqlSugarClient _sqlSugarClient;
  18. public SysUserLdapService(SqlSugarRepository<SysUserLdap> sysUserLdapRep, ISqlSugarClient sqlSugarClient)
  19. {
  20. _sysUserLdapRep = sysUserLdapRep;
  21. _sqlSugarClient = sqlSugarClient;
  22. }
  23. /// <summary>
  24. /// 批量插入数据
  25. /// </summary>
  26. /// <param name="tenantId"></param>
  27. /// <param name="sysUserLdaps"></param>
  28. /// <returns></returns>
  29. public async Task InsertUserLdapsAsync(long tenantId, List<SysUserLdap> sysUserLdaps)
  30. {
  31. await _sysUserLdapRep.DeleteAsync(u => u.TenantId == tenantId);
  32. await _sysUserLdapRep.InsertRangeAsync(sysUserLdaps);
  33. await _sqlSugarClient.Updateable<SysUserLdap>()
  34. .InnerJoin<SysUser>((l, u) => l.EmployeeId == u.Account && u.Status == StatusEnum.Enable && u.IsDelete == false && l.IsDelete == false)
  35. .SetColumns((l, u) => new SysUserLdap { UserId = u.Id })
  36. .ExecuteCommandAsync();
  37. }
  38. /// <summary>
  39. /// 批量插入数据
  40. /// </summary>
  41. /// <param name="tenantId"></param>
  42. /// <param name="userId"></param>
  43. /// <param name="account"></param>
  44. /// <param name="domainAccount"></param>
  45. /// <returns></returns>
  46. public async Task AddUserLdapAsync(long tenantId, long userId, string account, string domainAccount)
  47. {
  48. var userLdap = _sysUserLdapRep.GetFirstAsync(u => u.TenantId == tenantId && u.IsDelete == false && (u.Account == account || u.UserId == userId || u.EmployeeId == domainAccount));
  49. if (userLdap != null)
  50. await _sysUserLdapRep.DeleteByIdAsync(userLdap.Id);
  51. if (!string.IsNullOrWhiteSpace(domainAccount))
  52. await _sysUserLdapRep.InsertAsync(new SysUserLdap { EmployeeId = account, TenantId = tenantId, UserId = userId, Account = domainAccount });
  53. }
  54. /// <summary>
  55. /// 删除用户关联数据
  56. /// </summary>
  57. /// <param name="userId"></param>
  58. /// <returns></returns>
  59. public async Task DeleteUserLdapByUserId(long userId)
  60. {
  61. await _sysUserLdapRep.DeleteAsync(u => u.UserId == userId);
  62. }
  63. }