home *** CD-ROM | disk | FTP | other *** search
/ 221.214.14.186 / 221.214.14.186.tar / 221.214.14.186 / dz / qh / schq / schq.asp next >
Text File  |  2010-01-21  |  11KB  |  218 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=/03/><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/qihe.jpg WIDTH=100 HEIGHT=75></TD>
  25.     <TD WIDTH=620 height="57" valign="top"><img src=../qihe.jpg width=673 height=78></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> | <a href="#"><font color="#FF0000"><strong>╩╨│í╨╨╟Θ</strong></font></a> 
  31.       | <a href="http://www.sdxnw.gov.cn/syjs.asp"><font color="#000000">┼⌐╥╡┐╞╝╝</font></a> 
  32.       | <a href="../tese.htm"><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.             <%sub querytable(inputquery)
  79.                        set conn1=server.createobject("ADODB.connection")
  80.                        conn1.open("Provider=SQLOLEDB.1;Server=80.0.0.17;Database=sdxnw;UID=read;pwd=DSread17@8408;")
  81.                        set rstemp1=conn1.execute(inputquery)
  82.                          %>
  83.             <table border=0>
  84.               <%do while not rstemp1.eof%>
  85.               <tr> 
  86.                 <% for i = 0 to 1
  87.                                thisvalue=trim(rstemp1(i))
  88.                                If isnull(thisvalue) then
  89.                                thisvalue=""
  90.                                end if
  91.                                if thisvalue="╣⌐" then
  92.                                  thisvalue="<font color=red>╣⌐</font>"
  93.                                   end if
  94.                                if thisvalue="╟≤" then
  95.                                   thisvalue="<font color=green>╟≤</font>"
  96.                                   end if
  97.                              %>
  98.                 <td valign=top width="98%" height="15" align="left"> <a href="http://localhost/show.asp?id=<%=rstemp1("id")%>"><%=thisvalue%></a></td>
  99.                 <%next%>
  100.               </tr>
  101.               <%rstemp1.movenext
  102.                             loop
  103.                           %>
  104.             </table>
  105.             <%
  106.                           rstemp1.close
  107.                           set rstemp1=nothing
  108.                           conn1.close
  109.                           set conn1=nothing
  110.                           end sub
  111.                         %>
  112.             <%call querytable("select top 9 substring(titel,1,9),typeid,id from SCXX_sale order by dates desc,id desc")
  113.                         %>
  114.           </td>
  115.         </tr>
  116.         <tr> 
  117.           <td colspan="2" align=right><a href="http://www.sdxnw.gov.cn/scxx.asp"><img src="images/more.gif" width="20" height="6" border="0">╕ⁿ╢α</a></td>
  118.         </tr>
  119.       </table></td>
  120.     <td width="619" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
  121.         <tr> 
  122.           <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>
  123.         </tr>
  124.         <tr> 
  125.           <td height="164" valign="top"> 
  126.             <%
  127.                dim conn,sql,rs
  128.                dim currentPage,counts
  129.                dim cityid,cityids
  130.                    cityid=trim(request("cityid"))
  131.                    cityids=split(cityid,",")
  132.                    currentPage=trim(request("currentPage"))
  133.                    classid=request("classid")
  134.               if currentPage="" then currentPage=1
  135.  
  136.                  set conn=server.createobject("ADODB.connection")
  137.                  set rs=server.createobject("ADODB.recordSet")
  138.  
  139.                  conn.open(constr)
  140.                  sql="select * from SCXX_price"
  141.                  
  142.                  if  classid="" then
  143.                  sql=sql & " where types2='╩▀▓╦╥░▓╦' and cityid=19"      'cityid╬¬╕≈╡╪╩╨╧╪╨┼╧ó╘▒╔╧┤½╨┼╧ó╬¿╥╗▒α║┼íú
  144.                  else
  145.                  sql=sql & " where types2=" & classid &"and cityid=19"
  146.                  for counts=0 to ubound(cityids)
  147.                  sql=sql & " or cityid=" & cityids(counts)
  148.                  next
  149.                  end if
  150.                  sql=sql & " order by dates desc"
  151.                 ' response.write(sql)
  152.                  rs.PageSize=15
  153.                  rs.CursorType=adOpenStatic
  154.                  rs.Open sql,conn
  155.                  if cint(currentPage)<1 then currentPage=1
  156.                  if cint(currentPage)>rs.pageCount then currentPage=rs.PageCount
  157.                  if rs.eof then currentPage=0
  158.                  if not rs.eof then 
  159.                  rs.AbsolutePage=cint(currentPage)
  160.                  end if
  161.             %>
  162.             <form name="form_log" method="post" action="schq.asp">
  163.               <table width="619">
  164.                 <tr>
  165.                   <td width="596"> <table border=1 bordercolor="white">
  166.                       <tr > 
  167.                         <td height="17" align=left width=70 class="x">├√│╞</td>
  168.                         <td align=left width=40 class="x">╝█╕±</td>
  169.                         <td align=left width=50 class="x">╡Ñ╬╗</td>
  170.                         <td align=left width=65 class="x">╩▒╝Σ</td>
  171.                         <td align=left width=160 class="x">╜╗╥╫╡╪╡π</td>
  172.                         <td align-left width=100 class="x">└α╨═</td>
  173.                       </tr>
  174.                       <%
  175.                           counts=0
  176.                           while not rs.eof and counts<rs.PageSize
  177.                       %>
  178.                       <tr> 
  179.                         <td><%=left(rs("name"),5)%></td>
  180.                         <td><%=rs("price")%></td>
  181.                         <td><%=rs("units")%></td>
  182.                         <td><%=left(rs("dates"),10)%></td>
  183.                         <td><%=left(rs("lxfs"),13)%></td>
  184.                         <td><%=rs("types")%></td>
  185.                       </tr>
  186.                       <%
  187. counts=counts+1
  188. rs.movenext
  189. wend%>
  190.                     </table></td>
  191.                 </tr>
  192.                 <tr>
  193.                   <td>         <%=currentPage%>/<%=rs.PageCount%> 
  194.                          ╝═┬╝╩²:<%=rs.RecordCount%>                  
  195.                                      
  196.                     <input type="hidden" name="currentPage" value="<%=currentPage%>"> 
  197.                     <input type="hidden" name="cityid" value="<%=cityid%>"> <span style="cursor:hand;" onclick="form_log.currentPage.value=1;form_log.submit();">╩╫╥│</span> 
  198.                       <span style="cursor:hand;" onclick="form_log.currentPage.value=eval(form_log.currentPage.value)-1;form_log.submit();">╔╧╥╗╥│</span> 
  199.                       <span style="cursor:hand;" onclick="form_log.currentPage.value=eval(form_log.currentPage.value)+1;form_log.submit();">╧┬╥╗╥│</span> 
  200.                       <span style="cursor:hand;" onclick="form_log.currentPage.value=<%=rs.PageCount%>;form_log.submit();">╬▓╥│</span> 
  201.                   </TD>
  202.                 </TR>
  203.               </table>
  204.             </form></td>
  205.         </tr>
  206.       </table></td>
  207.   </tr>
  208. </table>
  209. <hr width=760 size=1>
  210.   
  211. <table width=760 border=0 align="center" cellpadding=0 cellspacing=0 >
  212.   <tr>
  213.       <td height=35 align=center> Copyright @ 2003 sdxnw.gov.cn All rights reserved. 
  214.         ╔╜╢½╨╦┼⌐═° ░µ╚¿╦∙╙╨<br>
  215.         ┬│ICP▒╕030012║┼ </td>
  216.     </tr></table></body>
  217. </html>
  218.