public DataTable Select_Sql_Return_Page(SqlCommand cmd, SqlPageQuery pageQuery, out string err) { if (string.IsNullOrEmpty(pageQuery.Sort)) { throw new Exception("Sort不可为空"); } int count = Select_Sql_Return_Count(cmd.CommandText, cmd.Params); pageQuery.TotalCount = count; string Sql = @"SELECT TOP {0} * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {1}) AS RowNumber,* FROM ({2}) AS _TABLE_A )AS _TABLE_B WHERE RowNumber>{3} ORDER BY RowNumber"; Sql = string.Format(Sql , pageQuery.PageSize , pageQuery.Sort , cmd.CommandText , pageQuery.PageSize * (pageQuery.PageIndex - 1)); cmd.CommandText = Sql; DataTable DT = Select_Sql_Return_DataTable(cmd, out err); return(DT); }
/// <summary> /// 分页获取数据 /// </summary> /// <param name="table"></param> /// <param name="pageQuery"></param> /// <param name="err"></param> /// <returns></returns> public DataTable Select_Sql_Return_Page(string table, SqlPageQuery pageQuery, out string err) { return(Select_Sql_Return_Page(new SqlCommand(table, null), pageQuery, out err)); }