修改成可前端自动配置角色,进行发送预警

zrg

2024-11-14 ea9bc943bdf7c382f3dd609582e7518c6f9a5841

 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();