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

/// 

        /// 写入sql查询句日志
        /// 
        /// 
        public virtual void WriteLog(string commandText)
        {
            string fileName = DateTime.Now.ToString(SystemInfo.DateFormat) + " _ " + this.FileName;
            WriteLog(commandText, fileName);
        }

        /// 

		/// 写入sql查询句日志
		/// 
		/// 异常
        /// 文件名
		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 + @"LogQuery";
			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 + @"LogQuery";
            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();
        }