public ActionResult _AjaxPickRuleList(GridCommand command, PickRuleSearchModel searchModel, string PickGroupCode) { SearchStatementModel searchStatementModel = PrepareSearchPickRuleStatement(command, searchModel, PickGroupCode); return PartialView(GetAjaxPageData<PickRule>(searchStatementModel, command)); }
private SearchStatementModel PrepareSearchPickRuleStatement(GridCommand command, PickRuleSearchModel searchModel, string pickGroupCode) { string whereStatement = " where pr.PickGroupCode='" + pickGroupCode + "' "; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Location", searchModel.Location, HqlStatementHelper.LikeMatchMode.Start, "pr", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectPickRuleCountStatement; searchStatementModel.SelectStatement = selectPickRuleStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _PickRuleList(GridCommand command, PickRuleSearchModel searchModel, string PickGroupCode) { ViewBag.PickGroupCode = PickGroupCode; SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = this.ProcessPageSize(command.PageSize); return PartialView(); }