/// <summary> /// 根据公告查角色数量 /// </summary> /// <param name="roleByBulletinSearchViewModel"></param> /// <returns></returns> public IQueryable <Bulletin_Board_Relate_Role> GetRoleByBulletinAll(RoleByBulletinSearchViewModel roleByBulletinSearchViewModel) { int bulletinId = roleByBulletinSearchViewModel.Bulletin_BoardId; var queryResult = DbSet.Where(k => k.Bulletin_BoardId == bulletinId && k.User_Role.Status == "0").Include(p => p.User_Role); return(queryResult); }
/// <summary> /// 根据公告栏查询角色 /// </summary> /// <param name="roleByBulletinSearchViewModel"></param> /// <returns></returns> public List <Bulletin_Board_Relate_Role> SearchRoleInfoByWhere(RoleByBulletinSearchViewModel roleByBulletinSearchViewModel) { int SkipNum = roleByBulletinSearchViewModel.pageViewModel.CurrentPageNum * roleByBulletinSearchViewModel.pageViewModel.PageSize; int bulletinId = roleByBulletinSearchViewModel.Bulletin_BoardId; var queryResult = DbSet.Where(k => k.Bulletin_BoardId == bulletinId && k.User_Role.Status == "0").Include(p => p.User_Role).OrderBy(o => o.Id) .Skip(SkipNum) .Take(roleByBulletinSearchViewModel.pageViewModel.PageSize) .ToList(); return(queryResult); }
/// <summary> /// 根据公告查角色 /// </summary> /// <param name="roleByBulletinSearchViewModel"></param> /// <returns></returns> public List <UserRoleSearChMiddles> Role_By_Bulletin_Search(RoleByBulletinSearchViewModel roleByBulletinSearchViewModel) { List <Bulletin_Board_Relate_Role> bulletin_Relate_Info_Roles = _IBulletinBoardRelateRoleRepository.SearchRoleInfoByWhere(roleByBulletinSearchViewModel); List <UserRoleSearChMiddles> user_roles = new List <UserRoleSearChMiddles>(); foreach (var item in bulletin_Relate_Info_Roles) { var user_role_temp = _IMapper.Map <User_Role, UserRoleSearChMiddles>(item.User_Role); user_roles.Add(user_role_temp); } return(user_roles); }
/// <summary> /// 根据公告栏查角色总数 /// </summary> /// <param name="roleByBulletinSearchViewModel"></param> /// <returns></returns> public int Role_By_Bulletin_Get_ALLNum(RoleByBulletinSearchViewModel roleByBulletinSearchViewModel) { return(_IBulletinBoardRelateRoleRepository.GetRoleByBulletinAll(roleByBulletinSearchViewModel).Count()); }
public ActionResult <RoleByBulletinSearchResModel> Manage_Role_By_Bulletin_Search(RoleByBulletinSearchViewModel roleByBulletinSearchViewModel) { RoleByBulletinSearchResModel roleByBulletinSearchResModel = new RoleByBulletinSearchResModel(); roleByBulletinSearchResModel.userRoles = _bulletinBoardService.Role_By_Bulletin_Search(roleByBulletinSearchViewModel); roleByBulletinSearchResModel.IsSuccess = true; roleByBulletinSearchResModel.TotalNum = _bulletinBoardService.Role_By_Bulletin_Get_ALLNum(roleByBulletinSearchViewModel); roleByBulletinSearchResModel.baseViewModel.Message = "根据公告栏信息查询角色成功"; roleByBulletinSearchResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("根据公告栏信息查询角色成功"); return(Ok(roleByBulletinSearchResModel)); }