DingDingMsg/.vs/DingDingMsg/v16/.suoBinary files differ
DingDingMsg/DingDingMsg/Program.cs
@@ -12,6 +12,8 @@ //异常反馈单,异常工艺参数预警 发送钉钉消息 static DBHelper oCN = new DBHelper(); static DataSet dt = new DataSet(); static DataSet dt1 = new DataSet(); static DataSet dt2 = new DataSet(); static async Task Main(string[] args) { //本地 @@ -114,16 +116,22 @@ 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 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"); dt1 = oCN.RunProcReturn(newSql, "h_v_Sb_EquipMentCollectionTechParam_ERRList"); string HContext = ""; string HDeptName = ""; HContext = dt.Tables[0].Rows[0]["内容"].ToString(); HDeptName= dt.Tables[0].Rows[0]["车间"].ToString(); for (int j = 0; j < dt1.Tables[0].Rows.Count; j++) { 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(); 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") { 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 @@ -170,10 +178,15 @@ } } DBHelper.CustomWriteLog("钉钉异常预警发送成功出来", DateTime.Now.ToString("yyyy-MM-dd")); } DBHelper.CustomWriteLog("钉钉异常预警发送成功出来1", DateTime.Now.ToString("yyyy-MM-dd")); } DBHelper.CustomWriteLog("钉钉异常预警发送成功出来2", DateTime.Now.ToString("yyyy-MM-dd")); } DBHelper.CustomWriteLog("钉钉异常预警发送成功出来3", DateTime.Now.ToString("yyyy-MM-dd")); } DBHelper.CustomWriteLog("钉钉异常预警发送成功出来4", DateTime.Now.ToString("yyyy-MM-dd")); lastNewTaskExecution = DateTime.Now; } 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-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> <History>True|2024-11-26T08:37:35.6037283Z;True|2024-11-26T16:19:56.1650507+08:00;True|2024-11-26T16:18:43.9351401+08:00;True|2024-11-26T15:59:33.8234090+08:00;True|2024-11-26T15:52:30.0966988+08:00;True|2024-11-26T15:45:06.3092696+08:00;True|2024-11-25T17:40:06.4971070+08:00;True|2024-11-25T15:49:10.2661307+08:00;True|2024-10-20T10:01:37.4542558+08:00;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> DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdbBinary files differ
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdbBinary files differ
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cacheBinary files differ
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt
@@ -39,4 +39,3 @@ D:\智云迈思\DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.dll D:\智云迈思\DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.pdb D:\智云迈思\DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.genruntimeconfig.cache D:\智云迈思\DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.csproj.AssemblyReference.cache DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdbBinary files differ
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdbBinary files differ
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdbBinary files differ
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cacheBinary files differ
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt
@@ -18,4 +18,3 @@ 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 DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdbBinary files differ