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