SysUserController.cs 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214
  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/skb/sysServer/user/page")]
  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("/v1/skb/sysServer/user/add")]
  81. public IActionResult AddUser([FromBody] SysUserDto parm)
  82. {
  83. var user = parm.Adapt<SysUser>().ToCreate(HttpContext);
  84. if (user == null) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  85. if (UserConstants.NOT_UNIQUE.Equals(UserService.CheckUserNameUnique(user.Username)))
  86. {
  87. return ToResponse(ApiResult.Error($"新增用户 '{user.Username}'失败,登录账号已存在"));
  88. }
  89. user.Password = Function.MD532(user.Password);
  90. return SUCCESS(UserService.InsertUser(user));
  91. }
  92. /// <summary>
  93. /// 修改用户
  94. /// </summary>
  95. /// <param name="parm"></param>
  96. /// <returns></returns>
  97. [HttpPut("/v1/skb/sysServer/user/update")]
  98. public IActionResult UpdateUser([FromBody] SysUserDto parm)
  99. {
  100. var user = parm.Adapt<SysUser>().ToUpdate(HttpContext);
  101. if (user == null || user.UserId <= 0) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  102. int upResult = UserService.UpdateUser(user);
  103. return ToResponse(upResult);
  104. }
  105. /// <summary>
  106. /// 改变用户状态
  107. /// </summary>
  108. /// <param name="user"></param>
  109. /// <returns></returns>
  110. [HttpPut("changeStatus")]
  111. [Log(Title = "修改用户状态", BusinessType = BusinessType.UPDATE)]
  112. [ActionPermissionFilter(Permission = "system:user:update")]
  113. public IActionResult ChangeStatus([FromBody] SysUser user)
  114. {
  115. if (user == null) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  116. int result = UserService.ChangeUserStatus(user);
  117. return ToResponse(result);
  118. }
  119. /// <summary>
  120. /// 删除用户
  121. /// </summary>
  122. /// <param name="userid"></param>
  123. /// <returns></returns>
  124. [HttpDelete("/v1/skb/sysServer/user/removeById/{id}")]
  125. public IActionResult Remove(int id = 0)
  126. {
  127. if (id <= 0) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
  128. if (id == 1) return ToResponse(ResultCode.FAIL, "不能删除管理员账号");
  129. int result = UserService.DeleteUser(id);
  130. return ToResponse(result);
  131. }
  132. /// <summary>
  133. /// 重置密码
  134. /// </summary>
  135. /// <returns></returns>
  136. [HttpPut("resetPwd")]
  137. [Log(Title = "重置密码", BusinessType = BusinessType.UPDATE)]
  138. [ActionPermissionFilter(Permission = "system:user:resetPwd")]
  139. public IActionResult ResetPwd([FromBody] SysUserDto sysUser)
  140. {
  141. //密码md5
  142. sysUser.Password = Function.MD532(sysUser.Password);
  143. int result = UserService.ResetPwd(sysUser.UserId, sysUser.Password);
  144. return ToResponse(result);
  145. }
  146. /// <summary>
  147. /// 导入
  148. /// </summary>
  149. /// <param name="formFile">使用IFromFile必须使用name属性否则获取不到文件</param>
  150. /// <returns></returns>
  151. [HttpPost("importData")]
  152. [Log(Title = "用户导入", BusinessType = BusinessType.IMPORT, IsSaveRequestData = false, IsSaveResponseData = true)]
  153. [ActionPermissionFilter(Permission = "system:user:import")]
  154. public IActionResult ImportData([FromForm(Name = "file")] IFormFile formFile)
  155. {
  156. List<SysUser> users = new();
  157. using (var stream = formFile.OpenReadStream())
  158. {
  159. users = stream.Query<SysUser>(startCell: "A2").ToList();
  160. }
  161. return SUCCESS(UserService.ImportUsers(users));
  162. }
  163. /// <summary>
  164. /// 用户导入模板下载
  165. /// </summary>
  166. /// <returns></returns>
  167. [HttpGet("importTemplate")]
  168. [Log(Title = "用户模板", BusinessType = BusinessType.EXPORT, IsSaveRequestData = true, IsSaveResponseData = false)]
  169. [AllowAnonymous]
  170. public IActionResult ImportTemplateExcel()
  171. {
  172. (string, string) result = DownloadImportTemplate("user");
  173. return ExportExcel(result.Item2, result.Item1);
  174. }
  175. /// <summary>
  176. /// 用户导出
  177. /// </summary>
  178. /// <param name="user"></param>
  179. /// <returns></returns>
  180. [HttpGet("export")]
  181. [Log(Title = "用户导出", BusinessType = BusinessType.EXPORT)]
  182. [ActionPermissionFilter(Permission = "system:user:export")]
  183. public IActionResult UserExport([FromQuery] SysUserQueryDto user)
  184. {
  185. var list = UserService.SelectUserList(user, new PagerInfo(1, 10000));
  186. var result = ExportExcelMini(list.Result, "user", "用户列表");
  187. return ExportExcel(result.Item2, result.Item1);
  188. }
  189. }
  190. }