萬盛學電腦網

 萬盛學電腦網 >> 網絡編程 >> asp編程 >> ASP無組件分頁實現思路及代碼

ASP無組件分頁實現思路及代碼

 MVC下: 

後台代碼:   代碼如下: public ActionResult sys(string page)  {  if (page == null)  {  string sql = "select top 15 * from dingdinfo ORDER BY dingdh desc";  ViewData["ds"] = dr.resultSet(sql, "dingdinfo");  }  if (page != null)  {  int pageSL = Convert.ToInt32(page);  string sql = "select top 15 * from dingdinfo where id not in (select top " + (pageSL - 1) * 15 + " id from dingdinfo order by dingdh desc )ORDER BY dingdh desc";  ViewData["ds"] = dr.resultSet(sql, "dingdinfo");  }  //計算pageCount  string sql1 = "select * from dingdinfo";  int pageCount = dr.resultCount(sql1,"dingdinfo");  int Chu = Convert.ToInt32(pageCount / 15);  int yuS = Convert.ToInt32(pageCount % 15);  if (pageCount > 15)  {  int pageJG = Chu;  if (yuS != 0)  {  pageJG = Chu + 1;  ViewData["jg"] = pageJG;  }  else  {  ViewData["jg"] = pageJG;  }  }  return View();  }    頁面顯示:  JS代碼:   代碼如下: <script type="text/javascript">  //分頁  function Page(id) {  window.location = "/bookIndex/sys/?page=" + id;  }  </script>    HTML代碼:   代碼如下: <td>  <% int count =Convert.ToInt32(ViewData["jg"]);  if (count != 0)  {  for (int i = 1; i <=count; i++)  { %>  <a href = "#" onclick="Page(<%:i%>)"><%:i%></a>  <% }  }%>  </td>   
copyright © 萬盛學電腦網 all rights reserved