home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
221.214.14.186
/
221.214.14.186.tar
/
221.214.14.186
/
dy
/
gr
/
schq
/
schq.asp
next >
Wrap
Text File
|
2010-01-21
|
11KB
|
218 lines
<!--#include file="data/include/sqldb.inc.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<style>
.x {color:#ffcc00;font-size:14px;font-weight:bold;}
table,input { font-size:12px; }
a { color:#0206CE;text-decoration:underline;}
a:hover{ text-decoration:underline; }
</style>
<body>
<table width=760 border=0 align="center" cellpadding=0 cellspacing=0 >
<tr bgcolor=#CCCCCC>
<td height=22 bgcolor=#666666 ALIGN=RIGHT> <FONT
color=#ffffff><img src=images/dot1.gif width=1 height=1> <A href="../"><FONT
color=#FFCC00>╩╫╥│</FONT></A> | <a href="javascript:window.external.addFavorite('http://www.sdxnw.gov.cn','╨╦┼⌐═°╩╨│í╨┼╧ó')"><font color="#ffcc00">╔Φ╬¬╩╒▓╪</font></a>|
<A href=/03/><A href="mailto:jfxnw@sdan.com.cn"><font color=#ffcc00>┴¬╧╡╬╥├╟</font></A>|</FONT></td>
</tr>
</table>
<TABLE WIDTH=760 BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD width="140" HEIGHT=66 rowspan="2" valign="top"><IMG SRC=file://///ZYX/%D7%D4%B6%AF%D5%BE%B1%B8%B7%DD/xnw/gr/schq/images/bs.gif WIDTH=142 HEIGHT=99></TD>
<TD WIDTH=620 height="57" valign="top"><img src=/banner.jpg width=660 height=50></TD>
</TR>
<TR>
<TD align="center" valign="middle"><a href="../qufu.htm"><font color="#000000">╣π╚─╕┼┐÷</font></a>
| <a href="file://///ZYX/%D7%D4%B6%AF%D5%BE%B1%B8%B7%DD/xnw/gr/news/xwkx.htm"><font color="#000000">╨╦┼⌐┐∞╤╢</font></a>
| <a href="#"><font color="#FF0000"><strong>╩╨│í╨╨╟Θ</strong></font></a> | <a href="http://www.sdxnw.gov.cn/syjs.asp"><font color="#000000">┼⌐╥╡┐╞╝╝</font></a>
| <a href="../tese.htm"><font color="#000000">╠╪╔½┼⌐╥╡</font></a> | <a href="../zsyz/zsyz.asp"><font color="#000000">╒╨╔╠╥²╫╩</font></a>
| <a href="../weather"><font color="#000000">╞°╧≤╖■╬±</font></a></TD>
</TR>
</TABLE>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="141" height="358" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr valign="middle">
<td height="19" colspan="2" background="images/line3.jpg"><font color="#FF0000"><strong>┼⌐╕▒▓·╞╖</strong></font></td>
</tr>
<tr>
<td width="69" height="18" valign="top"><a href="schq.asp?classid='╩▀▓╦╥░▓╦'">╩▀▓╦╥░▓╦</a></td>
<td width="72" align="left" valign="top"><a href="schq.asp?classid='┴╕╙═├▐┬Θ'">
┴╕╙═├▐┬Θ</a></td>
</tr>
<tr>
<td height="16" valign="top"><a href="schq.asp?classid='║ú╧╩╦«▓·'">║ú╧╩╦«▓·</a></td>
<td height="16" align="left" valign="top"><a href="schq.asp?classid='╕╔╧╩╣√╞╖'">╕╔╧╩╣√╞╖</a></td>
</tr>
<tr>
<td height="21" valign="top"><a href="schq.asp?classid='╚Γ╟▌╡░─╠'">╚Γ╟▌╡░─╠</a></td>
<td height="21" align="left" valign="top"><a href="schq.asp?classid='╩│╙├╒µ╛·'">╩│╙├╒µ╛·</a></td>
</tr>
<tr>
<td height="15" colspan="2" valign="top"><strong><font color="#FF0000">┼⌐╥╡╬∩╫╩</font></strong></td>
</tr>
<tr>
<td height="22" colspan="2" valign="top"><a href="schq.asp?classid='╗»╖╩'">╗»╖╩</a>
<a href="schq.asp?classid='┼⌐╥⌐'">┼⌐╥⌐</a> <a href="schq.asp?classid='╦╟┴╧'">╦╟┴╧</a>
<a href="schq.asp?classid='╓╓╫╙'">╓╓╫╙</a> </td>
</tr>
<tr>
<td height="16" colspan="2" valign="top"><strong><font color="#FF0000">╞Σ╦√</font></strong></td>
</tr>
<tr>
<td height="50" colspan="2" valign="top"><a href="schq.asp?classid='╗¿╗▄'">╗¿╗▄</a>
<a href="schq.asp?classid='╓╓├τ'">╓╓├τ</a> <a href="schq.asp?classid='╗·╨╡'">╗·╨╡</a>
<br> <br>
<a href="schq.asp?classid='╣ñ╥╒╓╞╞╖'">╣ñ╥╒╓╞╞╖</a> <a href="schq.asp?classid='╩▐╥⌐'">╩▐╥⌐</a><br>
</td>
</tr>
<tr>
<td height="17" colspan="2" valign="top" background="images/line3.jpg"><strong><font color="#FF0000">╣⌐╟≤╚╚╧▀</font></strong></td>
</tr>
<tr>
<td height="169" colspan="2" valign=top>
<%sub querytable(inputquery)
set conn1=server.createobject("ADODB.connection")
conn1.open("Provider=SQLOLEDB.1;Server=80.0.0.17;Database=sdxnw;UID=read;pwd=DSread17@8408;")
set rstemp1=conn1.execute(inputquery)
%>
<table border=0>
<%do while not rstemp1.eof%>
<tr>
<% for i = 0 to 1
thisvalue=trim(rstemp1(i))
If isnull(thisvalue) then
thisvalue=""
end if
if thisvalue="╣⌐" then
thisvalue="<font color=red>╣⌐</font>"
end if
if thisvalue="╟≤" then
thisvalue="<font color=green>╟≤</font>"
end if
%>
<td valign=top width="98%" height="15" align="left"> <a href="http://localhost/show.asp?id=<%=rstemp1("id")%>"><%=thisvalue%></a></td>
<%next%>
</tr>
<%rstemp1.movenext
loop
%>
</table>
<%
rstemp1.close
set rstemp1=nothing
conn1.close
set conn1=nothing
end sub
%>
<%call querytable("select top 9 substring(titel,1,9),typeid,id from SCXX_sale order by dates desc,id desc")
%>
</td>
</tr>
<tr>
<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>
</tr>
</table></td>
<td width="619" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<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>
</tr>
<tr>
<td height="164" valign="top">
<%
dim conn,sql,rs
dim currentPage,counts
dim cityid,cityids
cityid=trim(request("cityid"))
cityids=split(cityid,",")
currentPage=trim(request("currentPage"))
classid=request("classid")
if currentPage="" then currentPage=1
set conn=server.createobject("ADODB.connection")
set rs=server.createobject("ADODB.recordSet")
conn.open(constr)
sql="select * from SCXX_price"
if classid="" then
sql=sql & " where types2='╩▀▓╦╥░▓╦' and cityid=19" 'cityid╬¬╕≈╡╪╩╨╧╪╨┼╧ó╘▒╔╧┤½╨┼╧ó╬¿╥╗▒α║┼íú
else
sql=sql & " where types2=" & classid &"and cityid=19"
for counts=0 to ubound(cityids)
sql=sql & " or cityid=" & cityids(counts)
next
end if
sql=sql & " order by dates desc"
' response.write(sql)
rs.PageSize=15
rs.CursorType=adOpenStatic
rs.Open sql,conn
if cint(currentPage)<1 then currentPage=1
if cint(currentPage)>rs.pageCount then currentPage=rs.PageCount
if rs.eof then currentPage=0
if not rs.eof then
rs.AbsolutePage=cint(currentPage)
end if
%>
<form name="form_log" method="post" action="schq.asp">
<table width="619">
<tr>
<td width="596"> <table border=1 bordercolor="white">
<tr >
<td height="17" align=left width=70 class="x">├√│╞</td>
<td align=left width=40 class="x">╝█╕±</td>
<td align=left width=50 class="x">╡Ñ╬╗</td>
<td align=left width=65 class="x">╩▒╝Σ</td>
<td align=left width=160 class="x">╜╗╥╫╡╪╡π</td>
<td align-left width=100 class="x">└α╨═</td>
</tr>
<%
counts=0
while not rs.eof and counts<rs.PageSize
%>
<tr>
<td><%=left(rs("name"),5)%></td>
<td><%=rs("price")%></td>
<td><%=rs("units")%></td>
<td><%=left(rs("dates"),10)%></td>
<td><%=left(rs("lxfs"),13)%></td>
<td><%=rs("types")%></td>
</tr>
<%
counts=counts+1
rs.movenext
wend%>
</table></td>
</tr>
<tr>
<td> <%=currentPage%>/<%=rs.PageCount%>
╝═┬╝╩²:<%=rs.RecordCount%>
<input type="hidden" name="currentPage" value="<%=currentPage%>">
<input type="hidden" name="cityid" value="<%=cityid%>"> <span style="cursor:hand;" onclick="form_log.currentPage.value=1;form_log.submit();">╩╫╥│</span>
<span style="cursor:hand;" onclick="form_log.currentPage.value=eval(form_log.currentPage.value)-1;form_log.submit();">╔╧╥╗╥│</span>
<span style="cursor:hand;" onclick="form_log.currentPage.value=eval(form_log.currentPage.value)+1;form_log.submit();">╧┬╥╗╥│</span>
<span style="cursor:hand;" onclick="form_log.currentPage.value=<%=rs.PageCount%>;form_log.submit();">╬▓╥│</span>
</TD>
</TR>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table>
<hr width=760 size=1>
<table width=760 border=0 align="center" cellpadding=0 cellspacing=0 >
<tr>
<td height=35 align=center> Copyright @ 2003 sdxnw.gov.cn All rights reserved.
╔╜╢½╨╦┼⌐═° ░µ╚¿╦∙╙╨<br>
┬│ICP▒╕030012║┼ </td>
</tr></table></body>
</html>