/// <summary> /// 增加购物车商品信息 /// </summary> /// <param name="shoppingCartEntity">购物车信息实体</param> /// <returns></returns> public bool AddShoppingCartProductInfo(ShoppingCartEntity shoppingCartEntity) { var holycaDb = new HolycaEntities(); Sale_ShoppingCart sale_ShoppingCart = new Sale_ShoppingCart(); MCvHelper.ObjectCopyTo(shoppingCartEntity, sale_ShoppingCart); try { holycaDb.Sale_ShoppingCart.AddObject(sale_ShoppingCart); holycaDb.SaveChanges(); return true; } catch { return false; } }
/// <summary> /// 获取当前用户的购物车中的商品信息 /// </summary> /// <param name="userId">用户ID</param> /// <param name="guid">用户全局变量</param> /// <param name="channelId">渠道ID</param> /// <returns></returns> public List<ShoppingCartEntity> GetShoppingCartProductInfosByUserIDGuidChannelID(int userId, string guid, int channelId) { var holycaDb = new HolycaEntities(); List<ShoppingCartEntity> resultList = new List<ShoppingCartEntity>(); ShoppingCartEntity shoppingCartEntity; List<Sale_ShoppingCart> retList = new List<Sale_ShoppingCart>(); //用户登录了就用userId查询,用户未登录用Guid查 if (userId > 0) { var queryTxt = from c in holycaDb.Sale_ShoppingCart where c.intUserID == userId && c.intChannelID == channelId select c; retList = queryTxt.ToList(); } else { var queryTxt = from c in holycaDb.Sale_ShoppingCart where c.vchGuid == guid && c.intChannelID == channelId select c; retList = queryTxt.ToList(); } if (retList != null && retList.Count > 0) { foreach (Sale_ShoppingCart ssc in retList) { shoppingCartEntity = new ShoppingCartEntity(); MCvHelper.ObjectCopyTo(ssc, shoppingCartEntity); resultList.Add(shoppingCartEntity); } } return resultList; }