📄 query.asp
字号:
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD colSpan=3> <TABLE border=0 cellPadding=0 cellSpacing=0 width=606>
<TBODY>
<TR>
<TD><IMG height=35 src="images/pics2/wp_sbox_01.gif"
width=5></TD>
<TD background=images/pics2/wp_sbox_02.gif width=596>
<form action="search.asp" method="post" name="form" id="form">
<TABLE width="570" border=0 align=left cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=95><font color=#666666><img
height=20 src="images/pics2/wp_sbox_search_pp2.gif"
width=94></font></TD>
<TD width="169" align=right> <div align="center">
<input type="text" name="hw_name" size="20" class=input>
</div></TD>
<TD width=62><div align="center">
<input type="image" border="0" name="imageField" src="IMAGES/pics2/wp_sbox_bt_search.gif" width="51" height="19">
</div></TD>
<TD width=65><div align="right"><img src="IMAGES/pics2/icon_money.gif" width="19" height="13"></div></TD>
<TD width=42 valign="middle"><div align="center">原价</div></TD>
<TD width=15><div align="right"><img src="IMAGES/pics2/icon_unisex.gif" width="14" height="13"></div></TD>
<TD width=52><div align="center">会员价</div></TD>
<TD width=15><div align="right"><img src="IMAGES/pics2/icon_heart.gif" width="14" height="12"></div></TD>
<TD width=55><div align="center">贵宾价</div></TD>
</TR>
</TBODY>
</TABLE>
</form></TD>
<TD><IMG height=35 src="images/pics2/wp_sbox_03.gif"
width=5></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD height=6></TD>
</TR>
</TBODY>
</TABLE>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="14%" height="2" valign="top" background="IMAGES/pics2/top_bg.gif"> </td>
<td height="2" width="60%" background="images/pics2/top_bg.gif" valign="top"> </td>
<td height="2" width="4%" align="right" valign="top"><img src="images/pics2/join.gif" width="56" height="41"></td>
<td height="2" width="10%" align="right" valign="top"><a href="ding1.asp"><img src="images/pics2/avarta_bu.gif" width="128" height="41" border="0"></a></td>
<td height="2" width="12%" align="right" valign="top"><a href="ding2.asp"><img src="images/pics2/item_bu.gif" width="129" height="41" border="0"></a></td>
</tr>
<tr>
<TD height=6></TD>
</tr>
</table>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=606>
<TBODY>
<TR>
<TD width="606"><IMG height=24
src="images/pics2/querylg.gif" width=606></TD>
</TR>
<TR>
<TD height="67"> <TABLE width=575 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD colSpan=3> <TABLE class=board_field height=31 cellSpacing=0
cellPadding=0 width="100%"
background=images/pics2/bg_top.gif border=0>
<TBODY>
<TR>
<TD align=middle width=1> </TD>
<TD vAlign=center align=left> </TD>
<TD width=42></TD>
<TD width=42> </TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR bgColor=#ffffff>
<TD colSpan=3></TD>
</TR>
<TR bgColor=#ffffff>
<TD colSpan=3> <TABLE height="100%" cellSpacing=0 cellPadding=0
width="100%" bgColor=#CCCCCC border=0>
<TBODY>
<TR>
<TD height="30" align=middle vAlign=middle bgColor=#ffffff> 订单号
:
<%sub_number=trim(request("sub_number"))
response.write "<font color=red>"
response.write sub_number
response.write "</font>"
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 " 没有此订单信息,请确认你的订单号输入是否正确"
else
if rs("sub_check")=false then
response.write " 订单尚在处理中！"
else
response.write " 订单已确认！商品已递出!请注意查收！"
end if
%>
<b></b> <IMG
src="images/pics2/ic_sendmail.gif" align=absMiddle
border=0></TD>
</TR>
</TBODY>
</TABLE></TD>
<TR bgColor=#FDFEFF>
<TD colSpan=3 height=3></TD>
</TR>
<TR bgColor=#FDFEFF>
<TD width="2%"> </TD>
<TD width="96%" vAlign=top class=board_default>
<TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: 奔覆眉"
width="100%">
<TBODY>
<TR>
<TD> <DIV><br>
<table width="90%" border="0" align="center" cellspacing="1" background="IMAGES/pics2/querybg.gif">
<tr background="IMAGES/pics2/querybg.gif">
<td width="44%" height="25"><div align="center"><font color="#FFFFFF">商品名称</font></div></td>
<td width="17%" height="25"><div align="center"><font color="#FFFFFF">数量</font></div></td>
<td width="18%" height="25"><div align="center"><font color="#FFFFFF">单价</font></div></td>
<td width="21%" height="25"><div align="center"><font color="#FFFFFF">合计</font></div></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 bgcolor="#FFFFFF">
<td width="44%" height="25"><div align="center"><%=rs1("hw_name")%>
</div></td>
<td width="17%" height="25"><div align="center"><%=rs1("basket_count")%>
</div></td>
<td width="18%" height="25"><div align="center"><%=rs1("hw_cash")%>
元</div></td>
<td width="21%" height="25"><div align="center"><%=rs1("basket_count")*rs1("hw_cash")%>
元</div></td>
</tr>
<%totalcash=totalcash+(rs1("basket_count")*rs1("hw_cash"))%>
<%rs1.movenext
loop
rs1.close
set rs1=nothing
%>
<tr bgcolor="#FFFFFF">
<td height="22" colspan="3"> <div align="center">合计</div></td>
<td width="21%" height="22"> <div align="center"><font color=red><%=totalcash%>元</font></div></td>
</tr>
</table>
<br>
<%
end if
rs.close
%>
</DIV></TD>
</TR>
</TBODY>
</TABLE></TD>
<TD width="2%" bgcolor="#FDFEFF"> </TD>
</TR>
<TR>
<TD background=images/pics2/bg_bttm.gif colSpan=3
height=35> </TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD colSpan=3 height=28> </TD>
</TR>
</TBODY>
</TABLE>
<!--#include file="copy.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -