/// <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); }
/// <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); } }