📄 checkmeeting_bak.inc
字号:
<%
' ==================================================================
' 函数名称：GetInvisibleChar(strData)
' 函数功能：显示原字符串，包括其中的不可见字符：空格和回车
' 输入参数：字符串：strData
' 返回值： 字符串：GetInvisibleChar
' ==================================================================
function GetInvisibleChar(strData)
Dim strGetSpace
Dim strGetAll
if Isnull(strData) then
response.write "strData为null!"
response.end
else
strGetSpace = unescape(Replace(escape(strData),"%20"," "))
strGetAll = unescape(Replace(escape(strGetSpace),"%0D%0A","<br>"))
end if
GetInvisibleChar = strGetAll
end function
' =====================================================================
' 函数 GetInvisibleChar(strData)结束
' =====================================================================
Function CommentHeader()
Response.Write TableTitle("领导审批意见", 600, "", "#0040a0")
CommentHeader = _
"<table cellspacing=0 cellpadding=0 width=600 align=center class=tablelist>" & _
"<tr>" & _
"<td class=tdHead width=150> 流程步骤</td>" & _
"<td class=tdHead width=100> 审批人</td>" & _
"<td class=tdHead width=250> 审批意见</td>" & _
"</tr>"
End Function
'************************************************************************************************
' 函数名 : FormMeetingComment(iMeetingSerial)
' 输 入 : iMeetingSerial:会议序列号
' 输 出 : 一次会议的审批意见表单
' 功能描述: 根据会议序列号，填写相应的会议审批意见
' 调用模块: checkmeeting.inc
' 作 者 : 蔡晓燕
' 日 期 : 2002-07-15
' 版 本 :
'************************************************************************************************
Function FormMeetingComment(iMeetingSerial)
dim sTemp, sTempButtons, iStepno, sOpinion, sAccountname
dim crs, rs, sSQL, sComment, iIsconfirmed, iApprove_flow, crs2
sSQL = "select * from T_MeetingPrepare where meeting_serial = "& iMeetingSerial
set crs = New CRecordset
set rs = crs.open(dbLocal,sSQL)
if not rs.eof then
' response.write "here"
' response.end
sComment = crs.GetValue("comment")
iIsconfirmed = crs.GetValue("isconfirmed")
iApprove_flow = crs.GetValue("approve_flow")
sTempButtons=_
" <img border=0 src=""../images/button/pass.gif"" style=""cursor:hand"" name=btnOk>" & _
" <img border=0 src=""../images/button/back.gif"" style=""cursor:hand"" name=btnCancel>"
if iIsconfirmed = 0 then sTempButtons = sTempButtons & _
" <img border=0 src=""../images/button/goon.gif"" style=""cursor:hand"" name=btnGoon>"
crs.close()
' 如果已经经过领导审批流程，那么首先显示领导审批意见
if iIsconfirmed = 1 then
sSQL="select a.step_no,account_name,opinion from t_flow_opinion a,t_flow_step b,v_user_account c"
sSQL=sSQL & " where a.flow_id=b.flow_id and a.step_no=b.step_no and b.step_op_person=c.account_id"
sSQL=sSQL & " and a.flow_id=" & iApprove_flow
set crs2 = New CRecordset
Set rs = crs2.open(dbLocal, sSQL)
FormMeetingComment = CommentHeader()
while not rs.eof
iStepno = crs2.GetValue("step_no")
sOpinion = crs2.GetValue("opinion")
sAccountname = crs2.GetValue("account_name")
FormMeetingComment = FormMeetingComment & "<tr>" & _
"<td class=tdlist width=150 align=left> " & iStepno & " </td>" & _
"<td class=tdlist width=200 align=left> " & ToHTML(sAccountname) & " </td>" & _
"<td class=tdlist width=250 align=left> " & ToHtml(sOpinion) & " </td>" & _
"</tr>"
rs.movenext
wend
crs2.close()
end if
else
response.write "<script language=""javascript"">alert('对不起，不存在该会议或者该会议申请已经处理过了！')</script>"
response.write "<script language = vbscript>window.navigate(""list_checkmeeting.asp"")</script>"
end if
FormMeetingComment = FormMeetingComment & _
TableTitle("审批意见", 600, "", "#0040a0") & _
"<table cellspacing=0 cellpadding=0 width=600 align=center border=0 class=tablelist>" & _
"<form name=""frmcheckmeeting"" method=post action=""checkmeeting.asp"">" & _
"<tr height=30>" & _
" <td class=tdlist width=600 align=center colspan=4><textarea class=""FlatCtrl"" name=""comment"" rows=10 cols=96>"&sComment&"</textarea></td>"&_
"</tr>" & _
"<tr height=50>" & _
" <td class=tdlist colspan=4 align=center>" & sTempButtons & _
" </td>" & _
"</tr>" & _
"<tr height=30>" & _
" <input type=hidden name=meetingserial value="""&iMeetingSerial&""">" & _
" <input type=hidden name=formaction >" & _
" <input type=hidden name=rt >" & _
" <input type=hidden name=rm >" & _
"</tr>" & _
"</form>" & _
"</table>"
End Function
'************************************************************************************************
' 函数名 : FormMeetingDetail(iMeetingSerial)
' 输 入 : iMeetingSerial:会议序列号
' 输 出 : 一次会议的详细信息表
' 功能描述: 根据会议序列号，给出相应的会议详细信息
' 调用模块: checkmeeting.inc
' 作 者 : 蔡晓燕
' 日 期 : 2002-07-11
' 版 本 :
'************************************************************************************************
Function FormMeetingDetail(iMeetingSerial)
'------------------------------------
' 根据会议的MeetingSerial,显示相应的会议详细信息，
'------------------------------------
dim sSQL, iExecuter, sMeetingName, sSubject, sTask, iDepartment, sMeetingRoom, sPresider, dStart_time, dApply_time
dim dStop_time, fBudget, sAttendee, sGuest, iProposer, rt, rm, sError
dim sTemp, sTempButtons
dim crs, rs
sSQL = "select * from T_MeetingPrepare where meeting_serial = "& iMeetingSerial
set crs = New CRecordset
set rs = crs.open(dbLocal,sSQL)
if not rs.eof then
sMeetingName = crs.GetValue("meeting_name")
sSubject = crs.GetValue("subject")
sTask = crs.GetValue("task")
sMeetingRoom = crs.GetValue("meeting_room")
sPresider = crs.GetValue("presider")
fBudget = crs.GetValue("budget")
dStart_time = crs.GetValue("start_time")
dStop_time = crs.GetValue("stop_time")
sGuest = crs.GetValue("guest")
iDepartment = crs.GetValue("department")
sAttendee = crs.GetValue("attendee")
sTempButtons=_
" <img border=0 src=""../images/button/submit.gif"" style=""cursor:hand"" name=btnSubmit>" & _
" <img border=0 src=""../images/button/reset.gif"" style=""cursor:hand"" name=btnReset>"
else
sMeetingName = ""
sSubject = ""
sTask = ""
sMeetingRoom = ""
sPresider = ""
fBudget = 0
dStart_time = left(now(),len(now())-3)
dStop_time = left(now(),len(now())-3)
sGuest = ""
iDepartment = 0
sAttendee = ""
sTempButtons=_
" <img border=0 src=""../images/button/submit.gif"" style=""cursor:hand"" name=btnSubmit>" & _
" <img border=0 src=""../images/button/clear.gif"" style=""cursor:hand"" name=btnCancel>"
end if
FormMeetingDetail=_
TableTitle("会议申请表", 600, "", "#0040a0") & _
"<table cellspacing=0 cellpadding=0 width=600 align=center border=0 class=tablelist>" & _
"<form name=""frmApplymeeting"" method=post action=""applymeeting.asp"">" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>会议主题：</td>"&_
" <td class=tdlist width=485 colspan=4>" & " " & sSubject & "</td>" & _
"</tr>" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>会议名称：</td>" & _
" <td class=tdlist width=485 colspan=4>" & " " & sMeetingName & "</td>"&_
"</tr>" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>会议内容：</td>" & _
" <td class=tdlist width=485 colspan=4>" & " " & GetInvisibleChar(sTask) & "</td>"&_
"</tr>" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>召开部门：</td>" & _
" <td class=tdlist width=170>" & " " & TransDepartment(dbLocal, iDepartment) & "</td>" & _
" <td class=tdlist width=80 align=right>召开地点：</td>" & _
" <td class=tdlist width=235>"& " " & sMeetingRoom & "</td>" & _
" </td>" & _
"</tr>" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>主持人：</td>" & _
" <td class=tdlist width=170>" & " " & sPresider & "</td>"& _
" <td class=tdlist width=80 align=right>费用预算：</td>" & _
" <td class=tdlist width=235>" & " " & fBudget & "</td>"& _
"</tr>" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>开始时间：</td>" & _
" <td class=tdlist width=170>"& " " & dStart_time &"</td>"& _
" <td class=tdlist width=80 align=right>结束时间：</td>" & _
" <td class=tdlist width=235>"& " " & dStop_time &"</td>"& _
"</tr>" & _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>公司内部 <br>参会人员：</td>" & _
" <td class=tdlist width=485 colspan=3>" & " " & TransEmpSerial(dbLocal,sAttendee) & "</td>"& _
"<tr height=30>" & _
" <td class=tdlist width=115 align=right>公司外部 <br>参会人员：</td>"&_
" <td class=tdlist width=485 colspan=3>" & " " & sGuest & "</td>"& _
"<tr height=30>" & _
" <input type=hidden name=meetingserial value="""&iMeetingSerial&""">" & _
"</tr>" & _
"</form>" & _
"</table>"
End Function
'************************************************************************************************
' 函数名 : TableLink()
' 输 入 :
' 输 出 :
' 功能描述: 会议申请表页面上到其他页面的连接
' 调用模块: applymeeting.asp
' 作 者 : 蔡晓燕
' 日 期 : 2002-07-11
' 版 本 :
'************************************************************************************************
Function TableLink()
TableLink = _
"<table width=600 cellspacing=0 cellpadding=0 border=0 align=center>" & _
"<tr height=30>" & _
" <td width=600><img src=""../images/bg/line.gif"" width=600 height=3></td>" & _
"</tr>" & _
"<tr height=30>" & _
" <td width=600> " & _
" <img src=""../images/goto.gif"" width=11 height=11> <a href=""applymeeting.asp"">填写会议申请</a>" & _
" " & _
" <img src=""../images/goto.gif"" width=11 height=11> <a href=""list_checkmeeting.asp"">审批会议申请</a>" & _
" " & _
" <img src=""../images/goto.gif"" width=11 height=11> <a href=""list_reapplymeeting.asp"">修改会议申请表</a></td>" & _
"</tr>" & _
"</table>"
End Function
'************************************************************************************************
' 函数名 : UpdateMeeting()
' 输 入 :
' 输 出 :
' 功能描述: 新增或者更新会议的数据处理，根据meetingserial的值，采取不同的操作:
' iMeetingserial=0：新的会议申请
' iMeetingserial<>0 :重新会议申请
' 调用模块: applymeeting.asp
' 作 者 : 蔡晓燕
' 日 期 : 2002-07-11
' 版 本 :
'************************************************************************************************
Sub UpdateMeeting()
' 定义变量
dim sSQL, iExecuter, sFormaction, sComment, iMeetingserial, sMeetingname, sTask, dStarttime, dStoptime, sAttendee
dim rt, rm, sError, iProposer, sSQL1
dim crs, rs
' 获取表单的数据
iExecuter = Getofficer
sFormaction = GetParam("formaction")
sComment= GetParam("comment")
iMeetingserial = GetParam("meetingserial")
'response.write "iMeetingSerial="&iMeetingSerial
'response.end
sSQL = "SELECT * FROM T_MeetingPrepare where meeting_serial = "& iMeetingserial & "and meeting_status = 2 "
set crs = New CRecordset
set rs = crs.open(dbLocal,sSQL)
if not rs.eof then
'存在该会议，作审批处理
sMeetingname = crs.GetValue("meeting_name")
sTask = crs.GetValue("task")
dStarttime = crs.GetValue("start_time")
dStoptime = crs.GetValue("stop_time")
sAttendee = crs.GetValue("attendee")
iProposer = crs.GetValue("proposer")
sFormaction = LCase(sFormaction)
select case sFormaction
case "ok"'通过审批，则修改会议状态，填写审批意见，发送消息给参会人员
sError = ExecuteSQL(dbLocal, sSQL)
if sError <> "" then
Response.Write "<script language=""javascript"">alert('对不起，会议信息修改出错，请查看数据库！')</script>"
end if
call CommonSendMsg(MSG_MEETING,"",sMeetingname,"会议申请通过审批，请各位准时参加！",iExecuter,sAttendee)
case "cancel"'退回，修改会议状态，填写审批意见，添加新任务
sSQL = "update t_meetingprepare set meeting_status = 1, comment = "&Tosql(sComment,"text") &" where meeting_serial = "&iMeetingserial
' sMeetingname ="会议:<"&sMeetingname&">的申请没有通过审批，审批意见如下：<"&sComment&">。请重新申请！"
sError = ExecuteSQL(dbLocal, sSQL)
if sError <> "" then
Response.Write "<script language=""javascript"">alert('对不起，会议信息修改出错，请查看数据库！')</script>"
end if
call CommonSendMsg(MSG_MEETING,"",sMeetingname,"会议申请未通过审批，请根据审批意见重新申请！",iExecuter,iProposer)
case "goon"'添加新任务，提交审批
sMeetingname = "会议：<"&sMeetingname&">的申请正在审批过程中，请等候审批结果！"
call CommonSendMsg(MSG_MEETING,"",sMeetingname,"会议已经提交给领导审批，请等候审批结果！",iExecuter,sProposer)
end select
if sFormaction = "goon" then
response.write "<script language=javascript >window.alert('会议正在领导审批流程中！')</script>"
response.write "<script language=vbscript>window.navigate(""../flowmgr/am_fm_ms.asp?mtype=0&subject="&_
iMeetingserial&""")</script>"
end if
else
'不存在该会议，给出出错信息
response.write "<script language=""javascript"">alert('对不起，不存在该会议或者该会议申请已经处理过了！')</script>"
response.write "<script language = vbscript>window.navigate(""list_checkmeeting.asp"")</script>"
end if
response.write "<script language=vbscript>window.navigate(""list_checkmeeting.asp"")</script>"
End Sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -