home *** CD-ROM | disk | FTP | other *** search
/ 221.214.14.186 / 221.214.14.186.tar / 221.214.14.186 / lc / gaotang / SCHQ / SCHQ1.ASP < prev   
Text File  |  2010-01-21  |  10KB  |  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. <style>
  6.     .x {color:#ffcc00;font-size:14px;font-weight:bold;}
  7.     table,input { font-size:12px; }
  8.     a { color:#0206CE;text-decoration:underline;}
  9.     a:hover{ text-decoration:underline; }
  10. </style>
  11. </head>
  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 border="0" src="../IMAGES/╕▀╠╞═╝╞¼/gt01.jpg"></TD>
  25.     <TD WIDTH=620 height="57" valign="top"><img border="0" src="../IMAGES/╕▀╠╞═╝╞¼/gt02.jpg"></TD>
  26.     
  27.   </TR>
  28.   <TR> 
  29.     <TD align="center" valign="middle"><a href="../qufu.htm"><font color="#000000">╕▀╠╞</font></a><a href="file:///C:/╕▀╠╞/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="file:///C:/╕▀╠╞/tese.htm" target="_blank"><font color="#000000">╕▀╠╞</font></a><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=50.0.0.4;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.