ASP.NET MVC5 實現分頁查詢的示例代碼

//數據總量
int dataCount;
//每頁顯示的數據條數
int pageDataCount;
int pageNumber;

//總頁數
int pageCount = (int)Math.Ceiling(dataCount/ (pageDataCount* 1.0));
int startLine = (pageNumber - 1) * PageDataCount + 1;
int endLine=startLine + PageDataCount - 1;

protected IDbConnection CreateConnection()
{
 IDbConnection dbConnection = new SqlConnection(ConnectionString);
 dbConnection.Open();
 return dbConnection;
}

//獲取數據庫中數據的總條數
public virtual int QueryDataCount(string tableName)
{
 using (IDbConnection dbConnection = CreateConnection())
 {
 var queryResult = dbConnection.Query<int>("select count(Id) from " + tableName);
 if (queryResult == null || !queryResult.Any())
 {
 return 0;
 }
 return queryResult.First();
 }
}

public virtual IEnumerable<T> RangeQuery<T>(string tableName, int startline, int endline)
{
 if (string.IsNullOrEmpty(tableName))
 {
 throw new ArgumentNullException("表名不得為空或null");
 }
 if (startline <= 0)
 {
 throw new ArgumentOutOfRangeException("起始行號必須大于0");
 }
 if (endline - startline < 0)
 {
 throw new ArgumentOutOfRangeException("結束行號不得小于起始行號");
 }
 using (IDbConnection dbConnection = CreateConnection())
 {
 var queryResult = dbConnection.Query<T>("select top " + (endline - startline + 1) + " * from " + tableName + " where Id not in (select top " + (startline - 1) + " Id from " + tableName + " order by Id desc) order by Id desc");
 if (queryResult != null && queryResult.Any())
 {
 return queryResult;
 }
 }
 return null;
}

@*
 amount：數據總數，count：每頁顯示的數據條數，redierctUrl點擊按鈕時的跳轉鏈接
 頁面上需引用：bootstrap.min.css
*@
@helper CreatePaginateButton(int amount, int count, string redirectUrl)
{
 <div id="pagenumber" style="position:fixed;bottom:-15px;text-align:center;width:84%">
 <nav style="text-align:center">
 <ul class="pagination">
 <li><a href="@redirectUrl/1" rel="external nofollow" >首頁</a></li>
 @{
 int pageNumber = (int)Math.Ceiling(amount / (count * 1.0));
 pageNumber = pageNumber < 1 ? 1 : pageNumber;
 //頁面上顯示的按鈕數目（不計首頁、末頁、上一頁、下一頁等按鈕），若頁面總數超過該值則繪制按鈕分隔符
 const int BUTTON_COUNT = 7;
 // 按鈕分隔符
 const string BUTTON_SEPARATOR = "......";
 //按鈕分隔符左側按鈕數目（不計首頁、末頁、上一頁、下一頁等按鈕）
 const int LEFT_BUTTON_COUNT = 4;
 //按鈕分隔符右側按鈕數目（不計首頁、末頁、上一頁、下一頁等按鈕）
 const int RIGHT_BUTTON_COUNT = 2;

 string[] urlSegments = Request.Url.Segments;
 int selectedIndex = 0;
 int.TryParse(urlSegments[urlSegments.Length - 1], out selectedIndex);
 int previous = (selectedIndex - 1) <= 0 ? 1 : selectedIndex - 1;
 int next = (selectedIndex + 1 > pageNumber) ? pageNumber : selectedIndex + 1;
 var r=Request.Cookies[""];
 if (pageNumber > BUTTON_COUNT)
 {
 <li><a id="next" href="@redirectUrl/@previous" rel="external nofollow" >上一頁</a></li>
 for (int i = 1; i <= BUTTON_COUNT; i++)
 {
 if ( selectedIndex >= LEFT_BUTTON_COUNT && selectedIndex%LEFT_BUTTON_COUNT==0 && i <= LEFT_BUTTON_COUNT)
 {
 <li><a name="pageButton" id="@selectedIndex" href="@redirectUrl/@selectedIndex" rel="external nofollow" >@selectedIndex</a></li>
 int step = selectedIndex;
 int tag = 0;
 for (i = 1; i <= LEFT_BUTTON_COUNT; i++)
 {
 tag = i + step;
 if (tag > pageNumber - RIGHT_BUTTON_COUNT)
 {
 if (i <= LEFT_BUTTON_COUNT)
 {
 i = LEFT_BUTTON_COUNT + 1;
 }
 break;
 }
 <li><a name="pageButton" id="@tag" href="@redirectUrl/@tag" rel="external nofollow" rel="external nofollow" >@tag</a></li>
 }
 }
 else if (i <= LEFT_BUTTON_COUNT && selectedIndex<LEFT_BUTTON_COUNT)
 {
 <li><a name="pageButton" id="@i" href="@redirectUrl/@i" rel="external nofollow" rel="external nofollow" >@i</a></li>
 }
 else if (i < LEFT_BUTTON_COUNT && selectedIndex>LEFT_BUTTON_COUNT)
 {
 int step = selectedIndex / LEFT_BUTTON_COUNT;
 int tag = 0;
 <li><a name="pageButton" id="@(step*LEFT_BUTTON_COUNT)" href="@redirectUrl/@(step*LEFT_BUTTON_COUNT)" rel="external nofollow" >@(step*LEFT_BUTTON_COUNT)</a></li>
 for (i = 1; i <= LEFT_BUTTON_COUNT; i++)
 {
 tag = i + step * LEFT_BUTTON_COUNT;
 if (tag > pageNumber - RIGHT_BUTTON_COUNT)
 {
 if (i <= LEFT_BUTTON_COUNT)
 {
 i = LEFT_BUTTON_COUNT + 1;
 }
 break;
 }
 <li><a name="pageButton" id="@tag" href="@redirectUrl/@tag" rel="external nofollow" rel="external nofollow" >@tag</a></li>
 }
 }
 //繪制按鈕分隔符右側按鈕
 if (i==BUTTON_COUNT-1)
 {
 <li><a name="pageButton" id="@(pageNumber-1)" href="@redirectUrl/@(pageNumber-1)" rel="external nofollow" >@(pageNumber-1)</a></li>
 }
 else if(i==BUTTON_COUNT)
 {
 <li><a name="pageButton" id="@pageNumber" href="@redirectUrl/@pageNumber" rel="external nofollow" rel="external nofollow" >@pageNumber</a></li>
 }
 //繪制按鈕分隔符
 else if (i >= BUTTON_COUNT -RIGHT_BUTTON_COUNT)
 {
 <li><span name="pageButton">@BUTTON_SEPARATOR</span></li>
 }
 }
 <li><a id="next" href="@redirectUrl/@next" rel="external nofollow" >下一頁</a></li>
 }
 else
 {
 for (int i = 1; i <= pageNumber; i++)
 {
 <li><a name="pageButton" id="@i" href="@redirectUrl/@i" rel="external nofollow" rel="external nofollow" >@i</a></li>
 }
 }
 }
 <li><a href="@redirectUrl/@pageNumber" rel="external nofollow" rel="external nofollow" >末頁</a></li>
 </ul>
 </nav>
 </div>
 <script>
 $(function () {
 //設置被選中按鈕的背景色
 var selected = $('#@selectedIndex');
 if (selected != undefined) {
 selected.css('background-color', '#E1E1E1');
 }
 </script>
}

@PageHelper.CreatePaginateButton(246, 10, "/usermanager/attentionlist/")