📄 sort.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="inc/const.asp"-->
<%
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
dim keyword
dim sql
dim rs
dim updown
dim order_name
order_name=Request("Order")
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
if request("updown")<>"" then
updown="desc"
else
updown=""
end if
select case order_name
case "showname"
order_name="showname"
case "hot"
order_name="hot"
case "dateandtime"
order_name="dateandtime"
case "hits"
order_name="hits"
case "orders"
order_name="orders"
case "size"
order_name="size"
case else
order_name="dateandtime"
updown="desc"
end select
set rs=server.createobject("adodb.recordset")
dim classid,Nclassid
dim classname,Nclassname
if request("classid")="" then
' classid=""
' classname="所有软件"
classid="classid=1 and "
sql="select class from class where classid=1"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "还没有任何栏目，请到管理页面添加"
response.end
else
classname=rs("class")
end if
rs.close
else
classid="classid="&cstr(request("classid"))&" and "
sql="select class from class where classid="&cstr(request("classid"))
rs.open sql,conn,1,1
classname=rs("class")
rs.close
end if
if request("Nclassid")="" then
Nclassid=""
Nclassname="所有软件"
else
Nclassid=" Nclassid="&cstr(request("Nclassid"))&" and "
sql="select Nclass.Nclass,class.class from Nclass,class where Nclass.classid=class.classid and Nclass.Nclassid="&cstr(request("Nclassid"))
rs.open sql,conn,1,1
classname=rs("class")
Nclassname=rs("Nclass")
rs.close
end if
%>
<HTML><HEAD><TITLE>时尚软件：<%=classname%><%if Nclassid<>"" then%>：<%=Nclassname%><%end if%>-[www.51yx.com]</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" href="images/style.css">
<SCRIPT language=javascript>
function popwin2(id,path)
{ window.open("openarticle.asp?id="+id+"&ppath="+path,"");
}
</SCRIPT>
</HEAD>
<!--#include file="topMain.asp"-->
<table width="752" border="0" cellpadding="0" cellspacing="1" align="center" bgcolor="#995f14">
<tr>
<td valign="top" bgcolor="#FFD112">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#995f14" height="40">
<form method="post" name="myform" action="search.asp">
<tr>
<td bgcolor="#FFD112" valign="middle" align="center"> 搜索：
<input type="text" name="keyword" class=textfield size=10 maxlength="50" style="font-family: Arial">
<input type="submit" name="Submit22" value="搜索" style="height='21'" class="botton">
</td>
</tr>
</form>
</table>
<table border=0 cellpadding=0 width=100% align="center" bgcolor="#995f14" cellspacing=0>
<tr>
<td height="20" bgcolor="#AA7523">
<div align="center"><a class=white href='sort.asp?classid=<%=request("classid")%>'><font color="#FFFFFF"><%=classname%></font></a></div>
</td>
</tr>
<tr align=middle bgcolor="#999999">
<td bgcolor="#999999" valign="top">
<table border=0 cellpadding=0 cellspacing=0 width=100% height="100" align="center">
<tr>
<td bgcolor=#FFD112
valign=top width="191"><font style=line-height:150%>
<%
if request("classid")="" then
sql="select Nclass,Nclassid from Nclass where classid=1"
else
sql="select Nclass,Nclassid from Nclass where classid="&request("classid")
end if
rs.open sql,conn,1,1%>
</font>
<table width="100%" border="0" cellspacing="0">
<%do while not rs.eof%>
<tr>
<td align="right" height="21"><img src="images/into.gif"></td>
<td align="left" height="21">
<%if not Rs.eof then%>
<a href="sort.asp?classid=<%=request("classid")%>&Nclassid=<%=rs("Nclassid")%>"><%=Rs("Nclass")%></a>
</td>
<%rs.movenext
end if %>
</tr>
<%loop
Rs.Close
%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="20" bgcolor="#AA7523">
<p align="center"><font color=#ffffff>本类热门下载</font>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#999999">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="20" bgcolor="#FFD112" width="4%"></td>
<td width="96%" bgcolor="#FFD112" height="100" valign="top">
<%if request("Nclassid")="" then
sql="select top 10 id,showname,bb from download where download.classid="&request("classid")
sql=sql&" order by download.id desc"
else
sql="select top 10 id,showname,bb from download where download.Nclassid="&request("Nclassid")
sql=sql&" order by download.id desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write ("没有源码")
else
do while not rs.eof
response.write ("<li><A href=list.asp?id="&rs("id")&">"&rs("showname")&" "&rs("bb")&"</A></li>")
rs.movenext
loop
end if
rs.close
%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -