<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml"><!--#include file="../Include/Conno.asp" --><!--#include file="../Include/function.asp" --><!--#include file="../sql/Neeao_SqlIn.Asp" -->
<%set rs=conn.execute("select top 5 id,titlepic from tb_news where lm='21' and ontop='5' and titlepic <> '' and titlepic <> 'none' and not titlepic is Null order by id DESC")
if not rs.eof then
do while not rs.eof
ipics=ipics&rs("titlepic")&"|"
links=links&"NShow.asp?ArticleID="&rs("id")&"|"
rs.movenext
loop
picss=len(ipics)-1
ipics=mid(ipics,1,picss)
linkss=len(linkss)-1
links=mid(links,1,picss)
end if%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>旅游出行 >> 旅行社,自助旅游,飞机航班,机票预订,旅游情报,公交线路,铁路时刻,出行自备,域外风采,旅游景点,襄樊生活网</title>
<meta name="description"content="襄樊生活网旅游频道是襄樊地区旅游出行,旅行社,自助旅游,出行自备,域外风采,旅游景点,旅游情报,公交线路,铁路时刻,飞机航班等全方位于一体的襄樊本地化旅游信息服务频道">
<meta name="keywords" content="旅行社,自助旅游,飞机航班,机票预订,旅游情报,公交线路,铁路时刻,出行自备,域外风采,旅游景点">
<LINK href="../css/Menu.css" type=text/css rel=stylesheet>
<LINK href="../css/aTour.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<SCRIPT src="../js/029bxw.js" type=text/javascript></SCRIPT>
<base target="_blank">
<style type="text/css">
<!--
.style1 {
	color: #FF0000;
	font-weight: bold;
}
-->
</style>
</head>
<body>
<!--页面开始-->
<!--页面顶部开始-->
<!--#include file="../include/tourmenu.htm"-->
<!--页面顶部结束-->
<!--页面标题开始-->
<DIV id="aTitle"><img src="../images/Icon/001.gif"/> 您的位置：<A href="/">首页</A>&nbsp;&gt;&gt;&nbsp;<A href="/tour/index.asp">旅游出行</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#ff0000">特价机票预订电话:0351-##########</font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;本栏目寻求合作</DIV>
<!--页面标题结束-->
<!--页面正文结束-->
<table width="960" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="726" valign="top">
<table width="724" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="318" valign="top">
<div class="aTourLeft" style="width:300px;margin:5px 10px 0px 0px; padding:3px">
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="7%" valign="top" bgcolor="#F2FCEF">
	  <div class="aTourLeft01"><img src="images/010.gif"></div>
	  <div class="aTourLeft02"><a href="Plane_index.asp">机票预订</a></div>
	  </td>
      <td width="93%" valign="top">
	  <div class="aTourLeft03"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr align="middle">
            <td width="31%" height="18" align="center" background="images/ly_a_bj.gif"><strong>航班</strong></td>
            <td width="22%" align="center" background="images/ly_a_bj.gif"><strong>航班号</strong></td>
            <td width="17%" align="center" background="images/ly_a_bj.gif"><strong>原价</strong></td>
            <td width="15%" align="center" background="images/ly_a_bj.gif"><strong>特价</strong></td>
            <td width="15%" align="center" background="images/ly_a_bj.gif"><strong>预订</strong></td>
          </tr>
      </table>
	  </div><%set rs=conn.execute("Select top 7 F_ID,F_StartStation,F_EndStation,F_MemberPrice,F_Price,F_SFNumber From Plane_ScheduledFlight order by F_Addtime desc")
	  do while not rs.eof
	  m_SQLt = "SELECT F_CityName FROM Plane_CityType WHERE F_ID="&rs("F_StartStation")
        Set rst = conn.Execute(m_SQLt)
		if not rst.eof then
		StartStationname=rst("F_CityName")
		end if
		rst.close
		m_SQLt = "SELECT F_CityName FROM Plane_CityType WHERE F_ID="&rs("F_EndStation")
        Set rst = conn.Execute(m_SQLt)
		if not rst.eof then
		EndStationname=rst("F_CityName")
		end if
		rst.close%>
	  <div class="aTourLeft03"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="31%" align="center"><a href ='/Tour/Plane_Search.asp?Action=list&CityID=<%=rs("F_EndStation")%>&CityName=<%=EndStationname%>'> <%=StartStationname%> —— <%=EndStationname%></a></td>
            <td width="22%" align="center"><%=rs("F_SFNumber")%></td>
            <td width="17%" align="center"><% =rs("F_Price") %></td>
            <td width="15%" align="center"><font color="#FF3300"><% =rs("F_MemberPrice") %></font></td>
            <td width="15%" align="center"><a href="/Tour/Plane_Order.asp?Action=read&ID=<%=rs("F_ID")%>">预订</a></td>
          </tr>
      </table>
	  </div><%rs.movenext
	  loop
	  rs.close%>
	  <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="100%" align="center"><span class="style1">机票预订热线 0713-8550225 (八线)</span></td>
          </tr>
      </table>
	  </td>
    </tr>
  </table>
</div>
<div class="margin-bottom:5px"><img src="Images/BgLine01.gif"></div>
<div class="aTourLeft" style="width:300px;margin:5px 10px 0px 0px; padding:3px">
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="7%" valign="top" bgcolor="#F2FCEF">
	  <div class="aTourLeft01"><img src="images/010.gif"></div>
	  <div class="aTourLeft02"><a href="Travel_Lineall.asp">旅游线路</a></div>
	  </td>
      <td width="93%" valign="top">
	  <%set rs_c=conn.execute("Select top 8 F_id,F_LineName,f_typeid From Tour_TravelLine order by f_id desc")
	  do while not rs_c.eof
	  m_SQLt = "SELECT f_id,f_value FROM Tour_traveltype WHERE F_ID="&rs_c("f_typeid")
        Set rst = conn.Execute(m_SQLt)
		if not rst.eof then
		rstm_typename=rst("f_value")
		end if
		rst.close%>
	  <div class="aTourLeft03">[<%=rstm_typename%>] ·<A title=<%=rs_c("F_LineName")%> href="/Tour/Travel_LineShow.asp?ID=<%=rs_c("F_id")%>"><%=gotTopic(rs_c("F_LineName"),30)%></A></div>
	  <%rs_c.movenext
	  loop
	  rs_c.close%></td>
    </tr>
  </table>

</div>
<div><img src="Images/BgLine01.gif"></div>
</td>
    <td width="406" valign="top">
<div class="aTourLeft" style="margin:5px 10px 5px 0px"><script type="text/javascript">
 var swf_width=394	
 var swf_height=220
 var files='<%=ipics%>'
 var links='<%=links%>'
 var texts='||'
 document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ swf_width +'" height="'+ swf_height +'">');
 document.write('<param name="movie" value="../images/flash/focus.swf"><param name="quality" value="high">');
 document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
 document.write('<param name="FlashVars" value="bcastr_file='+files+'&bcastr_link='+links+'&bcastr_title='+texts+'">');
 document.write('<embed src="../images/flash/focus.swf" wmode="opaque" FlashVars="bcastr_file='+files+'&bcastr_link='+links+'&bcastr_title='+texts+'& menu="false" quality="high" width="'+ swf_width +'" height="'+ swf_height +'" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />'); document.write('</object>'); 
</script></div>
<div class="aTourLeft" style="margin:5px 10px 0px 0px; padding:0px 5px 3px 5px ">
	  <%set rs=conn.execute("Select top 9 ID,title,lm2 From tb_news where lm='21' and tj='推荐' order by id desc")
	  do while not rs.eof
	  m_SQLt = "SELECT n_name FROM tb_news_menu WHERE ID="&rs("lm2")
        Set rst = conn.Execute(m_SQLt)
		if not rst.eof then
		rstm_typename=rst("n_name")
		end if
		rst.close
	  %>
	  <div class="aTourLeft04"><a href="/Tour/NList.asp?newsSort=<%=rs("lm2")%>">[<%=rstm_typename%>]</a> <a href="/Tour/NShow.asp?ArticleID=<%=rs("id")%>">·<%=gotTopic(rs("title"),38)%></a></div>
	  <%rs.movenext
	  loop
	  rs.close%>
</div>
<div><img src="Images/BgLine02.gif"></div>
	</td>
  </tr>
</table>
<div id="aTourLeftAd1" style="width:712px; height:90px;margin:5px 0px 5px 0px;">
<img src="../Ad_Web/Images/60cannes_700-90-0515.jpg" width="100%" height="90"></div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="348" valign="top">
	<div class="aPlayList2">
<div style="margin:5px 5px 6px 5px "><TABLE cellSpacing=0 cellPadding=0 width=100% align=center 
            border=0>
              <TBODY>
              <TR>
                <TD align=middle width=8%><IMG src="images/013.gif"></TD>
                <TD width=25% align=middle class="aTexe14"><A href="/Tour/NList.asp?newsSort=24">出行必备</A></TD>
                <TD width=50% height=20 background="Images/BgLine03.gif"></TD>
                <TD width=17% background="Images/BgLine03.gif"><A href="/Tour/NList.asp?newsSort=24"><span class="aTexeMore" >更多&gt;&gt;</span></A></TD>
              </TR></TBODY></TABLE>
</div>

<div class="aCenter04"><%set rs=conn.execute("select * from tb_news_pic where newstype='24'")
if not rs.eof then%><table width="100%" border="0" cellspacing="3" cellpadding="0">
  <tr align="center">
    <td><a href="<%=rs("titleurl")%>"><img src="<%=rs("titlepic")%>" alt="<%=rs("title")%>" width="120" height="90"></a></td>
    <td><a href="<%=rs("titleurl2")%>"><img src="<%=rs("titlepic2")%>" alt="<%=rs("title2")%>" width="120" height="90"></a></td>
  </tr>
  <tr align="center">
    <td height="20"><a href="<%=rs("titleurl")%>"><%=rs("title")%></a></td>
    <td><a href="<%=rs("titleurl2")%>"><%=rs("title2")%></a></td>
  </tr>
</table><%end if%>
</div>
<ul class="aPlayList2Ul">
	 <%set rs=conn.execute("Select top 6 ID,title From tb_news where lm2='24' order by id desc")
	  do while not rs.eof%>
	  <li>
	 <div class="aPlayList201"><a href="/Tour/NShow.asp?ArticleID=<%=rs("ID")%>">·<%=gotTopic(rs("title"),22)%></a></div>
	 </li><%rs.movenext
	 loop
	 rs.close%>
</ul>
</div>
	<div class="aPlayList3">
<div style="margin:5px 5px 6px 5px "><TABLE cellSpacing=0 cellPadding=0 width=100% align=center 
            border=0>
              <TBODY>
              <TR>
                <TD align=middle width=8%><IMG src="images/013.gif"></TD>
                <TD width=25% align=middle class="aTexe14"><A href="/Tour/NList.asp?newsSort=25">旅游情报</A></TD>
                <TD width=50% height=20 background="Images/BgLine03.gif"></TD>
                <TD width=17% background="Images/BgLine03.gif"><A href="/Tour/NList.asp?newsSort=25"><span class="aTexeMore" >更多&gt;&gt;</span></A></TD>
              </TR></TBODY></TABLE>
</div>

<div class="aCenter04"><%set rs=conn.execute("select * from tb_news_pic where newstype='25'")
if not rs.eof then%><table width="100%" border="0" cellspacing="3" cellpadding="0">
  <tr align="center">
    <td><a href="<%=rs("titleurl")%>"><img src="<%=rs("titlepic")%>" alt="<%=rs("title")%>" width="120" height="90"></a></td>
    <td><a href="<%=rs("titleurl2")%>"><img src="<%=rs("titlepic2")%>" alt="<%=rs("title2")%>" width="120" height="90"></a></td>
  </tr>
  <tr align="center">
    <td height="20"><a href="<%=rs("titleurl")%>"><%=rs("title")%></a></td>
    <td><a href="<%=rs("titleurl2")%>"><%=rs("title2")%></a></td>
  </tr>
</table><%end if%>
</div>
<ul class="aPlayList2Ul">
<%set rs=conn.execute("Select top 6 ID,title From tb_news where lm2='25' order by id desc")
	  do while not rs.eof%>
	  <li>
	 <div class="aPlayList201"><a href="/Tour/NShow.asp?ArticleID=<%=rs("ID")%>">·<%=gotTopic(rs("title"),22)%></a></div>
	 </li><%rs.movenext
	 loop
	 rs.close%>
</ul>
</div>
</td>
    <td valign="top">
<div class="aCenter" style="margin:5px 7px 5px 0px; padding:3px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="3%" valign="top" bgcolor="#F0F7FD">
	  <div class="aCenter01"><img src="../images/Card/010.gif"></div>
	  <div class="aCenter02"><a href="/Tour/Travel_agencyall.asp">旅行社</a></div>	  </td>
      <td width="97%" valign="top">
<ul class="aPlayList1Ul">
<%set rs=conn.execute("Select top 12 F_ID,F_TravelAgencyName From Tour_TravelAgency order by F_ID desc")
	  do while not rs.eof%>
	  <li>
	 <div class="aPlayList101"><a href="/Tour/Travel_Agency.asp?ID=<%=rs("F_ID")%>">·<%=gotTopic(rs("F_TravelAgencyName"),22)%></a></div>
	 </li><%rs.movenext
	 loop
	 rs.close%>
</ul>	  
	  </td>
    </tr>
  </table>
</div>
<div class="aCenter" style="margin:5px 7px 5px 0px; padding:3px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="3%" valign="top" bgcolor="#F0F7FD">
	  <div class="aCenter01"><img src="../images/Card/010.gif"></div>
	  <div class="aCenter02"><a href="/Tour/NList.asp?newsSort=22">域外采风</a></div>	  </td>
      <td width="97%" valign="top">
<ul class="aPlayList1Ul">
	 <%set rs=conn.execute("Select top 12 ID,title From tb_news where lm2='22' order by id desc")
	  do while not rs.eof%>
	  <li>
	 <div class="aPlayList101"><a href="/Tour/NShow.asp?ArticleID=<%=rs("ID")%>">·<%=gotTopic(rs("title"),22)%></a></div>
	 </li><%rs.movenext
	 loop
	 rs.close%>
</ul>	  
	  </td>
    </tr>
  </table>
</div>
<div class="aCenter" style="margin:5px 7px 5px 0px; padding:3px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="3%" valign="top" bgcolor="#F0F7FD">
	  <div class="aCenter01"><img src="../images/Card/010.gif"></div>
	  <div class="aCenter02"><a href="/Tour/NList.asp?newsSort=23">自助旅行</a></div>	  </td>
      <td width="97%" valign="top">
<ul class="aPlayList1Ul">
<%set rs=conn.execute("Select top 12 ID,title From tb_news where lm2='23' order by id desc")
	  do while not rs.eof%>
	  <li>
	 <div class="aPlayList101"><a href="/Tour/NShow.asp?ArticleID=<%=rs("ID")%>">·<%=gotTopic(rs("title"),22)%></a></div>
	 </li><%rs.movenext
	 loop
	 rs.close%>
</ul>	  
	  </td>
    </tr>
  </table>
</div>
  	</td>
  </tr>
</table>
</td>
    <td width="236" valign="top">
<div class="aRight" style="width:234px;margin:5px 0px 5px 0px; padding:0px"><a href="/CardManage/reginfo.asp"><img src="../Ad_Web/Images/ad04.gif" width="234" height="98" border="0"></a></div>

<div class="aRight5" style="line-height:25px;padding:6px; margin:5px 0px 5px 0px">
<table width="100%" cellpadding="0" cellspacing="0">
  <form name="form1" method="post" action="/so/InfoSearch.asp">
  <TR>
    <TD width="60" rowspan="2"><a href="/so/InfoSearch.asp"><img src="../images/index/icon_so_.gif" alt="信息广场搜索" border="0"></a></TD>
    <TD width="102" align="left"><INPUT name="KeyWords" class="input" id="KeyWords" value="出租" size="15"></TD>
    <TD align="left"><input name="imageField" type="image" src="../images/index/search.gif" alt="搜索" width="50" height="19" border="0"></TD>
  </TR>
  <TR>
    <TD height="25" colspan="3">热门：<A href="/so/InfoSearch.asp?KeyWords=&#20986;&#31199;">出租</A> <A href="/so/InfoSearch.asp?KeyWords=出售">出售</A> <A href="/so/InfoSearch.asp?KeyWords=转让">转让</A> <A href="/so/InfoSearch.asp?KeyWords=求购">求购</A> </TD>
    </TR>
</form></table>
</div>
<div class="aRight3" style="line-height:20px">
      <table width="100%" border="0" cellpadding="6" cellspacing="1">
        <form name="form2" method="post" action="/Member/ChkLogin.asp"><tr>
          <td bgcolor="#FDFBF0"><div>用户名
            <input name="txtUserName" type="text" class="form" id="txtUserName" size="13">
&nbsp;
<input name="Submit" type="submit" class="form" style=" background-color: #ffffff; border: 1px solid #6994C3; HEIGHT: 19px; width:70px" value="会员登录">
<br>
密　码
<input name="txtPassword" type="text" class="form" id="txtPassword" size="13">
&nbsp;
<input name="Submit" type="button" class="form" style=" background-color: #ffffff; border: 1px solid #6994C3; HEIGHT: 19px; width:70px" value="用户注册" onClick="window.open'/Member/Register.asp','',''">
</div>
<div style="margin-top:5px; color:#2E8D00 "><a href="/about/help_4.asp">俱乐部会员注册帮助及功能介绍</a></div></td>
        </tr></form>
    </table>
</div>

<div class="aRight2" style="width:234px;margin:5px 0px 5px 0px; padding:0px"><a href="/member/Club.asp"><img src="../Ad_Web/Images/ad05.jpg" border="0"></a></div>
<div class="aRight4">
<div style="margin:5px"><TABLE cellSpacing=0 cellPadding=0 width=100% align=center 
            border=0>
              <TBODY>
              <TR>
                <TD align=middle width=11%><IMG src="images/Icon01.gif"></TD>
                <TD width=30% align=middle class="aTexe14"><A href="/Tour/Travel_Sightall.asp">旅游景点</A></TD>
                <TD width=38% height=20 bgColor=#E97DE0></TD>
                <TD width=21% bgColor=#E97DE0><A href="/Tour/Travel_Sightall.asp"><span class="aTexeMore" >更多&gt;&gt;</span></A></TD>
              </TR></TBODY></TABLE>
</div><%set rs=conn.execute("Select top 6 F_ID,F_SightName From Tour_TravelSight order by F_ID desc")
	  do while not rs.eof%>
<div class="aList1"><a href="/Tour/Travel_SightShow.asp?ID=<%=rs("F_ID")%>">·<%=gotTopic(rs("F_SightName"),30)%></a></div>
<%rs.movenext
loop
rs.close%>
</div>
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a href="/Member/Register.asp"><img src="../Ad_Web/Images/ClassVip_01.gif" alt="申请VIP" border="0"></a></td>
  </tr>
  <tr>
    <td><a href="/Member/Register.asp"><img src="../Ad_Web/Images/ClassVip_02.gif" alt="注册个人会员" border="0"></a></td>
  </tr>
  <tr>
    <td><a href="/info/write_info.asp"><img src="../Ad_Web/Images/ClassVip_03.gif" alt="发布信息" border="0"></a></td>
  </tr>
</table>
<div class="aRight6" style="margin-top:5px">
<div style="margin:5px"><TABLE cellSpacing=0 cellPadding=0 width=100% align=center 
            border=0>
              <TBODY>
              <TR>
                <TD align=middle width=11%><IMG src="images/Icon01.gif"></TD>
                <TD width=30% align=middle class="aTexe14"><A href="/Ba">互动专区</A></TD>
                <TD width=38% height=20 bgColor=#99CC33></TD>
                <TD width=21% bgColor=#99CC33><A href="/Ba"><span class="aTexeMore" >更多&gt;&gt;</span></A></TD>
              </TR></TBODY></TABLE>
</div>
<%m_SQL = "SELECT TOP 10 id,u_title FROM tb_ba where tj=1 and msgid=0 order by id desc"
	Set rs = conn.Execute(m_SQL)
	do while not rs.eof%>
<div class="aList1"><a href="/Ba/show.asp?ID=<%=rs("id")%>">·<%=gotTopic(rs("u_title"),28)%></a></div>
<%rs.movenext
	 loop
	 rs.close%>
</div></td>
  </tr>
</table>

<TABLE width=100% border=0 cellPadding=0 cellSpacing=0 bgcolor="#0175be">
    <TR>
      <TD height="26" class="aTexe142">&nbsp;&nbsp;精彩图片 <a href="/pic"><IMG src="../images/card/014.gif" alt="精彩图片" height=13 border="0" align=absMiddle></a></TD>
      <TD width=60><A class=aTexeMore href="/pic" >更多&gt;&gt;</A></TD>
    </TR>
</TABLE>
<div id="aPic" style=" height:150px">
<ul id="aPicUl"><%m_SQL = "SELECT TOP 6 id,title,titlepic FROM tb_news where lm='13' order by id desc"
			Set rs = conn.Execute(m_SQL)
			Do While Not rs.Eof
			ptitle=rs("title")%>
	 <li>
	 <div class="aPic01"><a href="/Pic/Show.asp?ArticleID=<%=rs("id")%>"><img src="<%=rs("titlepic")%>" alt="<%=ptitle%>" width="130" height="98" border="0" /></a> </div>
	 <div class="aPic01"><a href="/Pic/Show.asp?ArticleID=<%=rs("id")%>" title=<%=ptitle%>><%=gotTopic(ptitle,18)%></a></div>
	 </li><%rs.movenext
	 loop
	 rs.close%>
</ul>
</div>
<!--页面正文结束-->
<!--版权开始--><!--#include file="../include/CopyRight.htm"--><!--版权结束-->
<!--页面结束-->
</body>
</html>
