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