list_thisweekmeeting.asp

物业管理和办公自动化系统

<%
'************************************************************************************************
' 文件名: list_thisweekmeeting.asp
' Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'
' 　创建人 : 蔡晓燕
' 　日　期 : 2002-07-17
' 修改历史 :
'   ****年**月**日 ****** 修改内容:**************************************************
' 功能描述 : 列出一段时间内的会议列表
' 　版　本 :
'************************************************************************************************
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/emp.inc" -->
<!-- #include file="../include/date.inc" -->
<!-- #include file="../include/datahandle.inc" -->
<!-- #include file="../include/recordlist.inc" -->
<!-- #include file="../include/security.inc" -->
<!-- #include file="../common/commonpage.inc" -->
<!-- #include file="list_thisweekmeeting.inc" -->
<!-- #include file="tablelink.inc" -->

<%
call CheckSecurity()

'********************************************************************************************************
' 服务器端代码

'-------------------------------------------------------------------------------------------------------------------------------------------------
' 分页相关的变量定义
'-------------------------------------------------------------------------------------------------------------------------------------------------
Dim sSQL, sWhere, sOrderby
Dim sFileName			: sFileName = "list_thisweekmeeting.asp"
Dim sEmpId				: sEmpId = GetEmpSerial
Dim iTotalRecords		: iTotalRecords = 0			' 分页
Dim iRecordsPerPage	: iRecordsPerPage = 15
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 = ""

'-------------------------------------------------------------------------------------------------------------------------------------------------
' 查询参数，开始时间，结束时间
'-------------------------------------------------------------------------------------------------------------------------------------------------
Dim pDay1  : pDay1 = GetParam("day1")
Dim pDay2  : pDay2 = GetParam("day2")
Dim pToday : pToday = DatePart("w",date)
response.write pToday
select case pToday 
case 1
	response.write "Today is Sunday"
	pDay1 = dateadd("d", -6, date)
case 2
	response.write "Today is Monday"
	pDay1 = date
case 3
	response.write "Today is Tuesday"
	pDay1 = dateadd("d", -1, date)
case 4
	response.write "Today is Wednesday"
	pDay1 = dateadd("d", -2, date)
case 5
	response.write "Today is Thursday"
	pDay1 = dateadd("d", -3, date)
case 6
	response.write "Today is Friday"
	pDay1 = dateadd("d", -4, date)
case 7
	response.write "Today is Saturday"
	pDay1 = dateadd("d", -5, date)
end select
pDay2 = dateadd("d", 6, pDay1)
response.write "<br>firstday is :"&pDay1&"<br>lastday is :"&pDay2
'response.end

if IsEmpty(pDay1) then pDay1 = date
if IsEmpty(pDay2) then pDay2 = date

sFormParams = "day1=" & pDay1 & "&day2=" & pDay2  & "&"
'********************************************************************************************************
' 构造分页的SQL语句
'********************************************************************************************************
sSQL = "select * from T_MeetingPrepare "
sWhere = " where start_time >='" & pDay1 & "' and start_time <'" & DateAdd("d", 1, pDay2) & "'"
sOrderby = " order by apply_time"
'********************************************************************************************************
' 分页SQL语句构造完毕，调用PrepareListData进行分页前的准备
'-------------------------------------------------------------------------------------------------------------------------------------------------
dim arrayFields(3), sDelimiter
sDelimiter = "*"
arrayFields(0) = "start_time"
arrayFields(1) = "meeting_room"
arrayFields(2) = "meeting_name"
arrayFields(3) = "meeting_status"
'arrayFields(4) = "proposer"
call PrepareListData(sSQL & sWhere & sOrderBy, Join(arrayFields, sDelimiter), sDelimiter)

'********************************************************************************************************
%>

<html>
<head>
<title>会议管理——会议安排表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../common/common.css" type="text/css">
<!-- 日历 -->
<IFRAME style="display:none;position:absolute;width:148;height:194;z-index=100" ID="CalFrame" MarginHeight=0 MarginWidth=0 noresize frameborder=0 scrolling=no src="../common/cal/calendar.htm"></IFRAME>
<script language="javascript" src="../common/cal/calendar.js"></script>
<script for=document event="onclick()">
<!--
document.all.CalFrame.style.display="none";
//-->
</script>
<!-- 日历 -->
<script language="VBScript">
Sub btnSearch_OnClick()
	document.all.frmSearchMeeting.submit()
End Sub
</script>
</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="../images/bg/bg0.jpg">
<br>

<%
Response.Write OuterTableHeader
Response.Write HeaderWithMenu
Response.Write InnerTableHeader
'********************************************************************************************************
' 主体从这里开始
'-------------------------------------------------------------------------------------------------------------------------------------------------
Response.Write TableSearch
Response.Write TableHeader
Response.Write TableRecords(sSQL & sWhere & sOrderby, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams )
Response.Write TableLink3
'-------------------------------------------------------------------------------------------------------------------------------------------------
' 主体到这里结束
'********************************************************************************************************
Response.Write InnerTableTailer
Response.Write Footer
Response.Write OuterTableTailer
%>

</body>
</html>