<!--#include file=conn.asp-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>订单查寻</title>
<link rel="stylesheet" href="shop.css" type="text/css">
<style type="text/css">
<!--
.style2 {color: #FF9900}
.style3 {color: #999999}
.style4 {color: #FF0000}
-->
</style>
</head>

<body>
<table width="579" height="287" border="0" align="center" cellpadding="8" cellspacing="1" bgcolor="#CCCCCC">
  <tr>
    <td valign="top" bgcolor="#FFFFFF"><br>
        <% set rs=server.CreateObject("adodb.recordset")
	  ordernum=request("ordernum")
	  sql="select * from orderlist where ordernum='"&ordernum&"'"
rs.open sql,conn,1,3 
fei =rs("fei")%>
        <table width="508" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="508"><span class="style2"><span class="style3">订单号：</span><%= rs("ordernum") %>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="style3">下单时间：</span><%= rs("ordertime") %></span></td>
          </tr>
        </table>
        <hr width="90%" size="1" class="form">
        <table width="505" height="241" border="0" align="center" cellpadding="4" cellspacing="0">
          <tr>
            <td width="73"><div align="right">会员　ID：</div></td>
            <td width="408" colspan="2"><%=rs("userid")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">预付方式：</div></td>
            <td colspan="2"><%=rs("pei")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">联系人名：</div></td>
            <td colspan="2"><%=rs("recname")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">联系电话：</div></td>
            <td colspan="2"><%=rs("recphone")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">联系邮箱：</div></td>
            <td colspan="2"><%=rs("recmail")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">入住时间：</div></td>
            <td colspan="2"><%=rs("gettime")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">接送备注：</div></td>
            <td colspan="2"><%=rs("recaddress")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">顾客说明：<br>
              </div></td>
            <td colspan="2"><%=rs("notes")%>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="right">客服处理：</div></td>
            <td colspan="2"><span class="style4"><%=rs("memo")%></span></td>
          </tr>
        </table>
        <% rs.close
			  set rs=nothing
			   %>
        <hr width="90%" size="1" class="form">
        <table width="505" height="28" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="158" height="28"><div align="center">名称</div></td>
            <td width="121"><div align="center">购买数量</div></td>
            <td width="104"><div align="center">单价</div></td>
            <td width="122"><div align="center">合计</div></td>
          </tr>
        </table>
        <% set rs=server.CreateObject("adodb.recordset")
	  ordernum=request("ordernum")
	  sql="select * from orderdetail where ordernum='"&ordernum&"'"
rs.open sql,conn,1,1
sum=0
do while not rs.eof
prodid=rs("prodid")
sqll="select * from shop where prodid='"&prodid&"'"
set rs1=server.CreateObject("adodb.recordset")
rs1.open sqll,conn,1,1  %>
        <table width="505" height="28" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="158" height="28"><div align="center"><a href="../jiudian1.asp?prodid=<%=rs("prodid")%>" target="_blank"><%= rs1("shop_name") %></a></div></td>
            <td width="121"><div align="center"><%= rs("produnit") %></div></td>
            <td width="104"><div align="center"><%= rs1("shop_jg") %>.00</div></td>
            <td width="122"><div align="center">
                <%sum1=rs("produnit")*rs1("shop_jg")  %>
                <%= sum1 %>.00</div></td>
          </tr>
        </table>
        <%
			  sum=sum+sum1
			  rs1.close
			  set rs1=nothing
			  rs.movenext
			  loop%>
        <hr width="90%" size="1" class="form">
        <table width="505" height="39" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="156"><div align="center">合计：<span class="style2"><%= sum %>.00</span></div></td>
            <td width="162"><div align="center"></div></td>
            <td width="187"><div align="center">总计费用：<span class="style2"><%= fei+sum %>.00</span></div></td>
          </tr>
        </table>
        <p>&nbsp; </p></td>
  </tr>
</table>
</body>
</html>
 
