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());
            }
        }


    }
}