depeditok.asp

zheng fu wang zhan gong neng qi quan

<!--#INCLUDE FILE="Conn.asp" -->
<!--#include file="ConnUser.asp"-->
<!--#include file="config.asp"-->
<!--#include file="char.inc"-->
<!--#include file="chkuser.asp"-->
<!--#include file="ChkManage.asp" -->
<!--#include file="ChkURL.asp"-->

<%
IF request.cookies(eChuang)("ManageKEY")<>"super" then
	Show_Err("对不起，您的后台管理权限不够！")
	response.end
else
	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=ChkRequest(request("ID"),1)	'防注入
	deptype=changechr(trim(request.form("deptype")))
	name=request.form("name")
	depname=changechr(trim(request("depname")))
	if depname="" or deptype="" then
		Show_Err("单位部门名称不能为空<br><br><a href=javascript:history.go(-1)>返回重新填写</a>")
		response.end
	else
		'修改部门库
		dim depid
		set rs=server.createobject("adodb.recordset")
		sql="select * from "& db_dep_Table &" 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 "& db_User_Table &" where depid="&depid
		rs.open sql,ConnUser,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.write "<meta http-equiv=""refresh"" content="""&freetime&";url=DepManage.asp"">"
		Show_Message("<p align=center><font color=red>单位部门修改成功!<br><br>"&freetime&"秒钟后返回上页!</font>")
		response.end
	end if
end if%>