Gu_pro.asp
Upload User: pengwei803
Upload Date: 2021-02-10
Package Size: 3311k
Code Size: 4k
Development Platform:

HTML/CSS

  1. <!--#include file="ku_top.asp"-->
  2. <%
  3. function title()
  4. title="商家产品"
  5. end function
  6. %>
  7. <div align="center">
  8. <table cellpadding="0" cellspacing="0" width="100">
  9. <tr>
  10. <td height="5"></td>
  11. </tr>
  12. </table>
  13. </div>
  14. <div align="center">
  15. <table border="0" width="980" height="454" cellpadding="0" cellspacing="0">
  16. <tr>
  17. <td height="454" width="740" valign="top">
  18. <div align="center">
  19. <table cellpadding="0" cellspacing="0" width="740" height="452">
  20. <tr>
  21. <td height="36" background="Ku_img/News/news_001.JPG"><div id="dazi">
  22. <p align="left">
  23. <b><font color="#0066FF">
  24. &nbsp;&nbsp; </font>商家产品</b></div> </td>
  25. </tr>
  26. <tr>
  27. <td height="396" background="Ku_img/News/news_002.JPG" valign="top">
  28. <div align=center>
  29.   <script   language="JavaScript1.2">   
  30.   function   makevisible(cur,which){   
  31.   if   (which==0)   
  32.   cur.filters.alpha.opacity=100   
  33.   else   
  34.   cur.filters.alpha.opacity=20   
  35.   }   
  36.   </script> 
  37. <table width="730" border="0" align="center" cellpadding="0" cellspacing="0">
  38. <tr>
  39. <td colspan="2">
  40. <table width="730" border="0" align="center" cellpadding="2" cellspacing="1" >
  41. <tr>
  42. <%
  43. set rs=server.createobject("adodb.recordset")
  44. sql="select * from gu_pro "
  45. sql=sql&" order by addtime desc"
  46. rs.open sql,conn,1,1
  47. dim a
  48. Set a=New PageList
  49. listLimit=8
  50. '模拟分页一页显示分页数
  51. pageLists=5
  52. '设置分页参数
  53. If rs.BOF or rs.EOF Then 
  54. %>
  55. </tr>
  56. <tr bgcolor="#C6E3F4">
  57.   <td height="24"  align="center" bgcolor="#FFFFFF">此类暂无产品或者没有此分类!</td>
  58.   </tr>
  59. <%
  60. else
  61. dim x
  62. x=1
  63. '分页循环开始
  64. totalList=rs.recordcount
  65. a.InitPara=array(totalList,listLimit,pageLists)
  66. a.PageList()
  67. rs.pagesize=listLimit
  68. page = request("page")
  69. If page="" Then
  70. page=1
  71. End If
  72. rs.absolutepage = page
  73. %>
  74. <tr>
  75. <%for i=1 to rs.pagesize%>
  76. <td height="100" width="130" style="border: 1px solid #CECFCE">
  77. <p align="center">
  78. <a href="Gu_showpro.asp?guxing=<%=rs("id")%>">
  79. <img border="0" src="<%if rs("pic")<>"" then%><%=rs("pic")%><%else%>ku_Img/nopic.jpg<%end if%>" width="128" height="128" style="filter:alpha(opacity=20)"   onMouseOver="makevisible(this,0)"   onMouseOut="makevisible(this,1)"></a>
  80. </td>
  81. <td width="583">
  82. <div align="left">
  83. <table border="0" width="211" height="116" cellpadding="0" cellspacing="0">
  84. <tr>
  85. <td height="30" width="52" valign="top"><b>名称</b>:</td>
  86. <td height="30" width="159" valign="top"><a href="Gu_showpro.asp?guxing=<%=rs("id")%>"> 
  87. <b><font color="#FF0000"><%=Trim(rs("name"))%></font></b></a></td>
  88. </tr>
  89. <tr>
  90. <td height="30" width="52"><b>时间</b>:</td>
  91. <td height="30" width="159"><%=DateTimeFormat(rs("addtime"),4)%></td>
  92. </tr>
  93. <tr>
  94. <td height="28" width="52"><b>价格</b>:</td>
  95. <td height="28" width="159">¥<%=rs("price")%></td>
  96. </tr>
  97. <tr>
  98. <td height="28" width="52"><b>商家</b>:</td>
  99. <%
  100. cid=rs("did")
  101. set kurs=server.createobject("adodb.recordset")
  102.     csql="select * from shangjia where id="&cid
  103.     kurs.open csql,conn,1,3
  104. %>
  105. <td height="28" width="159"> <b>
  106. <a href="My_shop.asp?guxing=<%=kurs("id")%>"><font color="#FF6600"><%=kurs("Name")%></font></a></b></td>
  107. </tr>
  108. </table>
  109. </div>
  110. </td>
  111. <% if x mod 2 =0 then%> 
  112. </tr>
  113. <tr>
  114. <td height="5" width="640" colspan="2"></td>
  115. </tr>
  116. <tr align="center" width="320">
  117. <%
  118. end if
  119. x=x+1
  120. rs.movenext
  121. if rs.eof then exit for
  122. next
  123. end if
  124. %>
  125. </tr>
  126. </table></td>
  127.   </tr>
  128.   <tr>
  129.     <td colspan="2">   → <%=a.PageInfo%></td>
  130.   </tr>
  131.   <tr>
  132.     <td colspan="2"></td>
  133.   </tr>
  134.  </form>
  135. </table>
  136. </div>
  137. <%
  138. rs.close
  139. set rs=nohing
  140. %>
  141. </td>
  142. </tr>
  143. <tr>
  144. <td height="4">
  145. <img border="0" src="Ku_img/News/news_003.JPG" width="740" height="4"></td>
  146. </tr>
  147. </table>
  148. </div>
  149. </td>
  150. <td height="454" width="8"> </td>
  151. <td height="454" width="232" valign="top">
  152. <!--#include file="Ku_type/Index_login.asp"-->
  153. <!--#include file="Ku_type/sj_kind.asp"-->
  154. </td>
  155. </tr>
  156. </table>
  157. </div>
  158. <!--#include file="Ku_foot.asp"-->