home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
221.214.14.186
/
221.214.14.186.tar
/
221.214.14.186
/
jn
/
jinxiang
/
SCHQ
/
DATA
/
PRICE.ASP
< prev
next >
Wrap
Text File
|
2003-11-06
|
3KB
|
81 lines
<%option explicit%>
<!--#include file="include/sqldb.inc.asp"-->
<%
dim conn,sql,rs
dim currentPage,counts
dim cityid,cityids
cityid=trim(request("cityid"))
cityids=split(cityid,",")
currentPage=trim(request("currentPage"))
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 cityid<>"" then
sql=sql & " where 1=0 "
for counts=0 to ubound(cityids)
sql=sql & " or cityid=" & cityids(counts)
next
end if
sql=sql & " order by dates desc,name"
rs.PageSize=20
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
rs.AbsolutePage=cint(currentPage)
%>
<html>
<head>
<title>║╩╘≤╨╦┼⌐═°</title>
</head>
<body leftMargin=0 topMargin=0>
<form name="form_log" method="post" action="price.asp">
<table>
<tr><td>
<table border=1 bordercolor="white">
<tr >
<td align=center>├√│╞</td>
<td align=center>╝█╕±</td>
<td align=center width=40>╡Ñ╬╗</td>
<td align=center width=120>╩╨│í</td>
<td align=center>╩▒╝Σ</td>
</tr>
<%
counts=0
while not rs.eof and counts<rs.PageSize%>
<tr>
<td><%=rs("name")%></td>
<td><%=rs("price")%></td>
<td><%=rs("units")%></td>
<td><%=rs("lxfs")%></td>
<td><%=rs("dates")%></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>
</body>
</html>