<!--#include file="admin_chk.asp"-->
<!--#include file="book_conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="page.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.b {color:#cccc99;font-size:10pt;border:dotted 1px}
.style2 {color: #FF9900}
.style3 {color: #999999}
-->
</style>
</head>

<body>
<table width="188" height="34" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div align="center">订单管理</div></td>
  </tr>
</table>
<table width="568" height="262" border="0" align="center" cellpadding="0" 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">
            <br>
            <form name="form1" method="post" action="shop_ddedit.asp">
              <table width="505" height="276" border="0" align="center" cellpadding="4" cellspacing="0">
                <tr>
                  <td width="73"><div align="right">会员　ID：</div></td>
                  <td colspan="2"><input name="userid" type="text" class="form" id="userid" value="<%=rs("userid")%>">
                  &nbsp;&nbsp;&nbsp;&nbsp;修改订单状态：
                  <select name="Status" class="form" id="Status">
                   <option value="0" selected><% if rs("Status")=0 then %>新订单<%end if %><% if rs("Status")=11 then %>自行取消<%end if %><% if rs("Status")=99 then %>订单完成<%end if %></option>
				    <%if rs("status")=11 then %><option value="11">自行取消</option><%else%>
					
					<option value="0">新订单</option>
                  <!--<option value="11">自行取消</option>-->
                    <option value="99">订单完成</option>
                  </select><%end if%></td>
                </tr>
                <tr>
                  <td><div align="right">预付方式：</div></td>
                  <td colspan="2"><input name="pei" type="text" class="form" id="pei" value="<%=rs("pei")%>" size="30"></td>
                </tr>
                <tr>
                  <td><div align="right">联系人名：</div></td>
                  <td colspan="2"><input name="recname" type="text" class="form" id="recname" value="<%=rs("recname")%>"></td>
                </tr>
                <tr>
                  <td><div align="right">联系电话：</div></td>
                  <td colspan="2"><input name="recphone" type="text" class="form" id="recphone" value="<%=rs("recphone")%>"></td>
                </tr>
                <tr>
                  <td><div align="right">联系邮箱：</div></td>
                  <td colspan="2"><input name="recmail" type="text" class="form" id="recmail" value="<%=rs("recmail")%>"></td>
                </tr>
                <tr>
                  <td><div align="right">接送备注：</div></td>
                  <td colspan="2"><input name="zipcode" type="text" class="form" id="zipcode" value="<%=rs("recaddress")%>"></td>
                </tr>
                <tr>
                  <td><div align="right">入住时间：</div></td>
                  <td colspan="2"><input name="recaddress" type="text" class="form" id="recaddress" value="<%=rs("gettime")%>" size="50"></td>
                </tr>
                <tr>
                  <td><div align="right">顾客说明：</div></td>
                  <td colspan="2"><textarea name="notes" cols="40" rows="5" class="form" id="notes"><%=rs("notes")%></textarea>
                    <input name="ordernum" type="hidden" id="ordernum" value="<%=ordernum%>"></td>
                </tr>
                <tr>
                  <td><div align="right">处理意见：</div></td>
                  <td colspan="2"><textarea name="memo" cols="40" rows="5" class="form" id="memo"><%=rs("memo")%></textarea></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td width="159"><div align="center">
                    <input name="Submit" type="submit" class="form2" value="修改">
                  </div></td>
                  <td width="249"><input name="Submit" type="button" class="form2" value="返回"></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>            
            </form></td>
  </tr>
</table>
</body>
</html>

 
