📄 index_msg.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--#include file = "inc/conn.asp" -->
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<style type="text/css">
<!--
body {
background-color: #B1DB99;
}
body,td,th {
font-size: 12px;
}
.STYLE1 { height:30;}
.STYLE2 {color: #FF0000;font-size: 14px}
.STYLE4 {font-size: 12px}
-->
</style>
</head>
<%
Dim rs ,strSql ,Num ,pageNum ,page ,loopNum
strSql = "SELECT * FROM Msg WHERE ManTo = '"& Session("UserName") &"' ORDER BY SentTime DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql,conn,1,1
%>
<body topmargin="5" leftmargin="5">
<%
If rs.recordcount > 0 Then
rs.pagesize = 14
Num = rs.recordcount
pageNum = rs.pagecount
page = Request.QueryString("page")
If page <> "" Then
page = Cint(page)
ElseIf page < 1 Then
page = 1
Else
page =1
End If
If page < 1 then
page =1
End If
If page*rs.pagesize >Num and Not ((page-1)*rs.pagesize <Num) Then
page = 1
End If
rs.absolutepage = page
If page <> pageNum Then
LoopNum = rs.pagesize
Else
LoopNum = Num - (page-1)*rs.pagesize
End If
%>
<table width="536" border="0" >
<form id="form1" name="form1" method="post" action="">
<tr>
<td colspan="8" background="images/liebiao.gif" bgcolor="#00CC00"><span class="STYLE1"> <span class="STYLE2"><a href="index_Msg.asp" target="_self">收件箱</a></span></span> <span class="STYLE4"><a href="index_Msg_s.asp" target="_self">发件箱</a></span></td>
</tr>
<tr>
<td colspan="8" background="images/Down_bg.gif" bgcolor="#00CC00"><div align="center">总共找到 <%=Num%> 条记录 <a href="index_Msg.asp?page=1">首页</a> <a href="index_Msg.asp?page=<%=page-1%>">上一页</a> <a href="index_Msg.asp?page=<%=page+1%>">下一页</a> <a href="index_Msg.asp?page=<%=pageNum%>">尾页</a> 页次:<%=page%>/<%=pagenum%> 共<%=pageNum%>页</div></td>
</tr>
<tr bgcolor="#009933">
<td width="28" > </td>
<td width="28" >ID</td>
<td width="200" bgcolor="#009933" >标题</td>
<td width="50">收件人</td>
<td width="50">发件人</td>
<td width="120" bgcolor="#009933">发送时间</td>
<td width="50">删除</td>
</tr>
<% For i = 1 to LoopNum %>
<tr bgcolor="#FFFFFF" onMouseOver="this.style.backgroundColor='#FFFFCC'" onMouseOut="this.style.backgroundColor='#FFFFFF'">
<td align="center"><img src="images/mail_<%If rs("IsRead").value = 0 Then %>new<%ElseIf rs("IsReplyed").value = 1 Then %>replye<%Else%>open<%End If%>.gif" width="14" height="16" /></td>
<td><%=rs("id").value%></td>
<td><a href="DetailMsg.asp?ID=<%=rs("id").value%>&Type=r"><%=rs("Title").value%></a></td>
<td><%=rs("ManTo").value%></td>
<td><%=rs("ManFrom").value%></td>
<td><%=rs("SentTime").value%></td>
<td><a href="DelMsg.asp?Type=r&ID=<%=rs("ID").value%>" onclick='return confirm("您确定要删除这封邮件吗?")'><img src="images/del.gif" alt="删除" width="20" height="20" border="0" /></a></td>
</tr>
<% rs.movenext
Next %>
<tr>
<td height="15" colspan="9" background="images/Down_bg.gif" bgcolor="#00CC00"><div align="center">总共找到 <%=Num%> 条记录 <a href="index_Msg.asp?page=1">首页</a> <a href="index_Msg.asp?page=<%=page-1%>">上一页</a> <a href="index_Msg.asp?page=<%=page+1%>">下一页</a> <a href="index_Msg.asp?page=<%=pageNum%>">尾页</a> 页次:<%=page%>/<%=pagenum%> 共<%=pageNum%>页</div></td>
</tr></form>
</table>
<%
Else
%>
<table width="540" >
<tr>
<td colspan="7" background="images/liebiao.gif" bgcolor="#00CC00"><span class="STYLE1"> <span class="STYLE2"><a href="index_Msg.asp" target="_self">收件箱</a></span></span> <span class="STYLE4"><a href="index_Msg_s.asp" target="_self">发件箱</a></span></td>
</tr>
<tr bgcolor="#009933">
<td width="73">ID</td>
<td width="110">标题</td>
<td width="46">发件人 </td>
<td width="136">发送时间</td>
</tr>
<tr>
<td colspan="4" bgcolor="#FFFFFF">没有相关记录!</td>
</tr>
<tr>
<td colspan="4"></td>
</tr>
</table>
<%
End If
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -