<!--#include file="byshop_conn.asp"-->
<!--#include file="session.asp"-->
<%
'//新楼盘出售

'新楼盘全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from build    ",conn,1,1
buildall=rs.recordcount 
rs.close

'新楼盘待审核
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from build where by_shenhe=0  ",conn,1,1
buildwait=rs.recordcount 
rs.close


'//二手房出售

'二手房出售全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from sell ",conn,1,1
sellall=rs.recordcount 
rs.close

'二手房出售待审核
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from sell where by_shenhe=0  ",conn,1,1
sellwait=rs.recordcount 
rs.close




'//二手房求购

'二手房求购全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from sell2 ",conn,1,1
sellqgall=rs.recordcount 
rs.close

'二手房求购待审核
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from sell2 where by_shenhe=0  ",conn,1,1
sellqgwait=rs.recordcount 
rs.close


'//租赁房出租

'租赁房出租全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from rent ",conn,1,1
rentall=rs.recordcount 
rs.close

'租赁房出租待审核
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from rent where by_shenhe=0  ",conn,1,1
rentwait=rs.recordcount 
rs.close


'//租赁房求租

'租赁房求租全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from rent2 ",conn,1,1
rentqgall=rs.recordcount 
rs.close

'租赁房求租待审核
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from rent2 where by_shenhe=0  ",conn,1,1
rentqgwait=rs.recordcount 
rs.close



'//合租

'合租全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from cotenancy ",conn,1,1
cotenancyall=rs.recordcount 
rs.close

'合租待审核
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from cotenancy where by_shenhe=0  ",conn,1,1
cotenancywait=rs.recordcount 
rs.close

'所有会员
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from byshop_user",conn,1,1
userall=rs.recordcount 
rs.close

'等待会员
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT  * from byshop_user where  reglx=0  ",conn,1,1
userwait=rs.recordcount 
rs.close

%>
<HTML>
<title>管理首页面</title>
<link rel="stylesheet" href="css/Style.css" type="text/css">
</head>

<BODY>
 <table border="0" cellspacing="1" width="100%" align=center>
    <tr>
      <td width="100%">
		<div align="center">
			<table cellpadding="3" cellspacing="1" border="1" width="100%" class="tableBorder" bordercolor="#C0C0C0" style="border-collapse: collapse">
      <tr> 
          <th class="tableHeaderText" colspan=4  bgcolor="#E8F1FF">
			信息统计</th>
        </tr> 
		<tr> 
        <td class="forumRowHighlight" height="50%" width="49%" bgcolor="#F7F7F7" colspan="2">
		<b>新楼盘</b></td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="50%" bgcolor="#F7F7F7" colspan="2">
		<b>二手房</b></td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="10%" bgcolor="#F7F7F7">
		<p align="right">所有</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7">
			<%=buildall%>条</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="14%" bgcolor="#F7F7F7">
		<p align="right">所有</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="35%" bgcolor="#F7F7F7">
			出售<%=sellall%>条 求购<%=sellqgall%>条</td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="14%" bgcolor="#F7F7F7">
		<p align="right">等待</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7">
			<font color="#FF0000"><%=buildwait%></font>条</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="14%" bgcolor="#F7F7F7">
		<p align="right">等待</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="35%" bgcolor="#F7F7F7">
			出售<font color="#FF0000"><%=sellwait%></font>条 求购<font color="#FF0000"><%=sellqgwait%></font>条</td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="49%" bgcolor="#F7F7F7" colspan="2">
		<b>租赁房</b></td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="50%" bgcolor="#F7F7F7" colspan="2">
			<b>合租</b></td>
      </tr>
      		<tr> 
        <td class="forumRowHighlight" height=23 width="14%" bgcolor="#F7F7F7">
		<p align="right">所有</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7">
			出租<%=rentall%>条　求租<%=rentqgall%>条</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="14%" bgcolor="#F7F7F7">
		<p align="right">所有</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="35%" bgcolor="#F7F7F7">
			<%=cotenancyall%>条</td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="14%" bgcolor="#F7F7F7">
		<p align="right">等待</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7">
			出租<font color="#FF0000"><%=rentwait%></font>条　求租<font color="#FF0000"><%=rentqgwait%></font>条</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="14%" bgcolor="#F7F7F7">
		<p align="right">等待</td>
          <td class="forumRow" style="LINE-HEIGHT: 150%" width="35%" bgcolor="#F7F7F7">
			<font color="#FF0000"><%=cotenancywait%></font>条</td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="14%" bgcolor="#F7F7F7">
		<b>会员</b></td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7">
			　</td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="50%" bgcolor="#F7F7F7" colspan="2">
			　</td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="14%" bgcolor="#F7F7F7">
		<p align="right">所有</td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7"><%=userall%>人</td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="50%" bgcolor="#F7F7F7" colspan="2">
			　</td>
      </tr>
		<tr> 
        <td class="forumRowHighlight" height=23 width="14%" bgcolor="#F7F7F7">
		<p align="right">　等待</td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="34%" bgcolor="#F7F7F7">
			<font color="#FF0000"><%=userwait%></font>人</td>
          <td class="forumRowHighlight" style="LINE-HEIGHT: 150%" width="50%" bgcolor="#F7F7F7" colspan="2">
			　</td>
      </tr>
		</table>
		</div>
</td>
    </tr>
</table>
    <p align="center">您目前使用的 便宜房产网V1.0试用版<br>
	后台缺少了许多重要文件<br>
	如果你需要正式版的请联系我们</p>
    </BODY>
</HTML> 
  