Products.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:28k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <html>
  2. <head>
  3. <!--#include file="conn.asp"-->
  4. <!--#include file="config.asp"-->
  5. <!--#include file="./alipay_inc/myAlipay.asp"-->
  6. <!--#include file="./alipay_inc/alipay_Config.asp"-->
  7. <%set rss=server.CreateObject("adodb.recordset")
  8. rss.open "select * from products where bookid="&request.querystring("id"),conn,1,3
  9. if rss.eof or bof then
  10. response.write "<script>alert('对不起,没有此商品!');history.go(-1);</script>"
  11. response.end
  12. end if 
  13. dim des
  14. if not rss("metad")="" then 
  15. des=rss("metad")
  16. end if 
  17. if not rss("metak")="" then 
  18. keya=rss("metak")
  19. end if 
  20. %>
  21. <title><%=rss("bookname")%>_网软天下购物系统,网络购物系统,asp购物系统,免费购物系统,网上商城购物系统。</title>
  22. <meta name="description" content="<%=des%>">
  23. <meta name="keywords" content="<%=keya%>"> 
  24. <link href="skin/skin<%=skinid%>/css.css" rel="stylesheet" type="text/css">
  25. </head>
  26. <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
  27. <%if IsNumeric(request.QueryString("id"))=False then
  28. response.write("<script>alert(""非法访问!"");location.href=""index.asp"";</script>")
  29. response.end
  30. end if
  31. dim id
  32. id=request.QueryString("id")
  33. if not isinteger(id) then
  34. response.write"<script>alert(""非法访问!"");location.href=""index.asp"";</script>"
  35. end if%>
  36. <%dim bookid,action
  37. bookid=request.QueryString("id")
  38. action=request.QueryString("action")
  39. if action="save" then
  40. set rs=server.CreateObject("adodb.recordset")
  41. rs.open "select * from review",conn,1,3
  42. rs.addnew
  43. rs("bookid")=bookid
  44. rs("pingji")=request("pingji")
  45. rs("pinglunname")=HTMLEncode2(trim(request("pinglunname")))
  46. rs("pingluntitle")=HTMLEncode2(trim(request("pingluntitle")))
  47. rs("pingluncontent")=HTMLEncode2(trim(request("pingluncontent")))
  48. rs("ip")=Request.servervariables("REMOTE_ADDR")
  49. rs("pinglundate")=now()
  50. rs("shenhe")=0
  51. rs.update
  52. rs.close
  53. set rs=nothing
  54. set rs=server.CreateObject("adodb.recordset")
  55. rs.open "select * from products where bookid="&bookid,conn,1,3
  56. rs("pingji")=rs("pingji")+1
  57. rs("pingjizong")=rs("pingjizong")+request("pingji")
  58. rs.update
  59. rs.close
  60. set rs=nothing
  61. response.Write "<script language=javascript>alert('您的评论已成功提交,待管理员审核!');history.go(-1);</script>"
  62. response.End
  63. end if
  64. %>
  65. <!--#include file="include/head.asp"-->
  66. <table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  67.   <tr>
  68.     <td width="39" valign="top"><table width="100%" height="184" border="0" cellpadding="0" cellspacing="0">
  69.       <tr>
  70.         <td height="30" align="right" valign="top"><img src="skin/skin<%=skinid%>/jiao.gif" width="15" height="17"></td>
  71.       </tr>
  72.       <tr>
  73.         <td height="90"><div align="right"><img src="images/ttts.gif" width="26" height="110" /></div></td>
  74.       </tr>
  75.       <tr>
  76.         <td height="30">&nbsp;</td>
  77.       </tr>
  78.     </table></td>
  79.     <td width="190"style="BORDER-bottom:<%=skincolor%> 1px solid;BORDER-left:<%=skincolor%> 1px solid; BORDER-right:<%=skincolor%> 1px solid;" valign="top">
  80. <table width="100%" border="0" cellspacing="0" cellpadding="0" >
  81.       <tr>
  82.         <td ><table width="190" height="190" border="0" cellpadding="0" cellspacing="0">
  83.           <tr>
  84.               <td align="center" valign="middle" background="skin/skin<%=skinid%>/index_2.gif"><!--#include file="logins.asp"--></td>
  85.           </tr>
  86.         </table></td>
  87.       </tr>
  88.       <tr>
  89.         <td><img src="images/index_4.gif" width="190" height="12" alt="" /></td>
  90.       </tr>
  91.       <tr>
  92.         <td><!--#include file="viewhistory.asp"--><!--#include file="searc.asp"--><!--#include file="shopcart.asp"--></td>
  93.       </tr>
  94.       <tr>
  95.         <td><!--#include file="include/selltop.asp"--></td>
  96.       </tr>
  97.   <tr>
  98.                 <td height="5"></td>
  99.               </tr>
  100.               <tr>
  101.                 <td><div align="center"><a href="<%=ad6url%>" target="_blank"><img src="<%=ad6%>" border="0" width="180" ></a></div></td>
  102.               </tr>
  103.   <tr>
  104.                 <td height="5"></td>
  105.               </tr>              <tr>
  106.                 <td><div align="center"><a href="<%=ad7url%>" target="_blank"><img src="<%=ad7%>" border="0" width="180"  ></a></div></td>
  107.               </tr>
  108.     </table></td>
  109.     <td valign="top"><table width="100%" height="41" border="0" align="center" cellpadding="0" cellspacing="0">
  110.       <tr>
  111.         <td height="28" background="skin/skin<%=skinid%>/pdbg01.gif"><div align="center"><span class="table-zuo">
  112.           <%set rs=server.createobject("adodb.recordset")
  113. rs.open "select * from products where bookid="&request("id"),conn,1,3
  114. if rs.recordcount=0 then 
  115. %>
  116.           <font color="#FF0000"><strong>商品已不存在</strong></font>
  117.           <%
  118. else
  119. bname=rs("bookname")
  120. rs("liulancount")=rs("liulancount")+1
  121. rs.update
  122. Sub PutIntoFav( add, ProductList )
  123.    If Len(ProductList) = 0 Then
  124.       ProductList = add
  125.       'ProductList = "'" & add & "'"
  126.    ElseIf InStr( ProductList, add ) <= 0 Then
  127.       ProductList = ProductList & "," & add
  128.    End If
  129. End Sub
  130. dim ProductList,Products
  131. ProductList = request.cookies("leisure")("fav")
  132. Products = Split(request("id"),",")
  133. For I=0 To UBound(Products)
  134.    PutIntoFav Products(I), ProductList
  135. Next
  136. response.Cookies("leisure")("fav") = ProductList
  137. if request.cookies("Cnhww")("username")<>"" then 
  138. set rs_s=server.CreateObject("adodb.recordset")
  139. rs_s.open "select * from [YX_User] where name='"&request.cookies("Cnhww")("username")&"'",conn,1,1
  140. t_userid=rs_s("id")
  141. rs_s.close
  142.     set rs_s=server.createobject("adodb.recordset")
  143.     rs_s.open "select * from history where bookid="&request("id")&" and username='"&request.cookies("Cnhww")("username")&"' and lx=1",conn,1,3
  144.     if rs_s.recordcount>0 then 
  145. rs_s("ltime")=now()
  146. rs_s("userid")=t_userid
  147. rs_s.update
  148. rs_s.close
  149. set rs_s=nothing
  150.     else
  151.      rs_s.close
  152.      set rs_s=server.createobject("adodb.recordset")
  153.      rs_s.open "select * from history where username='"&request.cookies("Cnhww")("username")&"' and lx=1 order by ltime",conn,1,3
  154.      if rs_s.recordcount>=4 then
  155.          rs_s.delete
  156.          rs_s.update
  157.      end if
  158.      rs_s.addnew
  159.          rs_s("username")=request.cookies("Cnhww")("username")
  160.          rs_s("bookid")=id
  161.          rs_s("bookname")=rs("bookname")
  162.     rs_s("userid")=t_userid
  163.          rs_s("lx")=1
  164.          rs_s("ltime")=now()
  165.         rs_s.update
  166. rs_s.close
  167. set rs_s=nothing
  168. end if
  169. end if
  170. %>
  171.         </span></div>
  172.           &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=index.asp>网软天下购物系统,网络购物系统,asp购物系统,免费购物系统,网上商城购物系统。</a> >>
  173.           <%set rs2=server.createobject("adodb.recordset")
  174. rs2.open "select * from bsort where anclassid="&rs("anclassid"),conn,1,1
  175. if rs2.recordcount>0 then
  176. response.write "<a href=class.asp?lx=big&anid="&rs2("anclassid")&" targer=_blank>"&rs2("anclass")&"</a> >> "
  177. end if
  178. rs2.close
  179. set rs2=server.createobject("adodb.recordset")
  180. rs2.open "select * from ssort where nclassid="&rs("nclassid"),conn,1,1
  181. if rs2.recordcount>0 then
  182. response.write "<a href=class.asp?lx=small&anid="&rs2("anclassid")&"&nid="&rs2("nclassid")&" targer=_blank>"&rs2("nclass")&"</a>>>"
  183. end if
  184. rs2.close
  185.  
  186. set rs2=server.createobject("adodb.recordset")
  187. rs2.open "select * from xsort where id="&rs("xclassid"),conn,1,1
  188. if rs2.recordcount>0 then
  189. response.write "<a href=class.asp?lx=small&anid="&rs2("anclassid")&"&nid="&rs2("nclassid")&"&xid="&rs2("id")&" targer=_blank>"&rs2("xclass")&"</a>"
  190. end if 
  191. set rs2=nothing%></td>
  192.         </tr>
  193.       
  194.       <tr>
  195.         <td ><table width="100%" border="0" cellspacing="0" cellpadding="0">
  196.               <tr>
  197.               <td width="400"><br>
  198.               <table width=300 height=300border=0 align="center" cellpadding=0 cellspacing=0>
  199.                 <tbody>
  200.                   <tr>
  201.                     <td  align=center>
  202.                       <div align="center">
  203.                       <%if rs("zhuang")="" then 
  204. response.write "<img src=images/emptybook.gif width=200 border=0>"
  205. else%>
  206.                       <img src="<%=trim(rs("zhuang"))%>" width=300 border=0 alt="商品名称:<%=rs("bookname")%>" height="300">
  207.                       <%end if%>                  </td>
  208.                       </tr>
  209.                   </tbody>
  210.               </table></td><td width="8" rowspan="2" background="images/body/p_bg01.gif"></td>
  211.               <td width="462" rowspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  212.                     <tr> 
  213.                       <td height="25" colspan="2" align="center">&nbsp;<font color="#ff6600" size="3"><strong><%=rs("bookname")%></strong></font></td>
  214.                     </tr>
  215.                     <tr> 
  216.                       <td width="28%">&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  217.                         商品编号:</td>
  218.                       <td width="72%" height="22"><%=trim(rs("grade"))%></td>
  219.                     </tr>
  220.                     <tr> 
  221.                       <td>&nbsp;<img src="images/body/orange-bullet.gif"height="7" width="9" > 
  222.                         商品规格:</td>
  223.                       <td height="22"><%=trim(rs("isbn"))%></td>
  224.                     </tr>
  225.                     <tr> 
  226.                       <td>&nbsp;<img src="images/body/orange-bullet.gif"height="7" width="9" > 
  227.                         商品品牌:</td>
  228.                       <td height="22"><%=trim(rs("pingpai"))%></td>
  229.                     </tr>
  230.                     <tr> 
  231.                       <td>&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  232.                         商品比较:</td>
  233.                       <td height="22"><a href="to.asp?id=<%=rs("bookid")%>&action=add"><img src="images/to.gif" width="54" height="13" border="0"></a> 
  234.                       </td>
  235.                     </tr>
  236.                     <tr> 
  237.                       <td>&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  238.                         商品库存:</td>
  239.                       <td height="22"><%=trim(rs("kucun"))%> <%=rs("bookchuban")%> 
  240.                         <%if rs("kucun")>0 then%>
  241.                         <font color="#999999">热卖中</font> 
  242.                         <%else%>
  243.                         <font color="#999999">缺货</font> 
  244.                         <%end if%>
  245.                       </td>
  246.                         </tr>
  247.                     <tr> 
  248.                       <td>&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  249.                         商品折扣:</td>
  250.                       <td height="22"> 
  251.                         <%response.write left(rs("dazhe")*10,3)&"折"%>
  252.                         ( 赠送积分<%=rs("yeshu")%>分 ) </td>
  253.                     </tr>
  254.                     <tr> 
  255.                       <td>&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  256.                         浏览次数:</td>
  257.                       <td height="22"> <%=trim(rs("liulancount"))%>次 </td>
  258.                     </tr>
  259.                     <tr><form method=post action=buy.asp?id=<%=rs("bookid")%>&action=add>
  260.                       <% if rs("chima")<>"" then%><td>&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  261.                         商品尺码:</td>
  262.                         <td height="22"> 
  263.                           <%if rs("chima")<>"" then%>
  264.                           <%size=trim(rs("chima"))%>
  265.                           <%myarr=split(size,"/")%>
  266.                           <select name="chima" id="chima">
  267.                           <% for i=0 to ubound(myarr) %>
  268.                           <option value="<%=trim(myarr(i))%>" selected><%=trim(myarr(i))%></option>
  269.                           <%next%>
  270.                         </select>
  271. <%else
  272. response.write "无尺码信息" %>
  273.                           <%end if%>
  274.                         </td><%end if %>
  275.                     
  276.                     <tr> 
  277.                       <% if rs("yanse")<>"" then%><td>&nbsp;<img src="images/body/orange-bullet.gif" height="7" width="9"> 
  278.                         商品颜色:</td>
  279.                             <td height="22"> 
  280.                               <%if rs("yanse")<>"" then%>
  281.                               <%size=trim(rs("yanse"))%>
  282.                               <%myarr=split(size,"/")%>
  283.                               <select name="yanse" id="select">
  284.                           <% for i=0 to ubound(myarr) %>
  285.                           <option value="<%=trim(myarr(i))%>" selected><%=trim(myarr(i))%></option>
  286.                           <%next%>
  287.                         </select>
  288. <%else
  289. response.write "无颜色信息" %>
  290.                               <%end if%>
  291.                             </td><%end if %>
  292.                     </tr>
  293.                     <tr> 
  294.                       <td colspan="2"><table width="100%" height="60"  border="0" cellpadding="0" cellspacing="0">
  295.                           <tr> 
  296.                             <td height="8" colspan="2" background="images/body/p_bg02.gif"></td>
  297.                           </tr>
  298.                           <tr> 
  299.                             <td width="24%" height="13"><div align="center">市场价:</div></td>
  300.                             <td width="76%"><s>¥<%=FormatNum(rs("shichangjia"),2)%>元</s></td>
  301.                           </tr>
  302.                           <tr> 
  303.                             <td height="2" colspan="2" background="images/body/p_bg03.gif"></td>
  304.                           </tr>
  305.                           <tr> 
  306.                             <td ><div align="center">会员价:</div></td>
  307.                             <td ><font color="#FF0000">¥<%=FormatNum(rs("huiyuanjia"),2)%> 
  308.                               元</font></td>
  309.                           </tr>
  310.                           <tr> 
  311.                             <td ><div align="center">VIP 价:</div></td>
  312.                             <td ><font color="#FF0000"> 
  313.                               <%if Request.Cookies("cnhww")("reglx")=2 then%>
  314.                               ¥<%=FormatNum(rs("vipjia"),2)%>元 
  315.                               <%else%>
  316.                               <font color="#FF3333">更优惠...</font> 
  317.                               <%end if%>
  318.                               </font>&nbsp;</td>
  319.                           </tr>
  320.                           <tr> 
  321.                             <td height="2"  colspan="2"style=" BORDER-top:#DD0000 2px solid;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  322.                                 <tr> 
  323.                                   <td  height="10"></td>
  324.                                 </tr>
  325.                                 <tr> 
  326.                                   <td><input type="image" src="images/buy1.gif"  width="114" height="37"  border=0>
  327.   <% if  alipaytype=0 then 
  328.                         bookid=request.QueryString("id")
  329. set rsa=server.CreateObject("adodb.recordset")
  330. rsa.open "select * from products where bookid="&bookid,conn,1,3
  331. Dim body,out_trade_no,price,subject,sDate,show_url
  332. Dim myAlipayObj,ResponseTxt
  333. '****************以下为产品相关信息
  334. '生成日期字符串,如果您的网站没有自动生成订单编号,可以考虑用这个日期字符串做订单编号(订单编号不允许重复)
  335. sDate = Now()'生成订单编号,建议使用您网站自己系统的订单编号,否则可用日期时间的方式生成唯一订单编号
  336. sDate = Year(sDate) & Right(("00" & Month(sDate)),2) & Right(("00" & Day(sDate)),2) & Right(("00" & Hour(sDate)),2) & Right(("00" &  Minute(sDate)),2) & Right(("00" & Second(sDate)),2)
  337. body = "http://"&weburl&"/products.asp?id="&rsa("bookid")  '商品描述
  338. out_trade_no = sDate '商户网站订单
  339. if Request.Cookies("cnhww")("reglx")=2 then
  340. price = rsa("vipjia") '商品价格
  341. else
  342. price = rsa("huiyuanjia") '商品价格
  343. end if 
  344. subject = rsa("bookname") '商品名称
  345. show_url = weburl '商品展示网址
  346. '********************
  347. '创建一个myAlipay实例,并初始化myAlipay_Initialize()
  348. Set myAlipayObj = New myAlipay
  349. myAlipayObj.myAlipay_Initialize()
  350. '普通Payto
  351. ResponseTxt1 = myAlipayObj.generateURLForSW(body,s_logistics_fee,s_logistics_payment,s_logistics_type,s_logistics_fee_1,s_logistics_fee_2,s_logistics_payment_1,s_logistics_payment_2,s_logistics_type_1,s_logistics_type_2,s_notify_url,out_trade_no,price,s_return_url,s_myAlipayEmail,subject,partner,key,show_url,input_charset)
  352. Response.Write "<a href='" & ResponseTxt1 & "' target='_blank'><img src=images/alipay.gif border=0></a>"%><script language="javascript">
  353. function doClipBoard()
  354. {
  355. var textValue = document.getElementsByName("myTxt")[0].value;
  356. window.clipboardData.setData("text", textValue);
  357. }
  358. </script><%end if %><a href="javascript:;" onClick="javascript:window.open('stow.asp?id=<%=rs("bookid")%>&action=add','','width=640,height=260,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;">&nbsp<img src="images/fav.gif" width="90" height="37"  border=0></a></td>
  359.                                 </tr></form>
  360.                               </table></td>
  361.                           </tr>
  362.                         </table></td>
  363.                     </tr>
  364.                     <tr> 
  365.                
  366.                     </tr>
  367.                   </table></td>
  368.               <td width="16" rowspan="2">&nbsp;</td>
  369.             </tr>
  370.             <tr>
  371.                 <td align="center" valign="top">  <A class=navLink       title=点击查看清晰大图片,使用您更清楚看商品! 
  372.       onclick="window.open ('pic.asp?pic=<%=rs("zhuang")%>&book=<%=rs("bookid")%>&name=<%=rs("bookname")%>', 'picshow', 'height=650, width=800, top=0,left=0, toolbar=no, menubar=no, scrollbars=yes, resizable=yes,location=no, status=no') " 
  373.       href="#"> <img src="images/body/itemzoom.gif" border="0"></a><% if netpaytype=7 then %><form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">
  374. <input type="image" src="images/paypal.gif" border="0" name="submit" alt="立即使用贝宝定购:<%=rsa("bookname")%>">
  375. <input type="hidden" name="add" value="1">
  376. <input type="hidden" name="cmd" value="_cart">
  377. <input type="hidden" name="business" value="<%=paypal%>">
  378. <input type="hidden" name="item_name" value="<%=rsa("bookname")%>">
  379. <input type="hidden" name="amount" value="<%
  380. if Request.Cookies("cnhww")("reglx")=2 then
  381. response.write  rsa("vipjia")  
  382. else
  383. response.write rsa("huiyuanjia")  
  384. end if 
  385. %>">
  386. <input type="hidden" name="no_shipping" value="2">
  387. <input type="hidden" name="no_note" value="1">
  388. <input type="hidden" name="currency_code" value="CNY">
  389. <input type="hidden" name="bn" value="PP-ShopCartBF"></td></form><%end if %>
  390.             </tr>
  391.             
  392.         </table></td>
  393.       </tr>
  394.       <tr>
  395.         
  396.       </tr>
  397.       <tr>
  398.         <td >
  399. <table  style=" BORDER-bottom:<%=skincolor%> 1px solid; BORDER-top:<%=skincolor%> 1px solid;BORDER-left:<%=skincolor%> 1px solid; BORDER-right:<%=skincolor%> 1px solid;" width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  400.               <tr>
  401.               <td height="17" colspan="2" ><table width="100%"  border="0" cellspacing="0" cellpadding="0">
  402.                   <tr>
  403.                     <td><div align="center"><img src="skin/skin<%=skinid%>/p_dtitle01.gif" width="698" height="30" > 
  404.                         </div></td>
  405.                   </tr>
  406.               </table></td>
  407.             </tr>
  408.             <tr>
  409.               <td colspan="2"><table width="98%" border="0" cellspacing="0" cellpadding="10" align="center">
  410.                   <tr>
  411.                     <td>
  412.                         <%=rs("bookcontent")%> </td>
  413.                   </tr>
  414.               </table>
  415.                   <img src="skin/skin<%=skinid%>/tltj.gif" width="698" height="30" align="absmiddle"> 
  416.                   <%
  417.       sql="select top 5 * from products where anclassid = (select anclassid from products where bookid = "&request("id")&") order by liulancount ,chengjiaocount,adddate desc " 
  418.               set rs=server.createobject("adodb.recordset")
  419.       rs.open sql,conn,1,1
  420.     %>
  421.                   <table width="100%"  border="0" cellspacing="0" cellpadding="0">
  422.                     <tr> 
  423.                       <td valign="middle">&nbsp; <table width="590" border="0" cellspacing="0" cellpadding="0" align="center">
  424.                           <tr> 
  425.                             <%
  426.   if rs.eof and rs.bof then
  427.   response.write "<td  align=center>对不起,本栏目还没有比较适合您选购的商品!</td>"
  428.   'response.End
  429.   else
  430.   %>
  431.                             <%
  432. if not rs.eof then
  433. i=1
  434. do while not rs.eof%>
  435.                             <td width="195" height="135" align="center" valign="top"> 
  436.                               <div align="center"></div>
  437.                               <table width="20%"  border="0" align="center" cellpadding="0" cellspacing="0">
  438.                                 <tr> 
  439.                                   <td><div align="center"><a href=products.asp?id=<%=rs("bookid")%> target="_blank" class="style1"> 
  440.                                       <%=InterceptString(rs("bookname"),16)%>
  441.                                       </a></div></td>
  442.                                 </tr>
  443.                                 <tr> 
  444.                                   <td><TABLE width=90 height=90 border=0 align="center" cellPadding=2 cellSpacing=1 bgColor=#e1e1e1 onMouseOver="this.style.backgroundColor='#FF6600'" onMouseOut="this.style.backgroundColor=''">
  445.                                       <TBODY>
  446.                                         <TR> 
  447.                                           <TD width=90 height=90 bgColor=#ffffff align=center> 
  448.                                             <%if rs("bookpic")="" then 
  449. response.write "<div align=center><a href=products.asp?id="&rs("bookid")&" > <img src=images/emptybook.gif width=90 height=90 border=0></a></div>"
  450. else%>
  451.                                             <a href=products.asp?id=<%=rs("bookid")%> target="_blank"><img src="<%=trim(rs("bookpic"))%>" alt="<%=rs("bookname")%>" width=95 height=95 border=0 align=absmiddle></a> 
  452.                                             <%end if%>
  453.                                           </TD>
  454.                                         </TR>
  455.                                       </TBODY>
  456.                                     </TABLE></td>
  457.                                 </tr>
  458.                               </table></td>
  459.                             <%if i mod 5 = 0 then%>
  460.                           </tr>
  461.                           <%end if
  462.     rs.movenext
  463.          i=i+1
  464.       loop
  465. rs.close
  466. end if
  467. end if 
  468.  
  469. %>
  470.                         </table></td>
  471.                     </tr>
  472.                   </table> </td>
  473.             </tr>
  474.             <%
  475. response.write "<tr><td align=right>>>查看更多关于 <a href=research.asp?action=1&anclassid=0&searchkey="&bname&" ><font color=red>"&bname&"</font></a> 的商品&nbsp;&nbsp;&nbsp;</td>"
  476. end if%>
  477.             <tr>
  478.               <td colspan="2" ><div align="center"><img src="skin/skin<%=skinid%>/views.gif" width="698"  height="30"></div></td>
  479.             </tr>
  480.             <%
  481. set rs=server.createobject("adodb.recordset")
  482. rs.open "select  * from review where bookid="&request("id")&"and shenhe=1 order by pinglundate desc",conn,1,1
  483. j=rs.recordcount
  484. plcount=rs.recordcount
  485. if j>3 then j=3
  486. for i=1 to j
  487. %>
  488.             <tr>
  489.               <td colspan="2" valign="middle"><br>
  490.                 <table width="95%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#e1e1e1">
  491.                 <tr bgcolor="#FFFFFF">
  492.                   <td height="15" colspan="2">主题: <%=trim(rs("pingluntitle"))%></td>
  493.                   <td width="26%" height="15"><img src="images/level<%=rs("pingji")%>.gif"></td>
  494.                 </tr>
  495.                 <tr bgcolor="#FFFFFF">
  496.                   <td height="15" colspan="2">作者: <%=trim(rs("pinglunname"))%> (<%=trim(rs("pinglundate"))%>)</td>
  497.                   <td width="26%" height="15">来访Ip:<%=trim(rs("ip"))%></td>
  498.                 </tr>
  499.                 <tr bgcolor="#FFFFFF">
  500.                   <td height="15" colspan="3" bgcolor="#FFFFFF">内容:
  501.                     <%if len(rs("pingluncontent"))>24 then 
  502. 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>" 
  503. else response.write rs("pingluncontent")
  504. end if%>
  505.                   </td>
  506.                 </tr>
  507.                 <%if trim(rs("huifu"))<>"" then%>
  508.                 <tr bgcolor="#FFFFFF">
  509.                   <td height="15" colspan="3"><b><font color="#ff6600">销售商回复:</font></b><%=rs("huifu")%> </td>
  510.                 </tr>
  511.                 <%end if%>
  512.               </table>
  513.              </td>
  514.             </tr>
  515.             <%
  516. rs.movenext
  517. next
  518. if plcount>0 then 
  519. %>
  520.             <tr>
  521.               <td colspan="2" align=right> >>浏览该商品的 <a href=reviewlist.asp?id=<%=request("id")%> >全部<font color="#cc0000"><%=plcount%></font>条评论</a> &nbsp;&nbsp;&nbsp;</td>
  522.             </tr>
  523.             <%end if%>
  524.             <tr>
  525.               <td height="180" colspan="2" align="center"><!--#include file="review.asp"--></td>
  526.             </tr><style type="text/css">
  527. <!--
  528. .back_southidc {BACKGROUND-IMAGE:url('image/titlebg.gif');COLOR:000000;}
  529. .table_southidc {BACKGROUND-COLOR: A4B6D7;}
  530. .tit {font-size: 14px;
  531. }
  532. .tr_southidc {BACKGROUND-COLOR: ECF5FF;}
  533. -->
  534. </style>
  535. <div align="center">
  536. <table width="767" border="0" align="center" cellpadding="2" cellspacing="1" class="table_southidc">
  537.   <tr>
  538.     <td height="25" colspan="2" class="back_southidc"><div align="center"><span style="font-weight: bold">程序注册说明</span></div></td>
  539.   </tr>
  540.   <tr class="tr_southidc">
  541.     <form method="post" action="Admin_DataBackup.asp?action=Backup">
  542.       <td width="563"><div align="left"><span class="tit"><span class="style6">欢迎注册《网软天下购物网站管理系统正式版,正式版无加密无限制》 每套1000元
  543. <br />
  544.         联系QQ:<span class="style11">290116505<a target=blank href=tencent://message/?uin=290116505&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a>314730679</span><font face=Verdana><a target=blank href=tencent://message/?uin=314730679&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a></font>38306293</span><font face=Verdana><a target=blank href=tencent://message/?uin=38306293&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a></font>454882888</span><font face=Verdana><a target=blank href=tencent://message/?uin=454882888&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a></font><font face=Verdana><br />
  545.           </font><span class="style11">电话:020-34700400,34506590,13719472523,13527894748<br />
  546.             MSN:webmaster@wygk.cn<br />
  547.             演示:<a href="http://www.wygk.cn/shop8">http://www.wygk.cn/shop8</a><br />
  548.       官方:<a href="http://www.wygk.cn">http://www.wygk.cn</a></span></div></td>
  549.       <td width="128"><a href="https://pay3.chinabank.com.cn/Payto?v_mid=8279"><img src="paymentsby_01.gif" width="127" height="62" border="0" /></a></td>
  550.     </form>
  551.   </tr>
  552. </table>
  553.         </table></td>
  554.       </tr>
  555.       <tr>
  556.         <td >&nbsp;</td>
  557.       </tr>
  558.     </table></td>
  559.     <td width="68" valign="top"><img name="d" src="" width="69" height="0" alt=""></td>
  560.   </tr>
  561. </table>
  562. <!--#include file="include/foot.asp"-->
  563. </body>
  564. </html>
  565.   <%
  566. function InterceptString(txt,length) 
  567. txt=trim(txt) 
  568. x = len(txt) 
  569. y = 0 
  570. if x >= 1 then 
  571. for ii = 1 to x 
  572. if asc(mid(txt,ii,1)) < 0 or asc(mid(txt,ii,1)) >255 then 
  573. y = y + 2 
  574. else 
  575. y = y + 1 
  576. end if 
  577. if y >= length then 
  578. txt = left(trim(txt),ii) 
  579. exit for 
  580. end if 
  581. next 
  582. InterceptString = txt 
  583. else 
  584. InterceptString = "" 
  585. end if 
  586. End Function 
  587. %>