📄 query_lvxingshe.asp
字号:
<!-- 旅行社查询 -->
<%@ LANGUAGE=JavaScript %>
<!--#include file ="Lib/Comm.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>中国旅游 - 旅行社查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript" src="images/myfreetemplates.js"></script>
<link href="images/myfreetemplates.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/btn_chaxuen_dn.gif','images/btn_jingdian_dn.gif','images/btn_jiudian_dn.gif','images/btn_lvxingshe_dn.gif','images/btn_liuyan_dn.gif')"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="6" valign="top"> </td>
<td width="42" rowspan="6" valign="top" background="images/sidebg_left.gif"> </td>
<td width="670" background="images/tabletopbg1.gif"><img src="images/tabletopbg1.gif" width="1" height="4"></td>
<td width="46" rowspan="6" valign="top" background="images/sidebg_right.gif"><img src="images/sidebg_right.gif" width="46" height="3"></td>
<td rowspan="6" valign="top"> </td>
</tr>
<tr>
<td width="670"> <table width="676" border="0" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="2" background="images/pixi_greyblue.gif"><img src="images/top_logo.gif" width="166" height="92"></td>
<td colspan="6" background="images/pixi_greyblue.gif"><img src="images/pixi_greyblue.gif" width="1" height="61"></td>
</tr>
<tr>
<td><img src="images/top_curve.gif" width="22" height="31"></td>
<td colspan="5" align="right"><a onMouseOver="MM_swapImage('btn_null','','images/btn_null.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_null.gif" name="btn_null" border="0" id="btn_null" width="53" height="31"></a><!--
1
--><a href="index.asp" onMouseOver="MM_swapImage('btn_shouye','','images/btn_shouye_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_shouye.gif" name="btn_shouye" border="0" id="btn_shouye" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
2
--><a href="chaxun.asp" onMouseOver="MM_swapImage('btn_chaxuen','','images/btn_chaxuen_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_chaxuen.gif" name="btn_chaxuen" border="0" id="btn_chaxuen" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
3
--><a href="jingdian.asp" onMouseOver="MM_swapImage('btn_jingdian','','images/btn_jingdian_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_jingdian.gif" name="btn_jingdian" border="0" id="btn_jingdian" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
4
--><a href="jiudian.asp" onMouseOver="MM_swapImage('btn_jiudian','','images/btn_jiudian_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_jiudian.gif" name="btn_jiudian" border="0" id="btn_jiudian" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
5
--><a href="lvxingshe.asp" onMouseOver="MM_swapImage('btn_lvxingshe','','images/btn_lvxingshe_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_lvxingshe.gif" name="btn_lvxingshe" border="0" id="btn_lvxingshe" width="86" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
6
--><a href="liuyan.asp" onMouseOver="MM_swapImage('btn_liuyan','','images/btn_liuyan_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_liuyan.gif" name="btn_liuyan" border="0" id="btn_liuyan" width="68" height="31"></a></td>
</tr>
</table></td>
</tr>
<tr>
<td width="670" height="4" background="images/pixi_lightblue.gif"><img src="images/pixi_lightblue.gif" width="4" height="4"></td>
</tr>
<tr>
<td width="670" background="images/pixi_lightblue.gif"> <div align="left">
<!-- 横幅图片-->
<table width="676" cellpadding="0">
<tr><td align="center"><img src="images/changcheng.jpg" /></td></tr>
</table>
</div></td>
</tr>
<tr>
<td width="670" height="4" background="images/pixi_lightblue.gif"><img src="images/pixi_lightblue.gif" width="4" height="4"></td>
</tr>
<tr>
<td align="right" valign="top">
<table width="100%" cellpadding="0px" cellspacing="0px">
<tr><td align="right"><img src="images/midcurve2.gif" /></td></tr>
<tr><td class="neirong">
<!-- 主体内容 -->
<!-- 按编号查询 -->
<%
if (hasRequest(Request.QueryString("bianhao"))) {
BHQuery(Request.QueryString("bianhao"));
}
%>
<%
function BHQuery(BianHao) {
%>
<style type="text/css">
table.lvxingshe { font-size: 14px; border-collapse:collapse; margin-bottom: 24px;}
table.lvxingshe caption { font-weight: bold; text-align: left; padding-left: 180px; font-size: 18px; }
table.lvxingshe td { padding: 5px;}
</style>
<%
if (!isNum(BianHao)) {
Response.Write("<font color='red'>BianHao查询参数非法。</font>");
return;
}
var conn = new ActiveXObject("ADODB.Connection");
var sql = "SELECT * FROM LVXingShe WHERE BianHao=" + BianHao;
conn.Open(Application("ConnectionString"));
var rs = conn.Execute(sql);
if (rs.eof){
Response.Write("<font color='red'>对不起，该记录已被移动或被删除！</font>");
} else {
%>
<table class="lvxingshe" align="center" width="500" border="1">
<caption><%=rs("MingCheng")%></caption>
<tr><td width="80" align="right">等级：</td><td><%=rs("DengJi")%></td></tr>
<tr><td align="right">负责线路：</td><td><%=rs("FuZeXianLu")%></td></tr>
<tr><td align="right">联系电话：</td><td><%=rs("LianXiDianHua")%></td></tr>
</table>
<%
}
rs.Close();
rs = null;
conn.Close();
sql = "SELECT JingDianBianHao,JingDianMingCheng FROM JingDian_LVXingShe WHERE LVXingSheBianHao=" + BianHao;
conn.Open();
rs = conn.Execute(sql);
%>
<table class="lvxingshe" align="center" width="500" border="1">
<caption>负责景点</caption>
<%
while (!rs.eof) {
%>
<tr><td><a href="query_jingdian.asp?bianhao=<%=rs("JingDianBianHao")%>"><%=rs("JingDianMingCheng")%></a></td></tr>
<%
rs.MoveNext();
}
%>
</table>
<%
rs.Close();
rs = null;
conn.Close();
conn = null;
}; // end BHQuery()
%>
</td></tr>
</table>
</td>
</tr>
<tr>
<td valign="top"> </td>
<td valign="top" background="images/sidebg_left.gif"> </td>
<td valign="top" background="images/pixi_lightblue.gif"> <span class="baseline">©
Copyright 2006.<br>
<br>
</span></td>
<td valign="top" background="images/sidebg_right.gif"> </td>
<td valign="top"> </td>
</tr>
</table>
<table border=0 CELLSPACING=0 CELLPADDING=0 WIDTH="601" align=center>
<tr>
<td align=center><br><center>
<font style="font-size: 11px;">© 中国旅游 版权所有 <br />www.xxx.com</font>
</center></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -