|
|
<!--#include virtual="/include/site-seting.asp" -->
|
|
|
<!--#include virtual="/common/Function.asp" -->
|
|
|
<!--#include virtual="/common/Function-tour.asp" -->
|
|
|
<!--#include virtual="/common/function-seo.asp"-->
|
|
|
<!--#include virtual="/common/function-packageinfo.asp"-->
|
|
|
<!--#include virtual="/common/function-cityguide.asp" -->
|
|
|
<!--#include virtual="/common/travelguide-china-funs.asp" -->
|
|
|
<!--#include virtual="/common/function-pageintro.asp" --><%
|
|
|
''//应从原来一地线路列表另存出来的，现暂时使用原有变量city....
|
|
|
city = request.QueryString("region")
|
|
|
if request.QueryString("region") = empty then
|
|
|
city = "beijing"
|
|
|
else
|
|
|
city = Replace(SafeRequest("region",0), "-", " ")
|
|
|
end if
|
|
|
|
|
|
if request.querystring("days") <> empty then
|
|
|
days = SafeRequest("days",1)
|
|
|
days_sql = " and dbo.V_SRMS_ResourceAllot_Tour_Price_CJ.CLI_Days = " & days
|
|
|
if days > 1 then
|
|
|
days_txt = days & " Days " & capitalize(city) & " Tours, "
|
|
|
else
|
|
|
days_txt = days & " Day " & capitalize(city) & " Tours,"
|
|
|
end if
|
|
|
end if
|
|
|
|
|
|
SRMSPRovinceInfo = GetSRMSPRovinceId(city,Site_LGC,Site_ID)
|
|
|
if isarray(SRMSPRovinceInfo) then
|
|
|
SRMSPRI_SN = SRMSPRovinceInfo(0)
|
|
|
PRI_Code = SRMSPRovinceInfo(1)
|
|
|
else
|
|
|
'response.write "PRovince Error"
|
|
|
'response.End()
|
|
|
end if
|
|
|
|
|
|
''-----------------------------
|
|
|
wid = Site_ID
|
|
|
eid = SRMSPRI_SN
|
|
|
etype = "K"
|
|
|
epagetype="t-citytour-list"
|
|
|
|
|
|
def_title = days_txt & capitalize(city)&" Tours, "&capitalize(city)&" China Tours, Top "&capitalize(city)&" Tour Packages."
|
|
|
def_keywords = days_txt & capitalize(city)&" tour, "&capitalize(city)&" china tours, "
|
|
|
'URL定义-3H
|
|
|
dim urlCityTourInfo
|
|
|
urlCityTourInfo= "/tour/{0}tour/{1}/"
|
|
|
|
|
|
OrderType=saferequest("OrderType",0)
|
|
|
select case OrderType
|
|
|
case "price"
|
|
|
strFileName="tours-sort-by-price"
|
|
|
order_sql = " order by CLP_TwoToFiveAdultPrice"
|
|
|
case "days"
|
|
|
strFileName="tours-sort-by-length"
|
|
|
order_sql = " order by CLI_Days"
|
|
|
case else
|
|
|
strFileName="tours"
|
|
|
OrderType="OrderNum"
|
|
|
order_sql = " order by CLI_OrderNum"
|
|
|
end select
|
|
|
sql=""
|
|
|
sql=" " &_
|
|
|
"SELECT CItyInfo2.CII2_Name, PRovinceInfo2.PRI2_Name " &_
|
|
|
"FROM CItyInfo2 INNER JOIN " &_
|
|
|
" CItyInfo ON CItyInfo2.CII2_CII_SN = CItyInfo.CII_SN INNER JOIN " &_
|
|
|
" PRovinceInfo2 ON CItyInfo.CII_PRI_SN = PRovinceInfo2.PRI2_PRI_SN " &_
|
|
|
"WHERE (CItyInfo.DeleteFlag <> 1) AND (CItyInfo2.CII2_LGC = 1) AND " &_
|
|
|
" (PRovinceInfo2.PRI2_LGC = 1) AND (PRovinceInfo2.DeleteFlag <> 1) AND " &_
|
|
|
" (PRovinceInfo2.PRI2_Name = N'"& city &"') "
|
|
|
'response.write sql
|
|
|
'response.End()
|
|
|
set rs_cities = server.createobject("adodb.recordset")
|
|
|
rs_cities.open sql,conn,1,1,1
|
|
|
temp_cities = ""
|
|
|
if rs_cities.eof then
|
|
|
GotoErrPage
|
|
|
end if
|
|
|
k_i = 1
|
|
|
do while not rs_cities.eof
|
|
|
if k_i = rs_cities.recordcount then
|
|
|
temp_cities = temp_cities & " (CLI2_PassCity Like '%"&rs_cities("CII2_Name")&"%') "
|
|
|
else
|
|
|
temp_cities = temp_cities & " (CLI2_PassCity Like '%"&rs_cities("CII2_Name")&"%') Or "
|
|
|
end if
|
|
|
k_i = k_i + 1
|
|
|
rs_cities.movenext
|
|
|
loop
|
|
|
if temp_cities <> "" then
|
|
|
temp_cities = " AND ( " & temp_cities & " ) "
|
|
|
end if
|
|
|
rs_cities.close
|
|
|
set rs_cities = nothing
|
|
|
|
|
|
sql= ""
|
|
|
sql=" "&_
|
|
|
"SELECT top 100 T.CLI_SN, T.CLI_Days, T.CLI_ListImage, T.CLI_CityName, T.CLI2_Name, T.CLI_NO, "&_
|
|
|
" T.CLI2_PassCity, T.CLI2_AttractionList, T.CLI2_Memo, T.CLI_OrderNum, "&_
|
|
|
" dbo.GetFullPathByPII_SN(dbo.PictureInfo.PII_SN, 1) AS pic, T.CityName, T.CLI_CII_SN, T.CLP_TwoToFiveAdultPrice "&_
|
|
|
"FROM (SELECT TOP 100 dbo.CustomerLineInfo.CLI_SN, dbo.CustomerLineInfo.CLI_Days, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_ListImage, dbo.CustomerLineInfo.CLI_CityName, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_Name, dbo.CustomerLineInfo.CLI_NO, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_PassCity, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_AttractionList, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_Memo, dbo.CustomerLineInfo.CLI_OrderNum, "&_
|
|
|
" dbo.getCityName(dbo.CustomerLineInfo.CLI_CII_SN, 1) AS CityName, dbo.CustomerLineInfo.CLI_CII_SN, "&_
|
|
|
" (SELECT TOP 1 CLP_TwoToFiveAdultPrice "&_
|
|
|
" FROM dbo.CustomerLinePrice "&_
|
|
|
" WHERE (CLP_CLI_SN = dbo.CustomerLineInfo.CLI_SN) "&_
|
|
|
" ORDER BY CLP_TwoToFiveAdultPrice) AS CLP_TwoToFiveAdultPrice "&_
|
|
|
" FROM dbo.CustomerLineInfo2 INNER JOIN "&_
|
|
|
" dbo.CustomerLineInfo ON "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_CLI_SN = dbo.CustomerLineInfo.CLI_SN INNER JOIN "&_
|
|
|
" dbo.CustomerLinePrice ON "&_
|
|
|
" dbo.CustomerLineInfo.CLI_SN = dbo.CustomerLinePrice.CLP_CLI_SN "&_
|
|
|
" GROUP BY dbo.CustomerLineInfo.CLI_SN, dbo.CustomerLineInfo.CLI_NO, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_Days, dbo.CustomerLineInfo.CLI_ListImage, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_OrderNum, dbo.CustomerLineInfo.CLI_State, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_PassCity, "&_
|
|
|
" dbo.CustomerLinePrice.CLP_TwoToFiveAdultPrice, "&_
|
|
|
" dbo.CustomerLinePrice.CLP_PriceType, dbo.CustomerLineInfo2.CLI2_Name, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_PackageClass, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_LineType, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_AttractionList, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_EntranceCity, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_DepartureCity, dbo.CustomerLineInfo2.CLI2_LGC, "&_
|
|
|
" dbo.CustomerLinePrice.CLP_TwoToFiveAdultPriceRMB, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_CityName, dbo.CustomerLineInfo.CLI_Grade, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_LineClass, dbo.CustomerLineInfo.CLI_PrimeGroup, "&_
|
|
|
" dbo.CustomerLineInfo2.CLI2_Memo, dbo.CustomerLineInfo2.CLI2_Introduction, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_DEI_SN, "&_
|
|
|
" dbo.CustomerLinePrice.CLP_TwoToFiveAdultProPriceRMB, "&_
|
|
|
" dbo.CustomerLineInfo.CLI_Area, "&_
|
|
|
" dbo.getCityName(dbo.CustomerLineInfo.CLI_CII_SN, 1),dbo.CustomerLineInfo.CLI_CII_SN "&_
|
|
|
" HAVING (dbo.CustomerLineInfo.CLI_State = 1005004) AND "&_
|
|
|
" (dbo.CustomerLineInfo2.CLI2_LGC = 1) AND "&_
|
|
|
" (dbo.CustomerLineInfo.CLI_PackageClass IN (202003, 202005, 202007)) "&_
|
|
|
" "& temp_cities &" " &_
|
|
|
" ORDER BY dbo.CustomerLinePrice.CLP_TwoToFiveAdultPrice) T LEFT OUTER JOIN "&_
|
|
|
" dbo.PictureInfo ON T.CLI_ListImage = dbo.PictureInfo.PII_SN "&_
|
|
|
"GROUP BY T.CLI_SN, T.CLI_Days, T.CLI_ListImage, T.CLI_CityName, T.CLI2_Name, "&_
|
|
|
" T.CLI_NO, T.CLI2_PassCity, T.CLI2_AttractionList, T.CLI2_Memo, T.CLI_OrderNum, "&_
|
|
|
" dbo.GetFullPathByPII_SN(dbo.PictureInfo.PII_SN, 1), T.CityName, T.CLI_CII_SN, T.CLP_TwoToFiveAdultPrice "&_
|
|
|
"ORDER BY T.CLI_OrderNum "
|
|
|
'response.write sql
|
|
|
'response.End()
|
|
|
|
|
|
set rs = server.createobject("adodb.recordset")
|
|
|
rs.open sql,conn,3,1,1
|
|
|
|
|
|
tourcount = rs.recordcount
|
|
|
|
|
|
if tourcount = "" Or isempty(tourcount) Or isnull(tourcount) then
|
|
|
tourcount = 0
|
|
|
end if
|
|
|
'转到city-tour-list-new.asp
|
|
|
'if rs.recordcount > 8 then
|
|
|
' server.Transfer("/single-city-tour/city-tour-list-new.asp")
|
|
|
'end if
|
|
|
'转到city-tour-list-new.asp
|
|
|
|
|
|
%>
|
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
|
<head>
|
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
|
<title><%=def_title%></title>
|
|
|
<meta name="Copyright" content="www.chinahighlights.com, copyrights reserved." />
|
|
|
<meta name="keywords" content="<%=def_keywords%>"/>
|
|
|
<meta name="description" content="<%=capitalize(city)%> Tours: <%=strGetSubstring(get_web_page_intro(city), 1, 150, "...")%>"/>
|
|
|
<link href="/css/global-all-new.css" rel="stylesheet" type="text/css" media="all" />
|
|
|
<link href="http://data.chinahighlights.com/css/citytour.css" rel="stylesheet" type="text/css" media="all" />
|
|
|
<script language="javascript" src="http://data.chinahighlights.com/js/jquery.js"></script>
|
|
|
<script language="javascript" src="/js/newcalendar.js"></script>
|
|
|
<script type='text/javascript' src='/js/boxyapp.js'></script>
|
|
|
<script type="text/javascript" src="/js/newcalendar.js"></script>
|
|
|
<script type="text/javascript" src="/js/common.js"></script>
|
|
|
<script type="text/javascript" src="/js/hotel.js"></script>
|
|
|
<script type='text/javascript' src='http://data.chinahighlights.com/js/ChtPublic.js'></script>
|
|
|
|
|
|
<script language="javascript">
|
|
|
$(function(){
|
|
|
$("#ShowDayTrips").click(function(){
|
|
|
$("#DayTripsTop").show();$("#ActivitiesTop").hide();
|
|
|
$("#ShowDayTrips").addClass("active");$("#ShowActivities").removeClass("active");
|
|
|
})})
|
|
|
$(function(){
|
|
|
$("#ShowActivities").click(function(){
|
|
|
$("#DayTripsTop").hide();$("#ActivitiesTop").show();
|
|
|
$("#ShowDayTrips").removeClass("active");$("#ShowActivities").addClass("active");
|
|
|
})})
|
|
|
</script>
|
|
|
</head>
|
|
|
<body>
|
|
|
<div id="wrapper">
|
|
|
<!--#include virtual="/include/headerWrapper-2013.asp"-->
|
|
|
<div id="content">
|
|
|
<div id="contentHead">
|
|
|
<div id="subNav"><a href="/">Home</a> <a href="/citytour/" >Single City Tours</a> <%=capitalize(city)%> Tours</div>
|
|
|
<h1><%=capitalize(city)%> Tours</h1>
|
|
|
</div>
|
|
|
<div id="mainContent2">
|
|
|
<div id="contentRight">
|
|
|
<div class="note">
|
|
|
<p><% =get_web_page_intro(city) %></p>
|
|
|
</div>
|
|
|
<form id="form1" name="form1" method="post" action="">
|
|
|
<%
|
|
|
|
|
|
if rs.eof and rs.bof then
|
|
|
else
|
|
|
dim i1
|
|
|
i1 = 1
|
|
|
do while not rs.eof
|
|
|
sn = rs("cli_sn")
|
|
|
title = rs("CLI2_Name")
|
|
|
Price = rs("CLP_TwoToFiveAdultPrice")
|
|
|
CLI_NO = rs("CLI_NO")
|
|
|
CLI_CityName = rs("CityName")
|
|
|
CityTourInfoUrl = strFormat(urlCityTourInfo,array(changeStrPara(CLI_CityName),changToPara(rs("CLI_NO"))))
|
|
|
if rs("CLI_Days") > 1 then
|
|
|
days = rs("CLI_Days") & " Days"
|
|
|
else
|
|
|
days = rs("CLI_Days") & " Day"
|
|
|
end if
|
|
|
|
|
|
'HF 100211更新获得图片地址方法
|
|
|
if isnull(rs("pic")) or rs("pic") = empty then
|
|
|
pic = "/pic/unknown.gif"
|
|
|
else
|
|
|
pic = imgurl & rs("pic")
|
|
|
end if
|
|
|
CLI2_Memo = rs("CLI2_Memo")
|
|
|
if i1 > 4 then box_class = "tourListBox2" else box_class = "tourListBox1"
|
|
|
%>
|
|
|
<div class="china-tour-list">
|
|
|
<div class="listImage150"><a href="<%=CityTourInfoUrl%>"> <img src="<%=pic%> " border="0" /> </a> </div>
|
|
|
<div class="listContent418">
|
|
|
<h2><a href="<%=CityTourInfoUrl%>"><%=title%></a></h2>
|
|
|
<ul class="tourdetailedInfo">
|
|
|
<li><strong>Duration:</strong> <%=days%></li>
|
|
|
<li><strong>Destination:</strong> <%=capitalize(CLI_CityName)%></li>
|
|
|
<li class="features"><strong>Attractions:</strong> <%=CLI2_Memo%></li>
|
|
|
</ul>
|
|
|
</div>
|
|
|
<div class="searchlistPrice"><span class="fullPrice">Full price from:</span> <br />
|
|
|
<span class=" highlightBold red_price">$<%=Price%></span> p/p<br />
|
|
|
<div class="viewDetail"> <a href="<%=CityTourInfoUrl%>" target="citytour"><img src="http://data.chinahighlights.com/pic/view-details.png"></a></div>
|
|
|
</div>
|
|
|
<div class="clear"></div>
|
|
|
</div>
|
|
|
<%
|
|
|
i1 = i1 + 1
|
|
|
rs.movenext
|
|
|
loop
|
|
|
end if
|
|
|
rs.close
|
|
|
%>
|
|
|
</form>
|
|
|
<div id="sidebar"> </div>
|
|
|
<p><a href="/forms/tailormadetours.htm"><img src="http://data.chinahighlights.com/image/promo/tailor-make-760.gif" width="760" height="140" alt="Tailor Make a China Tour"></a></p>
|
|
|
</div>
|
|
|
<div id="sideBar">
|
|
|
<div class="rightBox">
|
|
|
<div class="rightContent">
|
|
|
<h4>About <%=capitalize(city)%></h4>
|
|
|
<ul class="squareGray">
|
|
|
<li><a href="/<%=replace(lcase(city), " ", "-")%>/"><%=capitalize(city)%> Overview</a></li>
|
|
|
<li><a href="/<%=replace(lcase(city), " ", "-")%>/weather.htm"><%=capitalize(city)%> Weather</a></li>
|
|
|
<li><a href="/<%=replace(lcase(city), " ", "-")%>/map.htm"><%=capitalize(city)%> Map</a>s</li>
|
|
|
</ul>
|
|
|
</div>
|
|
|
</div>
|
|
|
<p><a href="/faq/tour/china-tours-reservation/how-to-make-a-reservation.htm" target="_blank"><img src="http://data.chinahighlights.com/image/promo/book-steps-s.jpg" alt="<%=capitalize(city)%> Private Tours" title="<%=capitalize(city)%> Private Tours"></a></p>
|
|
|
<p> </p>
|
|
|
<p align="center"><a href="/forms/call-you.asp" rel="nofollow"><img original="/image/promo/call-you.gif" src="http://data.chinahighlights.com/image/promo/call-you.gif" alt="Would you like us to call you" border="0" height="71" width="171"></a></p>
|
|
|
<p><a href="/forms/call-you.asp" rel="nofollow">Leave your phone number, and we will call back!</a></p>
|
|
|
</div>
|
|
|
|
|
|
</div>
|
|
|
<div class="clear"></div>
|
|
|
</div>
|
|
|
<div class="contentBottom"></div>
|
|
|
<!--#include virtual="/include/footer-link-tour.asp" -->
|
|
|
</div>
|
|
|
</body>
|
|
|
</html> |