public ProductInfoNew SelectSpfSkuPrice(ProductInfoNew Product, string ProductNo)//商品价格的信息
{
//取最小价格
List <ProductInfoNew> Mininfo = DapperUtil.Query <ProductInfoNew>("ComBeziWfs_SwfsFlagShipNewArrivalProductList_SpfSkuPriceAll", new { ProductNo = ProductNo }).ToList();
if (Mininfo != null && Mininfo.Count() != 0)
{
Product.MinSellPrice = Mininfo.Min(p => p.SellPrice); //最小黄金价
Product.MinPlatinumPrice = Mininfo.Min(p => p.PlatinumPrice); //最小白金价
Product.MinDiamondPrice = Mininfo.Min(p => p.DiamondPrice); //最小钻石价
Product.MinLimitedPrice = Mininfo.Min(p => p.LimitedPrice); //最小尚品价格
Product.MinMarketPrice = Mininfo.Min(p => p.MarketPrice); //最小钻石价
Product.MinPromotionPrice = Mininfo.Min(p => p.PromotionPrice); //最小尚品价格
Product.MaxSellPrice = Mininfo.Max(p => p.SellPrice); //最大黄金价
Product.MaxPlatinumPrice = Mininfo.Max(p => p.PlatinumPrice); //最大白金价
Product.MaxDiamondPrice = Mininfo.Max(p => p.DiamondPrice); //最大钻石价
Product.MaxLimitedPrice = Mininfo.Max(p => p.LimitedPrice); //最大尚品价格
Product.MaxMarketPrice = Mininfo.Max(p => p.MarketPrice); //最大钻石价
Product.MaxPromotionPrice = Mininfo.Max(p => p.PromotionPrice); //最大尚品价格
}
return(Product);
}
/// <summary>
/// 添加商品展示图页面
/// </summary>
/// <param name="brandNo">商品编号</param>
/// <param name="DateShelf">上新时间</param>
/// <returns></returns>
public ActionResult AddProductImage(string ProductListId, string ArrivalId)
{
SwfsFlagShipNewArrivalProductService service = new SwfsFlagShipNewArrivalProductService();
SwfsFlagShipNewArrivalProductList Product = service.SelectProductListId(ProductListId);
ProductInfoNew model = service.SelectProductInfoNewProductListId(ProductListId);
ViewBag.ProductFirstPicNo = Product == null ? "" : Product.ProductFirstPicNo;
ViewBag.ProductSecondPicNo = Product == null ? "" : Product.ProductSecondPicNo;
ViewBag.ArrivalId = ArrivalId;
return(View(model));
}
