public List <MeetingRoom_Reservation> SearchRoomReservationNum(RoomReservationSearchViewModel roomReservationSearchViewModel) { var predicate = SearchReservationinfo(roomReservationSearchViewModel); 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> SearchRoomReservationWhere(RoomReservationSearchViewModel roomReservationSearchViewModel) { int SkipNum = roomReservationSearchViewModel.pageViewModel.CurrentPageNum * roomReservationSearchViewModel.pageViewModel.PageSize; var predicate = SearchReservationinfo(roomReservationSearchViewModel); var result = DbSet.Where(predicate).Include(a => a.MeetingRoom_Information).OrderByDescending(a => a.CreateDate) .Skip(SkipNum) .Take(roomReservationSearchViewModel.pageViewModel.PageSize).ToList(); return(result); }
public ActionResult <MeetingRoom_Reservation> Manage_RoomSearchAll(RoomReservationSearchViewModel roomReservationSearchViewModel) { RoomReservationSearchResModel roomreservationSearchResModel = new RoomReservationSearchResModel(); var Result = _RoomReservationService.RoomReservation_Search(roomReservationSearchViewModel); int count = _RoomReservationService.RoomReservation_SearchNum(roomReservationSearchViewModel); 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 RoomReservation_SearchNum(RoomReservationSearchViewModel roomReservationSearchViewModel) { List <MeetingRoom_Reservation> Reservation_Search = new List <MeetingRoom_Reservation>(); List <MeetingRoom_Reservation> meetingroom_reservation = _IRoomReservationRepository.SearchRoomReservationNum(roomReservationSearchViewModel); for (int i = 0; i < meetingroom_reservation.Count; i++) { if (!(meetingroom_reservation[i].Endingtime <roomReservationSearchViewModel.Meetingtime || meetingroom_reservation[i].Meetingtime> roomReservationSearchViewModel.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> > SearchReservationinfo(RoomReservationSearchViewModel roomReservationSearchViewModel) { var predicate = WhereExtension.True <MeetingRoom_Reservation>();//初始化where表达式 predicate = predicate.And(a => a.IsDelete == "0"); predicate = predicate.And(a => a.CreateUser.Contains(roomReservationSearchViewModel.CreateUser));// predicate = predicate.And(a => a.DepartName.Contains(roomReservationSearchViewModel.DepartName)); predicate = predicate.And(a => a.Phone.Contains(roomReservationSearchViewModel.Phone)); predicate = predicate.And(a => a.MeetingContent.Contains(roomReservationSearchViewModel.MeetingContent)); if (roomReservationSearchViewModel.RoomStatus == "") { predicate = predicate.And(a => a.RoomStatus == "1" || a.RoomStatus == "3"); } else { predicate = predicate.And(a => a.RoomStatus.Contains(roomReservationSearchViewModel.RoomStatus)); } predicate = predicate.And(a => a.Floor.Contains(roomReservationSearchViewModel.Floor)); // predicate = predicate.And(a => a.Area.Contains(roomReservationSearchViewModel.Area)); // predicate = predicate.And(a => a.ParticipantsNum.Contains(roomReservationSearchViewModel.ParticipantsNum.ToString())); // predicate = predicate.And(a => a.LeadershipWhether.Contains(roomReservationSearchViewModel.LeadershipWhether.ToString())); // predicate = predicate.And(a => a.Leadership.Contains(roomReservationSearchViewModel.Leadership.ToString())); // predicate = predicate.And(a => a.TeaWhether.Contains(roomReservationSearchViewModel.TeaWhether.ToString())); // predicate = predicate.And(a => a.MeetingRoom_InformationId.ToString().Contains(roomReservationSearchViewModel.MeetingRoom_InformationId)); return(predicate); }