/// <summary>
    /// 数据库执行拦截
    /// </summary>
    public class EFIntercepterLogging : DbCommandInterceptor
    {
       
        private readonly Stopwatch _stopwatch = new Stopwatch();  

        public override void ScalarExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext<object> interceptionContext)
        {
            base.ScalarExecuting(command, interceptionContext);  
            _stopwatch.Restart();
        }
        public override void ScalarExecuted(System.Data.Common.DbCommand command, DbCommandInterceptionContext<object> interceptionContext)
        { 
            _stopwatch.Stop();
            AuditLog aLog = InitLog(command);
            IDbContext currentDB = (IDbContext)interceptionContext.DbContexts.Where(q => q.GetType() == typeof(EFContext)).FirstOrDefault();
            if (aLog != null)
            {
                if (interceptionContext.Exception != null)
                {
                    aLog.SqlQuery = (string.Format("Exception:{1} \r\n --> Error executing command: {0}", command.CommandText, interceptionContext.Exception.ToString()));
                }
                else
                {
                    aLog.SqlQuery = (string.Format("\r\n执行时间:{0} 毫秒\r\n-->ScalarExecuted.Command:{1}\r\n", _stopwatch.ElapsedMilliseconds, command.CommandText));
                }

                if (currentDB != null)
                {
                     
                    currentDB.Entry(aLog).State = EntityState.Added;
                    currentDB.Set<AuditLog>().Add(aLog);
                    currentDB.SaveChangesAsync();
                }
            }

            base.ScalarExecuted(command, interceptionContext);
        }
        public override void NonQueryExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext<int> interceptionContext)
        {
            base.NonQueryExecuting(command, interceptionContext);
            _stopwatch.Restart();
        }
        public override void NonQueryExecuted(System.Data.Common.DbCommand command, DbCommandInterceptionContext<int> interceptionContext)
        {
            _stopwatch.Stop();
            AuditLog aLog = InitLog(command);
            IDbContext currentDB = (IDbContext)interceptionContext.DbContexts.Where(q => q.GetType() == typeof(EFContext)).FirstOrDefault();
            if (aLog != null)
            {
                if (interceptionContext.Exception != null)
                {
                    aLog.SqlQuery = (string.Format("Exception:{1} \r\n --> Error executing command:\r\n {0}", command.CommandText, interceptionContext.Exception.ToString()));
                }
                else
                {
                    aLog.SqlQuery = (string.Format("\r\n执行时间:{0} 毫秒\r\n-->NonQueryExecuted.Command:\r\n{1}", _stopwatch.ElapsedMilliseconds, command.CommandText));
                }
                if (currentDB != null)
                { 
                    currentDB.Entry(aLog).State = EntityState.Added;
                    currentDB.Set<AuditLog>().Add(aLog);
                    currentDB.SaveChangesAsync();
                }
            }

            base.NonQueryExecuted(command, interceptionContext);
        }
        public override void ReaderExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext<System.Data.Common.DbDataReader> interceptionContext)
        {
            base.ReaderExecuting(command, interceptionContext);
            _stopwatch.Restart();
        }
        public override void ReaderExecuted(System.Data.Common.DbCommand command, DbCommandInterceptionContext<System.Data.Common.DbDataReader> interceptionContext)
        {
            _stopwatch.Stop();
            IDbContext currentDB = (IDbContext)interceptionContext.DbContexts.Where(q=>q.GetType() == typeof(EFContext)).FirstOrDefault();
              
            AuditLog aLog = InitLog(command);
            if (aLog != null)
            {
                if (interceptionContext.Exception != null)
                {
                    aLog.SqlQuery = (string.Format("Exception:{1} \r\n --> Error executing command:\r\n {0}", command.CommandText, interceptionContext.Exception.ToString()));
                }
                else
                {
                    aLog.SqlQuery = (string.Format("\r\n执行时间:{0} 毫秒 \r\n -->ReaderExecuted.Command:\r\n{1}", _stopwatch.ElapsedMilliseconds, command.CommandText));
                }
                //repo.Insert<AuditLog>(aLog);
                //repo.SaveChanges();

                if (currentDB != null)
                { 
                    currentDB.Entry(aLog).State = EntityState.Added;
                    currentDB.Set<AuditLog>().Add(aLog);
                    currentDB.SaveChangesAsync(); 
                }
            }

            base.ReaderExecuted(command, interceptionContext);
        }

        private AuditLog InitLog(System.Data.Common.DbCommand command)
        {
            AuditLog log = new AuditLog();

            HttpContextBase context = new HttpContextWrapper(HttpContext.Current);
            RouteData rd = RouteTable.Routes.GetRouteData(context);
            if (rd != null)
            {
                string controllerName = rd.GetRequiredString("controller");
                string actionName = rd.GetRequiredString("action");
                string userName = HttpContext.Current.User.Identity.Name;
                string parms = "";
                if(command!=null)
                {
                   foreach(DbParameter parm in command.Parameters)
                    {
                        parms += string.Format(" 参数名:{0},值:{1};",parm.ParameterName,parm.Value);
                    }
                }


                //排除审计控制器自身 以及日志插入自身
                if (actionName.Contains(SystemConsts.ExceptedController_Audit)
                    || command.CommandText.Contains(SystemConsts.ExceptedTable_AuditLog))
                    return null;

                log.Controller = controllerName;
                log.Action = actionName;
                log.StartTime = DateTime.Now;
                log.EndTime = DateTime.Now;
                log.AuditAccount = userName;
               // log.IP = IPHelper.GetRealIP();
                log.Parameters = parms; 
            }
            return log;
        }
    }