public ActionResult Index(int?page)
{
DateTime dt = DateTime.Now;
DateTime endTime = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d")));
NameValueCollection q = new NameValueCollection();
q.Add("ClipScanTime1Start", endTime.AddDays(-1).ToString("yyyy/MM/dd 10:00"));
q.Add("ClipScanTime1End", DateTime.Now.AddHours(1).ToString("yyyy/MM/dd HH:00"));
InspectQueryModel query = new InspectQueryModel(q);
IPagedList <Inspect> inspects = null;
using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString))
{
int currentPageIndex = page.HasValue ? (page.Value <= 0 ? 0 : page.Value - 1) : 0;
IInspectRep inspectRep = new InspectRep(unitOfWork);
inspects = inspectRep.Queryable(query.ClipScanTime1Start, query.ClipScanTime1End).ToPagedList(currentPageIndex, int.Parse(Resources.PageSize));
}
ViewBag.Query = query;
return(View(inspects));
}
private IQueryable <Inspect> GenerateQuery(IUnitOfWork unitOfWork, InspectQueryModel query)
{
IInspectRep inspectRep = new InspectRep(unitOfWork);
return(inspectRep.Queryable().Where(item => (string.IsNullOrEmpty(query.TskNo) ? true : item.TskNo.Contains(query.TskNo)) &&
(string.IsNullOrEmpty(query.LeoniNo) ? true : item.LeoniNo.Contains(query.LeoniNo)) &&
(string.IsNullOrEmpty(query.CusNo) ? true : item.CusNo.Contains(query.CusNo)) &&
(string.IsNullOrEmpty(query.ClipScanNo) ? true : item.ClipScanNo.Contains(query.ClipScanNo)) &&
((query.ClipScanTime1Start.HasValue) ? item.ClipScanTime1 >= query.ClipScanTime1Start : true) &&
((query.ClipScanTime1End.HasValue) ? item.ClipScanTime1 <= query.ClipScanTime1End : true) &&
((query.ClipScanTime2Start.HasValue) ? item.ClipScanTime2 >= query.ClipScanTime2Start : true) &&
((query.ClipScanTime2End.HasValue) ? item.ClipScanTime2 <= query.ClipScanTime2End : true) &&
(string.IsNullOrEmpty(query.TskScanNo) ? true : item.TskScanNo.Contains(query.TskScanNo)) &&
((query.TskScanTime3Start.HasValue) ? item.TskScanTime3 >= query.TskScanTime3Start : true) &&
((query.TskScanTime3End.HasValue) ? item.TskScanTime3 <= query.TskScanTime3End : true) &&
((query.Time3MinTime2Start.HasValue) ? item.Time3MinTime2 >= query.Time3MinTime2Start : true) &&
((query.Time3MinTime2End.HasValue) ? item.Time3MinTime2 <= query.Time3MinTime2End : true) &&
(query.CreatedAtStart.HasValue ? item.CreatedAt >= query.CreatedAtStart : true) &&
(query.CreatedAtEnd.HasValue ? item.CreatedAt <= query.CreatedAtEnd : true) &&
(string.IsNullOrEmpty(query.OkOrNot) ? true : item.OkOrNot.Contains(query.OkOrNot))
));
}