From 39adf5d31e5eb1ff9093c62c6b509d0e10633fe3 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周二, 10 9月 2024 18:12:22 +0800
Subject: [PATCH] 日志类型优化
---
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs | 136 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 136 insertions(+), 0 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 88bf30f..7e2f90e 100644
--- a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs
+++ b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/ClearDataHandler.cs
@@ -64,5 +64,141 @@
}
+
+ /// <summary>
+ /// 绉婚櫎XX澶╁墠鐨� AccessInterfaceLogForRequest 鏁版嵁
+ /// </summary>
+ /// <param name="edm"></param>
+ public static void Delete_AccessInterfaceLogForRequest(int days)
+ {
+ try
+ {
+ using (DbModel edm = new DbModel())
+ {
+ var queryTime = DateTime.Now.AddDays(-days);
+
+ var removeList = edm.AccessInterfaceLogForRequest.Where(x => x.CreatedTime <= queryTime).ToList();
+ if (removeList != null && removeList.Count > 0)
+ {
+ edm.AccessInterfaceLogForRequest.RemoveRange(removeList);
+ }
+ edm.SaveChanges();
+ }
+ }
+ catch (Exception ex)
+ {
+ Log4NetHelper.WriteErrorLog(LogType.DeleteData, "绉婚櫎XX澶╁墠鐨� AccessInterfaceLogForRequest 鏁版嵁 鍑虹幇寮傚父", ex);
+ }
+ }
+
+
+
+ /// <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