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

namespace DbAccess
{
   public interface ISysSqlHelper
    {
        /// <summary>
        /// 执行SQL语句，返回影响的记录数
        /// </summary>
        /// <param name="SQLString"></param>
        /// <returns></returns>
        int ExecuteNonQuery(string SQLString);

        /// <summary>
        /// 执行多条SQL语句，实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList"></param>
        void ExecuteSqlTran(ArrayList SQLStringList);

        /// <summary>
        /// 执行查询语句，返回DataSet
        /// </summary>
        /// <param name="SQLString"></param>
        /// <returns></returns>
        DataSet ExecuteDataSet(string SQLString);

        /// <summary>
        /// 执行查询语句，返回DataTable
        /// </summary>
        /// <param name="SQLString"></param>
        /// <returns></returns>
        DataTable ExecuteDataTable(string SQLString);

        /// <summary>
        /// 返回数据表(分页)
        /// </summary>
        /// <param name="page">当前页</param>
        /// <param name="pageSize">每页显示数</param>
        /// <param name="recordCount">总记录数</param>
        /// <param name="strSql"></param>
        /// <returns></returns>
        DataTable ExecuteDataTable(int page, int pageSize, ref int recordCount, string strSql);

        /// <summary>
        /// 返回数据表(分页)
        /// </summary>
        /// <param name="page"></param>
        /// <param name="pageSize"></param>
        /// <param name="recordCount"></param>
        /// <param name="strSql"></param>
        /// <param name="tableName"></param>
        /// <param name="strWhere"></param>
        /// <returns></returns>
        DataTable ExecuteDataTable(int page, int pageSize, ref int recordCount, string strSql, string tableName, string strWhere);

        /// <summary>
        /// 返回查询的所有结果，突破rds的1万条的限制
        /// </summary>
        /// <param name="strSql"></param>
        /// <returns></returns>
        DataTable ExecuteDataTableAll(string strSql);

        /// <summary>
        /// 执行一条计算查询结果语句，返回查询结果（object）。
        /// </summary>
        /// <param name="SQLString"></param>
        /// <returns></returns>
        object ExecuteScalar(string SQLString);

        /// <summary>
        /// 获取数据库连接字符串
        /// </summary>
        /// <param name="keyName"></param>
        /// <returns></returns>
        //string GetDataBaseInfo(string keyName);
        string GetConnectString();
    }
}