schangxiang@126.com
2024-09-10 efa7310c7b32e6296d637332251dc4519c4c5aea
执行删除计划
已修改1个文件
15 ■■■■■ 文件已修改
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs 15 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs
@@ -6,6 +6,7 @@
using System;
using System.Collections.Generic;
using System.Data.Entity.Core.Common.CommandTrees;
using System.Data.Entity.Core.Common.CommandTrees.ExpressionBuilder;
using System.Data.Entity.Validation;
using System.Data.SqlTypes;
using System.Diagnostics;
@@ -57,6 +58,16 @@
            {
                try
                {
                    //Thread.Sleep(8 * 60 * 60 * 1000);//每天8小时一次
                    Thread.Sleep(20 * 60 * 1000);//20分钟执行一次
                    //每天凌晨1、3、5、6执行一次
                    var hour = DateTime.Now.Hour;
                    if (!(hour == 1 || hour == 3 || hour == 5 || hour == 6))
                    {
                        continue;
                    }
                    try
                    {
                        LogTextHelper.BatchDeleteLog();
@@ -81,6 +92,8 @@
                        ClearDataHandler.Delete_sys_log_op(7);
                        ClearDataHandler.Delete_sys_log_ex(7);
                        ClearDataHandler.Delete_EquipmentWorkingLog(7);
                        Log4NetHelper.WriteInfoLog(logType, $"定时删除表数据成功:");
                    }
@@ -185,7 +198,7 @@
                    }
                    Thread.Sleep(8 * 60 * 60 * 1000);//每天8小时一次
                }
                catch (Exception ex)
                {