优化查询

schangxiang@126.com

2025-09-04 6f6f118881771a70feb186061ebb4ccd03a47e68

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
 
 
using System;
using yunneiWCS.ORM;
using System.Linq;
 
namespace yunneiWCS
{
    public class ClearDataHandler
    {
 
        /// <summary>
        /// 移除XX天前的 Delete_serialNumberHistory  数据
        /// </summary>
        /// <param name="edm"></param>
        public static void Delete_serialNumberHistory(int days)
        {
            try
            {
                using (dbmodel edm = new dbmodel())
                {
                    var queryTime = DateTime.Now.AddDays(-days);
 
                    var removeList = edm.serialNumberHistory.Where(x => x.createTime <= queryTime).ToList();
                    if (removeList != null && removeList.Count > 0)
                    {
                        edm.serialNumberHistory.RemoveRange(removeList);
                    }
                    edm.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                WZ.Useful.Commons.LogTextHelper.WriteLine("ClearDataHandler", "Delete_serialNumberHistory", ex.ToString());
            }
        }
 
        /// <summary>
        /// 移除XX天前的 Delete_System_TianYongEmptyBackLog  数据
        /// </summary>
        /// <param name="edm"></param>
        public static void Delete_System_TianYongEmptyBackLog(int days)
        {
            try
            {
                using (dbmodel edm = new dbmodel())
                {
                    var queryTime = DateTime.Now.AddDays(-days);
 
                    var removeList = edm.System_TianYongEmptyBackLog.Where(x => x.CreateTime <= queryTime).ToList();
                    if (removeList != null && removeList.Count > 0)
                    {
                        edm.System_TianYongEmptyBackLog.RemoveRange(removeList);
                    }
                    edm.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                WZ.Useful.Commons.LogTextHelper.WriteLine("ClearDataHandler", "Delete_System_TianYongEmptyBackLog", ex.ToString());
            }
        }
 
        /// <summary>
        /// 移除XX天前的 taskRecord  数据
        /// </summary>
        /// <param name="edm"></param>
        public static void Delete_taskRecord(int days)
        {
            try
            {
                using (dbmodel edm = new dbmodel())
                {
                    var queryTime = DateTime.Now.AddDays(-days);
 
                    var removeList = edm.taskRecord.Where(x => x.createTime <= queryTime).ToList();
                    if (removeList != null && removeList.Count > 0)
                    {
                        edm.taskRecord.RemoveRange(removeList);
                    }
                    edm.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                WZ.Useful.Commons.LogTextHelper.WriteLine("ClearDataHandler", "Delete_taskRecord", ex.ToString());
            }
        }
 
 
        /// <summary>
        /// 移除XX天前的 推送给天永的日志  数据
        /// </summary>
        /// <param name="edm"></param>
        public static void Delete_System_TianYongLog(int days)
        {
            try
            {
                using (dbmodel edm = new dbmodel())
                {
                    var queryTime = DateTime.Now.AddDays(-days);
 
                    var removeList = edm.System_TianYongLog.Where(x => x.CreateTime <= queryTime).ToList();
                    if (removeList != null && removeList.Count > 0)
                    {
                        edm.System_TianYongLog.RemoveRange(removeList);
                    }
                    edm.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                WZ.Useful.Commons.LogTextHelper.WriteLine("ClearDataHandler", "Delete_Base_SysExceptionInfo", ex.ToString());
            }
        }
 
        /// <summary>
        /// 移除XX天前的 清理库存日志  数据
        /// </summary>
        /// <param name="edm"></param>
        public static void Delete_StockClearLog(int days)
        {
            try
            {
                using (dbmodel edm = new dbmodel())
                {
                    var queryTime = DateTime.Now.AddDays(-days);
 
                    var removeList = edm.StockClearLog.Where(x => x.CreateTime <= queryTime).ToList();
                    if (removeList != null && removeList.Count > 0)
                    {
                        edm.StockClearLog.RemoveRange(removeList);
                    }
                    edm.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                WZ.Useful.Commons.LogTextHelper.WriteLine("ClearDataHandler", "Delete_StockClearLog", ex.ToString());
            }
        }
 
 
    }
}