📄 jiazhuang.asp
字号:
<!--#include file="cn.asp"-->
<%if session("admin")="" or request.cookies("timesshop")("admin")="" then
response.Write "<script language='javascript'>alert('请先登录！');window.location.replace('login.asp');</script>"
response.End
end if
%><style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
.STYLE1 {font-size: 14px}
-->
</style>
<%
jz=request.QueryString("jz")
select case jz
case 1
%>
<table width="650" border="0" cellpadding="0" cellspacing="0" align="center">
<!--DWLayoutTable-->
<tr>
<td width="538" height="68" align="center" valign="top" bgcolor="#00CCFF">
<span class="STYLE1">个人家装</span>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="500" height="13" valign="top"><table width="650" border="0" cellpadding="0" cellspacing="0" bgcolor="#B1C3D9">
<tr>
<td width="119" height="20" align="center">发布人</td>
<td width="87" align="center">户型</td>
<td width="82" align="center">价格</td>
<td width="62" align="center">面积</td>
<td width="60" align="center">联系人</td>
<td width="69" align="center">联系电话</td>
<td width="62" align="center">发布日期</td>
<td width="47" align="center">有效期</td>
<td width="62" align="center">详细信息</td>
</tr>
</table></td>
</tr>
<tr>
<td height="21" valign="top"><table width="650" border="0" cellpadding="0" cellspacing="1" bgcolor="#BBCEFD">
<%set rs=server.CreateObject("adodb.recordset")
sql="select * from jzh where leibie='1' order by id desc"
rs.open sql,cn,1,1
if rs.eof then
response.Write "<script language='javascript'>alert('无记录！');window.location.replace('index.asp');</script>"
end if
'分页
jil=rs.recordcount
page=cint(request.QueryString("page"))
rs.pagesize=30
tpage=cint(rs.pagecount)
if page="" or page=0 then
page=1
end if
if page>rs.pagecount then
page=rs.pagecount
end if
rs.Absolutepage=page
do while not rs.eof
%>
<tr>
<td width="117" height="20" align="center" bgcolor="#FFFFFF"><%=rs("user")%></td>
<td width="87" align="center" bgcolor="#FFFFFF"><%=rs("hx")%></td>
<td width="80" align="center" bgcolor="#FFFFFF"><%=rs("jiage")%></td>
<td width="63" align="center" bgcolor="#FFFFFF"><%=left(rs("are"),10)%></td>
<td width="58" align="center" bgcolor="#FFFFFF"><%=rs("man1")%></td>
<td width="69" align="center" bgcolor="#FFFFFF"><%=rs("tel")%></td>
<td width="58" align="center" bgcolor="#FFFFFF"><%=left(rs("addtime"),10)%></td>
<td width="51" align="center" bgcolor="#FFFFFF"><%=rs("date")%>天</td>
<td width="57" align="center" bgcolor="#FFFFFF"><a href="jiazhxx.asp?id=<%=rs("id")%>&user=<%=rs("user")%>">详细信息</a></td>
</tr>
<%
rs.movenext
loop
%>
</table></td>
</tr>
<tr>
<td height="27" align="center" valign="bottom">共<%=jil%>条记录 每页显30示条 共<%=tpage%>页 第<%=page%>页 <a href="jiazhuang.asp?page=1&jz=1">第一页</a> <a href="jiazhuang.asp?page=<%=page+1%>&jz=1">下一页</a> <a href="jiazhuang.asp?page=<%=page-1%>&jz=1">上一页</a> <a href="jiazhuang.asp?page=<%=tpage%>&jz=1">最后一页</a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="300"> </td>
</tr>
</table>
<%
rs.close
set rs=nothing
cn.close
set cn=nothing
case 2
%>
<table width="650" border="0" cellpadding="0" cellspacing="0" align="center">
<!--DWLayoutTable-->
<tr>
<td width="538" height="68" align="center" valign="top" bgcolor="#00CCFF">
<span class="STYLE1">家装案例</span>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="500" height="13" valign="top"><table width="650" border="0" cellpadding="0" cellspacing="0" bgcolor="#B1C3D9">
<tr>
<td width="119" height="20" align="center">发布人</td>
<td width="87" align="center">户型</td>
<td width="82" align="center">价格</td>
<td width="62" align="center">面积</td>
<td width="60" align="center">联系人</td>
<td width="69" align="center">联系电话</td>
<td width="62" align="center">发布日期</td>
<td width="47" align="center">有效期</td>
<td width="62" align="center">详细信息</td>
</tr>
</table></td>
</tr>
<tr>
<td height="21" valign="top"><table width="650" border="0" cellpadding="0" cellspacing="1" bgcolor="#BBCEFD">
<%set rs=server.CreateObject("adodb.recordset")
sql="select * from jzh where leibie='2' order by id desc"
rs.open sql,cn,1,1
if rs.eof then
response.Write "<script language='javascript'>alert('无记录！');window.location.replace('index.asp');</script>"
end if
'分页
jil=rs.recordcount
page=cint(request.QueryString("page"))
rs.pagesize=30
tpage=cint(rs.pagecount)
if page="" or page=0 then
page=1
end if
if page>rs.pagecount then
page=rs.pagecount
end if
rs.Absolutepage=page
do while not rs.eof
%>
<tr>
<td width="117" height="20" align="center" bgcolor="#FFFFFF"><%=rs("user")%></td>
<td width="87" align="center" bgcolor="#FFFFFF"><%=rs("hx")%></td>
<td width="80" align="center" bgcolor="#FFFFFF"><%=rs("jiage")%></td>
<td width="63" align="center" bgcolor="#FFFFFF"><%=left(rs("are"),10)%></td>
<td width="58" align="center" bgcolor="#FFFFFF"><%=rs("man1")%></td>
<td width="69" align="center" bgcolor="#FFFFFF"><%=rs("tel")%></td>
<td width="58" align="center" bgcolor="#FFFFFF"><%=left(rs("addtime"),10)%></td>
<td width="51" align="center" bgcolor="#FFFFFF"><%=rs("date")%>天</td>
<td width="57" align="center" bgcolor="#FFFFFF"><a href="jiazhxx.asp?id=<%=rs("id")%>&user=<%=rs("user")%>">详细信息</a></td>
</tr>
<%
rs.movenext
loop
%>
</table></td>
</tr>
<tr>
<td height="27" align="center" valign="bottom">共<%=jil%>条记录 每页显30示条 共<%=tpage%>页 第<%=page%>页 <a href="jiazhuang.asp?page=1&jz=2">第一页</a> <a href="jiazhuang.asp?page=<%=page+1%>&jz=2">下一页</a> <a href="jiazhuang.asp?page=<%=page-1%>&jz=2">上一页</a> <a href="jiazhuang.asp?page=<%=tpage%>&jz=2">最后一页</a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="300"> </td>
</tr>
</table>
<%
rs.close
set rs=nothing
cn.close
set cn=nothing
end select
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -