清除数据

schangxiang@126.com

2024-09-06 19c66ffe3a8d2a2e784ba54cefc6f2566135bafa

 DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/DataCaptureHandlerV2/DeleteDataHandler.cs

@@ -60,10 +60,27 @@
                    try
                    {
                        LogTextHelper.BatchDeleteLog();

                        Log4NetHelper.WriteInfoLog(logType, $"定时删除日志数据成功：");
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(logType, $"定时删除日志数据异常：", ex);
                    }

                    try
                    {
                        ClearDataHandler.Delete_WorkPieceInfoLog(7);

                        ClearDataHandler.Delete_WorkPieceLog(7);

                        ClearDataHandler.Delete_AccessInterfaceLogForRequest(7);

                        Log4NetHelper.WriteInfoLog(logType, $"定时删除表数据成功：");
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(logType, $"定时删除表数据成功：", ex);
                    }


@@ -71,6 +88,7 @@
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"Q:\Measuring_Data_df_Copy", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP60的数据(Q:\\Measuring_Data_df_Copy)-定时删除数据成功：");
                    }
                    catch (Exception ex)
                    {
@@ -80,6 +98,7 @@
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"Q:\Measuring_Data_dfq", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP60的数据(Q:\\Measuring_Data_dfq)-定时删除数据");
                    }
                    catch (Exception ex)
                    {
@@ -91,6 +110,7 @@
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"X:\CA4GC20TD_COPY", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP80的数据(X:\\CA4GC20TD_COPY)-定时删除数据：");
                    }
                    catch (Exception ex)
                    {
@@ -100,6 +120,7 @@
                    try
                    {
                        LogTextHelper.BatchDeleteLog(@"X:\CA4GC20TD_Error", 60);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP80的数据(X:\\CA4GC20TD_Error)-定时删除数据：");
                    }
                    catch (Exception ex)
                    {
@@ -109,18 +130,48 @@
                    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);
                    }

                    //处理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
                    {
                        //处理OP20的数据
                        LogTextHelper.BatchDeleteLog(@"W:\", 20);
                        Log4NetHelper.WriteInfoLog(logType, $"处理OP20的数据-定时删除数据：");
                    }
                    catch (Exception ex)
                    {