<!-- #include virtual = "/include/myopen.asp" -->
<%
	set RS = Server.CreateObject("ADODB.RecordSet")
	set RS1 = Server.CreateObject("ADODB.RecordSet")
	set RS2 = Server.CreateObject("ADODB.RecordSet")
%>
<%	'判断用户是否登陆过
	IF Request.Cookies ("Admin_name") = "" OR Request.Cookies ("Admin_Pass") ="" THEN
	'没有登陆
	Response.Redirect ("/manage/Admin_Login.ASP")
	END IF
	IF REQUEST("HOME") <> "" THEN
	Response.Redirect ("/manage/default.asp")
	END IF
	IF REQUEST("Add") <> "" THEN
	Response.Redirect ("/manage/name_add.asp")
	END IF
	'用户已经成功注册

	DIM LK(20)
	
	SQL = "SELECT * FROM ORDER_DESC WHERE ORDER_NO = '" & Request("ORDER_NO") & "'"
	RS.Open SQL,CONN,adOpenKeyset ,adLockReadOnly
		IF RS.RecordCount >0 THEN
%>
<html>
<head>
<title>订单编号<%=REQUEST("ORDER_NO")%>查询结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.height {  line-height: 0.5pt}
td {  }
.word {  font-size: 9pt; color: #FFFFFF}
a:hover {  color: #CCFFCC; text-decoration: underline}
a {  text-decoration: none; color: #000066}
.border {  border-color: black #FF3300 black black; border-style: solid; border-top-width: 0px; border-right-width: 1px; border-bottom-width: 0px; border-left-width: 0px}
-->
</style>
</head>

<body bgcolor="#FFFFFF">

<div align="center"><font color="#0000FF"><br>
  <span class="word"><font color="#000000">定单编号为：<font color="#FF3333"><%=REQUEST("ORDER_NO")%></font>的详细商品资料</font></span></font> 
</div>
<form method="post" action="">
  <table width="750" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#66CCFF" bordercolordark="#FFFFFF" bgcolor="#DFEFFF">
    <tr bgcolor="#99CCFF"> 
      <td width="159" class="word" height="22"> 
        <div align="center"><font color="#000000">商品编号</font></div>
      </td>
      <td width="96" class="word" height="22"> 
        <div align="center"><font color="#000000">商品名称</font></div>
      </td>
      <td width="153" class="word" height="22"> 
        <div align="center"><font color="#000000">单位</font></div>
      </td>
      <td width="164" class="word" height="22"> 
        <div align="center"><font color="#000000">数量</font></div>
      </td>
      <td width="156" class="word" height="22"> 
        <div align="center"><font color="#000000">单价</font></div>
      </td>
      <td width="156" class="word" height="22"> 
        <div align="center"><font color="#000000">合计</font></div>
      </td>
    </tr>
    <%
    DO WHILE NOT RS.EOF 
    %> 
    <tr> 
      <td width="159" class="word"> 
        <div align="center"><font color="#000000"><%=RS("CARD_NO")%></font>&nbsp;</div>
      </td>
      <td width="250" class="word"> 
        <div align="center"><font color="#000000"> <%
        SQL1 = "SELECT LB FROM QIANBI WHERE NO1 = '" & RS("CARD_NO") & "'"
        RS1.Open SQL1,CONN,adOpenKeyset ,adLockReadOnly
			IF RS1.RecordCount >0 THEN
			Response.Write RS1("LB")
			ELSE
			Response.Write "无名称"
			END IF
		RS1.Close 
        %> </font></div>
      </td>
      <td width="15" class="word"> 
        <div align="center"><font color="#000000"><%=RS("CARD_UNIT")%></font>&nbsp;</div>
      </td>
      <td width="164" class="word"> 
        <div align="center"><font color="#000000"><%=RS("ORDER_NUM")%></font>&nbsp;</div>
      </td>
      <td class="word" width="156"> 
        <div align="center"><font color="#000000"><%=RS("CARD_PRICE")%></font>&nbsp;</div>
      </td>
      <td class="word" width="156"> 
        <div align="center"><font color="#000000"><%=RS("ORDER_TOTAL")%></font>&nbsp;</div>
      </td>
    </tr>
    <%
    RS.MoveNext 
    LOOP
    RS.Close 
    %> 
  </table>
  <div align="center">
    <input type="button" name="back" value="返回上页" onclick=history.back();>
    <input type="button" name="close" value="关闭窗口" onclick="self.close();">
  </div>
</form>
</body>
</html>



<%
ELSE
%>
没有记录
<%
END IF
%>