/// <summary> /// 根据用户查角色数量 /// </summary> /// <param name="roleByUserSearchViewModel"></param> /// <returns></returns> public IQueryable <User_Relate_Info_Role> GetRoleByUserAll(RoleByUserSearchViewModel roleByUserSearchViewModel) { int userid = roleByUserSearchViewModel.UserId; var queryResult = DbSet.Where(k => k.Station_InfoId == userid).Include(p => p.Station_Info); return(queryResult); }
/// <summary> /// 根据用户查角色 /// </summary> /// <param name="roleByUserSearchViewModel"></param> /// <returns></returns> public List <User_Relate_Info_Role> SearchRoleInfoByWhere(RoleByUserSearchViewModel roleByUserSearchViewModel) { int SkipNum = roleByUserSearchViewModel.pageViewModel.CurrentPageNum * roleByUserSearchViewModel.pageViewModel.PageSize; int userid = roleByUserSearchViewModel.UserId; var queryResult = DbSet.Where(k => k.User_InfoId == userid && k.User_Role.Status == "0").Include(p => p.User_Role).OrderBy(o => o.Id) .Skip(SkipNum) .Take(roleByUserSearchViewModel.pageViewModel.PageSize) .ToList(); return(queryResult); }
//根据用户查询角色 public List <UserRoleSearChMiddles> Role_By_User_Search(RoleByUserSearchViewModel roleByUserSearchViewModel) { List <User_Relate_Info_Role> user_Relate_Info_Roles = _userRelateInfoRoleRepository.SearchRoleInfoByWhere(roleByUserSearchViewModel); List <UserRoleSearChMiddles> user_roles = new List <UserRoleSearChMiddles>(); foreach (var item in user_Relate_Info_Roles) { var user_role_temp = _IMapper.Map <User_Role, UserRoleSearChMiddles>(item.User_Role); user_roles.Add(user_role_temp); } return(user_roles); }
public ActionResult <RoleByUserSearchResModel> Manage_Role_By_User_Search(RoleByUserSearchViewModel roleByUserSearchViewModel) { RoleByUserSearchResModel roleByUserSearchResModel = new RoleByUserSearchResModel(); roleByUserSearchResModel.userRoles = _roleService.Role_By_User_Search(roleByUserSearchViewModel); roleByUserSearchResModel.IsSuccess = true; roleByUserSearchResModel.TotalNum = _roleService.Role_By_User_Get_ALLNum(roleByUserSearchViewModel); roleByUserSearchResModel.baseViewModel.Message = "根据用户查询角色成功"; roleByUserSearchResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("根据用户查询角色成功"); return(Ok(roleByUserSearchResModel)); }
/// <summary> /// 根据用户查角色数量 /// </summary> /// <param name="roleByUserSearchViewModel"></param> /// <returns></returns> public int Role_By_User_Get_ALLNum(RoleByUserSearchViewModel roleByUserSearchViewModel) { return(_userRelateInfoRoleRepository.GetRoleByUserAll(roleByUserSearchViewModel).Count()); }