using iWareCommon.Utils;
|
using System;
|
using System.Linq;
|
|
namespace iWareSql.DataAccess
|
{
|
public class ClearDataHandler
|
{
|
/// <summary>
|
/// 移除XX天前的 wms_stock_snapshot_details 数据
|
/// </summary>
|
/// <param name="edm"></param>
|
public static void Delete_wms_stock_snapshot_details(int days)
|
{
|
try
|
{
|
using (MyDbContext.MyDbContext edm = new MyDbContext.MyDbContext())
|
{
|
var queryTime = DateTime.Now.AddDays(-days);
|
|
var removeList = edm.wms_stock_snapshot_details.Where(x => x.CreateTime <= queryTime).ToList();
|
if (removeList != null && removeList.Count > 0)
|
{
|
edm.wms_stock_snapshot_details.RemoveRange(removeList);
|
}
|
edm.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Sys_DeleteLog, "移除XX天前的 wms_stock_snapshot_details 数据 出现异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 移除XX天前的 wms_stock_snapshot 数据
|
/// </summary>
|
/// <param name="edm"></param>
|
public static void Delete_wms_stock_snapshot(int days)
|
{
|
try
|
{
|
using (MyDbContext.MyDbContext edm = new MyDbContext.MyDbContext())
|
{
|
var queryTime = DateTime.Now.AddDays(-days);
|
|
var removeList = edm.wms_stock_snapshot.Where(x => x.CreateTime <= queryTime).ToList();
|
if (removeList != null && removeList.Count > 0)
|
{
|
edm.wms_stock_snapshot.RemoveRange(removeList);
|
}
|
edm.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Sys_DeleteLog, "移除XX天前的 wms_stock_snapshot 数据 出现异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 移除XX天前的 wms_stock_snapshot_group 数据
|
/// </summary>
|
/// <param name="edm"></param>
|
public static void Delete_wms_stock_snapshot_group(int days)
|
{
|
try
|
{
|
using (MyDbContext.MyDbContext edm = new MyDbContext.MyDbContext())
|
{
|
var queryTime = DateTime.Now.AddDays(-days);
|
|
var removeList = edm.wms_stock_snapshot_group.Where(x => x.CreateTime <= queryTime).ToList();
|
if (removeList != null && removeList.Count > 0)
|
{
|
edm.wms_stock_snapshot_group.RemoveRange(removeList);
|
}
|
edm.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Sys_DeleteLog, "移除XX天前的 wms_stock_snapshot_group 数据 出现异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 移除XX天前的 wms_stock_quan_out 数据
|
/// </summary>
|
/// <param name="edm"></param>
|
public static void Delete_wms_stock_quan_out(int days)
|
{
|
try
|
{
|
using (MyDbContext.MyDbContext edm = new MyDbContext.MyDbContext())
|
{
|
var queryTime = DateTime.Now.AddDays(-days);
|
|
var removeList = edm.wms_stock_quan_out.Where(x => x.CreateTime <= queryTime).ToList();
|
if (removeList != null && removeList.Count > 0)
|
{
|
edm.wms_stock_quan_out.RemoveRange(removeList);
|
}
|
edm.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Sys_DeleteLog, "移除XX天前的 wms_stock_quan_out 数据 出现异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 移除XX天前的 wms_stock_quan_zero 数据
|
/// </summary>
|
/// <param name="edm"></param>
|
public static void Delete_wms_stock_quan_zero(int days)
|
{
|
try
|
{
|
using (MyDbContext.MyDbContext edm = new MyDbContext.MyDbContext())
|
{
|
var queryTime = DateTime.Now.AddDays(-days);
|
|
var removeList = edm.wms_stock_quan_zero.Where(x => x.CreateTime <= queryTime).ToList();
|
if (removeList != null && removeList.Count > 0)
|
{
|
edm.wms_stock_quan_zero.RemoveRange(removeList);
|
}
|
edm.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Sys_DeleteLog, "移除XX天前的 wms_stock_quan_zero 数据 出现异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 移除XX天前的 请求日志 数据
|
/// </summary>
|
/// <param name="edm"></param>
|
public static void Delete_HttpRequestRecord(int days)
|
{
|
try
|
{
|
using (MyDbContext.MyDbContext edm = new MyDbContext.MyDbContext())
|
{
|
var queryTime = DateTime.Now.AddDays(-days);
|
|
var removeList = edm.SysLogOp.Where(x => x.CreateTime <= queryTime).ToList();
|
if (removeList != null && removeList.Count > 0)
|
{
|
edm.SysLogOp.RemoveRange(removeList);
|
}
|
edm.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Sys_DeleteLog, "移除XX天前的 请求日志 数据 出现异常", ex);
|
}
|
}
|
|
///// <summary>
|
///// 移除XX天前的 请求日志 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_Task_RequestLog(int days)
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// var queryTime = DateTime.Now.AddDays(-days);
|
|
// var removeList = edm.Task_RequestLog.Where(x => x.CreateTime <= queryTime).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.Task_RequestLog.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 请求日志 数据 出现异常", ex);
|
// }
|
//}
|
|
///// <summary>
|
///// 移除XX天前的 请求日志 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_HttpRequestRecord(int days)
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// var queryTime = DateTime.Now.AddDays(-days);
|
|
// var removeList = edm.HttpRequestRecord.Where(x => x.CreateTime <= queryTime).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.HttpRequestRecord.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 请求日志 数据 出现异常", ex);
|
// }
|
//}
|
|
|
///// <summary>
|
///// 移除XX天前的 MES_BTJReceiveReq 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_MES_BTJReceiveReq(int days)
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// var queryTime = DateTime.Now.AddDays(-days);
|
|
// var removeList = edm.MES_BTJReceiveReq.Where(x => x.CreateTime <= queryTime).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.MES_BTJReceiveReq.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 MES_BTJReceiveReq 数据 出现异常", ex);
|
// }
|
//}
|
///// <summary>
|
///// 移除XX天前的 MES_OnLineReq 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_MES_OnLineReq(int days)
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// var queryTime = DateTime.Now.AddDays(-days);
|
|
// var removeList = edm.MES_OnLineReq.Where(x => x.CreateTime <= queryTime).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.MES_OnLineReq.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 MES_OnLineReq 数据 出现异常", ex);
|
// }
|
//}
|
|
|
///// <summary>
|
///// 移除XX天前的 设备任务表 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_Task_Part(int days)
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// 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)
|
// ).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.Task_Part.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 请求日志 数据 出现异常", ex);
|
// }
|
//}
|
|
|
///// <summary>
|
///// 移除XX天前的 Device_Warning 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_Device_Warning(int days)
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// var queryTime = DateTime.Now.AddDays(-days);
|
|
// var removeList = edm.Device_Warning.Where(x => x.CreateTime <= queryTime).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.Device_Warning.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 设备报警 数据 出现异常", ex);
|
// }
|
//}
|
|
///// <summary>
|
///// 移除XX天前的 AGV报警 数据
|
///// </summary>
|
///// <param name="edm"></param>
|
//public static void Delete_Les_InOutStockRecord()
|
//{
|
// try
|
// {
|
// using (DbModel edm = new DbModel())
|
// {
|
// var queryTime = DateTime.Now.AddDays(-30);
|
|
// var removeList = edm.Les_InOutStockRecord.Where(x => x.CreateTime <= queryTime).ToList();
|
// if (removeList != null && removeList.Count > 0)
|
// {
|
// edm.Les_InOutStockRecord.RemoveRange(removeList);
|
// }
|
// edm.SaveChanges();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.SdaService, "移除XX天前的 出入库记录 数据 出现异常", ex);
|
// }
|
//}
|
|
|
|
}
|
}
|
