From ea9bc943bdf7c382f3dd609582e7518c6f9a5841 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 14 十一月 2024 09:20:06 +0800
Subject: [PATCH] 修改成可前端自动配置角色,进行发送预警
---
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-11-01.txt | 23 +++++
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-10-11.txt | 13 +++
DingDingMsg/.vs/DingDingMsg/v16/.suo | 0
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb | 0
DingDingMsg_EarlyWarning/Program.cs | 47 ++++++-----
DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2 | 0
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb | 0
DingDingMsg_EarlyWarning/DBHelper.cs | 14 +-
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb | 0
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb | 0
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb | 0
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-10-24.txt | 43 ++++++++++
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb | 0
DingDingMsg_EarlyWarning/Properties/PublishProfiles/FolderProfile1.pubxml.user | 2
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt | 2
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache | 0
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb | 0
DingDingMsg/DingDingMsg/Program.cs | 46 ++++++++---
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb | 0
DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user | 2
20 files changed, 150 insertions(+), 42 deletions(-)
diff --git a/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2 b/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2
index b341811..5c9bbd5 100644
--- a/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2
+++ b/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2
Binary files differ
diff --git a/DingDingMsg/.vs/DingDingMsg/v16/.suo b/DingDingMsg/.vs/DingDingMsg/v16/.suo
index e9da45c..610f1f9 100644
--- a/DingDingMsg/.vs/DingDingMsg/v16/.suo
+++ b/DingDingMsg/.vs/DingDingMsg/v16/.suo
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/Program.cs b/DingDingMsg/DingDingMsg/Program.cs
index 0a23638..6c4209a 100644
--- a/DingDingMsg/DingDingMsg/Program.cs
+++ b/DingDingMsg/DingDingMsg/Program.cs
@@ -20,7 +20,7 @@
//鏂帿灏�
string appKey = "dingkdddbhdcssk7jduw";
string appSecret = "iv07c-GLfJPnzfJaNAAOfJDl3Z-eODvDAhlInMZCZhGorkle5Evbaxx3ImylvdjQ";
- Console.WriteLine("绋嬪簭姝ｅ湪鎵ц,璇蜂笉瑕佸叧闂�!!!!");
+ Console.WriteLine("瀹夌伅绋嬪簭姝ｅ湪鎵ц,璇蜂笉瑕佸叧闂�!!!!");
// 璁板綍涓婃鎵ц鏂板畾鏃朵换鍔＄殑鏃堕棿
DateTime lastNewTaskExecution = DateTime.MinValue;
while (true)
@@ -77,41 +77,63 @@
}
//寮傚父宸ヨ壓鍙傛暟棰勮锛堟瘡 5 鍒嗛挓鎵ц涓�娆★級
- if ((DateTime.Now - lastNewTaskExecution).TotalMinutes >= 5)
+ DBHelper.CustomWriteLog("寮�濮嬭繘鍏ユ墽琛屽惊鐜�:", DateTime.Now.ToString("yyyy-MM-dd"));
+ if ((DateTime.Now - lastNewTaskExecution).TotalMinutes >= 4)
{
+ DBHelper.CustomWriteLog("宸茶繘鍏ユ墽琛屽惊鐜�:", DateTime.Now.ToString("yyyy-MM-dd"));
//鏌ヨ鍑鸿鏇存柊宸茬粡鍙戦�佺殑寮傚父鍙傛暟
- string Sql = "select HItemID from Sb_EquipMentCollectionTechParam_ERR where HCreateTime>=DATEADD(minute, - 1, GETDATE());";
- dt = oCN.RunProcReturn(Sql, "Sb_EquipMentCollectionTechParam_ERR");
+ string Sql = "select HItemID from Sb_EquipMentCollectionTechParam_ERR where HCreateTime>=DATEADD(minute, - 1, GETDATE()) AND HSendFlag = 0";
+ DBHelper.CustomWriteLog("鏌ヨ鍑哄紓甯哥殑鍙傛暟:"+Sql, DateTime.Now.ToString("yyyy-MM-dd"));
+ dt = oCN.RunProcReturn(Sql, "Sb_EquipMentCollectionTechParam_ERR");
+ if (dt != null && dt.Tables[0].Rows.Count > 0)
+ {
+ List<string> itemIds = new List<string>();
+ foreach (DataRow row in dt.Tables[0].Rows)
+ {
+ itemIds.Add(row["HItemID"].ToString());
+ }
+ DBHelper.CustomWriteLog("杩斿洖鐨勫紓甯稿弬鏁伴泦鍚堬細" + string.Join(", ", itemIds), DateTime.Now.ToString("yyyy-MM-dd"));
+ }
+ DBHelper.CustomWriteLog("瑕佽繘鍏ユ洿鏂扮殑璇彞", DateTime.Now.ToString("yyyy-MM-dd"));
if (dt.Tables[0].Rows.Count > 0)
{
+ DBHelper.CustomWriteLog("杩涘叆鏇存柊鐨勮鍙�", DateTime.Now.ToString("yyyy-MM-dd"));
//鏇存柊瑕佸彂閫佺殑鍗曞瓙
if (dt != null && dt.Tables != null && dt.Tables.Count > 0)
{
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
string ycSql = "update Sb_EquipMentCollectionTechParam_ERR set HSendFlag = 1 where HItemID = " + dt.Tables[0].Rows[i]["HItemID"].ToString();
- DBHelper.CustomWriteLog("閽夐拤寮傚父棰勮鏇存柊璇彞:" + ycSql, DateTime.Now.ToString("yyyy - MM - dd"));
+ DBHelper.CustomWriteLog("閽夐拤寮傚父棰勮鏇存柊璇彞:" + ycSql, DateTime.Now.ToString("yyyy-MM-dd"));
oCN.RunProc(ycSql);
}
}
else
{
// 鍙互鍦ㄨ繖閲屾坊鍔犻�傚綋鐨勫鐞嗭紝姣斿璁板綍鏃ュ織琛ㄦ槑娌℃湁鍙鐞嗙殑鏁版嵁琛�
- DBHelper.CustomWriteLog("娌℃湁鍙敤浜庡鐞嗙殑鏁版嵁琛�", DateTime.Now.ToString("yyyy - MM - dd"));
- }
+ DBHelper.CustomWriteLog("娌℃湁鏇存柊鐨勮鍙�", DateTime.Now.ToString("yyyy-MM-dd"));
+ }
//鏌ヨ鍑鸿鍙戜俊鎭殑寮傚父鍙傛暟
- string newSql = @"select STUFF((SELECT '; ' + 璁惧缂栫爜 + ' - ' + 宸ヨ壓鍙傛暟鍚嶇О + ' - 鏁伴噰鍊�: ' + CAST(鏁伴噰鍊� as VARCHAR(10)) + ' - 涓婇檺鍊�: ' + CAST(涓婇檺鍊� as VARCHAR(10)) + ' - 涓嬮檺鍊�: ' + CAST(涓嬮檺鍊� as VARCHAR(10))
- FROM h_v_Sb_EquipMentCollectionTechParam_ERRList WHERE 鍙戠幇寮傚父鏃堕棿 >= DATEADD(minute, -1, GETDATE()) FOR XML PATH('')), 1, 2, '') as 鍐呭";
+ //string newSql = @"select STUFF((SELECT '; ' + 璁惧缂栫爜 + ' - ' + 宸ヨ壓鍙傛暟鍚嶇О + ' - 鏁伴噰鍊�: ' + CAST(鏁伴噰鍊� as VARCHAR(10)) + ' - 涓婇檺鍊�: ' + CAST(涓婇檺鍊� as VARCHAR(10)) + ' - 涓嬮檺鍊�: ' + CAST(涓嬮檺鍊� as VARCHAR(10))
+ //FROM h_v_Sb_EquipMentCollectionTechParam_ERRList WHERE 鍙戠幇寮傚父鏃堕棿 >= DATEADD(minute, -1, GETDATE()) FOR XML PATH('')), 1, 2, '') as 鍐呭";
+ 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"));
dt = oCN.RunProcReturn(newSql, "h_v_Sb_EquipMentCollectionTechParam_ERRList");
- string HContext = "";
+ string HContext = ""; string HDeptName = "";
HContext = dt.Tables[0].Rows[0]["鍐呭"].ToString();
+ HDeptName= dt.Tables[0].Rows[0]["杞﹂棿"].ToString();
+ DBHelper.CustomWriteLog("鏌ヨ鍑鸿鍙戜俊鎭殑鍐呭" + HContext, DateTime.Now.ToString("yyyy-MM-dd"));
//鏌ヨ鍑鸿鍙戦�佺殑浜�
string newSql1 = @"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 = '"+ HDeptName + "宸ヨ壓寮傚父棰勮鎺ユ敹浜�'";
DBHelper.CustomWriteLog("鏌ヨ鍑鸿鍙戦�佺殑浜�:" + newSql1, DateTime.Now.ToString("yyyy-MM-dd"));
- dt = oCN.RunProcReturn(newSql1, "Gy_Czygl");
+ dt = oCN.RunProcReturn(newSql1, "Gy_Czygl");
+ DBHelper.CustomWriteLog("寮�濮嬭繘鍏ュ彂淇℃伅", DateTime.Now.ToString("yyyy-MM-dd"));
if (dt.Tables[0].Rows.Count > 0)
{
+ DBHelper.CustomWriteLog("杩涘叆鍙戜俊鎭�", DateTime.Now.ToString("yyyy-MM-dd"));
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
string HName = dt.Tables[0].Rows[i]["閽夐拤id"].ToString();
diff --git a/DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user b/DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user
index b62bce0..4b6e1da 100644
--- a/DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user
+++ b/DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user
@@ -4,6 +4,6 @@
-->
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
- <History>True|2024-09-23T10:16:07.9656797Z;</History>
+ <History>True|2024-10-20T02:01:37.4542558Z;True|2024-10-14T12:26:09.3008697+08:00;True|2024-10-11T17:14:32.1495789+08:00;True|2024-10-11T17:01:27.4785195+08:00;True|2024-10-11T16:54:48.1999562+08:00;True|2024-10-11T14:35:28.0629168+08:00;True|2024-09-23T18:16:07.9656797+08:00;</History>
</PropertyGroup>
</Project>
\ No newline at end of file
diff --git a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
index 5df509d..3be4c88 100644
--- a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
+++ b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-10-11.txt b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-10-11.txt
new file mode 100644
index 0000000..53dd05a
--- /dev/null
+++ b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-10-11.txt
@@ -0,0 +1,13 @@
+2024/10/11 17:12:41 寮�濮嬭繘鍏ユ墽琛屽惊鐜�:
+
+2024/10/11 17:12:47 宸茶繘鍏ユ墽琛屽惊鐜�:
+
+2024/10/11 17:12:50 鏌ヨ鍑哄紓甯哥殑鍙傛暟:select HItemID from Sb_EquipMentCollectionTechParam_ERR where HCreateTime>=DATEADD(minute, - 1, GETDATE()) AND HSendFlag = 0
+
+2024/10/11 17:13:47 寮�濮嬭繘鍏ユ墽琛屽惊鐜�:
+
+2024/10/11 17:13:48 宸茶繘鍏ユ墽琛屽惊鐜�:
+
+2024/10/11 17:13:48 鏌ヨ鍑哄紓甯哥殑鍙傛暟:select HItemID from Sb_EquipMentCollectionTechParam_ERR where HCreateTime>=DATEADD(minute, - 1, GETDATE()) AND HSendFlag = 0
+
+2024/10/11 17:13:49 瑕佽繘鍏ユ洿鏂扮殑璇彞
diff --git a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
index 31232f3..f216892 100644
--- a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
+++ b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
index 5df509d..3be4c88 100644
--- a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
+++ b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
index 31232f3..f216892 100644
--- a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
+++ b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
Binary files differ
diff --git a/DingDingMsg_EarlyWarning/DBHelper.cs b/DingDingMsg_EarlyWarning/DBHelper.cs
index daae192..f962770 100644
--- a/DingDingMsg_EarlyWarning/DBHelper.cs
+++ b/DingDingMsg_EarlyWarning/DBHelper.cs
@@ -40,15 +40,15 @@
}
public DBHelper()
{
- //sServer = "47.96.97.237,15127";
- //sDataBase = "HX_LMESsys";
- //sUser = "HX_USER";
- //sPassword = "lc@841022";
- ////鏂帿灏�
- sServer = "30.10.7.6";
- sDataBase = "HX_LMESsys_test";
+ sServer = "47.96.97.237,15127";
+ sDataBase = "HX_LMESsys";
sUser = "HX_USER";
sPassword = "lc@841022";
+ ////鏂帿灏�
+ //sServer = "30.10.7.6";
+ //sDataBase = "HX_LMESsys_test";
+ //sUser = "HX_USER";
+ //sPassword = "lc@841022";
}
private bool CnOpen()//OPEN鏁版嵁搴撹繛鎺�
diff --git a/DingDingMsg_EarlyWarning/Program.cs b/DingDingMsg_EarlyWarning/Program.cs
index b11be21..0d62411 100644
--- a/DingDingMsg_EarlyWarning/Program.cs
+++ b/DingDingMsg_EarlyWarning/Program.cs
@@ -15,20 +15,23 @@
static async Task Main(string[] args)
{
//鏈湴
- //string appKey = "dingrsrzhdyn3mlaof95";
- //string appSecret = "RAqH6YtZnPLCpDbuqfaYQkKkVtVdS0wqfC8I26X6qiS-8eoCJCNrzx3fubGND4Sq";
+ string appKey = "dingrsrzhdyn3mlaof95";
+ string appSecret = "RAqH6YtZnPLCpDbuqfaYQkKkVtVdS0wqfC8I26X6qiS-8eoCJCNrzx3fubGND4Sq";
//鏂帿灏�
- string appKey = "dingkdddbhdcssk7jduw";
- string appSecret = "iv07c-GLfJPnzfJaNAAOfJDl3Z-eODvDAhlInMZCZhGorkle5Evbaxx3ImylvdjQ";
- Console.WriteLine("绋嬪簭姝ｅ湪鎵ц,璇蜂笉瑕佸叧闂�!!!!");
+ //string appKey = "dingkdddbhdcssk7jduw";
+ //string appSecret = "iv07c-GLfJPnzfJaNAAOfJDl3Z-eODvDAhlInMZCZhGorkle5Evbaxx3ImylvdjQ";
+ Console.WriteLine("绋嬪簭2姝ｅ湪鎵ц,璇蜂笉瑕佸叧闂�!!!!");
+ string HDeptName = "";
// 璁板綍涓婃鎵ц鏂板畾鏃朵换鍔＄殑鏃堕棿
while (true)
{
//鏌ユ壘璁惧淇濆吇棰勮
- string sql = "SELECT a.HInterID,b.HEntryID,c.HEquipFileNo 璁惧缂栫爜, c.HName 璁惧鍚嶇О FROM Sb_EquipMaintainPlanBillMain a " +
+ 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 " +
- "WHERE CAST(CONVERT(datetime, b.HErrBeginTime, 120) AS DATE) = CAST(GETDATE() AS DATE) and HSendFlag = '0'";
+ "LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID " +
+ " WHERE CONVERT(date, b.HErrBeginTime, 120) = CONVERT(date, GETDATE(), 120) and HSendFlag = '0'";
+ DBHelper.CustomWriteLog("鏌ヨ璁惧淇濆吇璁″垝:" + sql, DateTime.Now.ToString("yyyy-MM-dd"));
dt = oCN.RunProcReturn(sql, "Sb_EquipMaintainPlanBillMain");
//璁惧淇濆吇棰勮鑷姩鍙戜俊鎭�
if (dt.Tables[0].Rows.Count > 0)
@@ -37,14 +40,15 @@
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
- HContext = "璁惧缂栫爜涓�:"+dt.Tables[0].Rows[i]["璁惧缂栫爜"].ToString()+ ",璁惧鍚嶇О涓�:"+dt.Tables[0].Rows[i]["璁惧鍚嶇О"].ToString()+",宸插埌淇濆吇棰勮鏃ユ湡,闇�灏藉揩杩涜淇濆吇";
+ HContext = "璁惧缂栫爜涓�:" + dt.Tables[0].Rows[i]["璁惧缂栫爜"].ToString() + ",璁惧鍚嶇О涓�:" + dt.Tables[0].Rows[i]["璁惧鍚嶇О"].ToString() + ",宸插埌淇濆吇棰勮鏃ユ湡,闇�灏藉揩杩涜淇濆吇";
//鏇存柊璁惧淇濆吇璁″垝棰勮 瀛愯〃
- string sql1 = "update Sb_EquipMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID="+ dt.Tables[0].Rows[i]["HInterID"].ToString() + " and HEntryID=" + dt.Tables[0].Rows[i]["HEntryID"].ToString()+""; ;
+ string sql1 = "update Sb_EquipMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=" + dt.Tables[0].Rows[i]["HInterID"].ToString() + " and HEntryID=" + dt.Tables[0].Rows[i]["HEntryID"].ToString() + ""; ;
oCN.RunProc(sql1);
DBHelper.CustomWriteLog("璁惧淇濆吇璁″垝棰勮:" + sql1 + " 鏇存柊瀛愯〃璇彞:" + sql1, DateTime.Now.ToString("yyyy-MM-dd"));
-
+ HDeptName = dt.Tables[0].Rows[i]["璁惧閮ㄩ棬"].ToString();
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 = '" + HDeptName + "璁惧淇濆吇璁″垝棰勮鎺ユ敹浜�'";
+ DBHelper.CustomWriteLog("璁惧淇濆吇璁″垝棰勮鎺ユ敹浜�:" + sql2, DateTime.Now.ToString("yyyy-MM-dd"));
dts = oCN.RunProcReturn(sql2, "Gy_Czygl");
for (int j = 0; j < dts.Tables[0].Rows.Count; j++)
{
@@ -70,7 +74,7 @@
response = await msg.SendTextMessage(accessToken, agentId, userIdList, deptIdList, toAllUser, message);
ResponseData responseData = JsonConvert.DeserializeObject<ResponseData>(response);
if (responseData.errcode == 0)
- {
+ {
DBHelper.CustomWriteLog("閽夐拤鍙戦�佷俊鎭垚鍔�!", DateTime.Now.ToString("yyyy-MM-dd"));
}
else
@@ -78,15 +82,17 @@
Console.WriteLine(responseData.errcode);
DBHelper.CustomWriteLog("閽夐拤杩斿洖淇℃伅:" + response, DateTime.Now.ToString("yyyy-MM-dd"));
}
- }
+ }
}
}
//鏌ユ壘妯″叿淇濆吇棰勮
- string newsql = "SELECT a.HInterID,b.HEntryID,c.HMouldNo 妯″叿缂栫爜, c.HName 妯″叿鍚嶇О,B.HErrBeginQty,HSendFlag FROM Sc_MouldMaintainPlanBillMain a " +
+ 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 " +
- "WHERE b.HErrBeginQty >= (select sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'";
+ "LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID " +
+ " WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'";
+ DBHelper.CustomWriteLog("鏌ヨ妯″叿淇濆吇璁″垝:"+newsql, DateTime.Now.ToString("yyyy-MM-dd"));
dt = oCN.RunProcReturn(newsql, "Sb_EquipMaintainPlanBillMain");
//妯″叿淇濆吇棰勮鑷姩鍙戜俊鎭�
if (dt.Tables[0].Rows.Count > 0)
@@ -95,14 +101,15 @@
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
- HContext = "妯″叿缂栫爜涓�:" + dt.Tables[0].Rows[i]["妯″叿缂栫爜"].ToString() + ",妯″叿鍚嶇О涓�:" + dt.Tables[0].Rows[i]["妯″叿鍚嶇О"].ToString() + ",宸插埌淇濆吇棰勮鏃ユ湡,闇�灏藉揩杩涜淇濆吇";
+ HContext = "妯″叿缂栫爜涓�:" + dt.Tables[0].Rows[i]["妯″叿缂栫爜"].ToString() + ",妯″叿鍚嶇О涓�:" + dt.Tables[0].Rows[i]["妯″叿鍚嶇О"].ToString() + ",宸插埌淇濆吇棰勮娆℃暟,闇�灏藉揩杩涜淇濆吇";
//鏇存柊妯″叿淇濆吇璁″垝棰勮 瀛愯〃
string sql1 = "update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=" + dt.Tables[0].Rows[i]["HInterID"].ToString() + " and HEntryID=" + dt.Tables[0].Rows[i]["HEntryID"].ToString() + ""; ;
oCN.RunProc(sql1);
DBHelper.CustomWriteLog("妯″叿淇濆吇璁″垝棰勮:" + sql1 + " 鏇存柊瀛愯〃璇彞:" + sql1, DateTime.Now.ToString("yyyy-MM-dd"));
-
+ HDeptName = dt.Tables[0].Rows[i]["妯″叿閮ㄩ棬"].ToString();
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 = '妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�'";
+ DBHelper.CustomWriteLog("妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�:" + sql2, DateTime.Now.ToString("yyyy-MM-dd"));
dts = oCN.RunProcReturn(sql2, "Gy_Czygl");
for (int j = 0; j < dts.Tables[0].Rows.Count; j++)
{
@@ -116,9 +123,9 @@
string accessToken = responseJson["accessToken"].ToString();
//璋冪敤鏂规硶鍙戦�佹秷鎭�
- //string agentId = "3118119317";//閽夐拤鍚庡彴寤虹珛鐨勫皬绋嬪簭id
+ string agentId = "3118119317";//閽夐拤鍚庡彴寤虹珛鐨勫皬绋嬪簭id
//鏂帿灏�
- string agentId = "3151454458";//閽夐拤鍚庡彴寤虹珛鐨勫皬绋嬪簭id
+ //string agentId = "3151454458";//閽夐拤鍚庡彴寤虹珛鐨勫皬绋嬪簭id
string userIdList = HName;//閽夐拤浜哄憳鐨刬d
string deptIdList = "0"; // 绌哄瓧绗︿覆琛ㄧず涓嶆寚瀹氶儴闂�
string toAllUser = "false";
diff --git a/DingDingMsg_EarlyWarning/Properties/PublishProfiles/FolderProfile1.pubxml.user b/DingDingMsg_EarlyWarning/Properties/PublishProfiles/FolderProfile1.pubxml.user
index 8ecef3a..54e36f7 100644
--- a/DingDingMsg_EarlyWarning/Properties/PublishProfiles/FolderProfile1.pubxml.user
+++ b/DingDingMsg_EarlyWarning/Properties/PublishProfiles/FolderProfile1.pubxml.user
@@ -4,6 +4,6 @@
-->
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
- <History>True|2024-09-23T10:14:50.8540058Z;</History>
+ <History>True|2024-10-20T02:24:51.4832669Z;True|2024-10-14T12:09:10.5729183+08:00;True|2024-10-14T12:08:44.6720595+08:00;True|2024-10-14T12:06:19.5939470+08:00;True|2024-10-14T12:05:38.2281865+08:00;True|2024-10-14T12:01:34.1788799+08:00;True|2024-10-14T11:55:04.4773797+08:00;True|2024-10-14T11:48:05.5386326+08:00;True|2024-09-26T15:53:45.6428349+08:00;True|2024-09-23T18:14:50.8540058+08:00;</History>
</PropertyGroup>
</Project>
\ No newline at end of file
diff --git a/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
index 95a378b..819cb31 100644
--- a/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
+++ b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
Binary files differ
diff --git a/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-10-24.txt b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-10-24.txt
new file mode 100644
index 0000000..710c0a5
--- /dev/null
+++ b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-10-24.txt
@@ -0,0 +1,43 @@
+2024/10/24 15:48:17 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:48:33 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:49:34 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:50:34 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:51:34 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:51:50 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:52:04 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:54:39 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:54:54 妯″叿淇濆吇璁″垝棰勮:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 鏇存柊瀛愯〃璇彞:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
+
+2024/10/24 15:54:54 妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�:select a.HDingDingUserID 閽夐拤id,a.Czymc 鎺ユ敹浜� from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserIdleft join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�'
+
+2024/10/24 15:54:57 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:55:26 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:56:44 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:57:47 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:58:52 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 15:59:05 妯″叿淇濆吇璁″垝棰勮:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 鏇存柊瀛愯〃璇彞:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
+
+2024/10/24 15:59:45 妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�:select a.HDingDingUserID 閽夐拤id,a.Czymc 鎺ユ敹浜� from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserIdleft join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�'
+
+2024/10/24 16:01:01 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/10/24 16:01:09 妯″叿淇濆吇璁″垝棰勮:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 鏇存柊瀛愯〃璇彞:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
+
+2024/10/24 16:01:11 妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�: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 = '妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�'
+
+2024/10/24 16:01:24 閽夐拤鍙戦�佷俊鎭垚鍔�!
+
+2024/10/24 16:01:42 閽夐拤鍙戦�佷俊鎭垚鍔�!
diff --git a/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-11-01.txt b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-11-01.txt
new file mode 100644
index 0000000..8825bce
--- /dev/null
+++ b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/Vlog/2024-11-01.txt
@@ -0,0 +1,23 @@
+2024/11/1 13:41:17 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/11/1 13:41:18 妯″叿淇濆吇璁″垝棰勮:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 鏇存柊瀛愯〃璇彞:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
+
+2024/11/1 13:41:18 妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�: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 = '妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�'
+
+2024/11/1 13:41:20 閽夐拤鍙戦�佷俊鎭垚鍔�!
+
+2024/11/1 13:41:20 閽夐拤鍙戦�佷俊鎭垚鍔�!
+
+2024/11/1 13:42:20 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/11/1 13:43:20 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/11/1 13:44:20 鏌ヨ妯″叿淇濆吇璁″垝: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 LEFT JOIN Gy_Department d ON a.HDeptID = d.HItemID WHERE b.HErrBeginQty <= (select b.HUseNowQty+sum(HUseLife) from Sc_MouldLifeUseBillSub WHERE HMaterID = a.HMouldID) and b.HSendFlag = '0'
+
+2024/11/1 13:44:20 妯″叿淇濆吇璁″垝棰勮:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1 鏇存柊瀛愯〃璇彞:update Sc_MouldMaintainPlanBillSub_Plan set HSendFlag='1' where HInterID=34 and HEntryID=1
+
+2024/11/1 13:44:20 妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�: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 = '妯″叿淇濆吇璁″垝棰勮鎺ユ敹浜�'
+
+2024/11/1 13:44:21 閽夐拤鍙戦�佷俊鎭垚鍔�!
+
+2024/11/1 13:44:21 閽夐拤鍙戦�佷俊鎭垚鍔�!
diff --git a/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb
index 6bef430..1e2473b 100644
--- a/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb
+++ b/DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb
Binary files differ
diff --git a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
index f5e894a..a323781 100644
--- a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
+++ b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
Binary files differ
diff --git a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt
index a60c0a0..ea89b54 100644
--- a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt
+++ b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt
@@ -11,7 +11,6 @@
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\bin\Debug\netcoreapp3.1\runtimes\win-x86\native\sni.dll
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\bin\Debug\netcoreapp3.1\runtimes\unix\lib\netcoreapp2.1\System.Data.SqlClient.dll
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\bin\Debug\netcoreapp3.1\runtimes\win\lib\netcoreapp2.1\System.Data.SqlClient.dll
-D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.AssemblyInfoInputs.cache
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.AssemblyInfo.cs
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.csproj.CoreCompileInputs.cache
@@ -19,3 +18,4 @@
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.dll
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.pdb
D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.genruntimeconfig.cache
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
diff --git a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
index 95a378b..819cb31 100644
--- a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
+++ b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
Binary files differ
diff --git a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb
index 6bef430..1e2473b 100644
--- a/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb
+++ b/DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg_EarlyWarning.pdb
Binary files differ
--
Gitblit v1.9.1