📄 hyfw_yw_01.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")%>&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 + -