📄 sendemailbox.asp
字号:
<%response.expires=0%>
<%
'session.abandon
'Server.ScriptTimeOut=500
function opendb(DBPath,sessionname,dbsort)
dim conn
'if not isobject(session(sessionname)) then
Set conn=Server.CreateObject("ADODB.Connection")
'if dbsort="accessdsn" then conn.Open "DSN=" & DBPath
'if dbsort="access" then conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'if dbsort="sqlserver" then conn.Open "DSN=" & DBPath & ";uid=wsw;pwd=wsw"
DBPath1=server.mappath("../db/jzud-oa.asa")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set session(sessionname)=conn
'end if
set opendb=session(sessionname)
end function
%>
<!--#include file="../asp/bgsub.asp"-->
<!--#include file="publiclist.asp"-->
<!--#include file="delemail.asp"-->
<%
oabusyname=request.cookies("oabusyname")
oabusyuserid=request.cookies("oabusyuserid")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" or oabusyuserid="" then
response.write("<script language=""javascript"">")
response.write("window.top.location.href='../default.asp';")
response.write("</script>")
response.end
end if
%>
<html>
<head>
<meta http-equiv="expires" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/css.css">
<script language="javascript1.2" src="js/openwin.js"></script>
<title></title>
</head>
<body topmargin="5" leftmargin="5">
<form method="post" name="form1" action="sendemailbox.asp">
<%
if request("delbutton")="永久删除" then
call delemail(2)
end if
sql="select * from sendemailtable where senduserid="&cstr(oabusyuserid)&" order by emaildate desc"
set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1
if rs.eof or rs.bof then
conn.close
set rs=nothing
response.write("<p align=""center""><font color=""#dd0000"">您的发件箱中没有邮件！</font></p>")
else
%>
<script language="javascript">
function lookemail(recordid)
{
win=window.open('resendemail.asp?id='+recordid,'win'+recordid,'toolbar=no,scrollbars=yes,resizable=0,menubar=no,width=550,height=500');
}
</script>
<p align="left">
共<%=cstr(rs.recordcount)%>条已发送邮件 <font color="#808080">
（单击邮件“主题”可重发或转发该邮件！）</font>
</p>
<div align="center">
<center>
<table border="1" width="90%" cellspacing="0" cellpadding="0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<tr>
<td bgcolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" align="center" width="46" height="25"><font color="#FFFFFF">选择</font></td>
<td bgcolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" align="center" width="161" height="25"><font color="#FFFFFF">收件人</font></td>
<td bgcolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" align="center" width="356" height="25"><font color="#FFFFFF">主题</font></td>
<td bgcolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" align="center" width="167" height="25"><font color="#FFFFFF">日期</font></td>
</tr>
<%
do while not rs.eof
%>
<tr bgcolor="#ffffff">
<td width="46" align="center">
<input type="checkbox" name="selectnumber" value="<%=cstr(rs("autoid"))%>">
</td>
<td width="161" align="center"><%=server.htmlencode(rs("explain"))%></td>
<td width="356" align="center"><a href="#" onclick="javscript:lookemail('<%=cstr(rs("autoid"))%>')"><font color="#336699"><%=server.htmlencode(rs("emailtitle"))%></font></a></td>
<td width="167" align="center"><%=cstr(rs("emaildate"))%></td>
</tr>
<%
rs.movenext
loop
%>
</table>
</center>
</div>
<%
end if
%>
<br>
<div align="right">
<input type="submit" name="delbutton" value="永久删除">
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -