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 | 53 ++++++++++++++++++++++++++---------------------------
1 files changed, 26 insertions(+), 27 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs b/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
index 00b7382..6f95caf 100644
--- a/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ThreadTask/mesDataTranfficForRealMes.cs
@@ -29,15 +29,16 @@
//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)
{
+ SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},瑕佹帹閫亄sendMesData.Count()}鏉�!";
foreach (var itemTask in sendMesData)
{
try
{
- ApiResponse<object> ret = null;
+ mesMsg ret = null;
//鑾峰彇淇℃伅鏄庣粏
var details = mod.Wms_outInStockRecord_Details_V2_Mes.Where(x => x.mainId == itemTask.ID).ToList();
@@ -46,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,
@@ -58,57 +60,54 @@
});
}
- if (Form1.isvirtual)
- {//妯℃嫙鐜
- ret = new ApiResponse<object>();
- ret.Success = true;
- ret.Message = "绯荤粺妯℃嫙瀹屾垚";
- }
- else
+
+ switch (itemTask.outInFlag)
{
- switch (itemTask.outInFlag)
- {
- case (int)OutInFlag.鍏ュ簱:
- ret = PushMesHandler.Mes_InStockSend(pushData, itemTask.ID.ToString(), _logType);
- break;
- case (int)OutInFlag.鍑哄簱:
- ret = PushMesHandler.Mes_OutStockSend(pushData, itemTask.ID.ToString(), _logType);
- break;
- default:
- break;
- }
+ case (int)OutInFlag.鍏ュ簱:
+ ret = PushMesHandler.Mes_InStockSend(pushData, _logType);
+ break;
+ case (int)OutInFlag.鍑哄簱:
+ ret = PushMesHandler.Mes_OutStockSend(pushData, _logType);
+ break;
+ default:
+ break;
}
- if (ret.Success)
+ 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.Message;
+ itemTask.MesRet = ret.ErrorMsg;
itemTask.SendToMesCount = (itemTask.SendToMesCount ?? 0) + 1;
+ if (itemTask.isSendToMes == 0 && itemTask.SendToMesCount > 100)
+ {
+ itemTask.isSendToMes = 3;//琛ㄧず寮哄埗鎺ㄩ�佹垚鍔�
+ }
mod.SaveChanges();
}
catch (Exception ex)
{
- SystemWarningMsg.msg_mesDataTranfficForRealMes = "鎺ㄩ�佺粰MES鏁版嵁寮傚父:" + JsonConvert.SerializeObject(ex);
+ SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},鎺ㄩ�佺粰MES鏁版嵁寮傚父:" + JsonConvert.SerializeObject(ex);
Log4NetHelper.WriteErrorLog(_logType, SystemWarningMsg.msg_mesDataTranfficForRealMes, ex);
}
}
}
else
{
- SystemWarningMsg.msg_mesDataTranfficForRealMes = "娌℃湁鏁版嵁瑕佹帹閫佺粰MES!";
+ SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},娌℃湁鏁版嵁瑕佹帹閫佺粰MES!";
}
}
}
catch (Exception ex)
{
- SystemWarningMsg.msg_mesDataTranfficForRealMes = "鏁版嵁瑕佹帹閫佺粰MES鍑虹幇寮傚父:" + ex.Message;
+ SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},鏁版嵁瑕佹帹閫佺粰MES鍑虹幇寮傚父:" + ex.Message;
Log4NetHelper.WriteErrorLog(_logType, SystemWarningMsg.msg_mesDataTranfficForRealMes, ex);
}
}
--
Gitblit v1.9.3