开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 其他行业 > 查看源码
wy_trip_findasp.asp
资源名称：lyxxgl.rar　[点击查看]
上传用户：hnxqingdao
上传日期：2013-05-22
资源大小：1283k
文件大小：10k
源码类别：

其他行业

开发平台：

ASP/ASPX

wy_trip_findasp.asp：源码内容
  1. <!--#include file="../wy_trip_inc/wy_trip_cnn.inc"-->
  2. <html>
  3. <head>
  4. <title>PTrip Server 2005 For 数据库课程设计
  5. </title>
  6. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  7. <link rel="stylesheet" type="text/css" href="../wy_trip_css/wy_trip.css">
  8. </head>
  9. <%
  10.       country=request.Form("classid")
  11.   city=request.Form("Nclassid")
  12.   money=request.Form("Mclassid")
  13.   keyword=request.Form("keyword")
  14.   
  15.   qcountry=request.QueryString("country")
  16.   qcity=request.QueryString("city")
  17.   qmoney=request.QueryString("money")
  18.   
  19.   if(country="" and city="" and money="")then
  20.      country=qcountry
  21.  city=qcity
  22.  money=qmoney
  23.   end if  
  24.   country=trim(country)
  25.   city=trim(city)
  26.   money=trim(money)
  27.  ' response.Write(country)
  28.   'response.Write(city)
  29.      '"500~2000" d>500元~2000元</option>
  30. '<option value="2000~5000">2000元~5000元</option>
  31. '<option value="5000~8000">5000元~8000元</option>
  32. '<option value="8000~10000">
  33.  sqlstr1="nothing"
  34.  sqlstr2="nothing"
  36.      select case money
  37.         case "500~2000"
  38.       m1=500
  39.   m2=2000
  40.     case  "2000~5000"
  41.       m1=2000
  42.   m2=5000
  43. case  "5000~8000"
  44.       m1=5000
  45.   m2=8000
  46. case  "8000~10000"
  47.       m1=8000
  48.   m2=10000   
  49.  end select 
  50.  
  51.  
  52.  
  53.  if(city="")then
  54.      ' country="" city="" money=""
  55.      if(keyword="关键字")then
  56.   sqlstr1="select * from trip_solhomelandinfor"
  57.   sqlstr2="select * from trip_soloverseasinfor"
  58.  else
  59.   sqlstr1="select * from trip_solhomelandinfor where solname like '%"&keyword&"%'"
  60.   sqlstr2="select * from trip_soloverseasinfor where solname like '%"&keyword&"%'"     
  61.  end if
  62.  ' country="" city="" money<>""
  63.  if(money<>"")then
  64.    if(keyword="关键字")then
  65.     sqlstr1="select * from trip_solhomelandinfor where solmoney>="&m1&" and solmoney<="&m2
  66.     sqlstr2="select * from trip_soloverseasinfor where solmoney>="&m1&" and solmoney<="&m2
  67.    else
  68.     sqlstr1="select * from trip_solhomelandinfor where solmoney>="&m1&" and solmoney<="&m2&" and solname like '%"&keyword&"%'"
  69.     sqlstr2="select * from trip_soloverseasinfor where solmoney>="&m1&" and solmoney<="&m2&" and solname like '&"&keyword&"%'"    
  70.    end if
  71.  end if
  72.  else
  73.      ' country="" city<>""
  74.  if(keyword="关键字")then
  75.   sqlstr1="select * from trip_solhomelandinfor where soladdress='"&city&"'"
  76.   sqlstr2="select * from trip_soloverseasinfor where soladdress='"&city&"'"
  77.  else
  78.   sqlstr1="select * from trip_solhomelandinfor where soladdress='"&city&"' and solname like '%"&keyword&"%'"
  79.   sqlstr2="select * from trip_soloverseasinfor where soladdress='"&city&"' and solname like '%"&keyword&"%'"  
  80.  end if
  81.  ' country="" city="" money<>""
  82.  if(money<>"")then
  83.      if(keyword="关键字")then
  84.       sqlstr1="select * from trip_solhomelandinfor where soladdress='"&city&"' and solmoney>="&m1&" and solmoney<="&m2
  85.     sqlstr2="select * from trip_soloverseasinfor where soladdress='"&city&"' and solmoney>="&m1&" and solmoney<="&m2
  86.  else
  87.       sqlstr1="select * from trip_solhomelandinfor where soladdress='"&city&"' and solmoney>="&m1&" and solmoney<="&m2&"' and solname like '%"&keyword&"%'"
  88.     sqlstr2="select * from trip_soloverseasinfor where soladdress='"&city&"' and solmoney>="&m1&" and solmoney<="&m2&"' and solname like '%"&keyword&"%'"  
  89.  end if
  90.  end if 
  91.  end if
  92.  
  93.  select case country
  94.         case ""
  95.      showl=0
  96.     case "1"
  97.      showl=1
  98. case "2"
  99.      show=2  
  100.  end select
  102.  'if( country=1) then
  103.       ' tablename="trip_solhomelandinfor"
  104.    'solad=0
  105. ' else
  106.        'tablename="trip_soloverseasinfor"
  107.    'solad=1
  108. ' end if
  109. %>
  111. <body leftmargin="0" topmargin="0"  bottommargin="0" rightmargin="0" link="#3357B3" vlink="#3357B3" alink="#3357B3" bgcolor="#e8eefc">
  112. <table width="750" height="716" cellpadding="0" cellspacing="0">
  113. <tr>
  114.   <td valign="top" class="Main">
  115. <p class="NoBreakBeforeAfter"><img src="../wy_trip_images/TopCol3.gif" WIDTH="247" HEIGHT="23"></p>
  116. <p class="NoBreakBeforeAfter"><img src="../wy_trip_images/HeaderOtherDestination.gif" width="229" height="28"></p>
  117. <p class="Indented1" align="center"><font size="6" color="#3357b3"><b> 旅游解决方案查询</b></font></p>
  118. <p class="Indented1" align="center">&nbsp;</p>
  119. <table width="95%"  border="0" align="center" cellpadding="0" cellspacing="0">
  120.               <tr>
  121.                 <th colspan="2" scope="col">名称</th>
  122.                 <th width="14%" scope="col">类型</th>
  123.                 <th width="10%" scope="col">地点</th>
  124.                 <th width="10%" scope="col">费用</th>
  125.                 <th width="19%" scope="col">说明</th>
  126.                 <th width="21%" scope="col">更新时间</th>
  127.               </tr>
  128.               <tr>
  129.                 <td colspan="7"><hr color="#999999" width="100%"></td>
  130.               </tr>
  131.   <%
  132.       if(showl=0 or showl=1)then
  133.      sqlstr=sqlstr1
  135.                      solad1=0
  136.   set rst=server.createobject("adodb.recordset")
  137.   rst.open sqlstr,conn,1,1
  138.  
  139.  
  140.   if not (rst.eof or rst.bof) then
  141.                       do while(not rst.eof)
  142.     solid1=rst("id")
  143.     solname1=rst("solname")
  144. soladdress1=rst("soladdress")
  145. soltype1=rst("soltype")
  146. solabode1=rst("solabode")
  147. solmoney1=rst("solmoney")
  148. solnote1=rst("solnote")
  149. soltime1=rst("soltime")
  151.   %>
  152.               <tr onmouseover=this.style.backgroundColor="#cccccc";return  onmouseout=this.style.backgroundColor=''; true;>
  153.                 <td width="5%" ><div align="left">&nbsp;</div></td>
  154.                 <td width="21%" ><div align="left">&nbsp;国内：&nbsp;&nbsp;&nbsp;&nbsp;<%=solname1%></div></td>
  155.                 <td><div align="center"><%=soltype1%></div></td>
  156.                 <td><div align="center"><%=soladdress1%></div></td>
  157.                 <td><div align="center"><%=solmoney1%></div></td>
  158.                 <td><div align="center"><a href="wy_trip_findshow.asp?inforid=<%=solid1%>&inforkind=<%=solad1%>&solname=<%=solname1%>"><font color="#0000FF">详细内容</font></a></div></td>
  159.                 <td><div align="center"><%=soltime1%></div></td>
  160.               </tr>
  161.   <tr>
  162.                 <th colspan="2" scope="col">&nbsp;</th>
  163.                 <th scope="col">&nbsp;</th>
  164.                 <th scope="col">&nbsp;</th>
  165.                 <th scope="col">&nbsp;</th>
  166.                 <th scope="col">&nbsp;</th>
  167.                 <th scope="col">&nbsp;</th>
  168.               </tr> 
  169.   <%
  170.                rst.movenext
  171.  loop
  172.     end if
  173. rst.close
  174. set rst=nothing
  176. end if    
  177.    %>
  178.    <tr>
  179.                 <th colspan="2" scope="col">&nbsp;</th>
  180.                 <th scope="col">&nbsp;</th>
  181.                 <th scope="col">&nbsp;</th>
  182.                 <th scope="col">&nbsp;</th>
  183.                 <th scope="col">&nbsp;</th>
  184.                 <th scope="col">&nbsp;</th>
  185.               </tr> 
  186.    <%
  187.        if(showl=0 or show=2)then
  188.         sqlstr=sqlstr2
  189. solad2=1
  190.   set rst=server.createobject("adodb.recordset")
  191.   rst.open sqlstr,conn,1,1
  192.  
  193.   if not (rst.eof or rst.bof) then
  194.                       do while(not rst.eof)
  195.     solid2=rst("id")
  196.     solname2=rst("solname")
  197. soladdress2=rst("soladdress")
  198. soltype2=rst("soltype")
  199. solabode2=rst("solabode")
  200. solmoney2=rst("solmoney")
  201. solnote2=rst("solnote")
  202. soltime2=rst("soltime")
  204.   %>
  205.               <tr onmouseover=this.style.backgroundColor="#cccccc";return  onmouseout=this.style.backgroundColor=''; true;>
  206.                 <td><div align="left"></div></td>
  207.                 <td>&nbsp;国外：&nbsp;&nbsp;&nbsp;&nbsp;<%=solname2%></td>
  208.                 <td><div align="center"><%=soltype2%></div></td>
  209.                 <td><div align="center"><%=soladdress2%></div></td>
  210.                 <td><div align="center"><%=solmoney2%></div></td>
  211.                 <td><div align="center"><a href="wy_trip_findshow.asp?inforid=<%=solid2%>&inforkind=<%=solad2%>&solname=<%=solname2%>"><font color="#0000FF">详细内容</font></a></div></td>
  212.                 <td><div align="center"><%=soltime2%></div></td>
  213.               </tr>
  214.   <tr>
  215.                 <th colspan="2" scope="col">&nbsp;</th>
  216.                 <th scope="col">&nbsp;</th>
  217.                 <th scope="col">&nbsp;</th>
  218.                 <th scope="col">&nbsp;</th>
  219.                 <th scope="col">&nbsp;</th>
  220.                 <th scope="col">&nbsp;</th>
  221.               </tr> 
  222.   <%
  223.                rst.movenext
  224.  loop
  225.     end if
  226. rst.close
  227. set rst=nothing
  228. end if
  233.   %>
  234.   <tr>
  235.                 <th colspan="2" scope="col">&nbsp;</th>
  236.                 <th scope="col">&nbsp;</th>
  237.                 <th scope="col">&nbsp;</th>
  238.                 <th scope="col">&nbsp;</th>
  239.                 <th scope="col">&nbsp;</th>
  240.                 <th scope="col">&nbsp;</th>
  241.               </tr>
  242.   
  243.   <tr>
  244.                 <th colspan="2" scope="col">&nbsp;</th>
  245.                 <th scope="col">&nbsp;</th>
  246.                 <th scope="col">&nbsp;</th>
  247.                 <th scope="col">&nbsp;</th>
  248.                 <th scope="col">&nbsp;</th>
  249.                 <th scope="col"><a href="wy_trip_find.asp">返回</a></th>
  250.               </tr>
  251.             </table>
  252. <p>&nbsp;</p></td>
  253. </tr>
  254. <tr>
  255.   <td bgcolor="#e8eefc">&nbsp;</td>
  256.   </tr>
  257. <tr>
  258.    <td bgcolor="#e8eefc">&nbsp;</td>
  259. </tr>
  260. </table>
  261. </body>
  262. </html>