public ActionResult List(GridCommand command, ProdBomDetForecastChargSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return PartialView(); }
private string PrepareSearchStatement(GridCommand command, ProdBomDetForecastChargSearchModel searchModel) { string groupItemByCHARGNative = PermissionSearch + groupItemByCHARGNative_p1; if (searchModel.CHARG != null) { groupItemByCHARGNative += " WHERE CHARG = '" + searchModel.CHARG + "'"; } groupItemByCHARGNative += groupItemByCHARGNative_p2; return groupItemByCHARGNative; }
private List<ProdBomDetForecastChargView> GetChargData(ProdBomDetForecastChargSearchModel searchModel) { List<ProdBomDetForecastChargView> result = new List<ProdBomDetForecastChargView>(); if (Session["LES_ProdBomDetForecastCharg" + this.CurrentUser.Code] == null) { IList<object[]> groupedmatnr = this.genericMgr .FindAllWithNativeSql<object[]>( PermissionSearch + groupItemByCHARGNative_p1 + groupItemByCHARGNative_p2, this.CurrentUser.Code); foreach (object[] obj in groupedmatnr) { ProdBomDetForecastChargView pb = new ProdBomDetForecastChargView(); pb.MATNR = obj[0].ToString(); pb.MEINS = (obj[1] ?? string.Empty).ToString(); pb.BDMNG = decimal.Parse((obj[2] ?? 0).ToString()); pb.BDTER = DateTime.Parse(obj[3].ToString()); pb.WERKS = (obj[4] ?? string.Empty).ToString(); pb.DESC = (obj[5] ?? string.Empty).ToString(); pb.REFCODE = (obj[6] ?? string.Empty).ToString(); pb.CHARG = obj[7].ToString(); pb.SEQNR = obj[8].ToString(); result.Add(pb); } Session["LES_ProdBomDetForecastCharg"+this.CurrentUser.Code] = result; } else { result = (List<ProdBomDetForecastChargView>)Session["LES_ProdBomDetForecastCharg" + this.CurrentUser.Code]; } if (searchModel.CHARG != null) { return result.Where(pdf => pdf.CHARG == searchModel.CHARG).ToList(); } else { return result; } }
public ActionResult _AjaxListForCHARG(GridCommand command, ProdBomDetForecastChargSearchModel searchModel) { List<ProdBomDetForecastChargView> result = GetChargData(searchModel); GridModel<ProdBomDetForecastChargView> GridModel = new GridModel<ProdBomDetForecastChargView>(); GridModel.Total = result.Count; GridModel.Data = result .OrderBy(pf => pf.SEQNR) .ThenBy(pf => pf.CHARG) .Skip((command.Page - 1) * command.PageSize) .Take(command.PageSize).ToList(); ViewBag.Total = GridModel.Total; return PartialView(GridModel); }