isadmin.asp

财务管理系统 报账等基本功能实现 有完整的实现

<% 
  '从Session变量中读取用户信息
  UserName = Trim(Session("UserName"))
  UserPwd = Trim(Session("UserPwd"))
   '用户名是否为空
  If UserName <> "" Then
    sql = "Select * From Users Where UserName='" & UserName & "' And UserPwd='" & UserPwd & _
       "' And UserType Like '%售后%'"   
     '是否存在此用户信息
    Set rs = Conn.Execute(sql)
    If rs.EOF Then
      Response.Write "<script>alert('您没有权限');window.close()</script>"
    End If
  Else
    Response.Write "<script>alert('您没有权限');window.close()</script>"
  End If
  
  
Function isAdmin()
  isAdmin = -1
  '从Session变量中读取用户信息
  UserName = Trim(Session("UserName"))
  UserPwd = Trim(Session("UserPwd"))
   '用户名是否为空
  If UserName <> "" Then
    sql = "Select * From Users Where UserName='" & UserName & "' And UserPwd='" & UserPwd & "'"
    '是否存在此用户信息
    Set rsUser = Conn.Execute(sql)
    If Not rsUser.EOF Then
      If InStr(Trim(rsUser("UserType")),"售后管理员")>0 Then  '售后管理员
        isAdmin = 1
      ElseIf InStr(Trim(rsUser("UserType")),"售后主管")>0 Then  '售后主管
        isAdmin = 2
      ElseIf InStr(Trim(rsUser("UserType")),"售后工程师")>0 Then  '售后工程师
        isAdmin = 3
      End If
    End If
  Else
    isAdmin = -1
  End If
End Function
%>