public static IHostBuilder AddSerilogSetup(this IHostBuilder host)
        {
            var logConfiguration = new LoggerConfiguration()
                .MinimumLevel.Debug() //最小記錄等級
                .ReadFrom.Configuration(Appsettings.Configuration) //從給定的配置文件讀取信息
                .Enrich.FromLogContext()//從上下文中獲取信息，自動添加到日志中
                .WriteToConsole()//寫出到控制臺 
                .WriteToFile()//寫出到文件
                .WriteToDataBase();//寫出到數據庫(項目采用雪花ID,serilog自帶的生成日志表是自增int不太符合項目,可根據需求選擇)

            Log.Logger = logConfiguration.CreateLogger();

            host.UseSerilog(); //設置Serilog為日志提供者
            return host;
        }

        public static LoggerConfiguration WriteToConsole(this LoggerConfiguration configuration)
        {
            configuration = configuration.WriteTo.Logger(x =>
            {
                x.Filter.ByExcluding(ExcludingCondition())//過濾掉的內容，我會手動過濾掉不需要的，這個不是必要的。
                .Filter.ByExcluding(a => a.Level == LogEventLevel.Debug)//我自己不輸出Debug,因為程序自帶的Debug記錄太多了
                .WriteTo.Console();
            });
            return configuration;
        }

        public static LoggerConfiguration WriteToFile(this LoggerConfiguration configuration)
        {
            //輸出INFO日志
            configuration = configuration.WriteTo.Logger(x =>
            {
                x.Filter.ByIncludingOnly(x => x.Level == LogEventLevel.Information)
                .Filter.ByExcluding(ExcludingCondition())
                .WriteTo.Async(s => s.File(LogContextWrite.Combine(@"INFO/.txt"), rollingInterval: RollingInterval.Day, outputTemplate: LogTemplate));
            });
            //輸出ERROR日志
            configuration = configuration.WriteTo.Logger(x =>
            {
                x.Filter.ByIncludingOnly(x => x.Level == LogEventLevel.Error)
                .Filter.ByExcluding(ExcludingCondition())
                .WriteTo.Async(s => s.File(LogContextWrite.Combine(@$"ERROR/.txt"), rollingInterval: RollingInterval.Day, outputTemplate: LogTemplate));
            });
            //輸出Debug日志
            configuration = configuration.WriteTo.Logger(x =>
            {
                x.Filter.ByIncludingOnly(x => x.Level == LogEventLevel.Debug)
                .Filter.ByExcluding(ExcludingCondition())
                .WriteTo.Async(s => s.File(LogContextWrite.Combine(@"DEBUG/.txt"), rollingInterval: RollingInterval.Day, outputTemplate: LogTemplate));
            });
            //輸出Warning日志
            configuration = configuration.WriteTo.Logger(x =>
            {
                x.Filter.ByExcluding(ExcludingCondition())
                .WriteTo.Async(s => s.File(LogContextWrite.Combine(@"WARNING/.txt"), rollingInterval: RollingInterval.Day, outputTemplate: LogTemplate));
            });
            return configuration;
        }

        public static LoggerConfiguration WriteToDataBase(this LoggerConfiguration configuration)
        {
            //讀取配置文件是否開啟數據庫日志記錄(會自動建表)
            if (!Appsettings.AppStr("Seq:EnableWriteToDatabase").ObjToBool())
            {
                return configuration;
            }
            //數據庫連接字符
            var databaseSettings = Appsettings.App<DatabaseSettings>("DatabaseSettings");
            var defaultDb = databaseSettings.Db.FirstOrDefault(x => x.Name == databaseSettings.DefaultDb);

            configuration = configuration.WriteTo.Logger(x =>
            {
                //只記錄Error,其他的沒必要入庫。
                x.Filter.ByExcluding(l => l.Level != LogEventLevel.Error)
                .Filter.ByExcluding(Matching.FromSource("Microsoft"))//過濾掉微軟自帶的一些日志
                .Filter.ByExcluding(ExcludingCondition())
                .Filter.ByExcluding(l => l.Properties.ContainsKey("SourceContext") && l.Properties["SourceContext"].ToString().Contains("Quartz.")) // 根據 SourceContext 過濾
                .WriteTo.MSSqlServer(defaultDb.ConnectionString, new MSSqlServerSinkOptions
                {
                    AutoCreateSqlTable = true, //自動建表
                    TableName = Appsettings.AppStr("Seq:WriteToDataBaseTable"),  //表名
                });
            });
            return configuration;
        }

            builder.Host.AddSerilogSetup();