📄 pricecenter.asp
字号:
<%
dim toppath,dbpath,key
key="a5"
toppath=""
dbpath=""
%>
<!--#include file="db_conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/main.css" rel="stylesheet" type="text/css">
<title>报价中心</title>
</head>
<body topmargin="1">
<!--#include file="top.asp" -->
<div align="center">
<table border="0" width="760" id="table3" cellspacing="0" cellpadding="0">
<tr>
<td height="25">当前位置：<a href="index.asp">首页</a>>>>报价中心</td>
</tr>
</table>
<table border="0" width="760" id="table1" cellspacing="0" cellpadding="0" style="border:1px solid #E0E0E0; padding:1px; line-height: 150%">
<tr>
<td width="41" bgcolor="#C0C0C0"><font color="#FFFF00">ID</font></td>
<td width="211" align="left" bgcolor="#C0C0C0">
<font color="#FFFF00">商品类别</font></td>
<td width="228" align="left" bgcolor="#C0C0C0">
<font color="#FFFF00">商品名称</font></td>
<td width="112" align="left" bgcolor="#C0C0C0">
<font color="#FFFF00">市场价格</font></td>
<td width="100" align="left" bgcolor="#C0C0C0">
<font color="#FFFF00">会员价格</font></td>
<td width="68" align=center bgcolor="#C0C0C0"><font color="#FFFF00">购买</font></td>
</tr>
<%
dim sql,rs,p,arr(5),k,rs1,rs2,txt_big_class,txt_small_class
sql="select id,bid,sid,p_name,p_cmoney,p_mmoney from yqj_product order by addtime desc,sid desc,bid desc"
set rs=conn.execute (sql)
if rs.eof then
response.write "<tr><td colspan=6>暂时没有任何数据</td></tr>"
else
p=1
do while not rs.eof
for k=0 to 5
arr(k)=rs(k)
next
set rs1=conn.execute ("select txt_big_class from big_class where id="&arr(1))
txt_big_class=rs1(0)
set rs2=conn.execute ("select txt_small_class from small_class where id="&arr(2))
txt_small_class=rs2(0)
rs1.close
set rs1=nothing
rs2.close
set rs2=nothing
%>
<tr>
<td width="41"><%=p%></td>
<td width="211" align="left"><a href=big_class.asp?bid=<%=arr(1)%>><%=txt_big_class%></a>>>><a href=small_class.asp?bid=<%=arr(1)%>&sid=<%=arr(2)%>><%=txt_small_class%></a></td>
<td width="228" align="left"><a href=product/product_list.asp?id=<%=arr(0)%> title=查看详情><%=arr(3)%></a></td>
<td width="112" align="left"><strike>￥<%=arr(4)%></strike><font color="#C0C0C0">(市场价格)</font></td>
<td width="100" align="left"><font color="#FF0000"><font face="宋体">￥</font><%=arr(5)%></font>(会员价格)</td>
<td width="68">
<p align="center"><img src=images/che.gif border=0 align="absmiddle"><a href=buy.asp?id=<%=arr(0)%> title=点击购买>购买</a></td>
</tr>
<%
rs.movenext
p=p+1
loop
rs.close
set rs=nothing
end if
%>
</table>
</div><!--#include file="end.asp" -->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -