?? li.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="webconfig.asp"-->
<!--#include file="Ubb.asp"-->
<html>
<head>
<title><%=webname%>--商品信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!--#include file="webtop.asp"-->
<table width="770" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="EDECEC">
<tr>
<td width="180" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<!--#include file="info_class.asp"-->
<!--#include file="info_history.asp"-->
<!--#include file="info_brand.asp" -->
<!--#include file="info_market.asp"-->
</td>
<td width="5" valign="top" background="images/bj_x.gif"></td>
<td width="563" valign="top" bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="images/bj_x.gif" height="1"></td>
</tr>
<tr>
<td height="34" background="images/main/th_bg.gif">
<div align="center">
<!--#include file="info.asp"-->
</div>
</td>
</tr>
<tr>
<td background="images/bj_x.gif" height="1"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="4" align="center">
<tr>
<td colspan="4" align="center"><font color="#FF0000"><b>商品信息</b></font></td>
</tr>
<tr>
<td colspan="4" background="images/bj_x1.gif" height="1"></td>
</tr>
</table>
<%dim id
id=trim(request("id"))
if IsNumeric(request.QueryString("id"))=False or request.QueryString("id")="" then
response.write"<SCRIPT language=JavaScript>alert('參數錯誤');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
end if
sql="select * from sh_chanpin where bookid=" &id & ""
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,3
if rs.bof and rs.eof then
response.write"<SCRIPT language=JavaScript>alert('參數錯誤！');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
else
rs("liulancount")=rs("liulancount")+1
rs.update
'call history
if request.cookies("shopzhiwang")("username")<>"" then
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from [sh_user] where username='"&request.cookies("shopzhiwang")("username")&"'",conn,1,1
t_userid=rs_s("userid")
rs_s.close
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from sh_his where bookid="&request("id")&" and username='"&request.cookies("shopzhiwang")("username")&"' and lx=1",conn,1,3
if rs_s.recordcount>0 then
rs_s("ltime")=now()
rs_s("userid")=t_userid
rs_s.update
rs_s.close
set rs_s=nothing
else
rs_s.close
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from sh_his where username='"&request.cookies("shopzhiwang")("username")&"' and lx=1 order by ltime",conn,1,3
if rs_s.recordcount>=4 then
rs_s.delete
rs_s.update
end if
rs_s.addnew
rs_s("username")=request.cookies("shopzhiwang")("username")
rs_s("bookid")=request("id")
rs_s("bookname")=rs("bookname")
rs_s("userid")=t_userid
rs_s("lx")=1
rs_s("ltime")=now()
rs_s.update
rs_s.close
set rs_s=nothing
end if
end if
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="160" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td>
<div align="center">
<%if rs("zhuang")="" then
response.write "<img src=images/emptybook.gif width=150 border=0>"
else
%>
<a href="<%=trim(rs("zhuang"))%>" target=_blank><img src="<%=trim(rs("bookpic"))%>" width=130 border=0 alt="點擊瀏覽商品大圖" height="130"></a>
<%end if%>
</div>
</td>
</tr>
<tr>
<td>
<div align="center"><a href="<%=trim(rs("zhuang"))%>" target=_blank><img src="images/view2.gif" width="115" height="36" border="0"></a></div>
</td>
</tr>
<tr>
<td>
<div align="center">市場價：<s><%=rs("shichangjia")%>元</s></div>
</td>
</tr>
<tr>
<td>
<div align="center">會員價：<font color="#FF0000"><strong><%=rs("huiyuanjia")%>元</strong></font></div>
</td>
</tr>
<tr>
<td>
<div align="center">VIP 價：<font color="#FF0000"><%=rs("Vipjia")%>元</font></div>
</td>
</tr>
</table>
</td>
<td valign="top">
<table width="100%%" border="0" cellspacing="0" cellpadding="2">
<%
end if
%><br>
<tr>
<td height="30"><font color="#990000" size="3"><strong><%=rs("bookname")%></strong></font></td>
</tr>
<tr>
<td>【商品規格】 <%=rs("isbn")%></td>
</tr>
<tr>
<td>【商品單位】 <font color="#FF0000"><%=rs("bookchuban")%></font></td>
</tr>
<tr>
<td>【商品狀態】 <%if rs("kucun")>0 then%>有貨<%else%>暫時缺貨<%end if%>
</td>
</tr>
<tr>
<td>【所屬類別】
<%set rs2=server.createobject("adodb.recordset")
rs2.open "select * from sh_sort where anclassid="&rs("anclassid"),conn,1,1
if rs2.recordcount>0 then
response.write "<a href=class.asp?id=big&anid="&rs2("anclassid")&" targer=_blank>"&rs2("anclass")&"</a>>>>>"
end if
rs2.close
set rs2=server.createobject("adodb.recordset")
rs2.open "select * from sh_sort2 where nclassid="&rs("nclassid"),conn,1,1
if rs2.recordcount>0 then
response.write "<a href=class.asp?id=small&anid="&rs2("anclassid")&"&nid="&rs2("nclassid")&" targer=_blank>"&rs2("nclass")
end if
rs2.close
set rs2=nothing%>
</td>
</tr>
<tr>
<td>【評分星級】
<%if rs("pingjizong")>0 and rs("pingji")>0 then
xx=rs("pingjizong")\rs("pingji")
else
xx=5
end if
response.write "<img src=images/pingji/"&xx&".gif alt=評論星級>"%>
有<%=rs("pingji")%>位網友評論 </td>
</tr>
<tr>
<td> <font color="#FFFFFF">c</font>此商品已被瀏覽：<font color="#FF0000"><strong><%=rs("liulancount")%>次</strong></font></td>
</tr>
</table>
<table height="80">
<tr>
<td width="221"align="center" valign="bottom"><a href="javascript:;" onClick="javascript:window.open('shopcart.asp?id=<%=rs("bookid")%>&action=add','gouwu','width=450,height=300,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');"><img src="images/shopcart2.gif" width="100" height="36" border=0></a> <a href="javascript:;" onClick="javascript:window.open('favorites.asp?id=<%=rs("bookid")%>&action=add','shouchang','width=600,height=600,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');"><img src="images/Favorites2.gif" width="100" height="36" border=0></a></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="images/bj_x1.gif" height="1"></td>
</tr>
<tr>
<td>
<table width="95%" height="37" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td background="images/view0.gif"></td>
</tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><br><%=Code_Ubb(rs("bookcontent"))%><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<%
rs.close
set rs=nothing
%>
<tr>
<td> </td>
</tr>
<tr>
<td height=1 background="images/bj_x1.gif"> </td>
</tr>
<tr>
<td height="37" background="images/review.gif"></td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from sh_review where bookid="&request("id")&" and shenhe=1 order by pinglundate desc",conn,1,1
j=rs.recordcount
plcount=rs.recordcount
if j>3 then j=3
for i=1 to j
%>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="5%" align="right" height="22"><img src="images/image002.gif" width="15" height="15"></td>
<td colspan="2" height="22"><b>主題：</b><a href="javascript:;" onClick="javascript:window.open('pinglunll.asp?id=<%=rs("pinglunid")%>','pinglun','width=300,height=400,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=no');return false;" title="<%=trim(rs("pingluntitle"))%>"><%=trim(rs("pingluntitle"))%></a></td>
<td width="36%" height="22"><img src="images/pingji/<%=rs("pingji")%>.gif" width="79" height="14"></td>
</tr>
<tr>
<td width="5%"> </td>
<td colspan="2"><b>作者：</b><%=trim(rs("pinglunname"))%> (<%=trim(rs("pinglundate"))%>)</td>
<td width="36%"><%=trim(rs("ip"))%></td>
</tr>
<tr>
<td width="5%"> </td>
<td colspan="3">
<%if len(rs("pingluncontent"))>24 then
response.write left(rs("pingluncontent"),20)&"... <a href=""javascript:;"" onClick=""javascript:window.open('pinglunll.asp?id="&rs("pinglunid")&"','pinglun','width=300,height=400,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"" title="&trim(rs("pingluntitle"))&">[詳細內容]</a>"
else response.write rs("pingluncontent")
end if%>
</td>
</tr>
<%if trim(rs("huifu"))<>"" then%>
<tr>
<td width="5%"></td>
<td colspan="3"><b><font color="#0099CC">管理員回復：</font></b><%=rs("huifu")%>
</td>
</tr>
<%end if%>
<tr>
<td height=1 colspan=4 background="images/bj_x.gif"></td>
</tr>
</table>
</td>
</tr>
<%
rs.movenext
next
if plcount>0 then
%>
<tr>
<td align=right height="22"><a href=list_review.asp?id=<%=request("id")%>> 瀏覽該商品的全部評論</a> <font color="#999999">共<%=plcount%>條</font></td>
</tr>
<%end if%>
<tr>
<td background="images/bj_x.gif" height="1" ></td>
</tr>
<tr>
<td align="center" height="38"> <a href="javascript:;" onClick="javascript:window.open('info_recommend.asp?id=<%=request("id")%>','pingluntj','width=325,height=200,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=no')"><img src="images/tj.gif" width="60" height="19" border=0></a>
<a href="javascript:;" onClick="javascript:window.open('review.asp?id=<%=request("id")%>','pinglun','width=295,height=325,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=no');"><img src="images/pl.gif" width="60" height="19" border=0></a>
</td>
</tr>
</table>
</div>
</td>
<td width="5" valign="top" background="images/bj_x.gif"></td>
</tr>
</table>
<!--#include file="webfoot.asp"-->
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -