admin_link.asp

大型黄页系统,精美黄页flash演示,10m

		Rem ##########################
		n = CurrentPage
		If pagestart < 1 Then
			pagestart = 1
		End If
		If pageend > maxpagecount Then
			pageend = maxpagecount
		End If
		If n < maxpagecount Then
			n = maxpagecount
		End If
		Response.Write "<table width=""95%"" border=""0"" cellspacing=""1"" cellpadding=""3"" align=center class=""tableBorder"">" & Chr(13) & Chr(10)
		Response.Write " <tr> " & Chr(13) & Chr(10)
		Response.Write " <th height=""22"" colspan=5>友情链接列表 | <a href=""admin_link.asp?action=add""><font color=#FFFFFF>增加新的友情链接</font></a></th>" & Chr(13) & Chr(10)
		Response.Write " </tr>" & Chr(13) & Chr(10)
		Response.Write " <tr> " & Chr(13) & Chr(10)
		Response.Write " <td height=""22"" colspan=5 class=forumrow><form name=""searchsoft"" method=""POST"" action=""admin_link.asp"" target=""main"">" & Chr(13) & Chr(10)
		Response.Write "按名称搜索：<input class=smallInput type=""text"" name=""keyword"" size=""25"" class=""kuang""> <input type=""submit"" value=""搜索链接"" name=""submit"" class=""kuang"">" & Chr(13) & Chr(10)
		Response.Write " </td></form>" & Chr(13) & Chr(10)
		Response.Write " </tr>" & Chr(13) & Chr(10)
		Response.Write " <tr align=center>" & Chr(13) & Chr(10)
		Response.Write " <td width=""10%"" height=25 class=""forumHeaderBackgroundAlternate""><B>序号</B></td>" & Chr(13) & Chr(10)
		Response.Write " <td width=""30%"" class=""forumHeaderBackgroundAlternate""><B>名称</B></td>" & Chr(13) & Chr(10)
		Response.Write " <td width=""20%"" class=""forumHeaderBackgroundAlternate""><B>链接类型</B></td>" & Chr(13) & Chr(10)
		Response.Write " <td width=""30%"" class=""forumHeaderBackgroundAlternate""><B>操 作</B></td>" & Chr(13) & Chr(10)
		Response.Write " <td width=""10%"" class=""forumHeaderBackgroundAlternate""><B>状 态</B></td>" & Chr(13) & Chr(10)
		Response.Write " </tr>" & Chr(13) & Chr(10)
		j = (CurrentPage - 1) * maxperpage + 1
		Do While Not Rs.EOF And ii < Rs.pagesize
			Response.Write " <tr align=center>" & Chr(13) & Chr(10)
			Response.Write " <td height=25 class=forumrow><font color=red>"
			Response.Write j
			Response.Write "</font></td>" & Chr(13) & Chr(10)
			Response.Write " <td class=forumrow><a href="
			Response.Write Rs("Lurl")
			Response.Write " target=_blank>"
			Response.Write Rs("Linkname")
			Response.Write "</a></td>" & Chr(13) & Chr(10)
			Response.Write " <td class=forumrow>"
			If Rs("islogo") = 1 Then
				Response.Write "LOGO链接"
			Else
				Response.Write "文字链接"
			End If
			Response.Write "</td>" & Chr(13) & Chr(10)
			Response.Write " <td class=forumrow> <a href=""admin_link.asp?action=edit&id="
			Response.Write Rs("Linkid")
			Response.Write """><u>编辑</u></a> | <a href=""admin_link.asp?action=lock&id="
			Response.Write Rs("linkid")
			Response.Write """><u>锁定</u></a> | <a href=""admin_link.asp?action=free&id="
			Response.Write Rs("linkid")
			Response.Write """><u>解锁</u></a> | <a href=""admin_link.asp?action=del&id="
			Response.Write Rs("linkid")
			Response.Write """ onclick=""{if(confirm('此操作将删除本友情连接\n 您确定执行此操作吗?')){this.document.myform.submit();return true;}return false;}""><u>删除</u></a></td>" & Chr(13) & Chr(10)
			Response.Write " <td height=25 class=forumrow>"
			If Rs("isLock") = 0 Then
				Response.Write "正常"
			Else
				Response.Write "<font color=red>锁定</font>"
			End If
			Response.Write "</td>" & Chr(13) & Chr(10)
			Response.Write " </tr>" & Chr(13) & Chr(10)
			Rs.movenext
			j = j + 1
			ii = ii + 1
		Loop
		Rs.Close
		Set Rs = Nothing
	Else
		Response.Write ("暂时还没有任何友情连接")
	End If
	Response.Write "<tr><td colspan=5 class=forumRowHighlight>"
	Call showpage
	Response.Write "</td></tr>"
	Response.Write "</table>"
End Sub
Private Sub savenew()
	Dim linknum
	If Request("url") <> "" And Request("readme") <> "" And Request("name") <> "" Then
		Set Rs = CreateObject("adodb.recordset")
		SQL = "select * from [NC_link] order by Linkid desc"
		Rs.Open SQL, Conn, 1, 3
		If Rs.EOF And Rs.bof Then
			linknum = 1
		Else
			linknum = Rs("Linkid") + 1
		End If
		SQL = "insert into NC_link(Linkid,Linkname,readme,logo,Lurl,islogo,isLock) values(" & linknum & ",'" & Trim(Request.Form("name")) & "','" & Trim(Request.Form("readme")) & "','" & Trim(Request.Form("logo")) & "','" & Request.Form("url") & "','" & Request.Form("islogo") & "',0)"
		Conn.Execute (SQL)
		Rs.Close
		Set Rs = Nothing
		NC_Admin.Succeed_Msg("添加成功，请继续其他操作。")
	Else
		ErrMsg = ErrMsg + "<br>" + "请输入完整友情链接信息。"
		Founderr = True
		Exit Sub
	End If
End Sub

Private Sub savedit()
	Dim Rs,SQL
	Set Rs = CreateObject("adodb.recordset")
	SQL = "select * from [NC_Link] where Linkid=" & Request("id")
	Rs.Open SQL, Conn, 1, 3
		Rs("Linkname") =  Request.Form("name")
		Rs("readme") = Request.Form("readme")
		Rs("logo") = Request.Form("logo")
		Rs("Lurl") = Request.Form("url")
		Rs("islogo") = Request.Form("islogo")
		NC_Admin.Succeed_Msg ("更新成功，请继续其他操作。")
				Rs.Update
	Rs.Close
	Set Rs = Nothing
End Sub
Private Sub del()
	Dim id
	id = Request("id")
	SQL = "delete from [NC_link] where Linkid=" + id
	Conn.Execute (SQL)
	NC_Admin.Succeed_Msg ("删除成功，请继续其他操作。")
	Call cache_link
End Sub
Private Sub locklink()
	Dim id
	id = Request("id")
	Conn.Execute ("update [NC_link] set islock=1 where Linkid=" + id)
	NC_Admin.Succeed_Msg ("锁定操作成功，请继续其他操作。")
	Call cache_link
End Sub
Private Sub freelink()
	Dim id
	id = Request("id")
	Conn.Execute ("update [NC_link] set islock=0 where Linkid=" + id)
	NC_Admin.Succeed_Msg ("解除锁定操作成功，请继续其他操作。")
	Call cache_link
End Sub
Private Sub showpage()
	Response.Write "<table width=""96%"" border=""0"" align=""center"" cellpadding=""0"" cellspacing=""2"">" & Chr(13) & Chr(10)
	Response.Write " <tr><form method=""POST"" action="""
	Response.Write PageName
	Response.Write """ >" & Chr(13) & Chr(10)
	Response.Write " <td class=""td1"" align=""center"">共有"
	Response.Write totalnumber
	Response.Write "个 <a href="
	Response.Write PageName
	Response.Write "?page=1 title=返回第一页><font face=""Webdings"">97</font></a> "
	For i = pagestart To pageend
		If i = 0 Then
			i = 1
		End If
		strurl = "<a href=" & PageName & "?page=" & i & " title=第" & i & "页>[" & i & "]</a>"
		Response.Write strurl
		Response.Write " "
	Next
	Response.Write "<a href="
	Response.Write PageName
	Response.Write "?page="
	Response.Write maxpagecount
	Response.Write " title=尾页><font face=""Webdings"">8:</font></a> 页次:<font color=red>"
	Response.Write CurrentPage
	Response.Write "</font> / "
	Response.Write maxpagecount
	Response.Write "页 每页:"
	Response.Write maxperpage
	Response.Write " 转到:<select name='page' align=""absmiddle"" size='1' style=""font-size: 9pt"" onChange='javascript:submit()'>" & Chr(13) & Chr(10)
	Response.Write " "
	For i = 1 To n
		Response.Write " <option value='"
		Response.Write i
		Response.Write "' "
		If CurrentPage = CInt(i) Then
			Response.Write " selected "
		End If
		Response.Write ">第"
		Response.Write i
		Response.Write "页</option>" & Chr(13) & Chr(10)
		Response.Write " "
	Next
	Response.Write " </select>" & Chr(13) & Chr(10)
	Response.Write " </td></form>" & Chr(13) & Chr(10)
	Response.Write " </tr>" & Chr(13) & Chr(10)
	Response.Write " </table>" & Chr(13) & Chr(10)
End Sub
%>