From 2b05362eba2f989b7857349cc9a3a1c12f8181b6 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 26 9月 2025 11:35:50 +0800
Subject: [PATCH] 222
---
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs | 92 +++++++++++----------------------------------
1 files changed, 23 insertions(+), 69 deletions(-)
diff --git a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs
index 1ad9bbf..ffb1568 100644
--- a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs
+++ b/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(4);
+
+ 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, $"瀹氭椂鍒犻櫎琛ㄦ暟鎹垚鍔燂細");
}
@@ -82,74 +103,7 @@
}
- //澶勭悊OP60鐨勬暟鎹�
- try
- {
- LogTextHelper.BatchDeleteLog(@"Q:\Measuring_Data_df_Copy", 20);
- Log4NetHelper.WriteInfoLog(logType, $"澶勭悊OP60鐨勬暟鎹�(Q:\\Measuring_Data_df_Copy)-瀹氭椂鍒犻櫎鏁版嵁鎴愬姛锛�");
- }
- catch (Exception ex)
- {
- Log4NetHelper.WriteErrorLog(logType, $"澶勭悊OP60鐨勬暟鎹�(Q:\\Measuring_Data_df_Copy)-瀹氭椂鍒犻櫎鏁版嵁寮傚父锛�", ex);
- }
- try
- {
- LogTextHelper.BatchDeleteLog(@"Q:\Measuring_Data_dfq", 20);
- Log4NetHelper.WriteInfoLog(logType, $"澶勭悊OP60鐨勬暟鎹�(Q:\\Measuring_Data_dfq)-瀹氭椂鍒犻櫎鏁版嵁");
- }
- catch (Exception ex)
- {
- Log4NetHelper.WriteErrorLog(logType, $"澶勭悊OP60鐨勬暟鎹�(Q:\\Measuring_Data_dfq)-瀹氭椂鍒犻櫎鏁版嵁寮傚父锛�", ex);
- }
-
-
- //澶勭悊OP80鐨勬暟鎹�
- try
- {
- LogTextHelper.BatchDeleteLog(@"X:\CA4GC20TD_COPY", 20);
- Log4NetHelper.WriteInfoLog(logType, $"澶勭悊OP80鐨勬暟鎹�(X:\\CA4GC20TD_COPY)-瀹氭椂鍒犻櫎鏁版嵁锛�");
- }
- catch (Exception ex)
- {
- Log4NetHelper.WriteErrorLog(logType, $"澶勭悊OP80鐨勬暟鎹�(X:\\CA4GC20TD_COPY)-瀹氭椂鍒犻櫎鏁版嵁寮傚父锛�", ex);
- }
-
- try
- {
- LogTextHelper.BatchDeleteLog(@"X:\CA4GC20TD_Error", 60);
- Log4NetHelper.WriteInfoLog(logType, $"澶勭悊OP80鐨勬暟鎹�(X:\\CA4GC20TD_Error)-瀹氭椂鍒犻櫎鏁版嵁锛�");
- }
- catch (Exception ex)
- {
- Log4NetHelper.WriteErrorLog(logType, $"澶勭悊OP80鐨勬暟鎹�(X:\\CA4GC20TD_Error)-瀹氭椂鍒犻櫎鏁版嵁寮傚父锛�", ex);
- }
-
- try
- {
- LogTextHelper.BatchDeleteLog(@"X:\CA4GC20TD_NoNum", 60);
- Log4NetHelper.WriteInfoLog(logType, $"澶勭悊OP80鐨勬暟鎹�(X:\\CA4GC20TD_NoNum)-瀹氭椂鍒犻櫎鏁版嵁");
- }
- catch (Exception ex)
- {
- Log4NetHelper.WriteErrorLog(logType, $"澶勭悊OP80鐨勬暟鎹�(X:\\CA4GC20TD_NoNum)-瀹氭椂鍒犻櫎鏁版嵁寮傚父锛�", ex);
- }
-
-
-
- try
- {
- //澶勭悊OP20鐨勬暟鎹�
- LogTextHelper.BatchDeleteLog(@"W:\", 20);
- Log4NetHelper.WriteInfoLog(logType, $"澶勭悊OP20鐨勬暟鎹�-瀹氭椂鍒犻櫎鏁版嵁锛�");
- }
- catch (Exception ex)
- {
- Log4NetHelper.WriteErrorLog(logType, $"澶勭悊OP20鐨勬暟鎹�-瀹氭椂鍒犻櫎鏁版嵁寮傚父锛�", ex);
- }
-
-
- Thread.Sleep(8 * 60 * 60 * 1000);//姣忓ぉ8灏忔椂涓�娆�
}
catch (Exception ex)
{
--
Gitblit v1.9.3