smallclasseditok.asp

综合信息管理系统

<!--#INCLUDE FILE="Conn.asp" -->
<%
IF not(Session("KEY")="super" or Session("KEY")="input" or Session("KEY")="check") THEN
response.write "<script>alert('您无权修改此项目！');history.go(-1);</Script>"
response.end
END IF	

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

dim typename
dim ID
dim zs
zs=request.form("smallclasszs")
ID=request("ID")
typename=changechr(trim(request("typename")))
if typename="" then
response.write "不能为空！"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from SmallClass"
rs.open sql,conn,3,3
do while not rs.eof
if rs("SmallClassName")=typename and rs("smallclasszs")=zs 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

'修改小类库

set rs=server.createobject("adodb.recordset")
sql="select * from SmallClass where ID="&ID
rs.open sql,conn,3,3
typen=rs("SmallClassName")
rs("SmallClassName")=typename
rs("smallclasszs")=zs
rs.update
rs.close
set rs=nothing

'修改新闻库
set rs=server.createobject("adodb.recordset")
sql="select * from news where SmallClassName='"&typen&"'"
rs.open sql,conn,3,3
do while not rs.eof
rs("SmallClassName")=typename
rs("smallclasszs")=zs
rs.update
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing

response.redirect "SmallClass.asp"
%>