日志优化

schangxiang@126.com

2024-09-10 03de13b2a5357916a7b6ec2f3e8a9ff6ca2e3970

 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();
@@ -70,9 +81,19 @@

                    try
                    {
                        ClearDataHandler.Delete_WorkPieceInfoLog(-7);
                        ClearDataHandler.Delete_WorkPieceInfoLog(7);

                        ClearDataHandler.Delete_WorkPieceLog(-7);
                        ClearDataHandler.Delete_WorkPieceLog(7);

                        ClearDataHandler.Delete_AccessInterfaceLogForRequest(7);

                        ClearDataHandler.Delete_QualityDataInfoLog(7);

                        ClearDataHandler.Delete_sys_log_op(7);

                        ClearDataHandler.Delete_sys_log_ex(7);

                        ClearDataHandler.Delete_EquipmentWorkingLog(7);

                        Log4NetHelper.WriteInfoLog(logType, $"定时删除表数据成功：");
                    }
@@ -135,6 +156,34 @@
                        Log4NetHelper.WriteErrorLog(logType, $"处理OP80的数据(X:\\CA4GC20TD_NoNum)-定时删除数据异常：", ex);
                    }

                    //处理OP30的数据
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"U:\NutrunnerData\FO\SEQ_24", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP30的数据(U:\\NutrunnerData\\FO\\SEQ_24)-定时删除数据：");
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(logType, $"处理OP30的数据(U:\\NutrunnerData\\FO\\SEQ_24）-定时删除数据异常：", ex);
                    }
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"U:\NutrunnerData\FO\SEQ_04", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP30的数据(U:\\NutrunnerData\\FO\\SEQ_04)-定时删除数据：");
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(logType, $"处理OP30的数据(U:\\NutrunnerData\\FO\\SEQ_04）-定时删除数据异常：", ex);
                    }
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"Z:\kistler_crack", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP30的数据(Z:\\kistler_crack)-定时删除数据：");
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(logType, $"处理OP30的数据(Z:\\kistler_crack）-定时删除数据异常：", ex);
                    }


                    try
@@ -149,7 +198,7 @@
                    }


                    Thread.Sleep(8 * 60 * 60 * 1000);//每天8小时一次 

                }
                catch (Exception ex)
                {