www.gusucode.com > 运动用品商城网站系统源代码程序 > pinpai.asp

    <!--#include file="conn.asp"-->
<%
pinpai_id=Request("pinpai_id")
chkid(pinpai_id)
set rs=server.createobject("adodb.recordset")
sql="select pinpai_name,pinpai_logo,pinpai_content from venshop_pinpai where pinpai_id="&pinpai_id&""
rs.open sql,conn,1,1
if not rs.eof then
pinpai_name=rs("pinpai_name")
pinpai_logo=rs("pinpai_logo")
pinpai_content=rs("pinpai_content")
end if
rs.close
set rs=nothing

if Request("nsort_id")<>"" then
nsort_id=Request("nsort_id")
chkid(nsort_id)
set rs=conn.execute("select nsort_name,sort_id from venshop_nsort where nsort_id="&nsort_id&"")
if not rs.eof then
nsort_name=rs("nsort_name")
sort_id=rs("sort_id")
end if
rs.close
set rs=nothing
chkid(sort_id)
set rs=server.createobject("adodb.recordset")
sql="select sort_name from venshop_sort where sort_id="&sort_id&""
rs.open sql,conn,1,1
if not rs.eof then
sort_name=rs("sort_name")
end if
rs.close
set rs=nothing
showp="&nsort_id="&nsort_id
end if

if Request("sort_id")<>"" then
sort_id=Request("sort_id")
chkid(sort_id)
set rs=server.createobject("adodb.recordset")
sql="select sort_name from venshop_sort where sort_id="&sort_id&""
rs.open sql,conn,1,1
if not rs.eof then
sort_name=rs("sort_name")
end if
rs.close
set rs=nothing
showp=showp&"&sort_id="&sort_id
end if

order=request("order")
page=request("page")
orders=getorder(order)
page=getpage(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">
<!--#include file="IncAsp/venshop_log.asp"--><div class="d5"></div><!--#include file="IncAsp/all_pinpai.asp"--><div class="d5"></div>
</td>
<td valign="top" class="all_c_td">
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<%
if sort_id<>"" then sera=" and sort_id=" & sort_id & ""
if nsort_id<>"" then serb=" and nsort_id=" & nsort_id & ""
if pinpai_id<>"" then serc=" and pinpai_id=" & pinpai_id & ""
set rs=server.CreateObject("adodb.recordset")
sql="select hw_id,hw_name,hw_price1,hw_price2,hw_price3,hw_pic,hw_content from venshop_hw where hw_kucun>0 "&sera&serb&serc&"  order by "&orders&""
rs.open sql,conn,1,1
if rs.eof then
%><tr><td align="center" height="30">你所选的类别没有商品</td></tr><%else
rs.pagesize=lookpage
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize%>
<tr><td class="sort">&nbsp;<IMG src="Skin/<%=venshop_skin%>/home.gif" border=0 align="absmiddle">
您的位置：<a href="index.asp">首页</a>&nbsp;>>&nbsp;
<%if sort_id<>"" then%><a href="sort.asp?sort_id=<%=sort_id%>"><%=sort_name%></a>&nbsp;>>&nbsp;<%end if%>
<%if nsort_id<>"" then%><a href="nsort.asp?nsort_id=<%=nsort_id%>"><%=nsort_name%></a>&nbsp;>>&nbsp;<%end if%>
<%=pinpai_name%>
(共<%=totalrec%>件商品,这是第<%=(page-1)*rs.pagesize+1%>-<%if page+1<=totalpage then%><%=page*rs.pagesize%><%else%><%=totalrec%><%end if%>件)
</td></tr>
<tr><td>
<%if pinpai_content<>"" then%><p style="line-height: 150%; margin: 3px; text-indent:20px">
	<font color="#FD6700"><%=pinpai_content%></font></p><%end if%></td></tr>
<tr><td width="100%" align="center" style="border: 1px solid #E1E1E1">
<!--#include file="IncAsp/venshop_ins.asp"-->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<form action="<%=filename%>?pinpai_id=<%=pinpai_id%>&order=<%=order%><%=showp%>" 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="<%=filename%>?page=<%=page-1%>&pinpai_id=<%=pinpai_id%>&order=<%=order%><%=showp%>">上一页</a>  <%else%>上一页 <%end if%>
<%if page+1<=totalpage then%> <a href="<%=filename%>?page=<%=page+1%>&pinpai_id=<%=pinpai_id%>&order=<%=order%><%=showp%>">下一页</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="<%=filename%>?page=<%=i%>&pinpai_id=<%=pinpai_id%>&order=<%=order%><%=showp%>"><%=i%></a>
<%end if
next%></td></tr></form></table>
</td></tr>
<%end if
rs.close
set rs=nothing%></table></td></tr></table></div><!--#include file="IncAsp/venshop_copy.asp"-->