SysUserLdapService.cs 2.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
  1. // Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
  2. //
  3. // 本项目主要遵循 MIT 许可证和 Apache 许可证(版本 2.0)进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
  4. //
  5. // 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动!任何基于本项目二次开发而产生的一切法律纠纷和责任,我们不承担任何责任!
  6. namespace Admin.NET.Core.Service;
  7. /// <summary>
  8. /// 用户域账号服务
  9. /// </summary>
  10. public class SysUserLdapService : ITransient
  11. {
  12. private readonly ISqlSugarClient _db;
  13. private SimpleClient<SysUserLdap> sysUserLdapRep = null;
  14. public SysUserLdapService(ISqlSugarClient db)
  15. {
  16. _db = db;
  17. }
  18. public SimpleClient<SysUserLdap> SysUserLdapRep
  19. {
  20. get
  21. {
  22. sysUserLdapRep ??= _db.GetSimpleClient<SysUserLdap>();
  23. return sysUserLdapRep;
  24. }
  25. }
  26. /// <summary>
  27. /// 批量插入域账号
  28. /// </summary>
  29. /// <param name="tenantId"></param>
  30. /// <param name="sysUserLdaps"></param>
  31. /// <returns></returns>
  32. public async Task InsertUserLdaps(long tenantId, List<SysUserLdap> sysUserLdaps)
  33. {
  34. await SysUserLdapRep.DeleteAsync(u => u.TenantId == tenantId);
  35. await SysUserLdapRep.InsertRangeAsync(sysUserLdaps);
  36. await SysUserLdapRep.AsUpdateable()
  37. .InnerJoin<SysUser>((l, u) => l.EmployeeId == u.Account && u.Status == StatusEnum.Enable && u.IsDelete == false && l.IsDelete == false)
  38. .SetColumns((l, u) => new SysUserLdap { UserId = u.Id })
  39. .ExecuteCommandAsync();
  40. }
  41. /// <summary>
  42. /// 增加域账号
  43. /// </summary>
  44. /// <param name="tenantId"></param>
  45. /// <param name="userId"></param>
  46. /// <param name="account"></param>
  47. /// <param name="domainAccount"></param>
  48. /// <returns></returns>
  49. public async Task AddUserLdap(long tenantId, long userId, string account, string domainAccount)
  50. {
  51. var userLdap = await SysUserLdapRep.GetFirstAsync(u => u.TenantId == tenantId && u.IsDelete == false && (u.Account == account || u.UserId == userId || u.EmployeeId == domainAccount));
  52. if (userLdap != null)
  53. await SysUserLdapRep.DeleteByIdAsync(userLdap.Id);
  54. if (!string.IsNullOrWhiteSpace(domainAccount))
  55. await SysUserLdapRep.InsertAsync(new SysUserLdap { EmployeeId = account, TenantId = tenantId, UserId = userId, Account = domainAccount });
  56. }
  57. /// <summary>
  58. /// 删除域账号
  59. /// </summary>
  60. /// <param name="userId"></param>
  61. /// <returns></returns>
  62. public async Task DeleteUserLdapByUserId(long userId)
  63. {
  64. await SysUserLdapRep.DeleteAsync(u => u.UserId == userId);
  65. }
  66. }