www.gusucode.com > 凡人网络购物系统 2008源码程序 > allp.asp

    <!--#include file="conn.asp"-->
<%page=request("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)%>
<!--#include file="IncAsp/venshop_top.asp"-->
<div align="center">
<table cellpadding="0" cellspacing="0" class="all_t1">
<tr><td class="all_l_td" valign="top" height=300><!--#include file="IncAsp/venshop_log.asp"--><div class="d5"></div></td>
<td valign="top" class="all_c_td">
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<%set rs=server.CreateObject("adodb.recordset")
sql="select pinpai_id,pinpai_logo,pinpai_name from venshop_pinpai order by pinpai_xu DESC,pinpai_id DESC"
rs.open sql,conn,1,1
if rs.eof then%><tr><td align="center" height="30">No DATA</td></tr><%else
rs.pagesize=60
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize%>
<tr><td height="23" class="sort">&nbsp;<IMG src="Skin/<%=venshop_skin%>/home.gif" border=0 align="absmiddle"> 您的位置：  
<a href="index.asp">首页</a> >>&nbsp;品牌列表&nbsp;(共<%=totalrec%>品牌，这是第<%=(page-1)*rs.pagesize+1%>-<%if page+1<=totalpage then%><%=page*rs.pagesize%><%else%><%=totalrec%><%end if%>个)</td></tr>
<tr><td height=200 valign=top>

<table width="100%" border="0" cellpadding="3" cellspacing="0">
<%i=0
do while not rs.eof and (i<rs.pagesize)
i=i+1%>
<%if (i mod 6)=1 then%><tr><%end if%>
<td width="10%" align="center">
<p style="margin-top: 5px; margin-bottom: 5px"><a target="_blank" href="pinpai.asp?pinpai_id=<%=rs("pinpai_id")%>"><%if rs("pinpai_logo")<>"" then%><img border="0" src="<%=rs("pinpai_logo")%>" style="border: 1px solid #000000" width="80"><%else%><%=rs("pinpai_name")%><%end if%></a>
</td>
<%if (i mod 6)=0 then%></tr><%end if%>
<%rs.movenext
loop%>
</table>
</td></tr>
<form action="allp.asp" method=post>
<tr><td height="23" class="sortb"> 
<p style="line-height: 150%; margin: 5px">第<%=page%>页/共<%=totalpage%>页&nbsp;&nbsp;
<%if page-1>0 then%><a href="allp.asp?page=<%=page-1%>">上一页</a>  <%else%>上一页 <%end if%>
<%if page+1<=totalpage then%> <a href="allp.asp?page=<%=page+1%>">下一页</a> <%else%> 下一页 <%end if%>
第<input type="text" name="page" value="<%=page+1%>" size="1">页<input type="submit" value="GO">
<br>选择页数：<%for i=1 to totalpage
if i=page then%>
<font color="#FF0000"><b><%=i%></b></font>
<%else%>
<a href="allp.asp?page=<%=i%>"><%=i%></a>
<%end if
next%></td></tr></form><%end if
rs.close
set rs=nothing%></table></td></tr></table></div><!--#include file="IncAsp/venshop_copy.asp"-->