2

schangxiang@126.com

2024-08-23 9ef76a4a6f0cb9b9d24ae9faf3d1edac9afbc0fa

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
using iWare_SCADA_BusinessLogical.BLL;
using iWare_SCADA_BusinessLogical.Utils;
using iWare_SCADA_Model;
using iWare_SCADA_Model.MiddleModel;
using log4net;
using System;
using System.Collections.Generic;
using System.Data.Entity.Core.Common.CommandTrees;
using System.Data.Entity.Validation;
using System.Data.SqlTypes;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Web.UI.WebControls;
using System.Windows.Forms;
 
namespace iWare_SCADA_BusinessLogical
{
    /// <summary>
    /// 定时删除数据
    /// </summary>
    public class DeleteDataHandler : DataCaptureHandler
    {
        public static readonly DeleteDataHandler Instance = new DeleteDataHandler();
 
        public static readonly LogType logType = LogType.DeleteData;
 
        public DeleteDataHandler()
        {
        }
 
        public override string WorkingProcedure
        {
            get { return _dataCaptureConfig.WorkingProcedure; }
        }
 
        public override string DataCapturePointCode
        {
            get { return _dataCaptureConfig.DataCapturePointCode; }
        }
        public override string DataCapturePointCname
        {
            get { return _dataCaptureConfig.DataCapturePointCname; }
        }
 
 
        public override void RefreshDataList(List<DataCaptureConfig> dataCaptureConfig)
        {
        }
 
        public override void DataCaptureStart()
        {
            while (true)
            {
                try
                {
                    try
                    {
                        LogTextHelper.BatchDeleteLog();
                        Log4NetHelper.WriteInfoLog(logType, $"定时删除日志数据成功：");
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(logType, $"定时删除日志数据异常：", ex);
                    }
 
 
                    //处理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)
                {
                    Log4NetHelper.WriteErrorLog(logType, $"定时删除数据异常：", ex);
                }
                finally
                {
                }
            }
        }
 
    }
}