📄 adminnews.asp
字号:
<!--#include file="conn.asp"-->
<%
Dim pagesize
Dim page
Dim ipage
Dim taxis
if request("pagesize")="" then
pagesize=20
else
pagesize=request("pagesize")
end if
if request("page")="" then
page=1
else
page=request("page")
end if
if request("taxis")="" then
taxis="newsid"
else
taxis=request("taxis")
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>在线考试系统</title>
<link rel="stylesheet" type="text/css" href="../default.css">
<script language="JavaScript">
function checkall(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
function submitit()
{
if (confirm("是否删除考试新闻？")){
return true;
}
else
return false;
}
</script>
<script language="JavaScript1.2" src="../js/lock.js"></script>
</head>
<body oncontextmenu="self.event.returnValue=false" onselectstart="selectstart();" bgcolor="#FFFFFF">
<%
sql="select * from exam_news order by "& taxis&" desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
%>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#007CD0" width="100%" id="AutoNumber1" cellpadding="0">
<tr>
<td width="100%">当前位置：新闻管理 > <font color="#FF0000">管理新闻</font></td>
</tr>
</table>
<form method="POST" name="adminnews" action="adminnewsdel.asp" onsubmit="return submitit();">
<table border="1" bordercolor="#007CD0" width="100%" id="AutoNumber3" bgcolor="#007CD0" style="border-collapse: collapse" cellpadding="0" cellspacing="0" height="30">
<tr>
<td height="30" colspan="4" class="border_blue"> <input type="button" value="发布新闻" name="B4" class="s02" onclick="window.location='postnews.asp'"></td>
<td height="30" colspan="4" class="border_blue">
<p align="right">
<input type="checkbox" name="chkall" value="ON" onclick="checkall(this.form);">全部选择/取消选择
<input type="submit" value="删除所选项" name="B3" class="s02">
<select size="1" name="pagesize" onchange="javascript:window.location='adminnews.asp?pagesize='+this.options[this.selectedIndex].value;">
<option selected>每页显示<%=pagesize%>条记录</option>
<option value="10">每页显示10条记录</option>
<option value="20">每页显示20条记录</option>
<option value="50">每页显示50条记录</option>
<option value="100">每页显示100条记录</option>
<option value="10000">显示全部记录</option>
</select> </td>
</tr>
</table>
<hr noshade color="#FFFFFF" size="1"><% if rs.eof then %>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" class="noborder" height="20" bgcolor="#F1F1F1">
<tr>
<td width="100%" align="center" class="border">没有记录！</td>
</tr>
</table>
<% else %>
<table border="1" bordercolor="#FFFFFF" width="100%" id="AutoNumber3" bgcolor="#F1F1F1" style="border-collapse: collapse; border-style: solid; border-color: #007CD0" cellpadding="0" cellspacing="0">
<tr>
<td width="20" bgcolor="#FFCC00" height="20" class="border" bordercolor="#007CD0"> </td>
<td bgcolor="#FFCC00" align="center" class="border" bordercolor="#007CD0">
新闻标题</td>
<td bgcolor="#FFCC00" align="center" class="border" width="80" bordercolor="#007CD0">
有效</td>
<td bgcolor="#FFCC00" align="center" class="border" width="80" bordercolor="#007CD0">
通过审核</td>
<td bgcolor="#FFCC00" align="center" width="80" class="border" bordercolor="#007CD0">
发布时间</td>
<td bgcolor="#FFCC00" align="center" width="40" class="border" bordercolor="#007CD0">
编辑</td>
</tr>
<% on error resume next
rs.PageSize =pagesize
Page = CLng(Request("Page"))
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount
rs.AbsolutePage = Page
For iPage = 1 To rs.PageSize
%>
<tr onmouseover="this.className='trover'" onmouseout="this.className=''">
<td bordercolor="#007CD0" bgcolor="#C0C0C0">
<input type="checkbox" name="newsid" value="<%=rs("newsid")%>"></td>
<td bordercolor="#007CD0"><% if rs("havepass")=0 then %> <a href="previewnews.asp?newsid=<%=rs("newsid")%>"><%=left(rs("title"),24)%></a>
<% end if %> <% if rs("havepass")=1 then %> <a href="viewnews.asp?newsid=<%=rs("newsid")%>"><%=left(rs("title"),24)%></a>
<% end if %> <% if rs("havepass")=2 then %> <a href="previewnews.asp?newsid=<%=rs("newsid")%>"><%=left(rs("title"),24)%></a>
<% end if %> </td>
<td bordercolor="#007CD0" align="center"><% if rs("posttime")<date() then %>
0 <% else %> 1 <% end if %> </td>
<td bordercolor="#007CD0" align="center"><%=rs("havepass")%> </td>
<td align="center" bordercolor="#007CD0"><%=rs("posttime")%> </td>
<td align="center" bordercolor="#007CD0">
<a href="editnews.asp?newsid=<%=rs("newsid")%>">
<img border="0" src="../IMAGES/EDIT.GIF"></a></td>
</tr>
<% rs.MoveNext
If rs.EOF Then Exit For
Next
%>
</table>
</form>
<form ACTION="<%=Myself%>?&taxis=<%=taxis%>&pagesize=<%=pagesize%>" METHOD="GET">
<table width="100%" style="border-collapse: collapse" bordercolor="#007CD0" cellpadding="0" cellspacing="0" border="1" bgcolor="#F1F1F1">
<tr>
<td>
<p ALIGN="right"><%If Page <> 1 Then ' 如果不是位于第一页%>
<a href="<%=Myself%>?Page=1&taxis=<%=taxis%>&pagesize=<%=pagesize%>">第一页</a>
<a HREF="<%=Myself%>?Page=<%=(Page-1)%>&taxis=<%=taxis%>&pagesize=<%=pagesize%>">
上一页</a> <% End If
If Page <> rs.PageCount Then ' 如果不是位于最后一页
%>
<a HREF="<%=Myself%>?Page=<%=(Page+1)%>&taxis=<%=taxis%>&pagesize=<%=pagesize%>">
下一页</a>
<a HREF="<%=Myself%>?Page=<%=rs.PageCount%>&taxis=<%=taxis%>&pagesize=<%=pagesize%>">
最后一页</a> <% End If %> 输入页次:<input NAME="Page" SIZE="3" CLASS="s01"> 页次:<font COLOR="Red"><%=Page%>/<%=rs.PageCount%></font></td>
</tr>
</table>
</form>
<% end if %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -