您现在的位置: 万盛学电脑网 >> 程序编程 >> 网络编程 >> asp编程 >> 正文

ASP无组件分页实现思路及代码

作者:佚名    责任编辑:admin    更新时间:2022-06-22

 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>