private SearchStatementModel PrepareBindedSearchStatement(GridCommand command, FlowBindModel searchModel, string id) { string whereStatement = " where bf.Code='" + id + "'"; IList<object> param = new List<object>(); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountBindStatement; searchStatementModel.SelectStatement = selectBindStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareBindSearchStatement(GridCommand command, FlowBindModel searchModel, string id) { string whereStatement = " where mf.Code='" + id + "'"; IList<object> param = new List<object>(); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "BindedFlow.Code") { command.SortDescriptors[0].Member = "bf.Code"; } else if (command.SortDescriptors[0].Member == "BindedFlow.Description") { command.SortDescriptors[0].Member = "bf.Description"; } else if (command.SortDescriptors[0].Member == "BindTypeDescription") { command.SortDescriptors[0].Member = "f.BindType"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountBindStatement; searchStatementModel.SelectStatement = selectBindStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _Binded(GridCommand command, FlowBindModel searchModel, string id) { if (string.IsNullOrWhiteSpace(id)) { return HttpNotFound(); } ViewBag.flow = id; searchModel.BindedFlow = id; TempData["FlowBindModel"] = searchModel; ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return PartialView(); }
public ActionResult _AjaxBinded(GridCommand command, FlowBindModel searchModel, string id) { SearchStatementModel searchStatementModel = PrepareBindedSearchStatement(command, searchModel, id); return PartialView(GetAjaxPageData<FlowBinding>(searchStatementModel, command)); }
public ActionResult _Binded(GridCommand command, FlowBindModel searchModel, string id) { if (string.IsNullOrWhiteSpace(id)) { return HttpNotFound(); } ViewBag.flow = id; ViewBag.PageSize = base.ProcessPageSize(command.PageSize); SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel); SearchStatementModel searchStatementModel = PrepareBindedSearchStatement(command, (FlowBindModel)searchCacheModel.SearchObject, id); return PartialView(GetPageData<FlowBinding>(searchStatementModel, command)); }