From 202ea649c08c1cb71161e72e31c23a0777b57191 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期三, 19 二月 2025 18:33:28 +0800
Subject: [PATCH] 1
---
DingDingMsg/DingDingMsg/Program.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/DingDingMsg/DingDingMsg/Program.cs b/DingDingMsg/DingDingMsg/Program.cs
index c6c0c89..cff7e9f 100644
--- a/DingDingMsg/DingDingMsg/Program.cs
+++ b/DingDingMsg/DingDingMsg/Program.cs
@@ -117,9 +117,9 @@
}
//鏌ヨ鍑鸿鍙戜俊鎭殑寮傚父鍙傛暟
- string newSql = @"SELECT 杞﹂棿, STUFF(( SELECT '; ' + 璁惧缂栫爜 + ' - ' + 宸ヨ壓鍙傛暟鍚嶇О + ' - 鏁伴噰鍊�: ' + CAST(鏁伴噰鍊� AS VARCHAR(10)) + ' - 涓婇檺鍊�: ' + CAST(涓婇檺鍊� AS VARCHAR(10)) + ' - 涓嬮檺鍊�: ' + CAST(涓嬮檺鍊� AS VARCHAR(10))
- FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS InnerTable WHERE InnerTable.杞﹂棿 = OuterTable.杞﹂棿 AND 鍙戠幇寮傚父鏃堕棿 >= DATEADD(minute, -1, GETDATE())
- FOR XML PATH('') ), 1, 2, '') AS 鍐呭 FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS OuterTable GROUP BY 杞﹂棿 ";
+ string newSql = @"SELECT 宸ュ簭鍚嶇О, STUFF(( SELECT '; ' + 璁惧缂栫爜 + ' - ' + 宸ヨ壓鍙傛暟鍚嶇О + ' - 鏁伴噰鍊�: ' + CAST(鏁伴噰鍊� AS VARCHAR(10)) + ' - 涓婇檺鍊�: ' + CAST(涓婇檺鍊� AS VARCHAR(10)) + ' - 涓嬮檺鍊�: ' + CAST(涓嬮檺鍊� AS VARCHAR(10))
+ FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS InnerTable WHERE InnerTable.宸ュ簭鍚嶇О = OuterTable.宸ュ簭鍚嶇О AND 鍙戠幇寮傚父鏃堕棿 >= DATEADD(minute, -1, GETDATE())
+ FOR XML PATH('') ), 1, 2, '') AS 鍐呭 FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS OuterTable GROUP BY 宸ュ簭鍚嶇О ";
DBHelper.CustomWriteLog("鏌ヨ鍑鸿鍙戜俊鎭殑寮傚父鍙傛暟"+newSql, DateTime.Now.ToString("yyyy-MM-dd"));
dt1 = oCN.RunProcReturn(newSql, "h_v_Sb_EquipMentCollectionTechParam_ERRList");
string HContext = ""; string HDeptName = "";
@@ -127,7 +127,7 @@
{
DBHelper.CustomWriteLog("寮傚父鍐呭鏁伴噺 "+ dt1.Tables[0].Rows.Count, DateTime.Now.ToString("yyyy-MM-dd"));
HContext = dt1.Tables[0].Rows[j]["鍐呭"].ToString();
- HDeptName = dt1.Tables[0].Rows[j]["杞﹂棿"].ToString();
+ HDeptName = dt1.Tables[0].Rows[j]["宸ュ簭鍚嶇О"].ToString();
DBHelper.CustomWriteLog("寮傚父鍐呭鍊� "+ HContext, DateTime.Now.ToString("yyyy-MM-dd"));
DBHelper.CustomWriteLog("寮傚父杞﹂棿鍊� " + HDeptName, DateTime.Now.ToString("yyyy-MM-dd"));
if (!string.IsNullOrEmpty(HContext) && HContext.ToLower() != "null")
--
Gitblit v1.9.1