delrizhighf.asp

本oa系统内部短信.手机短信.文件传输.公文收发.邮件服务.共享下载.内部论坛等功能

<%@LANGUAGE="VBSCRIPT"%>
<%Response.Expires = -1
Response.ExpiresAbsolute = Now() - 1
Response.cachecontrol = "no-cache"%>
<%
' *** Restrict Access To Page: Grant or deny access to this page
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/oavbsconn.asp" -->
<%
Dim Recordset5
Dim Recordset5_numRows
Set Recordset5 = Server.CreateObject("ADODB.Recordset")
Recordset5.ActiveConnection = MM_oavbsconn_STRING
Recordset5.Source = "SELECT 日志管理时限 FROM 日志管理时限"
Recordset5.CursorType = 0
Recordset5.CursorLocation = 2
Recordset5.LockType = 1
Recordset5.Open()
Recordset5_numRows = 0
%>
<%if not Recordset5.eof or not Recordset5.bof then %>
<%dim tt
tt=Recordset5("日志管理时限")
end if%>
<%
Recordset5.Close()
Set Recordset5 = Nothing
%>

<%
Dim Recordset1__u
Recordset1__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  Recordset1__u = Session("userssdfgfhtrh")
End If
%>
<%
Dim Recordset1__ids1
Recordset1__ids1 = "1"
If (request("id")   <> "") Then 
  Recordset1__ids1 = request("id")  
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_oavbsconn_STRING
Recordset1.Source = "SELECT *  FROM 工作日志4545zdfbdgg  WHERE 帐号='" + Replace(Recordset1__u, "'", "''") + "' and id=" + Replace(Recordset1__ids1, "'", "''") + "  ORDER BY id DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%if not Recordset1.eof or not Recordset1.bof then %>
<%dim t
t=Recordset1("时间")
%>
<%if Recordset1("日志类型")="工作日志" then 
if datediff("h",t,now)>tt then

Recordset1.Close()
Set Recordset1 = Nothing

response.write"<script>alert('"&Session("names")&"很抱歉,工作日志管理超过"&tt&"小时时限,将无法删除。');location='"&request.ServerVariables("HTTP_REFERER")&"'</script>"
response.end()
end if
end if
end if%>
<%
if(request("id") <> "") then Command1__ids = request("id")
if(Session("userssdfgfhtrh") <> "") then Command1__u = Session("userssdfgfhtrh")
%>
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_oavbsconn_STRING
Command1.CommandText = "DELETE FROM 工作日志4545zdfbdgg  WHERE id=" + Replace(Command1__ids, "'", "''") + " and 帐号='" + Replace(Command1__u, "'", "''") + "' "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>

<%response.redirect("youserselftfd.asp")%>