home *** CD-ROM | disk | FTP | other *** search
/ 221.214.14.186 / 221.214.14.186.tar / 221.214.14.186 / lc / yg / schq.asp < prev    next >
Text File  |  2010-01-21  |  14KB  |  244 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=/03/></a><A href="mailto:jfxnw@sdan.com.cn"><font color=#ffcc00>┴¬╧╡╬╥├╟</font></A>|</FONT></td>        
  20.     </tr>        
  21.   </table>        
  22. <TABLE WIDTH=760 BORDER=1 align="center" CELLPADDING=0 CELLSPACING=0 height="110" bordercolor="#FFFF00" bgcolor="#FFFFFF" background="../../xzshj/2/xg[1].jpg">        
  23.   <TR>         
  24.     <TD width="110" HEIGHT=110 rowspan="2" valign="top"><img border="0" src="file:///D:/╨╦┼⌐═°1/bs4.jpg" width="110" height="75"></TD>       
  25.     <TD WIDTH=646 height="62" valign="top">íí</TD>       
  26.            
  27.   </TR>       
  28.   <TR>        
  29.     <TD align="center" valign="middle" width="646" height="48"><a href="yanggu.htm"><font size="3"><b><font color="#FF00FF">╤⌠╣╚╕┼┐÷</font></b></font></a>        
  30.       <font size="3"><font color="#FF00FF">         
  31.       | <a href="news.htm"></a> </font> <a href="news.htm"><font color="#FF0000"><b>╨╦┼⌐┐∞╤╢</b></font></a> <font color="#FF00FF"> | <a href="schq.asp"><strong></strong></a>         
  32.       </font> <a href="schq.asp"><strong><font color="#FF0000">╩╨│í╨╨╟Θ</font></strong></a>        
  33.       <font color="#FF00FF">         
  34.       | <a href="http://www.sdxnw.gov.cn/syjs.asp"></a>         
  35.       </font> <a href="http://www.sdxnw.gov.cn/syjs.asp"><font color="#FF0000"><b>┼⌐╥╡┐╞╝╝</b></font></a>        
  36.       <font color="#FF00FF">         
  37.       | <a href="tese.htm"></a> </font> <a href="tese.htm"><font color="#FF0000"><b>╠╪╔½┼⌐╥╡</b></font></a> <font color="#FF00FF"> | <a href="zsyz.asp"></a>         
  38.       </font> <a href="zsyz.asp"><font color="#FF0000"><b>╒╨╔╠╥²╫╩</b></font></a>        
  39.       <font color="#FF00FF">         
  40.       | <a href="../weather"></a></font> <a href="../weather"><i><font color="#FF0000"><b>╞°╧≤╖■╬±</b></font></i></a></font></TD>       
  41.   </TR>       
  42. </TABLE>       
  43. <table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">       
  44.   <tr>        
  45.     <td width="141" height="358" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" >       
  46.         <tr>        
  47.           <td height="17" valign="top" background="images/line3.jpg"><strong><font color="#FF0000">╣⌐╟≤╚╚╧▀</font></strong></td>       
  48.         </tr>       
  49.         <tr>        
  50.           <td height="169" valign=top>        
  51.             <%sub querytable(inputquery)       
  52.                        set conn1=server.createobject("ADODB.connection")       
  53.                        conn1.open("Provider=SQLOLEDB.1;Server=50.0.0.4;Database=sdxnw;UID=read;pwd=DSread17@8408;")       
  54.                        set rstemp1=conn1.execute(inputquery)       
  55.                          %>       
  56.             <table border=0>       
  57.               <%do while not rstemp1.eof%>       
  58.               <tr>        
  59.                 <% for i = 0 to 1       
  60.                                thisvalue=trim(rstemp1(i))       
  61.                                If isnull(thisvalue) then       
  62.                                thisvalue=""       
  63.                                end if       
  64.                                if thisvalue="╣⌐" then       
  65.                                  thisvalue="<font color=red>╣⌐</font>"       
  66.                                   end if       
  67.                                if thisvalue="╟≤" then       
  68.                                   thisvalue="<font color=green>╟≤</font>"       
  69.                                   end if       
  70.                              %>       
  71.                 <td valign=top width="98%" height="15" align="left"> <a href="http://localhost/show.asp?id=<%=rstemp1("id")%>">    
  72.                   <table width="100%" border="0" cellpadding="0" cellspacing="0">   
  73.                     <tr valign="middle">   
  74.                       <td height="19" colspan="2" background="file:///D:/╨╦┼⌐═°1/schq/images/line3.jpg"><font color="#FF0000"><strong>┼⌐╕▒▓·╞╖</strong></font></td>   
  75.                     </tr>   
  76.                     <tr>   
  77.                       <td width="69" height="18" valign="top"><a href="schq.asp?classid='╩▀▓╦╥░▓╦'">╩▀▓╦╥░▓╦</a></td>   
  78.                       <td width="72" align="left" valign="top"><a href="schq.asp?classid='┴╕╙═├▐┬Θ'">┴╕╙═├▐┬Θ</a></td>   
  79.                     </tr>   
  80.                     <tr>   
  81.                       <td height="16" valign="top"><a href="schq.asp?classid='║ú╧╩╦«▓·'">║ú╧╩╦«▓·</a></td>   
  82.                       <td height="16" align="left" valign="top"><a href="schq.asp?classid='╕╔╧╩╣√╞╖'">╕╔╧╩╣√╞╖</a></td>   
  83.                     </tr>   
  84.                     <tr>   
  85.                       <td height="21" valign="top"><a href="schq.asp?classid='╚Γ╟▌╡░─╠'">╚Γ╟▌╡░─╠</a></td>   
  86.                       <td height="21" align="left" valign="top"><a href="schq.asp?classid='╩│╙├╒µ╛·'">╩│╙├╒µ╛·</a></td>   
  87.                     </tr>   
  88.                     <tr>   
  89.                       <td height="15" colspan="2" valign="top"><strong><font color="#FF0000">┼⌐╥╡╬∩╫╩</font></strong></td>   
  90.                     </tr>   
  91.                     <tr>   
  92.                       <td height="22" colspan="2" valign="top"><a href="schq.asp?classid='╗»╖╩'">╗»╖╩</a>    
  93.                         <a href="schq.asp?classid='┼⌐╥⌐'">┼⌐╥⌐</a> <a href="schq.asp?classid='╦╟┴╧'">╦╟┴╧</a>    
  94.                         <a href="schq.asp?classid='╓╓╫╙'">╓╓╫╙</a></td>   
  95.                     </tr>   
  96.                     <tr>   
  97.                       <td height="16" colspan="2" valign="top"><strong><font color="#FF0000">╞Σ╦√</font></strong></td>   
  98.                     </tr>   
  99.                     <tr>   
  100.                       <td height="50" colspan="2" valign="top"><a href="schq.asp?classid='╗¿╗▄'">╗¿╗▄</a>    
  101.                         <a href="schq.asp?classid='╓╓├τ'">╓╓├τ</a> <a href="schq.asp?classid='╗·╨╡'">╗·╨╡</a><br>   
  102.                         <br>   
  103.                         <a href="schq.asp?classid='╣ñ╥╒╓╞╞╖'">╣ñ╥╒╓╞╞╖</a>    
  104.                         <a href="schq.asp?classid='╩▐╥⌐'">╩▐╥⌐</a><br>   
  105.                       </td>   
  106.                     </tr>   
  107.                     <tr>   
  108.                       <td height="17" colspan="2" valign="top" background="file:///D:/╨╦┼⌐═°1/schq/images/line3.jpg"><strong><font color="#FF0000">╣⌐╟≤╚╚╧▀</font></strong></td>   
  109.                     </tr>   
  110.                   </table>   
  111.                   <%=thisvalue%></td>      
  112.                 <%next%>      
  113.               </tr>      
  114.               <%rstemp1.movenext      
  115.                             loop      
  116.                           %>      
  117.             </table>      
  118.             <%      
  119.                           rstemp1.close      
  120.                           set rstemp1=nothing      
  121.                           conn1.close      
  122.                           set conn1=nothing      
  123.                           end sub      
  124.                         %>      
  125.             <%call querytable("select top 9 substring(titel,1,9),typeid,id from SCXX_sale order by dates desc,id desc")      
  126.                         %>      
  127.           </td>      
  128.         </tr>      
  129.         <tr>       
  130.           <td align=right><a href="http://www.sdxnw.gov.cn/scxx.asp"><img src="images/more.gif" width="20" height="6" border="0">╕ⁿ╢α</a></td>      
  131.         </tr>      
  132.       </table></td>      
  133.     <td width="619" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" height="283">      
  134.         <tr>       
  135.           <td width="619" height="7" 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>      
  136.         </tr>      
  137.         <tr>       
  138.           <td height="276" valign="top">       
  139.             <%      
  140.                dim conn,sql,rs      
  141.                dim currentPage,counts      
  142.                dim cityid,cityids      
  143.                    cityid=trim(request("cityid"))      
  144.                    cityids=split(cityid,",")      
  145.                    currentPage=trim(request("currentPage"))      
  146.                    classid=request("classid")      
  147.               if currentPage="" then currentPage=1      
  148.       
  149.                  set conn=server.createobject("ADODB.connection")      
  150.                  set rs=server.createobject("ADODB.recordSet")      
  151.       
  152.                  conn.open(constr)      
  153.                  sql="select * from SCXX_price"      
  154.                        
  155.                  if  classid="" then      
  156.                  sql=sql & " where types2='╩▀▓╦╥░▓╦' and cityid=19"      'cityid╬¬╕≈╡╪╩╨╧╪╨┼╧ó╘▒╔╧┤½╨┼╧ó╬¿╥╗▒α║┼íú      
  157.                  else      
  158.                  sql=sql & " where types2=" & classid &"and cityid=19"      
  159.                  for counts=0 to ubound(cityids)      
  160.                  sql=sql & " or cityid=" & cityids(counts)      
  161.                  next      
  162.                  end if      
  163.                  sql=sql & " order by dates desc"      
  164.                 ' response.write(sql)      
  165.                  rs.PageSize=15      
  166.                  rs.CursorType=adOpenStatic      
  167.                  rs.Open sql,conn      
  168.                  if cint(currentPage)<1 then currentPage=1      
  169.                  if cint(currentPage)>rs.pageCount then currentPage=rs.PageCount      
  170.                  if rs.eof then currentPage=0      
  171.                  if not rs.eof then       
  172.                  rs.AbsolutePage=cint(currentPage)      
  173.                  end if      
  174.             %>      
  175.             <form name="form_log" method="post" action="schq.asp">      
  176.               <table width="619" height="270">      
  177.                 <tr>      
  178.                   <td width="528" height="75"> <table border=1 bordercolor="white" width="556" height="36">      
  179.                       <tr >       
  180.                         <td height="5" align=left width=69 class="x">├√│╞</td>      
  181.                         <td align=left width=72 class="x" height="5">╝█╕±</td>      
  182.                         <td align=left width=48 class="x" height="5">╡Ñ╬╗</td>      
  183.                         <td align=left width=30 class="x" height="5">╩▒╝Σ</td>      
  184.                         <td align=left width=197 class="x" height="5">╜╗╥╫╡╪╡π</td>      
  185.                         <td align-left width=100 class="x" height="5">└α╨═</td>      
  186.                       </tr>      
  187.                       <%      
  188.                           counts=0      
  189.                           while not rs.eof and counts<rs.PageSize      
  190.                       %>      
  191.                       <tr>       
  192.                         <td width="69" height="19"><%=left(rs("name"),5)%>╞╗╣√</td>     
  193.                         <td width="72" height="19">4.00</td>     
  194.                         <td width="48" height="19">╣½╜∩</td>     
  195.                         <td width="30" height="19"><%=left(rs("dates"),10)%>08-25</td>    
  196.                         <td width="197" height="19"><%=left(rs("lxfs"),13)%>╤⌠╣╚▒▒╜╓╩╨│í</td>    
  197.                         <td width="100" height="19"><%=rs("types")%></td>    
  198.                       </tr>    
  199.                       <%    
  200. counts=counts+1    
  201. rs.movenext    
  202. wend%>    
  203.                     </table></td>    
  204.                 </tr>    
  205.                 <tr>    
  206.                   <td width="528" height="187">   └≡╙π           
  207.                     6.60         ╣½╜∩    08-25           
  208.                     ╤⌠╣╚▒▒╜╓╩╨│í<p> <%=currentPage%>     
  209.                     ╫╧╟╤        6.60            
  210.                     ╣½╜∩    08-25           
  211.                     ╤⌠╣╚▒▒╜╓╩╨│í</p>   
  212.                     <p> ╬≈╣╧            
  213.                     6.60         ╣½╜∩       
  214.                     08-25        ╤⌠╣╚▒▒╜╓╩╨│í</p>   
  215.                     <p> ╞╧╠╤         6.60         
  216.                        ╣½╜∩    08-25            
  217.                     ╤⌠╣╚▒▒╜╓╩╨│í     </p>    
  218.                     <p> ╝ª╡░         6.60          
  219.                       ╣½╜∩    08-25       
  220.                            
  221.                     ╤⌠╣╚▒▒╜╓╩╨│í</p>    
  222.                     <p> ≡╞≡╚╡░       6.60        
  223.                         ╣½╜∩    08-25      
  224.                              
  225.                     ╤⌠╣╚▒▒╜╓╩╨│í             
  226.                                           
  227.                     <input type="hidden" name="currentPage" value="<%=currentPage%>">        
  228.                     <input type="hidden" name="cityid" value="<%=cityid%>">  </p>     
  229.                   </TD>       
  230.                 </TR>       
  231.               </table>       
  232.             </form></td>       
  233.         </tr>       
  234.       </table></td>       
  235.   </tr>       
  236. </table>       
  237. <hr width=760 size=1>       
  238.          
  239. <table width=760 border=0 align="center" cellpadding=0 cellspacing=0 >       
  240.   <tr>       
  241.       <td height=35 align=center> </td>       
  242.     </tr></table></body>       
  243. </html>       
  244.