liuchen_more.asp
来自「房地产管理系统 vb写的,很不错!!!!!!!!!!!」· ASP 代码 · 共 370 行 · 第 1/2 页
ASP
370 行
do while not rs.eof
%>
<tr>
<td width="20" height="21"> <div align="right">
<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
<td width="232" height="21" style="CURSOR: hand" ><a href=../house/liuchen_detail.asp?newsid=<%=trim(rs("newsid"))%>&sort=12><font color=#ffffff><%=left(trim(rs("topic")),13)%></font></a></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
<tr>
<td height="23" align="right">
<a href="liuchen_more.asp?sort=12"><font color="#FFFFFF">更多</a> </td>
</tr>
<tr>
<td height="38" align="right" background="../img/36.gif">
<p align="left"> <font color="#FFFFFF"><b>家 居 物 业</b></td>
</tr>
<tr>
<td height="26" align="right">
<table width="252" border="0" cellpadding="0" cellspacing="0" class="main">
<%
set rs=server.CreateObject("adodb.recordset")
sql="select top 6 * from news where sort=13 order by dnt desc"
rs.open sql,conn,1,1
do while not rs.eof
%>
<tr>
<td width="21" height="21"> <div align="right">
<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
<td width="231" height="21" style="CURSOR: hand"><a href=../house/liuchen_detail.asp?newsid=<%=trim(rs("newsid"))%>&sort=13><font color=#ffffff><%=left(trim(rs("topic")),13)%></font></a></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
<tr>
<td height="23" align="right"><a href="liuchen_more.asp?sort=13"><font color="#FFFFFF">更多</font></a> </td>
</tr>
<tr>
<td height="23" align="right"> </td>
</tr>
<tr>
<td height="23" align="right"> </td>
</tr>
<tr>
<td height="23" align="right"> </td>
</tr>
<tr>
<td height="23" align="right"> </td>
</tr>
</TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR></TR>
<TR>
</TR></TBODY></TABLE>
<div align="right">
<TABLE height=30 cellSpacing=0 cellPadding=0 width=710 border=0>
<TBODY>
<TR>
<TD width=5><IMG height=30 src="../img/news1a.gif" width=5></TD>
<TD width=150 background=../img/news4a.gif>
<IMG height=9
src="../img/arr_w2.gif" width=9>
<a href="liuchen_more.asp?sort=<%=Trim(Request("sort"))%>" class="linkone"><font color="#FFFFFF" ><strong>
<!--#include file="../admin/sort2.asp"-->
</strong></font></a></TD>
<TD width=5><IMG height=30 src="../img/news2a.gif" width=5></TD>
<TD background=../img/news5a.gif> </TD>
<TD width=5><IMG height=30 src="../img/news3a.gif"
width=5></TD></TR></TBODY></TABLE>
</div>
<TABLE height=3 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<div align="right">
<TABLE class=out4s_green cellSpacing=0 cellPadding=0 width=705 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<TABLE height=5 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=700 align=center
border=0><TBODY>
<table width="97%" height="113" border="0" align="center" cellpadding="0" cellspacing="0" class="main">
<%
dim curpage
if request.querystring("curpage")="" then
curpage=1
else
curpage=request.querystring("curpage")
end if
const numperpage=40
sortnum=trim(request("sort"))
set rs=server.createobject("adodb.recordset")
sql="select * from news where sort="&sortnum&" order by dnt desc"
rs.open sql,conn,1,1
if not rs.eof then
rs.pagesize=numperpage
dim totalpages
totalpages=rs.pagecount
rs.absolutepage=curpage
end if
dim count
count=0
do while not rs.eof and count<numperpage
%>
<tr>
<td width="9%" height="20"> <div align="center">
<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
<td width="91%" height="22"><a href=liuchen_detail.asp?newsid=<%=trim(rs("newsid"))%>&sort=<%=trim(rs("sort"))%>><class="linkone" ><%=getStr(rs("topic"),27)%></a>
<%if trim(rs("imgname"))<>"" and isNull(trim(rs("imgname"))) then response.write "(图)" end if%>
</a><font color="#666666"> ( <%=Year(Rs("dnt"))&"-"&Month(Rs("dnt"))&"-"&Day(Rs("dnt"))%>)</font></td>
</tr>
<%
rs.movenext
count=count+1
loop
rs.close
set rs=nothing
%>
<tr>
<td height="50" colspan="2"> <div align="center" class="p12">
<span class="black">
<% if cint(curpage)<>1 then %>
<a href="liuchen_more.asp?curpage=1&sort=<%=trim(request("sort"))%>" class="linkone">首页 </a>
<% else %>
首页
<% end if %>
<% if cint(curpage)>1 then %>
<a href="liuchen_more.asp?curpage=<%=curpage-1%>&sort=<%=trim(request("sort"))%>" class="linkone">上一页 </a>
<% else %>
上一页
<% end if %>
<% if cint(curpage)<>cint(totalpages) then %>
</span><span><a href="liuchen_more.asp?curpage=<%=curpage+1%>&sort=<%=trim(request("sort"))%>" class="linkone">下一页</a><a href="liuchen_more.asp?curpage=<%=curpage+1%>&sort=<%=trim(request("sort"))%>"></a></span><span class="black"><a href="liuchen_more.asp?curpage=<%=curpage+1%>&sort=<%=trim(request("sort"))%>" class="linkone">
<% else %>
下一页
<% end if %>
<% if cint(curpage)<>cint(totalpages) then %>
</a><a href="liuchen_more.asp?curpage=<%=totalpages%>&sort=<%=trim(request("sort"))%>" class="linkone"> 末页
<% else %>
末页
<% end if %>
</a> 第<font color="#FF0000"><%=curpage%></font>页/共<%=totalpages%>页 </span> </div></td>
</tr>
</table></TR></TBODY></TABLE>
</div>
<TABLE height=5 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<div align="right">
<TABLE cellSpacing=0 cellPadding=0 width=708
background=../img/bomgreen2.gif border=0>
<TBODY>
<TR>
<TD width=20>
<IMG height=27 src="../img/bomgreen1.gif"
width=13></TD>
<TD align=right>
</TD></TR></TBODY></TABLE></div>
</TD></TR></TBODY></TABLE>
<!--#include file="../end.asp"-->
</BODY></HTML>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?