摘要:
1,直接通过sql语句分页 int Skip = (PageIndex - 1) * PageSize; int Take = PageSize; string strIsDesc = IsDesc ? "desc" : "asc"; StringBuilder sb = new StringBuilder(); sb.Append("with temp as (select top " + (Skip + Take)); sb.Append(" ROW_NUMBER() OVER(ORDER BY " + Ord 阅读全文