<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<!--#include file="inc/char.asp"-->
<!--#include file="chkadmin.asp"-->
<%
dim rs,sql,id,FileName
id=Trim(Request.QueryString("id"))
if id<>"" then
	sql="select FileName from Software where ID = "&id
	set rs=conn.execute(sql)
	FileName=rs(0)
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>软件点评 - <%=SiteSetting(0)%></title>
<STYLE>
BODY {
	    scrollbar-face-color : #96A2AD;
	    scrollbar-shadow-color : #96A2AD;
	    scrollbar-highlight-color : #96A2AD;
	    scrollbar-3dlight-color : #96A2AD;
	    scrollbar-darkshadow-color : #96A2AD;
	    scrollbar-track-color : #CCCCCC;
	    scrollbar-arrow-color : #FFFFFF;
}
</STYLE>
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="600" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#708090">
  <tr>
    <td align="center" class="TdBorderB"><font color="#FFFFFF"><%if id<>"" then response.write FileName else response.write "最新1000条评论"%></font></td>
  </tr>
<%dim n,totalrec,currentpage,rowcount,powers,onepage
if id<>"" then
sql="select * from Review where SoftID = "&id&" order by id DESC"
else
sql="select top 1000 * from Review order by id DESC"
end if

onepage=20
set rs=server.createobject("adodb.recordset") 
rs.cursorlocation = 3 
rs.pagesize = onepage
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.Write"<tr><td bgcolor=#EEEEEE><center>当前没有评论！</center></td></tr>"
else
if err.number<>0 then '错误处理
response.write "数据库操作失败：" & err.description
err.clear
else
if not (rs.eof and rs.bof) then '检测记录集是否为空
totalrec = RS.RecordCount 'totalrec：总记录条数
if rs.recordcount mod onepage = 0 then '计算总页数,recordcount:数据的总记录数
n = rs.recordcount\onepage 'n:总页数
else 
n = rs.recordcount\onepage+1 
end if 
currentpage = request("page") 'currentpage:当前页
If currentpage <> "" then
currentpage = cint(currentpage)
if currentpage < 1 then 
currentpage = 1
end if 
if err.number <> 0 then 
err.clear
currentpage = 1
end if
else
currentpage = 1
End if 
if currentpage*onepage > totalrec and not((currentpage-1)*onepage < totalrec)then 
currentPage=1
end if
rs.absolutepage = currentpage 'absolutepage：设置指针指向某页开头
rowcount = rs.pagesize
do while not rs.eof and rowcount > 0
	response.write "<tr><td bgcolor=#EEEEEE><a href='review_del.asp?id="&rs(0)&"'><font color=red>[删]</font></a>&nbsp;&nbsp;<u>"&killchar(rs(2))&"</u>&nbsp;&nbsp;发表于："&rs(4)&""
	if id="" then response.write "&nbsp;&nbsp;[<a href='review.asp?id="&rs(1)&"'>对应软件</a>]"
	response.write "</td></tr><tr><td bgcolor=#F6F6F6>"&killchar(rs(3))&"<br><br></td></tr>"
rowcount=rowcount-1
rs.movenext
loop
end if
end if
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</table>
<%call listpages()%>
</body>
</html>
<%sub listPages() 
if n <= 1 then exit sub
response.write("<table width=600 border=0 align=center cellpadding=2 cellspacing=1 bgcolor=#EEEEEE>")
response.write("<tr><td align=center bgcolor=#EEEEEE>共有"&totalrec&"条记录")
if currentpage = 1 then
response.write("<font color=darkgray>&nbsp;[首页]&nbsp;[上一页]</font>")
else
response.write("&nbsp;[<a href="&request.ServerVariables("script_name")&"?id="&id&"&Page=1>首页</a>]")
response.write("&nbsp;[<a href="&request.ServerVariables("script_name")&"?id="&id&"&Page="&currentpage-1&">上一页</a>]") 
end if
if currentpage = n then
response.write("&nbsp;<font color=darkgray>[下一页]&nbsp;[尾页]</font>") 
else
response.write("&nbsp;[<a href="&request.ServerVariables("script_name")&"?id="&id&"&Page="&currentpage+1&">下一页</a>]")
response.write("&nbsp;[<a href="&request.ServerVariables("script_name")&"?id="&id&"&Page="&n&">尾页</a>]")
end if
response.write("&nbsp;当前为第"&currentpage&"页&nbsp;共"&n&"页&nbsp;"&onepage&"条记录/页&nbsp;转到")
response.write("<select name=currentpage size=1 style=background-color:#eeeeee;color:#000000;font-size:12px onChange=javascript:window.location.href=this.options[this.selectedIndex].value>")
dim i
for i = 1 to n
response.write("<option value="&request.ServerVariables("script_name")&"?id="&id&"&Page="&i)
if cint(currentpage)=cint(i) then
response.write(" selected")
end if
response.write(">第"&i&"页</option>")
next
response.write("</select></td></tr></table>")
end sub
response.End()%>