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