admin_add_main.asp

非常好的源码 非常好的源码 非常好的源码

<!--#include file=admin_login_check.asp-->
<%
const PageSize=15	'一页15条记录

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_add_main.asp?Action=add">
  <p style="margin-left:15px;">
  <b>添加主题栏目</b><br/><a href='admin_add_main.asp'>返回主题栏目</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="20" maxlength="50">
      <font color=gray>(栏目名称，50字，可空)</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">主题栏目联接:</td>
    <td><input name="url" type="text" class=fminpt id="boardName" size="20" maxlength="100">
      <font color=gray>(栏目联接，如果没有联接请留空)</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">栏目横幅图片:</td>
    <td><input name="img" type="text" class=fminpt id="boardName" size="20" maxlength="50">
      <font color=gray>如果有图片,则显示图片,否则显示文字</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">主题栏目排序:</td>
    <td><input name="classID" type="text" class=fminpt id="boardName" size="10" maxlength="50"  onkeyup='this.value=this.value.replace(/\D/gi,"")'>
      <font color=gray>(主题栏目排序，序号越小越排前，必填)</font></td>
  </tr>
  <tr bgcolor=#f7f7f7 class=TBBG9> 
    <td class="tar">栏目换行:</td>
    <td><select name="wh">
	<option value="true">栏目后自动换行</option>
	<option value="false">栏目后不换行</option>
	</select>
      <font color=gray>(栏目换行，栏目后是否换行)</font></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,wh
	flag=1
	errmsg="<ul><font color=red>"
	url=TRim(Request.Form("url"))
	wh=TRim(Request.Form("wh"))
	img=TRim(Request.Form("img"))
	name=TRim(Request.Form("name"))
	classID=TRim(Request.Form("classID"))
	if wh=""  then errmsg=errmsg&"<li>栏目换行不能为空</li>":flag=0
	if classID=""  then errmsg=errmsg&"<li>主题栏目排序不能为空</li>":flag=0
	if not isnumeric(classID) then errmsg=errmsg&"<li>主题栏目排序必须为数字</li>":flag=0
		if flag<>0 then
			Dim sql,rs
			set rs=server.CreateObject("adodb.recordset")
			sql="select * from main"
			rs.open sql,conn,1,3
				rs.addnew()
					rs("br")=wh
					rs("url")=url
					rs("img")=img
					rs("title")=name
					rs("pid")=classID
					rs("class")="true"
				rs.update()
		Rs.close
		set rs=nothing
				Response.Write("成功添加名为<font color='red'>"&name&"</font>的主题栏目！")
				Response.Write("<br/><a href='admin_add_main.asp'>返回主题栏目</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%>
<form name="pollform3sdx" method="post" action="admin_add_main.asp">
  <p style="margin-left:15px;">
  <b>主题栏目</b><br/><a href='admin_add_main.asp?Action=add'>添加主题栏目</a></p>
<input type="hidden" name="SubmitFlag" value=yes>
  <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#FF0000" >
	<%
	If Request("SubmitFlag") <> "" Then
			Addbbs
			Exit Function
	Else
			mainBBSSet
	End If
	%>

</table>
</form>
<%

End Function

Function Addbbs
	dim flag,errmsg,id,name,classID,sql,rs
	flag=1
			set rs=server.CreateObject("adodb.recordset")
			sql="select * from main"
			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 main 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_add_main.asp'>返回主题栏目</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

%>
    <tr bgcolor="#799ae1"> 
      <td class="blu">ID</td>
      <td class="blu">主题栏目名称</td>
      <td class="blu">操作</td>
      <td class="blu">排序</td>
    </tr>
<%
dim sql,h,i
	Set Rs = Server.CreateObject("Adodb.Recordset")