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