home *** CD-ROM | disk | FTP | other *** search
/ 221.214.14.186 / 221.214.14.186.tar / 221.214.14.186 / lc / yg / schq / schq.asp < prev    next >
Text File  |  2010-01-21  |  15KB  |  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.asp"><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/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="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="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.