📄 datereturn.asp

📁 企业办公自动化管理系统 asp+sql server 2005
💻 ASP
字号:
<!--#include file="include/keepformat.asp"-->
<!--#include file="include/opendb.asp"-->
<!--#include file="include/sqlstr.asp"-->
<!--#include file="include/checked.asp"-->
<!--#include file="include/bgsub.asp"-->
<%
oabusyname=request.cookies("oabusyname")
oabusysuid=request.cookies("oabusysuid")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusysuid="" then response.redirect "default.asp"
sendto=request("sendto")
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="css/css.css" type="text/css">
<title>企业办公系统</title>
</head>
<body bgcolor="#ffffff">
<%
call bghead()
%>
<center>
<table>
<tr>
<td><b>公文回复和转发</b>&nbsp;&nbsp;</td>
<form method="post" action="showdate.asp">
<td><input type="submit" value="返回"><input type="hidden" name="id" value=<%=request("id")%>></td></form>
</tr>
</table>
</center>
<%
call bgmid()
%>
<%
if request("submit")="转发" then
	'打开要转发的记录，并读出转发人
	set conn=opendb()
	Set rs=Server.CreateObject("ADODB.recordset")
	sql="select a.*,b.name from a_senddate a,a_userinf b where a.id=" & request("id") & " and b.suid=" & sqlstr(oabusysuid)
	rs.open sql,conn,1
	'取出数据
	titleold=rs("title")
	contentold=rs("content")
	senderold=rs("sender")
	filenameold=rs("filename")
	fileContentTypeold=rs("fileContentType")
	filevalueold=rs("filevalue")
	changename=rs("name")
	title=titleold
	'转发格式
	content=contentold & "<br>---------------------<br>[转发人：" & changename & "]&nbsp;[转发时间：" & now() & "]<br>" & request("content")
	'转发对象
	sendto=request("sendto")
	dim mysendto
	mysendto=split(sendto,"|",-1,1)
	for each sendtoinf in mysendto
		userdeptpoint=InStr(sendtoinf,":")
		if userdeptpoint>0 then
			sendtoinflen=len(sendtoinf)
			recipientusername=right(sendtoinf,sendtoinflen-userdeptpoint)
			if recipientusername="所有人" then
				recipientusername="所有人"
			else
				suidpoint=Instr(recipientusername,"(")
				suidlen=len(recipientusername)
				recipientusername=left(recipientusername,suidlen-1)
				recipientusername=right(recipientusername,suidlen-1-suidpoint)
			end if
			recipientuserdept=left(sendtoinf,userdeptpoint-1)
			'对转发对象增加一条公文
			set conn=opendb()
			set rs=server.createobject("ADODB.recordset") 
			sql = "select * from a_senddate"
			rs.Open sql,conn,1,3
			rs.addnew 
			rs("title")=title
			rs("content")=content
			rs("sender")=senderold
			rs("recipientusername")=recipientusername
			rs("recipientuserdept")=recipientuserdept
			if filenameold<>"" then
				rs("filename")=filenameold
				rs("fileContentType")=fileContentTypeold
				rs("filevalue").appendchunk filevalueold
			end if
			rs.update 
			rs.close 
			set rs=nothing 
			set conn=nothing 
		end if
	next
	'把转发信息回复给原发送人
	sender=request("sender")
	recipientusername=request("recipientusername")
	reid=request("reid")
	title=request("title")
	content="此公文已经转发给：" & sendto & "<br>" & request("content")
	set conn=opendb()
	sql="Insert into a_senddate (title,content,sender,recipientusername,reid) values ("
	sql=sql & sqlstr(title) & ","
	sql=sql & sqlstr(content) & ","
	sql=sql & sqlstr(sender) & ","
	sql=sql & sqlstr(recipientusername) & ","
	sql=sql & reid & ")"
	conn.Execute sql
%>
<br><br><br>
<center><font color=red size=3>转发完成</font></center>
<%
end if
%>





<%
if request("submit")="回复" then
	sender=request("sender")
	recipientusername=request("recipientusername")
	reid=request("reid")
	title=request("title")
	content=request("content")
	set conn=opendb()
	sql="Insert into a_senddate (title,content,sender,recipientusername,reid) values ("
	sql=sql & sqlstr(title) & ","
	sql=sql & sqlstr(content) & ","
	sql=sql & sqlstr(sender) & ","
	sql=sql & sqlstr(recipientusername) & ","
	sql=sql & reid & ")"
	conn.Execute sql
%><br><br><br>
<center><font color=red size=3>回复完成</font></center>
<%
end if
%>

<%
call bgback()
%>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -