📄 manage.asp
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="CheckSystem.asp"-->
<%
checkmanager(session("ManagerName"))'调用函数，验证管理员是正常登陆
nextPage="Admin_add.asp"
del=request.Form("del")
if trim(request.form("Myaction"))="del" then
if del<>"" then
conn.execute("delete from myBunkmessage where auto in ("&del&") ")
else
response.write "<script language=javascript>alert('请选择记录！');history.go(-1);</script>"
response.end
end If
End if
'------------检索-----------
SearchFiled=request("SearchFiled")
SearchKey1=trim(request("SearchKey1"))
op="1" 'INetOrderForm
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="include/css.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="style/comm.css" />
<link rel="stylesheet" type="text/css" href="style/skin0.css" />
<title>后台管理机票系统</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function call(htmlurl){
window.location.href=htmlurl;
return false;
}
//-->
</script>
</head>
<body>
<div class="txt_title">添加静态航班特价（用途：针对航班的舱位特价政策，可自定义剩余座位数）</div>
<TABLE cellPadding=0 cellSpacing=1>
<form name="FrmSearch" action="manage.asp" method="post">
<TR align="left" bgColor=#C3E7F9>
<td height="25" colspan="8"> 检索：
<select name="SearchFiled">
<option value="LineNum">按航班号</option>
<!--<option value="City">按城市名称</option>-->
</select>
<input type="text" style="width:100px" name="SearchKey1" value='<%=SearchKey1%>'>
<input name="Submit" type="submit" value="搜索"></td>
</TR>
</form>
<form name="ZXLform" action="manage.asp" method="post">
<TR bgColor=#C3E7F9>
<TH height="25">航班号</TH>
<TH> 航班有效日期 </TH>
<TH> 舱位名称 </TH>
<TH>舱位等级</TH>
<TH>折扣</TH>
<TH>舱位数</TH>
<TH>更新时间</TH>
<TH>操作</TH>
</TR>
<%
dim szSQL
set oRst=Server.CreateObject("AdoDb.recordset")
szSQL="select * from myBunkmessage where ifDynamicBunk=0 order by DateTime desc"
if SearchFiled="LineNum" and SearchKey1<>"" then
szSQL="select * from myBunkmessage where ifDynamicBunk=0 and FlightNo like '%"&SearchKey1&"%' order by DateTime desc"
end if
oRst.Open szSQL,conn,1,3
'-----------分页
if oRst.eof then
response.write("当前没有记录,请单击<a href='Admin_add.asp'>[添加]</a>")
response.end
else
if request.QueryString("pageno")="" then
pageno=1
else
pageno=cint(request.QueryString("pageno"))
end if
recordcounts=oRst.recordcount
pagesiz=15
oRst.pagesize=15
pagecounts=oRst.pagecount
if pageno<1 then
pageno=1
end if
if pageno>pagecounts-1 then
pageno=pagecounts
end if
oRst.absolutepage=pageno
i=0
while not oRst.eof and pagesiz>0
i=i+1
bc="bgcolor='#eff3f7'"
if i mod 2=0 then bc="bgcolor='#FFFFFF'"
FlightNo=oRst("FlightNo")
flyDate=oRst("flyDate")
rebate=oRst("Rebate")
num=oRst("Num")
price=oRst("Price")
datetime=oRst("DateTime")
Auto=oRst("Auto")
endDatetime=oRst("endDatetime")
ifDynamicBunk=0
bunk=oRst("bunk")
%>
<TR <%=bc%> >
<TD height="25" align=center><a href="<%=nextPage%>?auto=<%=Auto%>&ifDynamicBunk=<%=ifDynamicBunk%>"> <strong><%=FlightNo%></strong></a> </TD>
<TD align=center nowrap><%=flyDate%>-><%=endDatetime%></TD>
<TD align="center"><%=rebate%></TD>
<TD align="center"><%=bunk%></TD>
<TD align="center"><%=price%></TD>
<TD align="center"><%=num%></TD>
<TD align="center" nowrap><%=DateTime%></TD>
<TD align="center"><input name="del" type="checkbox" id="del" value="<%=auto%>">
</TD>
</TR>
<%
oRst.MoveNext
pagesiz=pagesiz-1
wend
end if
%>
<input type="hidden" name="Myaction" value="">
<TR bgColor=#EEEEEE>
<TD height="30" colspan="9">
<input type="button" name="AddnewBunk" onClick="javascript:call('<%=nextPage%>');" value="添加静态特价">
<input type="submit" name="Submit" onClick="javascript:ZXLform.Myaction.value='del'" value=" 删 除 ">
共有<span style="color:red;"><%=recordcounts%></span>条;每页显示<font style="color:red;">15</font>条;转到第
<select name="select" id="pa" onChange="window.location.href='manage.asp?SearchFiled=<%=SearchFiled%>&SearchKey1=<%=SearchKey1%>&pageno='+document.all.pa.value;">
<% for i=1 to pagecounts
if i=pageno then
response.write("<option value="&i&" selected>"&i&"</option>")
else
response.write("<option value="&i&">"&i&"</option>")
end if
next
%>
</select>页 </TD>
</TR>
</form>
</TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -