简单实现log记录保存到文本和数据库

简单保存记录到txt，sqlite数据库，以及console监控记录

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Data.SQLite;
using System.IO;

namespace NlogFrame
{
    public enum  LogType
    {
        Trace,
        Consl,
        Debug,
        Info,
        Warn,
        Error,
        Fatal
    }
    public class Log
    {
        /// <summary>
        /// 最大缓存数
        /// </summary>
        [Browsable(true)]
        public static int MaxTempListCnt { get; set; } = 300;
        [Browsable(true)]
        public static LogType MinLevel { get; set; } = 0;
        [Browsable(true)]
        public static bool DebugEnable { get; set; } = true;
        [Browsable(true)]
        public static bool TraceEnable { get; set; } = true;
        [Browsable(true)]
        public static bool WarnEnable { get; set; } = true;
        static bool _ConsoleEnable = false;
        static TextWriter originalOut = null;
        [Browsable(true)]
        public static bool ConsoleEnable
        {
            get { return _ConsoleEnable; }
            set
            {
                _ConsoleEnable = value;
                if (value == true)
                {

                    if (originalOut == null)
                    {
                        originalOut = Console.Out;
                    }
                    Console.SetOut(logConsole);

                }
                else
                {
                    if (originalOut != null)
                    {
                        Console.SetOut(originalOut);
                        originalOut = null;
                    }
                }
            }
        }
        [Browsable(true)]
        public string Name { get; set; } = "";

        static LogConsole logConsole = new LogConsole();

        public static List<LogInfo> TempLogInfoList => _TempLogInfoList;
        static List<LogInfo> _TempLogInfoList;
        public Log(string name)
        {
            Name = name;
        }


        public void Error(string msg)
        {
            if ((int)LogType.Error >= (int)MinLevel)
            {
                //logger.Error(msg);
                AddLog(new LogInfo(DateTime.Now, LogType.Error, msg));
            }
        }
        public void Consl(string msg)
        {
            if ((int)LogType.Consl >= (int)MinLevel)
            {
                //logger.Error(msg);
                AddLog(new LogInfo(DateTime.Now, LogType.Consl, msg));
            }
        }
        public void Trace(string msg)
        {
            if ((int)LogType.Trace >= MinLevel)
            {
                // logger.Trace(msg);
                AddLog(new LogInfo(DateTime.Now, LogType.Trace, msg));
            }
        }
        public void Warn (string msg)
        {
            if ((int)LogType.Warn >= (int)MinLevel)
            {
                // logger.Warn(msg);
                AddLog(new LogInfo(DateTime.Now, LogType.Warn, msg));
            }
        }
        public void Info(string msg)
        {
            if ((int)LogType.Info >= (int)MinLevel)
            {
                //logger.Info(msg);
                AddLog(new LogInfo(DateTime.Now, LogType.Info, msg));
            }
        }
        public void Debug(string msg)
        {
            if ((int)LogType.Debug >= (int)MinLevel)
            {
                // logger.Debug(msg);
                AddLog(new LogInfo(DateTime.Now, LogType.Debug, msg));
            }
        }
        public void Fatal(string msg)
        {
            if ((int)LogType.Fatal >= (int)MinLevel)
            {
                //logger.Fatal(msg);

                AddLog(new LogInfo(DateTime.Now, LogType.Fatal, msg));
            }
        }

        public void WriteLogTxt(LogInfo info)
        {
            // 定义日志文件的路径  
            string logFilePath = Environment.CurrentDirectory + "\\logs\\log-" + DateTime.Now.Date.ToString("yyyy-mm-dd") + ".txt";
            if (!Directory.Exists(Environment.CurrentDirectory + "\\logs\\"))
                Directory.CreateDirectory(Environment.CurrentDirectory + "\\logs\\");
            // 使用StreamWriter写入日志  
            // 如果文件不存在，它将被创建；如果文件已存在，则默认是追加模式  
            using (StreamWriter writer = new StreamWriter(logFilePath, true)) // 第二个参数为true表示追加模式  
            {
                // 写入日志信息  
                writer.WriteLine(info.ToString());
                // 你可以继续写入更多的日志信息  
            }
        }

        public void WriteLogSqlite(LogInfo info)
        {
            // 定义日志文件的路径  
            string logFilePath = Environment.CurrentDirectory + "\\logs\\db-" + DateTime.Now.Date.ToString("yyyy-mm-dd") + ".db";
            if (!Directory.Exists(Environment.CurrentDirectory + "\\logs\\"))
                Directory.CreateDirectory(Environment.CurrentDirectory + "\\logs\\");
            // 创建数据库（如果尚不存在）  
            using (var connection = new SQLiteConnection($"Data Source={logFilePath}"))
            {
                connection.Open();
                // 创建一个表（如果尚不存在）  
                string createTableSql = @"  
                CREATE TABLE IF NOT EXISTS Log (  
                    Id INTEGER PRIMARY KEY AUTOINCREMENT,  
                    Time TEXT NOT NULL,  
                    Name TEXT , 
                    Type INTEGER , 
                    Message TEXT
                )";

                using (var command = new SQLiteCommand(createTableSql, connection))
                {
                    command.ExecuteNonQuery();
                }

                // 插入数据  
                string insertSql = "INSERT INTO Log (Time,Name ,Type , Message) VALUES (@Time,@Name,@Type, @Message)";
                using (var command = new SQLiteCommand(insertSql, connection))
                {
                    command.Parameters.AddWithValue("@Time", info.Time.ToString("yyyy-MM-dd HH:mm:ss.fff"));
                    command.Parameters.AddWithValue("@Name", info.Name);
                    command.Parameters.AddWithValue("@Type", info.Type);
                    command.Parameters.AddWithValue("@Message",info.Message);
                    command.ExecuteNonQuery();
                }
            }
        }

        public void DeleteFile()
        {

            // 指定你想要遍历的文件夹路径  
            string folderPath = @"C:\你的文件夹路径";

            // 获取文件夹中的所有文件  
            string[] files = Directory.GetFiles(folderPath);

            // 遍历文件  
            foreach (string file in files)
            {
                // 获取文件的创建时间  
                FileInfo fileInfo = new FileInfo(file);
                DateTime creationTime = fileInfo.CreationTime;

                // 计算自文件创建以来的天数  
                TimeSpan span = DateTime.Now - creationTime;
                double days = span.TotalDays;

                // 如果文件创建时间超过20天  
                if (days > 20)
                {
                    try
                    {
                        // 删除文件  
                        File.Delete(file);
                        //Console.WriteLine($"已删除文件: {file}");
                    }
                    catch (Exception ex)
                    {
                        // 处理删除文件时可能出现的异常，例如文件正在使用中  
                        Console.WriteLine($"无法删除文件: {file}. 错误: {ex.Message}");
                    }
                }
            }

            Console.WriteLine("处理完成。");
            Console.ReadKey(); // 暂停，以便查看输出  

        }
        private void AddLog(LogInfo info)
        {
            info.Name = Name;
            WriteLogTxt(info);
            WriteLogSqlite(info);
            if (_TempLogInfoList == null)
            {
                _TempLogInfoList = new List<LogInfo>();
            }
            while (_TempLogInfoList.Count > MaxTempListCnt)
            {
                _TempLogInfoList.RemoveAt(0);
            }

            _TempLogInfoList.Add(info);
        }
    }
    public class LogInfo
    {
        [Description("时间")]
        public DateTime Time { get; set; }
        [Description("类型")]
        public LogType Type { get; set; }
        [Description("对象")]
        public string Name { get; set; }
        [Description("信息")]
        public string Message { get; set; }
        public LogInfo(DateTime dateTime, LogType type, string msg)
        {
            Time = dateTime;
            Type = type;
            Message = msg;
        }
        public override string ToString() => Time.ToString("yyyy-MM-dd HH:mm:ss.fff") + " | " + Type + " | " + Name + " | " + Message;

    }
    public class LogConsole : TextWriter
    {
        private StringBuilder _sb = new StringBuilder();

        public override Encoding Encoding => throw new NotImplementedException();

        public override void WriteLine(string value)
        {
            Log console = new Log("控制台");
            //_sb.AppendLine(value);
            // 这里可以添加额外的逻辑，比如记录到文件或数据库  
            console.Consl(value);
            Console.WriteLine($"Intercepted: {value}");
            //Console.WriteLine($"Intercepted: {value}"); // 仅为了演示  
        }

        // 你可以根据需要实现其他重写的方法  

        // 一个方法用于获取或清空收集的输出  
        public string GetAndClearOutput()
        {
            string output = _sb.ToString();
            _sb.Clear();
            return output;
        }
    }
}