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