/// <summary>
/// 查询数据
/// </summary>
/// <param name="top">返回的记录数</param>
/// <param name="sql_where">查询条件</param>
/// <param name="sql_order">排序条件</param>
/// <returns>结果数据表</returns>
public DataSet QueryRecords(int top, string sql_where, string sql_order)
{
string sql_select = CreateSQL.Select(this.GetTableName(), top, sql_where, sql_order);
if (CheckData.IsStringNull(sql_select))
{
return(new DataSet());
}
DataSet ds = DbHelperSQL.Query(sql_select);
return(ds);
}
/// <summary>
/// 分页查询数据
/// </summary>
/// <param name="pageCount">定义: 每页记录数</param>
/// <param name="pageIndex">定义: 浏览到第几页</param>
/// <param name="recordCount">得到: 总记录数</param>
/// <param name="sql_where">定义: 查询条件</param>
/// <param name="sql_order">定义: 字段排序集合, true 为正序, false 倒序</param>
/// <returns>结果数据表</returns>
public DataSet QueryRecords(int pageCount, int pageIndex, out int recordCount, string sql_where, string sql_order)
{
if (CheckData.IsStringNull(sql_order))
{
throw new Exception(@"分页查询 排序条件必须存在!");
}
recordCount = GetRecordCount(sql_where);
string sql_select = CreateSQL.Select(this.GetTableName(), 0, sql_where, string.Empty);
string sql_paging = PagingHelper.CreatePagingSql(recordCount, pageCount, pageIndex, sql_select, sql_order);
if (CheckData.IsStringNull(sql_paging))
{
return(new DataSet());
}
DataSet ds = DbHelperSQL.Query(sql_paging);
return(ds);
}
