admin_class.asp

一个用ASP和ACCESS做的网络建站系统 1.WAP站长论坛网站系统【测试版】 2.只能添加一级主题栏目 3."文章栏目、文件栏目"添加栏目后再添加分类 4.可自定上传文件类型,上传目

<!--#include file=admin_login_check.asp-->
<%
const PageSize=15	'一页15条记录
dim cid
cid=TRim(Request("cid"))
IF  Request.QueryString("Action")="add" Then
	call BBSSET
elseIF  Request.QueryString("Action")="edit" Then
	call edit
elseIF  Request.QueryString("Action")="del" Then
	call del
else
	call main
end if

Function BBSSET

%>

<form name="pollform3sdx" method="post" action="admin_class.asp?Action=add&cid=<%=cid%>">
  <p style="margin-left:15px;">
  <b>添加文件分类</b><br/><a href='admin_class.asp?cid=<%=cid%>'>返回文件分类</a></p>
  <input type="hidden" name="SubmitFlag" value=yes>
  <table width="100%" border="0" align="center" cellpadding="8" cellspacing="0">

	<tr>
	<td align="center">
	<%
	If Request("SubmitFlag") <> "" Then
			Addbbsboards
			Exit Function
	Else
			DisplayBBSSet
	End If
	%>
	</td></tr>
	<tr>
	<td align="center">
	<input type=submit name=提交 value=提　交 class=fmbtn>　
	<input type=reset name=取消 value=清　除 class=fmbtn>
	</td>
	</tr>
</table>
</form>
<%

End Function



Function CheckLinkValue

	GetFormValue

End Function



Function DisplayBBSSet


%>
		
  <table width="100%" border=0 align="center" cellpadding=5 cellspacing=1  bgcolor="#FF0000"  class=TBone>


  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">分类名称:</td>
    <td><input name="name" type="text" class=fminpt id="boardName" size="30" maxlength="50">
      <font color=gray>(分类名称，50字，必填)</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">文件类型:</td>
    <td><input name="file" type="text" class=fminpt id="boardName" size="30" maxlength="50">
      <font color=gray><br/>(该分类可文上传的文件类型，如".gif",多个类型用","隔开)</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">文件目录:</td>
    <td><input name="upfile" type="text" class=fminpt id="boardName" value="<%=const_upfile%>/" size="30" maxlength="50">
      <font color=gray><br/>(文件存放目录，请确认有该目录,否则无法文件文件)</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">文件大小:</td>
    <td><input name="fsize" type="text" class=fminpt id="boardName" size="30" maxlength="50"   onkeyup='this.value=this.value.replace(/\D/gi,"")'>
      <font color=gray><br/>(文件大小，该分类可文件的文件大小，数字:如1M填1024)</font></td>
  </tr>
 		       <tr bgcolor=#f7f7f7 class=TBBG9> 
  		        <td valign="top">分类说明:<br/>支持UBB</td>
  		        <td><textarea rows="15" name="title" cols="63" >--------------</textarea></td>
   			     </tr>
  </table>
		<%

End Function



Function GetFormValue

	dim thing
	for each thing in Request.Form
		Response.Write thing&"="&Request(thing)&"<br>"
	next

End Function


Function Addbbsboards
	dim flag,errmsg,id,name,classID,pid,file,upfile,fsize
	flag=1
	errmsg="<ul><font color=red>"
	name=TRim(Request.Form("name"))
	file=TRim(Request.Form("file"))
	upfile=TRim(Request.Form("upfile"))
	title=TRim(Request.Form("title"))
	fsize=TRim(Request.Form("fsize"))
	if name=""  then errmsg=errmsg&"<li>分类名称不能为空</li>":flag=0
	if file=""  then errmsg=errmsg&"<li>文件类型不能为空</li>":flag=0
	if upfile=""  then errmsg=errmsg&"<li>文件目录不能为空</li>":flag=0
	if fsize=""  then errmsg=errmsg&"<li>大小不能为空</li>":flag=0
	if title=""  then errmsg=errmsg&"<li>栏目说明不能为空</li>":flag=0
		if flag<>0 then
			Dim sql,rs
			set rs=server.CreateObject("adodb.recordset")
			sql="select * from ulist WHERE cid='" & cid&"' order by pid asc"
			rs.open sql,conn,1,1
			if not (rs.bof and rs.eof)  then 
				rs.MoveLast
				pid=rs("pid")
			else
				pid=0
			end if
				Rs.close
				set rs=nothing
			set rs=server.CreateObject("adodb.recordset")
			sql="select * from ulist"
			rs.open sql,conn,1,3
				rs.addnew()
					rs("name")=name
					rs("format")=file
					rs("upfile")=upfile
					rs("cid")=cid
					rs("pid")=pid+1
					rs("size")=fsize
					rs("title")=title
				rs.update()
				Rs.close
				set rs=nothing
				Response.Write("成功添加名为<font color='red'>"&name&"</font>的分类！")
				Response.Write("<br/><a href='admin_class.asp?cid="&cid&"'>返回文件分类</a>")
				errmsg=errmsg&"</font></ul>"
		else
			Response.Write("由于以下原因，设置没有成功，请<a href='javascript:history.back()'>返回</a>修改：<br>"&errmsg&"<br><button  onclick='javascript:history.back()'>返回修改</button>") 
		
		end if	
End Function



Function main
	if not isnumeric(cid) then cid=""
	if cid<>""  then
	Set Rs = Server.CreateObject("Adodb.Recordset")
	Sql = "SELECT * FROM uclass  WHERE cid=" & cid
	Rs.Open Sql,conn,1,1
	if not (rs.bof and rs.eof)  then 

%>
<form name="pollform3sdx" method="post" action="admin_class.asp?cid=<%=cid%>">
  <p style="margin-left:15px;">
  <b>文件分类管理-<%=rs("class")%></b><br/>
<% if session("flag")="1" or session("flag")="2" then%>
<a href='admin_class.asp?Action=add&cid=<%=cid%>'>添加文件分类</a>|
<%end if%>
<a href='admin_add_class.asp'>返回栏目管理</a></p>
 <input type="hidden" name="SubmitFlag" value=yes>
 <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#FF0000" >
	<%
		Rs.close
		set rs=nothing

	If Request("SubmitFlag") <> "" Then
			Addbbs
			Exit Function
	Else
			mainBBSSet
	End If
	%>

</table>
</form>
<%
end if
end if
End Function

Function Addbbs
	dim flag,errmsg,id,name,classID,sql,rs
	flag=1
			set rs=server.CreateObject("adodb.recordset")
			sql="select * from ulist  WHERE cid='" & cid&"' order by pid asc"
			rs.open sql,conn,1,1
			errmsg="<ul><font color=red>"
			Page = Request("Page")
			Rs.PageSize = PageSize
			if not (rs.bof and rs.eof)  then 
				IF Not IsEmpty(Page) Then
					IF Not IsNumeric(Page) Then		'判断Page是否为数字
						Page=1
					Else
						Page=Cint(Page)		'转换成短整形Integer
					End IF
					IF Page > Rs.PageCount Then
						Rs.AbsolutePage = Rs.PageCount	'设置当前显示页等于最后一页
					ElseIF Page <= 0 Then
						Rs.AbsolutePage = 1		'设置当前页等于第一页
					Else
						Rs.AbsolutePage = Page	'如果大于零,显示当前页等于接收的页数
					End IF
				Else
					Rs.AbsolutePage = 1
				End IF
					Page = Rs.AbsolutePage

	For i=1 to Rs.PageSize
		If Rs.Eof Then
			exit For
		End If
		classID=TRim(Request.Form("classID"&i))
	if classID=""  then errmsg=errmsg&"<li>排序编号不能为空</li>":flag=0
	if not isnumeric(classID) then errmsg=errmsg&"<li>排序编号必须为数字</li>":flag=0
		Rs.MoveNext
	Next
		Rs.close
		set rs=nothing
		if flag<>0 then
			set rs=server.CreateObject("adodb.recordset")
			sql="select * from ulist  WHERE cid='" & cid&"' order by pid asc"
			rs.open sql,conn,1,3
			Page = Request("Page")
			Rs.PageSize = PageSize
			if not (rs.bof and rs.eof)  then 
			IF Not IsEmpty(Page) Then
				IF Not IsNumeric(Page) Then		'判断Page是否为数字
					Page=1
				Else
					Page=Cint(Page)		'转换成短整形Integer
				End IF
				IF Page > Rs.PageCount Then
					Rs.AbsolutePage = Rs.PageCount	'设置当前显示页等于最后一页
				ElseIF Page <= 0 Then
					Rs.AbsolutePage = 1		'设置当前页等于第一页
				Else
					Rs.AbsolutePage = Page	'如果大于零,显示当前页等于接收的页数
				End IF
			Else
				Rs.AbsolutePage = 1
			End IF
			Page = Rs.AbsolutePage

			For i=1 to Rs.PageSize
				If Rs.Eof Then
					exit For
				End If
					rs("pid")=TRim(Request.Form("classID"&i))
					rs.update()
					Rs.MoveNext
			Next
			end if
		Rs.close
		set rs=nothing

				Response.Write("成功排序文件分类！")
				Response.Write("<br/><a href='admin_class.asp?cid="&cid&"'>返回文件分类</a>")
				errmsg=errmsg&"</font></ul>"
		end if
		else
			Response.Write("由于以下原因，设置没有成功，请<a href='javascript:history.back()'>返回</a>修改：<br>"&errmsg&"<br><button  onclick='javascript:history.back()'>返回修改</button>") 
		
		end if	
End Function



Function mainBBSSet
	if not isnumeric(cid) then cid=""