📄 plane_query.asp
字号:
<td width="1"></td>
<td width="560" valign="top">
<table width="100%" height="100%"border="0" cellpadding="0" cellspacing="0" bgcolor="#d9e7eb">
<tr>
<td width="559" height="161" valign="middle" align="center">
<form method="POST" action="plane_query.asp?query=query#ddd">
<table border="0" width="100%">
<tr>
<td valign="top" height="20" colspan="5"><font color="#000000"><b>
<img src="../../Images/Icon_JiPiao.gif" width="25" height="16">
航班查询</b></font></td>
</tr>
<tr>
<td height="27" valign="middle" width="99"><font size="2" color="#000000">降落时间：</font></td>
<td valign="middle" width="165">
<select size="1" name="ArriveTime">
<option value="0">全天</option>
<option value="1">0:00-6:00</option>
<option value="2">6:00-8:00</option>
<option value="3">8:00-12:00</option>
<option value="4">12:00-16:00</option>
<option value="5">16:00-21:00</option>
<option value="6">21:00-23:59</option>
</select>
</td>
<td valign="top" colspan="2"><font size="2" color="#000000">起飞时间：</font></td>
<td width="177" valign="top">
<select size="1" name="LeaveTime">
<option value="0">全天</option>
<option value="1">0:00-6:00</option>
<option value="2">6:00-8:00</option>
<option value="3">8:00-12:00</option>
<option value="4">12:00-16:00</option>
<option value="5">16:00-21:00</option>
<option value="6">21:00-23:59</option>
</select>
</td>
</tr>
<tr>
<td height="27" valign="top"><font size="2" color="#000000">到达城市</font><font color="#000000">：</font></td>
<td valign="top">
<input type="text" name="ToCity" size="20">
</td>
<td valign="top" colspan="2"><font size="2" color="#000000">出发城市：</font></td>
<td valign="top">
<input type="text" name="FromCity" size="20">
</td>
</tr>
<tr>
<td height="27" valign="top"><font color="#000000" size="2">航班号：</font></td>
<td valign="top">
<input type="text" name="PlaneNum" size="20">
</td>
<td width="1"></td>
<td width="99" valign="top"><font color="#000000" size="2">航班类型：</font></td>
<td valign="top">
<input type="radio" value="0" name="R1" checked>
<font size="2" color="#000000">国内航班
<input type="radio" value="1" name="R1">
国际航班</font></td>
</tr>
<tr>
<td height="31"></td>
<td></td>
<td></td>
<td></td>
<td valign="top">
<input style=" BACKGROUND-COLOR: #e6f4ff;
BORDER-BOTTOM: #0099ff 1px solid;
BORDER-LEFT: #0099ff 1px solid;
BORDER-RIGHT: #0099ff 1px solid;
BORDER-TOP: #0099ff 1px solid;
COLOR: #336699;
HEIGHT: 18px;
width:30px:
TEXT-ALIGN: center" type="submit" value="提交" name="B1">
<input style=" BACKGROUND-COLOR: #e6f4ff;
BORDER-BOTTOM: #0099ff 1px solid;
BORDER-LEFT: #0099ff 1px solid;
BORDER-RIGHT: #0099ff 1px solid;
BORDER-TOP: #0099ff 1px solid;
COLOR: #336699;
HEIGHT: 18px;
width:30px:
TEXT-ALIGN: center" type="reset" value="重写" name="B2">
</td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td valign="top" height="25"><img src="../../Images/icon01.gif" width="23" height="23">
<b><font color="#000000">航班查询结果</font></b> </td>
</tr>
<tr>
<td height="153" valign="top">
<table width="559" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="65" valign="middle" align="center" bgcolor="#ffcc00"><font color="#FFFFFF" size="2"><a name="ddd"></a>航班号</font></td>
<td width="96" valign="middle" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">航空公司</font></td>
<td valign="middle" colspan="2" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">出发城市</font></td>
<td width="82" valign="middle" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">到达城市</font></td>
<td width="68" valign="middle" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">班期</font></td>
<td valign="middle" width="41" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">离站</font></td>
<td width="43" valign="middle" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">到站</font></td>
<td valign="middle" width="50" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">价格</font></td>
<td width="45" valign="middle" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">详细</font></td>
</tr>
<%
if Request("r1")<>"" then
sqlRsCond= sqlRsCond & " and 国内国际标志=" & Request("r1")
if Request("FromCity")<>"" then
sqlRsCond= sqlRsCond & " and 出发城市_kr='" & Request("FromCity") & "'"
end if
if Request("ToCity")<>"" then
sqlRsCond= sqlRsCond & " and 目的城市_kr='" & Request("ToCity") & "'"
end if
if Request("PlaneNum")<>"" then
sqlRsCond= sqlRsCond & " and 航班号='" & Request("PlaneNum") & "'"
end if
if Request("Company")<>"" then
sqlRsCond= sqlRsCond & " and 航空公司_kr='" & Request("Company") & "'"
end if
if Request("Company")<>"" then
sqlRsCond= sqlRsCond & " and 航空公司_kr='" & Request("Company") & "'"
end if
if IsDate(request("LeaveDate")) then
nWeekDay=weekday(cdate(request(LeaveDate)))-1
if nWeekDay=0 then nWeekDay=7
sqlRsCond= sqlRsCond & " and instr(班期,'" & nWeekDay & "')>0"
end if
if Request("LeaveTime")="2" then
sqlRsCond= sqlRsCond & " and 离站时间>='06:00' and 离站时间<='08:00'"
end if
if Request("LeaveTime")="3" then
sqlRsCond= sqlRsCond & " and 离站时间>='08:00' and 离站时间<='12:00'"
end if
if Request("LeaveTime")="4" then
sqlRsCond= sqlRsCond & " and 离站时间>='12:00' and 离站时间<='16:00'"
end if
if Request("LeaveTime")="5" then
sqlRsCond= sqlRsCond & " and 离站时间>='16:00' and 离站时间<='21:00'"
end if
if Request("LeaveTime")="6" then
sqlRsCond= sqlRsCond & " and 离站时间>='21:00' and 离站时间<='23:59'"
end if
if Request("ArriveTime")="1" then
sqlRsCond= sqlRsCond & " and 到站时间>='00:00' and 到站时间<='06:00'"
end if
if Request("ArriveTime")="2" then
sqlRsCond= sqlRsCond & " and 到站时间>='06:00' and 到站时间<='08:00'"
end if
if Request("ArriveTime")="3" then
sqlRsCond= sqlRsCond & " and 到站时间>='08:00' and 到站时间<='12:00'"
end if
if Request("ArriveTime")="4" then
sqlRsCond= sqlRsCond & " and 到站时间>='12:00' and 到站时间<='16:00'"
end if
if Request("ArriveTime")="5" then
sqlRsCond= sqlRsCond & " and 到站时间>='16:00' and 到站时间<='21:00'"
end if
if Request("ArriveTime")="6" then
sqlRsCond= sqlRsCond & " and 到站时间>='21:00' and 到站时间<='23:59'"
end if
session("planeCond")=sqlRsCond
elseif Request("page")<>"" then
sqlRsCond=session("planeCond")
else
sqlrscond=" and 特惠=1"
end if
sqlRs=" Select 航班编码,航班号,航空公司_kr,出发城市_kr,目的城市_kr,班期,离站时间,到站时间,价格,特惠价格 From xt_td_plane Where 1=1 " & sqlRsCond
%>
<!-- #include file="../../Include/AdoDBOpen.asp" -->
<%
do while (not rs.eof) and rowcount>0
if (rowcount mod 2)=0 then
%>
<tr>
<%else%>
<tr bgcolor="fff1dd">
<%end if%>
<td valign="middle" height="18"><font size="2"><font color="000000"><%=rs(1)%></font></font></td>
<td valign="middle" align="center"><font size="2"><font color="000000"><%=rs(2)%></font></font></td>
<td width="68" valign="middle" align="center"><font size="2"><font color="000000"><%=rs(3)%></font></font></td>
<td width="1" ></td>
<td valign="middle" align="center" ><font size="2"><font color="000000"><%=rs(4)%></font></font></td>
<td valign="middle" align="center" ><font size="2"><font color="000000"><%=rs(5)%></font></font></td>
<td valign="middle" align="center" ><font size="2"><font color="000000"><%=rs(6)%></font></font></td>
<td valign="middle" align="center" ><font size="2"><font color="000000"><%=rs(7)%></font></font></td>
<td valign="middle" align="center" ><font size="2"><font color="000000"><%=rs(8)%></font></font></td>
<td valign="middle" align="center" ><a href="javascript:open1(<%=rs(0)%>)"><font size="2"><font color="000000">详细</font></font></a></td>
</tr>
<%
rs.movenext '纪录指针下移
rowcount=rowcount-1
loop
%>
<tr>
<td height="20" colspan="10" valign="top"> </td>
</tr>
<tr>
<td height="95" colspan="10" valign="top" align="right">
<%sLinkFile="plane_query.asp?query="
sBookMark="ddd"%>
<!-- #include file="../../Include/pageend.asp" -->
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="98"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td height="16" colspan="2" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="756" height="16" valign="top">
<hr>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="middle" align="center">
<td height="17" colspan="2"><font size="2" color="#000000">版权所有©恒奇商务服务中心<br>
地址:沈阳市西塔街77号方迪大厦C座12楼 邮编：110003<br>
管理员E-mail:webmaster@heng7.net 服务热线: 024-23490656</font></td>
</tr>
</table>
<map name="Map2">
<area shape="rect" coords="7,-1,53,21" href="../User/user_login.asp">
</map>
<map name="Map">
<area shape="rect" coords="2,3,37,16" href="../China/User/user_login.asp">
</map>
<map name="Map3">
<area shape="rect" coords="5,-1,57,23" href="#">
</map>
</center>
</body>
</html>
<script language="vbscript">
function check() '校验表单
check=true
if loginform.Username.value ="" then
check=false
window.alert "登录前请输入用户名！"
exit function
end if
if loginform.Password.value ="" then
check=false
window.alert "登录前请输入密码！"
exit function
end if
end function
</script>
<script language=javascript>
function open1(code)
{
window.open("plane_detail.asp?code="+code,"航班详细内容","height=290,width=340,toolbar=no,menubar=no,scrollbars=yes,resizable=no,status=no,location=no")
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -