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