/// <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); }