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