让log4net保存自定义对象信息到数据库中

如果只想保存系统运行日志,只需要基本地配置一下log4net就Ok了,但想保存自定义对象(如LogInfo)之类的就得多写一点代码了:

 

1.先确保log4net最基本的log4net.Appender.AdoNetAppender配置运行正常:

<appender name="AdoNetAppender_Oracle" type="log4net.Appender.AdoNetAppender">
    <connectionType value="System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <connectionString value="data source=[mydatabase];User ID=[user];Password=[password]" />
    <commandText value="INSERT INTO Log (Datetime,Thread,Log_Level,Logger,Message) VALUES (:log_date, :thread, :log_level, :logger, :message)" />
    <bufferSize value="128" />
    <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>
</appender>

注:以上摘自http://logging.apache.org/log4net/release/config-examples.html,其中有一个问题就是,目前我们使用的都是.net2.0了,需要将System.Data.OracleClient的Version改为2.0.0.0;

2.创建两个类:

namespace GXSN.Util.Logger
{

    public class XLayout : PatternLayout
    {
        public XLayout()
        {
            this.AddConverter("property", typeof(XPatternLayoutConverter));
        }
    }

 

    public class XPatternLayoutConverter : PatternLayoutConverter
    {
        protected override void Convert(System.IO.TextWriter writer, log4net.Core.LoggingEvent loggingEvent)
        {
            if (this.Option != null)
            {
                // Write the value for the specified key
                WriteObject(writer, loggingEvent.Repository, LookupProperty(Option, loggingEvent));
            }
            else
            {
                // Write all the key value pairs
                WriteDictionary(writer, loggingEvent.Repository, loggingEvent.GetProperties());
            }
        }

        /// <summary>
        /// 通过反射获取传入的日志对象的某个属性的值
        /// </summary>
        /// <param name="property"></param>
        /// <returns></returns>
        private Object LookupProperty(String property, log4net.Core.LoggingEvent loggingEvent)
        {
            Object propertyValue = String.Empty;
            PropertyInfo propertyInfo;

            propertyInfo = loggingEvent.MessageObject.GetType().GetProperty(property);
            if (propertyInfo != null)
            {
                propertyValue = propertyInfo.GetValue(loggingEvent.MessageObject, null);
            }
            return propertyValue;
        }
    }

}

 

注:这两个类网上可以找到,只是把类名改了一下,看注释就明白了.

3.自定义类LogInfo:

namespace xxx.Model
{
    public class LogInfo
    {
        public String SID { get; set; }
        public String Title { get; set; }
        public String UserID { get; set; }
        public String LogLevel { get; set; }
        public String Logger { get; set; }
        public String Detail { get; set; }
        public String DateTime { get; set; }
    }
}

 

4.修改xxx.config文件,其中LogInfo类的SID, Title, UserID,Detail作为扩展变量:

<appender name="AdoNetAppender_Oracle" type="log4net.Appender.AdoNetAppender">
            <connectionType value="System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=2.0.0.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089" />
            <connectionString value="data source=orcl;User ID=system;Password=123456" />
            <commandText value="INSERT INTO TBL_Log(sid,title,userid,threadid,loglevel,logger,detail,logdate) VALUES(:sid, :title, :userid, :thread, :log_level, :logger, :message, :log_date)" />
            <bufferSize value="128" />
            <parameter>
                <parameterName value=":sid" />
                <dbType value="String" />
                <size value="64" />
                <layout type="GXSN.Util.Logger.XLayout, GXSN.Util.Logger">
                    <conversionPattern value="%property{SID}" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value=":title" />
                <dbType value="String" />
                <size value="255" />
                <layout type="GXSN.Util.Logger.XLayout, GXSN.Util.Logger">
                    <conversionPattern value="%property{Title}" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value=":userid" />
                <dbType value="String" />
                <size value="255" />
                <layout type="GXSN.Util.Logger.XLayout, GXSN.Util.Logger">
                    <conversionPattern value="%property{UserID}" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value=":thread" />
                <dbType value="String" />
                <size value="32" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%thread" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value=":log_level" />
                <dbType value="String" />
                <size value="64" />
                <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="GXSN.Util.Logger.XLayout, GXSN.Util.Logger">
                    <conversionPattern value="%property{Detail}" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value=":log_date" />
                <dbType value="DateTime" />
                <layout type="log4net.Layout.RawTimeStampLayout" />
            </parameter>
        </appender>

4.开始调试至成功.

 

参考页面:

http://blog.csdn.net/penginpha/archive/2011/05/03/6387593.aspx

http://logging.apache.org/log4net/release/config-examples.html

http://www.cnblogs.com/sunrack/articles/911938.html