📄 baojia.asp

📁 凡人网络购物系统 v8.0 中文版
💻 ASP
字号:
<!--#include file="conn.asp"-->
<title>商品报价表</title>
<link href=Skin/<%=venshop_skin%>/css.css rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<body topmargin="3" leftmargin="3" rightmargin="3" bottommargin="3">
<table border="0" cellpadding="0" cellspacing="0" width="980">
<tr><td>
<script>
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"' ");
if (restore) selObj.selectedIndex=0;
}
</script>
<%If Request.ServerVariables("QUERY_STRING") = "" Then
url="http://"&Request.ServerVariables("SERVER_NAME")&Request.ServerVariables("SCRIPT_NAME")
Else
url="http://"&Request.ServerVariables("SERVER_NAME")&Request.ServerVariables("SCRIPT_NAME")&"?"&Request.ServerVariables("QUERY_STRING")
End If%>
<select name="menu1" onChange="MM_jumpMenu('self',this,0)" class="font">
<option value="index.asp" selected>请选择分类</option>
<%set rs8=server.CreateObject("adodb.recordset")
rs8.open "select * from venshop_sort order by sort_id desc" ,conn,1,1
do while not rs8.eof and not rs8.bof%><option value="baojia.asp?sort_id=<%=rs8("sort_id")%>"><%=rs8("sort_name")%></option>
<%rs8.movenext
loop
rs8.close
set rs8=nothing%></select></td>
<td align="center"><a href="baojiap.asp?sort_id=<%=request("sort_id")%>">打印报价单</a></td></tr></table>
<%
set rss=server.createobject("adodb.recordset")
if request("sort_id")<>"" then
sortid=request("sort_id")
If Not(isNumeric(sortid)) or sortid="" or sortid=0 Then
response.write "<script language=javascript>alert('Url处理出错！');history.go(-1);</script>"
response.End
End If
rss.open "select * from venshop_sort where sort_id="&sortid&"",conn,1,1
else
rss.open "select * from venshop_sort order by sort_id desc",conn,1,1
end if
do while not rss.eof
sort_id=rss("sort_id")
set rs=server.createobject("adodb.recordset")
rs.open "select * from venshop_hw where sort_id="&sort_id&" and hw_kucun>0 order by hw_id desc",conn,1,1
%>
<table border=0 cellpadding=5 cellspacing=1 width="980" bgcolor="#FFFFFF">
	<tr><td colspan="6" bgcolor="#CCCCCC"><b><font color="#FF0000"><%=rss("sort_name")%></font>商品报价单</b></td></tr>
	<tr bgcolor="#EEEEEE"><td width="200"><b>商品</b></td>
		<td width="120"><b>零售价</b></td>
		<td width="120"><b>本站价</b></td>
		<td width="60" align="center"><b>购买</b></td>
		<td><b>简介</b></td>
		<td width="100"><b>详细介绍</b></td>
	</tr>
<%i=1
do while not rs.eof
i=-i%>
	<tr<%if i=-1 then%> bgcolor="#FFFFFF"<%else%> bgcolor="#F5F5F5"<%end if%>>
	<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #FFFFFF" width="200"><a href=views.asp?hw_id=<%=rs("hw_id")%> target=_blank><%=rs("hw_name")%></a></td>
	<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #FFFFFF" width="120">￥<%=trim(rs("hw_price1"))%>元</td>
	<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #FFFFFF" width="120"><font color=#ff0000>￥<%=trim(rs("hw_price2"))%></font>元</td>
	<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #FFFFFF" width="60" align="center"><a href="basket.asp?hw_id=<%=rs("hw_id")%>"><img border="0" src="img/buy.gif"></a></td>
	<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #FFFFFF"><%=rs("hw_content")%></td>
	<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #FFFFFF" width="100"><a href=views.asp?hw_id=<%=rs("hw_id")%> target=_blank>详细介绍</a></td>
	</tr>
<%rs.movenext  
loop  
rs.close
set rs=nothing
rss.movenext  
loop  
rss.close
set rss=nothing%></table>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -