// GET: PVC public ActionResult Index(int?page) { int pageIndex = PagingHelper.GetPageIndex(page); PVCSearchModel q = new PVCSearchModel(); IPVCService us = new PVCService(Settings.Default.db, Session["user"] as User); IPagedList <PVC> pvcs = us.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; return(View(pvcs)); }
public ActionResult Search([Bind(Include = "name, shipDateFrom, shipDateTo, peNum, brand ,batchNo, startTimeFrom, startTimeTo, endTimeFrom, endTimeTo, createdAtFrom, createdAtTo")] PVCSearchModel q) { int pageIndex = 0; int.TryParse(Request.QueryString.Get("page"), out pageIndex); pageIndex = PagingHelper.GetPageIndex(pageIndex); IPVCService us = new PVCService(Settings.Default.db, Session["user"] as User); IPagedList <PVC> pvcs = us.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; return(View("Index", pvcs)); }
public IQueryable <PVC> Search(PVCSearchModel searchModel) { IQueryable <PVC> pvcs = BaseQuery(); if (!string.IsNullOrWhiteSpace(searchModel.name)) { pvcs = pvcs.Where(c => c.name.Contains(searchModel.name.Trim())); } if (searchModel.shipDateFrom.HasValue) { pvcs = pvcs.Where(c => c.shipDate >= searchModel.shipDateFrom); } if (searchModel.shipDateTo.HasValue) { pvcs = pvcs.Where(c => c.shipDate <= searchModel.shipDateTo); } if (!string.IsNullOrWhiteSpace(searchModel.peNum)) { //pvcs = pvcs.Where(c => c.peNum.Contains(searchModel.peNum)); try { string batchNo = searchModel.peNum.Split('.')[0]; string timeStr = searchModel.peNum.Split('.')[1]; if (!string.IsNullOrWhiteSpace(batchNo)) { pvcs = pvcs.Where(c => c.batchNo.Equals(batchNo)); } if (!string.IsNullOrWhiteSpace(timeStr)) { DateTime time = DateTime.ParseExact(timeStr, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture); //pvcs = pvcs.Where(c => c.startTime <= time).Where(c => c.endTime >= time); pvcs = pvcs.Where(c => c.startTime <= time && c.endTime >= time); } } catch (Exception) { if (!string.IsNullOrWhiteSpace(searchModel.peNum)) { pvcs = pvcs.Where(c => c.batchNo.Equals(searchModel.peNum)); } } } if (!string.IsNullOrWhiteSpace(searchModel.brand)) { pvcs = pvcs.Where(c => c.brand.Contains(searchModel.brand)); } //if (!string.IsNullOrWhiteSpace(searchModel.batchNo)) //{ // pvcs = pvcs.Where(c => c.batchNo.Contains(searchModel.batchNo)); //} //if (searchModel.startTimeFrom.HasValue) //{ // pvcs = pvcs.Where(c => c.startTime >= searchModel.startTimeFrom); //} //if (searchModel.startTimeTo.HasValue) //{ // pvcs = pvcs.Where(c => c.startTime <= searchModel.startTimeTo); //} //if (searchModel.endTimeFrom.HasValue) //{ // pvcs = pvcs.Where(c => c.endTime >= searchModel.endTimeFrom); //} //if (searchModel.endTimeTo.HasValue) //{ // pvcs = pvcs.Where(c => c.endTime <= searchModel.endTimeTo); //} if (searchModel.createdAtFrom.HasValue) { pvcs = pvcs.Where(c => c.createdAt >= searchModel.createdAtFrom); } if (searchModel.createdAtTo.HasValue) { pvcs = pvcs.Where(c => c.createdAt <= searchModel.createdAtTo); } return(pvcs); }
public IQueryable <PVC> Search(PVCSearchModel searchModel) { return(rep.Search(searchModel)); }