icommonaccess.cs

此项目是用asp.net开发的航班查询系统

using System;
using System.Collections;
using System.Data;

namespace OceanSoft.Data
{
	/// <summary>
	/// 通用数据访问接口
	/// </summary>
	public interface ICommonAccess
	{
		/// <summary>
		/// 命令字符串属性
		/// </summary>
		string CommandString{get;set;}

		/// <summary>
		/// 命令参数集属性
		/// </summary>
		Hashtable CommandParams{get;set;}

		/// <summary>
		/// 是否是存储过程属性
		/// </summary>
		bool IsStoredProcedure{get;set;}

		/// <summary>
		/// 开始事务
		/// </summary>
		void BeginTrans();

		/// <summary>
		/// 提交事务
		/// </summary>
		void CommitTrans();

		/// <summary>
		/// 回滚事务
		/// </summary>
		void RollbackTrans();


		/// <summary>
		/// 打开数据库的连接,得到命令对象
		/// </summary>
		void Open();

		/// <summary>
		/// 关闭数据连接
		/// </summary>
		void Close();

		/// <summary>
		/// 得到数据库连接对象
		/// </summary>
		/// <returns>连接对象</returns>
		IDbConnection GetConnection();

		/// <summary>
		/// 得到打开连接的命令对象
		/// </summary>
		/// <returns>命令对象</returns>
		IDbCommand GetCommand();

		/// <summary>
		///得到空数据适配对象 
		/// </summary>
		/// <returns>空数据适配对象</returns>
		IDbDataAdapter GetNullDataAdapter();

		/// <summary>
		/// 得到数据流对象
		/// </summary>
		/// <returns>数据流对象</returns>
		IDataReader GetDataReader();

		/// <summary>
		/// 运行SQL语句
		/// </summary>
		/// <returns>受影响的行数</returns>
		int RunSql();

		/// <summary>
		/// 运行SQL语句,得到第一行第一列值
		/// </summary>
		/// <returns>第一行第一列值</returns>
		object GetScalar();

		/// <summary>
		/// 得到DataSet
		/// </summary>
		/// <param name="mTableName">表名</param>
		/// <returns>对应的DataSet</returns>
		DataSet GetDataSet(string mTableName);

		/// <summary>
		/// 得到DataSet
		/// </summary>
		/// <returns>对应的DataSet</returns>
		DataSet GetDataSet();

		/// <summary>
		/// 得到DataTable
		/// </summary>
		/// <param name="mTableName">表名</param>
		/// <returns>对应的DataTable</returns>
		DataTable GetDataTable(string mTableName);

		/// <summary>
		/// 得到DataTable
		/// </summary>
		/// <returns>对应的DataTable</returns>
		DataTable GetDataTable();

        /// <summary>
        /// 填充DataSet
        /// </summary>
        /// <param name="mDataSet">对应的DataSet</param>
        void Fill(DataSet mDataSet);

        /// <summary>
        /// 填充DataTable
        /// </summary>
        /// <param name="mDataTable">对应的DataTable</param>
        void Fill(DataTable mDataTable);
	}
}