log4net把自定义的变量写入数据库

最新推荐文章于 2024-08-14 16:26:23 发布

蓝色水

最新推荐文章于 2024-08-14 16:26:23 发布

阅读量967

点赞数

分类专栏： Log4NET

Log4NET 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

一、log4net针对sqlserver,mysql及文本的配置方式：

（注：如果配置写入数据库，需要将System.Data.dll拷到bin目录下。）

文本和sqlserver-sqlclient连接库：

</layout>
</parameter>

</appender>

mysql-odbc方式连接库：

二、log.info(object messageObject)传入自定义对象

比如说插入数据库时需要将该业务操作的原因也记录，假设数据库中该字段名称为Reason。

1.自定义一个业务对象，LogContent

public class LogContent
    {
        public LogContent(string reason)
        {
            _Reason = reason;
        }

        private string _reason;
        public string Reason
        {
            get { return _reason; }
            set { _reason = value; }
        }
    }

2.自定义一个Layout(在该类的构造方法中将自定义的Converter加进去，以处理property{}中的自定义字段)和一个PatternConverter:

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

public class MyMessagePatternConverter : PatternLayoutConverter
    {
        protected override void Convert(System.IO.TextWriter writer, log4net.Core.LoggingEvent loggingEvent)
        {
            if (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());
            }
            //if (Option != null)
            //{
            //    // Write the value for the specified key
            //    WriteObject(writer, loggingEvent.Repository, loggingEvent.LookupProperty(Option));
            //}
            //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 = loggingEvent.MessageObject.GetType().GetProperty(property);
            if(propertyInfo != null)
                propertyValue = propertyInfo.GetValue(loggingEvent.MessageObject, null);

            return propertyValue;
        }

3.配置文件中相应节点：

4.调用代码：

static void Main(string[] args)
        {
            log4net.Config.XmlConfigurator.Configure();//使用单独配置文件时无需此方法

            log4net.ILog log = log4net.LogManager.GetLogger(typeof(Program));

log.Info("log4net测试");

log.Info(new LogContent("reason-because……"));
}