public ActionResult JuMeiMallSearchIndex(JuMeiMallSearchRequest query) { var request = _container.Resolve <OperationJuMeiMall>(); var model = new JuMeiMallListModel(); query.PageSize = 500; var category = request.CommodityCategorysService.GetById(query.commodityCategoryId); if (category != null) { model.categoryName = category.name; } var recordSet = request.JuMeiMallService.QueryList(query); if (recordSet != null && recordSet.TotalCount > 0) { model.JuMeiMallExList = recordSet.ModelList.ToList().Select(x => new JuMeiMallModelExpress() { commodityId = x.commodityId, commodityName = x.commodityName, images = request.GetFirstImage(x.images), commodityPrice = x.commodityPrice, commodityRank = x.commodityRank, sellQuantity = x.sellQuantity, submitTime = x.submitTime.ToString(), commodityRemark = x.commodityRemark == null ? " " : x.commodityRemark, commodityJifen = x.commodityJifen, }).ToList(); model.totalCount = recordSet.TotalCount; model.pageIndex = query.PageIndex; } return(View(model)); // return Json(model); }
public DataTables <Commodity> QueryList(JuMeiMallSearchRequest request) { SqlParameter[] param = { new SqlParameter("@commodityName", request.commodityName), new SqlParameter("@commodityCategoryId", request.commodityCategoryId), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), new SqlParameter("@commodityState", CommodityStates.putaway), }; StoreProcedure sp = new StoreProcedure("P_getAllMallGoods", param); return(_databaseInstance.GetTables <Commodity>(sp)); }