using Common;
using System.Collections;
using System.Data;
using System.Text;
using Model;

namespace DataBase
{
    public interface IDbHelper
    {
        //string ExecuteByProcReturn { get; set; }
        DataTable GetDataTableBySQL(StringBuilder sql);

        DataRow GetDataRowBySQL(StringBuilder sql);

        DataTable GetDataTableBySQL(StringBuilder sql,string tableName);

        DataTable GetDataTableBySQL(StringBuilder sql, SqlParam[] param,string tableName);

        IDataReader GetDataReaderBySQL(StringBuilder sql);

        IDataReader GetDataReaderBySQL(StringBuilder sql, SqlParam[] param);

        int InsertByHashtableNullParam(string tableName, Hashtable ht);


        int InsertByHashtable(string tableName, Hashtable ht);

        int UpdateByHashtable(string tableName, string pkName, string pkVal, Hashtable ht);

        int UpdateByHashtables(string tableName, string pkName, string pkVal, Hashtable ht);

        int UpdateByHashtable(string tableName, string pkName, object[] pkValues, Hashtable ht);

        int UpdateByHashtableA(string tableName, string pkName, object[] pkValues, Hashtable ht);

        int UpdateByHashtable(string tableName, Hashtable ht1, Hashtable ht);

        DataTable GetPageList(string sql, SqlParam[] param, string orderField, string orderType, ref PageInfo pageInfo);

        int DeleteData(string tableName, string pkName, string pkVal);

        int DeleteData(string tableName, Hashtable ht);

        int BatchDeleteData(string tableName, string pkName, object[] pkValues);

        int IsExist(string tableName, string pkName, string[] pkValues);

        int IsExist(string tableName, Hashtable ht);
        int IsExist(string tableName, string pkName, string[] pkValues, Hashtable ht);
        int ExecuteBySql(StringBuilder strSql);

        int ExecuteBySql(StringBuilder strSql,SqlParam[] param);

        int ExecuteByProcReturn(string procName, Hashtable ht, ref Hashtable rs);

        #region add liudl ¹«¹²·½·¨
        bool IsExist(string tableName, string sqlwhere);
        #endregion
    }
}