idbutils.cs

基于C/S的医疗卫生管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace Qeb.Support.DataAccess
{
    public interface IDBUtils
    {
        #region ExecuteNonQuery
        /// <summary>
		/// 执行 Transact-SQL 语句并返回受影响的行数
		/// </summary>
		/// <param name="sql">dbCommand</param>
		/// <returns>SQL语句所影响的记录数</returns>
		int ExecuteNonQuery(IDbCommand dbCommand);

        #endregion

		#region ExecuteScalar

		/// <summary>
		/// 执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。
		/// </summary>
        /// <param name="sql">dbCommand</param>
		/// <returns>第一行第一列的值</returns>
        object ExecuteScalar(IDbCommand dbCommand);

		#endregion

		#region Seqence or AutoID

		/// <summary>
		/// 获取序列或自动增长值的下一个值
		/// </summary>
		/// <param name="identity">获取值标识</param>
		/// <returns>增长值</returns>
        string GetNextID(string identity);

		/// <summary>
		/// 获取序列或自动增长值的当前值
		/// </summary>
		/// <param name="identity">获取值标识</param>
		/// <returns>当前值</returns>
        string GetCurrentID(string identity);

		#endregion

		#region FillDataSet

        /// <summary>
        /// 填充DataTable
        /// </summary>
        /// <param name="table"></param>
        /// <param name="dbCommand"></param>
        void Fill(DataTable table, IDbCommand dbCommand);

        /// <summary>
        /// 填充DataTable
        /// </summary>
        /// <param name="table"></param>
        /// <param name="dbCommand"></param>
        /// <param name="pageIndex">当前页数</param>
        /// <param name="pageSize">当前页显示的记录数</param>
        void Fill(DataTable table, IDbCommand dbCommand,int pageIndex, int pageSize);
		#endregion

        #region 事务控制
        void BeginTransaction();

        void BeginTransaction(IsolationLevel level);

        void Commit();

        void Rollback();
        #endregion

        IDbCommand NewCommand();

        IDataParameter NewParameter();

        void CloseDB();
    }
}