From f92f06042907f92f75f6e4cf68a43854d2de8027 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 23 12月 2024 17:08:47 +0800
Subject: [PATCH] 22
---
CC/iWareSql/DataAccess/ClearDataHandler.cs | 61 +++++++++++++++++++++---------
1 files changed, 43 insertions(+), 18 deletions(-)
diff --git a/CC/iWareSql/DataAccess/ClearDataHandler.cs b/CC/iWareSql/DataAccess/ClearDataHandler.cs
index bfb5ff8..6b7e989 100644
--- a/CC/iWareSql/DataAccess/ClearDataHandler.cs
+++ b/CC/iWareSql/DataAccess/ClearDataHandler.cs
@@ -19,21 +19,21 @@
public class ClearDataHandler
{
/// <summary>
- /// 绉婚櫎XX澶╁墠鐨� 寮傚父琛� 鏁版嵁
+ /// 绉婚櫎XX澶╁墠鐨� wms_record_print 鏁版嵁
/// </summary>
/// <param name="edm"></param>
- public static void Delete_Base_SysExceptionInfo(int days)
+ public static void Delete_wms_record_print(int days)
{
try
{
- using (DbModel edm = new DbModel())
+ using (WmsDBModel.WmsDBModel edm = new WmsDBModel.WmsDBModel())
{
var queryTime = DateTime.Now.AddDays(-days);
- var removeList = edm.Base_SysExceptionInfo.Where(x => x.createTime <= queryTime).ToList();
+ var removeList = edm.wms_record_print.Where(x => x.CreateTime <= queryTime).ToList();
if (removeList != null && removeList.Count > 0)
{
- edm.Base_SysExceptionInfo.RemoveRange(removeList);
+ edm.wms_record_print.RemoveRange(removeList);
}
edm.SaveChanges();
}
@@ -71,21 +71,21 @@
}
/// <summary>
- /// 绉婚櫎XX澶╁墠鐨� 璇锋眰鏃ュ織 鏁版嵁
+ /// 绉婚櫎XX澶╁墠鐨� mes_push_papercut 鏁版嵁
/// </summary>
/// <param name="edm"></param>
- public static void Delete_Task_RequestLog(int days)
+ public static void Delete_mes_push_papercut(int days)
{
try
{
- using (DbModel edm = new DbModel())
+ using (WmsDBModel.WmsDBModel edm = new WmsDBModel.WmsDBModel())
{
var queryTime = DateTime.Now.AddDays(-days);
- var removeList = edm.Task_RequestLog.Where(x => x.CreateTime <= queryTime).ToList();
+ var removeList = edm.mes_push_papercut.Where(x => x.CreateTime <= queryTime).ToList();
if (removeList != null && removeList.Count > 0)
{
- edm.Task_RequestLog.RemoveRange(removeList);
+ edm.mes_push_papercut.RemoveRange(removeList);
}
edm.SaveChanges();
}
@@ -179,23 +179,48 @@
/// 绉婚櫎XX澶╁墠鐨� 璁惧浠诲姟琛� 鏁版嵁
/// </summary>
/// <param name="edm"></param>
- public static void Delete_Task_Part(int days)
+ public static void Delete_mes_push_packagecode(int days)
{
try
{
- using (DbModel edm = new DbModel())
+ using (WmsDBModel.WmsDBModel edm = new WmsDBModel.WmsDBModel())
{
var queryTime = DateTime.Now.AddDays(-days);
- var queryTaskState1 = (int)DeviceTaskStatusEnum.宸插彇娑�;
- var queryTaskState2 = (int)DeviceTaskStatusEnum.宸插畬鎴�;
-
- var removeList = edm.Task_Part.Where(x => x.CreateTime <= queryTime
- && (x.TaskState == queryTaskState1 || x.TaskState == queryTaskState2)
+
+ var removeList = edm.mes_push_packagecode.Where(x => x.CreateTime <= queryTime
).ToList();
if (removeList != null && removeList.Count > 0)
{
- edm.Task_Part.RemoveRange(removeList);
+ edm.mes_push_packagecode.RemoveRange(removeList);
+ }
+ edm.SaveChanges();
+ }
+ }
+ catch (Exception ex)
+ {
+ Log4NetHelper.WriteErrorLog(LogType.DataProcess_BZ21_FinishTask, "绉婚櫎XX澶╁墠鐨� 璇锋眰鏃ュ織 鏁版嵁 鍑虹幇寮傚父", ex);
+ }
+ }
+
+ /// <summary>
+ /// 绉婚櫎XX澶╁墠鐨� 璁惧浠诲姟琛� 鏁版嵁
+ /// </summary>
+ /// <param name="edm"></param>
+ public static void Delete_wms_rbline_task(int days)
+ {
+ try
+ {
+ using (WmsDBModel.WmsDBModel edm = new WmsDBModel.WmsDBModel())
+ {
+ var queryTime = DateTime.Now.AddDays(-days);
+
+
+ var removeList = edm.wms_rbline_task.Where(x => x.CreateTime <= queryTime
+ ).ToList();
+ if (removeList != null && removeList.Count > 0)
+ {
+ edm.wms_rbline_task.RemoveRange(removeList);
}
edm.SaveChanges();
}
--
Gitblit v1.9.3