SysUser.cs 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264
  1. namespace Admin.NET.Core;
  2. /// <summary>
  3. /// 系统用户表
  4. /// </summary>
  5. [SugarTable("sys_user", "系统用户表")]
  6. public class SysUser : EntityTenant
  7. {
  8. /// <summary>
  9. /// 账号
  10. /// </summary>
  11. [SugarColumn(ColumnDescription = "账号", Length = 32)]
  12. [Required, MaxLength(32)]
  13. public virtual string Account { get; set; }
  14. /// <summary>
  15. /// 密码(MD5加密)
  16. /// </summary>
  17. [SugarColumn(ColumnDescription = "密码", Length = 64)]
  18. [MaxLength(64)]
  19. [System.Text.Json.Serialization.JsonIgnore]
  20. [JsonIgnore]
  21. public virtual string Password { get; set; } = CommonConst.SysPassword;
  22. /// <summary>
  23. /// 真实姓名
  24. /// </summary>
  25. [SugarColumn(ColumnDescription = "真实姓名", Length = 32)]
  26. [MaxLength(32)]
  27. public virtual string RealName { get; set; }
  28. /// <summary>
  29. /// 昵称
  30. /// </summary>
  31. [SugarColumn(ColumnDescription = "昵称", Length = 32)]
  32. [MaxLength(32)]
  33. public string NickName { get; set; }
  34. /// <summary>
  35. /// 头像
  36. /// </summary>
  37. [SugarColumn(ColumnDescription = "头像", Length = 512)]
  38. [MaxLength(512)]
  39. public string Avatar { get; set; }
  40. /// <summary>
  41. /// 性别-男_1、女_2
  42. /// </summary>
  43. [SugarColumn(ColumnDescription = "性别")]
  44. public GenderEnum Sex { get; set; } = GenderEnum.Male;
  45. /// <summary>
  46. /// 年龄
  47. /// </summary>
  48. [SugarColumn(ColumnDescription = "年龄")]
  49. public int Age { get; set; }
  50. /// <summary>
  51. /// 出生日期
  52. /// </summary>
  53. [SugarColumn(ColumnDescription = "出生日期")]
  54. public DateTime? Birthday { get; set; }
  55. /// <summary>
  56. /// 民族
  57. /// </summary>
  58. [SugarColumn(ColumnDescription = "民族", Length = 32)]
  59. [MaxLength(32)]
  60. public string Nation { get; set; }
  61. /// <summary>
  62. /// 手机号码
  63. /// </summary>
  64. [SugarColumn(ColumnDescription = "手机号码", Length = 16)]
  65. [MaxLength(16)]
  66. public virtual string Phone { get; set; }
  67. /// <summary>
  68. /// 证件类型
  69. /// </summary>
  70. [SugarColumn(ColumnDescription = "证件类型")]
  71. public virtual CardTypeEnum CardType { get; set; }
  72. /// <summary>
  73. /// 身份证号
  74. /// </summary>
  75. [SugarColumn(ColumnDescription = "身份证号", Length = 32)]
  76. [MaxLength(32)]
  77. public virtual string IdCardNum { get; set; }
  78. /// <summary>
  79. /// 邮箱
  80. /// </summary>
  81. [SugarColumn(ColumnDescription = "邮箱", Length = 64)]
  82. [MaxLength(64)]
  83. public string Email { get; set; }
  84. /// <summary>
  85. /// 地址
  86. /// </summary>
  87. [SugarColumn(ColumnDescription = "地址", Length = 256)]
  88. [MaxLength(256)]
  89. public string Address { get; set; }
  90. /// <summary>
  91. /// 文化程度
  92. /// </summary>
  93. [SugarColumn(ColumnDescription = "文化程度")]
  94. public CultureLevelEnum CultureLevel { get; set; }
  95. /// <summary>
  96. /// 政治面貌
  97. /// </summary>
  98. [SugarColumn(ColumnDescription = "政治面貌", Length = 16)]
  99. [MaxLength(16)]
  100. public string PoliticalOutlook { get; set; }
  101. /// <summary>
  102. /// 毕业院校
  103. /// </summary>COLLEGE
  104. [SugarColumn(ColumnDescription = "毕业院校", Length = 128)]
  105. [MaxLength(128)]
  106. public string College { get; set; }
  107. /// <summary>
  108. /// 办公电话
  109. /// </summary>
  110. [SugarColumn(ColumnDescription = "办公电话", Length = 16)]
  111. [MaxLength(16)]
  112. public string OfficePhone { get; set; }
  113. /// <summary>
  114. /// 紧急联系人
  115. /// </summary>
  116. [SugarColumn(ColumnDescription = "紧急联系人", Length = 32)]
  117. [MaxLength(32)]
  118. public string EmergencyContact { get; set; }
  119. /// <summary>
  120. /// 紧急联系人电话
  121. /// </summary>
  122. [SugarColumn(ColumnDescription = "紧急联系人电话", Length = 16)]
  123. [MaxLength(16)]
  124. public string EmergencyPhone { get; set; }
  125. /// <summary>
  126. /// 紧急联系人地址
  127. /// </summary>
  128. [SugarColumn(ColumnDescription = "紧急联系人地址", Length = 256)]
  129. [MaxLength(256)]
  130. public string EmergencyAddress { get; set; }
  131. /// <summary>
  132. /// 个人简介
  133. /// </summary>
  134. [SugarColumn(ColumnDescription = "个人简介", Length = 512)]
  135. [MaxLength(512)]
  136. public string Introduction { get; set; }
  137. /// <summary>
  138. /// 排序
  139. /// </summary>
  140. [SugarColumn(ColumnDescription = "排序")]
  141. public int Order { get; set; } = 100;
  142. /// <summary>
  143. /// 状态
  144. /// </summary>
  145. [SugarColumn(ColumnDescription = "状态")]
  146. public StatusEnum Status { get; set; } = StatusEnum.Enable;
  147. /// <summary>
  148. /// 备注
  149. /// </summary>
  150. [SugarColumn(ColumnDescription = "备注", Length = 128)]
  151. [MaxLength(128)]
  152. public string Remark { get; set; }
  153. /// <summary>
  154. /// 账号类型
  155. /// </summary>
  156. [SugarColumn(ColumnDescription = "账号类型")]
  157. public AccountTypeEnum AccountType { get; set; } = AccountTypeEnum.None;
  158. /// <summary>
  159. /// 机构Id
  160. /// </summary>
  161. [SugarColumn(ColumnDescription = "机构Id")]
  162. public long OrgId { get; set; }
  163. /// <summary>
  164. /// 机构
  165. /// </summary>
  166. [SugarColumn(IsIgnore = true)]
  167. [Navigate(NavigateType.OneToOne, nameof(OrgId))]
  168. public SysOrg SysOrg { get; set; }
  169. /// <summary>
  170. /// 职位Id
  171. /// </summary>
  172. [SugarColumn(ColumnDescription = "职位Id")]
  173. public long PosId { get; set; }
  174. /// <summary>
  175. /// 职位
  176. /// </summary>
  177. [SugarColumn(IsIgnore = true)]
  178. [Navigate(NavigateType.OneToMany, nameof(PosId))]
  179. public SysPos SysPos { get; set; }
  180. /// <summary>
  181. /// 工号
  182. /// </summary>
  183. [SugarColumn(ColumnDescription = "工号", Length = 32)]
  184. [MaxLength(32)]
  185. public string JobNum { get; set; }
  186. /// <summary>
  187. /// 职级
  188. /// </summary>
  189. [SugarColumn(ColumnDescription = "职级", Length = 32)]
  190. [MaxLength(32)]
  191. public string PosLevel { get; set; }
  192. /// <summary>
  193. /// 入职日期
  194. /// </summary>
  195. [SugarColumn(ColumnDescription = "入职日期")]
  196. public DateTime? JoinDate { get; set; }
  197. /// <summary>
  198. /// 最新登录Ip
  199. /// </summary>
  200. [SugarColumn(ColumnDescription = "最新登录Ip", Length = 16)]
  201. [MaxLength(16)]
  202. public string LastLoginIp { get; set; }
  203. /// <summary>
  204. /// 最新登录地点
  205. /// </summary>
  206. [SugarColumn(ColumnDescription = "最新登录地点", Length = 128)]
  207. [MaxLength(128)]
  208. public string LastLoginAddress { get; set; }
  209. /// <summary>
  210. /// 最新登录时间
  211. /// </summary>
  212. [SugarColumn(ColumnDescription = "最新登录时间")]
  213. public DateTime? LastLoginTime { get; set; }
  214. /// <summary>
  215. /// 最新登录设备
  216. /// </summary>
  217. [SugarColumn(ColumnDescription = "最新登录设备", Length = 128)]
  218. [MaxLength(128)]
  219. public string LastLoginDevice { get; set; }
  220. /// <summary>
  221. /// 电子签名
  222. /// </summary>
  223. [SugarColumn(ColumnDescription = "电子签名", Length = 512)]
  224. [MaxLength(512)]
  225. public string Signature { get; set; }
  226. }