/// <summary>
/// 判断角色存在
/// </summary>
/// <param name="sysUserId">用户主键</param>
/// <param name="sysRoleId">角色主键</param>
/// <returns></returns>
public async Task <bool> ExistsSysUserRole(Guid sysUserId, Guid sysRoleId)
{
using (IDAL.System.ISysUserRoleDao sysUserRoleDao = new SysUserRoleDao())
{
return(await sysUserRoleDao.GetAllAsync().AnyAsync(m => m.SysUserId == sysUserId && m.SysRoleId == sysRoleId));
}
}
public async Task <int> GetDataCount()
{
using (var sysUserRoleDao = new SysUserRoleDao())
{
return(await sysUserRoleDao.GetAllAsync().CountAsync());
}
}
/// <summary>
/// 查询中间表信息
/// </summary>
/// <param name="sysUserRoleId"></param>
/// <returns></returns>
public async Task <DTO.System.SysUserRoleDto> GetOneSysUserRoleById(Guid sysUserRoleId)
{
using (IDAL.System.ISysUserRoleDao sysUserRoleDao = new SysUserRoleDao())
{
return(await sysUserRoleDao.GetAllAsync()
.Where(m => m.Id == sysUserRoleId)
.Select(m => new DTO.System.SysUserRoleDto()
{
Id = m.Id,
SysUserId = m.SysUserId,
SysRoleId = m.SysRoleId,
CreateTime = m.CreateTime,
}).FirstAsync());
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="sysUser"></param>
/// <returns></returns>
public async Task EditSysUser(SysUser sysUser, Guid[] sysRoleIds)
{
using (var sysUserDao = new SysUserDao())
{
var m = await sysUserDao.GetOneByIdAsync(sysUser.Id);
m.UserName = sysUser.UserName;
m.RealName = sysUser.RealName;
m.SysDepartId = sysUser.SysDepartId;
await sysUserDao.EditAsync(m);
//中间表处理
if (sysRoleIds != null)
{
using (var sysUserRoleDao = new SysUserRoleDao())
{
var sysUserRoleList = sysUserRoleDao.GetAllAsync().Where(a => a.SysUserId == sysUser.Id);
//先清空
foreach (var item in sysUserRoleList)
{
await sysUserRoleDao.RemoveAsync(item, false);
}
await sysUserRoleDao.Save();
//添加
foreach (var roleId in sysRoleIds)
{
await sysUserRoleDao.CreateAsync(new SysUserRole()
{
SysUserId = sysUser.Id,
SysRoleId = roleId
}, false);
}
await sysUserRoleDao.Save();
}
}
}
}