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