public SelectionWorker(Route route)
{
var db2 = new Domains2.Entities.EiSDbContext();
this.GreenPathCategories = new System.Web.Mvc.SelectList(db2.GreenPathCategories.OrderBy(c => c.Priority), "GreenPathCategoryId", "GreenPathCategoryName", route.GreenPathCategoryId);
this.InRoomWays = new System.Web.Mvc.SelectList(db2.InRoomWays.Where(c => (c.InRoomWayCode & Domains2.Entities.InRoomWayCode.IntensiveCareRoom) == Domains2.Entities.InRoomWayCode.IntensiveCareRoom).OrderBy(c => c.Priority), "InRoomWayId", "InRoomWayName", route.InRoomWayId);
this.Destinations = new System.Web.Mvc.SelectList(db2.Destinations.Where(c => (c.DestinationCode & Domains2.Entities.DestinationCode.UseForIntensiveCareRoom) == Domains2.Entities.DestinationCode.UseForIntensiveCareRoom).OrderBy(c => c.Priority2), "DestinationId", "DestinationName", route.DestinationId);
this.IsRescues = new System.Web.Mvc.SelectList(
new List <System.Web.Mvc.SelectListItem>
{
new System.Web.Mvc.SelectListItem {
Text = "是", Value = "True"
},
new System.Web.Mvc.SelectListItem {
Text = "否", Value = "False"
}
}, "Value", "Text");
this.IsLeaves = new System.Web.Mvc.SelectList(
new List <System.Web.Mvc.SelectListItem>
{
new System.Web.Mvc.SelectListItem {
Text = "是", Value = "true"
},
new System.Web.Mvc.SelectListItem {
Text = "否", Value = "false"
}
}, "Value", "Text");
}
public Index(Route route)
{
var db2 = new Domains2.Entities.EiSDbContext();
var query = db2.GeneralRoomInfos.Where(c => (c.Room.RoomCode & Domains2.Entities.RoomCode.IntensiveCareRoom) == Domains2.Entities.RoomCode.IntensiveCareRoom);
if (route.InDepartmentTimeStart != null)
{
query = query.Where(c => route.InDepartmentTimeStart.Value <= c.InDepartmentTime);
}
if (route.InDepartmentTimeEnd != null)
{
query = query.Where(c => c.InDepartmentTime < route.InDepartmentTimeEnd);
}
if (route.OutDepartmentTimeStart != null)
{
query = query.Where(c => route.OutDepartmentTimeStart.Value <= c.OutDepartmentTime);
}
if (route.OutDepartmentTimeEnd != null)
{
query = query.Where(c => c.OutDepartmentTime < route.OutDepartmentTimeEnd);
}
if (route.GreenPathCategoryId != null)
{
query = query.Where(c => c.GreenPathCategoryId == route.GreenPathCategoryId);
}
if (route.IsRescue != null)
{
query = query.Where(c => c.IsRescue == route.IsRescue);
}
if (route.IsLeave != null)
{
query = query.Where(c => c.OutDepartmentTime.HasValue == route.IsLeave);
}
if (!string.IsNullOrWhiteSpace(route.PatientName))
{
route.PatientName = route.PatientName.Trim();
query = query.Where(c => c.PatientName == route.PatientName);
}
if (!string.IsNullOrWhiteSpace(route.OutPatientNumber))
{
route.OutPatientNumber = route.OutPatientNumber.Trim();
query = query.Where(c => c.OutPatientNumber == route.OutPatientNumber);
}
if (route.InRoomWayId != null)
{
query = query.Where(c => c.InRoomWayId == route.InRoomWayId);
}
if (route.DestinationId != null)
{
query = query.Where(c => c.DestinationId == route.DestinationId);
}
route.Count = query.Count();
var queryOrdered = query.OrderByDescending(c => c.InDepartmentTime).ThenBy(c => c.GeneralRoomInfoId);
var queryCurrentPage = queryOrdered.Skip((route.Page - 1) * route.PerPage).Take(route.PerPage);
this.Route = route;
this.List = queryCurrentPage.ToList().Select(c => new Item(c)).ToList();
}
