www.gusucode.com > 盐城分类信息网asp源码程序 > admin/xinxi.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: #DBE4EE; 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="xinxi_yz.asp"; thisForm.submit(); } } if (id==2) { { thisForm.target='_self'; thisForm.action="xinxi_del.asp"; thisForm.submit(); } } if (id==3) { { thisForm.target='_self'; thisForm.action="xinxi_tj.asp"; thisForm.submit(); } } if (id==4) { { thisForm.target='_self'; thisForm.action="xinxi_tjdel.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> </p> <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 width="100%" height="24" colspan="6" bgcolor="#D8E1EB"> <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="285" height="31" bgcolor="#E4EBF1"> <FORM name=sou1 action="?cnmai=1" method=POST style="line-height: 150%; margin-top: 0; margin-bottom: 0"> <p align="center">按帐号:<input type="text" name="T1" size="10"> <input type="submit" value="查找" name="B1"> </form> </td> <td width="285" height="31" bgcolor="#E4EBF1"> <FORM name=sou2 action="?cnmai=2" method=POST style="line-height: 150%; margin-top: 0; margin-bottom: 0"> <p align="center">按姓名: <input type="text" name="T2" size="10"> <input type="submit" value="查找" name="B1"> </form> </td> <td width="285" bgcolor="#E4EBF1"> <FORM name=sou3 action="?cnmai=3" method=POST style="line-height: 150%; margin-top: 0; margin-bottom: 0"> <p align="center">按关键词: <input type="text" name="T3" size="10"> <input type="submit" value="查找" name="B1"> </form> </td> </tr> <tr> <td width="864" colspan="3" height="28"> <p align="center"><a href="?cnmai=4">未(<font color="#FF0000">ⅹ</font>)验证信息</a>---<a href="?cnmai=5">已(√)验证的信息</a>---<a href="?cnmai=6">未推荐信息</a>---<a href="?cnmai=7">推荐信息</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 [xinxi] where username='"&trim(request("T1"))&"' order by b desc" Case "2" sql="select * from [xinxi] where name like '%"&trim(request("T2"))&"%' order by b desc" Case "3" sql="select * from [xinxi] where biaoti like '%"&trim(request("T3"))&"%' or memo like '%"&trim(request("T3"))&"%' order by b desc" Case "4" sql="select * from [xinxi] where yz<>1 order by fbsj desc" Case "5" sql="select * from [xinxi] where yz=1 order by fbsj desc" Case "6" sql="select * from [xinxi] where tuijian<>1 order by fbsj desc" Case "7" sql="select * from [xinxi] where tuijian=1 order by fbsj desc" Case Else sql="select * from [xinxi] order by fbsj 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=20 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 height="30" align="center" bgcolor="#C5D5E4" > </td> <td bgcolor="#C5D5E4" >标题</td> <td bgcolor="#C5D5E4" > <p align="center">姓名</td> <td bgcolor="#C5D5E4" > <p align="center">日期</td> <td bgcolor="#C5D5E4" > <p align="center">验证</td> <td bgcolor="#C5D5E4" align="center"> 操作</td> </tr> <% dim uid do while not rs.eof uid=rs("id") %> <tr onMouseOver="this.style.backgroundColor='#EFE8D6';return true;" onMouseOut="this.style.backgroundColor='#FFFFFF';"> <td height="24" align="center" bgcolor="#E4EBF1" > <INPUT type=checkbox value="<%=uid%>" name=selectedid></td> <td bgcolor="#E4EBF1" ><%if rs("tupian")<>"0" then%><img src="../image/pic.gif"><%end if%><a target="_blank" href=../x.asp?cnmai=<%=uid%>><%=rs("biaoti")%></a><%if rs("tuijian")=1 then%><font color="#FF0000">[推荐]</font><%end if%></td> <td width="55" align="center" bgcolor="#E4EBF1" ><a target="_blank" href=../per.asp?username=<%=rs("username")%>><%=rs("name")%></td> <td width="140" align="center" bgcolor="#E4EBF1" ><%=rs("fbsj")%></td> <td width="30" align="center" bgcolor="#E4EBF1" ><%if rs("yz")=1 then%>√<%else%><b><font color="#FF0000">ⅹ</font></b><%end if%></td> <td width="40" bgcolor="#E4EBF1"> <p align="center"><font color="#FF0000"><span id="followImg<%=k%>" style="CURSOR: hand" onClick="loadThreadFollow(<%=k%>,5)"> 管理</span></font></td> </tr> <tr style="display:none" id="follow<%=k%>"> <td height="24" colspan="6" bgcolor="#FFF8EC"> <div align="center"> <center> <table width="98%" 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 align="center" bgcolor="#E4EBF1"><a href="xinxi_del.asp?selectedid=<%=uid%>"> <font color="#0000FF">删除该信息</font></a></td> <td align="center" bgcolor="#E4EBF1"><a href="xinxi_hfdel.asp?selectedid=<%=uid%>">删除所有回复</a></td> <td align="center" bgcolor="#E4EBF1"><a href="xinxi_edit.asp?id=<%=uid%>">编辑该信息</a></td> <td align="center" bgcolor="#E4EBF1"><a href="#" ONCLICK="window.open('xinximail.asp?id=<%=uid%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=355,height=328,left=300,top=100')">发送邮件</a></td> <td width="160" align="center" bgcolor="#E4EBF1"><a target="_blank" title="查看发布IP" href="http://www.52.la/Sub/IP/ListAddress.asp?ip=<%=rs("ip")%>"> <font color="#FF0000">发布者IP:<%=rs("ip")%></font></a></td> <td align="center" bgcolor="#E4EBF1"><%if rs("tuijian")=0 then%><a href="xinxi_tj.asp?selectedid=<%=uid%>">推荐该信息</a><%else%><a href="xinxi_tjdel.asp?selectedid=<%=uid%>">取消推荐</a><%end if%></td> <td align="center" bgcolor="#E4EBF1"><%if rs("yz")=0 then%><a href="xinxi_yz.asp?selectedid=<%=uid%>">通过验证</a><%end if%></td> </tr> </table> </center> </div> </td> </tr> <% k=k+1 rs.movenext if k>=Pagesize then exit do loop rs.close set rs=nothing closedb %> <tr> <td width="100%" height="1" colspan="6" bgcolor="#F3F7FA" 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="595" height="25" colspan="3" bgcolor="#E4EBF1"> <p align="left"> <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"> <input onclick=javascript:showoperatealert(3) type="submit" value="推荐" name="B3" style="color: #FF0000"> <input onclick=javascript:showoperatealert(4) type="submit" value="取消推荐" name="B4"></td> <td width="595" height="25" bgcolor="#E4EBF1"> <p align="center"> </td> </tr> <tr> <td height="25" width="595" align="center"> 共有 <font color="#CC5200"><%=Allrecord%></font> 条记录</td> <td height="25" width="595" align="center"> 共 <font color="#CC5200"><%=Allpage%></font> 页</td> <td height="25" width="595" align="center"> 现在是第 <font color="#CC5200"><%=ThisPage%></font> 页</td> <td height="25" width="595" align="center"> <% 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 width="100%" 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(3) border="0" src="img/ershou_3.gif"> <img style="CURSOR: hand" onclick=javascript:showoperatealert(2) border="0" src="img/ershou_1.gif"></td> </tr> </form> <tr> <td width="100%" height="1" colspan="6" style="border-top-style: solid; border-top-width: 1"></td> </tr> </table> </div>