using System;
using System.Data;
namespace ETD.Data
{
    /// <summary>
    /// 
    /// </summary>
    public interface IDBHandlerble : IDisposable
    {
        /// <summary>
        /// 添加参数
        /// </summary>
        /// <param name="paramName">参数名称</param>
        /// <param name="paramType">参数类型</param>
        /// <param name="p_objDirection">参数方向</param>
        /// <returns>返回执行结果</returns>
        void AddParameter(string paramName, DbType paramType, ParameterDirection p_objDirection);
        /// <summary>
        /// 重载-添加参数
        /// </summary>
        /// <param name="paramName">参数名称</param>
        /// <param name="paramType">参数类型</param>
        /// <param name="p_objDirection">参数方向</param>
        /// <param name="pValue">参数值</param>
        /// <returns>返回执行结果</returns>
        void AddParameter(string paramName, DbType paramType, ParameterDirection p_objDirection, object pValue);
        /// <summary>
        /// 添加有长度的参数
        /// </summary>
        /// <param name="paramName">参数名称</param>
        /// <param name="paramType">参数类型</param>
        /// <param name="paramSize">参数长度</param>
        /// <param name="p_objDirection">参数方向</param>
        /// <returns>返回执行结果</returns>
        void AddParameter(string paramName, DbType paramType, int paramSize, ParameterDirection p_objDirection);
        /// <summary>
        /// 重载-添加有长度的参数
        /// </summary>
        /// <param name="paramName">参数名称</param>
        /// <param name="paramType">参数类型</param>
        /// <param name="paramSize">参数长度</param>
        /// <param name="p_objDirection">参数方向</param>
        /// <param name="pValue">参数值</param>
        /// <returns>返回执行结果</returns>
        void AddParameter(string paramName, DbType paramType, int paramSize, ParameterDirection p_objDirection, object pValue);
        /// <summary>
        /// 启动事务处理
        /// </summary>
        void BeginTransaction();
        /// <summary>
        /// 提交事务处理
        /// </summary>
        void CommitTransaction();
        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        /// <returns>返回执行结果状态码</returns>
        void ConnectionClose();
        /// <summary>
        /// 打开数据连接
        /// </summary>
        /// <returns>返回执行结果状态码</returns>
        void ConnectionOpen();
        /// <summary>
        /// 返回数据适配器
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <returns>返回执行结果</returns>
        IDbDataAdapter ExecuteAdapter(string commandText);
        /// <summary>
        /// 重载-返回数据适配器(适应存储过程调用需求)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <returns>返回执行结果</returns>
        IDbDataAdapter ExecuteAdapter(string commandText, CommandType commandType);
        /// <summary>
        /// 返回数据集
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <returns>返回执行结果</returns>
        DataSet ExecuteDataSet(string commandText);
        /// <summary>
        /// 重载-返回数据集(适应存储过程调用需求)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <returns>返回执行结果</returns>
        DataSet ExecuteDataSet(string commandText, CommandType commandType);
        /// <summary>
        /// 重载-返回数据集(适应存储过程调用需求)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="tableName">表名</param>
        /// <returns>返回执行结果</returns>
        DataSet ExecuteDataSet(string commandText, CommandType commandType, string tableName);
        /// <summary>
        /// 重载-返回数据集(适应存储过程调用需求)
        /// </summary>
        /// <param name="dataSetName">DataSet 名称</param>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="tableName">表名</param>
        /// <returns>返回执行结果</returns>
        DataSet ExecuteDataSet(string dataSetName, string commandText, CommandType commandType, string tableName);
        /// <summary>
        /// 返回数据表
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <returns>返回执行结果</returns>
        DataTable ExecuteDataTable(string commandText);
        /// <summary>
        /// 返回数据表
        /// </summary>
        /// <param name="commandText"></param>
        /// <param name="isCloseConnection"></param>
        /// <returns>返回执行结果</returns>
        DataTable ExecuteDataTable(string commandText, bool isCloseConnection);
        /// <summary>
        /// 重载-返回数据表
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <returns>返回执行结果</returns>
        DataTable ExecuteDataTable(string commandText, CommandType commandType);
        /// <summary>
        /// 重载-返回数据表
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="tableName">表名</param>
        /// <returns>返回执行结果</returns>
        DataTable ExecuteDataTable(string commandText, CommandType commandType, string tableName);
        /// <summary>
        /// 重载-返回数据表
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="tableName">表名</param>
        /// <param name="isCloseConnection">是否关闭数据库</param>
        /// <returns>返回执行结果</returns>
        DataTable ExecuteDataTable(string commandText, CommandType commandType, string tableName, bool isCloseConnection);
        /// <summary>
        /// 返回数据表(分页)
        /// </summary>
        /// <param name="page">当前页</param>
        /// <param name="pageSize">每页显示数</param>
        /// <param name="recordCount">总记录数</param>
        /// <param name="strFields">需要查询的字段</param>
        /// <param name="strOrderBy">排序字段，例如： id asc,name desc 不带order by</param>
        /// <param name="strTableName">查询表名称,如果是复杂查询传入(select * from ...)</param>
        /// <returns></returns>
        DataTable ExecuteDataTable(int page, int pageSize, ref int recordCount, string strFields, string strOrderBy, string strTableName);
        /// <summary>
        /// 执行无返回类型数据查询(返回影响行数)
        /// </summary>
        /// <param name="commandText">查询命令(SQL语句)</param>
        /// <returns>返回执行结果影响行数</returns>
        int ExecuteNonQuery(string commandText);
        /// <summary>
        /// 执行无返回类型数据查询(返回影响行数)
        /// </summary>
        /// <param name="commandText">查询命令(SQL语句)</param>
        /// <param name="isCloseConnection">是否关闭数据连结,true: 关闭,false: 不关闭</param>
        /// <returns>返回执行结果影响行数</returns>
        int ExecuteNonQuery(string commandText, bool isCloseConnection);
        /// <summary>
        /// 重载-无返回类型数据查询(适应存储过程调用需求且返回影响行数)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <returns>返回执行结果影响行数</returns>
        int ExecuteNonQuery(string commandText, CommandType commandType);
        /// <summary>
        /// 重载-无返回类型数据查询(适应存储过程调用需求且返回影响行数)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="isCloseConnection">是否关闭数据连结,true: 关闭,false: 不关闭</param>
        /// <returns>返回执行结果影响行数</returns>
        int ExecuteNonQuery(string commandText, CommandType commandType, bool isCloseConnection);
        /// <summary>
        /// 返回向前只读数据集查询
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <returns>返回执行结果</returns>
        IDataReader ExecuteReader(string commandText);
        /// <summary>
        /// 重载-返回向前只读数据集查询(适应存储过程调用需求)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <returns>返回执行结果</returns>
        IDataReader ExecuteReader(string commandText, CommandType commandType);
        /// <summary>
        /// 重载-返回向前只读数据集查询(适应存储过程调用需求)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="p_objBehaviour">提供对查询结果和查询对数据库的影响的说明</param>
        /// <returns>返回执行结果</returns>
        IDataReader ExecuteReader(string commandText, CommandType commandType, CommandBehavior p_objBehaviour);
        /// <summary>
        /// 返回第一行第一列结果的数据查询
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <returns>返回查询结果</returns>
        object ExecuteScalar(string commandText);
        /// <summary>
        /// 返回第一行第一列结果的数据查询
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="isCloseConnection">是否关闭数据连结,true: 关闭,false: 不关闭</param>
        /// <returns>返回查询结果</returns>
        object ExecuteScalar(string commandText, bool isCloseConnection);
        /// <summary>
        /// 重载-返回第一行第一列结果的数据查询(适应存储过程调用需求)
        /// </summary>
        /// <param name="commandText">查询命令</param>
        /// <param name="commandType">查询命令类型</param>
        /// <param name="isCloseConnection">是否关闭数据连结,true: 关闭,false: 不关闭</param>
        /// <returns>返回查询结果</returns>
        object ExecuteScalar(string commandText, CommandType commandType, bool isCloseConnection);
        /// <summary>
        /// 获得数据库连接字符串
        /// </summary>
        /// <param name="ModuleName">模块名称</param>
        /// <returns></returns>
        string GetDataLink(string ModuleName);
        /// <summary>
        /// 提取参数值
        /// </summary>
        /// <param name="paramName">参数名称</param>
        /// <returns>返回执行结果</returns>
        object GetParameter(string paramName);
        /// <summary>
        /// 将DataTable添加到DataSet中
        /// </summary>
        /// <param name="dataSet">DataSet对象</param>
        /// <param name="tableNames">表名数组</param>
        void LoadDataSet(DataSet dataSet, string[] tableNames);
        /// <summary>
        /// 将DataTable添加到DataSet中
        /// </summary>
        /// <param name="dataSet">DataSet对象</param>
        /// <param name="tableName">表名</param>
        void LoadDataSet(DataSet dataSet, string tableName);
        /// <summary>
        /// 修改参数值
        /// </summary>
        /// <param name="paramName">参数名称</param>
        /// <param name="pValue">参数值</param>
        void ModifyParameter(string paramName, object pValue);
        /// <summary>
        /// 移除所有的参数
        /// </summary>
        void RemoveAllParameters();
        /// <summary>
        /// 移除参数
        /// </summary>
        /// <param name="paramName">参数名称</param>
        void RemoveParameter(string paramName);
        /// <summary>
        /// 回滚事务处理
        /// </summary>
        void RollbackTransaction();
    }
}