📄 cp_list.asp
字号:
<!--#include file="main.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=citytitle%></title>
<body topmargin="0">
<%SMT_TOP%>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td valign="top" width="570">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td valign="top">
<!--==================-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="95" background="img/pagounew_20.jpg" height="30" style="color:#ffffff"> <strong class=f14>产品分类</strong></td>
<td background="img/pagounew_22.jpg" align="center">
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align=center>
<tr><td height=5></td></tr>
<tr>
<td>
<!---->
<table width="80%" border="0" cellspacing="0" cellpadding="0" align="center">
<%set rs=server.createobject("adodb.recordset")
sql="select * from SMT_ypxxtwo where SMT_ypxxone_id="&request("id")&" order by SMT_date desc"
rs.open sql,conn,1,1%>
<tr>
<%n=0
do while not rs.eof
n=n+1
set rs1=server.createobject("adodb.recordset")
sql1="select * from SMT_cp where SMT_key=1 and SMT_key1=1 and SMT_key2=1 and SMT_ypxxtwo_id="&rs("SMT_ypxxtwo_id")
rs1.open sql1,conn,1,1
twocount=rs1.recordcount
rs1.close%>
<td height=30 width=33% valign=top>
<a href=cp_vlist.asp?id=<%=rs("SMT_ypxxtwo_id")%>><%=rs("SMT_ypxxtwo")%></a> <font color=red>(<%=twocount%>)</font>
</td>
<%if n mod 3=0 then response.write("</tr><tr>")
rs.movenext
loop%>
</tr>
<%rs.close%>
</table>
<!---->
</td>
</tr>
</table>
<!--==================-->
</td>
</tr>
</table>
<!--##############################################################-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" style="border-top:1px #cccccc solid">
<tr>
<td valign="top">
<!--==================-->
<table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">
<tr bgcolor="#FFE2DA"><th height=30>图片</th><th>主题</th></tr>
<%sql="select * from SMT_cp where SMT_key=1 and SMT_key1=1 and SMT_key2=1 and SMT_ypxxone_id="&request("id")&" order by SMT_id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<tr><td height=194 colspan=5 align=center>暂无内容</td></tr>"
else
'分页的实现
listnum=12
Rs.pagesize=listnum
page=Request("page")
if (page-Rs.pagecount) > 0 then
page=Rs.pagecount
elseif page = "" or page < 1 then
page = 1
end if
Rs.absolutepage=page
'编号的实现
j=rs.recordcount
j=j-(page-1)*listnum%>
<%i=0
nn=request("page")
if nn="" then
n=0
else
nn=nn-1
n=listnum*nn
end if
do while not rs.eof and i<listnum
n=n+1
set rs1=server.createobject("adodb.recordset")
sql1="select * from SMT_yp where SMT_id="&rs("SMT_yp_id")
rs1.open sql1,conn,1,1
if not rs1.eof then
goname=rs1("SMT_user")
goid=rs1("SMT_id")
coname=rs1("SMT_coname")
addtwo_id=rs1("SMT_addtwo_id")
svip=rs1("SMT_vip")
set rs2=server.createobject("adodb.recordset")
sql2="select * from SMT_ypaddtwo where SMT_addtwo_id="&addtwo_id
rs2.open sql2,conn,1,1
coadd=" <font color=0000ff>["&rs2("SMT_addone")&"/"&rs2("SMT_addtwo")&"]</font>"
rs2.close
end if
rs1.close%>
<!--#include file="dns/dns.asp"-->
<tr <%if n mod 2=0 then response.write "bgcolor=efefef"%>>
<td width="110" align="center"><a href=cp_view.asp?id=<%=rs("SMT_id")%> target="_blank"><img src="<%=rs("SMT_pic")%>" width="80" height="80" style="border:1px #000000 solid"></a></td>
<td width="460" valign=top><p style="line-height:150%"><font color=#000000><strong><a href=cp_view.asp?id=<%=rs("SMT_id")%> target="_blank"><%=rs("SMT_cpname")%></a></strong></font><br><a href=<%=usertwourl%> target=_blank><%=coname%></a> <%if svip=2 then%><img src="img/vip.gif" title="VIP会员"><%end if%> <%=coadd%><br>
<%=trim(rs("SMT_cpjm"))%></td>
</tr>
<tr><td background="img/list_line_1.gif" colspan=2></td></tr>
<%rs.movenext
i=i+1
j=j-1
loop%>
<tr>
<%filename="cp_list.asp?id="&request("id")%>
<td colspan=6 align=right bgcolor=#FFE2DA height=20><strong><font color=FF6C00><%=rs.recordcount%></font></strong>条信息 共<strong><font color=FF6C00><%=Rs.pagecount%></font></strong>页
<% if page=1 then %>
<%else%>
<a href=<%=filename%>><strong>|<<</strong></a>
<a href=<%=filename%>&page=<%=page-1%>><strong><<</strong></a>
<a href=<%=filename%>&page=<%=page-1%>><strong>[<%=page-1%>]</strong></a>
<%end if%><% if Rs.pagecount=1 then %>
<%else%><strong>[<%=page%>]</strong>
<%end if%>
<% if Rs.pagecount-page <> 0 then %>
<a href=<%=filename%>&page=<%=page+1%>><strong>[<%=page+1%>]</strong></a>
<a href=<%=filename%>&page=<%=page+1%>><strong>>></strong></a>
<a href=<%=filename%>&page=<%=Rs.pagecount%>><strong>>>|</strong></a>
<%end if%> </td>
<%end if%></tr>
<tr><td colspan=5 height=4></td></tr>
</table>
<%rs.close%>
<!--==================-->
</td>
</tr>
</table>
</td>
<!--======== end left ==========-->
<td width="10"></td>
<!--======== right ==========-->
<td width="180" valign="top" background="img/pa_bg9.jpg" style="background-repeat:repeat-y;border:1px #cccccc solid">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td height=30 background="img/bgtitle1.gif" width="180"> <font color=#ffffff><strong>产品信息推荐</strong></font></td>
</tr>
<tr><td height=5></td></tr>
<%set rs=server.createobject("adodb.recordset")
sql="select top 10 * from SMT_cp where SMT_key=1 and SMT_key1=1 and SMT_key2=1 and SMT_key3=1 order by SMT_id desc"
rs.open sql,conn,1,1
do while not rs.eof
cpname=rs("SMT_cpname")%>
<tr><td height=90 align=center><a href=cp_view.asp?id=<%=rs("SMT_id")%> target="_blank"><img src="<%=rs("SMT_pic")%>" border="0" width=80 height=80 style="border:1px #000000 solid"></a></td></tr>
<tr><td align="center" height=25><strong><a href=cp_view.asp?id=<%=rs("SMT_id")%> target="_blank"><%=LeftT(cpname,12)%></a></strong></td></tr>
<%rs.movenext
loop
rs.close%>
</table>
</td>
</tr>
</table>
<!--====== bottom ========-->
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor=#ffffff>
<tr><td height=2 bgcolor=#cc3300></td></tr>
<tr>
<td align="center" height=80><%=citybottom%></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -