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