public ProductDetailHelper(int productSysNo) { string key = String.Format(DynomicCacheObjSettings.ProductBaiscInfoCacheSettings.CacheKey, productSysNo); int duration = DynomicCacheObjSettings.ProductBaiscInfoCacheSettings.CacheDuration; productDetail = CacheObj<ProductDetailModel>.GetCachedObj(key, duration, ProductDetailBasicService.GetProductDetailBasicInfo(productSysNo)); //productDetail = ProductDetailBasicService.GetProductDetailBasicInfo(productSysNo); }
/// <summary> /// 获得商品详细的基本信息 /// </summary> /// <param name="productSysNo"></param> /// <returns></returns> public static ProductDetailModel GetProductDetailBasicInfo(int productSysNo) { string sqlCmd = String.Format(getProductDetailInfoSqlCmdTemplate, productSysNo); try { DataTable data = new SqlDBHelper().ExecuteQuery(sqlCmd); int rowCount = data.Rows.Count; if (rowCount > 0) { ProductDetailModel productDetail = new ProductDetailModel() { ProductID = data.Rows[0]["ProductID"].ToString().Trim(), SysNo = data.Rows[0]["SysNo"].ToString().Trim(), ProductBriefName = data.Rows[0]["BriefName"].ToString().Trim(), ProductBaiscPrice = data.Rows[0]["BasicPrice"].ToString().Trim(), ProductCurrentPrice = data.Rows[0]["CurrentPrice"].ToString().Trim(), ProductDescriptionLong = data.Rows[0]["ProductDescLong"].ToString().Trim(), PackageList = data.Rows[0]["PackageList"].ToString().Trim(), LimitedQty = int.Parse(data.Rows[0]["LimitedQty"].ToString().Trim()), PromotionWord = data.Rows[0]["PromotionWord"].ToString().Trim(), Images = GetProductDetailImgs(productSysNo), ProductAttrSummery = data.Rows[0]["SummaryMain"].ToString().Trim(), Point = int.Parse(data.Rows[0]["Point"].ToString().Trim()), }; return(productDetail); } else { return(null); } } catch { return(null); } }
/// <summary> /// 获得商品详细的基本信息 /// </summary> /// <param name="productSysNo"></param> /// <returns></returns> public static ProductDetailModel GetProductDetailBasicInfo(int productSysNo) { string sqlCmd = String.Format(getProductDetailInfoSqlCmdTemplate, productSysNo); try { DataTable data = new SqlDBHelper().ExecuteQuery(sqlCmd); int rowCount = data.Rows.Count; if (rowCount > 0) { ProductDetailModel productDetail = new ProductDetailModel() { ProductID = data.Rows[0]["ProductID"].ToString().Trim(), SysNo = data.Rows[0]["SysNo"].ToString().Trim(), ProductBriefName = data.Rows[0]["BriefName"].ToString().Trim(), ProductBaiscPrice = data.Rows[0]["BasicPrice"].ToString().Trim(), ProductCurrentPrice = data.Rows[0]["CurrentPrice"].ToString().Trim(), ProductDescriptionLong = data.Rows[0]["ProductDescLong"].ToString().Trim(), PackageList = data.Rows[0]["PackageList"].ToString().Trim(), LimitedQty = int.Parse(data.Rows[0]["LimitedQty"].ToString().Trim()), PromotionWord = data.Rows[0]["PromotionWord"].ToString().Trim(), Images = GetProductDetailImgs(productSysNo), ProductAttrSummery = data.Rows[0]["SummaryMain"].ToString().Trim(), Point = int.Parse(data.Rows[0]["Point"].ToString().Trim()), }; return productDetail; } else { return null; } } catch { return null; } }