/// <summary> /// 获得购物车列表 /// </summary> public static IList <Model.cart_items> GetList(int group_id) { IDictionary <string, int> dic = GetCart(); if (dic != null) { IList <Model.cart_items> iList = new List <Model.cart_items>(); foreach (var item in dic) { BLL.article bll = new BLL.article(); Model.article_goods model = bll.GetGoodsModel(Convert.ToInt32(item.Key)); if (model == null) { continue; } Model.cart_items modelt = new Model.cart_items(); modelt.id = model.id; modelt.title = model.title; modelt.img_url = model.img_url; modelt.point = model.point; modelt.price = model.sell_price; modelt.user_price = model.sell_price; modelt.stock_quantity = model.stock_quantity; //会员价格 if (model.goods_group_prices != null) { Model.goods_group_price gmodel = model.goods_group_prices.Find(p => p.group_id == group_id); if (gmodel != null) { modelt.user_price = gmodel.price; } } modelt.quantity = item.Value; iList.Add(modelt); } return(iList); } return(null); }
/// <summary> /// 获得商品价格数据列表 /// </summary> private List <Model.goods_group_price> GetGoodsGroupPriceList(int article_id) { List <Model.goods_group_price> modelList = new List <Model.goods_group_price>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,group_id,price from dt_goods_group_price "); strSql.Append(" where article_id=" + article_id); DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.goods_group_price model; for (int n = 0; n < rowsCount; n++) { model = new Model.goods_group_price(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "") { model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString()); } if (dt.Rows[n]["group_id"] != null && dt.Rows[n]["group_id"].ToString() != "") { model.group_id = int.Parse(dt.Rows[n]["group_id"].ToString()); } if (dt.Rows[n]["price"] != null && dt.Rows[n]["price"].ToString() != "") { model.price = decimal.Parse(dt.Rows[n]["price"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 返回对应商品的会员价格 /// </summary> /// <param name="goods_id">商品ID</param> /// <returns>Decimal</returns> protected decimal get_user_goods_price(int goods_id) { Model.users userModel = GetUserInfo(); if (userModel == null) { return(-1); } Model.article_goods model = new BLL.article().GetGoodsModel(goods_id); if (model != null) { if (model.goods_group_prices != null) { Model.goods_group_price priceModel = model.goods_group_prices.Find(p => p.group_id == userModel.group_id); if (priceModel != null) { return(priceModel.price); } } return(model.sell_price); } return(-1); }
/// <summary> /// �����Ʒ�۸������б� /// </summary> private List<Model.goods_group_price> GetGoodsGroupPriceList(int article_id) { List<Model.goods_group_price> modelList = new List<Model.goods_group_price>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,group_id,price from dt_goods_group_price "); strSql.Append(" where article_id=" + article_id); DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.goods_group_price model; for (int n = 0; n < rowsCount; n++) { model = new Model.goods_group_price(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "") { model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString()); } if (dt.Rows[n]["group_id"] != null && dt.Rows[n]["group_id"].ToString() != "") { model.group_id = int.Parse(dt.Rows[n]["group_id"].ToString()); } if (dt.Rows[n]["price"] != null && dt.Rows[n]["price"].ToString() != "") { model.price = decimal.Parse(dt.Rows[n]["price"].ToString()); } modelList.Add(model); } } return modelList; }