<!--#include file=../include/config.asp-->
<!--#include file=../include/conn_newhouse.asp-->
<!--#include file=../include/access.asp-->
<!--#include file=../include/function.asp-->

<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../style.css" type="text/css">
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
	function GON()
	{
		var pageno;
		var strs;
		if(form1.pp.value=="")
		{
			pageno=1;
		}
		else
		{
			pageno=form1.pp.value;
		}
		strs="view_lyb.asp?PageNO=" + pageno;
		window.location.href=strs;
	}
//-->
</SCRIPT>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<div align="center"><br>
  <b><font size="3">最 新 楼 盘 信 息</font></b><br>
</div>
<FORM METHOD=POST NAME="form1">
  <table width="600" border="0" cellpadding="0" cellspacing="2" class="kuan" align="center" height="49" bgcolor="#FFFFFF">
    <%
	dim strSql,rs,i,PageNo
	strSql="select * from [house_new] order by id desc"
	set rs=Server.CreateObject("ADODB.RecordSet")
	rs.open strSql,conn,3,3
	rs.PageSize=20
	PageNo=request("PageNo")
	if PageNo<1 or not isnumeric(PageNo) then
		PageNo=1
	end if
	if cint(PageNo)>rs.PageCount then
		PageNo=rs.PageCount
	end if
%>
    <tr> 
      <td background="../images/system1.gif" height="25" align="center" width="84"><font color="#FF6633" class="font"><b><font color="#FF9B59">发布日期</font></b></font></td>
      <td background="../images/system1.gif" height="25" align="center" width="113"><font color="#FF6633" class="font"><b><font color="#FF9B59">楼盘名称</font></b></font></td>
      <td background="../images/system1.gif" height="25" align="center" width="188"><font color="#FF6633" class="font"><b><font color="#FF9B59">电话</font></b></font></td>
      <td background="../images/system1.gif" height="25" align="center" width="93"><font color="#FF6633" class="font"><b><font color="#FF9B59">均价</font></b></font></td>
      <td background="../images/system1.gif" height="25" align="center" width="43"><font color="#FF6633" class="font"><b><font color="#FF9B59">删除</font></b></font></td>
      <td background="../images/system1.gif" height="25" align="center" width="65"><font color="#FF6633" class="font"><b></b></font><font color="#FF6633" class="font"><b><font color="#FF9B59">详细资料</font></b></font></td>
    </tr>
    <%
		if rs.recordcount>0 then
		   rs.AbsolutePage =PageNo
		   for i=1 to rs.pageSize
  			  if rs.eof then exit for
  %>
    <tr bgcolor="#ECFFEC"> 
      <td class="font" align="center" valign="middle" height="26" width="84" bgcolor="#DBE7F2">
	  <% if len(rs("date"))>8 then response.write(split(rs("date")," ")(0))%></td>
      <td class="font" align="center" valign="middle" height="26" width="113" bgcolor="#C1D6EA"><font color="red"><%=rs("house_name")%></font></td>
      <td class="font" align="center" valign="middle" height="26" bgcolor="#DBE7F2" width="188"><%=rs("sell_tel")%></td>
      <td class="font" align="center" valign="middle" height="26" bgcolor="#DBE7F2" width="93"><font color="#FF6633" class="font"><b><%=rs("jun_pay")%></b></font></td>
      
      <td class="font" align="center" valign="middle" height="26" width="43" bgcolor="#C1D6EA"><a href="del_newhouse.asp?id=<%=rs("id")%>" class="linkfont">删除</a></td>

      <td class="linkfont" align="center" valign="middle" height="26" width="65" bgcolor="#DBE7F2"><a href="change_newhouse.asp?id=<%=rs("id")%>" class="linkfont" target="_blank">修改</a></td>
    </tr>
    <%
				rs.movenext
			next
  %>
    <tr> 
      <td colspan="6" align="right" class="font"> 
        <%
			out("共 " & rs.pagecount & " 页 &nbsp;&nbsp;")
			out("当前第 " & PageNo & " 页 &nbsp;&nbsp;")
			out("到第 <input class=""textinput"" name=""pp"" type=""text"" size=""2""> 页")
			out(" <INPUT class=""textinput"" TYPE=""button"" value=""GO"" onclick=""javascript:GON()"">&nbsp;")
			out("<a href=""view_lyb.asp?PageNo=1"">首页</a>&nbsp;")
		    out("<a href=""view_lyb.asp?PageNo=" & (PageNo-1) & """>上一页</a>&nbsp;")
		    out("<a href=""view_lyb.asp?PageNo=" & (PageNo+1) & """>下一页</a>&nbsp;")
			out("<a href=""view_lyb.asp?PageNo=" & rs.pagecount & """>尾页</a>&nbsp;")
	  %>
        &nbsp; </td>
    </tr>
    <%
		else
  %>
    <tr> 
      <td colspan="6" class="font"> 
        <div align="center">没有数据!</div>
      </td>
    </tr>
    <%
		end if 
		rs.close
		set rs=nothing
  %>
  </table>
</FORM>
</body>
</html>
<!--#include file=../include/foot.asp-->