admin_newsfuntionn.asp

ASP源程序采用天空软件小偷中心核件制成

<!--#INCLUDE FILE="function.asp" -->
<!--#INCLUDE FILE="Conn.asp" -->
<!--#include file="admin_loginchk.asp"-->
<%admin1%>
<%

dim action
dim ID
ID=request("ID")


if request("action")="modiNclass" then
class1=request("Nclass")

set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where NclassID="&ID
rs.open sql,conn,3,3
rs("Nclass")=class1
rs.update
rs.close

end if

if request("action")="modiclass" then
class1=request("classid")

set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where NclassID="&ID
rs.open sql,conn,3,3
rs("classid")=class1
rs.update
rs.close
conn.execute("update download set classid="&class1&" where NclassID="&ID&"")

end if

if request("action")="upNclass" then
set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where NclassID="&ID
rs.open sql,conn,3,3
rs("Nclassorder")=rs("Nclassorder")-1
rs.update
idtemp=rs("Nclassid")
ordertemp=rs("Nclassorder")
rs.close

set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where Nclassorder="&ordertemp&" and classID<>"&ID
rs.open sql,conn,3,3
rs("Nclassorder")=rs("Nclassorder")+1
rs.update

end if

if request("action")="downNclass" then
set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where NclassID="&ID
rs.open sql,conn,3,3
rs("Nclassorder")=rs("Nclassorder")+1
rs.update
idtemp=rs("Nclassid")
ordertemp=rs("Nclassorder")
rs.close

set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where Nclassorder="&ordertemp&" and NclassID<>"&ID
rs.open sql,conn,3,3
rs("Nclassorder")=rs("Nclassorder")-1
rs.update
rs.close
end if

if request("action")="addadminn" then
Master=trim(request("Master"))
if Master="" then
Master="无"
end if
set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where NclassID="&ID
rs.open sql,conn,3,3
rs("manager")=master
rs.update
rs.close
end if


if request("action")="addNclass" then
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 typename
dim howmany
typename=changechr(trim(request("type")))
howmany=request("howmany")
classt=request("class")

If classt="" Then
errmsg=errmsg+"<br>"+"<li>"+"主分类不能为空！请<a href=javascript:history.go(-1)>返回重新填写</a>"
call error()
response.end
end if

If typename="" Then
errmsg=errmsg+"<br>"+"<li>"+"小分类名不能为空！请<a href=javascript:history.go(-1)>返回重新填写</a>"
call error()
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from ANclass where classid="&classt
rs.open sql,conn,3,3
do while not rs.eof
if rs("Nclass")=typename then
errmsg=errmsg+"<br>"+"<li>"+"已经存在这个小分类名称！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
call error()
response.end
end if
rs.movenext
loop
rs.close
set rs=nothing

Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from ANclass"
rs.open sql,conn,3,3
rs.addnew
rs("classid")=classt
rs("Nclass")=typename
rs("Nclassorder")=howmany+1
rs("manager")="无"
rs.update
rs.close

end if

if request("action")="Nclassinit" then
set rs=server.createobject("adodb.recordset")
sql="select * from ANclass order by NclassID"
rs.open sql,conn,3,3
i=0
do while not rs.eof
i=i+1
rs("Nclassorder")=i
rs.update
rs.movenext
loop
rs.close

end if


if request("action")="delNclass" then
       
	  
	Rem 删除相关栏目下子栏目
        sql="delete from ANclass where Nclassid=" &id
        conn.execute sql
	Rem 删除相关栏目对应程序
        sql="delete from download where Nclassid=" &id
        conn.execute sql
       
	    if err.Number<>0 then
         err.clear
        response.write " 数 据 库 操 作 失 败 ! "
         end if
			   
end if

set rs=nothing
conn.close
set conn=nothing
response.redirect "admin_newsnclassmana.asp"
%>