e_typeset.asp

zheng fu wang zhan gong neng qi quan

<!--#INCLUDE FILE="Conn.asp"-->
<!--#include file="ConnUser.asp"-->
<!--#include file="char.inc"-->
<!--#include file="config.asp"-->
<!--#include file="chkuser.asp" -->
<!--#include file="ChkURL.asp"-->
<%
IF request.cookies(eChuang)("KEY")<>"super" THEN
	Show_Err("对不起，您的后台管理权限不够！")
	response.end
else
	if request("action")="update" then
		dim typeorder,typemaster,mode,typename,typecontent,typeview,typeurl
		for i=1 to request.form("typeid").count
			typeid=CheckStr(request.form("typeid")(i))
			mode=CheckStr(request.form("mode")(i))
			typename=CheckStr(request.form("typename")(i))
			typecontent=CheckStr(request.form("typecontent")(i))
			typeorder=CheckStr(request.form("typeorder")(i))
			typemaster=CheckStr(request.form("typemaster")(i))
			typeview=CheckStr(request.form("typeview")(i))
			if CheckStr(request.form("typeorder")(i))="" then
				Show_Err("请填写总栏排序！<br><br><a href='javascript:history.back()'>返回</a>")
				response.end
			end if
			typeurl=CheckStr(request.form("url")(i))
			if CheckStr(request.form("typemaster")(i))="" then
				typemaster="无"
			else
				master=split(CheckStr(request.form("typemaster")(i)),"|")
				for k=0 to ubound(master)
					set rs=server.createobject("adodb.recordset")
					sql="Select * from "& db_User_Table &" where oskey='typemaster' and  "& db_User_Name &"='"&trim(master(k))&"'"
					rs.open sql,ConnUser,1,3
					if trim(master(k))<>"无" then
						if rs.eof then
							Show_Err("总栏管理员中无"& trim(master(k)) &"用户！请重新选择该总栏的管理员！<br><br><a href='javascript:history.back()'>返回</a>")
							Response.End
						end if
					else
						typemaster="无"
					end if
					rs.close
					set rs=nothing
				next
			end if
			conn.execute("update "& db_Type_Table &" set typeorder="&typeorder&",typemaster='"&typemaster&"',mode="&mode&",typeview="&typeview&",typename='"&typename&"',typecontent='"&typecontent&"',url='"&typeurl&"' where typeid="&typeid)
		next
	end if

	if request("action")="add" then
	typecontent=request.form("typecontent")
	typename=trim(request("typename"))
	mode=request("mode")
	typeorder=request("typeorder")
	typeview=request("typeview")
	typeurl=request.form("url")
	typemaster=request("typemaster")
	
	If mode="0" Then
		Show_Err("请选择模板！<br><br><a href='javascript:history.back()'>返回</a>")
		response.end
	end if
	
	If typeorder="" Then
		Show_Err("总栏排序不能为空！<br><br><a href='javascript:history.back()'>返回</a>")
		response.end
	end if
	If typename="" Then
		Show_Err("总栏名称不能为空！<br><br><a href='javascript:history.back()'>返回</a>")
		response.end
	end if
	set rs=server.createobject("adodb.recordset")
		sql="select * from "& db_Type_Table
	rs.open sql,conn,3,3
	do while not rs.eof
		if rs("typename")=typename then
			Show_Err("已经存在这个总栏名称！<br><br><a href='javascript:history.back()'>返回</a>")
			response.end
		end if
		rs.movenext
	loop
	rs.close
	set rs=nothing
	set rs=server.createobject("adodb.recordset")
		sql="select * from "& db_Type_Table
	rs.open sql,conn,3,3
	do while not rs.eof
		if rs("typeorder")=typeorder then
			Show_Err("已经存在这个总栏顺序！<br><br><a href='javascript:history.back()'>返回</a>")
			response.end
		end if
		rs.movenext
	loop
	rs.close
	set rs=nothing
	
	Set rs = Server.CreateObject("ADODB.Recordset")
	sql="select * from "& db_Type_Table &""
	rs.open sql,conn,3,3
	rs.addnew
	rs("typename")=typename
	rs("mode")=mode
	rs("typecontent")=typecontent
	rs("typeorder")=typeorder
	rs("typeview")=typeview
	rs("url")=typeurl
	if typemaster="" then
		rs("typemaster")="无"
	else
		rs("typemaster")=typemaster
	end if
	rs.update
	rs.close
	set rs=nothing
	end if
	
	conn.close
	set conn=nothing
	response.write "<meta http-equiv=""refresh"" content="""&freetime&";url=E_TypeManage.asp"">"
	Show_Message("<p align=center><font color=red>恭喜您!设置成功!<br><br>"&freetime&"秒钟后返回上页!</font>")
	response.end
end if%>