public ActionResult _AjaxList(GridCommand command, OpRefMapSearchModel searchModel)
{
TempData["GridCommand"] = command;
TempData["searchModel"] = searchModel;
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<OpRefMap>(searchStatementModel, command));
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, OpRefMapSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("ProdLine", searchModel.ProdLineSearch, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("SAPProdLine", searchModel.SAPProdLineSearch, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.ItemSearch, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("OpReference", searchModel.OpReferenceSearch, "o", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserNameSearch, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param);
if (searchModel.IsPrimarySearch.HasValue && searchModel.IsPrimarySearch.Value)
{
HqlStatementHelper.AddEqStatement("IsPrimary", searchModel.IsPrimarySearch.Value, "o", ref whereStatement, param);
}
if (searchModel.CreateStartDate != null & searchModel.CreateEndDate != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.CreateStartDate, searchModel.CreateEndDate, "o", ref whereStatement, param);
}
else if (searchModel.CreateStartDate != null & searchModel.CreateEndDate == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.CreateStartDate, "o", ref whereStatement, param);
}
else if (searchModel.CreateStartDate == null & searchModel.CreateEndDate != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.CreateEndDate, "o", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult List(GridCommand command, OpRefMapSearchModel searchModel)
{
TempData["OpRefMapSearchModel"] = searchModel;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public void ExportOpRefMapXls(OpRefMapSearchModel searchModel)
{
string hql = " select o from OpRefMap as o where 1=1 ";
IList<object> parameter = new List<object>();
if (!string.IsNullOrWhiteSpace(searchModel.ItemSearch))
{
hql += " and Item=? ";
parameter.Add(searchModel.ItemSearch);
}
if (!string.IsNullOrWhiteSpace(searchModel.SAPProdLineSearch))
{
hql += " and SAPProdLine=? ";
parameter.Add(searchModel.SAPProdLineSearch);
}
if (!string.IsNullOrWhiteSpace(searchModel.ProdLineSearch))
{
hql += " and ProdLine=? ";
parameter.Add(searchModel.ProdLineSearch);
}
if (!string.IsNullOrWhiteSpace(searchModel.OpReferenceSearch))
{
hql += " and OpReference=? ";
parameter.Add(searchModel.OpReferenceSearch);
}
if (!string.IsNullOrWhiteSpace(searchModel.CreateUserNameSearch))
{
hql += " and CreateUserName like ? ";
parameter.Add(searchModel.CreateUserNameSearch+"%");
}
if (searchModel.IsPrimarySearch.HasValue && searchModel.IsPrimarySearch.Value)
{
hql += " and IsPrimary=? ";
parameter.Add(searchModel.IsPrimarySearch.Value);
}
if (searchModel.CreateStartDate.HasValue)
{
hql += " and CreateDate>=? ";
parameter.Add(searchModel.CreateStartDate.Value);
}
if (searchModel.CreateEndDate.HasValue)
{
hql += " and CreateDate<=? ";
parameter.Add(searchModel.CreateEndDate.Value);
}
var exportList = this.genericMgr.FindAll<OpRefMap>(hql, parameter.ToArray());
ExportToXLS<OpRefMap>("OpRefMapXls", "XLS", exportList);
}
