using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace GoodIdea.CMS.DBUtility
{
/// <summary>
/// 数据库操作基类
/// 实现对Sql数据库的各种操作
/// 创建时间:2006-8-3
/// </summary>
public class SqlDataBase
{
//获取Web.Config数据库连接字符串
private readonly string SqlConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
private SqlConnection cn; //创建SQL连接
private SqlDataAdapter sda; //创建SQL数据适配器
private SqlDataReader sdr; //创建SQL数据读取器
private SqlCommand cmd; //创建SQL命令对象
private SqlParameter param; //创建SQL参数
private DataSet ds; //创建数据集
private DataView dv; //创建视图
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
#region
cn = new SqlConnection(SqlConnectionString);
cn.Open();
#endregion
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
#region
if (cn != null)
{
cn.Close();
cn.Dispose();
}
#endregion
}
/// <summary>
/// 返回DataSet数据集
/// </summary>
/// <param name="strSql">SQL语句</param>
public DataSet GetDs(string strSql)
{
#region
Open();
sda = new SqlDataAdapter(strSql, cn);
ds = new DataSet();
sda.Fill(ds);
Close();
return ds;
#endregion
}
/// <summary>
/// 添加DataSet表
/// </summary>
/// <param name="ds">DataSet对象</param>
/// <param name="strSql">Sql语句</param>
/// <param name="strTableName">表名</param>
public void GetDs(DataSet ds, string strSql, string strTableName)
{
#region
Open();
sda = new SqlDataAdapter(strSql, cn);
sda.Fill(ds, strTableName);
Close();
#endregion
}
/// <summary>
/// 返回DataView数据视图
/// </summary>
/// <param name="strSql">Sql语句</param>
public DataView GetDv(string strSql)
{
#region
dv = GetDs(strSql).Tables[0].DefaultView;
return dv;
#endregion
}
/// <summary>
/// 获得DataTable对象
/// </summary>
/// <param name="strSql">SQL语句</param>
/// <returns></returns>
public DataTable GetTable(string strSql)
{
#region
return GetDs(strSql).Tables[0];
#endregion
}
/// <summary>