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