OleDbHelper.cs
using System;
using System.Web;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.ComponentModel;
namespace OleDbHelper
{
public class OleDbHelper
{
/// 连接数据源
private OleDbConnection MyConn = null;
private readonly string RETURNVALUE = "RETURNVALUE";
/// <summary>
/// 打开数据库连接.
/// </summary>
private void Open()
{
// 打开数据库连接
if (MyConn == null)
{
MyConn = new OleDbConnection(ConfigurationManager.AppSettings["OLEDBCONNECTIONSTRING"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]));
}
if (MyConn.State == ConnectionState.Closed)
{
try
{
///打开数据库连接
MyConn.Open();
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
}
finally
{
///关闭已经打开的数据库连接
}
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
///判断连接是否已经创建
if (MyConn != null)
{
///判断连接的状态是否打开
if (MyConn.State == ConnectionState.Open)
{
MyConn.Close();
}
}
}
/// <summary>
/// 释放资源
/// </summary>
public void Dispose()
{
// 确认连接是否已经关闭
if (MyConn != null)
{
MyConn.Dispose();
MyConn = null;
}
}
private OleDbCommand TrySqlCommand(string cmdText)
{
OleDbCommand cmd = new OleDbCommand(cmdText, MyConn);
cmd.ExecuteNonQuery();
return cmd;
}
private OleDbCommand CreateSQLCommand(string cmdText)
{
Open();
OleDbCommand cmd = new OleDbCommand(cmdText, MyConn);
return cmd;
}
public void TryCmd(string cmdText)
{
OleDbCommand cmd = TrySqlCommand(cmdText);
}
public void RunCmd(string cmdText, out OleDbDataReader dataReader)
{
///创建Command
OleDbCommand cmd = CreateSQLCommand(cmdText);
try
{
///读取数据
dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
dataReader = null;
///记录错误日志
SystemError.CreateErrorLog(ex.Message);
}
}
//创建ADAPTER
private OleDbDataAdapter CreateProcDataAdapter(string cmdText)
{
///打开数据库连接
Open();
///设置SqlDataAdapter对象
OleDbDataAdapter da = new OleDbDataAdapter(cmdText, MyConn);
da.SelectCommand.CommandType = CommandType.Text;
return da;
}
}
}
SystemError.cs
using System;
using System.IO;
using System.Collections.Generic;
using System.Text;
namespace OleDbHelper
{
/// <summary>
/// 错误处理函数,用于记录错误日志
/// </summary>
public class SystemError
{
//记录错误日志位置
private static string m_fileName = System.Web.HttpContext.Current.Server.MapPath("Systemlog.log");
public static String FileName
{
get
{
return (m_fileName);
}
set
{
if (value != null || value != "")
{
m_fileName = value;
}
}
}
/// <summary>
/// 记录日志至文本文件
/// </summary>
/// <param name="message">记录的内容</param>
public static void CreateErrorLog(string message)
{
if (File.Exists(m_fileName))
{
///如果日志文件已经存在,则直接写入日志文件
StreamWriter sr = File.AppendText(FileName);
sr.WriteLine("/n");
sr.WriteLine(DateTime.Now.ToString() + message);
sr.Close();
}
else
{
///创建日志文件
StreamWriter sr = File.CreateText(FileName);
sr.Close();
}
}
}
}
SystemTools.cs
using System;
using System.Collections.Generic;
using System.Text;
namespace OleDbHelper
{
public class SystemException : Exception
{
/// <summary>
/// 包含系统Excepton
/// </summary>
public SystemException(string source, string message, Exception inner)
: base(message, inner)
{
base.Source = source;
}
/// <summary>
/// 不包含系统Excepton
/// </summary>
public SystemException(string source, string message)
: base(message)
{
base.Source = source;
}
}
/// <summary>
/// 处理网页中的HTML代码,并消除危险字符
/// </summary>
public class SystemHTML
{
private static string HTMLEncode(string fString)
{
if (fString != string.Empty)
{
///替换尖括号
fString.Replace("<", "<");
fString.Replace(">", "&rt;");
///替换引号
fString.Replace(((char)34).ToString(), """);
fString.Replace(((char)39).ToString(), "'");
///替换空格
fString.Replace(((char)13).ToString(), "");
///替换换行符
fString.Replace(((char)10).ToString(), "<BR> ");
}
return (fString);
}
}
}