/*********************************************************************** * Project: baifenBinfa * ProjectName: 核心内容管理系统 * Web: http://chuanyin.com * Author: * Email: * CreateTime: 202403/02 * Description: 暂无 ***********************************************************************/ using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Linq.Expressions; using System.Threading.Tasks; using CoreCms.Net.Configuration; using CoreCms.Net.Filter; using CoreCms.Net.IServices; using CoreCms.Net.Loging; using CoreCms.Net.Model.Entities; using CoreCms.Net.Model.Entities.Expression; using CoreCms.Net.Model.FromBody; using CoreCms.Net.Model.ViewModels.DTO; using CoreCms.Net.Model.ViewModels.UI; using CoreCms.Net.Utility.Extensions; using CoreCms.Net.Web.Admin.Infrastructure; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; using SqlSugar; namespace CoreCms.Net.Web.Admin.Controllers { /// /// 角色表 /// [Description("角色表")] [Route("api/[controller]/[action]")] [ApiController] [RequiredErrorForAdmin] [Authorize(Permissions.Name)] public class SysRoleController : ControllerBase { private readonly ISysMenuServices _sysMenuServices; private readonly ISysRoleMenuServices _sysRoleMenuServices; private readonly ISysRoleServices _sysRoleServices; private readonly IWebHostEnvironment _webHostEnvironment; /// /// 构造函数 /// public SysRoleController(IWebHostEnvironment webHostEnvironment , ISysRoleServices sysRoleServices , ISysMenuServices sysMenuServices , ISysRoleMenuServices sysRoleMenuServices ) { _webHostEnvironment = webHostEnvironment; _sysRoleServices = sysRoleServices; _sysMenuServices = sysMenuServices; _sysRoleMenuServices = sysRoleMenuServices; } #region 获取列表============================================================ // POST: Api/SysRole/GetPageList /// /// 获取列表 /// /// [HttpPost] [Description("获取列表")] public async Task GetPageList() { var jm = new AdminUiCallBack(); var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1); var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30); var where = PredicateBuilder.True(); //获取排序字段 var orderField = Request.Form["orderField"].FirstOrDefault(); Expression> orderEx; switch (orderField) { case "id": orderEx = p => p.id; break; case "roleName": orderEx = p => p.roleName; break; case "roleCode": orderEx = p => p.roleCode; break; case "comments": orderEx = p => p.comments; break; case "deleted": orderEx = p => p.deleted; break; case "createTime": orderEx = p => p.createTime; break; case "updateTime": orderEx = p => p.updateTime; break; default: orderEx = p => p.id; break; } //设置排序方式 var orderDirection = Request.Form["orderDirection"].FirstOrDefault(); var orderBy = orderDirection switch { "asc" => OrderByType.Asc, "desc" => OrderByType.Desc, _ => OrderByType.Desc }; //查询筛选 //角色id int var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0); if (id > 0) @where = @where.And(p => p.id == id); //角色名称 nvarchar var roleName = Request.Form["roleName"].FirstOrDefault(); if (!string.IsNullOrEmpty(roleName)) @where = @where.And(p => p.roleName.Contains(roleName)); //角色标识 nvarchar var roleCode = Request.Form["roleCode"].FirstOrDefault(); if (!string.IsNullOrEmpty(roleCode)) @where = @where.And(p => p.roleCode.Contains(roleCode)); //备注 nvarchar var comments = Request.Form["comments"].FirstOrDefault(); if (!string.IsNullOrEmpty(comments)) @where = @where.And(p => p.comments.Contains(comments)); //是否删除,0否,1是 bit var deleted = Request.Form["deleted"].FirstOrDefault(); if (!string.IsNullOrEmpty(deleted) && deleted.ToLowerInvariant() == "true") @where = @where.And(p => p.deleted); else if (!string.IsNullOrEmpty(deleted) && deleted.ToLowerInvariant() == "false") @where = @where.And(p => p.deleted == false); //创建时间 datetime var createTime = Request.Form["createTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(createTime)) { if (createTime.Contains("到")) { var dts = createTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.createTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.createTime < dtEnd); } else { var dt = createTime.ObjectToDate(); where = where.And(p => p.createTime > dt); } } //修改时间 datetime var updateTime = Request.Form["updateTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(updateTime)) { if (updateTime.Contains("到")) { var dts = updateTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.updateTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.updateTime < dtEnd); } else { var dt = updateTime.ObjectToDate(); where = where.And(p => p.updateTime > dt); } } //获取数据 var list = await _sysRoleServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 首页数据============================================================ // POST: Api/SysRole/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建数据============================================================ // POST: Api/SysRole/GetCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public AdminUiCallBack GetCreate() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建提交============================================================ // POST: Api/SysRole/DoCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoCreate([FromBody] SysRole entity) { var jm = new AdminUiCallBack(); entity.createTime = DateTime.Now; var bl = await _sysRoleServices.InsertAsync(entity) > 0; jm.code = bl ? 0 : 1; jm.msg = bl ? GlobalConstVars.CreateSuccess : GlobalConstVars.CreateFailure; return jm; } #endregion #region 编辑数据============================================================ // POST: Api/SysRole/GetEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _sysRoleServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } jm.code = 0; jm.data = model; return jm; } #endregion #region 编辑提交============================================================ // POST: Api/SysRole/Edit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoEdit([FromBody] SysRole entity) { var jm = new AdminUiCallBack(); var oldModel = await _sysRoleServices.QueryByIdAsync(entity.id); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } //事物处理过程开始 oldModel.roleName = entity.roleName; oldModel.roleCode = entity.roleCode; oldModel.comments = entity.comments; oldModel.updateTime = DateTime.Now; //事物处理过程结束 var bl = await _sysRoleServices.UpdateAsync(oldModel); jm.code = bl ? 0 : 1; jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure; return jm; } #endregion #region 删除数据============================================================ // POST: Api/SysRole/DoDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDelete([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _sysRoleServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = GlobalConstVars.DataisNo; return jm; } var bl = await _sysRoleServices.DeleteByIdAsync(entity.id); jm.code = bl ? 0 : 1; jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure; return jm; } #endregion #region 批量删除============================================================ // POST: Api/SysRole/DoBatchDelete/10,11,20 /// /// 批量删除 /// /// /// [HttpPost] [Description("批量删除")] public async Task DoBatchDelete([FromBody] FMArrayIntIds entity) { var jm = new AdminUiCallBack(); var bl = await _sysRoleServices.DeleteByIdsAsync(entity.id); jm.code = bl ? 0 : 1; jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure; return jm; } #endregion #region 获取权限设置============================================================ // POST: Api/SysRole/GetRoleSet /// /// 获取权限设置 /// /// /// [HttpPost] [Description("获取权限设置")] public async Task GetRoleSet([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _sysRoleServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } jm.code = 0; jm.data = model; return jm; } #endregion #region 获取菜单===================================================================== // POST: Api/SysRole/GetSysMenu /// /// 获取菜单 /// /// /// [HttpPost] [Description("获取菜单")] public async Task GetSysMenu([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _sysMenuServices.QueryListByClauseAsync(p => p.deleted == false && p.hide == false, p => p.sortNumber, OrderByType.Asc); if (model == null) { jm.msg = "不存在此信息"; return jm; } var roleMenus = await _sysRoleMenuServices.QueryListByClauseAsync(p => p.roleId == entity.id); var list = new List(); if (model.Any()) model.ForEach(p => { list.Add(new SysMenuTreeDto { authority = p.authority, @checked = roleMenus.Exists(m => m.menuId == p.id), children = null, component = p.component, createTime = p.createTime, deleted = p.deleted, hide = p.hide, iconColor = p.iconColor, menuName = p.menuName, menuIcon = p.menuIcon, menuType = p.menuType, id = p.id, open = true, parentId = p.parentId, parentName = "", path = p.path, sortNumber = p.sortNumber, target = p.target, updateTime = p.updateTime }); }); jm.code = 0; jm.data = list; jm.otherData = new { entity, roleMenus }; return jm; } #endregion #region 设置权限===================================================================== // POST: Api/SysRole/DoSetSysMenu /// /// 设置权限 /// /// /// [HttpPost] [Description("设置权限")] public async Task DoSetSysMenu([FromBody] FMIntIdByListIntData entity) { var jm = new AdminUiCallBack(); var oldModel = await _sysRoleServices.QueryByIdAsync(entity.id); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } await _sysRoleMenuServices.DeleteAsync(p => p.roleId == oldModel.id); if (entity.data.Any()) { var list = new List(); entity.data.ForEach(p => { list.Add(new SysRoleMenu { createTime = DateTime.Now, menuId = p, roleId = oldModel.id }); }); await _sysRoleMenuServices.InsertAsync(list); } jm.code = 0; jm.msg = "权限设置成功"; return jm; } #endregion } }