注释优化

yangle

2025-04-11 7847684c9fe5f934f4a7806f641a5370fcc9f218

注释优化

 DingDingMsg_EarlyWarning/Program.cs

@@ -173,11 +173,12 @@

                        if ((DateTime.Now - DateTime.Parse(HRecordDate)).TotalMinutes >= int.Parse(HWarningDate))
                        {

                            //根据 设备+工艺参数+采集时间 查询工艺参数临时表的数据
                            DataSet ds = oCN.RunProcReturn("exec h_p_Sb_EquipMentTechParam_Temp '" + HEquipFileNo + "', '" + HParameterName + "', '" + HCollectionDate + "'", "h_p_Sb_EquipMentTechParam_Temp");
                            if (ds.Tables[0].Rows.Count > 0)
                            {
                                string HMaxCreateTime = ds.Tables[0].Rows[0]["HCreateTime"].ToString();
                                // 判断 当前时间-参数的创建时间 是否大于预警时间  如果 大于预警时间则需要钉钉发消息
                                if ((DateTime.Now - DateTime.Parse(HMaxCreateTime)).TotalMinutes >= int.Parse(HWarningDate))
                                {
                                    if (HEquipFileName != HEquipFileNo)
@@ -216,6 +217,7 @@
                    {
                        HRemark += "没有采集到数据!";

                        // 根据 角色 去查询需要发消息的钉钉号
                        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 = '参数预警'";
                        dts = oCN.RunProcReturn(sql2, "Gy_Czygl");
@@ -269,7 +271,7 @@
                {
                    HRecordDate_spc = DateTime.Now.ToString();
                }

                //根据30分钟时间 去发送消息
                if (dt.Tables[0].Rows.Count > 0 && (DateTime.Now - DateTime.Parse(HRecordDate_spc)).TotalMinutes >= 30)
                {

@@ -285,6 +287,7 @@

                        if (HRemark.Length > 0)
                        {
                            // 根据 角色 去查询需要发消息的钉钉号
                            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 = 'SPC数据异常预警'";
                            dts = oCN.RunProcReturn(sql2, "Gy_Czygl");