一套简单的OA系统
源代码在线查看： showsenddate.asp
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then
response.write("")
response.write("window.top.location.href='default.asp';")
response.write("")
response.end
end if
%>
公文内容
set conn=opendb("oabusy","conn","accessdsn")
set rs=Server.CreateObject("ADODB.recordset")
sql="select * from senddate,texttype where id=" & request("id")&" and senddate.documenttype=texttype.number"
rs.open sql,conn,1
if not rs.eof and not rs.bof then
%>
（）
if rs("filename")"" then
%>
else
%>
end if
%>-->
[发送日期：][接收人所在部门：]
if rs("recipientusername")="所有人" then
%>
[接收者：]
else
set rs1=Server.CreateObject("ADODB.recordset")
sql="select name from userinf where username=" & sqlstr(rs("recipientusername"))
rs1.open sql,conn,1
if not rs1.eof and not rs1.bof then
%>
[接收者：]
end if
end if
%>
response.write(" ")
response.write(keepformat(rs("content")))
'打开数据库读出回复
set rs2=Server.CreateObject("ADODB.recordset")
sql="select * from senddate where reid=" & request("id") & " order by id desc"
rs2.open sql,conn,1
while not rs2.bof and not rs2.eof
%>
response.write(keepformat(rs2("title"))&"")
set rs3=Server.CreateObject("ADODB.recordset")
sql="select userdept,name from userinf where username=" & sqlstr(rs2("sender"))
rs3.open sql,conn,1
if not rs3.eof and not rs3.bof then
%>
[回复部门：][回复者：][回复时间：]
response.write("回复意见：")
response.write(keepformat(rs2("content")))
end if
rs2.movenext
wend
else
%>
response.write("对不起，该公文已被删除！")
response.write("")
end if
%>
IE37 © IE37.com
conn.close
set conn=nothing
%>
