RDIFramework.NET ━ .NET快速信息化系统开发框架记录所有操作的Sql

在实际开发或试运行过程中，我们有时需要查看或分析模块执行的所有sql，以便进行相关分析。有时我们可以通过数据库自带的软件抓取，如：SQL Server Profiler。在我们RDIFramework.NET框架中已经提供了对Sql执行的跟踪支持，只需要把“LogSQL”配置项设置为True即可。

WinForm配置如下图所示：

MVC配置为：Code\RDIFramework.MvcApp\XmlConfig\下的system.config

WebForm配置为：Code\RDIFramework.WebApp\下的Web.config

Web同时要指定：SystemInfo.StartupPath = HttpContext.Current.Server.MapPath("~/");

如下图所示

登录框架后，随便点击一些模块，再查看框架运行目录下的“\Log\Query\”文件夹下以日期开始的文本文件，如下图所示：

随便打开一个文件，就可以查看所有的sql，如下图：

方法参考：

/// <summary>
   /// 写入sql查询句日志
   /// </summary>
   /// <param name="commandText"></param>
   public virtual void WriteLog(string commandText)
   {
       string fileName = DateTime.Now.ToString(SystemInfo.DateFormat) + " _ " + this.FileName;
       WriteLog(commandText, fileName);
   }
 
   　　　　/// <summary>
   /// 写入sql查询句日志
   /// </summary>
   /// <param name="commandText">异常</param>
   /// <param name="fileName">文件名</param>
   public virtual void WriteLog(string commandText, string fileName = null)
   {
       if (string.IsNullOrEmpty(fileName))
       {
           fileName = DateTime.Now.ToString(SystemInfo.DateFormat) + " _ " + this.FileName;
       }
       string returnValue = string.Empty;
       // 系统里应该可以配置是否记录异常现象
       if (!SystemInfo.LogSQL)
       {
           return;
       }
       // 将异常信息写入本地文件中
       string logDirectory = SystemInfo.StartupPath + @"\\Log\\Query";
       if (!System.IO.Directory.Exists(logDirectory))
       {
           System.IO.Directory.CreateDirectory(logDirectory);
       }
       string writerFileName = logDirectory + "\\" + fileName;
       if (!File.Exists(writerFileName))
       {
           FileStream FileStream = new FileStream(writerFileName, FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite);
           FileStream.Close();
       }
       StreamWriter streamWriter = new StreamWriter(writerFileName, true, Encoding.Default);
       streamWriter.WriteLine(DateTime.Now.ToString(SystemInfo.DateTimeFormat) + " " + commandText);
       streamWriter.Close();
   }
 
   public virtual void WriteLog(string commandText, IDbDataParameter[] dbParameters = null, string fileName = null)
   {
       // 系统里应该可以配置是否记录异常现象
       if (!SystemInfo.LogSQL)
       {
           return;
       }
       if (string.IsNullOrEmpty(fileName))
       {
           fileName = DateTime.Now.ToString(SystemInfo.DateFormat) + " _ " + FileName;
       }
       string message = string.Empty;
       message = DateTime.Now.ToString(SystemInfo.DateTimeFormat) + System.Environment.NewLine + "commandText内容" + System.Environment.NewLine + commandText;
       if (dbParameters != null)
       {
           StringBuilder sb = new StringBuilder();
           foreach (var parameter in dbParameters)
           {
               sb.AppendLine(parameter.ParameterName + "=" + parameter.Value);
           }
           message += System.Environment.NewLine + "dbParameters内容" + System.Environment.NewLine + sb.ToString();
       }
       string logDirectory = SystemInfo.StartupPath + @"\Log\Query";
       if (!System.IO.Directory.Exists(logDirectory))
       {
           System.IO.Directory.CreateDirectory(logDirectory);
       }
       string writerFileName = logDirectory + "\\" + fileName;
       if (!File.Exists(writerFileName))
       {
           FileStream FileStream = new FileStream(writerFileName, FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite);
           FileStream.Close();
       }
       StreamWriter streamWriter = new StreamWriter(writerFileName, true, Encoding.Default);
       streamWriter.WriteLine(DateTime.Now.ToString(SystemInfo.DateTimeFormat) + " " + message);
       streamWriter.Close();
   }