⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 hyfw_yw_01.asp

📁 机票预定系统 各个模块的设计-ticket reservation systems detailed design system modules of the design
💻 ASP
字号:
<!--#include file="function/m_conn.asp"-->
<%
    if len(session("login_name"))=0 then
%>
<script language="javascript">
    alert("您没有权限访问,请登陆!")
    window.location="index.asp"
</script>
<%
    end if
	dim szSQL,oRderStatus
    set oRst=Server.CreateObject("AdoDb.recordset")
    oRderStatus=request("oRderStatus")
    SearchFiled=request("SearchFiled")
    SearchKey=request("SearchKey")
    if len(SearchFiled)=0 then SearchFiled="tro_Name"
	szSQL="select * from Prize order by OrderUpDate desc"
	if SearchKey<>"" then
	szSQL="select * from Prize where  "& SearchFiled &" like '%" &SearchKey& "%' order by OrderUpDate desc"
	end if
    oRst.Open szSQL,conn,1,1
%>
<!--#include file="../../config.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=ZXLCompanyStr%>管理服务在线</title>
<link href="RLimages/user.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
function relaodme(){
	window.location="hyfw_yw_01.asp?oRderStatus=<%=oRderStatus%>";
}
//-->
</script>
</head>

<body>

<table cellpadding="0" cellspacing="1">
 <form name="FrmSearch" action="hyfw_yw_01.asp" method="post">
    <tr> 
         <td height="30" align="center" bgcolor="#FFFFFF" class="b-14"> <strong><span class="back-12">检索:</span></strong> 
              <select name="SearchFiled">
                <option selected>类别选择</option>
                <option>奖品</option>
                <option>抵用券</option>
                <option>VIP卡</option>
                <option>其它</option>
              </select> <input type="text" name="SearchKey" size="20"> <input name="Submit" type="submit" value=" GO "> 
      </td>
    </tr>
  </form>
</table>
<TABLE cellPadding=0 cellSpacing=1 >
          <TR bgColor=#C3E7F9> 
            <TH width="13%" height="25">订单号</TH>
            <TH width="11%"> 联系人</TH>
            <TH width="21%"> 联系电话</TH>
            <TH width="21%">兑换奖品</TH>
            <TH width="14%">所须积分</TH>
            <TH width="11%">状态</TH>
            <TH width="9%">操 作</TH>
          </TR>
          <%
            i=0
			while not oRst.eof 			
                i=i+1
                bc="bgcolor='#eff3f7'"
                if i mod 2=0 then bc="bgcolor='#FFFFFF'"
		  %>
          
          <TR <%=bc%> > 
            <TD height="25" align=center><%=oRst("Order_Code")%></TD>
            <TD align=center><a href="#" class="back-12" onMouseDown="MM_openBrWindow('hyfw_02.asp','会员注册资料','width=580,height=546')"><%=oRst("tro_name")%></a></TD>
            <TD align="center"><%=oRst("tro_tel1")%></TD>
            <TD align="center"><%=oRst("tro_name3")%></TD>
            <TD align="center"><%=oRst("TotalPrice2")%></TD>
            <TD align="center"><%
			 select case oRst("OrderState") 
			 case "1"  OrderTypeName="收到的订单"
    		 case "2"  OrderTypeName="订单已确定"
    		 case "3"  OrderTypeName="订单已生效"
    		 case "4"  OrderTypeName="订单已成交"
    		 case "5"  OrderTypeName="订单已取消"
			 end select
			 response.write OrderTypeName
			%></TD>
            <TD align="center"> <a href="#" class="back-12"  onClick="MM_openBrWindow('hyfw_yw_08.asp?OrderID=<%=oRst("Prize_id")%>&amp;OrdStatus=<%=oRst("OrderState")%>','','scrollbars=yes,resizable=yes,width=650,height=500')">处理</a>|<a href ='hyfw_del_order.asp?prize_id=<%=orst("prize_id")%>'>删除</a>  </TD>
          </TR>
          <%
			oRst.MoveNext
			wend
			oRst.Close
			%>
          <TR bgcolor="#FFFFFF"> 
            <TD height="25" colspan="7" align=center>     </TD>
          </TR>
      </TABLE>
</body>
</html>

⌨️ 快捷键说明

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