📄 user_xxgl.asp
字号:
<!--#include file=conn1.asp-->
<!--#include file=usercookies.asp-->
<!--#include file="config.asp"-->
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=title%>-信息管理</title>
<link href="inc_style.css" rel="stylesheet" type="text/css">
</head>
<SCRIPT language=JavaScript>
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;
}
}
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>
<body topmargin="0" leftmargin="0">
<!--#include file=usertop.asp-->
<div align="center">
<center>
<table border="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" width="760" height="191">
<tr>
<td width="157" height="191" valign="top">
<!--#include file=userleft.asp--></td>
<td width="10" height="191" background="images/line_01.gif"> </td>
<td width="606" height="191" valign="top" align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="111" bgcolor="#F1FAE6">
<FORM name=thisForm action="xinxi_del.asp" method=POST>
<tr>
<td width="94%" height="1" colspan="8"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="26">
<tr>
<td width="100%" background="images/xxgl.gif" height="26"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="6%" height="27" align="center" background="images/bar_bg3.gif">
<p>编号</td>
<td width="13%" height="27" align="center" background="images/bar_bg3.gif">
<span lang="zh-cn">类别</span></td>
<td width="45%" height="27" align="center" background="images/bar_bg3.gif">
标 题</td>
<td width="12%" height="27" align="center" background="images/bar_bg3.gif">
浏览/回复</td>
<td width="11%" height="27" align="center" background="images/bar_bg3.gif">
发布时间</td>
<td width="6%" height="27" align="center" background="images/bar_bg3.gif">
</td>
<td width="4%" height="27" align="center" background="images/bar_bg3.gif">验证</td>
<td width="8%" height="27" align="center" background="images/bar_bg3.gif">
</td>
</tr>
<%
dim username,rs,sql,i,rs1,sql1,id,ii,rslx
dim ThisPage,Pagesize,Allrecord,Allpage
i=0
ii=1
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
username=request.cookies("cnmai")("username")
set rs = Server.CreateObject("ADODB.RecordSet")
set rslx = Server.CreateObject("ADODB.RecordSet")
sql="select * from [xinxi] where username='"&username&"' order by fbsj desc"
rs.open sql,conn,1,1
if rs.eof then
response.write "<tr><td></td><td><li>没有记录</td></tr>"
else
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
do while not rs.eof
id=rs("id")
sql="select * from class1 where id="&rs("class1")&" "
rslx.open sql,conn,1,1
%>
<tr>
<td width="6%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%=i+1%>
</td>
<td width="13%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
[<%=rslx("class1")%>]</td>
<td width="45%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="left"><a target="_blank" href="<%=rslx("memopage")%>?cnmai=<%=id%>"><%=rs("biaoti")%></a></td>
<td width="12%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%=rs("llcs")%>/<%=rs("hfcs")%></td>
<td width="11%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%=datevalue(rs("fbsj"))%>
</td>
<td width="6%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<font color="#666666">
<span id="followImg<%=i%>" style="CURSOR: hand" onClick="loadThreadFollow(<%=i%>,5)">管理</span></font></td>
<td width="4%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%if rs("yz")=1 then%><font color="#008000">√</font><%else%><font color="#FF0000">ⅹ</font><%end if%>
</td>
<td width="8%" height="26" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<input type="checkbox" name="selectedid" value="<%=id%>"></td>
</tr>
<tr style="display:none" id="follow<%=i%>">
<td width="101%" height="25" align="center" style="border-bottom-style: none; border-bottom-width: medium" colspan="8">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="100%">
<tr>
<td width="17%" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#E1E1E1" align="center">
<font color="#CC5200"><a href="xinxi_del.asp?selectedid=<%=id%>">
<font color="#FF0000">删除</font></a></font></td>
<td width="17%" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#E1E1E1" align="center">
<a href="<%=rslx("editpage")%>?id=<%=id%>">修改</a></td>
</tr>
</table>
</td>
</tr>
<%
i=i+1
rslx.close
rs.movenext
if i>=Pagesize then exit do
loop
end if
%> <tr>
<td width="99%" height="25" colspan="8">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td height="25" width="151">
<p align="center">
</td>
<td height="25" width="126">
<p align="center"> </td>
<td height="25" width="118">
<p align="right"> </td>
<td height="25" width="200">
<p align="center">
<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有记录
<input type="submit" value="删除" name="B1"></td>
</tr>
<tr>
<td height="25" width="151" align="center">
共有 <font color="#CC5200"><%=Allrecord%></font> 条记录</td>
<td height="25" width="126" align="center">
共 <font color="#CC5200"><%=Allpage%></font> 页</td>
<td height="25" width="118" align="center">
现在是第
<font color="#CC5200"><%=ThisPage%></font> 页</td>
<td height="25" width="200" 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>首页</a> "
response.write "<a href=?page="&ThisPage-1&">上一页</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)&">下一页</a> "
response.write "<a href=?page="&Allpage&">尾页</a> "
end if
%></td>
</tr>
<tr>
<td height="25" width="595" colspan="4">
<p align="right"> </td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</td>
<td width="5" height="191" background="images/line_01.gif"> </td>
</tr><!--#include file=end.htm-->
</table>
</center>
</div>
</body>
</html>
<%
rs.close
set rs=nothing
set rslx=nothing
closedb
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -