예제 #1
0
 /// <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;
     }
 }
예제 #2
0
        /// <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;
        }