📄 soft_newupdate.asp
字号:
<!--#include file="Inc/func_soft.asp"-->
<%
'请勿改动下面这三行代码
const ChannelID=3
Const ShowRunTime="Yes"
MaxPerPage=20
PageTitle="最近更新"
strFileName="Soft_NewUpdate.asp?ClassID=" & ClassID
Set rsSoft= Server.CreateObject("ADODB.Recordset")
Set rsPic= Server.CreateObject("ADODB.Recordset")
SkinID=0
%>
<html>
<head>
<title><%=strPageTitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="inc/Skin_CSS.asp"-->
<%call MenuJS()%>
</head>
<body <%=Body_Label%> onmousemove='HideMenu()'>
<!--#include file="Top.asp"-->
<%
dim sqlRoot,rsRoot,trs,arrClassID,TitleStr
sqlRoot="select C.ClassID,C.ClassName,C.RootID,L.LayoutFileName,L.LayoutID,C.Child,C.ParentPath From SoftClass C inner join Layout L on C.LayoutID=L.LayoutID "
if ClassID<>0 then
sqlRoot = sqlRoot & " where C.ParentID=" & ClassID & " or C.ParentPath like '%" & ParentPath & "," & ClassID & "%' "
else
sqlRoot = sqlRoot & " where 1 "
end if
sqlRoot = sqlRoot & " and C.IsElite=True and C.LinkUrl='' and C.BrowsePurview>=" & UserLevel & " order by C.OrderID"
Set rsRoot= Server.CreateObject("ADODB.Recordset")
rsRoot.open sqlRoot,conn,1,1
arrClassID=ClassID
do while not rsRoot.eof
arrClassID=arrClassID & "," & rsRoot(0)
rsRoot.movenext
loop
rsRoot.close
set rsRoot=nothing
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="border2">
<tr>
<td width="180" rowspan="2" align="left" valign="top" class="tdbg_leftall"> <table width="180" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="title_left2"></td>
</tr>
<%if Child>0 then%>
<tr>
<td background="Images/left12.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="title_left">
<td class="title_lefttxt"> <div align="center"><strong><%=ClassName%>分类</strong></div></td>
</tr>
</table></td>
</tr>
<tr>
<td class="tdbg_left"><table width="100%" height="100%" border="0" cellpadding="8">
<tr>
<td height="80" valign="top">
<%call ShowChildClass(1)%>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="title_left2"></td>
</tr>
<%end if%>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0" class="title_left">
<tr>
<td class='title_bg_center' align="center"><%=ClassName%> 下载Top10</td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top" class="tdbg_left"><table width="100%" height="100%" border="0" cellpadding="8">
<tr>
<td valign="top">
<%call ShowTop(10,200,arrClassID)%>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="title_left2"></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0" class="title_left">
<tr>
<td class='title_bg_center' align="center">推荐下载</td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top" class="tdbg_left"><table width="100%" height="100%" border="0" cellpadding="8">
<tr>
<td valign="top">
<% call ShowPicSoft(0,4,20,1,1,130,90,200,false,true) %>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="title_left2"></td>
</tr>
</table></td>
<td width="99%" valign="top">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td> 最近更新：
<%
if ClassID=0 then
response.write "所有软件"
else
response.write ClassName
end if
%>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF" class="tdbg_rightall" style="word-break:break-all">
<tr>
<td width="280" align="center">软件名称</td>
<td width="80" align="center"> 更新日期</td>
<td width="60" align="center"> 软件大小</td>
<td width="60" align="center"> 下载次数</td>
<td width="100" align="center"> 软件等级</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#cccccc">
<%
sqlSoft="select S.SoftID,S.ClassID,C.ClassName,L.LayoutFileName,S.SoftName,S.SoftVersion,S.UpdateTime,S.Hits,S.SoftSize,S.OnTop,S.Elite,S.Passed,S.Stars from Soft S"
sqlSoft=sqlSoft & " inner join (SoftClass C inner join Layout L on C.LayoutID=L.LayoutID) on S.ClassID=C.ClassID where S.Deleted=False and S.Passed=True "
if instr(arrClassID,",")>0 then
sqlSoft=sqlSoft & " and S.ClassID in (" & arrClassID & ")"
else
sqlSoft=sqlSoft & " and S.ClassID=" & Clng(arrClassID)
end if
sqlSoft=sqlSoft & " order by S.SoftID desc"
Set rsSoft= Server.CreateObject("ADODB.Recordset")
rsSoft.open sqlSoft,conn,1,1
if rsSoft.bof and rsSoft.eof then
totalput=0
response.Write "<tr><td colspan='6' height='30' bgcolor='#FFFFFF'>没有任何软件</td></tr>"
else
totalput=rsSoft.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
call SoftContent2()
else
if (currentPage-1)*MaxPerPage<totalPut then
rsSoft.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rsSoft.bookmark
call SoftContent2()
else
currentPage=1
call SoftContent2()
end if
end if
end if
rsSoft.close
set rsSoft=nothing
sub SoftContent2()
do while not rsSoft.eof
%>
<tr valign="middle" class="tdbg_leftall">
<td width="20" align="center" bgcolor="#FFFFFF">
<%
if rsSoft("OnTop")=true then
response.write "<img src='images/Soft_ontop.gif' alt='固顶软件'> "
elseif rsSoft("Elite")=true then
response.write "<img src='images/Soft_elite.gif' alt='推荐软件'> "
else
response.write "<img src='images/Soft_common.gif' alt='普通软件'> "
end if
%>
</td>
<td width="260" bgcolor="#FFFFFF">
<%response.write "<a href='Soft_Show.asp?SoftID=" & rsSoft("SoftID") & "' target='_blank'>" & rsSoft("SoftName") & " " & rsSoft("SoftVersion") & "</a>"%>
</td>
<td width="80" align="center" bgcolor="#FFFFFF"><%=FormatDateTime(rsSoft("UpdateTime"),2)%></td>
<td width="60" align="center" bgcolor="#FFFFFF"><%=rsSoft("SoftSize") & " KB"%></td>
<td width="60" align="center" bgcolor="#FFFFFF"><%=rsSoft("Hits")%></td>
<td width="100" align="center" bgcolor="#FFFFFF"> <font color="#009900"><%=string(rsSoft("Stars"),"★")%></font></td>
</tr>
<%
rsSoft.movenext
loop
end sub
%>
<tr bgcolor="#FFFFFF">
<td height="1" colspan="6">
<%
if totalput>0 then
call showpage(strFileName,totalput,MaxPerPage,false,true,"个软件")
end if
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' border='0' align="center"cellpadding='2' class="title" style="border-top:solid #999999 1px">
<tr>
<td width="100" align="center" class='title_bg_center'><img src="Images/checksoft.gif" width="15" height="15" align="absmiddle"> 软件搜索：</td>
<td align=center><% call ShowSearchForm("Soft_Search.asp",2) %></td>
</tr>
</table> </td>
</tr>
</table>
<% call Bottom() %>
</td>
</tr></table>
<% call PopAnnouceWindow(400,300) %>
</body>
</html>
<script>
mtDropDown.initialize();
</script>
<%
set rsSoft=nothing
set rsPic=nothing
call CloseConn()
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -