📄 manage3.asp
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="CheckSystem.asp"-->
<%
checkmanager(session("ManagerName"))'调用函数，验证管理员是正常登陆
nextPage="Admin_add3.asp"
if trim(request("Myaction"))="del" then
del=request.Form("del")
if del<>"" then
conn.execute("delete from myBunkmessage where auto in ("&del&") ")
else%>
<script language="javascript">
alert("请输入要删除的记录");
window.history.back();
</script>
<%
response.end
end if
end if
'--------分页-------------
SearchFiled=request("SearchFiled")
startcity01=request("startcity01")
endcity01=request("endcity01")
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" />
</head>
<script language="JavaScript" type="text/JavaScript">
<!--
function call(htmlurl){
window.location.href=htmlurl;
return false;
}
//-->
</script>
<body >
<SCRIPT language=javascript src="../js/address.js"></SCRIPT>
<div class="txt_title">添加动态航线特价（用途：针对某城市、航段、航空公司、舱位的特价政策，座次随航信数据自动变更）</div>
<TABLE cellPadding=0 cellSpacing=1 >
<form name="FrmSearch" action="manage3.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>
起飞：
<select name=startcity01 id="startcity01" style="WIDTH: 100px">
<option value="aa" selected>请选择</option>
<script> document.write(citystr)</script>
</select>
到达： <select name=EndCity01 id="EndCity01" style="WIDTH: 100px">
<option value="bb" selected>请选择</option>
<script> document.write(citystr)</script>
</select>
<input name="Submit" type="submit" value=" 搜 索 ">
</td>
</TR>
</form>
<form name="ZXLform" action="manage3.asp" method="post">
<TR bgColor=#C3E7F9>
<TH height="25"> 航线 </TH>
<TH bgcolor="#C3E7F9"> 航线有效日期 </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=2 and startcity<>'' order by DateTime desc"
if SearchFiled="City" and startcity01<>"aa" and endcity01<>"bb" then
szSQL="select * from myBunkmessage where ifDynamicBunk=2 and startcity='"&startcity01&"' and endcity='"&endcity01&"' order by DateTime desc"
end if
oRst.Open szSQL,conn,1,3
'-----------分页
if oRst.eof then
response.write("当前没有记录,请单击<a href='Admin_add3.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")
AirwayName=oRst("AirwayName")
rebate=oRst("Rebate")
startcity=oRst("startcity")
if startcity="" then
startcity="所有"
end if
endcity=oRst("endcity")
if endcity="" then
endcity="所有"
end if
bunk=oRst("bunk")
num=oRst("Num")
price=oRst("Price")
datetime=oRst("DateTime")
Auto=oRst("Auto")
endDatetime=oRst("endDatetime")
ifDynamicBunk=oRst("ifDynamicBunk")
%>
<TR <%=bc%> >
<TD height="25" align=center nowrap><a href="<%=nextPage%>?auto=<%=Auto%>&ifDynamicBunk=<%=ifDynamicBunk%>"> <%=startcity%>-><%=endcity%></a></TD>
<TD align=center><%=flyDate%>-><%=endDatetime%></TD>
<TD align="center"><%=AirwayName%></TD>
<TD align="center"><%=rebate%></TD>
<TD align="center"><%=bunk%></TD>
<TD align="center"><%=price%></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="8">
<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='manage3.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 + -