public ActionResult RccpPlanMasterList(GridCommand command, RccpPlanMasterSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); if (searchCacheModel.isBack == true) { ViewBag.Page = searchCacheModel.Command.Page==0 ? 1 : searchCacheModel.Command.Page; } ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult _AjaxRccpPlanMasterList(GridCommand command, RccpPlanMasterSearchModel searchModel) { string replaceFrom = "_AjaxRccpPlanMasterList"; string replaceTo = "_AjaxRccpPlanMasterList"; this.GetCommand(ref command, searchModel, replaceFrom, replaceTo); SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel); return PartialView(GetAjaxPageData<RccpPlanMaster>(searchStatementModel, command)); }
public ActionResult TreeViewList(RccpPlanMasterSearchModel searchModel) { var rccpTransGroups = new List<RccpTransGroup>(); TempData["RccpPlanMasterSearchModel"] = searchModel; ViewBag.SearchModel = searchModel; if (string.IsNullOrWhiteSpace(searchModel.Item) || !searchModel.PlanVersion.HasValue || string.IsNullOrWhiteSpace(searchModel.DateIndex)) { SaveErrorMessage(Resources.EXT.ControllerLan.Con_PlanTypeVersionTimeItemCodeTimeIndexCanNotBeEmpty); } else { string hql = "from Item where IsActive = 1 and Code = ? "; IList<Item> items = this.queryMgr.FindAll<Item>(hql, searchModel.Item, 0, 20); foreach (var item in items) { var rccpTransGroup = this.genericMgr.FindAll<RccpTransGroup> ("from RccpTransGroup where DateIndex = ? and DateType =? and Item =? and PlanVersion =? ", new object[] { searchModel.DateIndex, searchModel.DateType, searchModel.Item, searchModel.PlanVersion }).FirstOrDefault(); if (rccpTransGroup != null) { rccpTransGroup.ItemDescription = item.Description; rccpTransGroup.IsDown = searchModel.IsDown.HasValue ? searchModel.IsDown.Value : false; rccpTransGroups.Add(rccpTransGroup); } } } return View(rccpTransGroups); }
private SearchStatementModel PrepareSearchStatement(GridCommand command, RccpPlanMasterSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); if (searchModel.DateType != null) { whereStatement += " where r.DateType=? "; param.Add(searchModel.DateType); } HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "r", ref whereStatement, param); HqlStatementHelper.AddEqStatement("SnapTime", searchModel.SnapTime, "r", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by PlanVersion desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectRccpPlanMasterCountStatement; searchStatementModel.SelectStatement = selectRccpPlanMasterStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }