自己写的 Log日志记录类,支持文件和数据库,自动建立Log表格,刚学设计模式,大家别见笑。
文件:ILog.cs代码
using
System;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
namespace
LZ2007.Function.Log
![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 日志通用接口
/// </summary>
public interface ILog
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
void Info(string message, int level);
void Info(string message);
void Warn(string message, int leave);
void Warn(string message);
void Debug(string message, int leave);
void Debug(string message);
void Error(string message, Exception e, int leave);
void Error(string message, Exception e);
void Fatal(string message, Exception e, int leave);
void Fatal(string message, Exception e);
void Close();
}
}
文件LogManage.cs代码
using
System;
using
System.Data;
using
System.Configuration;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
namespace
LZ2007.Function.Log
![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 日志工厂类
/// </summary>
public static class LogFactory
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
public static ILog GetLog(Type objType)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
int _LogType = Convert.ToInt32(ConfigurationManager.AppSettings["eLogType"]);
ILog log = null;
if (_LogType == 1)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
log = new DataBaseLog(objType);
}
else if(_LogType==0)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
log = new FileLog(objType);
}
return log;
}
}
}
文件DataBaseLog.cs代码
using
System;
using
System.Data;
using
System.Configuration;
using
System.Web;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
using
System.Data.SqlClient;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
namespace
LZ2007.Function.Log
![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 数据库日志类.
/// </summary>
public class DataBaseLog : ILog
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/7ff8d92cded7e0ce15e7ca1acc870052.gif)
私有变量申明#region 私有变量申明
private string _LogConnStr;
private string _LogObjectSource;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private bool _isDebug;
private bool _isInfo;
private bool _isError;
private bool _isWarn;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private SqlConnection _sqlConn;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
public bool IsDebug
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
get ...{ return _isDebug; }
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
set ...{ _isDebug = value; }
}
public bool IsInfo
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
get ...{ return _isInfo; }
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
set ...{ _isInfo = value; }
}
public bool IsError
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
get ...{ return _isError; }
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
set ...{ _isError = value; }
}
public bool IsWarn
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
get ...{ return _isWarn; }
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
set ...{ _isWarn = value; }
}
#endregion
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
public DataBaseLog(Type objType)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
_isDebug = Convert.ToBoolean(ConfigurationManager.AppSettings["eLogDebug"]);
_isInfo = Convert.ToBoolean(ConfigurationManager.AppSettings["eLogInfo"]);
_isError = Convert.ToBoolean(ConfigurationManager.AppSettings["eLogError"]);
_isWarn = Convert.ToBoolean(ConfigurationManager.AppSettings["eLogWarn"]);
_LogObjectSource = objType.FullName;
//_LogType = Convert.ToInt32(ConfigurationManager.AppSettings["eLogType"]);
_LogConnStr = ConfigurationManager.AppSettings["eLogConnStr"];
_sqlConn = new SqlConnection(_LogConnStr);
Init();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void Init()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
//检查是否有该表
string strTest = "select count(name)as a1 from sysobjects where id = object_id(N’[LOGSYSTEM]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
//建立表
string strSQL = "CREATE TABLE [dbo].[LOGSYSTEM] (" +
"[lId] [int] IDENTITY (1, 1) NOT NULL ," +
"[lMessage] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ," +
"[lLevel] [int] NULL ," +
"[lSource] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ," +
"[lException] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ," +
"[lType] [int] NULL ," +
"[lDate] [datetime] NULL ," +
"[lADDIT1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ," +
"[lADDIT2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ," +
"[lADDIT3] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL " +
") ON [PRIMARY]";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
_sqlConn.Open();
SqlCommand sqlcomm = new SqlCommand(strTest, _sqlConn);
int i = (int)sqlcomm.ExecuteScalar(); ;
if (i == 0)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
sqlcomm = new SqlCommand(strSQL, _sqlConn);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
sqlcomm.ExecuteNonQuery();
}
sqlcomm.Dispose();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private int insertLog(string message, int level, string source, string exception, int type)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
string strSQL = "INSERT INTO LOGSYSTEM(lMessage,lLevel,lSource,lException,lType,lDate) " +
"VALUES (@lMessage,@lLevel,@lSource,@lException,@lType,@lDate)";
SqlCommand sqlcomm = new SqlCommand(strSQL, _sqlConn);
if (_sqlConn.State == ConnectionState.Closed)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
_sqlConn.Open();
}
sqlcomm.Parameters.Add("@lMessage", SqlDbType.NVarChar, 1000);
sqlcomm.Parameters["@lMessage"].Direction = ParameterDirection.Input;
sqlcomm.Parameters["@lMessage"].Value = message;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
sqlcomm.Parameters.Add("@lLevel", SqlDbType.Int);
sqlcomm.Parameters["@lLevel"].Direction = ParameterDirection.Input;
sqlcomm.Parameters["@lLevel"].Value = level;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
sqlcomm.Parameters.Add("@lSource", SqlDbType.NVarChar, 100);
sqlcomm.Parameters["@lSource"].Direction = ParameterDirection.Input;
sqlcomm.Parameters["@lSource"].Value = source;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
sqlcomm.Parameters.Add("@lException", SqlDbType.NVarChar, 100);
sqlcomm.Parameters["@lException"].Direction = ParameterDirection.Input;
sqlcomm.Parameters["@lException"].Value = exception;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
sqlcomm.Parameters.Add("@lType", SqlDbType.Int);
sqlcomm.Parameters["@lType"].Direction = ParameterDirection.Input;
sqlcomm.Parameters["@lType"].Value = type;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
sqlcomm.Parameters.Add("@lDate", SqlDbType.DateTime);
sqlcomm.Parameters["@lDate"].Direction = ParameterDirection.Input;
sqlcomm.Parameters["@lDate"].Value = DateTime.Now;
return sqlcomm.ExecuteNonQuery();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
public void Close()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.Info("Log End", 5);
_sqlConn.Close();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)