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

2022-08-30 12:30:17

在实际开发或试运行过程中，我们有时需要查看或分析模块执行的所有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();

        }