/// <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(); } } } }