From 7ca0d964d2df19bf56e8a8a96f34f26a139b078d Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期五, 27 二月 2026 15:23:57 +0800
Subject: [PATCH] 增加异常工艺参数预警通知
---
DingDingMsg_EarlyWarning/Program.cs | 16 ++++++++++------
1 files changed, 10 insertions(+), 6 deletions(-)
diff --git a/DingDingMsg_EarlyWarning/Program.cs b/DingDingMsg_EarlyWarning/Program.cs
index b3795c9..44302e6 100644
--- a/DingDingMsg_EarlyWarning/Program.cs
+++ b/DingDingMsg_EarlyWarning/Program.cs
@@ -28,7 +28,7 @@
// 璁板綍涓婃鎵ц鏂板畾鏃朵换鍔＄殑鏃堕棿
while (true)
{
- //鏌ユ壘璁惧淇濆吇棰勮
+ #region 鏌ユ壘璁惧淇濆吇棰勮
string sql = "SELECT a.HInterID,b.HEntryID,c.HEquipFileNo 璁惧缂栫爜, c.HName 璁惧鍚嶇О,d.HName 璁惧閮ㄩ棬 FROM Sb_EquipMaintainPlanBillMain a " +
"INNER JOIN Sb_EquipMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID " +
"LEFT JOIN Gy_EquipFileBillMain c ON a.HEquipID = c.HInterID " +
@@ -89,7 +89,9 @@
}
}
- //鏌ユ壘妯″叿淇濆吇棰勮
+ #endregion
+
+ #region 鏌ユ壘妯″叿淇濆吇棰勮
string newsql = "SELECT a.HInterID,b.HEntryID,c.HMouldNo 妯″叿缂栫爜, c.HName 妯″叿鍚嶇О,B.HErrBeginQty,HSendFlag,d.HName 妯″叿閮ㄩ棬 FROM Sc_MouldMaintainPlanBillMain a " +
"INNER JOIN Sc_MouldMaintainPlanBillSub_Plan b ON a.HInterID = b.HInterID " +
"LEFT JOIN Gy_MouldFileMain c ON a.HMouldID = c.HInterID " +
@@ -149,8 +151,9 @@
}
}
}
+ #endregion
-
+ #region 璁惧閲囬泦寮傚父
DBHelper.CustomWriteLog("璁惧閲囬泦寮傚父寮�濮�!", DateTime.Now.ToString("yyyy-MM-dd"));
//璁惧閲囬泦寮傚父鏃讹紙寮�宸ュ悗锛岃澶囨寔缁�10鍒嗛挓鏈噰闆嗭級锛岃繘琛屾秷鎭璀�
//鑾峰彇 涓洪璀� 骞朵笖鐘舵�佷负寮�宸ョ殑 璁惧 鍜屽伐鑹哄弬鏁�
@@ -219,7 +222,7 @@
// 鏍规嵁 瑙掕壊 鍘绘煡璇㈤渶瑕佸彂娑堟伅鐨勯拤閽夊彿
string sql2 = "select a.HDingDingUserID 閽夐拤id,a.Czymc 鎺ユ敹浜� from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserId" +
- " left join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '鍙傛暟棰勮'";
+ " left join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '璁惧鏈噰闆嗗埌鍙傛暟棰勮'";
dts = oCN.RunProcReturn(sql2, "Gy_Czygl");
for (int j = 0; j < dts.Tables[0].Rows.Count; j++)
{
@@ -259,8 +262,9 @@
}
DBHelper.CustomWriteLog("璁惧閲囬泦寮傚父缁撴潫!", DateTime.Now.ToString("yyyy-MM-dd"));
+ #endregion
-
+ #region
DBHelper.CustomWriteLog("spc寮傚父鍙戞秷鎭�!", DateTime.Now.ToString("yyyy-MM-dd"));
//spc 寮傚父琛ㄦ湁鏈彂娑堟伅鐨勬暟鎹椂 涓�灏忔椂 鍙戦�佷竴娆℃秷鎭�
//鑾峰彇 寮傚父琛� 鏈夋湭鍙戞秷鎭殑鏁版嵁
@@ -333,7 +337,7 @@
}
}
DBHelper.CustomWriteLog("spc寮傚父鍙戞伅缁撴潫!", DateTime.Now.ToString("yyyy-MM-dd"));
-
+ #endregion
// 绛夊緟涓�鍒嗛挓
await Task.Delay(TimeSpan.FromMinutes(1));
}
--
Gitblit v1.9.1