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

时间:2022-09-18 13:52:43
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> 

页面最终效果: 
ASP无组件分页实现思路及代码