search-order.asp

西亚电子购物系统

<!--#include file="header.asp" -->
<!--#include file="conn/nosql.asp" -->
<table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr> 
    <td width="185" valign="top" class="table-right">
<!--#include file="left.asp" -->&nbsp;</td>
    <td height="350" valign="top"> <p>&nbsp;</p>
      <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;您查询的订单号为: 
        <%
	    ordernumber=nosql(request("ordernumber"))
        response.write "<font color=red>"
        response.write ordernumber
        response.write "</font>"
        response.write "<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
        sql="select * from sia_order where ordernumber='"&ordernumber&"'"
          set rs=server.createobject("adodb.recordset")
          rs.open sql,conn,3,3
          if rs.eof then
              response.write "没有此订单信息,请确认您的订单号输入是否正确"
          else
              if rs("orderstate")="尚未处理" then
                  response.write "您输入的订单尚在处理中，我们会及时的处理！"
              else
                  response.write "订单已确认，货物已递出！请耐心等待。"
              end if
			end if	  
   rs.close
set rs=nothing
%>
      </p></td>
  </tr>
</table>
<!--#include file="footer.asp" -->