📄 record.asp
字号:
<%
'=========================================================
' 『动感在线』版权所有(C) Donggan.Net
' 您可以自由应用本程序于合法的个人或商业行为。
' 您必须保留版权信息。
'=========================================================
' Version:1.3
' Date: 2003-01-10
' Script Written by xubin
'=========================================================
' Copyright (C) 1999-2002 Donggan.Net. All rights reserved.
' Web: http://www.Donggan.net
' Email: webmaster@Donggan.net,webmaster@mail.Donggan.net
'=========================================================
%>
<!--#Include File="conn.asp" -->
<!--#Include File="procedure.asp" -->
<!--#Include File="Language.asp" -->
<%
'Call loaderror()
Call showwebdata()
Call Language_var(Language,"record")
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charSet=<%=Language_charSet%>">
<link rel="stylesheet" href="images/styles.css" type="text/css">
<title><%=webname%>|</title>
<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 check()
{
if (isNaN(go2to.page.value))
alert("<%=Language_viewuser(19)%>");
else if (go2to.page.value=="")
{
alert("<%=Language_viewuser(20)%>");
}
else
go2to.submit();
}
//-->
</SCRIPT>
</head>
<body leftmargin="0" Topmargin="0" marginwidth="0" marginheight="0" background="images/greystrip.gIf" text="#336699">
<!--#Include File="head.asp" -->
<center>
<br>
<Form name="searchuser" method="post" action="record.asp">
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#000000" width="513" height="28" bordercolor="#000000" background="images/greystrip.gIf">
<tr>
<td width="499" height="1" bgcolor="#7C96B8">
<div align="center"><font color="#FFFFFF"><%=Language_record(0)%>
<input type="text" name="key" maxlength="50" class="bk" style="border:1px #7C96B8 solid; color:#336699"><input type="Submit" name="Submit1" value="<%=Language_record(1)%>" class="Tips_bo"></font></div>
</td>
</tr>
</table>
</Form>
<%
If Request.Form("delmail")<>"" Then
'如果选择了删除,则删除记录,显示
Call delmail()
Call main()
Else
Call main()
End If
%>
<%
'删除历史记录
Sub delmail()
delid=replace(Request.Form("id"),"'","")
conn.Execute("delete * from record where id in ("&delid&")")
End Sub
'显示历史记录
Sub main()
Set rs=Server.Createobject("adodb.recordset")
If Request("page")<>"" Then
pagecount=cint(Request("page"))
Else
pagecount=1
End If
If key="" Then
sql="select * from record order by id desc"
Else
sql="select * from record where MailSubject like '%"&key&"%' or order by id desc"
End If
rs.open sql,conn,1,1
If rs.eof AND rs.bof Then
Response.Write"<BR>=== "&Language_record(3)&" ===<BR><BR>"
Response.End
End If
rs.pagesize=20
If pagecount>rs.pagecount or pagecount<=0 Then
pagecount=1
End If
rs.AbsolutePage=pagecount %>
<table border="0" cellpadding="0" cellspacing="0" width="580" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" class=ver height="25">
<tr>
<% If rs.pagecount=1 Then %>
<td height="2" colspan="4" class="ver" width="684"> <font class=ver><%=Language_record(2)%>[<font color="#ff0000"><%=rs.recordcount%></font>]
<%=Language_record(4)%>[<font color="red">1～<%=rs.recordcount%></font>]</font></td>
</tr>
<tr>
<td height="14" colspan="4" width="684" ></td>
</tr>
<%Else%>
<tr>
<td height="9" colspan="4" width="684" ><font class=ver> <%
page_start=(pagecount-1)*rs.pagesize
If pagecount=1 Then page_start=1
page_End=rs.pagesize*pagecount
If pagecount*rs.pagesize=>rs.recordcount Then page_End=rs.recordcount End If%>
<%=Language_record(2)%>[<font color="#ff0000"><%=rs.recordcount%></font>] <%=Language_record(4)%>[<font color="red"><%=page_start%>～<%=page_End%></font>]</font></td>
</tr>
<tr>
<td height="1" colspan="4" width="684" > <% Response.Write"<Form name=go2To Form method=Post action='?key="+key+"'>"
If pagecount=1 Then
Response.Write "<font class=ver>"&Language_record(5) & Language_record(6)&"</font> "
Else
Response.Write "<a href=record.asp?page=1&key="+key+"><font color=#336699>"&Language_record(5)&"</font></a> "
Response.Write "<a href=record.asp?page="+cstr(pagecount-1)+"&key="+key+"><font color=#336699>"&Language_record(6)&"</font></a> "
End If
If rs.PageCount-pagecount<1 Then
Response.Write "<font class=ver>"&Language_record(7)&Language_record(8)&"</font>"
Else
Response.Write "<a href=record.asp?page="+cstr(pagecount+1)+"&key="+key+"><font color=#336699>"&Language_record(7)&"</font></a> "
Response.Write "<a href=record.asp?page="+cstr(rs.PageCount)+"&key="+key+"><font color=#336699>"&Language_record(8)&"</font></a>"
End If
Response.Write "<font class=ver> "&Language_record(12)&":<font class=ver>"&pagecount&"</font>/"&rs.pagecount&Language_record(10)&"</font>"
Response.Write "<font class=ver> "&Language_record(9)&"<input type='text' name='page' size=2 maxLength=3 style='font-size: 9pt; color:#00006A; position: relative; height: 18' value="&PageCount&">"&Language_record(10)&"</font> "
Response.Write "<input class=butTon1 type='butTon' value='"&Language_record(11)&"' onclick=check() class='Tips_bo' style='border:1px #7C96B8 solid ; font-family: 宋体; font-size: 9pt; position: relative; height: 19'>" %>
</td>
</tr>
<%End If%>
</table>
<Form action="?page=<%=currentpage%>" method=post name=inbox>
<table border="1" width="581" bordercolor="#7C96B8" cellspacing="0" bordercolordark="#FFFFFF" height="9" cellpadding="0">
<tr>
<td width="269" background="images/mmTo.gIf" height="20" align="center" bgcolor="#7C96B8"><DIV style="FILTER: dropshadow(color=#FFFFFF, offx=1, offy=1, positive=1); WIDTH: 100%; CURSOR: hAND; POSITION: relative"><font color="#336699"><%=Language_record(13)%></font></div></td>
<td width="137" background="images/mmTo.gIf" height="20" align="center" bgcolor="#7C96B8"><DIV style="FILTER: dropshadow(color=#FFFFFF, offx=1, offy=1, positive=1); WIDTH: 100%; CURSOR: hAND; POSITION: relative"><font color="#336699"><%=Language_record(14)%></font></div></td>
<td width="103" background="images/mmTo.gIf" height="20" align="center" bgcolor="#7C96B8"><DIV style="FILTER: dropshadow(color=#FFFFFF, offx=1, offy=1, positive=1); WIDTH: 100%; CURSOR: hAND; POSITION: relative"><font color="#336699"><%=Language_record(15)%></font></div></td>
<td width="62" background="images/mmTo.gIf" height="20" align="center" bgcolor="#7C96B8" colspan="2"><DIV style="FILTER: dropshadow(color=#FFFFFF, offx=1, offy=1, positive=1); WIDTH: 100%; CURSOR: hAND; POSITION: relative"><p align="center"><font color="#336699"><%=Language_record(16)%></font></div>
</td>
</tr>
<% Do While NOT rs.eof %>
<tr>
<td height="21" width="269"> <a href=showrecord.asp?id=<%=rs("id")%> target="_blank"><%=rs("MailSubject")%></a></td>
<td height="21" width="137"> <%=rs("SEndTime")%></td>
<td height="21" width="103"> <%=rs("MailCount")%></td>
<td height="21" width="32"><p align="center"><input type=checkbox name=id value=<%=rs("id")%>></p>
</td>
</tr>
<% i=i+1
rs.movenext
If i>=rs.PageSize Then Exit Do
Loop
%>
<tr>
<td width="577" colspan="5" height="19">
<p align="right"> <input type=checkbox name=chkall value=on onclick="CheckAll(this.form)"><%=Language_record(18)%> <input type=submit name=delmail class="Tips_bo" onclick="{if(confirm('<%=Language_record(19)%>')){this.document.inbox.submit();return true;}return false;}" value="<%=Language_record(20)%>">
</td>
</tr>
</table></Form>
<% rs.close
End Sub
'关闭销毁对象
Set rs=nothing
conn.close
Set conn=nothing
%>
</center>
<p> </p>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -