public Dictionary <string, decimal> GetModel(int productId)
{
string key = "hl_p_" + productId;
Dictionary <string, decimal> price = mc.Get(key) as Dictionary <string, decimal>;
if (price == null)
{
price = new Dictionary <string, decimal>();
bll.ChangeDataCenter();
string sql = string.Format("SELECT a.category,a.Price_N FROM dbo.Price a INNER JOIN dbo.Product_DEF b ON a.ID=b.Product_id AND a.iden=b.iden WHERE b.id='{0}'", productId);
var dt = bll.ExecuteTable(sql);
foreach (DataRow item in dt.Rows)
{
price.Add(item["category"].ToString(), (decimal)item["Price_N"]);
}
mc.Set("hl_p_" + productId, price, DateTime.Now.AddYears(1));
}
return(price);
}
