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

HTML/CSS

  1. <!--#include file="ku_top.asp"-->
  2. <%
  3. sjid=request.querystring("guxing")
  4. set rssj=server.CreateObject("adodb.recordset")
  5. sqlsj="select * from shangjia where id="&sjid&""
  6. rssj.open sqlsj,conn,1,1
  7. if rssj.eof then
  8. response.redirect"Shangjia.asp"
  9. end if
  10. function title()
  11. sjid=request.querystring("guxing")
  12. set rssjt=server.CreateObject("adodb.recordset")
  13. sqlsjt="select * from shangjia where id="&sjid&""
  14. rssjt.open sqlsjt,conn,1,1
  15. %>
  16. <%=rssjt("name")%>
  17. <%
  18. end function
  19. %>
  20. <div align="center">
  21. <table cellpadding="0" cellspacing="0" width="100">
  22. <tr>
  23. <td height="5"></td>
  24. </tr>
  25. </table>
  26. </div>
  27. <div align="center">
  28. <table border="0" width="980" height="454" cellpadding="0" cellspacing="0">
  29. <tr>
  30. <td height="454" width="740" valign="top">
  31. <div align="center">
  32. <table cellpadding="0" cellspacing="0" width="740" height="452">
  33. <tr>
  34. <td height="36" background="Ku_img/News/news_001.JPG"><div id="dazi">
  35. <p align="left">
  36. <b><font color="#0066FF">
  37. &nbsp;&nbsp; </font>商家:<%=title%></b></div> </td>
  38. </tr>
  39. <tr>
  40. <td height="396" background="Ku_img/News/news_002.JPG" valign="top">
  41. <div align="center">
  42. <table cellpadding="0" cellspacing="1" width="732" height="170" bgcolor="#F6F6F6">
  43. <tr>
  44. <td height="170" bgcolor="#FFFFFF" width="165"><p align="center"><img border="0" src="<%=rssj("logo")%>" width="143" height="153"></td>
  45. <td height="170" bgcolor="#FFFFFF" width="564">
  46. <div align="center">
  47. <table border="0" width="99%" id="table3" cellpadding="3" cellspacing="1"  bgcolor="#EFEFEF">
  48. <tr>
  49. <td width="84" height="32" bgcolor="#FFFFFF">
  50. <p align="center"><b>店铺名称</b>:</td>
  51. <td height="32" bgcolor="#FFFFFF"><b>
  52. <font color="#6699FF"><%=rssj("name")%></font></b></td>
  53. </tr>
  54. <tr>
  55. <td width="84" height="95" bgcolor="#FFFFFF">
  56. <p align="center"><b>店铺简介</b>:</td>
  57. <td height="95" bgcolor="#FFFFFF"><%=changechr(cstr(rssj("beizhu")))%></td>
  58. </tr>
  59. <tr>
  60. <td width="84" bgcolor="#FFFFFF">
  61. <p align="center"><b>联系方式</b>:</td>
  62. <td bgcolor="#FFFFFF"><font color="#6699FF">电话:</font><%=rssj("tel")%> 
  63. <font color="#6699FF">联系人:</font><%=rssj("username")%><br>
  64. <font color="#6699FF">地址:</font><%=rssj("address")%></td>
  65. </tr>
  66. </table>
  67. </div>
  68. </td>
  69. </tr>
  70. </table>
  71. <div align="center">
  72. <table cellpadding="0" cellspacing="0" width="100">
  73. <tr>
  74. <td height="5"></td>
  75. </tr>
  76. </table>
  77. </div>
  78. <table cellpadding="0" cellspacing="1" width="99%" bgcolor="#F6F6F6">
  79. <!-- MSTableType="layout" -->
  80. <tr>
  81. <td height="135" bgcolor="#FFFFFF" valign="top">
  82. <div align=center>
  83. <table width="720" border="0" align="center" cellpadding="0" cellspacing="0">
  84. <tr>
  85. <td colspan="2">
  86. <table width="720" border="0" align="center" cellpadding="3" cellspacing="1" height="175" >
  87. <tr>
  88. <%
  89. set rs=server.createobject("adodb.recordset")
  90. sql="select * from gu_pro where did="&sjid&""
  91. sql=sql&" order by addtime desc"
  92. rs.open sql,conn,1,1
  93. dim a
  94. Set a=New PageList
  95. listLimit=6
  96. '模拟分页一页显示分页数
  97. pageLists=5
  98. '设置分页参数
  99. If rs.BOF or rs.EOF Then 
  100. %>
  101. </tr>
  102. <tr bgcolor="#C6E3F4">
  103.   <td height="24"  align="center" bgcolor="#FFFFFF"><b><font color="#0066FF">此商家还没添加产品!</font></b></td>
  104.   </tr>
  105. <%
  106. else
  107. dim x
  108. x=1
  109. '分页循环开始
  110. totalList=rs.recordcount
  111. a.InitPara=array(totalList,listLimit,pageLists)
  112. a.PageList()
  113. rs.pagesize=listLimit
  114. page = request("page")
  115. If page="" Then
  116. page=1
  117. End If
  118. rs.absolutepage = page
  119. %>
  120. <tr>
  121. <%for i=1 to rs.pagesize%>
  122. <td height="124" width="114" style="border: 1px solid #CECFCE">
  123. <p align="center">
  124. <a href="Gu_showpro.asp?guxing=<%=rs("id")%>">
  125. <img border="0" src="<%=rs("pic")%>" width="108" height="114"></a>
  126. </td>
  127. <td width="529" valign="top">
  128. <div align="left">
  129. <table border="0" width="190" height="111" cellpadding="0" cellspacing="0">
  130. <tr>
  131. <td height="36" width="51"><b>名称</b>:</td>
  132. <td height="36" width="139"><a href="Gu_showpro.asp?guxing=<%=rs("id")%>"> 
  133. <font color="#FF0000"> <%=Trim(rs("name"))%></font></a></td>
  134. </tr>
  135. <tr>
  136. <td height="32" width="51"><b>时间</b>:</td>
  137. <td height="32" width="139"> <%=DateTimeFormat(rs("addtime"),4)%></td>
  138. </tr>
  139. <tr>
  140. <td height="33" width="51"><b>价格</b>:</td>
  141. <td height="33" width="139"> <font color="#800000"> <%=rs("price")%></font> 元</td>
  142. </tr>
  143. </table>
  144. </div>
  145. </td>
  146. <% if x mod 2 =0 then%> 
  147. </tr>
  148. <tr>
  149. <td height="9" width="640" colspan="2"></td>
  150. </tr>
  151. <tr align="center" width="320">
  152. <%
  153. end if
  154. x=x+1
  155. rs.movenext
  156. if rs.eof then exit for
  157. next
  158. end if
  159. %>
  160. </tr>
  161. </table></td>
  162.   </tr>
  163.   <tr>
  164.     <td colspan="2">   
  165. <p align="center"><%=a.PageInfo%></td>
  166.   </tr>
  167.   <tr>
  168.     <td colspan="2"></td>
  169.   </tr>
  170.  </form>
  171. </table>
  172. </div>
  173. <%
  174. rs.close
  175. set rs=nohing
  176. %>
  177. </td>
  178. </tr>
  179. </table>
  180. </div>
  181. <tr>
  182. <td height="4">
  183. <img border="0" src="Ku_img/News/news_003.JPG" width="740" height="4"></td>
  184. </tr>
  185. </table>
  186. </div>
  187. </td>
  188. <td height="454" width="8"> </td>
  189. <td height="454" width="232" valign="top">
  190. <!--#include file="Ku_type/Index_login.asp"-->
  191. <!--#include file="Ku_type/sj_gg.asp"-->
  192. </td>
  193. </tr>
  194. </table>
  195. </div>
  196. <!--#include file="Ku_foot.asp"-->