?? query.asp
字號(hào):
<!--#include file="top.asp"-->
<center>
<table border="0" width="760" cellspacing="0" cellpadding="0" height="312">
<tr>
<td width="190" height="312" valign="top" align="left">
<table border="0" width="190" cellspacing="0" cellpadding="0">
<tr>
<td width="190" valign="top" align="left"><!--#include file="left.asp"--></td>
</tr>
</table>
</td>
</center>
<td width="380" valign="top" align="left">
<table border="0" width="380" cellspacing="0" cellpadding="0" height="5">
<tr>
<td width="380" bgcolor="#FF9A31" height="18">
貨物交易狀態(tài)
</td>
</tr>
<tr>
<td width="100%" bgcolor="#63CFFF">
<table border="0" width="100%" cellspacing="1">
<tr>
<td width="100%" bgcolor="#FFFFFF">訂單號(hào)為<%sub_number=trim(request("sub_number"))
response.write "<font color=red>"
response.write sub_number
response.write "</font>"
response.write "<br>"
sql="select * from sub where sub_number='"&sub_number&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof then
response.write "沒有此訂單信息,請(qǐng)確認(rèn)你的訂單號(hào)輸入是否正確"
else
if rs("sub_check")=false then
response.write "訂單尚在處理中!"
else
response.write "訂單已確認(rèn)!貨物已遞出"
end if
%>
<table border="0" width="100%" cellspacing="1">
<tr>
<td width="20%">商品編號(hào)</td>
<td width="20%">商品名稱</td>
<td width="20%">數(shù)量</td>
<td width="20%">單價(jià)</td>
<td width="20%">合計(jì)</td>
</tr><%sql="select * from basket where sub_number='"&sub_number&"'"
set rs1=server.createobject("adodb.recordset")
rs1.open sql,conn,3,3
do while not rs1.eof%>
<tr>
<td width="20%"><%=rs1("hw_id")%></td>
<td width="20%"><%=rs1("hw_name")%></td>
<td width="20%"><%=rs1("basket_count")%></td>
<td width="20%"><%=rs1("hw_cash")%>元</td>
<td width="20%"><%=rs1("basket_count")*rs1("hw_cash")%>元</td>
</tr><%totalcash=totalcash+(rs1("basket_count")*rs1("hw_cash"))%>
<%rs1.movenext
loop
rs1.close
set rs1=nothing
%>
<tr>
<td width="80%" colspan="4">合計(jì)</td>
<td width="20%"><font color=red><%=totalcash%>元</font></td>
</tr>
</table>
<%
end if
rs.close
%></td>
</tr>
</table>
</td>
</tr>
<center>
<tr>
<td width="100%">
</td>
</tr>
</table>
</center>
</td>
<td width="190" valign="top" align="left">
<table border="0" width="190" cellspacing="0" cellpadding="0">
<tr>
<td width="190"><!--#include file="right.asp"--></td>
</tr>
</table>
</td>
</tr>
</table>
<!--#include file="copy.asp"-->
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -