SysUser.cs 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. using MiniExcelLibs.Attributes;
  2. using Newtonsoft.Json;
  3. using SqlSugar;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Text;
  7. namespace ZR.Model.System
  8. {
  9. /// <summary>
  10. /// 用户表
  11. /// </summary>
  12. [SugarTable("sys_user")]
  13. [Tenant("0")]
  14. public class SysUser : SysBase
  15. {
  16. /// <summary>
  17. /// 用户id
  18. /// </summary>
  19. [SugarColumn(IsIdentity = true, IsPrimaryKey = true)]
  20. public long UserId { get; set; }
  21. //[Duplication]//校验模板类该列数据是否重复
  22. public string UserName { get; set; }
  23. public string NickName { get; set; }
  24. /// <summary>
  25. /// '用户类型(00系统用户)',
  26. /// </summary>
  27. //[JsonProperty(propertyName: "userType")]
  28. //public string User_type { get; set; } = "";
  29. [SugarColumn(IsOnlyIgnoreInsert = true)]
  30. [ExcelIgnore]
  31. public string Avatar { get; set; }
  32. public string Email { get; set; }
  33. [JsonIgnore]
  34. [ExcelIgnore]
  35. public string Password { get; set; }
  36. /// <summary>
  37. /// 手机号
  38. /// </summary>
  39. public string Phonenumber { get; set; }
  40. /// <summary>
  41. /// 用户性别(0男 1女 2未知)
  42. /// </summary>
  43. public string Sex { get; set; }
  44. /// <summary>
  45. /// 帐号状态(0正常 1停用)
  46. /// </summary>
  47. [ExcelIgnore]
  48. public string Status { get; set; }
  49. /// <summary>
  50. /// 删除标志(0代表存在 2代表删除)
  51. /// </summary>
  52. [SugarColumn(IsOnlyIgnoreInsert = true)]
  53. public string DelFlag { get; set; }
  54. /// <summary>
  55. /// 最后登录IP
  56. /// </summary>
  57. [SugarColumn(IsOnlyIgnoreInsert = true)]
  58. public string LoginIP { get; set; }
  59. /// <summary>
  60. /// 最后登录时间
  61. /// </summary>
  62. [SugarColumn(IsOnlyIgnoreInsert = true)]
  63. [ExcelColumn(Name = "登录日期", Format = "yyyy-MM-dd HH:mm:ss")]
  64. public DateTime? LoginDate { get; set; }
  65. /// <summary>
  66. /// 部门Id
  67. /// </summary>
  68. public long DeptId { get; set; }
  69. #region 表额外字段
  70. public bool IsAdmin()
  71. {
  72. return IsAdmin(UserId);
  73. }
  74. public static bool IsAdmin(long userId)
  75. {
  76. return 1 == userId;
  77. }
  78. /// <summary>
  79. /// 拥有角色个数
  80. /// </summary>
  81. //[SugarColumn(IsIgnore = true)]
  82. //public int RoleNum { get; set; }
  83. [SugarColumn(IsIgnore = true)]
  84. public string DeptName { get; set; }
  85. /// <summary>
  86. /// 角色id集合
  87. /// </summary>
  88. [SugarColumn(IsIgnore = true)]
  89. [ExcelIgnore]
  90. public long[] RoleIds { get; set; }
  91. /// <summary>
  92. /// 岗位集合
  93. /// </summary>
  94. [SugarColumn(IsIgnore = true)]
  95. [ExcelIgnore]
  96. public int[] PostIds { get; set; }
  97. [SugarColumn(IsIgnore = true)]
  98. [ExcelIgnore]
  99. public List<SysRole> Roles { get; set; }
  100. [SugarColumn(IsIgnore = true)]
  101. public string WelcomeMessage
  102. {
  103. get
  104. {
  105. int now = DateTime.Now.Hour;
  106. if (now > 0 && now <= 6)
  107. {
  108. return "午夜好";
  109. }
  110. else if (now > 6 && now <= 11)
  111. {
  112. return "早上好";
  113. }
  114. else if (now > 11 && now <= 14)
  115. {
  116. return "中午好";
  117. }
  118. else if (now > 14 && now <= 18)
  119. {
  120. return "下午好";
  121. }
  122. else
  123. {
  124. return "晚上好";
  125. }
  126. }
  127. }
  128. [SugarColumn(IsIgnore = true)]
  129. public string WelcomeContent { get; set; }
  130. #endregion
  131. }
  132. }