//根据条件查询公告栏
private Expression <Func <Bulletin_Board, bool> > SearchBulletinBoardWhere(BulletinBoardSearchViewModel bulletinBoardSearchViewModel)
{
var predicate = WhereExtension.True <Bulletin_Board>();//初始化where表达式
predicate = predicate.And(p => p.BulletinTitle.Contains(bulletinBoardSearchViewModel.BulletinTitle));
predicate = predicate.And(p => p.StayNum.Contains(bulletinBoardSearchViewModel.StayNum));
predicate = predicate.And(p => p.UserName.Contains(bulletinBoardSearchViewModel.UserName));
predicate = predicate.And(p => p.status.Contains(bulletinBoardSearchViewModel.status));
return(predicate);
}
/// <summary>
/// 查询公告栏信息
/// </summary>
/// <param name="bulletinBoardSearchViewModel"></param>
/// <returns></returns>
public List <BulletinBoardSearchMiddlecs> Bulletin_Board_Search(BulletinBoardSearchViewModel bulletinBoardSearchViewModel)
{
List <Bulletin_Board> bulletin_Board = _IBulletinBoardRepository.SearchInfoByBulletinWhere(bulletinBoardSearchViewModel);
List <BulletinBoardSearchMiddlecs> boardSearchMiddlecs = new List <BulletinBoardSearchMiddlecs>();
foreach (var item in bulletin_Board)
{
var BusSearchMiddlecs = _IMapper.Map <Bulletin_Board, BulletinBoardSearchMiddlecs>(item);
boardSearchMiddlecs.Add(BusSearchMiddlecs);
}
return(boardSearchMiddlecs);
}
/// <summary>
/// 查询公告栏信息
/// </summary>
/// <param name="bulletinBoardSearchViewModel"></param>
/// <returns></returns>
public List <Bulletin_Board> SearchInfoByBulletinWhere(BulletinBoardSearchViewModel bulletinBoardSearchViewModel)
{
//查询条件
int SkipNum = bulletinBoardSearchViewModel.pageViewModel.CurrentPageNum * bulletinBoardSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchBulletinBoardWhere(bulletinBoardSearchViewModel);
var result = DbSet.Where(predicate)
.Skip(SkipNum)
.Take(bulletinBoardSearchViewModel.pageViewModel.PageSize)
.OrderBy(o => o.AddDate).ToList();
return(result);
}
/// <summary>
/// 查询公告栏信息数量
/// </summary>
/// <param name="bulletinBoardSearchViewModel"></param>
/// <returns></returns>
public int BulletinBoard_Get_ALLNum(BulletinBoardSearchViewModel bulletinBoardSearchViewModel)
{
return(_IBulletinBoardRepository.GetBulletinBoardAll(bulletinBoardSearchViewModel).Count());
}
public ActionResult <BulletinBoardSearchResModel> Manage_BulletinBoard_Search(BulletinBoardSearchViewModel bulletinBoardSearchViewModel)
{
BulletinBoardSearchResModel bulletinBoardSearchResModel = new BulletinBoardSearchResModel();
var BusSearchResult = _bulletinBoardService.Bulletin_Board_Search(bulletinBoardSearchViewModel);
// var TotalNum = _userService.User_Get_ALLNum();
var TotalNum = _bulletinBoardService.BulletinBoard_Get_ALLNum(bulletinBoardSearchViewModel);
bulletinBoardSearchResModel.bulletinBoard_Infos = BusSearchResult;
bulletinBoardSearchResModel.isSuccess = true;
bulletinBoardSearchResModel.baseViewModel.Message = "查询成功";
bulletinBoardSearchResModel.baseViewModel.ResponseCode = 200;
bulletinBoardSearchResModel.TotalNum = TotalNum;
_ILogger.Information("查询公告栏信息成功");
return(Ok(bulletinBoardSearchResModel));
}
/// <summary>
/// 公告栏数量
/// </summary>
/// <param name="bulletinBoardSearchViewModel"></param>
/// <returns></returns>
public IQueryable <Bulletin_Board> GetBulletinBoardAll(BulletinBoardSearchViewModel bulletinBoardSearchViewModel)
{
var predicate = SearchBulletinBoardWhere(bulletinBoardSearchViewModel);
return(DbSet.Where(predicate));
}
