📄 msg_l.asp
字号:
<%
'************************************************************************************************
' 文件名: msg_l.asp
' Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'
' 创建人 : 周秋舫
' 日 期 : 2002-05-13
' 修改历史 :
' ****年**月**日 ****** 修改内容:**************************************************
' 功能描述 : 消息
' 版 本 :
'************************************************************************************************
option explicit
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1
%>
<!-- #include file="../include/config.inc" -->
<!-- #include file="../include/common.inc" -->
<!-- #include file="../include/debug.inc" -->
<!-- #include file="../include/db.inc" -->
<!-- #include file="../include/date.inc" -->
<!-- #include file="../include/datahandle.inc" -->
<!-- #include file="../include/recordlist.inc" -->
<!-- #include file="../include/security.inc" -->
<!-- #include file="../include/emp.inc" -->
<!-- #include file="../common/commonpage.inc" -->
<!-- #include file="../include/message.inc" -->
<!-- #include file="msg.inc" -->
<!-- #include file="msg_l.inc" -->
<%
call CheckSecurity()
'********************************************************************************************************
' 服务器端代码
dim pFolder : pFolder = GetParam("folder")
if IsEmpty(pFolder) then pFolder = IN_BOX '' 缺省为收件箱
dim pFreePage : pFreePage = GetParam("freepage")
'' 如果是提交，则进行删除操作
if UCase(Request.ServerVariables("REQUEST_METHOD") = "POST") then
dim choose, sFormAction
choose = GetParam("choose")
sFormAction = GetParam("FormAction")
select case sFormAction
case "delete"
call DeleteMsg(choose)
case "perdelete"
call PerDeleteMsg(choose)
case "restore"
call RestoreMsg(choose)
end select
end if
'-------------------------------------------------------------------------------------------------------------------------------------------------
' 分页相关的变量定义
'-------------------------------------------------------------------------------------------------------------------------------------------------
Dim sSQL, sWhere, sOrderby
Dim sFileName : sFileName = "msg_l.asp"
Dim iTotalRecords : iTotalRecords = 0 ' 分页
Dim iRecordsPerPage : iRecordsPerPage = 14
Dim iTotalPages : iTotalPages = 0
Dim iCols : iCols = 5
Dim iCurrentPage : iCurrentPage = GetParam("Page")
Dim iSort : iSort = GetParam("Sorting")
Dim iSorted : iSorted = GetParam("Sorted")
Dim sSortParams : sSortParams = ""
Dim sFormParams : sFormParams = ""
Dim sDirection : sDirection = ""
sFormParams = "folder=" & pFolder & "&freepage=" & pFreePage & "&"
''********************************************************************************************************
'' 构造分页的SQL语句
''********************************************************************************************************
sSQL = "select * from t_msg"
sWhere = " where emp_serial = " & GetEmpSerial
sOrderby = " order by send_time desc"
''********************************************************************************************************
'' 分页SQL语句构造完毕，调用PrepareListData进行分页前的准备
'' 收件箱、回收站显示发件人
'' 发件箱、草稿箱显示收件人
''-------------------------------------------------------------------------------------------------------------------------------------------------
dim arrayFields(3), sDelimiter
sDelimiter = "*"
arrayFields(0) = "status"
arrayFields(1) = "subject"
arrayFields(2) = "send_time"
select case pFolder
case IN_BOX, INBOX_BULLETIN, INBOX_MEETING, INBOX_APPROVE, INBOX_TASK
arrayFields(3) = "sender" '' 收件箱显示发件人
sWhere = sWhere & " and folder = " & pFolder
case OUT_BOX, DRAFT_BOX
arrayFields(3) = "receiver" '' 发件箱/草稿箱等显示收件人
sWhere = sWhere & " and folder = " & pFolder
case TRASH_BOX '' 回收站显示发件人
sWhere = sWhere & " and folder > 1000" '' 1000以上的为回收站内容
end select
call PrepareListData(sSQL & sWhere & sOrderby, Join(arrayFields, sDelimiter), sDelimiter)
'********************************************************************************************************
%>
<html>
<head>
<title>上海信息大楼 Shanghai Information Tower</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../common/common.css" type="text/css">
<style type="text/css">
.shadow2 {color:black;FILTER: DropShadow(color=cccccc, offX=1, offY=1, positive=1); width:100%;}
.shadow1 {color:#990000;FILTER: DropShadow(color=cccccc, offX=2, offY=2, positive=1); width:100%;}
</style>
<script language="javascript" src="msg_l.js"></script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="../images/bg/bg0.jpg">
<%
if Not IsEmpty(pFreePage) then
Response.Write "<br>" & vbLF
Response.Write OuterTableHeader
Response.Write HeaderWithMenu
Response.Write InnerTableHeader
end if
'********************************************************************************************************
' 主体从这里开始
'-------------------------------------------------------------------------------------------------------------------------------------------------
select case CStr(pFolder)
case IN_BOX
Response.Write FrameTitle("收件箱", "images/receive.gif", "#0099cc", "black")
case INBOX_MEETING
Response.Write FrameTitle("收件箱 -> 会议相关消息", "images/folder.gif", "#0099cc", "black")
case INBOX_APPROVE
Response.Write FrameTitle("收件箱 -> 审批相关消息", "images/folder.gif", "#0099cc", "black")
case INBOX_TASK
Response.Write FrameTitle("收件箱 -> 任务相关消息", "images/folder.gif", "#0099cc", "black")
case OUT_BOX
Response.Write FrameTitle("发件箱", "images/send.gif", "#0099cc", "black")
case DRAFT_BOX
Response.Write FrameTitle("草稿箱", "images/draft.gif", "#0099cc", "black")
case TRASH_BOX
Response.Write FrameTitle("回收站", "images/trash.gif", "#0099cc", "black")
end select
Response.Write TableHeader
Response.Write TableRecords(sSQL & sWhere & sOrderby, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams )
Response.Write TableTailer
Response.Write ActionLink
'-------------------------------------------------------------------------------------------------------------------------------------------------
' 主体到这里结束
'********************************************************************************************************
if Not IsEmpty(pFreePage) then
Response.Write MsgLinkTable
Response.Write InnerTableTailer
Response.Write Footer
Response.Write OuterTableTailer
end if
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -