From c34f8f93417c5a0125f9c55ba3d347411995ac13 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周二, 10 9月 2024 15:05:32 +0800
Subject: [PATCH] 1
---
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs | 110 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 109 insertions(+), 1 deletions(-)
diff --git a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs
index ea64e1d..7e2f90e 100644
--- a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs
+++ b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs
@@ -66,7 +66,7 @@
/// <summary>
- /// 绉婚櫎XX澶╁墠鐨� WorkPieceLog 鏁版嵁
+ /// 绉婚櫎XX澶╁墠鐨� AccessInterfaceLogForRequest 鏁版嵁
/// </summary>
/// <param name="edm"></param>
public static void Delete_AccessInterfaceLogForRequest(int days)
@@ -92,5 +92,113 @@
}
+
+ /// <summary>
+ /// 绉婚櫎XX澶╁墠鐨� QualityDataInfoLog 鏁版嵁
+ /// </summary>
+ /// <param name="edm"></param>
+ public static void Delete_QualityDataInfoLog(int days)
+ {
+ try
+ {
+ using (DbModel edm = new DbModel())
+ {
+ var queryTime = DateTime.Now.AddDays(-days);
+
+ var removeList = edm.QualityDataInfoLog.Where(x => x.CreatedTime <= queryTime).ToList();
+ if (removeList != null && removeList.Count > 0)
+ {
+ edm.QualityDataInfoLog.RemoveRange(removeList);
+ }
+ edm.SaveChanges();
+ }
+ }
+ catch (Exception ex)
+ {
+ Log4NetHelper.WriteErrorLog(LogType.DeleteData, "绉婚櫎XX澶╁墠鐨� QualityDataInfoLog 鏁版嵁 鍑虹幇寮傚父", ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 绉婚櫎XX澶╁墠鐨� sys_log_op 鏁版嵁
+ /// </summary>
+ /// <param name="edm"></param>
+ public static void Delete_sys_log_op(int days)
+ {
+ try
+ {
+ using (DbModel edm = new DbModel())
+ {
+ var queryTime = DateTime.Now.AddDays(-days);
+
+ var removeList = edm.sys_log_op.Where(x => x.OpTime <= queryTime).ToList();
+ if (removeList != null && removeList.Count > 0)
+ {
+ edm.sys_log_op.RemoveRange(removeList);
+ }
+ edm.SaveChanges();
+ }
+ }
+ catch (Exception ex)
+ {
+ Log4NetHelper.WriteErrorLog(LogType.DeleteData, "绉婚櫎XX澶╁墠鐨� sys_log_op 鏁版嵁 鍑虹幇寮傚父", ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 绉婚櫎XX澶╁墠鐨� sys_log_ex 鏁版嵁
+ /// </summary>
+ /// <param name="edm"></param>
+ public static void Delete_sys_log_ex(int days)
+ {
+ try
+ {
+ using (DbModel edm = new DbModel())
+ {
+ var queryTime = DateTime.Now.AddDays(-days);
+
+ var removeList = edm.sys_log_ex.Where(x => x.ExceptionTime <= queryTime).ToList();
+ if (removeList != null && removeList.Count > 0)
+ {
+ edm.sys_log_ex.RemoveRange(removeList);
+ }
+ edm.SaveChanges();
+ }
+ }
+ catch (Exception ex)
+ {
+ Log4NetHelper.WriteErrorLog(LogType.DeleteData, "绉婚櫎XX澶╁墠鐨� sys_log_ex 鏁版嵁 鍑虹幇寮傚父", ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 绉婚櫎XX澶╁墠鐨� EquipmentWorkingLog 鏁版嵁
+ /// </summary>
+ /// <param name="edm"></param>
+ public static void Delete_EquipmentWorkingLog(int days)
+ {
+ try
+ {
+ using (DbModel edm = new DbModel())
+ {
+ var queryTime = DateTime.Now.AddDays(-days);
+
+ var removeList = edm.EquipmentWorkingLog.Where(x => x.CreatedTime <= queryTime).ToList();
+ if (removeList != null && removeList.Count > 0)
+ {
+ edm.EquipmentWorkingLog.RemoveRange(removeList);
+ }
+ edm.SaveChanges();
+ }
+ }
+ catch (Exception ex)
+ {
+ Log4NetHelper.WriteErrorLog(LogType.DeleteData, "绉婚櫎XX澶╁墠鐨� EquipmentWorkingLog 鏁版嵁 鍑虹幇寮傚父", ex);
+ }
+ }
+
}
}
\ No newline at end of file
--
Gitblit v1.9.3