📄 moreinfo.asp
字号:
<!--#include file="session.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="img/admin_style.css">
<title>详细订单信息</title></head>
<body>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="mainmiddle">
<tr>
<td width="29" height="32"> <div align="left">
<p class="maindaohang"> </p>
</div></td>
<td width="709"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<b><font color="#000000"><b> <span class="bigNavi"> 详细订单信息</span> </b></font></b></td>
<td width="8" class="mainrights"></td>
</tr>
</table>
<br>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from theorder where order_id="&request("moreid")
rs.open sql,conn,3,3
if rs.eof then
response.write"没有此订单的详细信息!"
else
ordernum=rs("order_number")
%>
<table width="95%" height="22" border="0" align="center" cellpadding="3" cellspacing="1" class="tabbgcolor">
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">订单号</div></td>
<td width="25%"><div align="center"><%=ordernum%></div></td>
<td width="25%"><div align="center">订货时间</div></td>
<td width="25%"><div align="center"><%=rs("order_date")%></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">订货人</div></td>
<td width="25%"><div align="center"><%=rs("guest")%></div></td>
<td width="25%"><div align="center">收获人</div></td>
<td width="25%"><div align="center"><%=rs("reciver")%></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">E-mail</div></td>
<td width="25%"><div align="center"><%=rs("email")%></div></td>
<td width="25%"><div align="center">联系电话</div></td>
<td width="25%"><div align="center"><%=rs("guest_tel")%></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">收货地址</div></td>
<td width="25%"><div align="center"><%=rs("guest_addr")%></div></td>
<td width="25%"><div align="center">邮政编码</div></td>
<td width="25%"><div align="center"><%=rs("guest_post")%></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">送货方式</div></td>
<td width="25%"><div align="center"><%=rs("way")%></div></td>
<td width="25%"><div align="center">汇款方式</div></td>
<td width="25%"><div align="center"><%=rs("money")%></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">其他留言</div></td>
<td colspan="3">
<div align="center"><%=rs("other")%></div></td>
</tr>
<%
rs.close
end if
%>
</table>
<br>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="mainmiddle">
<tr>
<td width="29" height="32"> <div align="left">
<p class="maindaohang"> </p>
</div></td>
<td width="709"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<b><font color="#000000"><b> <span class="bigNavi"> 定购商品清单</span> </b></font></b></td>
<td width="8" class="mainrights"></td>
</tr>
</table>
<br>
<table width="95%" height="22" border="0" align="center" cellpadding="3" cellspacing="1" class="tabbgcolor">
<tr class="tabbgcolorli">
<td width="25%"> <div align="center">商品名称</div></td>
<td width="25%"><div align="center">商品单价</div></td>
<td width="25%"><div align="center">定购数量</div></td>
<td width="25%"><div align="center">商品总价</div></td>
</tr>
<%
sql1="select * from basket where order_number='"&ordernum&"'"
rs.open sql1,conn,3,3
if rs.eof then
response.write"没有此订单所列的商品清单！"
else
do while not rs.eof
%>
<tr class="tabbgcolorli">
<td width="25%"> <div align="center"><%=rs("sp_name")%></div></td>
<td width="25%"><div align="center"><%=rs("memprice")%>元</div></td>
<td width="25%"><div align="center"><%=rs("count")%></div></td>
<td width="25%"><div align="center"><%=rs("memprice")*rs("count")%>元</div></td>
<%totalmoney=totalmoney+rs("memprice")*rs("count")%>
</tr>
<%
rs.movenext
loop
%>
<tr class="tabbgcolorli">
<td width="25%"><div align="center">全部商品总价:</div></td>
<td colspan="3">
<div align="center"><%=totalmoney%>元</div></td>
</tr>
<%
end if
rs.close
set rs=nothing
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -