一汽连杆项目
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
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();


@@ -73,6 +84,16 @@


                        ClearDataHandler.Delete_WorkPieceInfoLog(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, $"定时删除表数据成功：");


                    }


@@ -177,7 +198,7 @@


                    }






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




                }


                catch (Exception ex)


                {