/// <summary>
/// 查询广告促销商品列表
/// </summary>
/// <param name="model">搜索实体对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-9</remarks>
public JsonResult List(SearchSalesProductModel model)
{
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
var list =
_salesProductService.Select(new SearchSalesProductModel
{
PagedIndex = model.PagedIndex,
PagedSize = model.PagedSize,
ProductName = model.ProductName,
LanguageID = ACultureHelper.GetLanguageID
});
var data = new { rows = list.Data, total = list.Data.TotalCount };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
///广告促销商品分页查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-8</remarks>
public ResultModel Select(SearchSalesProductModel model)
{
var salesProduct = _database.Db.SalesProduct;
var productlang = _database.Db.Product_Lang;
var product = _database.Db.Product;
var productRule = _database.Db.ProductRule;
var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
dynamic pl;
dynamic pd;
dynamic pr;
var query = salesProduct.Query().
LeftJoin(productlang, out pl).On(pl.ProductId == salesProduct.ProductId).
Where(pl.LanguageID == model.LanguageID).
LeftJoin(product, out pd).On(pd.ProductId == salesProduct.ProductId).
LeftJoin(productRule, out pr).On(pr.ProductId == salesProduct.ProductId).
Select(
pl.ProductName.Distinct(),
salesProduct.SalesProductId,
salesProduct.productId,
salesProduct.PlaceCode,
salesProduct.IdentityStatus,
(pd.HKPrice * pr.Discount).As("SalePrice"),
pd.HKPrice,
pd.Status,
pr.SalesRuleId,
pr.Discount,
pr.StarDate,
pr.EndDate,
salesProduct.Sorts,
salesProduct.PicAddress,
salesProduct.CreateBy,
salesProduct.CreateDT,
salesProduct.UpdateBy,
salesProduct.UpdateDT).
OrderBy(salesProduct.Sorts).
Where(pl.ProductName.Like("%" + model.ProductName + "%"));
var result = new ResultModel
{
Data =
new SimpleDataPagedList <SalesProductModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
