public ActionResult _AjaxList(GridCommand command, OpReportSearchModel searchModel) { string selectStatement = "select o from OperationReport as o where 1=1 "; IList<object> param = new List<object>(); if (!string.IsNullOrEmpty(searchModel.OrderNo)) { selectStatement += " and o.OrderNo=?"; param.Add(searchModel.OrderNo); } if (!string.IsNullOrEmpty(searchModel.ExtOrderNo)) { selectStatement += " and o.ExternalOrderNo=?"; param.Add(searchModel.ExtOrderNo); } if (!string.IsNullOrEmpty(searchModel.Operation)) { selectStatement += " and o.Operation=?"; param.Add(searchModel.Operation); } if (searchModel.StartDate != null & searchModel.EndDate != null) { selectStatement += " and o.CreateDate between ? and ?"; param.Add(searchModel.StartDate); param.Add(searchModel.EndDate); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { selectStatement += " and o.CreateDate >= ? "; param.Add(searchModel.StartDate); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { selectStatement += " and o.CreateDate <= ? "; param.Add(searchModel.EndDate); } IList<OperationReport> list = genericMgr.FindAll<OperationReport>(selectStatement, param.ToArray()); return PartialView(new GridModel(list)); //return PartialView(GetAjaxPageData<ReceiptMaster>(searchStatementModel, command)); }
public ActionResult List(GridCommand command, OpReportSearchModel searchModel) { TempData["OpReportSearchModel"] = searchModel; ViewBag.PageSize = 20; return View(); }