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));
}
