Esempio n. 1
0
 public string resetStock(string seckillArticleId)
 {
     try
     {
         if (_worker == null)
         {
             _worker = new Thread(DeEnqueue);
             _worker.Start();
         }
         if (_workerRedis == null)
         {
             _workerRedis = new Thread(DeEnqueueRedis);
             _workerRedis.Start();
         }
         //查询当前是否还存在库存
         articleInfo = _context.TSeckillArticle.FirstOrDefault(u => u.Id == seckillArticleId);
         int articleStockNum = articleInfo?.ArticleStockNum ?? 0;
         if (articleStockNum == 0)
         {
             //没有库存直接返回
             return("数据库存已为0");
         }
         else
         {
             //库存总值记录模式
             GlobalParam.queueStockrNum = articleStockNum;
             ////首先要清除原剩余库存
             //GlobalParam.queueNum.Clear();
             ////重新设置初始库存
             //for (int i = 0; i < articleStockNum; i++)
             //{
             //    GlobalParam.queueNum.Enqueue(i);
             //}
             return($"数据库存已重置成功{articleStockNum}");
         }
     }
     catch (Exception ex)
     {
     }
     return("重置库存失败");
 }
Esempio n. 2
0
        public void DeEnqueue()
        {
            try
            {
                //连接字符串
                string stq            = "Server=47.92.198.126;Database=ESHOP;user id=eshop;password=eshop123456;MultipleActiveResultSets=true";
                var    optionsBuilder = new DbContextOptionsBuilder <ESHOPContext>();
                optionsBuilder.UseSqlServer(stq);
                //using (var db = new ESHOPContext(optionsBuilder.Options))
                //{
                var             db          = new ESHOPContext(optionsBuilder.Options);
                TSeckillArticle articleInfo = null;  //存储如果存在修改需要查询库存
                bool            isdbDispose = false; //手动记录是否释放db上下文
                int             dequeueNum  = 0;
                while (true)
                {
                    if (isdbDispose)
                    {
                        db          = new ESHOPContext(optionsBuilder.Options);
                        isdbDispose = false;
                    }
                    ModelQueueParam data;
                    var             saved = false;//处理并发字段
                    lock (_locker)
                    {
                        //根据数据内容进行循环插入数据
                        if (GlobalParam.queue.TryDequeue(out data))
                        {
                        }
                    }
                    //存在下单人
                    if (data != null)
                    {
                        string userId           = data.userId;
                        string seckillArticleId = data.seckillArticleId;
                        //查询秒杀商品信息
                        articleInfo = db.TSeckillArticle.Where(u => u.Id == seckillArticleId).AsNoTracking().FirstOrDefault();
                        int articleStockNum = articleInfo?.ArticleStockNum ?? 0;
                        if (articleStockNum == 0)
                        {
                            //库存没有 等待信号
                            _wh.WaitOne();
                        }
                        else
                        {
                            //存在库存就进行消费库存
                            // articleInfo.ArticleStockNum -= 1;
                            dequeueNum++;
                            //同时添加订单信息
                            string   id      = Guid.NewGuid().ToString("N");
                            DateTime nowTime = DateTime.Now;
                            TOrder   order   = new TOrder();
                            order.Id              = id;
                            order.UserId          = userId;
                            order.ArticleId       = seckillArticleId;
                            order.OrderNum        = id;
                            order.OrderTotalPrice = 50;
                            order.AddTime         = nowTime;
                            order.UpdateTime      = nowTime;
                            order.PayTime         = nowTime;
                            order.DeliverTime     = nowTime;
                            order.FinishTime      = nowTime;
                            order.OrderStatus     = 3;
                            order.OrderPhone      = "12451554";
                            order.OrderAddress    = "地址地址地址";
                            order.OrderRemark     = "订单备注";
                            order.DelFlag         = 1;

                            //进行数据库真实操作
                            db.TOrder.Attach(order);
                            db.TOrder.Add(order);
                        }
                    }
                    else
                    {
                        //是否处理过数据
                        if (articleInfo != null)
                        {
                            articleInfo.ArticleStockNum -= dequeueNum;
                            //db.Entry(articleInfo).State = EntityState.Modified;
                            db.TSeckillArticle.Update(articleInfo);
                            //处理并发
                            while (!saved)
                            {
                                try
                                {
                                    db.SaveChanges();
                                    saved       = true;
                                    articleInfo = null;
                                    isdbDispose = true;
                                    dequeueNum  = 0;
                                }
                                catch (DbUpdateConcurrencyException ex)
                                {
                                    foreach (var entry in ex.Entries)
                                    {
                                        if (entry.Entity is TSeckillArticle)
                                        {
                                            var proposedValues = entry.CurrentValues;       //当前需要写入数据库的值
                                            var databaseValues = entry.GetDatabaseValues(); //数据库值
                                            entry.OriginalValues.SetValues(databaseValues);
                                        }
                                    }
                                }
                            }
                        }
                        //库存没有 等待信号
                        _wh.WaitOne();
                    }
                }
                //}
            }
            catch (Exception ex)
            {
            }
        }