/// <summary> /// 转换成List /// </summary> public static List <Model.cart_items> ToList(List <Model.cart_keys> ls, int group_id) { if (ls != null) { List <Model.cart_items> iList = new List <Model.cart_items>(); foreach (Model.cart_keys item in ls) { //查询文章的信息 Model.article articleModel = new BLL.article().GetModel(item.channel_id, item.article_id); if (articleModel == null || !articleModel.fields.ContainsKey("sell_price")) { continue; } //开始赋值 Model.cart_items modelt = new Model.cart_items(); modelt.channel_id = articleModel.channel_id; modelt.article_id = articleModel.id; if (articleModel.fields.ContainsKey("goods_no")) { modelt.goods_no = articleModel.fields["goods_no"]; } modelt.title = articleModel.title; modelt.img_url = articleModel.img_url; modelt.sell_price = ConvertTool.ToDecimal(articleModel.fields["sell_price"], 0); modelt.user_price = ConvertTool.ToDecimal(articleModel.fields["sell_price"], 0); if (articleModel.fields.ContainsKey("point")) { modelt.point = ConvertTool.ToInt(articleModel.fields["point"], 0); } if (articleModel.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = ConvertTool.ToInt(articleModel.fields["stock_quantity"], 0); } bool setStatus = false; //会员组价格赋值状态 if (group_id > 0 && articleModel.group_price != null) { Model.user_group_price userPriceModel = articleModel.group_price.Find(p => p.group_id == group_id); if (userPriceModel != null) { setStatus = true; //已赋值 modelt.user_price = userPriceModel.price; } } //如果未曾有会员组价格则使用折扣价格 if (group_id > 0 && !setStatus) { int discount = new BLL.user_groups().GetDiscount(group_id); if (discount > 0) { modelt.user_price = modelt.sell_price * discount / 100; } } modelt.quantity = item.quantity; //添加入列表 iList.Add(modelt); } return(iList); } return(null); }
public IList <Model.cart_items> GetList(string cart) { IDictionary <string, string> dic = GetCart(DTKeys.COOKIE_SHOPPING_CART) as Dictionary <string, string>; if (dic != null) { IList <Model.cart_items> iList = new List <Model.cart_items>(); foreach (var item in dic) { try { Model.article_goods model = bll.GetGoodsModel(Utils.StrToInt(item.Key, 0)); Model.cart_items modelt = new Model.cart_items(); if (model != null) { modelt.title = model.title; modelt.img_url = model.img_url; modelt.price = model.sell_price; modelt.id = model.id; modelt.quantity = Utils.StrToInt(item.Value, 0); } iList.Add(modelt); } catch (Exception eee) { } } return(iList); } return(null); }
/// <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 model = bll.GetModel(Convert.ToInt32(item.Key)); if (model == null || !model.fields.ContainsKey("sell_price")) { continue; } Model.cart_items modelt = new Model.cart_items(); modelt.id = model.id; modelt.title = model.title; modelt.img_url = model.img_url; if (model.fields.ContainsKey("point")) { modelt.point = Utils.StrToInt(model.fields["point"], 0); } modelt.price = Utils.StrToDecimal(model.fields["WholesalePrice"], 0); modelt.user_price = Utils.StrToDecimal(model.fields["sell_price"], 0); if (model.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Utils.StrToInt(model.fields["stock_quantity"], 0); } if (model.fields.ContainsKey("english_name")) { modelt.english_name = model.fields["english_name"].ToString(); } if (model.fields.ContainsKey("Barcode")) { modelt.Barcode = model.fields["Barcode"].ToString(); } ////会员价格 //if (model.group_price != null) //{ // Model.user_group_price gmodel = model.group_price.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> 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 model = bll.GetModel(Convert.ToInt32(item.Key)); if (model == null || !model.fields.ContainsKey("sell_price")) { continue; } Model.cart_items modelt = new Model.cart_items(); modelt.id = model.id; modelt.title = model.title; modelt.img_url = model.img_url; if (model.fields.ContainsKey("point")) { modelt.point = Utils.StrToInt(model.fields["point"], 0); } modelt.price = Utils.StrToDecimal(model.fields["sell_price"], 0); modelt.user_price = Utils.StrToDecimal(model.fields["sell_price"], 0); if (model.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Utils.StrToInt(model.fields["stock_quantity"], 0); } //会员价格 if (model.group_price != null) { Model.user_group_price gmodel = model.group_price.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> 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> 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> public static IList<Model.cart_items> GetList(int group_id) { IDictionary<string, int> dic = GetCart(); if (dic==null || dic.Count <= 0) { #region 获取数据库购物车 Model.users model = new BasePage().GetUserInfo(); if (model != null) { BLL.cart cartbll = new BLL.cart(); DataTable dt = cartbll.GetList("UserID='" + model.id + "'").Tables[0]; if (dt.Rows.Count <= 0) { //return null; } else { dic = new Dictionary<string, int>(); for (int i = 0; i < dt.Rows.Count; i++) { dic.Add(dt.Rows[i]["ProductName"].ToString(), int.Parse(dt.Rows[i]["Counts"].ToString())); } } } #endregion } if (dic != null) { IList<Model.cart_items> iList = new List<Model.cart_items>(); foreach (var item in dic) { BLL.article bll = new BLL.article(); //key:1547-27|120,28|122-55 int goods_id = Convert.ToInt32(item.Key.Split('-')[0]); string standard = item.Key.Split('-')[1]; decimal unit_id = decimal.Parse(item.Key.Split('-')[2], 0);// Convert.ToDecimal(item.Key.Split('-')[2]); Model.article model = bll.GetModel(Convert.ToInt32(goods_id)); if (model == null || !model.fields.ContainsKey("sell_price")) { continue; } string standard_value_ids = ""; string[] arr_standard = standard.Split(','); foreach (string str in arr_standard) { if (!string.IsNullOrEmpty(str)) { standard_value_ids += str.Split('|')[1] + ","; } } if (!string.IsNullOrEmpty(standard_value_ids)) { standard_value_ids = standard_value_ids.Substring(0, standard_value_ids.Length - 1); } Model.cart_items modelt = new Model.cart_items(); modelt.id = model.id; modelt.title = model.title; modelt.img_url = model.img_url; modelt.standard = standard; modelt.unit_id = unit_id; if (model.fields.ContainsKey("point")) { modelt.point = Utils.StrToInt(model.fields["point"], 0); } modelt.price = Utils.StrToDecimal(model.fields["sell_price"], 0); modelt.user_price = Utils.StrToDecimal(model.fields["sell_price"], 0); //单位价格 -- 有单位 无会员 无规格 BLL.unit bll_unit = new BLL.unit(); Model.unit model_unit = bll_unit.GetModel(unit_id); if (model_unit != null) { modelt.price = Utils.StrToDecimal(model.fields["sell_price"], 0) * model_unit.quantity * (model_unit.rate / 100); modelt.user_price = Utils.StrToDecimal(model.fields["sell_price"], 0) * model_unit.quantity * (model_unit.rate / 100); } //规格价格 --有/无单位 无会员 有规格 BLL.standard_price bll_standard_price = new BLL.standard_price(); DataTable dt_standard_price = bll_standard_price.GetList("standard_value_ids='" + standard_value_ids + "' and good_id=" + goods_id).Tables[0]; if (dt_standard_price != null && dt_standard_price.Rows.Count > 0) { modelt.user_price = modelt.price = Utils.StrToDecimal(dt_standard_price.Rows[0]["sell_price"].ToString(), 0); if (model_unit != null) { modelt.user_price = modelt.price = Utils.StrToDecimal(dt_standard_price.Rows[0]["sell_price"].ToString(), 0) * model_unit.quantity * (model_unit.rate / 100); } } if (model.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Utils.StrToInt(model.fields["stock_quantity"], 0); } //会员价格 if (model.group_price != null) { Model.user_group_price gmodel = model.group_price.Find(p => p.group_id == group_id); if (gmodel != null) { modelt.user_price = gmodel.price; //有规格才有规格等级价格 if (dt_standard_price != null && dt_standard_price.Rows.Count > 0) { BLL.standard_group_price bll_standard_group_price = new BLL.standard_group_price(); DataTable dt_standard_group_price = bll_standard_group_price.GetList("good_id=" + goods_id + " and standard_price_id=" + dt_standard_price.Rows[0]["id"].ToString() + " and group_id=" + group_id).Tables[0]; //有规格会员价格 if (dt_standard_group_price != null && dt_standard_group_price.Rows.Count > 0) { //规格会员价格 无单位-- 有规格 有会员 modelt.user_price = Convert.ToDecimal(dt_standard_group_price.Rows[0]["group_price"]); } } if (model_unit != null) { modelt.user_price = modelt.user_price * model_unit.quantity * (model_unit.rate / 100); } } } modelt.quantity = item.Value; iList.Add(modelt); } return iList; } return null; }
/// <summary> /// 转换成List /// </summary> public static List<Model.cart_items> ToList(List<Model.cart_keys> ls, int group_id) { if (ls != null) { List<Model.cart_items> iList = new List<Model.cart_items>(); foreach (Model.cart_keys item in ls) { //查询文章的信息 Model.article articleModel = new BLL.article().GetModel(item.article_id); if (articleModel == null || !articleModel.fields.ContainsKey("sell_price")) { continue; } //查询商品信息 Model.article_goods goodsModel = articleModel.goods.Find(p => p.id == item.goods_id); if (articleModel.goods != null && articleModel.goods.Count > 0 && goodsModel == null) { continue; } //开始赋值 Model.cart_items modelt = new Model.cart_items(); modelt.article_id = articleModel.id; if (articleModel.fields.ContainsKey("goods_no")) { modelt.goods_no = articleModel.fields["goods_no"]; } modelt.title = articleModel.title; modelt.img_url = articleModel.img_url; modelt.sell_price = Utils.StrToDecimal(articleModel.fields["sell_price"], 0); modelt.user_price = Utils.StrToDecimal(articleModel.fields["sell_price"], 0); if (articleModel.fields.ContainsKey("point")) { modelt.point = Utils.StrToInt(articleModel.fields["point"], 0); } if (articleModel.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Utils.StrToInt(articleModel.fields["stock_quantity"], 0); } bool setStatus = false; //会员组价格赋值状态 if (goodsModel != null) { modelt.stock_quantity = goodsModel.stock_quantity; //库存 modelt.sell_price = goodsModel.sell_price; //商品价格 modelt.user_price = goodsModel.sell_price; //会员组价格 modelt.goods_id = goodsModel.id; modelt.goods_no = goodsModel.goods_no; modelt.spec_text = goodsModel.spec_text; //会员组价格 if (group_id > 0 && goodsModel.group_prices != null) { Model.user_group_price userPriceModel = goodsModel.group_prices.Find(p => p.group_id == group_id); if (userPriceModel != null) { setStatus = true; //已赋值 modelt.user_price = userPriceModel.price; } } } //如果未曾有会员组价格则使用折扣价格 if (group_id > 0 && !setStatus) { int discount = new BLL.user_groups().GetDiscount(group_id); if (discount > 0) { modelt.user_price = modelt.sell_price * discount / 100; } } modelt.quantity = item.quantity; //添加入列表 iList.Add(modelt); } return iList; } return null; }
/// <summary> /// 转换成List /// </summary> public static List <Model.cart_items> ToList(List <Model.cart_keys> ls, int group_id) { if (ls != null) { List <Model.cart_items> iList = new List <Model.cart_items>(); foreach (Model.cart_keys item in ls) { //查询文章的信息 Model.article articleModel = new BLL.article().GetModel(item.article_id); if (articleModel == null || !articleModel.fields.ContainsKey("sell_price")) { continue; } //查询商品信息 Model.article_goods goodsModel = articleModel.goods.Find(p => p.id == item.goods_id); if (articleModel.goods != null && articleModel.goods.Count > 0 && goodsModel == null) { continue; } //开始赋值 Model.cart_items modelt = new Model.cart_items(); modelt.article_id = articleModel.id; if (articleModel.fields.ContainsKey("goods_no")) { modelt.goods_no = articleModel.fields["goods_no"]; } modelt.title = articleModel.title; modelt.img_url = articleModel.img_url; modelt.seller_id = articleModel.user_id; //供应商id modelt.seller_name = articleModel.user_name; //供应商name modelt.sell_price = Utils.StrToDecimal(articleModel.fields["sell_price"], 0); modelt.user_price = Utils.StrToDecimal(articleModel.fields["sell_price"], 0); if (articleModel.fields.ContainsKey("point")) { modelt.point = Utils.StrToInt(articleModel.fields["point"], 0); } if (articleModel.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Utils.StrToInt(articleModel.fields["stock_quantity"], 0); } bool setStatus = false; //会员组价格赋值状态 if (goodsModel != null) { modelt.stock_quantity = goodsModel.stock_quantity; //库存 modelt.sell_price = goodsModel.sell_price; //商品价格 modelt.user_price = goodsModel.sell_price; //会员组价格 modelt.goods_id = goodsModel.id; modelt.goods_no = goodsModel.goods_no; modelt.spec_text = goodsModel.spec_text; //会员组价格 if (group_id > 0 && goodsModel.group_prices != null) { Model.user_group_price userPriceModel = goodsModel.group_prices.Find(p => p.group_id == group_id); if (userPriceModel != null) { setStatus = true; //已赋值 modelt.user_price = userPriceModel.price; } } } //如果未曾有会员组价格则使用折扣价格 if (group_id > 0 && !setStatus) { int discount = new BLL.user_groups().GetDiscount(group_id); if (discount > 0) { modelt.user_price = modelt.sell_price * discount / 100; } } modelt.quantity = item.quantity; modelt.use_date = item.use_date;//add by 赵成龙 //添加入列表 iList.Add(modelt); } return(iList); } return(null); }
/// <summary> /// 獲得購物車列表 /// </summary> public static IList <Model.cart_items> GetList(int group_id) { BLL.goods bllgoods = new BLL.goods(); BLL.article bll = new BLL.article(); BLL.user_group_price bll_group = new BLL.user_group_price(); Tea.Model.users _users = new Tea.Web.UI.UserPage().GetUserInfo(); IDictionary <string, int> dic = GetCart(); if (dic != null) { int hong = 0, lv = 0; IList <Model.cart_items> i_List = new List <Model.cart_items>(); string[] CartKey = new string[2]; foreach (var item in dic) { CartKey = item.Key.Split('_'); Model.cart_items modelt = new Model.cart_items(); if (CartKey.Length > 1) { Model.article model = bll.GetModel(Convert.ToInt32(CartKey[0])); Model.goods modelgoods = bllgoods.GetModel(Convert.ToInt32(CartKey[1])); if (model == null || modelgoods == null) { continue; } if (model.status != 0) { continue; } if (model.add_time > System.DateTime.Now || modelgoods.stock_quantity < 1) { continue; } if (model.xia_date != null && model.xia_date.Value.AddDays(1) < System.DateTime.Now) { continue; } modelt.ps = model.call_index; modelt.id = model.id; modelt.key = item.Key; modelt.title = model.title; modelt.sub_title = model.sub_title; modelt.img_url = model.img_url; modelt.goods_color = modelgoods.color; modelt.goods_size = modelgoods.size; modelt.zhong = modelgoods.zhong; modelt.chang = modelgoods.chang; modelt.kuan = modelgoods.kuan; modelt.gao = modelgoods.gao; modelt.point = model.point; modelt.price = modelgoods.market_price; modelt.user_price = modelgoods.sell_price; if (modelgoods.yu_lock > 0) { Tea.Model.sales models = new Tea.BLL.sales().GetModel(modelgoods.yu_lock); if (models != null && models.type == "2" && models.status == 1 && models.start_time < System.DateTime.Now && (models.end_time == null || models.end_time > System.DateTime.Now)) { modelt.user_price = modelgoods.yu_num; } } modelt.goodsid = modelgoods.id; modelt.goods_code = modelgoods.goods_no; modelt.stock_quantity = modelgoods.stock_quantity; modelt.quantity = item.Value; modelt.sales_id = modelgoods.yu_lock; modelt.by = model.wheresql; modelt.hdcode = model.guige; if (model.is_msg == 0) { modelt.sales_name = "no"; } modelt.psmoney = model.brand_id.ToString(); if (group_id > 0) { if (model.brand_id == 1) { if (_users != null && _users.group_id == 2) { Model.user_group_price userPriceModel = bll_group.GetModel(modelt.goodsid, _users.id); if (userPriceModel != null) { modelt.user_price = userPriceModel.price; } } } i_List.Add(modelt); } else { if (model.brand_id == 1 && group_id == -3) { if (_users != null && _users.group_id == 2) { Model.user_group_price userPriceModel = bll_group.GetModel(modelt.goodsid, _users.id); if (userPriceModel != null) { modelt.user_price = userPriceModel.price; modelt.by = "vip"; i_List.Add(modelt); } } } if (model.brand_id == 3 && group_id == -2) { i_List.Add(modelt); } if (model.brand_id != 3 && group_id == -1 && model.wheresql != "jiajia") { if (_users.group_id == 1) { i_List.Add(modelt); } else { Model.user_group_price userPriceModel = bll_group.GetModel(modelt.goodsid, _users.id); if (userPriceModel == null) { i_List.Add(modelt); } } } try { if (model.wheresql == "jiajia" && group_id == -1 && Convert.ToInt32(CartKey[2]) == 1) { i_List.Add(modelt); } if (model.wheresql == "jiajia" && group_id == -2 && Convert.ToInt32(CartKey[2]) == 2) { i_List.Add(modelt); } if (model.wheresql == "jiajia" && group_id == -3 && Convert.ToInt32(CartKey[2]) == 3) { i_List.Add(modelt); } } catch (Exception eee) { } } } } return(i_List); } return(null); }
protected void btnlogin_Click(object sender, ImageClickEventArgs e) { IDictionary <string, string> dic = GetCart(DTKeys.COOKIE_SHOPPING_CART) as Dictionary <string, string>; cartModel = GetTotal(DTKeys.COOKIE_SHOPPING_CART); if (dic == null) { Response.Redirect("productJPlist.aspx"); } Model.orders model = new Model.orders(); model.order_no = hideNo.Value; model.user_id = WEBUserCurrent.UserID; model.user_name = WEBUserCurrent.UserName; model.payment_id = string.IsNullOrEmpty(ddlzhifu.SelectedValue) ? 0 : int.Parse(ddlzhifu.SelectedValue); //付款類型 model.distribution_id = string.IsNullOrEmpty(ddlpeisong.SelectedValue) ? 0 : int.Parse(ddlpeisong.SelectedValue); //配送類型 model.accept_name = txtusername.Value; model.post_code = txtyoubian.Value; model.telphone = txtlianxidianhua.Value; model.mobile = txtphone.Value; model.address = txtdizhi.Value; model.message = txtliuyan.Value; model.payable_freight = decimal.Parse(Fee); //應付運費 model.real_freight = decimal.Parse(Fee); //實付運費 model.payment_fee = 0; //付款手續費 model.point = Utils.StringToNum(hidePoint.Value); //獲得的積分 model.add_time = DateTime.Now; model.order_goods = new List <order_goods>(); decimal Price = 0m; decimal GoodsPrice = 0, GoodToablPrice = 0; if (dic != null) { IList <Model.cart_items> iList = new List <Model.cart_items>(); foreach (var item in dic) { try { Model.article_goods modelPro = bll.GetGoodsModel(Utils.StrToInt(item.Key, 0)); Model.cart_items modelt = new Model.cart_items(); if (model != null) { int ProductID = modelPro.id; int ShopNumber = Utils.StrToInt(item.Value, 0); Model.article_goods modelpro = bll.GetGoodsModel(ProductID); Price = modelpro.sell_price; GoodsPrice = ShopNumber * Price; GoodToablPrice += GoodsPrice; Model.order_goods detail = new Model.order_goods(); detail.goods_id = ProductID; detail.goods_name = modelPro.title; detail.goods_price = modelPro.sell_price; detail.point = Utils.StringToNum(hidePoint.Value); detail.quantity = ShopNumber; detail.real_price = modelpro.market_price; model.order_goods.Add(detail); } } catch (Exception eee) { } } } #region 算折扣 string aa = Request.Form["chkPoint"]; decimal PousePrice = 0, LastPrice = 0; if (!string.IsNullOrEmpty(aa)) { PousePrice = GoodToablPrice - decimal.Parse(hidePoint.Value); //model.payable_amount = model.order_amount; //model.real_amount = model.order_amount; } else { PousePrice = GoodToablPrice; } #endregion #region 算运费 if (hideFee.Value == "2") { decimal FeeLv = TwoTypeFee; if (PousePrice >= FeeLv) { LastPrice = PousePrice; model.payable_freight = 0; //應付運費 model.real_freight = 0; //實付運費 } else { LastPrice = PousePrice + decimal.Parse(Fee); //訂單總金額 } } else { LastPrice = PousePrice + decimal.Parse(Fee); //訂單總金額 } #endregion model.order_amount = LastPrice; //訂單總金額 model.payable_amount = LastPrice; //應付商品總金額 model.real_amount = LastPrice; //實付商品總金額 #region 清空购物车 Clear(DTKeys.COOKIE_SHOPPING_CART, "0"); #endregion 清空购物车 //普通訂單的情況下修改狀態 if (!string.IsNullOrEmpty(Request.QueryString["cjid"])) { int id = Convert.ToInt32(Request.QueryString["cjid"]); BLL.article bll = new BLL.article(); Model.article_goods productmodel = bll.GetGoodsModel(id); bll.UpdateField(id, "Status=3"); model.status = 6; } int bk = bllorder.Add(model); string Url = "pay.aspx?"; Url += "paymenttype=" + ddlzhifu.SelectedValue + ""; Url += "&id=" + bk + ""; // string UserUrl = "userinfo.aspx"; if (bk > 0) { //setEmail(model.order_no); UpUserPoint(PousePrice); int Uid = WEBUserCurrent.UserID; User.UpJianPoint(Uid, Utils.StringToNum(hidePoint.Value)); AddAmount(LastPrice); this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('送出訂單成功,請牢記訂單號:" + model.order_no + "');window.location.href = '" + Url + "';</script>"); // Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "pay", "window.open('" + Url + "');window.location.href='" + UserUrl + "';", true); //Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "pay", "window.open('" + Url + "');", true); //Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "transfer", "window.location.href='" + UserUrl + "';", true); } else { this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('送出失敗,請重新送出');window.location.href = '" + Url + "';</script>"); } }
/// <summary> /// 獲得購物車列表 /// </summary> public static IList <Model.cart_items> GetList(int group_id, int uid) { BLL.goods bllgoods = new BLL.goods(); BLL.article bll = new BLL.article(); BLL.user_group_price bll_group = new BLL.user_group_price(); Tea.Model.users _users = new BLL.users().GetModel(uid); IDictionary <string, int> dic = GetCart(); if (dic != null) { int hong = 0, lv = 0; IList <Model.cart_items> i_List = new List <Model.cart_items>(); string[] CartKey = new string[2]; foreach (var item in dic) { CartKey = item.Key.Split('_'); Model.cart_items modelt = new Model.cart_items(); if (CartKey.Length > 1) { Model.article model = bll.GetModel(Convert.ToInt32(CartKey[0])); Model.goods modelgoods = bllgoods.GetModel(Convert.ToInt32(CartKey[1])); if (model == null || modelgoods == null) { continue; } modelt.ps = model.call_index; modelt.id = model.id; modelt.key = item.Key; modelt.title = model.title; modelt.sub_title = model.sub_title; modelt.img_url = model.img_url; modelt.goods_color = modelgoods.color; modelt.goods_size = modelgoods.size; modelt.zhong = modelgoods.zhong; modelt.chang = modelgoods.chang; modelt.kuan = modelgoods.kuan; modelt.gao = modelgoods.gao; modelt.point = model.point; modelt.price = modelgoods.market_price; modelt.user_price = modelgoods.sell_price; modelt.goodsid = modelgoods.id; modelt.goods_code = modelgoods.goods_no; modelt.stock_quantity = modelgoods.stock_quantity; modelt.quantity = item.Value; modelt.sales_id = modelgoods.yu_lock; modelt.by = model.wheresql; modelt.psmoney = model.brand_id.ToString(); if (group_id > 0) { if (model.brand_id == 1) { if (_users != null && _users.group_id == 2) { Model.user_group_price userPriceModel = bll_group.GetModel(modelt.goodsid, _users.id); if (userPriceModel != null) { modelt.user_price = userPriceModel.price; } } } i_List.Add(modelt); } else { if (model.brand_id == 1 && group_id == -3) { if (_users != null && _users.group_id == 2) { Model.user_group_price userPriceModel = bll_group.GetModel(modelt.goodsid, _users.id); if (userPriceModel != null) { modelt.user_price = userPriceModel.price; modelt.by = "vip"; i_List.Add(modelt); } } } if (model.brand_id == 3 && group_id == -2) { i_List.Add(modelt); } if (model.brand_id != 3 && group_id == -1) { if (_users.group_id == 1) { i_List.Add(modelt); } else { Model.user_group_price userPriceModel = bll_group.GetModel(modelt.goodsid, _users.id); if (userPriceModel == null) { i_List.Add(modelt); } } } } } } return(i_List); } return(null); }
/// <summary> /// 获得购物车列表 /// </summary> public static IList <Model.cart_items> GetList(int group_id) { IDictionary <string, string> dic = GetCart(); if (dic != null) { IList <Model.cart_items> iList = new List <Model.cart_items>(); Model.cart_total totalmodel = new Model.cart_total(); foreach (var item in dic) { BLL.article bll = new BLL.article(); Model.article model = bll.GetModel(Convert.ToInt32(item.Key)); if (model == null || !model.fields.ContainsKey("sell_price")) { continue; } string[] strArray = item.Value.Split('|'); Model.cart_items modelt = new Model.cart_items(); modelt.id = model.id; modelt.title = model.title; //modelt.img_url = model.img_url; //获取产品图片 DataTable dt = new BLL.article_albums().GetList(1, " article_id=" + int.Parse((item.Key).ToString()) + " and category_id=1", " id").Tables[0]; var img = ""; if (dt.Rows.Count > 0) { img = dt.Rows[0]["original_path"].ToString(); modelt.img_url = img; } else { modelt.img_url = model.img_url; } modelt.quantity = strArray[0]; modelt.type = strArray[1]; modelt.weight = strArray[2]; modelt.price = decimal.Parse(strArray[3]); if (strArray[1] == "智能家居") { modelt.total_price = decimal.Parse(modelt.quantity) * modelt.price; } else { modelt.total_price = decimal.Parse(modelt.quantity) * modelt.price * decimal.Parse(modelt.weight); } totalmodel.payable_amount += modelt.total_price; totalmodel.total_point += modelt.point; if (model.fields.ContainsKey("point")) { modelt.point = Vincent._DTcms.Utils.StrToInt(model.fields["point"], 0); } modelt.user_price = Vincent._DTcms.Utils.StrToDecimal(model.fields["sell_price"], 0); if (model.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Vincent._DTcms.Utils.StrToInt(model.fields["stock_quantity"], 0); } //会员价格 if (model.group_price != null) { Model.user_group_price gmodel = model.group_price.Find(p => p.group_id == group_id); if (gmodel != null) { modelt.user_price = gmodel.price; } } iList.Add(modelt); } return(iList); } return(null); }
/// <summary> /// 获得购物车列表 /// </summary> public static IList <Model.cart_items> GetList(int group_id) { IDictionary <string, int> dic = GetCart(); if (dic == null || dic.Count <= 0) { #region 获取数据库购物车 Model.users model = new BasePage().GetUserInfo(); if (model != null) { BLL.cart cartbll = new BLL.cart(); DataTable dt = cartbll.GetList("UserID='" + model.id + "'").Tables[0]; if (dt.Rows.Count <= 0) { //return null; } else { dic = new Dictionary <string, int>(); for (int i = 0; i < dt.Rows.Count; i++) { dic.Add(dt.Rows[i]["ProductName"].ToString(), int.Parse(dt.Rows[i]["Counts"].ToString())); } } } #endregion } if (dic != null) { IList <Model.cart_items> iList = new List <Model.cart_items>(); foreach (var item in dic) { BLL.article bll = new BLL.article(); //key:1547-27|120,28|122-55 int goods_id = Convert.ToInt32(item.Key.Split('-')[0]); string standard = item.Key.Split('-')[1]; decimal unit_id = decimal.Parse(item.Key.Split('-')[2], 0);// Convert.ToDecimal(item.Key.Split('-')[2]); Model.article model = bll.GetModel(Convert.ToInt32(goods_id)); if (model == null || !model.fields.ContainsKey("sell_price")) { continue; } string standard_value_ids = ""; string[] arr_standard = standard.Split(','); foreach (string str in arr_standard) { if (!string.IsNullOrEmpty(str)) { standard_value_ids += str.Split('|')[1] + ","; } } if (!string.IsNullOrEmpty(standard_value_ids)) { standard_value_ids = standard_value_ids.Substring(0, standard_value_ids.Length - 1); } Model.cart_items modelt = new Model.cart_items(); modelt.id = model.id; modelt.title = model.title; modelt.img_url = model.img_url; modelt.standard = standard; modelt.unit_id = unit_id; if (model.fields.ContainsKey("point")) { modelt.point = Utils.StrToInt(model.fields["point"], 0); } modelt.price = Utils.StrToDecimal(model.fields["sell_price"], 0); modelt.user_price = Utils.StrToDecimal(model.fields["sell_price"], 0); //单位价格 -- 有单位 无会员 无规格 BLL.unit bll_unit = new BLL.unit(); Model.unit model_unit = bll_unit.GetModel(unit_id); if (model_unit != null) { modelt.price = Utils.StrToDecimal(model.fields["sell_price"], 0) * model_unit.quantity * (model_unit.rate / 100); modelt.user_price = Utils.StrToDecimal(model.fields["sell_price"], 0) * model_unit.quantity * (model_unit.rate / 100); } //规格价格 --有/无单位 无会员 有规格 BLL.standard_price bll_standard_price = new BLL.standard_price(); DataTable dt_standard_price = bll_standard_price.GetList("standard_value_ids='" + standard_value_ids + "' and good_id=" + goods_id).Tables[0]; if (dt_standard_price != null && dt_standard_price.Rows.Count > 0) { modelt.user_price = modelt.price = Utils.StrToDecimal(dt_standard_price.Rows[0]["sell_price"].ToString(), 0); if (model_unit != null) { modelt.user_price = modelt.price = Utils.StrToDecimal(dt_standard_price.Rows[0]["sell_price"].ToString(), 0) * model_unit.quantity * (model_unit.rate / 100); } } if (model.fields.ContainsKey("stock_quantity")) { modelt.stock_quantity = Utils.StrToInt(model.fields["stock_quantity"], 0); } //会员价格 if (model.group_price != null) { Model.user_group_price gmodel = model.group_price.Find(p => p.group_id == group_id); if (gmodel != null) { modelt.user_price = gmodel.price; //有规格才有规格等级价格 if (dt_standard_price != null && dt_standard_price.Rows.Count > 0) { BLL.standard_group_price bll_standard_group_price = new BLL.standard_group_price(); DataTable dt_standard_group_price = bll_standard_group_price.GetList("good_id=" + goods_id + " and standard_price_id=" + dt_standard_price.Rows[0]["id"].ToString() + " and group_id=" + group_id).Tables[0]; //有规格会员价格 if (dt_standard_group_price != null && dt_standard_group_price.Rows.Count > 0) { //规格会员价格 无单位-- 有规格 有会员 modelt.user_price = Convert.ToDecimal(dt_standard_group_price.Rows[0]["group_price"]); } } if (model_unit != null) { modelt.user_price = modelt.user_price * model_unit.quantity * (model_unit.rate / 100); } } } modelt.quantity = item.Value; iList.Add(modelt); } return(iList); } return(null); }