📄 101.asp
字号:
<tr>
<td> </td>
</tr>
</table>
<%end sub%>
<%sub newsp%>
<!--最新商品======================================= -->
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>首页:最新商品</td>
</tr>
<tr>
<td > </td>
</tr>
<tr>
<td height="10" > </td>
</tr>
<tr>
<td valign="top">
<!-- 最新商品开始-------------------------------------------------- -->
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from Product Where p_shop='"& shop_name &"' order by Product_id desc"
rs.open sqltext,conn,1,1
'/////////////////////////////////////////////////////////假如没有商品时//////////////////
If rs.eof and rs.bof then
response.write "<td><p align='center'><font color='#ff0000'>暂时没有商品资料</font></p></td>"
else
i=1
Do While Not rs.EOF
%>
<td height="56" align="center" valign="top"><a href="default.asp?sb=product&Product_id=<%=rs("Product_id")%>"><img src="<%=rs("small_pic")%>" name="small" width="80" height="82" border="0" ><br>
<font color="#0000FF"><%=rs("Product_Name")%></font><br>
</a><font color="#666666">市场价:</font><span class="main1"><strike><%=rs("P_OldPrice")%>元</strike></span><font color="#cc0000"> </font><font color="#cc0000"><br>
会员价:</font><%=rs("P_NewPrice")%>元<br> <a href="javascript:openbag('../check.asp?cpbm=<%=rs("Product_Id")%>&shopname=<%=rs("p_shop")%>')"><img style="CURSOR: hand" height="22" src="../images/che1.gif" width="56" align="absMiddle" border="0"></a>
</td>
<%if i mod 4 =0 then%>
</tr>
<tr>
<td height="20"></td>
</tr>
<tr>
<%end if%>
<%
i=i+1
if i >= 21 then exit do
rs.MoveNext
Loop
end if
rs.close:set rs=nothing
%>
</tr>
</table>
<!-- 最新商品结束-------------------------------------------------- -->
</td>
</tr>
<tr>
<td valign="top"> </td>
</tr>
</table>
<%end sub%>
<%sub bill%>
<!--商品清单======================================= -->
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>首页:商品清单</td>
</tr>
<tr>
<td height="10" > </td>
</tr>
<tr>
<td valign="top">
<!-- 商品清单开始-/////////////////////////////////------------------------------------------------- -->
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight="#0099CC" bordercolordark="#FFFFFF" class=main1 height="55">
<tr bgcolor="#CCCCCC">
<td width="13%" height="23" align="center">商品编号</td>
<td width="38%" height="23" align="center">商品名称</td>
<td width="16%" height="23" align="center">会员价</td>
<td width="18%" height="23" align="center">市场价</td>
<td width="15%" height="23" align="center">购买</td>
</tr>
<%
dim page
page=request("page")
PageSize = 25
set rs=server.createobject("adodb.recordset")
sqltext="select * from Product where P_shop='"&shop_name&"'"
rs.open sqltext,conn,1,1
rs.PageSize=PageSize
totalfilm=rs.recordcount
pgnum=rs.Pagecount
if page="" or clng(page)<1 then page=1
if clng(page) > pgnum then page=pgnum
if pgnum>0 then rs.AbsolutePage=page
'假如没有商品时
If rs.eof and rs.bof then
response.write "<tr bgcolor=#CCCCCC><td height=23 colspan=5 align=center>本商店暂时还没有商品资料</td></tr></table>"
else
count=0
do while not (rs.eof or rs.bof) and count<rs.PageSize
%>
<tr>
<td width="13%" align="center" height="28"><%=rs("Product_Id")%></td>
<td width="38%" align="center" height="28" ><a href="default.asp?sb=product&Product_id=<%=rs("Product_id")%>"><%=rs("Product_Name")%></a></td>
<td width="16%" align="center" height="28"><%=rs("P_NewPrice")%></td>
<td width="18%" align="center" height="28"><span class="main1"><strike><%=rs("P_OldPrice")%>元</strike></span><font color="#cc0000"> </font></td>
<td width="15%" align="center" height="28"><a href="javascript:openbag('../check.asp?cpbm=<%=rs("Product_Id")%>&shopname=<%=rs("p_shop")%>')"><img style="CURSOR: hand" height="22" src="../images/che1.gif" width="56" align="absMiddle" border="0"></a></td>
</tr>
<%
rs.movenext
count=count+1
loop
%>
</table>
<div align="center"><br>
[<b><%=rs.pagecount%></b>/<%=page%>页] [共<%=totalfilm%>个]
<%if page=1 then%>
[首 页] [上一页]
<% else %>
[<a href="default.asp?sb=bill&page=1">首 页</a>] [<a href="default.asp?sb=bill&page=<%=page-1%>">上一页</a>]
<%end if%>
<%if rs.pagecount-page<1 then%>
[下一页] [尾 页]
<%else%>
[<a href="default.asp?sb=bill&page=<%=page+1%>">下一页</a>] [<a href="default.asp?sb=bill&page=<%=rs.pagecount%>">尾
页</a>]
<%end if%>
<%
end if
rs.close:set rs=nothing
%>
<!-- 最新商品结束-------------------------------------------------- -->
</div></td>
</tr>
<tr>
<td valign="top"> </td>
</tr>
</table>
<%end sub%>
<%sub news%>
<!--新闻公告开始=========================================== -->
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>首页:新闻公告</td>
</tr>
<tr>
<td height="10" > </td>
</tr>
<tr>
<td valign="top">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="3">
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from news where shop_name='"&shop_name&"'"
rs.open sqltext,conn,1,1
'假如没有新闻时
If rs.eof and rs.bof then
response.write "没有新闻内容"
else
do while not (rs.eof or rs.bof)
%>
<tr>
<td width="55%">>>> <a href="default.asp?sb=news_show&id=<%=rs("id")%>"><B><%=rs("n_top")%></B></a></td>
<td width="45%"><%=rs("n_time")%></td>
</tr>
<%
rs.movenext
loop
rs.close:set rs=nothing
%>
</table>
<%end if%></div>
</td>
</tr>
<tr>
<td valign="top"> </td>
</tr>
</table>
<%end sub%>
<%sub mode%>
<!--配送方式======================================= -->
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>首页:配送方式</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<%
set rs=server.createobject("adodb.recordset")
sqltext="select p_other from shop where shop_name1='"&shop_name&"' "
rs.open sqltext,conn,1,1
if not rs.eof then
response.write rs("p_other")
else
response.write "没有数据"
end if
rs.close:set rs=nothing
%>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<% end sub%>
<%sub help%>
<!--购物帮助======================================= -->
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>首页:购物帮助</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<%
set rs=server.createobject("adodb.recordset")
sqltext="select Enterprises from shop where shop_name1='"&shop_name&"' "
rs.open sqltext,conn,1,1
if not rs.eof then
response.write rs("Enterprises")
else
response.write "没有数据"
end if
rs.close:set rs=nothing
%>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<%end sub%>
<%sub word%>
<!--客户留言======================================= -->
<table width="516" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#6699FF">
<tr>
<TD width="552" height="25" align="center"><font color="#FFFFFF"><strong>功能限制</strong></font></TD>
</tr>
</table>
<table width="516" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#6699FF">
<tr>
<td width="512" height="196" bgcolor="#F0F5FF"><table border="0" cellpadding="0" cellspacing="0" width="100%" height="73">
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td height="20" colspan="2"><span class=p9orange><strong> 特区商城系统</strong></span></td>
</tr>
<tr>
<td width="33%" height="50" align="center"><a href="http://www.tequshop.com/SoftBuy/index.htm" target="_blank"><img src="IMAGES/tequshop.jpg" width="149" height="123" border="0"></a></td>
<td width="67%"> 您好,您现在使用的是特区商城的测试版,有一部分功能将受到限制,在您试用后如果觉得满意,欢迎您与我们联系购买正式版使用。<br>
<br>
深圳市玉龙网络技术有限公司 <br>
http://www.dns100.cn <br>
Tel:(0755)61321320 Fax:(0755)82414037 <br>
公司地址:深圳市泥岗路万年青大楼502室 <br>
PostCode:518000 Email:web@dns100.cn</td>
</tr>
<tr>
<td height="63" colspan="2"><TABLE
width="98%" border=0 align="center" cellPadding=0 cellSpacing=0 class=p9gray>
<TBODY>
<TR>
<TD vAlign=left><SPAN
class=p9orange> </SPAN> <table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="right"><strong><font color="#FF9900">进入特区商城系统正式版</font></strong><font color="#FF9900">--</font> <a href="http://www.tequshop.com/SoftBuy/index.htm" target="_blank">简介</a>
| <a href="http://www.tequshop.com/SoftBuy/index1.htm" target="_blank">演示</a>
| <a href="http://www.tequshop.com/SoftBuy/index2.htm" target="_blank">安装</a>
| <a href="http://www.tequshop.com/SoftBuy/index3.htm" target="_blank">购买</a>
| <a href="http://www.tequshop.com/SoftBuy/index4.htm" target="_blank">升级</a>
| <a href="http://www.tequshop.com/SoftBuy/index5.htm" target="_blank">服务</a>
| <a href="http://www.tequshop.com/SoftBuy/index6.htm" target="_blank">成功案例</a>
</div></td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
</table></td>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -