62,046
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// linq分页
/// < SPAN>summary>
/// <typeparam name="T">< SPAN>typeparam>
/// <param name="List">实现IEnumerable< SPAN>param>
/// <param name="FunWhere">delegate检索条件< SPAN>param>
/// <param name="FunOrder">delegate排序< SPAN>param>
/// <param name="PageSize">每页显示数< SPAN>param>
/// <param name="PageIndex">当前页码< SPAN>param>
/// <returns>< SPAN>returns>
static IEnumerable<T> GetIenumberable<T>(IEnumerable<T> List, Func<T,
bool> FunWhere, Func<T, string> FunOrder, int PageSize, int PageIndex)
{
var rance = List.Where(FunWhere).OrderByDescending(FunOrder).
Select(t => t).Skip((PageIndex - 1) * PageSize).Take(PageSize);
return rance;
}
SELECT TOP 页大小 *
FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1
) A
WHERE RowNumber > 页大小*(页数-1)