📄 linkeaa.asp

📁 个人网站系统,本人基于第三方源码进行更改!
💻 ASP
字号:
<!--#Include file="../Common/Inc_DatConn.asp"-->
<!--#Include file="Common/Inc_Config.asp"-->
<!--#Include file="Common/Inc_Function.asp"-->
<%
'┌─  风云ASP在线  ────────────────────────┐
'│                                                                 │
'│  作者：赵振波.	http://www.fyasp.com	    				    │
'│                                                                 │
'│   Q Q：176189168  										   	    │
'│                                                                 │
'│ Email：fy96@163.com                                             │
'│                                                                 │
'│ 程序定做，系统开发，网站制作，提供高质量的网络产品、技术和服务！│
'│                                                                 │
'│【版权声明】                                                     │
'│                                                                 │
'│     本程序版权归坐看风云所有，未经授权擅自修改、复制或散布本程序│
'│                                                                 │
'│的部分或全部，将承受严厉的民事和刑事处罚，对已知的违反者将给予法 │
'│                                                                 │
'│律范围内的全面制裁。对非法使用此程序所造成的一切后果本人概不负责!│
'│                                                                 │
'└───────────────────  http://www.fyasp.com ──┘
%>
<%if IsTimeOut(Session("strAccount"),Session("strPassWord")) then Response.Redirect "index.asp"%>
<html>
<head>
<title><% = strSiteName%> - 网站后台管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="Common/Site.css" type="text/css">
<script language="javascript">
function EaaLink(ID) {
  popupWin = window.open('Oper.asp?Oper=EaaLink&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function DelLink(ID) {
  popupWin = window.open('Oper.asp?Oper=DelLink&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
</script>
</head>

<body leftMargin="0" topMargin="2">
<!--#Include file="Common/inc_Top.asp"-->
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td width="105" valign="top" style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0)" class="bottom"><br>
	<!--#Include file="Common/Inc_Button.asp"-->
    </td>
    <td valign="top" style="border-right: 1px solid rgb(0,0,0)" align="center">
      <table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
         <td height="50">当前位置：<a href="Main.asp">管理首页</a> -&gt; 链接管理</td>
        </tr>
      </table>
      <table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
	    <tr>
		  <td width="50%" height="25"><input Onclick="parent.location.href='AddLink.asp'" type="button" value="添 加" name="Button" class="button">
		  <%
			if Session("intUserLevel") > 2 then
				Response.Write "&nbsp;<input onclick=""parent.location.href='LinkMgr.asp'"" type=""button"" value=""管 理"" class=""button"">"
			end if
			%>
		  </td>
		  <form method="post" action="LinkEaa.asp" name="Form1">
		  <td width="50%" height="25" align="right">网站名称：<input type="text" name="KeyWord" size="20" value="<% = Request("KeyWord")%>" class="face"> <input type="submit" name="Submit" value="搜" class="button"></td>
		  </form>
		</tr>
	  </table>
	  <table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
	    <tr>
	      <td width="100%" class="booktable">
			<table border="0" width="100%" cellspacing="1" cellpadding="0">
			  <tr>
			    <td width="10%" height="30" class="bottom" align="center">编 号</td>
			    <td width="46%" height="30" class="bottom" align="center">标 题</td>
			    <td width="10%" height="30" class="bottom" align="center">状 态</td>
			    <td width="12%" height="30" class="bottom" align="center">添加时间</td>
			    <td width="12%" height="30" class="bottom" align="center">操 作</td>
			  </tr>
<%
Dim rdsLink    '/通告的数据库对象及SQL语句/
Dim sqlLink
Dim rdsTotalRec   
Dim strKeyWord    '/关键字/
Dim intPage       '/当前页/
Dim intTotalRec	  '/所有记录/
Dim intLinkCot	  '/通告条数/
Dim intLinkCount
Dim n,p,ii	      '/定义一些临时变量/
Dim strState

strKeyWord = Request("KeyWord")

intPage = Trim(Request("Page"))
if intPage = "" then
	intPage = 1
else
	intPage = Clng(intPage)
end if

intLinkCot = 10

set rdsLink = Server.CreateObject("ADODB.Recordset")
if strKeyWord <> "" then
	set rdsTotalRec = Conn.Execute("Select Count(LinkKey) From Dat_Link Where State = 0 And Homepage like '%"& strKeyWord &"%'")
	intTotalRec = rdsTotalRec(0)
	sqlLink = "Select * From Dat_Link Where State = 0 And Homepage like '%"& strKeyWord &"%' Order By LinkKey Desc"
else
	set rdsTotalRec = Conn.Execute("Select Count(LinkKey) From Dat_Link Where State = 0")
	intTotalRec = rdsTotalRec(0)
	sqlLink = "Select * From Dat_Link Where State = 0 Order By LinkKey Desc"
end if
rdsLink.Open sqlLink,Conn,1,1
if not rdsLink.EOF then
	if intTotalRec mod intLinkCot = 0 then
		n = intTotalRec \ intLinkCot
	else
		n = intTotalRec \ intLinkCot + 1
	end if
	rdsLink.MoveFirst
	if intPage > n then intPage = n
	if intPage < 1 then intPage = 1
	rdsLink.Move (intPage - 1) * intLinkCot
	do while not rdsLink.EOF and intLinkCount < Clng(intLinkCot)
		intLinkCount = intNewsCount + 1
		if rdsLink("State") = 0 then
			strState = "<font color=""red"">关闭</font>"
		end if
%>			  	  
			  <tr>
			    <td height="25" align="center" class="banma1"><% = rdsLink("LinkKey")%></td>
			    <td height="25" class="banma2">&nbsp;<% = rdsLink("Homepage")%></td>
			    <td height="25" align="center" class="banma1"><% = strState%></td>
			    <td height="25" align="center" class="banma1"><% = FormatTime(rdsLink("CreateTime"),4)%></td>
			    <td height="25" align="center" class="banma2"><a href="javascript:EaaLink(<% = rdsLink("LinkKey")%>)"><img border="0" src="<% = strImageUrl%>move.gif" align="absmiddle" alt="审批"></a>&nbsp;&nbsp;&nbsp;<a href="javascript:DelLink(<% = rdsLink("LinkKey")%>)"><img border="0" src="<% = strImageUrl%>del.gif" align="absmiddle" alt="删除"></a></td>
			  </tr>
<%
		rdsLink.MoveNext
	loop
else
	Response.Write "<tr><td width=""100%"" height=""25"" colspan=""5"" class=""banma1"">&nbsp;<font color=""#FF0000"">没有链接信息...</font></td></tr>"
end if
rdsLink.Close
set rdsLink = nothing

if intPage - 1 mod 10 = 0 then
	p = (intPage - 1) \ 10
else
	p = (intPage - 1) \ 10
end if	
%>	  
			</table>		
	      </td>
		</tr>
	  </table>
	  <table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
	    <form method="post" action="LinkEaa.asp" name="Form2">
	    <input type="hidden" name="KeyWord" value="<% = strKeyWord%>">
	    <tr>
		  <td width="30%" height="30" valign="middle">页次：<b><%= intPage %></b>/<b><%= n %></b>页 每页<b><%= intLinkCot %></b>条 共<b><%= intTotalRec %></b>条</td>
		  <td width="70%" height="30" valign="middle"><div align="right">分页：
			<%
				if intPage = 1 then
					Response.Write "<font face=webdings>9</font>   "
				else
					Response.Write "<a href='?Page=1&KeyWord="& strKeyWord &"' title=首页><font face=webdings>9</font></a>   "
				end if
				if p * 10 > 0 then Response.Write "<a href='?Page="&Cstr(p*10)&"&KeyWord="& strKeyWord &"' title=上十页><font face=webdings>7</font></a>   "
				Response.Write "<b>"
				for ii = p * 10 + 1 to P * 10 + 10
					   if ii = intPage then
				          Response.Write "<font color=""#FF0000"">"+Cstr(ii)+"</font> "
					   else
					      Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"'>"+Cstr(ii)+"</a>   "
					   end if
					if ii = n then exit for
				next
				Response.Write "</b>"
				if ii < n then Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"' title=下十页><font face=webdings>8</font></a>   "
				if intPage=n then
					Response.Write "<font face=webdings>:</font>   "
				else
					Response.Write "<a href='?Page="&Cstr(n)&"&KeyWord="& strKeyWord &"' title=尾页><font face=webdings>:</font></a>   "
				end if
			%>
			转到：<input type="text" name="Page" size="2" maxlength="10" value="<%= intPage %>" class="face"> <input type="submit" value="Go" name="submit" class="button">
			</div></td>
		</tr>
		</form>
	  </table>
	  <br>
    </td>
  </tr>
</table>
<!--#Include file="Common/Inc_Bottom.asp"-->
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -