Log4Net记录日志到SQLServer数据库

Log4Net配置步骤:

1、在项目中添加Log4Net引用,可在nuget包工具中下载

2、在项目中添加Log4Net.config文件并配置

<?xml version="1.0"?>
<configuration>

  <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
  </configSections>

  <system.web>
    <compilation debug="true" targetFramework="4.0" />
  </system.web>
  <!--***********************************日志相关配置*************************************-->
  <log4net>
    <!--定义输出到数据库中,这里连接字符串会去取Web.config里面定义的名字为GFDbContext的字符串-->
    <appender name="AdoNetAppender_SQLServer" type="GFG.GloryFinance.Framework.Log4Net.MyAdoNetAppender">
      <!--BufferSize为缓冲区大小,只有日志记录超10条才会一块写入到数据库-->
      <bufferSize value="10" />
      <connectionType value="System.Data.SqlClient.SqlConnection,System.Data, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089" />
      <connectionStringName value="GFDbContext"></connectionStringName>
      <commandText value="INSERT INTO [Log].[SystemException]([SystemExceptionId],[CreateTime],[Thread],[Level],[Logger],[MethodName],[Message],[IPAddress],[MemberId]) VALUES (NEXT VALUE FOR [Log].[SystemExceptionSequence],@LogDate,@Thread, @LogLevel,@LogType,@FunName,@Message,@IP,@UserId)" />
      <!--定义各个参数-->
      <parameter>
        <parameterName value="@LogDate" />
        <dbType value="DateTime" />
        <layout type="log4net.Layout.RawTimeStampLayout" />
      </parameter>
      <parameter>
        <parameterName value="@Thread"/>
        <dbType value="String"/>
        <size value="240"/>
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%thread"/>
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@LogLevel" />
        <dbType value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%level" />
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@LogType" />
        <dbType value="String" />
        <size value="255" />
        <layout type="GFG.GloryFinance.Framework.Log4Net.CustomLayout">
          <conversionPattern value="%property{logType}" />
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@FunName" />
        <dbType value="String" />
        <size value="255" />
        <layout type="GFG.GloryFinance.Framework.Log4Net.CustomLayout">
          <conversionPattern value="%property{FunName}" />
        </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="@IP"/>
        <dbType value="String"/>
        <size value="255" />
        <layout type="GFG.GloryFinance.Framework.Log4Net.CustomLayout">
          <param name="ConversionPattern" value="%property{IP}"/>
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@UserId"/>
        <dbType value="String"/>
        <size value="255" />
        <layout type="GFG.GloryFinance.Framework.Log4Net.CustomLayout">
          <param name="ConversionPattern" value="%property{UserId}"/>
        </layout>
      </parameter>
    </appender>

    <!--定义日志的输出媒介,下面定义日志以四种方式输出。也可以下面的按照一种类型或其他类型输出。-->
    <root>
      <!--定义级别OFF FATAL、ERROR、WARN、INFO、DEBUG ALL-->
      <level value="WARN"></level>
      <!--文件形式记录日志-->
    </root>
    <logger name="iNotes">
      <level value="INFO"/>
      <appender-ref ref="AdoNetAppender_SQLServer" />
    </logger>
  </log4net>
  <!--***********************************日志相关配置*************************************-->
</configuration>


注意参照配置文件在数据库中创建日志记录表 [Log].[SystemException]


3、在项目的AssemblyInfo.cs文件中添加以下配置

//日志系统应用程序配置文件
[assembly: log4net.Config.XmlConfigurator(ConfigFile = "Log4Net.config", Watch = true)]


4、重写Log4Net服务并创建单例

using System;
using System.Collections;
using System.Configuration;
using System.Reflection;
using log4net;
using log4net.Appender;
using log4net.Core;
using log4net.Layout;
using log4net.Layout.Pattern;


    /// <summary>
    ///日志服务,支持自定义属性
    /// </summary>
    public sealed class Log4NetService
    {
        /// <summary>
        /// 日志单例
        /// </summary>
        public static Log4NetService Instance = new Log4NetService();

        /// <summary>
        /// 创建log4net日志记录器
        /// </summary>
        private static IMyLog MyLog = MyLogManager.GetLogger("iNotes");

        /// <summary>
        /// 日志级别枚举
        /// </summary>
        public enum MsgLevel
        {
            /// <summary>
            /// 1. 毁灭级别
            /// </summary>
            Fatal,

            /// <summary>
            /// 2. 错误级别
            /// </summary>
            Error,

            /// <summary>
            /// 3. 警告级别
            /// </summary>
            Warn,

            /// <summary>
            /// 4. 消息级别
            /// </summary>
            Info,

            /// <summary>
            ///  5. 调试级别
            /// </summary>
            Debug
        }

        /// <summary>
        /// 创建系统日志
        /// </summary>
        /// <param name="level">级别</param>
        /// <param name="type">类名,可自定义</param>
        /// <param name="parasHashtable">自定义参数,目前固定三个{UserId;IP;FunName}</param>
        /// <param name="message">内容</param>
        public void Log(MsgLevel level,System.String type,Hashtable parasHashtable, object message)
        {
            
            switch (level)
            {
                case MsgLevel.Debug:
                    MyLog.Debug(type, parasHashtable, message);
                    break;
                case MsgLevel.Info:
                    MyLog.Info(type, parasHashtable, message);
                    break;
                case MsgLevel.Warn:
                    MyLog.Warn(type, parasHashtable, message);
                    break;
                case MsgLevel.Error:
                    MyLog.Error(type, parasHashtable, message);
                    break;
                case MsgLevel.Fatal:
                    MyLog.Fatal(type, parasHashtable, message);
                    break;
            }
        }
        
    }

    #region 重写log4net接口

    /// <summary>
    /// 重写ILog接口
    /// </summary>
    public interface IMyLog : ILog
    {

        void Debug(string logType, Hashtable parasHashtable, object message);
        void Debug(string logType, Hashtable parasHashtable, object message, System.Exception t);

        void Info(string logType, Hashtable parasHashtable, object message);
        void Info(string logType, Hashtable parasHashtable, object message, System.Exception t);

        void Warn(string logType, Hashtable parasHashtable, object message);
        void Warn(string logType, Hashtable parasHashtable, object message, System.Exception t);

        void Error(string logType, Hashtable parasHashtable, object message);
        void Error(string logType, Hashtable parasHashtable, object message, System.Exception t);

        void Fatal(string logType, Hashtable parasHashtable, object message);
        void Fatal(string logType, Hashtable parasHashtable, object message, System.Exception t);
    }

    /// <summary>
    /// 日志方法类,重写新增日志方法
    /// </summary>
    public class MyLogImpl : LogImpl, IMyLog
    {
        /// <summary>
        /// The fully qualified name of this declaring type not the type of any subclass.
        /// </summary>
        public readonly static System.Type ThisDeclaringType = typeof(MyLogImpl);

        public MyLogImpl(ILogger logger) : base(logger) { }

        #region 重写添加日志内容的方法
        public void Debug(string logType, Hashtable parasHashtable, object message)
        {
            Debug(logType, parasHashtable, message, null);
        }
        public void Debug(string logType, Hashtable parasHashtable, object message, System.Exception t)
        {
            if (this.IsDebugEnabled)
            {
                LoggingEvent loggingEvent = new LoggingEvent(ThisDeclaringType, Logger.Repository, Logger.Name, Level.Debug, message, t);
                loggingEvent.Properties["logType"] = logType;
                //添加自定义输出项
                foreach (DictionaryEntry de in parasHashtable)
                {
                    loggingEvent.Properties[de.Key.ToString()] = de.Value.ToString();
                }
               
                Logger.Log(loggingEvent);
            }
        }

        public void Info(string logType, Hashtable parasHashtable, object message)
        {
            Info(logType, parasHashtable, message, null);
        }
        public void Info(string logType, Hashtable parasHashtable, object message, System.Exception t)
        {
            if (this.IsInfoEnabled)
            {
                LoggingEvent loggingEvent = new LoggingEvent(ThisDeclaringType, Logger.Repository, Logger.Name, Level.Info, message, t);
                loggingEvent.Properties["logType"] = logType;
                //添加自定义输出项
                foreach (DictionaryEntry de in parasHashtable)
                {
                    loggingEvent.Properties[de.Key.ToString()] = de.Value.ToString();
                }
                Logger.Log(loggingEvent);
            }
        }

        public void Warn(string logType, Hashtable parasHashtable, object message)
        {
            Warn(logType, parasHashtable, message, null);
        }
        public void Warn(string logType, Hashtable parasHashtable, object message, System.Exception t)
        {
            if (this.IsWarnEnabled)
            {
                LoggingEvent loggingEvent = new LoggingEvent(ThisDeclaringType, Logger.Repository, Logger.Name, Level.Warn, message, t);
                loggingEvent.Properties["logType"] = logType;
                //添加自定义输出项
                foreach (DictionaryEntry de in parasHashtable)
                {
                    loggingEvent.Properties[de.Key.ToString()] = de.Value.ToString();
                }
                Logger.Log(loggingEvent);
            }
        }

        public void Error(string logType, Hashtable parasHashtable, object message)
        {
            Error(logType, parasHashtable, message, null);
        }
        public void Error(string logType, Hashtable parasHashtable, object message, System.Exception t)
        {
            if (this.IsErrorEnabled)
            {
                LoggingEvent loggingEvent = new LoggingEvent(ThisDeclaringType, Logger.Repository, Logger.Name, Level.Error, message, t);
                loggingEvent.Properties["logType"] = logType;
                //添加自定义输出项
                foreach (DictionaryEntry de in parasHashtable)
                {
                    loggingEvent.Properties[de.Key.ToString()] = de.Value.ToString();
                }
                Logger.Log(loggingEvent);
            }
        }

        public void Fatal(string logType, Hashtable parasHashtable, object message)
        {
            Fatal(logType, parasHashtable, message, null);
        }
        public void Fatal(string logType, Hashtable parasHashtable, object message, System.Exception t)
        {
            if (this.IsFatalEnabled)
            {
                LoggingEvent loggingEvent = new LoggingEvent(ThisDeclaringType, Logger.Repository, Logger.Name, Level.Fatal, message, t);
                loggingEvent.Properties["logType"] = logType;
                //添加自定义输出项
                foreach (DictionaryEntry de in parasHashtable)
                {
                    loggingEvent.Properties[de.Key.ToString()] = de.Value.ToString();
                }
                Logger.Log(loggingEvent);
            }
        }
        #endregion 重写添加日志内容的方法

        /// <summary>
        /// 获取当前操作用户编号
        /// </summary>
        /// <returns></returns>
        private string GetUserId()
        {
            string account = string.Empty;
            try
            {
                account = "username"; //这里尽可替换,根据你的程序修改相关代码获取当前登录的用户账号
            }
            catch
            {
                account = "未登录";// string.Empty;
            }
            finally
            {

            }
            return account;
        }
        /// <summary>
        /// 获取当前操作用户IP
        /// </summary>
        /// <returns></returns>
        private string GetIp()
        {
            return System.Web.HttpContext.Current.Request.UserHostAddress;
        }
    }
    /// <summary>
    /// 日志管理类
    /// </summary>
    public class MyLogManager
    {
        #region 静态成员
        /// <summary>
        /// The wrapper map to use to hold the <see cref="EventIDLogImpl"/> objects
        /// </summary>
        private static readonly WrapperMap s_wrapperMap = new WrapperMap(new WrapperCreationHandler(WrapperCreationHandler));

        #endregion

        #region 构造函数
        /// <summary>
        /// Private constructor to prevent object creation
        /// </summary>
        private MyLogManager() { }
        #endregion

        #region 成员方法
        /// <summary>
        /// Returns the named logger if it exists
        /// </summary>
        /// <remarks>
        /// <para>If the named logger exists (in the default hierarchy) then it
        /// returns a reference to the logger, otherwise it returns
        /// <c>null</c>.</para>
        /// </remarks>
        /// <param name="name">The fully qualified logger name to look for</param>
        /// <returns>The logger found, or null</returns>
        public static IMyLog Exists(string name)
        {
            return Exists(Assembly.GetCallingAssembly(), name);
        }

        /// <summary>
        /// Returns the named logger if it exists
        /// </summary>
        /// <remarks>
        /// <para>If the named logger exists (in the specified domain) then it
        /// returns a reference to the logger, otherwise it returns
        /// <c>null</c>.</para>
        /// </remarks>
        /// <param name="domain">the domain to lookup in</param>
        /// <param name="name">The fully qualified logger name to look for</param>
        /// <returns>The logger found, or null</returns>
        public static IMyLog Exists(string domain, string name)
        {
            return WrapLogger(LoggerManager.Exists(domain, name));
        }

        /// <summary>
        /// Returns the named logger if it exists
        /// </summary>
        /// <remarks>
        /// <para>If the named logger exists (in the specified assembly's domain) then it
        /// returns a reference to the logger, otherwise it returns
        /// <c>null</c>.</para>
        /// </remarks>
        /// <param name="assembly">the assembly to use to lookup the domain</param>
        /// <param name="name">The fully qualified logger name to look for</param>
        /// <returns>The logger found, or null</returns>
        public static IMyLog Exists(Assembly assembly, string name)
        {
            return WrapLogger(LoggerManager.Exists(assembly, name));
        }

        /// <summary>
        /// Returns all the currently defined loggers in the default domain.
        /// </summary>
        /// <remarks>
        /// <para>The root logger is <b>not</b> included in the returned array.</para>
        /// </remarks>
        /// <returns>All the defined loggers</returns>
        public static IMyLog[] GetCurrentLoggers()
        {
            return GetCurrentLoggers(Assembly.GetCallingAssembly());
        }

        /// <summary>
        /// Returns all the currently defined loggers in the specified domain.
        /// </summary>
        /// <param name="domain">the domain to lookup in</param>
        /// <remarks>
        /// The root logger is <b>not</b> included in the returned array.
        /// </remarks>
        /// <returns>All the defined loggers</returns>
        public static IMyLog[] GetCurrentLoggers(string domain)
        {
            return WrapLoggers(LoggerManager.GetCurrentLoggers(domain));
        }

        /// <summary>
        /// Returns all the currently defined loggers in the specified assembly's domain.
        /// </summary>
        /// <param name="assembly">the assembly to use to lookup the domain</param>
        /// <remarks>
        /// The root logger is <b>not</b> included in the returned array.
        /// </remarks>
        /// <returns>All the defined loggers</returns>
        public static IMyLog[] GetCurrentLoggers(Assembly assembly)
        {
            return WrapLoggers(LoggerManager.GetCurrentLoggers(assembly));
        }

        /// <summary>
        /// Retrieve or create a named logger.
        /// </summary>
        /// <remarks>
        /// <para>Retrieve a logger named as the <paramref name="name"/>
        /// parameter. If the named logger already exists, then the
        /// existing instance will be returned. Otherwise, a new instance is
        /// created.</para>
        ///
        /// <para>By default, loggers do not have a set level but inherit
        /// it from the hierarchy. This is one of the central features of
        /// log4net.</para>
        /// </remarks>
        /// <param name="name">The name of the logger to retrieve.</param>
        /// <returns>the logger with the name specified</returns>
        public static IMyLog GetLogger(string name)
        {
            return GetLogger(Assembly.GetCallingAssembly(), name);
        }

        /// <summary>
        /// Retrieve or create a named logger.
        /// </summary>
        /// <remarks>
        /// <para>Retrieve a logger named as the <paramref name="name"/>
        /// parameter. If the named logger already exists, then the
        /// existing instance will be returned. Otherwise, a new instance is
        /// created.</para>
        ///
        /// <para>By default, loggers do not have a set level but inherit
        /// it from the hierarchy. This is one of the central features of
        /// log4net.</para>
        /// </remarks>
        /// <param name="domain">the domain to lookup in</param>
        /// <param name="name">The name of the logger to retrieve.</param>
        /// <returns>the logger with the name specified</returns>
        public static IMyLog GetLogger(string domain, string name)
        {
            return WrapLogger(LoggerManager.GetLogger(domain, name));
        }

        /// <summary>
        /// Retrieve or create a named logger.
        /// </summary>
        /// <remarks>
        /// <para>Retrieve a logger named as the <paramref name="name"/>
        /// parameter. If the named logger already exists, then the
        /// existing instance will be returned. Otherwise, a new instance is
        /// created.</para>
        ///
        /// <para>By default, loggers do not have a set level but inherit
        /// it from the hierarchy. This is one of the central features of
        /// log4net.</para>
        /// </remarks>
        /// <param name="assembly">the assembly to use to lookup the domain</param>
        /// <param name="name">The name of the logger to retrieve.</param>
        /// <returns>the logger with the name specified</returns>
        public static IMyLog GetLogger(Assembly assembly, string name)
        {
            return WrapLogger(LoggerManager.GetLogger(assembly, name));
        }

        /// <summary>
        /// Shorthand for <see cref="LogManager.GetLogger(string)"/>.
        /// </summary>
        /// <remarks>
        /// Get the logger for the fully qualified name of the type specified.
        /// </remarks>
        /// <param name="type">The full name of <paramref name="type"/> will
        /// be used as the name of the logger to retrieve.</param>
        /// <returns>the logger with the name specified</returns>
        public static IMyLog GetLogger(System.Type type)
        {
            return GetLogger(Assembly.GetCallingAssembly(), type.FullName);
        }

        /// <summary>
        /// Shorthand for <see cref="LogManager.GetLogger(string)"/>.
        /// </summary>
        /// <remarks>
        /// Get the logger for the fully qualified name of the type specified.
        /// </remarks>
        /// <param name="domain">the domain to lookup in</param>
        /// <param name="type">The full name of <paramref name="type"/> will
        /// be used as the name of the logger to retrieve.</param>
        /// <returns>the logger with the name specified</returns>
        public static IMyLog GetLogger(string domain, System.Type type)
        {
            return WrapLogger(LoggerManager.GetLogger(domain, type));
        }

        /// <summary>
        /// Shorthand for <see cref="LogManager.GetLogger(string)"/>.
        /// </summary>
        /// <remarks>
        /// Get the logger for the fully qualified name of the type specified.
        /// </remarks>
        /// <param name="assembly">the assembly to use to lookup the domain</param>
        /// <param name="type">The full name of <paramref name="type"/> will
        /// be used as the name of the logger to retrieve.</param>
        /// <returns>the logger with the name specified</returns>
        public static IMyLog GetLogger(Assembly assembly, System.Type type)
        {
            return WrapLogger(LoggerManager.GetLogger(assembly, type));
        }

        #endregion

        #region 帮助类

        /// <summary>
        /// Lookup the wrapper object for the logger specified
        /// </summary>
        /// <param name="logger">the logger to get the wrapper for</param>
        /// <returns>the wrapper for the logger specified</returns>
        private static IMyLog WrapLogger(ILogger logger)
        {
            return (IMyLog)s_wrapperMap.GetWrapper(logger);
        }

        /// <summary>
        /// Lookup the wrapper objects for the loggers specified
        /// </summary>
        /// <param name="loggers">the loggers to get the wrappers for</param>
        /// <returns>Lookup the wrapper objects for the loggers specified</returns>
        private static IMyLog[] WrapLoggers(ILogger[] loggers)
        {
            IMyLog[] results = new IMyLog[loggers.Length];
            for (int i = 0; i < loggers.Length; i++)
            {
                results[i] = WrapLogger(loggers[i]);
            }
            return results;
        }

        /// <summary>
        /// Method to create the <see cref="ILoggerWrapper"/> objects used by
        /// this manager.
        /// </summary>
        /// <param name="logger">The logger to wrap</param>
        /// <returns>The wrapper for the logger specified</returns>
        private static ILoggerWrapper WrapperCreationHandler(ILogger logger)
        {
            return new MyLogImpl(logger);
        }
        #endregion
    }

    #endregion

    #region 自定义属性相关
    /// <summary>
    /// 把我们定义的属性转换为log4net所能识别的属性
    /// </summary>
    public class CustomLayout : PatternLayout
    {
        public CustomLayout()
        {
            this.AddConverter("property", typeof(ReflectionPatternConverter));
        }
    }
    /// <summary>
    /// 重写 PatternLayout
    /// </summary>
    public class ReflectionPatternConverter : PatternLayoutConverter
    {
        /// <summary>
        /// 重写 PatternLayout
        /// </summary>
        /// <param name="writer"></param>
        /// <param name="loggingEvent"></param>
        protected override void Convert(System.IO.TextWriter writer, log4net.Core.LoggingEvent loggingEvent)
        {
            if (Option != null)
            {
                WriteObject(writer, loggingEvent.Repository, LookupProperty(Option, loggingEvent));
            }
            else
            {
                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;
            propertyValue = loggingEvent.Properties[property];
            return propertyValue;
        }
    }
    #endregion

    #region 数据库日志相关
    /// <summary>
    /// 将数据库链接字符串独立出来
    /// </summary>
    public class MyAdoNetAppender : AdoNetAppender
    {
        private static IMyLog _Log;
        private string _ConnectionStringName;
        public string ConnectionStringName
        {
            get { return _ConnectionStringName; }
            set { _ConnectionStringName = value; }
        }
        protected static IMyLog Log
        {
            get
            {
                if (_Log == null)
                    _Log = MyLogManager.GetLogger(typeof(MyAdoNetAppender));
                return _Log;
            }
        }
        public override void ActivateOptions() { PopulateConnectionString(); base.ActivateOptions(); }

        /// <summary>
        /// 获取或设置数据库连接字符串
        /// </summary>
        private void PopulateConnectionString()
        {
            // 如果配置文件中设置了ConnectionString,则返回
            if (!String.IsNullOrEmpty(ConnectionString)) return;
            // 如果配置文件中没有设置ConnectionStringName,则返回
            if (String.IsNullOrEmpty(ConnectionStringName)) return;
            // 获取对应Web.config中的连接字符串配置
            ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[ConnectionStringName];
            if (settings == null)
            {
                if (Log.IsErrorEnabled)
                    Log.ErrorFormat("Connection String Name not found in Configuration: {0}", ConnectionStringName);
                return;
            }
            //返回解密的连接字符串
            ConnectionString = settings.ConnectionString;// new DESEncrypt().Decrypt(settings.ConnectionString, null);
        }
    }
    #endregion


5、添加调用方法

public class Log4NetHelper
    {
        /// <summary>
        /// 记录系统日志
        /// </summary>
        /// <param name="msgLevel">日志级别</param>
        /// <param name="className">类名称</param>
        /// <param name="funName">方法名</param>
        /// <param name="msg">日志内容</param>
        public static void Log(Log4NetService.MsgLevel msgLevel, string className, string funName, string msg)
        {
            LoginUser loginUser = LoginHelper.GetLoginUser();
            Hashtable parasHashtable = new Hashtable();
            parasHashtable.Add("UserId", loginUser == null ? "" : loginUser.MemberId.ToString()); //form表单提交的数据
            parasHashtable.Add("IP", IPHelper.Instance().AcceptIP()); //Url 参数
            parasHashtable.Add("FunName", funName);
            Log4NetService.Instance.Log(msgLevel, className, parasHashtable, msg);
        }
    }


通过以上配置,调用日志服务就可实现日志记录功能了,MVC项目如需自动记录系统异常日志,可参照以下方法实现:

6、新增特性,可对单个Action指定该特性,也可注册为全局特性(所有Action)

[AttributeUsage(AttributeTargets.Class | AttributeTargets.Method, AllowMultiple = false)]
    public class Log4NetFilterAttribute : ActionFilterAttribute, IExceptionFilter
    {
        #region 错误日志

        public void OnException(ExceptionContext filterContext)
        {
            if (!filterContext.ExceptionHandled)
            {
                //记录日志
                Log4NetHelper.Log(Log4NetService.MsgLevel.Error,
                    filterContext.Controller.GetType().ToString(), filterContext.RequestContext.RouteData.Values["action"].ToString(),
                    filterContext.Exception.Message);
                //设置异常已经处理
                filterContext.ExceptionHandled = true;

                //错误页跳转
                filterContext.HttpContext.Response.Redirect("/home/500");
            }
        }
        #endregion

    }

7、将特性在项目的Global.asax文件注册为全局特性

 public class MvcApplication : System.Web.HttpApplication
    {
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            RegisterGlobalFilters(GlobalFilters.Filters);
        }

        public static void RegisterGlobalFilters(GlobalFilterCollection filters)
        {
            filters.Add(new Log4NetFilterAttribute());
        }
    }

这样,MVC项目就可以自动记录数据到数据库了。

  • 1
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值