/// 分页查询 /// <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)); } }
/// 查询简单sql /// <summary> /// 查询简单sql /// </summary> /// <param name="sql"></param> /// <returns></returns> public DataTable GetDataTable(string sql) { using (OracleDataBase db = new OracleDataBase()) { return(db.ExecuteDataTable(sql)); } }