📄 dele_message.asp
字号:
<!--#include file="conn.asp"-->
<%if session("adminadmin")<>true then response.redirect("list.asp") end if%>
<%
'删除一批信息
doing=request.querystring("doing")
if doing="days" then
dele_days=cint(request.form("dele_days"))
str="select * from news where date()-发文日期>="&dele_days&" "
set rs=conn.execute(str)
do while not rs.eof
if rs("附件")<>" " then
Dim fs1,del_file1
del_file1=rs("附件")
del_file1=Server.MapPath(del_file1)
Set fs1=Server.CreateObject("Scripting.FileSystemObject")
if fs1.FileExists(del_file1) then
fs1.DeleteFile del_file1,True
end if
end if
rs.movenext
loop
dele_day=date()-dele_days
str="delete from news where 发文日期<=(now-"&dele_days&") "
conn.execute(str)
str1="delete from qsnews where 发文日期<=(now-"&dele_days&") "
conn.execute(str1)
end if
'删除一条信息
dele_id=request.querystring("dele_id")
if dele_id<>0 or dele_id<>"" then
str="select 附件 from news where id="&dele_id&""
set rs=conn.execute(str)
if rs("附件")<>" " then
Dim fs,del_file
del_file=rs("附件")
del_file=Server.MapPath(del_file)
Set fs=Server.CreateObject("Scripting.FileSystemObject")
if fs.FileExists(del_file) then
fs.DeleteFile del_file,True
end if
end if
str="delete from news where id="&dele_id&""
'response.write str
conn.execute(str)
str1="delete from qsnews where reid="&dele_id&""
'response.write str1
conn.execute(str1)
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除信息</title>
<!--#include file="css.css"-->
</head>
<body topmargin="1">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><!--#include file="top.asp"--></td></tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="140" valign="top" bgcolor="#98a5d0">
<table width="140" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><!--#include file="left.asp"--></td>
</tr>
</table></td>
<td width="560" valign="top" bgcolor="#98a5d0">
<table width="400" border="0" cellpadding="0" cellspacing="0" class="unnamed12">
<tr>
<td> </td>
</tr>
</table>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="unnamed12"><form action="dele_message.asp?doing=days" method="post" name="form1" class="unnamed14">
<div align="center">=============================================================================<br>
成批删除：
<select name="dele_days" id="dele_days">
<option value="0">删除所有的信息</option>
<option value="5">删除5天以前信息</option>
<option value="10">删除10天以前信息</option>
<option value="20">删除20天以前信息</option>
<option value="30" selected>删除30天以前信息</option>
</select>
<input type="submit" name="Submit" value=" 删 除 ">
<br>
=============================================================================
</div>
</form></td>
</tr>
<tr>
<td class="unnamed12"></td>
</tr>
</table>
<% anguage="vbscript"
dim conn
dim connstr
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
dim sql
dim rs
on error resume next
'打开数据库
set rs=server.createobject("adodb.recordset")
'定义每页文章显示数
const MaxPerPage=10
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
sql="select * from news order by 置顶 desc,id desc"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,3,2
if rs.eof and rs.bof then
response.write "<p align='center' valign='middle' class='unnamed18'> 没 有 任 何 文 件</p>"
else
'数据库中文章数totalput
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
'统计总页数currentpage
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
showContent
showpage totalput,MaxPerPage,"dele_message.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage totalput,MaxPerPage,"dele_message.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"dele_message.asp"
end if
end if
end if
sub showContent
'选择显示数据库内容
%>
<table width="552" border="0" align="center" cellpadding="0" cellspacing="1">
<tr class="unnamed14" bgcolor="#FF9966">
<td width="333" height="30"> <div align="center">主 题</div></td>
<td width="53" height="20"> <div align="center">发送者</div></td>
<td width="74" height="20">
<div align="center"></div> <div align="center">发送时间</div></td>
<td width="49" align="center">置顶</td>
<td width="37" height="20"> <div align="center">删除</div></td>
</tr>
<% dim j
j=0
do while not rs.eof
%>
<tr class="unnamed12" bgcolor="<%if j mod 2=0 then %>#ffcc99<%else%>#ffffff<%end if%>" >
<td height="30"><a href=qtdisp.asp?disp_id=<%=rs("id")%> target="_blank"><%=left(rs("标题"),20)%> </a> <%if rs("附件")<>" " then%> <img src="images/fujian.gif" align="absbottom"> <%end if%></td>
<td height="20"><div align="center"><%=rs("发文者")%></div></td>
<td height="20"><div align="center"><%=rs("发文日期")%> <%=rs("发文时间")%></div></td>
<td align="center">
<%if rs("置顶")<>1 then%>
<a href="zhiding.asp?zhiding_id=<%=rs("id")%>&doing=yes">置顶</a>
<%else%>
<a href="zhiding.asp?zhiding_id=<%=rs("id")%>&doing=no">消顶</a>
<%end if%>
</td>
<td height="20"><div align="center"><a href="dele_message.asp?dele_id=<%=rs("id")%>&pageno=<%=pageno%>" class="unnamed14wu"><img src="images/delete.gif" width="11" height="14" border="0"></a></div></td>
</tr>
<%
'当显示记录大于maxperpage时结束这页
i=i+1
j=j+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
<%
end sub
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 "<form method=Post action="&filename&">"
response.write "<p align='center' > <font color='#000080' class='unnamed12'>>>分页</font> "
'显示页数链接的条件
if CurrentPage<2 then
response.write "<font color='#000080' class='unnamed12'>首页 上一页</font> "
else
response.write "<a href="&filename&"?page=1& class='unnamed12'>首页</a> "
response.write "<a href="&filename&"?page="&CurrentPage-1&" class='unnamed12'>上一页</a> "
end if
if n-currentpage<1 then
response.write "<font color='#000080' class='unnamed12'>下一页 尾页</font>"
else
response.write "<a href="&filename&"?page="&(CurrentPage+1)
response.write "><font color='#000080' class='unnamed12'>下一页</font></a> <a href="&filename&"?page="&n&"><font color='#000080' class='unnamed12'>尾页</font></a>"
end if
response.write "<font color='#000080' class='unnamed12'> 页次：</font><strong><font color=red class='unnamed12'>"&CurrentPage&"</font><font color='#000080'class='unnamed12'>/"&n&"</strong>页</font>"
response.write "<font color='#000080' class='unnamed12'> 共<b>"&totalnumber&"</b>篇文章 <b>"&maxperpage&"</b>篇文章/页</font>"
response.write " <font color='#000080' class='unnamed12'>转到：</font><input type='text' name='page' size=4 maxlength=10 class='unnamed12't value="&tpage&">"
response.write "<input class='unnamed12' type='submit' value=' Goto ' name='cndok'></p></form>"
end function
rs.close
set rs=nothing
conn.close
set conn=nothing
%></td>
</tr>
</table>
</td>
</tr>
</table>
<%conn.close%>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><!--#include file="bottom.asp"--></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -