www.gusucode.com > 盐城分类信息网asp源码程序 > admin/link.asp
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<link href="inc_style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
background-color: #E7EEF5;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style><body>
<p align="center">
<script>
function loadThreadFollow(t_id,b_id){
var targetImg =eval("document.all.followImg" + t_id);
var targetDiv =eval("document.all.follow" + t_id);
if ("object"==typeof(targetImg)){
if (targetDiv.style.display!='block'){
targetDiv.style.display="block";
}else{
targetDiv.style.display="none";
}
}
}
</script>
<SCRIPT language=JavaScript>
function showoperatealert(id)
{
if (id==1)
{
{
thisForm.target='_self';
thisForm.action="link_yz.asp";
thisForm.submit();
}
}
if (id==2)
{
{
thisForm.target='_self';
thisForm.action="link_del.asp";
thisForm.submit();
}
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall' )
e.checked = form.chkall.checked;
}
}
//-->
</SCRIPT>
<div align="center">
<table width="88%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4" style="font-size:12px; letter-spacing:1px;">
<tr bgcolor="#B6EBC4">
<td height="24" colspan="6" bgcolor="#E3EBF2">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="25">
<tr>
<td width="864" height="24" bgcolor="#C5D5E4">
<p align="center"><a href="?cnmai=1">未(<font color="#FF0000">ⅹ</font>)验证链接</a>---<a href="?cnmai=2">已(√)验证的链接</a>---<a href="?cnmai="><font color="#FF0000">显示全部链接</font></a></td>
</tr>
</table>
</td>
</tr>
<FORM name=thisForm action="" method=POST>
<%
dim rs,sql,k,cnmai
dim ThisPage,Pagesize,Allrecord,Allpage
k=1
set rs = Server.CreateObject("ADODB.RecordSet")
cnmai=trim(request("cnmai"))
Select Case cnmai
Case "1"
sql="select * from [link] where yanz<>1 order by jrsj desc"
Case "2"
sql="select * from [link] where yanz=1 order by jrsj desc"
Case Else
sql="select * from [link] order by jrsj desc"
End Select
rs.open sql,conn,1,1
if rs.eof then
response.write "<li>没有记录"
response.end
end if
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
rs.Pagesize=15
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
On Error Resume Next
rs.move (ThisPage-1)*Pagesize
%>
<tr>
<td width="5%" height="24" align="center" bgcolor="#E3EBF2">选择</td>
<td width="15%" height="24" bgcolor="#E3EBF2">
网站名称</td>
<td width="17%" height="24" bgcolor="#E3EBF2">
<p align="center">网站地址</td>
<td width="26%" height="24" bgcolor="#E3EBF2">
<p align="center">LOGO图片</td>
<td width="10%" height="24" bgcolor="#E3EBF2">
<p align="center">验证</td>
<td width="27%" height="24" bgcolor="#E3EBF2"> </td>
</tr>
<%
dim uid
do while not rs.eof
uid=rs("id")
%>
<tr>
<td width="5%" height="24" align="center" bgcolor="#E3EBF2" style="border-top-style: solid; border-top-width: 1">
<INPUT type=checkbox value="<%=uid%>" name=selectedid></td>
<td width="15%" height="24" bgcolor="#E3EBF2" style="border-top-style: solid; border-top-width: 1"><a target="_blank" href=<%=rs("url")%>><%=rs("web")%></a></td>
<td width="17%" height="24" align="center" bgcolor="#E3EBF2" style="border-top-style: solid; border-top-width: 1"><a target="_blank" href=<%=rs("url")%>><%=rs("url")%></td>
<td width="26%" height="24" align="center" bgcolor="#E3EBF2" style="border-top-style: solid; border-top-width: 1"><%if rs("logo")<>"" and rs("logo")<>"http://" then%><IMG src="<%=rs("logo")%>" width="88" height="31"><%else%>没有LOGO图片<%end if%></td>
<td width="10%" height="24" align="center" bgcolor="#E3EBF2" style="border-top-style: solid; border-top-width: 1"><%if rs("yanz")=1 then%>√<%else%><b><font color="#FF0000">ⅹ</font></b><%end if%></td>
<td width="27%" height="24" bgcolor="#E3EBF2" style="border-top-style: solid; border-top-width: 1">
<p align="center"><%if rs("yanz")=0 then%><a href="link_yz.asp?selectedid=<%=uid%>">通过验证</a><%end if%> <a href="link_e.asp?selectedid=<%=uid%>">修改</a> | <a href="link_del.asp?selectedid=<%=uid%>">删除该链接</a></td>
</tr>
<%
k=k+1
rs.movenext
if k>=Pagesize then exit do
loop
rs.close
set rs=nothing
closedb
%>
<tr>
<td height="1" colspan="6" style="border-top-style: solid; border-top-width: 1">
<table width="99%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4" style="font-size:12px; letter-spacing:1px;">
<tr bgcolor="#B6EBC4">
<td width="863" height="33" colspan="4" bgcolor="#E3EBF2">
<p align="center">
<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有 <input onclick=javascript:showoperatealert(1) type="submit" value="验证" name="B1">
<input onclick=javascript:showoperatealert(2) type="submit" value="删除" name="B2"></td>
</tr>
<tr>
<td height="25" width="863" align="center" bgcolor="#C5D5E4">
共有 <font color="#CC5200"><%=Allrecord%></font> 条记录</td>
<td width="863" align="center" bgcolor="#C5D5E4">
共 <font color="#CC5200"><%=Allpage%></font> 页</td>
<td width="863" align="center" bgcolor="#C5D5E4">
现在是第
<font color="#CC5200"><%=ThisPage%></font> 页</td>
<td width="863" align="center" bgcolor="#C5D5E4">
<%
if ThisPage<2 then
response.write "<font color=""#808080"">首页</font> "
response.write "<font color=""#808080"">上一页</font> "
else
response.write "<a href=?page=1&t1="&trim(request("t1"))&"&t2="&trim(request("t2"))&"&t3="&trim(request("t3"))&"&cnmai="&cnmai&">首页</a> "
response.write "<a href=?page="&ThisPage-1&"&t1="&trim(request("t1"))&"&t2="&trim(request("t2"))&"&t3="&trim(request("t3"))&"&cnmai="&cnmai&">上一页</a> "
end if
if Allpage-ThisPage<1 then
response.write "<font color=""#808080"">下一页</font> "
response.write "<font color=""#808080"">尾页</font> "
else
response.write "<a href=?page="&(ThisPage+1)&"&t1="&trim(request("t1"))&"&t2="&trim(request("t2"))&"&t3="&trim(request("t3"))&"&cnmai="&cnmai&">下一页</a> "
response.write "<a href=?page="&Allpage&"&t1="&trim(request("t1"))&"&t2="&trim(request("t2"))&"&t3="&trim(request("t3"))&"&cnmai="&cnmai&">尾页</a> "
end if
%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="39" colspan="6" bordercolor="#999999">
<p align="center"><img style="CURSOR: hand" onclick=javascript:showoperatealert(1) border="0" src="img/ershou_2.gif">
<img style="CURSOR: hand" onclick=javascript:showoperatealert(2) border="0" src="img/ershou_1.gif"></td>
</tr>
</form>
<tr>
<td height="1" colspan="6" style="border-top-style: solid; border-top-width: 1"></td>
</tr>
</table>
</div>