SysUserController.cs 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227
  1. using Attribute;
  2. using Common;
  3. using Dto;
  4. using Enums;
  5. using Filters;
  6. using Infrastructure;
  7. using Infrastructure.Model;
  8. using Mapster;
  9. using Microsoft.AspNetCore.Authorization;
  10. using Microsoft.AspNetCore.Mvc;
  11. using Middleware;
  12. using MiniExcelLibs;
  13. using Model;
  14. using Model.Base;
  15. using Services;
  16. using Util;
  17. namespace Controllers
  18. {
  19. /// <summary>
  20. /// 用户管理
  21. /// </summary>
  22. [Verify]
  23. public class SysUserController : BaseController
  24. {
  25. private readonly ISysUserService UserService;
  26. private readonly ISysRoleService RoleService;
  27. private readonly ISysPostService PostService;
  28. private readonly ISysUserPostService UserPostService;
  29. public SysUserController(
  30. ISysUserService userService,
  31. ISysRoleService roleService,
  32. ISysPostService postService,
  33. ISysUserPostService userPostService)
  34. {
  35. UserService = userService;
  36. RoleService = roleService;
  37. PostService = postService;
  38. UserPostService = userPostService;
  39. }
  40. /// <summary>
  41. /// 用户管理 -> 获取用户
  42. /// /system/user/list
  43. /// </summary>
  44. /// <returns></returns>
  45. [HttpGet("/v1/skb/sysServer/user/page")]
  46. public IActionResult List([FromQuery] SysUserQueryDto user, PagerInfo pager)
  47. {
  48. var list = UserService.SelectUserList(user, pager);
  49. return SUCCESS(list);
  50. }
  51. /// <summary>
  52. /// 用户管理 -> 编辑、添加用户获取用户,信息查询
  53. /// </summary>
  54. /// <param name="userId"></param>
  55. /// <returns></returns>
  56. [HttpGet("")]
  57. [HttpGet("{userId:int=0}")]
  58. [ActionPermissionFilter(Permission = "system:user:query")]
  59. public IActionResult GetInfo(int userId)
  60. {
  61. Dictionary<string, object> dic = new();
  62. var roles = RoleService.SelectRoleAll();
  63. dic.Add("roles", roles);
  64. //dic.Add("roles", SysUser.IsAdmin(userId) ? roles : roles.FindAll(f => !f.IsAdmin()));
  65. dic.Add("posts", PostService.GetAll());
  66. //编辑
  67. if (userId > 0)
  68. {
  69. SysUser sysUser = UserService.SelectUserById(userId);
  70. dic.Add("user", sysUser);
  71. dic.Add("postIds", UserPostService.GetUserPostsByUserId(userId));
  72. dic.Add("roleIds", sysUser.RoleIds);
  73. }
  74. return SUCCESS(dic);
  75. }
  76. /// <summary>
  77. /// 添加用户
  78. /// </summary>
  79. /// <param name="parm"></param>
  80. /// <returns></returns>
  81. [HttpPost("/v1/skb/sysServer/user/add")]
  82. public IActionResult AddUser([FromBody] SysUserDto parm)
  83. {
  84. var user = parm.Adapt<SysUser>().ToCreate(HttpContext);
  85. if (user == null) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  86. if (UserConstants.NOT_UNIQUE.Equals(UserService.CheckUserNameUnique(user.username)))
  87. {
  88. return ToResponse(ApiResult.Error($"新增用户 '{user.username}'失败,登录账号已存在"));
  89. }
  90. user.RoleIds = parm.role;
  91. user.PostIds = parm.post;
  92. user.password = Function.MD532(Function.CheckNull(user.password));
  93. TokenModel loginUser = JwtUtil.GetLoginUser(HttpContext);
  94. user.CreateBy = loginUser.Username;
  95. user.UpdateBy = loginUser.Username;
  96. user.LockFlag = "0";
  97. user.DelFlag = "0";
  98. return SUCCESS(UserService.InsertUser(user));
  99. }
  100. /// <summary>
  101. /// 修改用户
  102. /// </summary>
  103. /// <param name="parm"></param>
  104. /// <returns></returns>
  105. [HttpPut("/v1/skb/sysServer/user/update")]
  106. public IActionResult UpdateUser([FromBody] SysUserDto parm)
  107. {
  108. var user = parm.Adapt<SysUser>().ToUpdate(HttpContext);
  109. if (user == null || user.userId <= 0) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  110. user.RoleIds = parm.role;
  111. user.PostIds = parm.post;
  112. TokenModel loginUser = JwtUtil.GetLoginUser(HttpContext);
  113. user.UpdateBy = loginUser.Username;
  114. int upResult = UserService.UpdateUser(user);
  115. return SUCCESS(upResult);
  116. }
  117. /// <summary>
  118. /// 改变用户状态
  119. /// </summary>
  120. /// <param name="user"></param>
  121. /// <returns></returns>
  122. [HttpPut("changeStatus")]
  123. [Log(Title = "修改用户状态", BusinessType = BusinessType.UPDATE)]
  124. [ActionPermissionFilter(Permission = "system:user:update")]
  125. public IActionResult ChangeStatus([FromBody] SysUser user)
  126. {
  127. if (user == null) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  128. int result = UserService.ChangeUserStatus(user);
  129. return ToResponse(result);
  130. }
  131. /// <summary>
  132. /// 删除用户
  133. /// </summary>
  134. /// <param name="userid"></param>
  135. /// <returns></returns>
  136. [HttpDelete("/v1/skb/sysServer/user/removeById/{id}")]
  137. public IActionResult Remove(int id = 0)
  138. {
  139. if (id <= 0) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  140. if (id == 1) return ToResponse(ResultCode.FAIL, "不能删除管理员账号");
  141. int result = UserService.DeleteUser(id);
  142. return SUCCESS(result);
  143. }
  144. /// <summary>
  145. /// 重置密码
  146. /// </summary>
  147. /// <returns></returns>
  148. [HttpPut("resetPwd")]
  149. [Log(Title = "重置密码", BusinessType = BusinessType.UPDATE)]
  150. [ActionPermissionFilter(Permission = "system:user:resetPwd")]
  151. public IActionResult ResetPwd([FromBody] SysUserDto sysUser)
  152. {
  153. //密码md5
  154. sysUser.password = Function.MD532(sysUser.password);
  155. int result = UserService.ResetPwd(sysUser.userId, sysUser.password);
  156. return ToResponse(result);
  157. }
  158. /// <summary>
  159. /// 导入
  160. /// </summary>
  161. /// <param name="formFile">使用IFromFile必须使用name属性否则获取不到文件</param>
  162. /// <returns></returns>
  163. [HttpPost("importData")]
  164. [Log(Title = "用户导入", BusinessType = BusinessType.IMPORT, IsSaveRequestData = false, IsSaveResponseData = true)]
  165. [ActionPermissionFilter(Permission = "system:user:import")]
  166. public IActionResult ImportData([FromForm(Name = "file")] IFormFile formFile)
  167. {
  168. List<SysUser> users = new();
  169. using (var stream = formFile.OpenReadStream())
  170. {
  171. users = stream.Query<SysUser>(startCell: "A2").ToList();
  172. }
  173. return SUCCESS(UserService.ImportUsers(users));
  174. }
  175. /// <summary>
  176. /// 用户导入模板下载
  177. /// </summary>
  178. /// <returns></returns>
  179. [HttpGet("importTemplate")]
  180. [Log(Title = "用户模板", BusinessType = BusinessType.EXPORT, IsSaveRequestData = true, IsSaveResponseData = false)]
  181. [AllowAnonymous]
  182. public IActionResult ImportTemplateExcel()
  183. {
  184. (string, string) result = DownloadImportTemplate("user");
  185. return ExportExcel(result.Item2, result.Item1);
  186. }
  187. /// <summary>
  188. /// 用户导出
  189. /// </summary>
  190. /// <param name="user"></param>
  191. /// <returns></returns>
  192. [HttpGet("export")]
  193. [Log(Title = "用户导出", BusinessType = BusinessType.EXPORT)]
  194. [ActionPermissionFilter(Permission = "system:user:export")]
  195. public IActionResult UserExport([FromQuery] SysUserQueryDto user)
  196. {
  197. var list = UserService.SelectUserList(user, new PagerInfo(1, 10000));
  198. var result = ExportExcelMini(list.Records, "user", "用户列表");
  199. return ExportExcel(result.Item2, result.Item1);
  200. }
  201. }
  202. }