/// 分页查询
/// <summary>
/// 分页查询
/// </summary>
/// <param name="sql"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="total"></param>
/// <returns></returns>
public DataTable GetDataTable(string sql, int pageIndex, int pageSize, out int total)
{
using (OracleDataBase db = new OracleDataBase())
{
return(db.ExecuteDataTable(sql, pageIndex, pageSize, out total));
}
}
/// 查询总数
/// <summary>
/// 查询总数
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public int GetDataTableCount(string sql)
{
using (OracleDataBase db = new OracleDataBase())
{
return(db.ExecuteDataTableCount(sql, null));
}
}
/// 查询简单sql
/// <summary>
/// 查询简单sql
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public DataTable GetDataTable(string sql)
{
using (OracleDataBase db = new OracleDataBase())
{
return(db.ExecuteDataTable(sql));
}
}
