public List <MeetingRoom_Reservation> SearchReservationMaxNum(ReservationMaxSearchViewModel reservationMaxSearchViewModel)
{
var predicate = SearchReservationMax(reservationMaxSearchViewModel);
var result = DbSet.Where(predicate).Include(a => a.MeetingRoom_Information).OrderByDescending(a => a.CreateDate).ToList();
return(result);
}
/// <summary>
/// 会议室预定信息大屏显示
/// </summary>
/// <param name="bookSearchViewModel"></param>
/// <returns></returns>
public List <MeetingRoom_Reservation> SearchReservationMaxWhere(ReservationMaxSearchViewModel reservationMaxSearchViewModel)
{
int SkipNum = reservationMaxSearchViewModel.pageViewModel.CurrentPageNum * reservationMaxSearchViewModel.pageViewModel.PageSize;
var predicate = SearchReservationMax(reservationMaxSearchViewModel);
var result = DbSet.Where(predicate).Include(a => a.MeetingRoom_Information).OrderByDescending(a => a.CreateDate)
.Skip(SkipNum)
.Take(reservationMaxSearchViewModel.pageViewModel.PageSize).ToList();
return(result);
}
public ActionResult <MeetingRoom_Reservation> Manage_ReservationMax(ReservationMaxSearchViewModel reservationMaxSearchViewModel)
{
RoomReservationSearchResModel roomreservationSearchResModel = new RoomReservationSearchResModel();
var Result = _RoomReservationService.ReservationMax_Search(reservationMaxSearchViewModel);
int count = _RoomReservationService.ReservationMax_SearchNum(reservationMaxSearchViewModel);
roomreservationSearchResModel.Room_info = Result;
roomreservationSearchResModel.TotalNum = count;
roomreservationSearchResModel.isSuccess = true;
roomreservationSearchResModel.baseViewModel.Message = "查询成功";
roomreservationSearchResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("根据会议室信息，查询成功");
return(Ok(roomreservationSearchResModel));
}
/// <summary>
/// 会议室预定信息大屏显示数量
/// </summary>
/// <param name="roomReservationSearchViewModel"></param>
/// <returns></returns>
public int ReservationMax_SearchNum(ReservationMaxSearchViewModel reservationMaxSearchViewModel)
{
List <MeetingRoom_Reservation> Reservation_Search = new List <MeetingRoom_Reservation>();
List <MeetingRoom_Reservation> meetingroom_reservation = _IRoomReservationRepository.SearchReservationMaxNum(reservationMaxSearchViewModel);
for (int i = 0; i < meetingroom_reservation.Count; i++)
{
if (!(meetingroom_reservation[i].Endingtime <reservationMaxSearchViewModel.Meetingtime ||
meetingroom_reservation[i].Meetingtime> reservationMaxSearchViewModel.Endingtime))
{
Reservation_Search.Add(meetingroom_reservation[i]);
}
}
var meetingroom_result = _IMapper.Map <List <MeetingRoom_Reservation>, List <RoomReservationSearchMiddle> >(Reservation_Search);
return(meetingroom_result.Count);
}
//根据条件查询会议室预定信息
private Expression <Func <MeetingRoom_Reservation, bool> > SearchReservationMax(ReservationMaxSearchViewModel reservationMaxSearchViewModel)
{
var predicate = WhereExtension.True <MeetingRoom_Reservation>();//初始化where表达式
predicate = predicate.And(a => a.IsDelete == "0");
if (reservationMaxSearchViewModel.RoomStatus == "")
{
predicate = predicate.And(a => a.RoomStatus == "1" || a.RoomStatus == "3");
}
else
{
predicate = predicate.And(a => a.RoomStatus.Contains(reservationMaxSearchViewModel.RoomStatus));
}
predicate = predicate.And(a => a.Floor.Contains(reservationMaxSearchViewModel.Floor));//
return(predicate);
}
