using AutoMapper;
|
using Model.ModelDto.SysDto;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Utility;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.ISysServer;
|
using WMS.IDAL.ISysInterface;
|
|
namespace WMS.BLL.SysServer
|
{
|
/// <summary>
|
/// 角色服务实践
|
/// </summary>
|
public class RolesServer : IRolesServer
|
{
|
/// <summary>
|
/// 依赖注入
|
/// </summary>
|
private readonly IMapper _mapper;
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
private readonly UserManager _userManager;
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
/// <param name="roles">角色</param>
|
/// <param name="mapper">automapper</param>
|
public RolesServer(IMapper mapper, UserManager userManager)
|
{
|
_mapper = mapper; //automapper
|
_userManager = userManager;
|
}
|
|
/// <summary>
|
/// 获取角色数据列表
|
/// </summary>
|
/// <param name="RoleNo">角色号</param>
|
/// <param name="RoleName">角色名称</param>
|
/// <returns></returns>
|
public async Task<List<RoleDto>> GetRoleList(string RoleNo, string RoleName)
|
{
|
var modUser = await Db.Queryable<SysUserInfor>().FirstAsync(s => s.Id == _userManager.UserId);
|
return await Db.Queryable<SysRoles>()
|
.LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
|
.LeftJoin<SysUserInfor>((a, b, c) => a.UpdateUser == c.Id)
|
//.WhereIF(modUser.UserName.ToUpper() != "ADMIN", a => a.CreateUser == _userManager.UserId)
|
.WhereIF(!string.IsNullOrEmpty(RoleNo), a => a.RoleNo.Contains(RoleNo))
|
.WhereIF(!string.IsNullOrEmpty(RoleName), a => a.RoleName.Contains(RoleName))
|
.Where(a => a.IsDel == "0")
|
.Select<RoleDto>((a, b, c) => new RoleDto()
|
{
|
CreateUserName = b.RealName,
|
UpdateUserName = c.RealName
|
}, true)
|
.ToListAsync();
|
}
|
|
/// <summary>
|
/// 根据编号获取角色信息列表
|
/// </summary>
|
/// <param name="RoleNo">角色编号</param>
|
/// <returns></returns>
|
public async Task<int> GetRoleByNo(string RoleNo)
|
{
|
return await Db.Queryable<SysRoles>().CountAsync(s => s.RoleNo == RoleNo && s.IsDel == "0");
|
}
|
|
/// <summary>
|
/// 新增角色数据信息
|
/// </summary>
|
/// <param name="roledto">角色dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> InsertRoleInfo(RoleDto roledto)
|
{
|
//模型映射
|
SysRoles roles = _mapper.Map<SysRoles>(roledto);
|
//判断角色号是否唯一
|
int count = await GetRoleByNo(roledto.RoleNo);
|
if (count > 0)
|
{
|
throw Oops.Bah("角色号必须唯一");
|
}
|
//新增角色信息
|
roles.CreateTime = DateTime.Now;
|
roles.CreateUser = _userManager.UserId;
|
var i = await Db.Insertable(roles).ExecuteCommandAsync();
|
if (i <= 0)
|
throw Oops.Bah("新增角色数据信息失败");
|
return i;
|
}
|
|
|
/// <summary>
|
/// 删除角色信息（逻辑删除）
|
/// </summary>
|
/// <param name="roles">角色实体模型</param>
|
/// <returns></returns>
|
public async Task<int> DeleteRoleInfo(SysRoles roles)
|
{
|
return await Db.Updateable<SysRoles>()
|
.Where(s => s.Id == roles.Id)
|
.SetColumns(s => s.IsDel == "1")
|
.SetColumns(s => s.UpdateTime == DateTime.Now)
|
.SetColumns(s => s.UpdateUser == _userManager.UserId)
|
.ExecuteCommandAsync();
|
|
}
|
|
/// <summary>
|
/// 编辑角色信息
|
/// </summary>
|
/// <param name="role">角色实体模型</param>
|
/// <returns></returns>
|
public async Task<int> UpdateRoleInfo(SysRoles role)
|
{
|
int count = await Db.Queryable<SysRoles>().CountAsync(s => s.RoleNo == role.RoleNo && s.Id != role.Id && s.IsDel == "0");
|
if (count > 0)
|
throw Oops.Bah("角色号必须唯一");
|
role.UpdateTime = DateTime.Now;
|
role.UpdateUser = _userManager.UserId;
|
int i = await Db.Updateable(role)
|
.UpdateColumns(s => new { s.RoleNo, s.RoleName, s.Demo, s.UpdateUser, s.UpdateTime })
|
.ExecuteCommandAsync();
|
if (i <= 0)
|
throw Oops.Bah("修改角色数据信息失败");
|
return i;
|
}
|
|
/// <summary>
|
/// 根据id获取角色信息
|
/// </summary>
|
/// <param name="roleids">角色id</param>
|
/// <returns></returns>
|
public async Task<SysRoles> GetRoleInfoById(int roleids)
|
{
|
return await Db.Queryable<SysRoles>().FirstAsync(s => s.Id == roleids && s.IsDel == "0");
|
}
|
|
}
|
}
|
