📄 soft_search.asp
字号:
<!--#include file="Inc/func_soft.asp"-->
<%
'请勿改动下面这三行代码
const ChannelID=3
Const ShowRunTime="Yes"
MaxPerPage=20
PageTitle="搜索结果"
strFileName="Soft_Search.asp?Field=" & strField & "&Keyword=" & keyword & "&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="760" border="0" align="center" cellpadding="0" cellspacing="0" class="border2">
<tr>
<td colspan="3" align="left" valign="top" class="tdbg_rightall"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100" valign="middle"><img src="Images/arrow2.gif" width="6" height="7" align="absmiddle"> <font color="#CC0000">下载中心通告</font></td>
<td width="480" valign="middle"> <marquee id="scrollarea" direction="left" scrolldelay="10" scrollamount="1" width="470" height="20" onmouseover="this.stop();" onmouseout="this.start();">
<% call ShowAnnounce(2,5) %>
</marquee> </td>
<td width="180" align="center" valign="middle">
<a href="Soft_NewUpdate.asp"><font color="#009900">最近更新</font></a> <a href="Soft_NewElite.asp"><font color="#009900">推荐下载</font></a>
</td>
</tr>
</table> </td>
</tr>
<tr>
<td width="180" align="left" valign="top" class="tdbg_leftall"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="180" border="0" cellspacing="0" cellpadding="0" style="word-break:break-all">
<%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 background="Images/left14.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="title_left">
<td class="title_lefttxt"><div align="center"><strong><%=ClassName%>下载Top10</strong></div></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 background="Images/left08.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="title_left">
<td class="title_lefttxt"><div align="center"><strong>推荐下载</strong></div></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="5" valign="top"> </td>
<td width="575" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <strong> 搜索条件：</strong>
<%
if keyword="" then
response.write "所有软件"
else
select case strField
case "SoftName"
response.write "软件名称含有 <font color=red>"&keyword&"</font> 的软件"
case "SoftIntro"
response.write "软件简介含有 <font color=red>"&keyword&"</font> 的软件"
case "Author"
response.write "作者姓名含有 <font color=red>"&keyword&"</font> 的软件"
case "Editor"
response.write "编辑姓名含有 <font color=red>"&keyword&"</font> 的软件"
case else
response.write "软件名称含有 <font color=red>"&keyword&"</font> 的软件"
end select
end if
%>
</td>
</tr>
<tr>
<td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="tdbg_rightall">
<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" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#FFFFFF">
<td width="562" height="5"></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.Author,S.AuthorEmail,S.Keyword,S.UpdateTime,S.Editor,S.Hits,S.DayHits,S.WeekHits,S.MonthHits,S.SoftSize,S.OnTop,S.Elite,S.Passed,S.Stars,S.SoftLevel,S.SoftPoint,S.SoftIntro,S.OperatingSystem,S.SoftType 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 SpecialID>0 then
' sqlSoft=sqlSoft & " and S.SpecialID=" & SpecialID
'end if
if instr(arrClassID,",")>0 then
sqlSoft=sqlSoft & " and S.ClassID in (" & arrClassID & ")"
else
sqlSoft=sqlSoft & " and S.ClassID=" & Clng(arrClassID)
end if
if keyword<>"" then
select case strField
case "SoftName"
sqlSoft=sqlSoft & " and S.SoftName like '%" & keyword & "%' "
case "SoftIntro"
sqlSoft=sqlSoft & " and S.SoftIntro like '%" & keyword & "%' "
case "Author"
sqlSoft=sqlSoft & " and S.Author like '%" & keyword & "%' "
case "Editor"
sqlSoft=sqlSoft & " and S.Editor like '%" & keyword & "%' "
case else
sqlSoft=sqlSoft & " and S.SoftName like '%" & keyword & "%' "
end select
end if
sqlSoft=sqlSoft & " order by S.OnTop,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()
dim SoftNum
SoftNum=0
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>
<tr>
<td height="50" colspan="6" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC" style="WORD-BREAK: break-all">
<tr bgcolor="#FFFFFF">
<td height="50" colspan="3" valign="top">·<%=dvhtmlencode(Left(rsSoft("SoftIntro"),200))%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="269"><font color="#666666"> 运行平台：<%=rsSoft("OperatingSystem")%></font></td>
<td width="189"><font color="#666666"> 软件类别：
<%
select case rsSoft("SoftType")
case 1
response.write "国产软件"
case 2
response.write "国外软件"
case 3
response.write "汉化补丁"
case 4
response.write "程序源码"
case 5
response.write "电影下载"
case 6
response.write "FLASH动画"
case 7
response.write "其他"
end select
%>
</font></td>
<td width="105"><font color="#666666"> 本日下载：<%=rsSoft("DayHits")%></font></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="5" colspan="6"></td>
</tr>
<%
SoftNum=SoftNum+1
if SoftNum>=MaxPerPage then exit do
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>
<tr>
<td> <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="13" Class="tdbg_left2"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width='100%' border='0' align="center"cellpadding='2' cellspacing='0' class="tdbg_rightall">
<tr>
<td width="100" align="center" class='title_bg_center'><img src="Images/checksoft.gif" width="15" height="15" align="absmiddle"> 软件搜索：</td>
<td> <div align="center">
<% call ShowSearchForm("Soft_Search.asp",2) %>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" class="tdbg">
<tr>
<td height="13" align="center" valign="top"><table width="756" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="13" Class="tdbg_left2"></td>
</tr>
</table></td>
</tr>
</table>
<% call Bottom() %>
<% call PopAnnouceWindow(400,300) %>
</body>
</html>
<%
set rsSoft=nothing
set rsPic=nothing
call CloseConn()
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -