private SearchStatementModel PrepareSearchStatement(GridCommand command, FlowItemSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "d", ref whereStatement, param); string sortingStatement = string.Empty; if (command.SortDescriptors.Count == 0) { sortingStatement = " order by CreateDate desc"; } else { sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from FlowDetail as d"; searchStatementModel.SelectStatement = "select d from FlowDetail as d"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _SearchResult(GridCommand command, FlowItemSearchModel searchModel) { ViewBag.Item = searchModel.Item; ViewBag.Flow = searchModel.Flow; ViewBag.SearchType = searchModel.SearchType; ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return PartialView(); }
public ActionResult _AjaxList(GridCommand command, FlowItemSearchModel searchModel) { var itemlist = itemMgr.GetCacheAllItem(); if (searchModel.SearchType == "searchFlow") { GridModel<FlowDetail> flowList = new GridModel<FlowDetail>(); var flowMasterList = this.genericMgr.FindAll<FlowMaster> (" from FlowMaster where code like ? ", "%" + searchModel.Flow + "%"); var flowDetails = new List<FlowDetail>(); foreach (var flowMaster in flowMasterList) { flowDetails.AddRange(flowMgr.GetFlowDetailList(flowMaster.Code)); } foreach (var flowDetail in flowDetails) { var item = itemMgr.GetCacheItem(flowDetail.Item); flowDetail.WarnLeadTime = item.WarnLeadTime; flowDetail.Warranty = item.Warranty; flowDetail.ItemDescription = item.FullDescription; } FillFlowDetial(flowDetails); foreach (var flowDetail in flowDetails) { flowDetail.ItemDescription = itemlist.ValueOrDefault(flowDetail.Item).FullDescription; } flowList.Total = flowDetails.Count(); flowList.Data = flowDetails; return PartialView(flowList); } SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); GridModel<FlowDetail> List = GetAjaxPageData<FlowDetail>(searchStatementModel, command); FillFlowDetial(List.Data); foreach (var list in List.Data) { list.ItemDescription = itemlist.ValueOrDefault(list.Item).FullDescription; } return PartialView(List); }
public ActionResult _ScmModelResult(FlowItemSearchModel searchModel) { SearchStatementModel searchStatementModel = PrepareSearchStatement(new GridCommand(), searchModel); GridModel<FlowDetail> List = GetAjaxPageData<FlowDetail>(searchStatementModel, null); FillFlowDetial(List.Data); return View(List.Data); }