/// <summary> /// 根据ID来查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public CommodityServiceInfo GetCommodity(string id) { //Code Change Func<string, Tuple<CommodityDiscountInfoCNb, float>> _codeChangeFunc = new WeShopSeviceOverride().CommodityInfoQueryOnceOpeFunc; //创建 CommodityServiceInfo serInfo = new CommodityServiceInfo(); float fDiscountValue = 1.0f; //单纯商品数据 //dynamic item = shopCommodityDal.Query("id=@ID", new { ID = id }).ElementAt(0); Tuple<CommodityDiscountInfoCNb, float> tupResult = _codeChangeFunc(id); CommodityDiscountInfoCNb commItem = tupResult.Item1; fDiscountValue = tupResult.Item2; //Dynamic赋值 serInfo.SCommodityInfo = commItem; serInfo.DiscountValue = fDiscountValue; //商品规格数据List IEnumerable<dynamic> itemOption = new WX_ShopCommodityOptionDAL().Query("CommodityID = @ID ORDER BY iOrder", new { ID = id }); if (itemOption.Count() > 0) { //需要备注价格区间 string maxPrice = itemOption.Max(x => x.Price * fDiscountValue).ToString(); string minPrice = itemOption.Min(x => x.Price * fDiscountValue).ToString(); //价格区间,最大值最小值相同,则只展示一个价位 string strPriceInterval = maxPrice.Equals(minPrice) ? maxPrice : string.Format("{0} - {1}", minPrice, maxPrice); serInfo.SCommodityPriceInterVal = strPriceInterval; } else { serInfo.SCommodityPriceInterVal = serInfo.SCommodityInfo.DiscountPrice.ToString(); } serInfo.SCommdityOptionInfo = itemOption; //商品图片信息 IEnumerable<dynamic> PhotoDetail = photoDicDAL.Query("Source=@Source AND RelationID=@RelationID AND Flag IN (2,3) Order by iOrder", new { Source = "commodity", RelationID = id }); serInfo.SDicPhoto.Add(2, PhotoDetail.Where(x => x.Flag.Equals(2)).Select(x => x.Value.ToString()).ToArray()); serInfo.SDicPhoto.Add(3, PhotoDetail.Where(x => x.Flag.Equals(3)).Select(x => x.Value.ToString()).ToArray()); //商品运送方式 serInfo.SPostType = commItem.PostType.Equals(0) ? ZZSCResource.PostOption(commItem.PostType) : commItem.PostPrice.ToString(); return serInfo; }
public object AddCommodityOption() { object model = new { ID = Guid.NewGuid().ToString("N"), CommodityID = "0a05c53871b84921987cf763e55463a9", Name = "精装版", Price = "199", Flag = 1, Remark = string.Empty }; object modelNa = new { ID = Guid.NewGuid().ToString("N"), CommodityID = "0a05c53871b84921987cf763e55463a9", Name = "豪华版", Price = "299", Flag = 1, Remark = string.Empty }; var dal = new WX_ShopCommodityOptionDAL(); dal.Add(model); return dal.Add(modelNa); }