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 | 23 +++++++++++++++--------
1 files changed, 15 insertions(+), 8 deletions(-)
diff --git a/DingDingMsg_EarlyWarning/Program.cs b/DingDingMsg_EarlyWarning/Program.cs
index 58a2195..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鍒嗛挓鏈噰闆嗭級锛岃繘琛屾秷鎭璀�
//鑾峰彇 涓洪璀� 骞朵笖鐘舵�佷负寮�宸ョ殑 璁惧 鍜屽伐鑹哄弬鏁�
@@ -173,11 +176,12 @@
if ((DateTime.Now - DateTime.Parse(HRecordDate)).TotalMinutes >= int.Parse(HWarningDate))
{
-
+ //鏍规嵁 璁惧+宸ヨ壓鍙傛暟+閲囬泦鏃堕棿 鏌ヨ宸ヨ壓鍙傛暟涓存椂琛ㄧ殑鏁版嵁
DataSet ds = oCN.RunProcReturn("exec h_p_Sb_EquipMentTechParam_Temp '" + HEquipFileNo + "', '" + HParameterName + "', '" + HCollectionDate + "'", "h_p_Sb_EquipMentTechParam_Temp");
if (ds.Tables[0].Rows.Count > 0)
{
string HMaxCreateTime = ds.Tables[0].Rows[0]["HCreateTime"].ToString();
+ // 鍒ゆ柇 褰撳墠鏃堕棿-鍙傛暟鐨勫垱寤烘椂闂� 鏄惁澶т簬棰勮鏃堕棿 濡傛灉 澶т簬棰勮鏃堕棿鍒欓渶瑕侀拤閽夊彂娑堟伅
if ((DateTime.Now - DateTime.Parse(HMaxCreateTime)).TotalMinutes >= int.Parse(HWarningDate))
{
if (HEquipFileName != HEquipFileNo)
@@ -216,8 +220,9 @@
{
HRemark += "娌℃湁閲囬泦鍒版暟鎹�!";
+ // 鏍规嵁 瑙掕壊 鍘绘煡璇㈤渶瑕佸彂娑堟伅鐨勯拤閽夊彿
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++)
{
@@ -257,8 +262,9 @@
}
DBHelper.CustomWriteLog("璁惧閲囬泦寮傚父缁撴潫!", DateTime.Now.ToString("yyyy-MM-dd"));
+ #endregion
-
+ #region
DBHelper.CustomWriteLog("spc寮傚父鍙戞秷鎭�!", DateTime.Now.ToString("yyyy-MM-dd"));
//spc 寮傚父琛ㄦ湁鏈彂娑堟伅鐨勬暟鎹椂 涓�灏忔椂 鍙戦�佷竴娆℃秷鎭�
//鑾峰彇 寮傚父琛� 鏈夋湭鍙戞秷鎭殑鏁版嵁
@@ -269,7 +275,7 @@
{
HRecordDate_spc = DateTime.Now.ToString();
}
-
+ //鏍规嵁30鍒嗛挓鏃堕棿 鍘诲彂閫佹秷鎭�
if (dt.Tables[0].Rows.Count > 0 && (DateTime.Now - DateTime.Parse(HRecordDate_spc)).TotalMinutes >= 30)
{
@@ -285,6 +291,7 @@
if (HRemark.Length > 0)
{
+ // 鏍规嵁 瑙掕壊 鍘绘煡璇㈤渶瑕佸彂娑堟伅鐨勯拤閽夊彿
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 = 'SPC鏁版嵁寮傚父棰勮'";
dts = oCN.RunProcReturn(sql2, "Gy_Czygl");
@@ -330,7 +337,7 @@
}
}
DBHelper.CustomWriteLog("spc寮傚父鍙戞伅缁撴潫!", DateTime.Now.ToString("yyyy-MM-dd"));
-
+ #endregion
// 绛夊緟涓�鍒嗛挓
await Task.Delay(TimeSpan.FromMinutes(1));
}
--
Gitblit v1.9.1