增加快捷折叠

zrg

2025-05-08 57757113e2aa3023649df1c8fdc9dc2753c88a97

增加快捷折叠

 DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2

Binary files differ

 DingDingMsg/.vs/DingDingMsg/v16/.suo

Binary files differ

 DingDingMsg_EarlyWarning/Program.cs

@@ -28,7 +28,7 @@
            // 记录上次执行新定时任务的时间
            while (true)
            {
                //查找设备保养预警
                #region 查找设备保养预警
                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 " +
@@ -89,7 +89,9 @@
                    }
                }

                //查找模具保养预警
                #endregion

                #region 查找模具保养预警
                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 " +
@@ -149,8 +151,9 @@
                        }
                    }
                }
                #endregion


                #region 设备采集异常
                DBHelper.CustomWriteLog("设备采集异常开始!", DateTime.Now.ToString("yyyy-MM-dd"));
                //设备采集异常时（开工后，设备持续10分钟未采集），进行消息预警
                //获取 为预警  并且状态为开工的 设备 和工艺参数
@@ -259,8 +262,9 @@
                }
                DBHelper.CustomWriteLog("设备采集异常结束!", DateTime.Now.ToString("yyyy-MM-dd"));

                #endregion


                #region
                DBHelper.CustomWriteLog("spc异常发消息!", DateTime.Now.ToString("yyyy-MM-dd"));
                //spc 异常表有未发消息的数据时 一小时 发送一次消息
                //获取 异常表 有未发消息的数据
@@ -333,7 +337,7 @@
                    }
                }
                DBHelper.CustomWriteLog("spc异常发息结束!", DateTime.Now.ToString("yyyy-MM-dd"));

                #endregion
                // 等待一分钟
                await Task.Delay(TimeSpan.FromMinutes(1));
            }