using Infrastructure.Attribute;
using Infrastructure.Enums;
using Infrastructure.Model;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using MiniExcelLibs;
using SqlSugar;
using ZR.Admin.WebApi.Extensions;
using ZR.Admin.WebApi.Filters;
using ZR.Model;
using ZR.Model.System;
using ZR.Service.System.IService;
namespace ZR.Admin.WebApi.Controllers.System
{
///
/// 用户管理
///
[Verify]
[Route("system/user")]
public class SysUserController : BaseController
{
private readonly ISysUserService UserService;
private readonly ISysRoleService RoleService;
private readonly ISysPostService PostService;
private readonly ISysUserPostService UserPostService;
public SysUserController(
ISysUserService userService,
ISysRoleService roleService,
ISysPostService postService,
ISysUserPostService userPostService)
{
UserService = userService;
RoleService = roleService;
PostService = postService;
UserPostService = userPostService;
}
///
/// 用户管理 -> 获取用户
/// /system/user/list
///
///
[ActionPermissionFilter(Permission = "system:user:list")]
[HttpGet("list")]
public IActionResult List([FromQuery] SysUser user, PagerInfo pager)
{
var list = UserService.SelectUserList(user, pager);
return SUCCESS(list, TIME_FORMAT_FULL);
}
///
/// 用户管理 -> 编辑、添加用户获取用户,信息查询
///
///
///
[HttpGet("")]
[HttpGet("{userId:int=0}")]
public IActionResult GetInfo(int userId)
{
Dictionary dic = new();
var roles = RoleService.SelectRoleAll();
dic.Add("roles", roles);
//dic.Add("roles", SysUser.IsAdmin(userId) ? roles : roles.FindAll(f => !f.IsAdmin()));
dic.Add("posts", PostService.GetAll());
//编辑
if (userId > 0)
{
SysUser sysUser = UserService.SelectUserById(userId);
dic.Add("user", sysUser);
dic.Add("postIds", UserPostService.GetUserPostsByUserId(userId));
dic.Add("roleIds", sysUser.RoleIds);
}
return ToResponse(ApiResult.Success(dic));
}
///
/// 添加用户
///
///
///
[HttpPost("edit")]
[Log(Title = "用户管理", BusinessType = BusinessType.INSERT)]
[ActionPermissionFilter(Permission = "system:user:add")]
public IActionResult AddUser([FromBody] SysUser user)
{
if (user == null) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
if (UserConstants.NOT_UNIQUE.Equals(UserService.CheckUserNameUnique(user.UserName)))
{
return ToResponse(ApiResult.Error($"新增用户 '{user.UserName}'失败,登录账号已存在"));
}
user.Create_by = HttpContext.GetName();
user.Password = NETCore.Encrypt.EncryptProvider.Md5(user.Password);
return ToResponse(UserService.InsertUser(user));
}
///
/// 修改用户
///
///
///
[HttpPut("edit")]
[Log(Title = "用户管理", BusinessType = BusinessType.UPDATE)]
[ActionPermissionFilter(Permission = "system:user:edit")]
public IActionResult UpdateUser([FromBody] SysUser user)
{
if (user == null || user.UserId <= 0) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
user.Update_by = HttpContext.GetName();
int upResult = UserService.UpdateUser(user);
return ToResponse(upResult);
}
///
/// 改变用户状态
///
///
///
[HttpPut("changeStatus")]
[Log(Title = "修改用户状态", BusinessType = BusinessType.UPDATE)]
[ActionPermissionFilter(Permission = "system:user:update")]
public IActionResult ChangeStatus([FromBody] SysUser user)
{
if (user == null) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
int result = UserService.ChangeUserStatus(user);
return ToResponse(ToJson(result));
}
///
/// 删除用户
///
///
///
[HttpDelete("{userId}")]
[Log(Title = "用户管理", BusinessType = BusinessType.DELETE)]
[ActionPermissionFilter(Permission = "system:user:remove")]
public IActionResult Remove(int userid = 0)
{
if (userid <= 0) { return ToResponse(ApiResult.Error(101, "请求参数错误")); }
if (userid == 1) return ToResponse(Infrastructure.ResultCode.FAIL, "不能删除管理员账号");
int result = UserService.DeleteUser(userid);
return ToResponse(ToJson(result));
}
///
/// 重置密码
///
///
[HttpPut("resetPwd")]
[Log(Title = "重置密码", BusinessType = BusinessType.UPDATE)]
[ActionPermissionFilter(Permission = "system:user:update")]
public IActionResult ResetPwd([FromBody] SysUser sysUser)
{
//密码md5
sysUser.Password = NETCore.Encrypt.EncryptProvider.Md5(sysUser.Password);
int result = UserService.ResetPwd(sysUser.UserId, sysUser.Password);
return ToResponse(ToJson(result));
}
///
/// 导入
///
/// 使用IFromFile必须使用name属性否则获取不到文件
///
[HttpPost("importData")]
[Log(Title = "用户导入", BusinessType = BusinessType.IMPORT, IsSaveRequestData = false, IsSaveResponseData = false)]
[ActionPermissionFilter(Permission = "system:user:import")]
public IActionResult ImportData([FromForm(Name = "file")] IFormFile formFile)
{
//List users = (List)ExcelHelper.ImportData(formFile.OpenReadStream());
List users = new();
using (var stream = formFile.OpenReadStream())
{
users = stream.Query().ToList();
}
string msg = UserService.ImportUsers(users);
//TODO 业务逻辑,自行插入数据到db
return SUCCESS(users);
}
///
/// 用户导入模板下载
///
///
[HttpGet("importTemplate")]
[Log(Title = "用户模板", BusinessType = BusinessType.EXPORT, IsSaveRequestData = false, IsSaveResponseData = false)]
[AllowAnonymous]
public IActionResult ImportTemplateExcel()
{
List user = new();
MemoryStream stream = new();
var fileInfo = DownloadImportTemplate(user, stream, "用户列表");
//2023年4月25日 下载的文件有问题,弃用 赵
//return File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", $"{sFileName}");
return ExportExcel(fileInfo.Item1, fileInfo.Item2);
}
///
/// 用户导出
///
///
///
[HttpGet("export")]
[Log(Title = "用户导出", BusinessType = BusinessType.EXPORT)]
[ActionPermissionFilter(Permission = "system:user:export")]
public IActionResult UserExport([FromQuery] SysUser user)
{
var list = UserService.SelectUserList(user, new PagerInfo(1, 10000));
var result = ExportExcelMini(list.Result, "user", "用户列表");
return ExportExcel(result.Item2, result.Item1);
}
}
}