📄 hyfw_order_view.asp

📁 机票预定系统各个模块的设计-ticket reservation systems detailed design system modules of the design
💻 ASP
字号:
<!--#include file="function/conn.asp"-->
<%
	dim szSQL,oRderStatus
    set oRst=Server.CreateObject("AdoDb.recordset")
    OrderID=request("code_id")
     if len(OrderID)=0 then
	   OrderID="-1"
	 end if
    szSQL="select * from Prize where Prize_id="&OrderID
    oRst.Open szSQL,conn,1,1
    if not oRst.Eof then
	   OrderID=oRst("Prize_id")	
	   Order_Code=oRst("Order_Code")
	   tro_Name3=oRst("tro_Name3")
	   tro_Code=oRst("tro_Code")	
	   tro_txt=oRst("tro_txt")		
	   tro_date=oRst("tro_date")	
	   tro_conent=oRst("tro_conent")
	   tro_Name=oRst("tro_Name")
	   tro_TicketNum=oRst("tro_TicketNum")
	   tro_Tel1=oRst("tro_Tel1")
	   tro_Tel2=oRst("tro_Tel2")
	   tro_Email=oRst("tro_Email")
	   tro_Address=oRst("tro_Address")
	   tro_PC=oRst("tro_PC")
	   tro_Remark=oRst("tro_Remark")
	   tro_update=oRst("tro_update")
	   YdSxf=oRst("YdSxf")	
	   TotalPrice2=oRst("TotalPrice2")	
	   TicketCount=oRst("TicketCount")	
	   GetDateTime=oRst("GetDateTime")	
	   GetUser=oRst("GetUser")	
	   GetDes=oRst("GetDes")	
	   CheckDateTime=oRst("CheckDateTime")	
	   CheckUser=oRst("CheckUser")	
	   CheckSender=oRst("CheckSender")	
	   CheckSendTime=oRst("CheckSendTime")	
	   CheckDes=oRst("CheckDes")	
	   ApproveDateTime=oRst("ApproveDateTime")	
	   ApproveUser=oRst("ApproveUser")	
	   AriveTime=oRst("AriveTime")	
	   ApprovePrice=oRst("ApprovePrice")	
	   ApproveDes=oRst("ApproveDes")	
	   EndTime=oRst("EndTime")	
	   EndUser=oRst("EndUser")	
	   IsPrice=oRst("IsPrice")	
	   EndDes=oRst("EndDes")	
	   CancelTime=oRst("CancelTime")	
	   CancelUser=oRst("CancelUser")	
	   CancelStatus=oRst("CancelStatus")	
	   CancelWhy=oRst("CancelWhy")	
	   CancelDes=oRst("CancelDes")
	OrderState=oRst("OrderState")
    if OrdStatus="1" then OrdStatus1="checked"
    if OrdStatus="2" then OrdStatus2="checked"
    if OrdStatus="3" then OrdStatus3="checked"
    if OrdStatus="4" then OrdStatus4="checked"
    if OrdStatus="5" then OrdStatus5="checked"
%>
<!--#include file="../../config.asp"--><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>订单状态查询</title>
<link href="RLimages/user.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
.style2 {color: #666666}
.style3 {
	color: #FFFFFF;
	font-weight: bold;
}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<TABLE 
      width=585 border=0 align="center" cellPadding=0 cellSpacing=0 id=Table_01>
  <TBODY>
    <TR> 
      <TD height="34">&nbsp;</TD>
      <TD align="center" bgcolor="#2E7FD1" class="b-14"><span class="style3">客户网上订单查询通知单</span></TD>
      <TD>&nbsp;</TD>
    </TR>
    <TR> 
      <TD width="1" height="16">&nbsp;</TD>
<TD width="585" align="center" vAlign=top>

          <TABLE 
            width="585" border=0 align="center" cellPadding=0 cellSpacing=1 borderColor=#66cccc bgcolor="#999999" class="back-12">
          <TBODY>
            <TR bgcolor="#FFFFFF"> 
              <TD height=30 colSpan=4>　<span class="style1">您的订单号为：<b><%=Order_Code%></b></span></TD>
            </TR>
            <TR bgcolor="#FFFFFF">
              <TD height=0> 　奖品名称： <BR>              </TD>
              <TD height=0 bgcolor="#FFFFFF" class="back-12 style2"> &nbsp; <%=tro_Name3%> </TD>
              <TD height=25 bgcolor="#FFFFFF">　邮寄代号：</TD>
              <TD bgcolor="#FFFFFF"><span class="style2">&nbsp; <%=tro_Code%> <font face="宋体"></font></span></TD>
            </TR>
            <TR bgcolor="#FFFFFF">
              <TD height=25> 　补充说明：</TD>
              <TD height=25 colspan="3"><span class="back-12 style2">&nbsp; </span><%=tro_txt%></TD>
            </TR>
            <TR bgcolor="#FFFFFF">
              <TD height=25> 　<font face=宋体>入住日期</font></TD>
              <TD height=25 colspan="3"><span class="back-12 style2">&nbsp; </span><%=tro_date%></TD>
            </TR>
            <TR bgcolor="#FFFFFF"> 
              <TD width="23%" height=0> 　您的姓名： <BR> 
              </TD>
              <TD width="26%" height=0 bgcolor="#FFFFFF" class="back-12 style2"> &nbsp; <%=tro_Name%>                </TD>
              <TD width="18%" height=25 bgcolor="#FFFFFF">　订数量：</TD>
              <TD width="33%" bgcolor="#FFFFFF"><span class="style2">&nbsp; 
                <%=tro_TicketNum%>                <font face="宋体">张</font><font face="宋体"></font></span></TD>
            </TR>
            <TR bgcolor="#FFFFFF"> 
              <TD width="23%" height=0 bgcolor="#FFFFFF"><font face=宋体>　联系电话1： 
                </font></TD>
              <TD width="26%" height=0><span class="style2">&nbsp;<%=tro_Tel1%> </span></TD>
              <TD height=25 bgcolor="#FFFFFF">　<font face=宋体>联系电话</font>2：</TD>
              <TD bgcolor="#FFFFFF"><span class="style2">&nbsp; <%=tro_Tel2%></span></TD>
            </TR>
            <TR bgcolor="#FFFFFF"> 
              <TD width="23%" height=0>　您的E-mail：<font color=#6699ff face=华文行楷>&nbsp; 
                </font></TD>
              <TD>&nbsp;<span class="style2"> <%=tro_Email%>                </span></TD>
              <TD height=25 bgcolor="#FFFFFF"><font color=>　</font><font face=宋体>邮政编码：</font></TD>
              <TD bgcolor="#FFFFFF"><span class="style2">&nbsp; 
                <%=tro_PC%>                </span></TD>
            </TR>
            <TR bgcolor="#FFFFFF">
              <TD height=30 bgcolor="#FFFFFF"><font face=宋体>　送票地址：</font><FONT color=#6699ff face=宋体>　</FONT></TD>
              <TD colspan="3" bgcolor="#FFFFFF"><font color=#6699ff face=华文行楷> &nbsp; <%=tro_Address%> </font></TD>
            </TR>
            <TR bgcolor="#FFFFFF"> 
              <TD height=30 bgcolor="#FFFFFF"><FONT face=宋体>　补充说明：</FONT><FONT color=#6699ff face=宋体>　</FONT></TD>
              <TD height=50 colspan="3" bgcolor="#FFFFFF"><font color=#6699ff face=华文行楷> 
&nbsp; 
<%=tro_Remark%>                </font></TD>
            </TR>
          </TBODY>
        </TABLE>
          
        <TABLE 
            width="585" border=0 align="center" cellPadding=0 cellSpacing=1 borderColor=#66cccc bgcolor="#999999" class="back-12">
          <TBODY>
            <TR bgcolor="#FFFFFF"> 
              <TD height=25><FONT color=#6699ff face=宋体>　</FONT><FONT face=宋体>预订</FONT>手续费：<span class="style2">&nbsp; <%=TotalPrice2%>               </span>合计费用：<span class="style2"> <%=orst("TotalPrice2")%></span></TD>
            </TR>
            <TR bgcolor="#CCCCCC">
              <TD height=30>　以下为订单的处理状态：</TD>
            </TR>
            <%if OrderState="1" then
			%>
            <TR> 
              <TD height=30 bgcolor="#FFFFFF">　您的订单已成功提交，正在处理中。</TD>
            </TR>
			<% else
			   if  OrderState="2" then %>
            <TR> 
              <TD height=30 bgcolor="#FFFFFF">　您的订单已被确认。<%=ZXLCompanyStr%>商旅网的311号工作人员正在去往贵方约定所在地。敬请等待，多谢合作。</TD>
            </TR>
			<% else
			   if  OrderState="5" then %>
            <TR> 
              <TD height=30 bgcolor="#FFFFFF">　您的<%=orst("tro_codeid")%>号订单已取消。</TD>
            </TR>
			<% else
			   if  OrderState="3" or OrderState="4" then %>
			<TR> 
              <TD height=30 bgcolor="#FFFFFF">　您的订单已经交易成功。</TD>
            </TR>
			<% 
			end if
			end if
			end if
			end if
			 %>
            <TR>
              <TD height=30 bgcolor="#CCCCCC">如果您要求更改或取消预订请致电：<%=ZXLTelCenter%></TD>
            </TR>
            <TR> 
              <TD height=30 align="center" bgcolor="#FFFFFF"><table width="116" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
                  <tr> 
                    <td width="110" height="18" align="center" valign="bottom" bgcolor="#FF9900"><FONT class=small><A href="javascript:close()" class="b-14"><strong>关闭窗口</strong></A></FONT></td>
                  </tr>
                </table></TD>
            </TR>
          </TBODY>
        </TABLE>
     </TD>
      <TD width="1">&nbsp;</TD>
    </TR>
  </TBODY>
</TABLE>
</body>
</html>
<%
else
%>
<script language="JavaScript">
		alert("对不起，未找到该记录，如有问题请与<%=ZXLTelCenter%>联系!");
		//window.history.go(-1);
		//window.opener.relaodme();
		window.close();
	</script>
<%
end if 
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -