log4net学习笔记(一)WPF

　　Log4Net官方文档

1.创建MS SQL Server日志表

CREATE TABLE [dbo].[Log] (
[Id] [int] IDENTITY (1, 1) NOT NULL,
[Date] [datetime] NOT NULL,
[Thread] [varchar] (255) NOT NULL,
[Level] [varchar] (50) NOT NULL,
[Logger] [varchar] (255) NOT NULL,
[Message] [varchar] (4000) NOT NULL,
[Exception] [varchar] (2000) NULL
)

2.日志表配置-log4net.config中添加（把参数改成自己的,启用了保存到数据库和csv文件）

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>
<log4net>

<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">

<File value="Log\" />

<param name="AppendToFile" value="true" />


<param name="lockingModel" type="log4net.Appender.FileAppender+MinimalLock" />

<param name="RollingStyle" value="Composite" />

<StaticLogFileName value="false" />
<DatePattern value="yyyy\\MM\\dd\\CSV_yyyy-MM-dd'.csv'" />
<MaxSizeRollBackups value="-1" />

<MaximumFileSize value="2MB" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%n＝＝＝＝＝＝＝＝＝
%n【日志级别】,【记录时间】,【线程ID】,【出错文件】,【出错行号】,【出错的类】,【属性】,【错误描述】,【错误详情】,
%n %-5level,%date,[%thread],%F,%L,%logger,[%property{NDC}],%message,%newline," />
</layout>
</appender>
log4net-日志表配置
<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="0" />

<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<connectionString value="data source=172.***.1.***;initial catalog=DBNAME;Persist Security Info=True;User ID=sa;Password=pwd123123" />
<commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
<parameter>
<parameterName value="@log_date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.RawTimeStampLayout" />
</parameter>
<parameter>
<parameterName value="@thread" />
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%thread" />
</layout>
</parameter>
<parameter>
<parameterName value="@log_level" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<parameter>
<parameterName value="@logger" />
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%logger" />
</layout>
</parameter>
<parameter>
<parameterName value="@message" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%message" />
</layout>
</parameter>
<parameter>
<parameterName value="@exception" />
<dbType value="String" />
<size value="2000" />
<layout type="log4net.Layout.ExceptionLayout" />
</parameter>
</appender>





















<root>

<level value="all" />
<appender-ref ref="RollingFileAppender" />
<appender-ref ref="AdoNetAppender" />
</root>
</log4net>
</configuration>

3.引用log4net的Nuget包

4.添加log4net-helper

（1）第一版

using log4net;
using System;
[assembly: log4net.Config.XmlConfigurator(ConfigFile = "log4net.config", Watch = true)]
namespace HOST_CONTROL_CENTER.Uril.LogHelper
{
    /// <summary>
    /// Log4NetHelper
    /// </summary>
    public class Log4NetHelper
    {
        #region 执行SQL日志
        /// <summary>
        /// 普通日志
        /// </summary>
        /// <param name="message">日志内容</param>
        public static void WriteInfo(Type type, string message)
        {
            ILog log = log4net.LogManager.GetLogger("Info");  // 可以改成type typeof(类)
            if (log.IsInfoEnabled)
            {
                log.Info(message);
            }
            log = null;
        }

        /// <summary>
        /// 警告日志
        /// </summary>
        /// <param name="message">警告日志</param>
        public static void WriteWarn(Type type, string message)
        {
            ILog log = log4net.LogManager.GetLogger("Warn");
            if (log.IsWarnEnabled)
            {
                log.Warn(message);
            }
            log = null;
        }

        /// <summary>
        /// 错误日志
        /// </summary>
        /// <param name="message">错误日志</param>
        public static void WriteError(Type type, string message)
        {
            ILog log = log4net.LogManager.GetLogger("Error");
            if (log.IsInfoEnabled)
            {
                log.Error(message);
            }
            log = null;
        }
        #endregion

        public static void TestLog(string aa= "错误")
        {
            ILog log = log4net.LogManager.GetLogger("Info");
            log.Error("Hello World!");
        }
    }
}

（2）第二版（用这个就够用）

 1 using log4net;
 2 using System;
 3 [assembly: log4net.Config.XmlConfigurator(ConfigFile = "log4net.config", Watch = true)]
 4 namespace HOST_CONTROL_CENTER.Uril.LogHelper
 5 {
 6     /// <summary>
 7     /// Log4NetHelper
 8     /// </summary>
 9     public class Log4NetHelper
10     {
11         #region 执行SQL日志
12         /// <summary>
13         /// 普通日志
14         /// </summary>
15         /// <param name="message">日志内容</param>
16         public static void WriteInfo(Type type, string message)
17         {
18             ILog log = log4net.LogManager.GetLogger(type);
19             if (log.IsInfoEnabled)
20             {
21                 log.Info(message);
22             }
23             log = null;
24         }
25 
26         /// <summary>
27         /// 警告日志
28         /// </summary>
29         /// <param name="message">警告日志</param>
30         public static void WriteWarn(Type type, string message)
31         {
32             ILog log = log4net.LogManager.GetLogger(type);
33             if (log.IsWarnEnabled)
34             {
35                 log.Warn(message);
36             }
37             log = null;
38         }
39 
40         /// <summary>
41         /// 错误日志
42         /// </summary>
43         /// <param name="message">错误日志</param>
44         public static void WriteError(Type type, string message)
45         {
46             ILog log = log4net.LogManager.GetLogger(type);
47             if (log.IsInfoEnabled)
48             {
49                 log.Error(message);
50             }
51             log = null;
52         }
53         #endregion
54 
55         public static void TestLog(string aa= "错误")
56         {
57             ILog log = log4net.LogManager.GetLogger("Info");
58             log.Error("Hello World!");
59         }
60     }
61 }

　　测试例子：

 1   private void mitPInfo_Click(object sender, RoutedEventArgs e)
 2         {
 3             Log4NetHelper.WriteInfo(typeof(MianShow), "信息");
 4         }
 5 
 6         private void mitPWarn_Click(object sender, RoutedEventArgs e)
 7         {
 8             Log4NetHelper.WriteWarn(typeof(MianShow), "警告");
 9         }
10 
11         private void mitPError_Click(object sender, RoutedEventArgs e)
12         {
13             try{
14                 int a = Convert.ToInt32("aa");
15             }
16             catch
17             {
18                 Log4NetHelper.WriteError(typeof(MianShow), "a错误");
19             }
20         }
21 
22         private void mitPError1_Click(object sender, RoutedEventArgs e)
23         {
24             try
25             {
26                 int a = Convert.ToInt32("aa");
27                 Log4NetHelper.TestLog("a错误");
28             }
29             catch
30             {
31                 Log4NetHelper.TestLog("a错误");
32             }
33         }

结果：

　　日志文件：

　　数据库：

（3）其他版本：

  1 using log4net;
  2 using log4net.Appender;
  3 using log4net.Config;
  4 using log4net.Repository.Hierarchy;
  5 using System;
  6 using System.IO;
  7 
  8 //[assembly: XmlConfigurator(ConfigFile = "log4net.config", Watch = true)]
  9 namespace HOST_CONTROL_CENTER.Uril.LogHelper
 10 {
 11     public class Log4Helper2
 12     {
 13         private static ILog ILogger;
 14         private static string configFile = "log4net.config";
 15 
 16         static Log4Helper2()
 17         {
 18             if (File.Exists(Log4NetConfigFile))
 19             {
 20                 if (Environment.OSVersion.Platform == PlatformID.Win32NT)
 21                 {
 22                     XmlConfigurator.ConfigureAndWatch(new FileInfo(Log4NetConfigFile));
 23                 }
 24                 else
 25                 {
 26                     XmlConfigurator.Configure(new FileInfo(Log4NetConfigFile));
 27                 }
 28             }
 29             else
 30             {
 31                 BasicConfigurator.Configure();
 32             }
 33 
 34             ILogger = GetLogger(typeof(Log4Helper2));
 35         }
 36 
 37         #region Abbributes
 38         public static string Log4NetConfigFile
 39         {
 40             get
 41             {
 42                 return Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location), configFile);
 43 
 44             }
 45         }
 46 
 47         public static ILog GetLogger(System.Type type)
 48         {
 49             return LogManager.GetLogger(type);
 50         }
 51         #endregion
 52 
 53         #region 执行SQL日志
 54         public static void Info(string message)
 55         {
 56             ILogger.Info(message);
 57         }
 58 
 59         public static void Warn(string message)
 60         {
 61             ILogger.Warn(message);
 62         }
 63 
 64         public static void Error(string message)
 65         {
 66             ILogger.Error(message);
 67         }
 68         #endregion
 69 
 70         /// <summary>
 71         /// 清理log文件
 72         /// </summary>
 73         /// <param name="keepDays"></param>
 74         public static void ClearOldLogFiles(string keepDays)
 75         {
 76             int days = 0;
 77             int.TryParse(keepDays, out days);
 78             if (days <= 0)
 79             {
 80                 return;
 81             }
 82 
 83             try
 84             {
 85                 DateTime now = DateTime.Now;
 86 
 87                 Hierarchy hierarchy = (Hierarchy)LogManager.GetLoggerRepository();
 88                 foreach (IAppender appender in hierarchy.Root.Appenders)
 89                 {
 90                     if (appender is RollingFileAppender)
 91                     {
 92                         string logPath = ((RollingFileAppender)appender).File;
 93                         DirectoryInfo dir = new DirectoryInfo(logPath.Substring(0, logPath.LastIndexOf("\\")));
 94 
 95                         foreach (FileInfo file in dir.GetFiles())
 96                         {
 97                             if (file.LastWriteTime < now.AddDays(-days))
 98                             {
 99                                 file.Delete();
100                             }
101                         }
102                     }
103                 }
104             }
105             catch
106             {
107             }
108         }
109     }
110 }

参考文档：https://logging.apache.org/log4net/release/config-examples.html

365个夜晚，我希望做到两天更一篇博客。加油，小白！

相关阅读:
matlab安装YaHei Consolas Hybrid字体
 Matlab各种拟合
 正态分布
 JQuery插件：遮罩+数据加载中。。。（特点：遮你想遮，罩你想罩）
【调侃】IOC前世今生
 使用jquery的 uploadify，在谷歌浏览器上总会崩溃的解决方法
 源代码管理工具TFS2013安装与使用
 C# 给枚举定义DescriptionAttribute，把枚举转换为键值对
 Bootstrap 中文官网
 时间时间戳转换
原文地址：https://www.cnblogs.com/qq2806933146xiaobai/p/15783489.html