SysUserController.cs 7.7 KB

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