writeforeadfielsehuizhi1.asp

来自「绿叶oa系统办公自动化 2008.工作日志管理,文件管理」· ASP 代码 · 共 137 行

<%  
Response.ExpiresAbsolute=now()-1
Response.CacheControl="no-cache"
%> 
<%
MM_authorizedUsers=""
MM_authFailedURL="../../index.asp"
MM_grantAccess=false
If Session("userssdfgfhtrh") <> "" Then
  If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
         (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
    MM_grantAccess = true
  End If
End If
If Not MM_grantAccess Then
  MM_qsChar = "?"
  If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
  MM_referrer = Request.ServerVariables("URL")
  if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
  MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
  Response.Redirect(MM_authFailedURL)
End If
%>
<!--#include file="../../Connections/oavbsconncopy.asp" -->
<%
Dim r__MMColParam
r__MMColParam = "1"
If (id <> "") Then 
  r__MMColParam = id
End If
%>
<%
Dim r
Dim r_numRows
Set r = Server.CreateObject("ADODB.Recordset")
r.ActiveConnection = MM_oavbsconncopy_STRING
r.Source = "SELECT 上传人部门  FROM 文件信息  WHERE ID = " + Replace(r__MMColParam, "'", "''") + ""
r.CursorType = 0
r.CursorLocation = 2
r.LockType = 1
r.Open()
r_numRows = 0
%>
<%
Dim Recordset22
Dim Recordset22_numRows
Set Recordset22 = Server.CreateObject("ADODB.Recordset")
Recordset22.ActiveConnection = MM_oavbsconncopy_STRING
Recordset22.Source = "SELECT 标题,内容,接收人姓名,sms接收部门,文件名,发送人姓名,文件编号,发送人帐号,入库日期,信息属性,sms发送人level,发送人部门,sms是否为群发,回执  FROM infoall"
Recordset22.CursorType = 0
Recordset22.CursorLocation = 3
Recordset22.LockType = 3
Recordset22.Open()
Recordset22.addnew
dim f
f=huizhi("文件名")
Recordset22("标题")=f&"文件收到"
Recordset22("内容")="你好！你发送给"&huizhi("接收人部门")&"--"& huizhi("接收人姓名")&":"&f&"的文件收到,已"&juti&",谢谢！"
Recordset22("接收人姓名")=huizhi("上传人姓名")
Recordset22("发送人姓名")=session("names")
Recordset22("发送人帐号")=Session("userssdfgfhtrh")   
Recordset22("入库日期")=date()
Recordset22("信息属性")="短消息"
Recordset22("sms发送人level")=Session("levels")
Recordset22("发送人部门")=session("bumen")
Recordset22("sms是否为群发")="否"
Recordset22("sms接收部门")=r("上传人部门")
Recordset22("回执")="文件"
Recordset22("文件名")=n
Recordset22("文件编号")=id
Recordset22.update
Recordset22_numRows = 0

%>
<%
Recordset22.Close()
Set Recordset22 = Nothing
%>
<%
Dim rs__MMColParam
rs__MMColParam = "文件"
If (Request("MM_EmptyValue") <> "") Then 
  rs__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rs__u
rs__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  rs__u = Session("userssdfgfhtrh")
End If
%>
<%
Dim rs
Dim rs_numRows

Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_oavbsconncopy_STRING
rs.Source = "SELECT max(ID) as fhuiid  FROM infoall  WHERE 回执 = '" + Replace(rs__MMColParam, "'", "''") + "' and 发送人帐号='" + Replace(rs__u, "'", "''") + "'and 信息属性='短消息'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()

rs_numRows = 0
dim smsid
smsid=rs("fhuiid")

%>
<%

if(rs("fhuiid") <> "") then Command1__d = smsid

if(cint(request("id")) <> "") then Command1__ids = cint(request("id"))

if(session("names") <> "") then Command1__u = session("names")

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_oavbsconncopy_STRING
Command1.CommandText = "UPDATE 文件信息  SET 回执sms编号=" + Replace(Command1__d, "'", "''") + "  WHERE id=" + Replace(Command1__ids, "'", "''") + " and 接收人姓名='" + Replace(Command1__u, "'", "''") + "' "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>

<%
r.Close()
Set r = Nothing
%>
<%
rs.Close()
Set rs = Nothing
%>