From e9269528ae01bc4572b68148b9c801b51f23b669 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 9月 2025 10:41:45 +0800
Subject: [PATCH] 查询优化
---
wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs b/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
index 5e68e73..6f95caf 100644
--- a/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
@@ -29,7 +29,7 @@
//Log4NetHelper.WriteInfoLog(_logType, "娴嬭瘯鍟婂晩鍟婂晩 ");
using (dbmodel mod = new dbmodel())
{
- List<Wms_outInStockRecord_V2_Mes> sendMesData = mod.Wms_outInStockRecord_V2_Mes.Where(x => x.isSendToMes == 0).ToList();
+ List<Wms_outInStockRecord_V2_Mes> sendMesData = mod.Wms_outInStockRecord_V2_Mes.Where(x => x.isSendToMes == 0).OrderBy(x => x.ID).ToList();
if (sendMesData.Count > 0)
{
@@ -76,15 +76,19 @@
SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},宸叉帹閫佺粨鏉燂紝杩斿洖:{JsonConvert.SerializeObject(ret)}";
if (ret.ErrorCode == 0)
{
- itemTask.isSendToMes = 1;
+ itemTask.isSendToMes = 1;//鎺ㄩ�佹垚鍔�
}
else
{
- itemTask.isSendToMes = 0;
+ itemTask.isSendToMes = 0;//鎺ㄩ�佸け璐�
}
itemTask.SendToMesTime = DateTime.Now;
itemTask.MesRet = ret.ErrorMsg;
itemTask.SendToMesCount = (itemTask.SendToMesCount ?? 0) + 1;
+ if (itemTask.isSendToMes == 0 && itemTask.SendToMesCount > 100)
+ {
+ itemTask.isSendToMes = 3;//琛ㄧず寮哄埗鎺ㄩ�佹垚鍔�
+ }
mod.SaveChanges();
}
--
Gitblit v1.9.3