MESProductionWeb/AntORM/Ant.Data/DataAccess/DataAccess.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using System.Data;
using System.Xml;
namespace Ant.Data
{
    /// <summary>
    ///  数据库访问接口
    /// </summary>
    public interface DataAccess : IDisposable
    {
        #region Property & method

        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        string ConnectionString { get; set; }
        /// <summary>
        /// 获取数据库类型
        /// </summary>
        DatabaseType DatabaseType { get; }


        /// <summary>
        /// 数据库是否关闭//是：已经关闭，否：未关闭；
        /// </summary>
        bool IsClosed { get; }

        /// <summary>
        /// 数据库连接是否不可用
        /// </summary>
        bool IsUnEnable { get; }

        /// <summary>
        /// 事务
        /// </summary>
        DbTransaction Trans { get; }

        /// <summary>
        /// 打开数据库连接
        /// </summary>
        void Open();
        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        void Close();
        /// <summary>
        /// 开启一个事务
        /// </summary>
        void BeginTransaction();
        /// <summary>
        /// 提交一个事务
        /// </summary>
        void Commit();
        /// <summary>
        /// 回滚一个事务
        /// </summary>
        void RollBack();
        #endregion

        #region ExecuteNonQuery
        int ExecuteNonQuery(string commandText);
        int ExecuteNonQuery(string commandText, CommandType commandType);
        int ExecuteNonQuery(string commandText, QueryParameterCollection Parameters);
        int ExecuteNonQuery(string commandText, CommandType commandType, QueryParameterCollection Parameters);
        #endregion

        #region ExecuteDataReader
        DbDataReader ExecuteDataReader(string commandText);
        DbDataReader ExecuteDataReader(string commandText, CommandType commandType);
        DbDataReader ExecuteDataReader(string commandText, QueryParameterCollection Parameters);
        DbDataReader ExecuteDataReader(string commandText, CommandType commandType, QueryParameterCollection Parameters);
        DbDataReader ExecuteReader(string cmdText, DbParam[] parameters, CommandType cmdType);

        DbDataReader ExecuteReader(string cmdText, DbParam[] parameters, CommandBehavior be, CommandType cmdType);

        #endregion

        object ExecuteScalar(string commandText, DbParam[] parameters);

        object ExecuteScalar(string commandText, DbParam[] parameters, System.Data.CommandType commandType);

        int ExecuteNonQuery(string commandText, DbParam[] Parameters);



        #region ExecuteDataTable
        DataTable ExecuteDataTable(string commandText);
        DataTable ExecuteDataTable(string commandText, CommandType commandType);
        DataTable ExecuteDataTable(string commandText, QueryParameterCollection Parameters);
        DataTable ExecuteDataTable(string commandText, CommandType commandType, QueryParameterCollection Parameters);
        DataTable ExecuteDataTable(string commandText, CommandType commandType, QueryParameterCollection Parameters, string tableName);
        DataTable ExecuteDataTable(string commandText, int startRecord, int maxRecords);
        DataTable ExecuteDataTable(string commandText, CommandType commandType, int startRecord, int maxRecords);
        DataTable ExecuteDataTable(string commandText, QueryParameterCollection Parameters, int startRecord, int maxRecords);
        DataTable ExecuteDataTable(string commandText, QueryParameterCollection Parameters, string tableName);
        DataTable ExecuteDataTable(string commandText, CommandType commandType, QueryParameterCollection Parameters, int startRecord, int maxRecords);
        DataTable ExecuteDataTable(string commandText, CommandType commandType, QueryParameterCollection Parameters, string tableName, int startRecord, int maxRecords);

        #endregion

        #region ExecuteDataSet
        DataSet ExecuteDataSet(string commandText);
        DataSet ExecuteDataSet(string commandText, CommandType commandType);
        DataSet ExecuteDataSet(string commandText, QueryParameterCollection Parameters);
        DataSet ExecuteDataSet(string commandText, QueryParameterCollection Parameters, string tableName);
        DataSet ExecuteDataSet(string commandText, CommandType commandType, QueryParameterCollection Parameters);
        DataSet ExecuteDataSet(string commandText, CommandType commandType, QueryParameterCollection Parameters, string tableName);
        DataSet ExecuteDataSet(string commandText, int startRecord, int maxRecords);
        DataSet ExecuteDataSet(string commandText, CommandType commandType, int startRecord, int maxRecords);
        DataSet ExecuteDataSet(string commandText, QueryParameterCollection Parameters, int startRecord, int maxRecords);
        DataSet ExecuteDataSet(string commandText, CommandType commandType, QueryParameterCollection Parameters, int startRecord, int maxRecords);
        DataSet ExecuteDataSet(string commandText, CommandType commandType, QueryParameterCollection Parameters, string tableName, int startRecord, int maxRecords);

        #endregion

        #region ExecuteDataView
        /// <summary>
        /// 视图
        /// </summary>
        /// <param name="commandText"></param>
        /// <param name="commandType"></param>
        /// <param name="Parameters"></param>
        /// <param name="tableName"></param>
        /// <param name="startRecord"></param>
        /// <param name="maxRecords"></param>
        /// <returns></returns>
        DataView ExecuteDataView(string commandText, CommandType commandType, QueryParameterCollection Parameters, string tableName, int startRecord, int maxRecords);

        #endregion

        #region ExecuteScalar
        /// <summary>
        /// 执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。
        /// </summary>
        /// <param name="commandText">SQL命令文本</param>
        /// <returns>查询所返回的结果集中第一行的第一列</returns>
        object ExecuteScalar(string commandText);
        /// <summary>
        /// 执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。
        /// </summary>
        /// <param name="commandText">SQL命令文本</param>
        /// <param name="commandType">命令类型</param>
        /// <returns>查询所返回的结果集中第一行的第一列</returns>
        object ExecuteScalar(string commandText, CommandType commandType);
        /// <summary>
        /// 执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。
        /// </summary>
        /// <param name="commandText">SQL命令文本</param>
        /// <param name="parameters">参数集合</param>
        /// <returns>查询所返回的结果集中第一行的第一列</returns>
        object ExecuteScalar(string commandText, QueryParameterCollection parameters);
        /// <summary>
        /// 执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。
        /// </summary>
        /// <param name="commandText"SQL命令文本></param>
        /// <param name="commandType">命令类型</param>
        /// <param name="parameters">参数集合</param>
        /// <returns>查询所返回的结果集中第一行的第一列</returns>
        object ExecuteScalar(string commandText, CommandType commandType, QueryParameterCollection parameters);
        #endregion

        #region 验证SQL语句是否正确
        bool ValidateSQL(string sql);
        #endregion

    }
}