修复 要发送的信息为空时自动跳过,不进行发送

zrg

2024-11-26 3ae7b33dfca55b3e9a745aea8d8e8f3cea67ae87

 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;
                }