/// <summary> /// Search Statement /// </summary> /// <param name="command">Telerik GridCommand</param> /// <param name="searchModel">PriceListDetail Search Model</param> /// <param name="locationCode">PriceList Code</param> /// <returns>Search Statement</returns> private SearchStatementModel LocationAreaPrepareSearchStatement(GridCommand command, PriceListDetailSearchModel searchModel, string priceListDetail) { string whereLocationStatement = "where p.PriceList = '" + priceListDetail + "'"; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "p", ref whereLocationStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = priceListDetailSelectCountStatement; searchStatementModel.SelectStatement = priceListDetailSelectStatement; searchStatementModel.WhereStatement = whereLocationStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _PriceListDetailList(GridCommand command, PriceListDetailSearchModel searchModel, string priceListCode) { ViewBag.LocationCode = priceListCode; SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return PartialView(); }
public ActionResult _AjaxPriceListDetailList(GridCommand command, PriceListDetailSearchModel searchModel, string priceListCode) { SearchStatementModel searchStatementModel = this.LocationAreaPrepareSearchStatement(command, searchModel, priceListCode); GridModel<PriceListDetail> priceListDetailList = GetAjaxPageData<PriceListDetail>(searchStatementModel, command); foreach (var priceList in priceListDetailList.Data) { if (priceList.PriceList != null) { priceList.PriceListCode = priceList.PriceList.Code; } priceList.ItemDesc = this.itemMgr.GetCacheItem(priceList.Item).Description; } return PartialView(priceListDetailList); }
public ActionResult _AjaxPriceListDetailList(GridCommand command, PriceListDetailSearchModel searchModel, string priceListCode) { SearchStatementModel searchStatementModel = this.LocationAreaPrepareSearchStatement(command, searchModel, priceListCode); GridModel<TransportPriceListDetail> priceListDetailList = GetAjaxPageData<TransportPriceListDetail>(searchStatementModel, command); return PartialView(priceListDetailList); }