📄 list_big.asp
字号:
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
<td width="8" valign="top"></td>
<td valign="top">
<table border="0" width="100%" id="table2" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0" class="t1">
<tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td height="36" align="center" onmouseover="this.className='tbb'" onmouseout="this.className='taa'" class="taa"><strong><%=topic%></strong></td>
</tr>
<tr>
<td align=center><br>
<table border="0" width="98%" cellspacing="0" cellpadding="0">
<tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<%
rs.open"select * from assort where shuxing="&id&" order by paixu",conn,1,1
if rs.eof then%>
<tr>
暂时没有分类!
<%else
while not rs.eof
i=i+1
rs2.open"select * from question where fenleiid="&rs("id")&"",conn,1,1
totalquestion=rs2.recordcount
rs2.close
%>
<td> ·<a href=List_Little.asp?id=<%=rs("id")%>&topic=<%=rs("topic")%>><%=rs("topic")%></a> (<%=totalquestion%>)</td>
<%rs.movenext
if i>=3 then
i=0%>
</tr>
<%end if
wend
end if
rs.close
%>
</table>
</tr>
</table></td>
</tr>
</table>
<br></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="0" class="t1">
<tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td height="36" align="center" onmouseover="this.className='tbb'" onmouseout="this.className='taa'" class="taa"><div align="left"><img src="img/wtlb.gif" alt="问题列表" width="400" height="36" /></div></td>
</tr>
<tr>
<td align=center><br>
<table border="0" width="98%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="184" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="24" valign="bottom" class="<%if jie="" then%>bgtabCr<%else%>bgtab<%end if%>" align="center"><div align="center"><%if jie="" then%>全部的问题<%else%><a href="List_Big.asp?id=<%=id%>&topic=<%=topic%>">全部的问题</a><%end if%></div></td>
<td width="10" align="center"></td>
<td valign="bottom" class="<%if jie="1" then%>bgtabCr<%else%>bgtab<%end if%>" align="center"><div align="center"><%if jie="1" then%>已解决问题<%else%><a href="List_Big.asp?id=<%=id%>&topic=<%=topic%>&jie=1">已解决问题</a><%end if%></div></td>
<td width="10" align="center"></td>
<td valign="bottom" class="<%if jie="0" then%>bgtabCr<%else%>bgtab<%end if%>" align="center"><div align="center"><%if jie="0" then%>待解决问题<%else%><a href="List_Big.asp?id=<%=id%>&topic=<%=topic%>&jie=0">待解决问题</a><%end if%></div></td>
<td width="10" align="center"></td>
<td valign="bottom" class="<%if jie="4" then%>bgtabCr<%else%>bgtab<%end if%>" align="center"><div align="center"><%if jie="4" then%>投票中问题<%else%><a href="List_Big.asp?id=<%=id%>&topic=<%=topic%>&jie=4" >投票中问题</a><%end if%></div></td>
<td width="10" align="center"></td>
<td valign="bottom" class="<%if jie="3" then%>bgtabCr<%else%>bgtab<%end if%>" align="center"><div align="center"><%if jie="3" then%>高分的问题<%else%><a href="List_Big.asp?id=<%=id%>&topic=<%=topic%>&jie=3" >高分的问题</a><%end if%></div></td>
<td width="10" align="center"></td>
<td valign="bottom" class="<%if jie="2" then%>bgtabCr<%else%>bgtab<%end if%>" align="center"><div align="center"><%if jie="2" then%>零回答问题<%else%><a href="List_Big.asp?id=<%=id%>&topic=<%=topic%>&jie=2" >零回答问题</a><%end if%></div></td>
<td valign="bottom" align="center"> </td>
</tr>
</table>
<%
rs2.open"select * from class where id="&id,conn,1,1
shu=rs2("id")
if jie="0" then
rs.open"select * from question where shuxing="&shu&" and jie=0 order by sendtime desc",conn,1,1
elseif jie="1" then
rs.open"select * from question where shuxing="&shu&" and jie=1 order by views desc",conn,1,1
elseif jie="2" then
rs.open"select * from question where shuxing="&shu&" and replys=0 order by sendtime desc",conn,1,1
elseif jie="3" then
rs.open"select * from question where shuxing="&shu&" and shang>0 order by shang desc",conn,1,1
elseif jie="4" then
rs.open"select * from question where shuxing="&shu&" and jie=4 order by sendtime desc",conn,1,1
elseif jie<>"0" or jie <>"1" or jie<>"2" or jie<>"3" or jie<>"4" or jie="" then
rs.open"select * from question where shuxing="&shu&" order by sendtime desc",conn,1,1
end if
totalquestion1=rs.recordcount
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr class="t11">
<td height="24" class="bglne"><div align="right">共有相关问题 <%=totalquestion1%>
项</div></td>
</tr> <tr><td height="10"></td></tr></table>
<table width="100%" border="0" cellspacing="0" class=zhtable>
<tr>
<td height="30"> 标题</td>
<td width=40 align=center>回答数</td><td width="32" align="center">状态</td><td width="52" align="center">提问时间</td>
</tr> <%if rs.eof then%>
<tr>
<td height="34" colspan=6>暂时没有问题!</td>
</tr><tr><%else
rs.pagesize=MaxPerPage
maxnum=rs.recordcount
maxpage=rs.pagecount
if request("p")="" then
p=1
else
p=cint(request("p"))
end if
if p>maxpage then
p=maxpage
end if
if p=0 then
p=1
end if
if p<>1 then
rs.move (p-1)*rs.pagesize
end if
for i=1 to rs.pagesize
yue=Month(rs("sendtime"))
ri=day(rs("sendtime"))
%>
<td class="ln28"><span class="f14ln20"><%if rs("shang")>"0" then %><img src="img/icn_ps.gif" alt="悬赏<%=rs("shang")%>分" width="12" height="11" align="absmiddle"><span class="f10rd" title="悬赏<%=rs("shang")%>分"><%=rs("shang")%></span> <%end if%><a href=Show_Question.asp?id=<%=rs("id")%> target=_blank><%if len(rs("title"))>28 then%><%=left(rs("title"),28)&"..."%><%else%><%=rs("title")%><%end if%></a> [<a href=List_Little.asp?id=<%=rs("fenleiid")%>&topic=<%=rs("topic")%> class=lgy><%=rs("topic")%></a>]</span></td>
<td align="center" valign="middle" class="ln28"><%=rs("replys")%></td>
<td align="center" valign="middle" class="ln28"><%if rs("jie")=0 then %><img src=img/icn_time.gif alt=待解决问题><%elseif rs("jie")=1 or rs("jie")=3 then%><img src=img/icn_ok.gif alt =已解决问题><%elseif rs("jie")=2 then%><img src=img/icn_cancel.gif alt =问题已关闭><%elseif rs("jie")=4 then%><img src=img/icn_vote.gif alt =投票中问题><%end if%></td>
<td align="center" valign="middle" class="ln28"><%=yue%>-<%=ri%></td></tr>
<%rs.movenext
if rs.eof then exit for
next%>
</table>
<br>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" class="t11">问题数:<font color=red><%=maxnum%></font> | 每页数:<font color=green><%=rs.pagesize%></font> | 总页数:<font color=green><%=maxpage%></font> | 当前页:<font color=red><%=p%></font>
<a href=List_Big.asp?id=<%=shu%>&p=1&topic=<%=topic%>&jie=<%=jie%>>首页</a>
<a href=List_Big.asp?id=<%=shu%>&p=<%=p-1%>&topic=<%=topic%>&jie=<%=jie%>>上页</a>
<a href=List_Big.asp?id=<%=shu%>&p=<%=p+1%>&topic=<%=topic%>&jie=<%=jie%>>下页</a>
<a href=List_Big.asp?id=<%=shu%>&p=<%=maxpage%>&topic=<%=topic%>&jie=<%=jie%>>尾页</a></td>
</tr>
</table>
<%end if
rs.close
rs2.close
%>
</td>
</tr>
</table>
<br></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<!--#include file=end.asp-->
<%else%>
参数错误!
<%
end if
%><%
Set rs=nothing
Set rs1=nothing
Set rs2=nothing
Set rs3=nothing
conn.Close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -