通过代码配置 Log4net

     最近将项目的异常日志模块改造成log4net。在Asp.net MVC3 中的改造非常简单，我们只要继承HandleErrorAttribute类使用自定义类，

使用特性即可统一处理MVC controller 下的 所有的Action 方法的异常。无须try ... catch.... 详情请见我的这篇随笔

http://www.cnblogs.com/ryanding/archive/2010/11/16/1878168.html。我们只要在上文的CustomHandleErrorAttribute方法内植入Log4Net 即可。

具体的留给读者自己去实践了。本文主要讲解如何通过代码配置Log4Net。将程序的异常信息保存到相关文件以及SQLSERVER数据库。

       这里需要提下，将异常存储在文件中的好处就是如果sqlserver出现异常或者网络出现异常。就无法确保将异常正常保存到数据库,

此时异常信息依然会被本地文件记录在案。对于Log4Net 这个开源库我们就不讨论其XML配置。这里着重讲解用代码如何启用Log4Net。

具体配置代码如下：

1 public static class Log4netHelper
2 {
3
4 // 记录异常日志数据库连接字符串
5   private const string _ConnectionString = @" data source=your server;initial catalog=your db;integrated security=false;persist security info=True;User ID=sa;Password=1111 " ;
6
7 /// <summary>
8 /// 使用SQLSERVER记录异常日志
9 /// </summary>
10 /// <Author> Ryanding </Author>
11 /// <date> 2011-05-01 </date>
12   public static void LoadADONetAppender()
13 {
14 LoadFileAppender();
15
16 log4net.Repository.Hierarchy.Hierarchy hier =
17 log4net.LogManager.GetLoggerRepository() as log4net.Repository.Hierarchy.Hierarchy;
18
19 if (hier != null )
20 {
21 log4net.Appender.AdoNetAppender adoAppender = new log4net.Appender.AdoNetAppender();
22 adoAppender.Name = " AdoNetAppender " ;
23 adoAppender.CommandType = CommandType.Text;
24 adoAppender.BufferSize = 1 ;
25 adoAppender.ConnectionType = " System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " ;
26 adoAppender.ConnectionString = _ConnectionString;
27 adoAppender.CommandText = @" INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception) " ;
28 adoAppender.AddParameter( new AdoNetAppenderParameter { ParameterName = " @log_date " , DbType = System.Data.DbType.DateTime, Layout = new log4net.Layout.RawTimeStampLayout() });
29 adoAppender.AddParameter( new AdoNetAppenderParameter { ParameterName = " @thread " , DbType = System.Data.DbType.String, Size = 255 , Layout = new Layout2RawLayoutAdapter( new PatternLayout( " %thread " )) });
30 adoAppender.AddParameter( new AdoNetAppenderParameter { ParameterName = " @log_level " , DbType = System.Data.DbType.String, Size = 50 , Layout = new Layout2RawLayoutAdapter( new PatternLayout( " %level " )) });
31 adoAppender.AddParameter( new AdoNetAppenderParameter { ParameterName = " @logger " , DbType = System.Data.DbType.String, Size = 255 , Layout = new Layout2RawLayoutAdapter( new PatternLayout( " %logger " )) });
32 adoAppender.AddParameter( new AdoNetAppenderParameter { ParameterName = " @message " , DbType = System.Data.DbType.String, Size = 4000 , Layout = new Layout2RawLayoutAdapter( new PatternLayout( " %message " )) });
33 adoAppender.AddParameter( new AdoNetAppenderParameter { ParameterName = " @exception " , DbType = System.Data.DbType.String, Size = 4000 , Layout = new Layout2RawLayoutAdapter( new ExceptionLayout()) });
34 adoAppender.ActivateOptions();
35 BasicConfigurator.Configure(adoAppender);
36 }
37
38
39 }
40
41 /// <summary>
42 /// 使用文本记录异常日志
43 /// </summary>
44 /// <Author> Ryanding </Author>
45 /// <date> 2011-05-01 </date>
46   public static void LoadFileAppender()
47 {
48 string currentPath = AppDomain.CurrentDomain.BaseDirectory;
49 string txtLogPath = string .Empty;
50 string iisBinPath = AppDomain.CurrentDomain.RelativeSearchPath;
51
52 if ( ! string .IsNullOrEmpty(iisBinPath))
53 txtLogPath = Path.Combine(iisBinPath, " ErrorLog.txt " );
54 else
55 txtLogPath = Path.Combine(currentPath, " ErrorLog.txt " );
56
57 log4net.Repository.Hierarchy.Hierarchy hier =
58 log4net.LogManager.GetLoggerRepository() as log4net.Repository.Hierarchy.Hierarchy;
59
60 FileAppender fileAppender = new FileAppender();
61 fileAppender.Name = " LogFileAppender " ;
62 fileAppender.File = txtLogPath;
63 fileAppender.AppendToFile = true ;
64
65 PatternLayout patternLayout = new PatternLayout();
66 patternLayout.ConversionPattern = " 记录时间：%date 线程ID:[%thread] 日志级别：%-5level 出错类：%logger property:[%property{NDC}] - 错误描述：%message%newline " ;
67 patternLayout.ActivateOptions();
68 fileAppender.Layout = patternLayout;
69
70 // 选择UTF8编码，确保中文不乱码。
71   fileAppender.Encoding = Encoding.UTF8;
72
73 fileAppender.ActivateOptions();
74 BasicConfigurator.Configure(fileAppender);
75
76 }
77
78 /// <summary>
79 /// 异常处理
80 /// </summary>
81 /// <param name="methedType"> 出现异常方法的类型。例如：MethodBase.GetCurrentMethod().DeclaringType </param>
82 /// <param name="errorMsg"> 错误信息。例如：SaveBuildingPhoto方法出错。Author:开发者名称 </param>
83 /// <param name="ex"></param>
84   public static void InvokeErrorLog(Type methedType, string errorMsg, Exception ex)
85 {
86 LoadADONetAppender();
87 ILog log = log4net.LogManager.GetLogger(methedType);
88 log.Info(errorMsg, ex);
89 }
90 }

在您的数据库执行以下脚本：

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N ' [dbo].[Log] ' ) AND type in (N ' U ' ))
BEGIN
CREATE TABLE [ dbo ] . [ Log ] (
[ Id ] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[ Date ] [ datetime ] NOT NULL ,
[ Thread ] [ varchar ] ( 255 ) NULL ,
[ Level ] [ varchar ] ( 50 ) NULL ,
[ Logger ] [ varchar ] ( 255 ) NULL ,
[ Message ] [ varchar ] ( 4000 ) NULL ,
[ Exception ] [ varchar ] ( 4000 ) NULL ,
PRIMARY KEY CLUSTERED
(
[ Id ] ASC
) WITH (PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [ PRIMARY ]
) ON [ PRIMARY ]
END
Go

调用如下：

1 public bool Login( string userName, string password)
2 {
3 try
4 {
5 // TODO:
6
7 }
8 catch (Exception ex)
9 {
10 Log4netHelper.InvokeErrorLog(MethodBase.GetCurrentMethod().DeclaringType, " 登录方法Login出错-Author：ryanding " , ex);
11 return false ;
12 }
13 }