/// <summary> /// 购物车商品条目数 /// </summary> /// <param name="entId">企业</param> /// <param name="userId">用户</param> /// <param name="ywyId">业务员</param> /// <returns></returns> public ActionResult NumberOfItems(string entId, string userId, string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); if (user.Count <= 0) { return(Json(new { success = false, message = "用户未登录,请重新登录" })); } ///获取购物车信息 CartDal cdal = new CartDal(); int num = cdal.GetCartCount(entId, userId, ywyId); return(Json(new { success = true, message = "购物车商品条目数获取成功", num })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/NumberOfItems", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
/// <summary> /// 获取购物车金额 /// </summary> /// <param name="entId">企业Id</param> /// <param name="userId">用户id</param> /// <param name="goodsList">选中的商品id</param> /// <returns></returns> public JsonResult CartAmount(string entId, string userId, string goodsList, string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); if (user.Count <= 0) { return(Json(new { success = false, message = "E002" })); } ///获取购物车信息 CartDal cdal = new CartDal(); List <CartList> list = cdal.GetCartAmount(user[0].EntId, userId, goodsList, user[0].Pricelevel, user[0].KhType, ywyId); return(Json(new { success = true, list = list })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/CartAmount", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
/// <summary> /// 再次购买 /// </summary> /// <param name="userId">用户Id</param> /// <param name="entId">机构Id</param> /// <param name="billNo">订单序号</param> /// <returns></returns> public JsonResult OnceAgain(string userId, string entId, int billNo, string cartType, string bs = "XQ", string loginId = "") { try { if (string.IsNullOrEmpty(userId)) { LogQueue.Write(LogType.Error, "Cart/OnceAgain", $"userId:{userId},entId:{entId},billNo:{billNo}"); return(Json(new{ success = false, message = "用户未登录,请先登录!" })); } ///获取用户信息 UserInfoDal udal = new UserInfoDal(); List <UserInfo> user = udal.GetUserInfo(userId, entId); string jgjb = "", khType = ""; if (user.Count > 0) { jgjb = user[0].Pricelevel; khType = user[0].KhType; } CartDal dal = new CartDal(); string result = dal.OnceAgain(userId, entId, billNo, loginId, out bool flag, jgjb, khType, cartType, bs); return(Json(new { success = flag, message = result })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/OnceAgain", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message })); } }
public bool InsertCart(int mid, decimal price, int number, int pid) { T_Cart cart = new T_Cart(); T_Protuct produce = new T_Protuct(); T_ProductDetail pdetail = new T_ProductDetail(); UserBll userbll = new UserBll(); cart.CreateDate = DateTime.Now; cart.ProductPrice = price; cart.ProductNumber = number; cart.ProductdetailId = mid; cart.ProductId = pid; cart.UserId = userbll.GetUserIdByToken(); ProductBll pbll = new ProductBll(); CartDal cartdal = new CartDal(); produce = pbll.GetProductById(pid); pdetail = pbll.GetPDetailById(mid); if (pdetail != null) { cart.Specification = pdetail.Specification; cart.Size = pdetail.Size; } if (produce != null) { cart.ProductName = produce.ProductTitle; cart.ImgUrl = produce.Imgurl1; // cart.Specification=produce.sp } return(cartdal.InsertCart(cart)); }
/// <summary> /// 删除购物车商品 /// </summary> /// <param name="entId">企业Id</param> /// <param name="userId">用户id</param> /// <param name="dltType">删除类型(单条one/全部all)</param> /// <param name="cartId">购物车Id</param> /// <returns></returns> public JsonResult DeleteCartGoods(string entId, string userId, string dltType, string cartId, string cartType = "", string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } if (dltType == "" || (dltType == "one" && cartId == "")) { return(Json(new { success = false, message = "必传参数不能为空" })); } CartDal dal = new CartDal(); bool flag = dal.DeleteCart(entId, userId, dltType, cartId, cartType, ywyId); if (flag) { return(Json(new { success = true, message = "操作成功" })); } else { return(Json(new { success = false, message = "E006" })); } } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/DeleteCartGoods", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
//return cart list public ActionResult getCartProductsByJSON() { Cartdal = new CartDal(); List <Cart> CartList = Cartdal.cart.ToList <Cart>(); return(Json(CartList, JsonRequestBehavior.AllowGet)); }
//function add item to cart public ActionResult AddToCart() { CartDal dal = new CartDal(); Cart cart = new Cart(); cart.Model = Request.Form["Model"].ToString(); string mo = Request.Form["Model"].ToString(); cart.Type = Request.Form["Type"].ToString(); cart.Price = Convert.ToInt32(Request.Form["Price"]); List <Cart> p = (from x in dal.cart where x.Model.Contains(mo) select x).ToList(); if (p.Count == 0) { cart.CartQuantity++; dal.cart.Add(cart); } else if (p.Count == 1) { var cartv = dal.cart.First(m => m.Model == mo); cart.CartQuantity = cartv.CartQuantity; cart.CartQuantity++; var ToDeleteC = dal.cart.First(m => m.Model == mo); dal.cart.Remove(ToDeleteC); dal.cart.Add(cart); } dal.SaveChanges(); UpdateMQuantity(cart.Model, "Add"); return(Json(cart, JsonRequestBehavior.AllowGet)); }
public bool DelCartById(int CartId) { CartDal cartdal = new CartDal(); UserBll userbll = new UserBll(); int userid = userbll.GetUserIdByToken(); return(cartdal.DelCartById(CartId, userid)); }
public int GetCartNumByUserId(int userid) { CartDal cartdal = new CartDal(); if (cartdal.GetCartListByUserId(userid) != null) { return(cartdal.GetCartListByUserId(userid).Count()); } else { return(0); } }
//removes item from cart public ActionResult RemoveFromCart() { //if (((string)Session["type"]).Equals("Employee")) CartDal dal = new CartDal(); Cart pro = new Cart(); pro.Model = Request.Form["Model"].ToString(); string mo = Request.Form["Model"].ToString(); List <Cart> p = (from x in dal.cart where x.Model.Contains(mo) select x).ToList(); if (ModelState.IsValid && p.Count != 0) { //there is such model ... delete him var ToDelete = dal.cart.First(m => m.Model == pro.Model); // Delete pro.Type = ToDelete.Type; pro.CartQuantity = ToDelete.CartQuantity; pro.Price = ToDelete.Price; dal.cart.Remove(ToDelete); dal.SaveChanges(); UpdateMQuantity(mo, "Remove"); if (pro.CartQuantity > 1) { pro.CartQuantity--; dal.cart.Add(pro); dal.SaveChanges(); } List <Cart> cartL1 = dal.cart.ToList <Cart>(); return(Json(cartL1, JsonRequestBehavior.AllowGet)); } else { return(RedirectToAction("ShoppingCart", "Buying")); } }
public JsonResult CartList(string entId, string userId, string goodsList, string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); if (user.Count <= 0) { return(Json(new { success = false, message = "E002" })); } CartDal cdal = new CartDal(); List <CartEenDoc> cartDoc = new List <CartEenDoc>(); ///获取购物车商品机构列表 DataTable dtCartEnt = cdal.GetCartEntList(userId); ///获取购物车信息 if (dtCartEnt == null || dtCartEnt.Rows.Count <= 0) { return(Json(new { success = false, messageCode = "E002", message = "无数据" })); } foreach (DataRow dr in dtCartEnt.Rows) { CartEenDoc model = new CartEenDoc(); model.EntId = dr["entId"].ToString(); model.EntName = dr["entname"].ToString(); model.cartlist = cdal.GetCartList(dr["entId"].ToString(), userId, goodsList, user[0].Pricelevel, user[0].KhType, ywyId); cartDoc.Add(model); } return(Json(new { success = true, list = cartDoc })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/CartList", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
/// <summary> /// 组合商品加入购物车 /// </summary> /// <param name="userId">用户Id</param> /// <param name="entId">企业Id</param> /// <param name="fabh">方案编号</param> /// <param name="num">组数</param> /// <returns></returns> public JsonResult AddCartGroup(string userId, string entId, string cartType, string fabh, decimal num, string bs = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } if (num <= 0) { return(Json(new { success = false, message = "购买组数不能小于0" })); } //获取组合商品信息 PromotionDal pdal = new PromotionDal(); DataTable dt = pdal.GetGroupInfo(entId, userId, fabh); if (dt.Rows.Count <= 0) { return(Json(new { success = true, message = "该组合不存在" })); } StringBuilder strSql = new StringBuilder(); string msg = ""; foreach (DataRow dr in dt.Rows) { ///客户经营范围验证 if (decimal.Parse(dr["giftquantity"].ToString()) * num > decimal.Parse(dr["stock_quantity"].ToString())) { msg = dr["sub_title"].ToString() + "库存不足"; return(Json(new { success = true, message = msg })); } } CartDal dal = new CartDal(); msg = dal.CartAddGroup(entId, userId, num, fabh, out int flag, bs, cartType); return(Json(new { success = flag == 0?true:false, message = msg })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/AddCartGroup", ex.Message.ToString()); return(Json(new { success = false, message = "E005" })); } }
/// <summary> /// 商品添加购物车 /// </summary> /// <param name="entId">企业id</param> /// <param name="userId">用户id</param> /// <param name="article_Id">商品id</param> /// <param name="quantity">数量</param> /// <param name="cartType">购物车类型</param> /// <param name="fabh">促销方案编号</param> /// <param name="bs">'XQ'商品详情/''购物车</param> /// <returns></returns> public JsonResult CartAdd(string entId, string userId, string article_Id, decimal quantity, string cartType, string fabh, string bs = "", string ywyId = "") { try { ///获取用户信息 UserInfoDal userInfo = new UserInfoDal(); List <UserInfo> user = userInfo.GetUserInfo(userId ?? "", entId); if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } else if (quantity <= 0) { return(Json(new { success = false, message = "购买数量不能小于0" })); } else if (user[0].Status == 1) { return(Json(new { success = false, message = "该账号未通过审核,无法购买商品" })); } ////客户经营范围拦截 CartDal dal = new CartDal(); bool flag = dal.CartAdd(entId, userId, article_Id, quantity, cartType, fabh, bs, ywyId); if (flag) { ///获取购物车条目数 int num = dal.GetCartCount(entId, userId, ywyId); return(Json(new { success = true, num = num, message = "加入购物车成功" })); } else { return(Json(new { success = true, message = "加入失败" })); } } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/CartAdd", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
/// <summary> /// 快速下单商品加入购物车 /// </summary> /// <param name="entId"></param> /// <param name="userId"></param> /// <param name="IdOrNum"></param> /// <returns></returns> public JsonResult SetCarProducts(string entId, string userId, string IdOrNum) { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } CartDal dal = new CartDal(); var proModel = IdOrNum.Split('|');//id,num|id,num| List <string> successlist = new List <string>(); List <string> errorlist = new List <string>(); if (proModel.Length > 0) { foreach (var porobj in proModel) { if (porobj != null && porobj != "") { var pro = porobj.Split(','); if (pro.Length == 2) { bool flag = dal.CartAdd(entId, userId, pro[0], decimal.Parse(pro[1]), "PC", "", "XQ"); if (flag) { successlist.Add(pro[0]); } else { errorlist.Add(pro[0]); } } else { return(Json(new { success = false, num = 0, message = "请检查下单商品的拼接!" })); } } else { return(Json(new { success = false, num = 0, message = "请检查下单组合的拼接!" })); } } } else { return(Json(new { success = false, num = 0, message = "请选择加入购物车的商品!" })); } if (errorlist.Count == 0) { return(Json(new { success = true, num = successlist.Count, message = "加入购物车成功" })); } else if (successlist.Count == 0) { return(Json(new { success = false, num = 0, message = "加入购物车全部失败" })); } else { return(Json(new { success = true, num = -1, message = "未全部加入购物车,某些商品加入失败" })); } } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/CartAdd", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
public List <T_Cart> GetCartListByUserId(int userid) { CartDal cartdal = new CartDal(); return(cartdal.GetCartListByUserId(userid)); }