depeditok.asp

很好的代码！！大家可以下

<!--#INCLUDE FILE="Conn.asp" --><!--#include file="char.inc"--><!--#include file="chkuser.asp" -->
<%
IF request.cookies("KEY")<>"super" THEN
response.redirect "index_face.asp"
response.end
else
usernamecookie=CheckStr(request.cookies("UserName"))
passwdcookie=replace(trim(Request.cookies("passwd")),"'","''")
KEYcookie=replace(trim(request.cookies("KEY")),"'","''")
if usernamecookie="" or passwdcookie="" then
response.redirect "login.asp"
response.end
else
'判断用户的合法性
  set rs=server.createobject("adodb.recordset")
  sql="select * from admin where username='"&usernamecookie&"'"
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
             response.redirect "login.asp"
            response.end
         end if
  IF passwdcookie<>rs("passwd") THEN
          response.redirect "login.asp"
           response.end
      END IF
   '下面判断用户级别实际在有用户级别是都应该判断
   if KEYcookie<>rs("OSKEY") then
      response.redirect "index_face.asp"
      response.end
    end if
           rs.close
           set rs=nothing
END IF
END IF

function changechr(str) 
    changechr=replace(replace(replace(replace(str,"<","&lt;"),">","&gt;"),chr(13),"<br>")," "," ") 
    changechr=replace(changechr,"'","&acute;")
    changechr=replace(changechr,mid(" "" ",2,1),"&quot;")
end function

dim depname
dim deptype
dim ID
ID=request("ID")
deptype=request.form("deptype")
name=request.form("name")
depname=changechr(trim(request("depname")))
if depname="" then
response.write "不能为空！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from dep"
rs.open sql,conn,3,3
do while not rs.eof
if rs("depName")=depname and rs("deptype")=deptype then
response.write "<br><br><br><center>没有做任何改动！请<a href=javascript:history.go(-1)>返回重新填写</a>！</center>"
response.end
end if
rs.movenext
loop
rs.close
set rs=nothing

'修改部门库
dim depid
set rs=server.createobject("adodb.recordset")
sql="select * from dep where ID="&ID
rs.open sql,conn,3,3
depid=rs("id")
rs("depName")=depname
rs("deptype")=deptype
rs.update
rs.close
set rs=nothing

'修改用户库

set rs=server.createobject("adodb.recordset")
sql="select * from admin where depid="&depid
rs.open sql,conn,3,3
do while not rs.eof
rs("depName")=depname
rs.update
rs.movenext
loop
rs.close
set rs=nothing


conn.close
set conn=nothing

response.redirect "depmanage.asp"
%>