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("重置库存失败");
}
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)
{
}
}
