📄 admin_softnet.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<!--#include file="admin_loginchk.asp"-->
<%admin2%>
<%if request("action")="setshow" then
set rs=server.createobject("adodb.recordset")
sql="select show from soft where softid="&request("softid")
rs.open sql,conn,1,3
if not rs.eof then
if rs("show")=true then
rs("show")=false
else
rs("show")=true
end if
rs.update
end if
rs.close
end if
%>
<%if request("action")="del" then
conn.execute("delete * from soft where softid="&request("softid")&"")
end if
%>
<%
classid=request("classid")
nclassid=request("nclassid")
title=trim(request("title"))
%>
<title>网友自助程序管理管理</title>
<!--#include file="top.asp"-->
<table border="0" width="99%" cellspacing="1" cellpadding="1" style="margin-top:6px;margin-bottom:6px" align="center">
<tr>
<td valign=top width="20%" style="border:1px solid black;" bgcolor="#999999">
<!--#include file="admin_left.asp"-->
</td>
<td align=center valign=top>
<table border="0" cellpadding="4" cellspacing="1" width="98%" align="center" bgcolor="#333333">
<tr align="center" bgcolor="#999999">
<td colspan="2">网友自助程序管理管理（<b><font color="#FFFF00">当前查看的全部是网友提供的</font></b>）</td>
</tr>
<tr align="center" bgcolor="#CCCCCC">
<td align="center" valign="top" bgcolor="#CCCCCC" width="83%"> <br>
<form name="form1" method="post" action="admin_softnet.asp?classid=<%=classid%>&nclassid=<%=nclassid%>">
<table border="0" cellpadding="4" cellspacing="1" width="99%" align="center" bgcolor="#333333">
<tr align="left" bgcolor="#999999">
<td bgcolor="#99CCFF" width="14%" align="right" >软件名：</td>
<td bgcolor="#99CCFF" width="51%" >
<input type="text" name="title" size="16">
<input type="submit" name="Submit" value="查询">
</td>
<td bgcolor="#FFCCCC" width="22%" align="center" ><a href="admin_softclass.asp">管理员添加</a></td>
<td bgcolor="#9966FF" width="13%" ><a href="admin_softnet.asp"><font color="#FFFFFF"><b>全部</b></font></a></td>
</tr>
</table>
</form>
<br>
<table border="0" cellpadding="4" cellspacing="1" width="99%" align="center" bgcolor="#333333">
<tr align="left" bgcolor="#999999">
<td height="24">
<%if title="" then%>
<%if nclassid<>"" then %>
你当前看到的程序位于<font color="#FF0000">
<%classname(classid)%>
</font>>><font color="#FF0000">
<%nclass(nclassid)%>
</font>
<%elseif classid<>"" then %>
你当前看到的程序位于<font color="#FF0000">
<%classname(classid)%>
</font>
<%else %>
你当前看到的程序是本站的<font color="#FF0000">全部程序</font>
<%end if %>
<%else %>
<%if nclassid<>"" then %>
你当前看到的程序位于<font color="#FF0000">
<%classname(classid)%>
</font>>><font color="#FF0000">
<%nclass(nclassid)%>
</font>>>你查询的关键字为<b><font color="#FF0000"><%=title%></font> </b>
<%elseif classid<>"" then %>
你当前看到的程序位于<font color="#FF0000">
<%classname(classid)%>
</font>>>你查询的关键字为<b><font color="#FF0000"><%=title%></font> </b>
<%else %>
你当前看到的程序是本站的<font color="#FF0000">全部程序</font>>>你查询的关键字为<b><font color="#FF0000"><%=title%></font> </b>
<%end if %>
<%end if %>
</td>
</tr>
<tr align="center" bgcolor="#CCCCCC">
<td align="center" valign="top">
<table width="99%" border="0" cellpadding="2">
<tr>
<td bgcolor="#CCCCCC" align="center">
<%
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
const MaxPerPage=5
who="admin"
if title="" then
if nclassid<>"" then
sql="select * from soft where nclassid="&nclassid&" and whoadd='"&who&"' order by softid desc"
elseif classid<>"" then
sql="select * from soft where classid="&classid&" and whoadd='"&who&"' order by softid desc"
else
sql="select * from soft where whoadd='"&who&"' order by softid desc"
end if
else
cxun="%"&title&"%"
if nclassid<>"" then
sql="select * from soft where nclassid="&nclassid&" and title like '"&cxun&"' and whoadd='"&who&"' order by softid desc"
elseif classid<>"" then
sql="select * from soft where classid="&classid&" and title like '"&cxun&"'and whoadd='"&who&"' order by softid desc"
else
sql="select * from soft where title like '"&cxun&"' and whoadd='"&who&"' order by softid desc"
end if
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'> 还 没 有 任 何 软 件 </p>"
else
urlname="admin_softnet.asp"
totalPut=rs.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
showpage totalput,MaxPerPage,urlname
showContent
showpage totalput,MaxPerPage,urlname
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,urlname
showContent
showpage totalput,MaxPerPage,urlname
else
currentPage=1
showpage totalput,MaxPerPage,urlname
showContent
showpage totalput,MaxPerPage,urlname
end if
end if
rs.close
end if
sub showContent
dim i
i=0
%>
<table width="100%" border="0" cellspacing="1" cellpadding="3" bgcolor="#0066FF">
<tr bgcolor="#99CCFF" align="center">
<td width="47%">软件名称</td>
<td width="8%">通过</td>
<td width="12%">大分类</td>
<td width="13%">提供用户</td>
<td width="10%">修改</td>
<td width="10%">删除</td>
</tr>
<%do while not rs.eof%>
<tr bgcolor="#CCCCCC">
<td width="47%"><%=rs("title" )%></td>
<td width="8%" align="center">
<a href="admin_softnet.asp?softid=<%=rs("softid")%>&action=setshow">
<%if rs("show")=true then%>
否
<%else %>
是
<%end if %></a>
</td>
<td width="12%" align="center">
<%classname(rs("classid"))%>
</td>
<td width="13%" align="center">
<%=rs("adder")%>
</td>
<td width="10%" align="center"><a href="admin_softmodi.asp?id=<%=rs("softid")%>&classid=<%=rs("classid")%>&sid=<%=rs("sid")%>&nclassid=<%=rs("nclassid")%>">修改</a></td>
<td width="10%" align="center"><a href="admin_softnet.asp?softid=<%=rs("softid")%>&action=del">删除</a></td>
</tr>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop%>
</table>
<BR>
<%
end sub
%>
</td>
</tr>
</table>
</td>
</tr>
<tr align="left" valign="top" bgcolor="#CCCCCC">
<td><font color="#990033">说明:</font><br>
1.你点击右边的软件栏目中的紫色的大分类后，显示的将是对应的大分类下面的软件，你可以对其进行操作。<br>
<br>
</td>
</tr>
</table>
</td>
<td align="center" valign="top" bgcolor="#CCCCCC" width="17%"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#0000FF" align="center"><b><font color="#FFFFFF">栏目</font></b></td>
</tr>
<tr>
<td>
<%set ms=server.createobject("adodb.recordset")
sql="select * from Aclass"
ms.open sql,conn,1,1
do while not ms.eof %>
<br>
<table width="90%" border="0" cellspacing="1" cellpadding="1" align="center" bgcolor="#333333">
<tr>
<td bgcolor="#CC99FF" align="center"><a href="admin_softnet.asp?classid=<%=ms("classid")%>"><%=ms("class")%></a></td>
</tr> <% set ts=server.createobject("adodb.recordset")
sql="select * from ANclass where classid="&ms("classid")
ts.open sql,conn,1,1
do while not ts.eof %><tr>
<td height="16" align="center" bgcolor="#FFCCCC"><a href="admin_softnet.asp?nclassid=<%=ts("nclassid")%>&classid=<%=ms("classid")%>"><%=ts("Nclass")%></a></td>
</tr>
<% ts.movenext
loop
ts.close
%>
</table><br>
<% ms.movenext
loop
ms.close
%>
</td>
</tr>
</table>
</td>
</tr>
<tr align="left" valign="top" bgcolor="#CCCCCC">
<td colspan="2"><font color="#990033">说明:</font> 本程序由去看去看-7k7k.com制作!!</td>
</tr>
</table>
</td>
</tr>
</table>
<!--#include file="copyright.asp"-->
<%
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
response.write "<p align='center'> "
if CurrentPage<2 then
response.write "<font color='#000080'>首页 上一页</font> "
else
response.write "<a href="&filename&"?classid="&classid&"&nclassid="&nclassid&"&title="&title&"&page=1>首页</a> "
response.write "<a href="&filename&"?classid="&classid&"&nclassid="&nclassid&"&title="&title&"&page="&CurrentPage-1&">上一页</a> "
end if
if n-currentpage<1 then
response.write "<font color='#000080'>下一页 尾页</font>"
else
response.write "<a href="&filename&"?classid="&classid&"&nclassid="&nclassid&"&title="&title&"&page="&(CurrentPage+1)&">"
response.write "下一页</a> <a href="&filename&"?classid="&classid&"&nclassid="&nclassid&"&title="&title&"&page="&n&">尾页</a>"
end if
response.write "<font color='#000080'> 页次：</font><strong><font color=red>"&CurrentPage&"</font><font color='#000080'>/"&n&"</strong>页</font> "
response.write "<font color='#000080'> 共<b>"&totalnumber&"</b>个程序 <b>"&maxperpage&"</b>个程序/页</font> "
end function
%>
<br>
<% conn.close
set conn=nothing
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -