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 | 21 +++++++++++++--------
1 files changed, 13 insertions(+), 8 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs b/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
index 92f0d68..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)
{
@@ -38,7 +38,7 @@
{
try
{
- ApiResponse<object> ret = null;
+ mesMsg ret = null;
//鑾峰彇淇℃伅鏄庣粏
var details = mod.Wms_outInStockRecord_Details_V2_Mes.Where(x => x.mainId == itemTask.ID).ToList();
@@ -47,6 +47,7 @@
{
pushData.Add(new InboundStockInfoToMes()
{
+ identifier = de.ID.ToString(),
containerCode = itemTask.containerCode,
createTime = itemTask.CreateTime?.ToString("yyyy-MM-dd HH:mm:ss"),
materialCode = de.productCode,
@@ -63,27 +64,31 @@
switch (itemTask.outInFlag)
{
case (int)OutInFlag.鍏ュ簱:
- ret = PushMesHandler.Mes_InStockSend(pushData, itemTask.ID.ToString(), _logType);
+ ret = PushMesHandler.Mes_InStockSend(pushData, _logType);
break;
case (int)OutInFlag.鍑哄簱:
- ret = PushMesHandler.Mes_OutStockSend(pushData, itemTask.ID.ToString(), _logType);
+ ret = PushMesHandler.Mes_OutStockSend(pushData, _logType);
break;
default:
break;
}
SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},宸叉帹閫佺粨鏉燂紝杩斿洖:{JsonConvert.SerializeObject(ret)}";
- if (ret.Success)
+ if (ret.ErrorCode == 0)
{
- itemTask.isSendToMes = 1;
+ itemTask.isSendToMes = 1;//鎺ㄩ�佹垚鍔�
}
else
{
- itemTask.isSendToMes = 0;
+ itemTask.isSendToMes = 0;//鎺ㄩ�佸け璐�
}
itemTask.SendToMesTime = DateTime.Now;
- itemTask.MesRet = ret.Message;
+ 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