home *** CD-ROM | disk | FTP | other *** search
/ 221.214.14.186 / 221.214.14.186.tar / 221.214.14.186 / jn / yanzhou / SCHQ / SCHQ1.ASP < prev   
Text File  |  2010-01-21  |  9KB  |  185 lines
  1. <!--#include file="data/include/sqldb.inc.asp"-->
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  5. </head>
  6. <style>
  7.     .x {color:#ffcc00;font-size:14px;font-weight:bold;}
  8.     table,input { font-size:12px; }
  9.     a { color:#0206CE;text-decoration:underline;}
  10.     a:hover{ text-decoration:underline; }
  11. </style>
  12. <body>
  13. <table width=760 border=0 align="center" cellpadding=0 cellspacing=0 >
  14.   <tr bgcolor=#CCCCCC> 
  15.       
  16.     <td height=22 bgcolor=#666666 ALIGN=RIGHT> <FONT 
  17. color=#ffffff><img src=images/dot1.gif width=1 height=1> <A href="../"><FONT 
  18. color=#FFCC00>╩╫╥│</FONT></A> | <a href="javascript:window.external.addFavorite('http://www.sdxnw.gov.cn','╨╦┼⌐═°╩╨│í╨┼╧ó')"><font color="#ffcc00">╔Φ╬¬╩╒▓╪</font></a>| 
  19.       <A href="mailto:jfxnw@sdan.com.cn"><font color=#ffcc00>┴¬╧╡╬╥├╟</font></A>|</FONT></td>
  20.     </tr>
  21.   </table>
  22. <TABLE WIDTH=760 BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  23.   <TR> 
  24.     <TD width="140" HEIGHT=66 rowspan="2" valign="top"><IMG SRC=../images/qufu.jpg WIDTH=123 HEIGHT=75></TD>
  25.     <TD WIDTH=620 height="57" valign="top"><img src=../banner.jpg width=620 height=50></TD>
  26.     
  27.   </TR>
  28.   <TR> 
  29.     <TD align="center" valign="middle"><a href="../qufu.htm"><font color="#000000">╟·╕╖╕┼┐÷</font></a> 
  30.       | <a href="../news"><font color="#000000">╨╦┼⌐┐∞╤╢</font></a> | <font color="#FF0000"><strong>╩╨│í╨╨╟Θ</strong></font> 
  31.       | <a href="http://www.sdxnw.gov.cn/syjs.asp" target="_blank"><font color="#000000">┼⌐╥╡┐╞╝╝</font></a> 
  32.       | <a href="../tese.htm" target="_blank"><font color="#000000">╟·╕╖╠╪╔½</font></a> | <a href="../zsyz/zsyz.asp"><font color="#000000">╒╨╔╠╥²╫╩</font></a> 
  33.       | <a href="../weather"><font color="#000000">╞°╧≤╖■╬±</font></a></TD>
  34.   </TR>
  35. </TABLE>
  36. <table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  37.   <tr> 
  38.     <td width="141" height="358" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" >
  39.         <tr valign="middle"> 
  40.           <td height="19" colspan="2" background="images/line3.jpg"><font color="#FF0000"><strong>┼⌐╕▒▓·╞╖</strong></font></td>
  41.         </tr>
  42.         <tr> 
  43.           <td width="69" height="18" valign="top"><a href="schq.asp?classid='╩▀▓╦╥░▓╦'">╩▀▓╦╥░▓╦</a></td>
  44.           <td width="72" align="left" valign="top"><a href="schq.asp?classid='┴╕╙═├▐┬Θ'"> 
  45.             ┴╕╙═├▐┬Θ</a></td>
  46.         </tr>
  47.         <tr> 
  48.           <td height="16" valign="top"><a href="schq.asp?classid='║ú╧╩╦«▓·'">║ú╧╩╦«▓·</a></td>
  49.           <td height="16" align="left" valign="top"><a href="schq.asp?classid='╕╔╧╩╣√╞╖'">╕╔╧╩╣√╞╖</a></td>
  50.         </tr>
  51.         <tr> 
  52.           <td height="21" valign="top"><a href="schq.asp?classid='╚Γ╟▌╡░─╠'">╚Γ╟▌╡░─╠</a></td>
  53.           <td height="21" align="left" valign="top"><a href="schq.asp?classid='╩│╙├╒µ╛·'">╩│╙├╒µ╛·</a></td>
  54.         </tr>
  55.         <tr> 
  56.           <td height="15" colspan="2" valign="top"><strong><font color="#FF0000">┼⌐╥╡╬∩╫╩</font></strong></td>
  57.         </tr>
  58.         <tr> 
  59.           <td height="22" colspan="2" valign="top"><a href="schq.asp?classid='╗»╖╩'">╗»╖╩</a> 
  60.             <a href="schq.asp?classid='┼⌐╥⌐'">┼⌐╥⌐</a> <a href="schq.asp?classid='╦╟┴╧'">╦╟┴╧</a> 
  61.             <a href="schq.asp?classid='╓╓╫╙'">╓╓╫╙</a> </td>
  62.         </tr>
  63.         <tr> 
  64.           <td height="16" colspan="2" valign="top"><strong><font color="#FF0000">╞Σ╦√</font></strong></td>
  65.         </tr>
  66.         <tr> 
  67.           <td height="50" colspan="2" valign="top"><a href="schq.asp?classid='╗¿╗▄'">╗¿╗▄</a> 
  68.             <a href="schq.asp?classid='╓╓├τ'">╓╓├τ</a> <a href="schq.asp?classid='╗·╨╡'">╗·╨╡</a> 
  69.             <br> <br>
  70.             <a href="schq.asp?classid='╣ñ╥╒╓╞╞╖'">╣ñ╥╒╓╞╞╖</a> <a href="schq.asp?classid='╩▐╥⌐'">╩▐╥⌐</a><br>
  71.           </td>
  72.         </tr>
  73.         <tr> 
  74.           <td height="17" colspan="2" valign="top" background="images/line3.jpg"><strong><font color="#FF0000">╣⌐╟≤╚╚╧▀</font></strong></td>
  75.         </tr>
  76.         <tr> 
  77.           <td height="169" colspan="2" valign=top> 
  78.            <!--#include file="../../../common/market1.asp"-->
  79.           </td>
  80.         </tr>
  81.         <tr> 
  82.           <td colspan="2" align=right><a href="http://www.sdxnw.gov.cn/scxx_jghq_show.asp?scxx=2"><img src="images/more.gif" width="20" height="6" border="0">╕ⁿ╢α</a></td>
  83.         </tr>
  84.       </table></td>
  85.     <td width="619" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
  86.         <tr> 
  87.           <td width="619" height="18" align="right" valign="bottom"><a href="http://www.sdxnw.gov.cn/scxx_show.asp?mark=1"><img src="images/more.gif" width="20" height="9" border="0">╕ⁿ╢α</a></td>
  88.         </tr>
  89.         <tr> 
  90.           <td height="164" valign="top"> 
  91.            <%
  92.                dim conn,sql,rs
  93.                dim currentPage,counts
  94.                dim cityid,cityids
  95.                    cityid=trim(request("cityid"))
  96.                    cityids=split(cityid,",")
  97.                    currentPage=trim(request("currentPage"))
  98.                    classid=request("classid")
  99.               if currentPage="" then currentPage=1
  100.  
  101.                  set conn=server.createobject("ADODB.connection")
  102.                  set rs=server.createobject("ADODB.recordSet")
  103.  
  104.                  conn.open("Provider=SQLOLEDB.1;Server=80.0.0.17;Database=sdxnw;UID=read;pwd=DSread17@8408;")
  105.                  sql="select * from SCXX_price"
  106.                  %>
  107.  
  108.             <%
  109.                  if  classid="" then
  110.                  
  111.                  sql=sql & " where types2='╩▀▓╦╥░▓╦' and cityid=19"  '╘┌┤╦┤ª╨▐╕─cityidíú
  112.                  else
  113.                  sql=sql & " where types2=" & classid &"and cityid=19" '╘┌┤╦┤ª╨▐╕─cityid.
  114.                 ' for counts=0 to ubound(cityids)
  115.                 ' sql=sql & " or cityid=" & cityids(counts)
  116.                 ' next
  117.                  end if
  118.                  sql=sql & " order by dates desc"
  119.                  rs.PageSize=15
  120.                  rs.CursorType=adOpenStatic
  121.                  rs.Open sql,conn
  122.                  if cint(currentPage)<1 then currentPage=1
  123.                  if cint(currentPage)>rs.pageCount then currentPage=rs.PageCount
  124.                  if rs.eof then currentPage=0
  125.                  if not rs.eof then 
  126.                  rs.AbsolutePage=cint(currentPage)
  127.                  end if
  128.             %>
  129.             <form name="form_log" method="post" action="schq.asp?classid=<%=classid%>">
  130.               <table width="619" align="center">
  131.                 <tr>
  132.                   <td width="596" align="center"> <table border=1 bordercolor="white" align="center">
  133.                       <tr > 
  134.                         <td height="17" align=left width=90 class="x">├√│╞</td>
  135.                         <td align=left width=45 class="x">╝█╕±</td>
  136.                         <td align=left width=45 class="x">╡Ñ╬╗</td>
  137.                         <td align=left width=65 class="x">╩▒╝Σ</td>
  138.                         <td align=left width=150 class="x">╜╗╥╫╡╪╡π</td>
  139.                         <td align=left width=90 class="x">└α╨═</td>
  140.                       </tr>
  141.                       <%
  142.                           counts=0
  143.                           while not rs.eof and counts<rs.PageSize
  144.                       %>
  145.                       <tr> 
  146.                         <td><%=left(rs("name"),10)%></td>
  147.                         <td><%=rs("price")%></td>
  148.                         <td><%=rs("units")%></td>
  149.                         <td><%=left(rs("dates"),10)%></td>
  150.                         <td><%=left(rs("lxfs"),13)%></td>
  151.                         <td><%=rs("types")%></td>
  152.                       </tr>
  153.                       <%counts=counts+1
  154.                       rs.movenext
  155.                       wend%>
  156.                  
  157.                     </table></td>
  158.                 </tr>
  159.                 <tr>
  160.                   <td>         <%=currentPage%>/<%=rs.PageCount%> 
  161.                          ╝═┬╝╩²:<%=rs.RecordCount%>                  
  162.                                
  163.                     <input type="hidden" name="currentPage" value="<%=currentPage%>"> 
  164.                     <input type="hidden" name="cityid" value="<%=cityid%>"> <span style="cursor:hand;" onclick="form_log.currentPage.value=1;form_log.submit();"><font color="#cccccc">╩╫╥│</font></span> 
  165.                       <span style="cursor:hand;" onclick="form_log.currentPage.value=eval(form_log.currentPage.value)-1;form_log.submit();"><font color="#cccccc">╔╧╥╗╥│</font></span> 
  166.                       <span style="cursor:hand;" onclick="form_log.currentPage.value=eval(form_log.currentPage.value)+1;form_log.submit();"><font color="#cccccc">╧┬╥╗╥│</font></span> 
  167.                       <span style="cursor:hand;" onclick="form_log.currentPage.value=<%=rs.PageCount%>;form_log.submit();"><font color="#cccccc">╬▓╥│</font></span> 
  168.                   </TD>
  169.                 </TR>
  170.               </table>
  171.             </form></td>
  172.         </tr>
  173.       </table></td>
  174.   </tr>
  175. </table>
  176. <hr width=760 size=1>
  177.   
  178. <table width=760 border=0 align="center" cellpadding=0 cellspacing=0 >
  179.   <tr>
  180.       <td height=35 align=center> Copyright @ 2003 sdxnw.gov.cn All rights reserved. 
  181.         ╔╜╢½╨╦┼⌐═° ░µ╚¿╦∙╙╨<br>
  182.         ┬│ICP▒╕030012║┼ </td>
  183.     </tr></table></body>
  184. </html>
  185.