自由分页代码：
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<%set string category_title=get_category_title(category_id,"")%>
<title>{category_title} - {config.webname}</title>
<meta content="{model.seo_keywords}" name="keywords" />
<meta content="{model.seo_description}" name="description" />
{model.seo_title}
<link rel="stylesheet" type="text/css" href="<%templateskin%>/css/base.css" />
<link rel="stylesheet" type="text/css" href="<%templateskin%>/css/subpage.css" />
<link rel="stylesheet" type="text/css" href="<%templateskin%>/css/public.css" />
<script type="text/javascript" src="<%templateskin%>/js/jquery1.42.min.js"></script>
<script type="text/javascript" src="<%templateskin%>/js/jquery.SuperSlide.2.1.1.js"></script>
<script type="text/javascript" src="<%templateskin%>/js/jquery.carouFredSel-6.0.4-packed.js"></script>
</head>
<body>
<!--header--->
<!--页头star-->
<%template src="_header.html"%>
<!--页头end-->
<!--main---->
<div id="main">
<div class="main">
<div class="add_bar">
当前位置:<a href="/">首页</a><span>>></span>图片中心
</div>
<div class="sub_content">
<%csharp%>
//分页sql语句请确保和上面的写法一致
StringBuilder sbcount= new StringBuilder();
sbcount.Append("select COUNT(*) ");
sbcount.Append("from dt_article a, ");
sbcount.Append("dt_channel c ");
sbcount.Append("where a.img_url<>'' and a.channel_id=c.id ");
sbcount.Append("and (c.name='gov'OR c.name='edu'OR c.name='party'OR c.name='personnel'OR c.name='maser'OR c.name='collection'OR c.name='flash'OR c.name='award'OR c.name='message'OR c.name='study') ");
sbcount.Append(" ");
int total=NetWingGetAnyCount(sbcount.ToString());
sbcount.Clear();
int pagesize=20;
int page=1;
int start=1;
int nextpage=1;
int firstpage=1;
int end=20;
int allpage=(int)(total/pagesize);
if(!string.IsNullOrEmpty(Request["page"])){
page=int.Parse(Request["page"]);
if(page<allpage){
nextpage=page+1;
}else{
nextpage=page;
}
if(page!=1){
firstpage=page-1;
}
start=pagesize*(page-1)+1;
end=pagesize*page;
}
//显示中间的页码s
string mdpage="";//中间的页码
//小于9页也就是8页的时候
if(page<=9){
for(int i=1;i<=9;i++){ if(i==page){
mdpage=mdpage+"<span class='current'>"+page+"</span>";
}
else{
mdpage=mdpage+"<a href='/photo_list.aspx?page="+i+"'>"+i+"</a>";
}
}
}
//在末尾的情况
if((page+9)>=allpage){
for(int i=(allpage-8);i<=allpage;i++){
if(i==page){
mdpage=mdpage+"<span class='current'>"+page+"</span>";
}
else{
mdpage=mdpage+"<a href='/photo_list.aspx?page="+i+"'>"+i+"</a>";
}
}
}
//在末尾的情况
//中间的情况s
if(((page+9)<allpage) && page>9){
for(int i=(page-4);i<=(page+4);i++){
if(i==page){
mdpage=mdpage+"<span class='current'>"+page+"</span>";
}
else{
mdpage=mdpage+"<a href='/photo_list.aspx?page="+i+"'>"+i+"</a>";
}
}
}
//中间的情况e
//显示中间的页码e
//分页sql语句请确保和上面的写法一致
StringBuilder sb= new StringBuilder();
sb.Append("Select * FROM ( ");
sb.Append("SELECT ROW_NUMBER()Over(order by a.add_time desc) rowId, ");
sb.Append("a.id aid, ");
sb.Append("a.title atitle, ");
sb.Append("a.img_url aimg_url, ");
sb.Append("c.name+'_show' cname ");
sb.Append("from dt_article a, ");
sb.Append("dt_channel c ");
sb.Append("where a.img_url<>'' and a.channel_id=c.id ");
sb.Append("and (c.name='gov'OR c.name='edu'OR c.name='party'OR c.name='personnel'OR c.name='maser'OR c.name='collection'OR c.name='flash'OR c.name='award'OR c.name='message'OR c.name='study') ");
sb.Append(") mytable ");
sb.Append(" WHERE rowId between "+start+" and "+end+" --分页条件 ");
string thissql=sb.ToString();
sb.Clear();
<%/csharp%>
<!--图说警事图片列表---->
<ul class="police">
<%set DataTable jdDt=NetWingGetAnyTable({thissql})%>
<%loop jdDr jdDt%>
<li>
<div class="police_pic">
<a href="/{jdDr[cname]}.aspx?id={jdDr[aid]}"><img src="{jdDr[aimg_url]}"></a>
</div>
<p><a href="/{jdDr[cname]}.aspx?id={jdDr[aid]}"><%cutstring({jdDr[atitle]},20)%></a></p>
</li>
<%/loop%>
</ul>
</div>
<div class="yema"><span>共{total}记录,{allpage}页</span><a href="?page={firstpage}">«上一页</a>{mdpage}<a href="?page={nextpage}">下一页»</a></div>
</div>
</div>
<!--footer---->
<!--底部 开始-->
<%template src="_footer.html"%>
<!--底部 结束-->
</body>
</html>
Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4
