<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<!--#include file="conn1.asp"-->
    <%set rs=server.CreateObject("adodb.recordset")
	
rs.open "select * from member where id="&request.QueryString("id")&" order by id desc ",conn,1,1%>
<%jjman=rs("truename")
username=rs("username")

%>		  
		  
<title>经济人<%=jjman%>的店铺-泰华地产</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.line6 {
	border-right-width: 1px;
	border-bottom-width: 1px;
	border-left-width: 1px;
	border-right-style: solid;
	border-bottom-style: solid;
	border-left-style: solid;
	border-right-color: #74B646;
	border-bottom-color: #74B646;
	border-left-color: #74B646;
}

a.cd1 {
	color:#000000; font-size:13px; text-decoration:none;
	
	
}
 a.cd1:link {
	color:#000000; font-size:13px; text-decoration:none;
	
}
 a.cd1:visited {
	color:#000000; font-size:13px; text-decoration:none;
	
}
a.cd1:hover {
color:#0041D9; font-size:13px; text-decoration:underline;
	
}


a.cd4 {
	color:#0041D9; font-size:12px; text-decoration:none;
	
}
 a.cd4:link {
	color:#0041D9; font-size:12px; text-decoration:none;
	
}
 a.cd4:visited {
	color:#0041D9; font-size:12px; text-decoration:none;
	
}
a.cd4:hover {
color:#FF6600; font-size:12px; text-decoration:underline;
	
}


.STYLE1 {
	font-size: 13px;
	font-weight: bold;
	color:#FFFFFF;
}



-->
</style>
</head>

<body>
<table width="960" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#D5EEC6">
  <tr>
    <td>
<table width="960" height="60" border="0" cellpadding="0" cellspacing="0" background="images/hc048.jpg" align="center">
  <tr>
    <td align="left"   valign="top" style="padding-top:5px;"><table width="960" height="40" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="130"  align="center" valign="top"><a href="index.asp"><img src="images/logo.gif" width="110" height="40" border="0" /></a></td>
		
		<td width="130" align="center" valign="middle" style="font-size:13px;"><a href="index.asp" class="cd1">首页</a> <a href="ershoufang.asp" class="cd1">二手房</a> <a href="zufang.asp" class="cd1">租房</a></td>
        <td width="700"   align="center" style="font-size:13px;">  <form id="form1" name="form1" method="post" action="checklogin.asp">
		用户名：<input name="username" type="text" id="username"  style="width:130px;height:16px;"/>&nbsp;密码：
		<input name="password" type="password" id="password"  style="width:130px; height:16px;"/>&nbsp;验证码：
		<input name="verifycode" type="text" id="verifycode"  style="width:40px;height:16px;"  maxlength="4"/>
		<img src="VerifyCode.asp" alt="点击刷新验证码" style="cursor:pointer;border:0;vertical-align:middle;"  onClick="src='VerifyCode.asp?s='+Math.random()"/>&nbsp;
        <label>
        <input type="submit" name="Submit" value="登&nbsp;陆" />
        </label>
        </form></td>
      </tr>
    </table>
    
    </td>
  </tr>
</table>



<table width="960" border="0" cellspacing="0"  style="margin-top:5px;" cellpadding="0" align="center" height="83" background="images/88_1.jpg">
  <tr>
    <td align="center" valign="middle"><table width="785" height="35" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
      <tr>
        <td align="center" valign="middle" style="color:#666666; font-size:14px; font-weight:bold;"><%=jjman%>  【置业顾问】</td>
      </tr>
    </table></td>
  </tr>
</table>








<table width="960" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td  bgcolor="#74B646" align="left" valign="middle" style="padding-left:100px;"> <a href="jjren.asp?id=<%=request.QueryString("id")%>" class="cd1">首 页</a>  <a href="twohouse.asp?id=<%=request.QueryString("id")%>" class="cd1">二手房</a>  <a href="Rentalfan.asp?id=<%=request.QueryString("id")%>" class="cd1" >租 房</a> </td>
  </tr>
</table>




<table width="960" border="0" cellspacing="0" cellpadding="0"  align="center" style="padding-top:10px;">
  <tr>
    <td width="630" align="left"  valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="25"  bgcolor="#74B646" align="left" valign="middle">&nbsp;&nbsp;<span class="STYLE1">我的精品房源</span></td>
      </tr>
      <tr>
        <td align="center" valign="top"><table width="100%" height="160" border="0" cellpadding="0" cellspacing="1" class="line6">
          <tr>
		  
		  
		  
		        <%
                  set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 5 * from twohouse where fabuzhe='"&username&"' and fyclass='精品' order by id desc",conn,1,1
		   %>
		   
		    <%do while not rs.eof%>
            <td  align="left"  valign="middle" width="20%"><table width="110" height="160" border="0" cellpadding="0" cellspacing="0" style="padding:5px;">
              <tr>
                <td height="110" align="center" valign="middle"><a class="cd4" href="viewhouse.asp?id=<%=rs("id")%>"><img class="line8" src="<%=rs("tupian")%>" width="110" height="110" border="0" /></a></td>
              </tr>
              <tr>
                <td height="30"  align="left" valign="top" style="color:#666666; padding-top:5px; font-size:13px;"><a class="cd4" href="viewhouse.asp?id=<%=rs("id")%>"><%=trim(rs("fybt"))%></a></td>
              </tr>
              <tr>
                <td align="center" valign="middle" style="color:#666666; font-size:13px;">人气：<%=rs("views")%> </td>
              </tr>
            </table></td>
			
		
				  
	     <%rs.movenext
		  loop
		  rs.close
		  set rs=nothing%>
		  
			
			
			     
          </tr>
        </table></td>
      </tr>
	  
	  
	  <tr><td  height="10"></td></tr>
	  
	  <tr><td height="25" align="left" valign="middle" bgcolor="#74B646"  >&nbsp;&nbsp;<span class="STYLE1">我推荐的二手房</span> </td>
	  </tr>
	  
	  <tr><td align="left" valign="top"><table width="100%" height="60" border="0" cellpadding="0" cellspacing="1" class="line6">
	   
		        <%
                  set rs=server.CreateObject("adodb.recordset")
		  rs.open "select  * from twohouse where fabuzhe='"&username&"' and fyclass='推荐' order by id desc",conn,1,1
		   %>
		   
		    <%do while not rs.eof%>
	  
          <tr>
		  <td width="12%" height="80" align="left" class="td_content" style="padding-left:8px;"><a href="viewhouse.asp?id=<%=rs("id")%>"><img src="<%=rs("tupian")%>" width="80" height="60" border="0" /></a></td>
      <td width="55%" height="80" class="td_content" valign="middle"><table width="100%" height="80" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td align="left" height="25"  valign="middle">&nbsp;<a class="cd4" href="viewhouse.asp?id=<%=rs("id")%>"><%=trim(rs("fybt"))%></a></td>
        </tr>
        <tr>
          <td align="left" valign="middle" height="25" style="font-size:12px;">&nbsp;<span style="color:#585858;"><%=rs("localArea")%></span>-<span style="color:#585858;"><%=rs("xxdz")%></span></td>
        </tr>
        <tr>
          <td align="left" valign="middle" height="25" style="font-size:12px;">&nbsp;<span style="color:#666666; font-family:Arial, Helvetica, sans-serif;"><%=rs("jushi")%>室<%=rs("ting")%>厅<%=rs("hxwei")%>卫&nbsp;/ &nbsp;更新时间：<%=rs("adddate")%></span></td>
        </tr>
      </table></td>
      <td width="12%" class="td_content" align="center" valign="middle" style="font-size:12px;">
	  <span style="font-family:Arial, Helvetica, sans-serif; color:#FF0000; font-size:12px; line-height:30px; "><%=rs("sale")%></span>万<br><span style="color:#666666; font-family:Arial, Helvetica, sans-serif;"><%aa=rs("sale")/rs("area")%><%=int(aa*10000)%>元/㎡</span>	  </td>
      <td width="11%" class="td_content" ><div align="center"><span style="font-family:Arial, Helvetica, sans-serif; color:#FF0000; font-size:12px; "><%=rs("area")%></span>㎡</div></td>
      </tr>
		 
			     <%rs.movenext
		  loop
		  rs.close
		  set rs=nothing%>
		   
		 
		 
        </table></td></tr>
	 	  <tr><td  height="10"></td></tr>
	  
	  <tr><td height="25" align="left" valign="middle" bgcolor="#74B646"  >&nbsp;&nbsp;<span class="STYLE1">我推荐的租房</span> </td>
	  </tr>
	  
	  <tr><td align="left" valign="top"><table width="100%" height="60" border="0" cellpadding="0" cellspacing="1" class="line6">
	   
		        <%
                  set rs=server.CreateObject("adodb.recordset")
		  rs.open "select * from fwcz where fabuzhe='"&username&"' and fyclass='推荐' order by id desc",conn,1,1
		   %>
		   
		    <%do while not rs.eof%>
	      <tr style="font-size:12px;"> 
      <td class="td_content" align="left" style="padding-left:8px;" height="25"><a class="cd4" href="viewzufang.asp?id=<%=rs("id")%>"><%=trim(rs("fybt"))%></a>&nbsp;<span style="color:#585858;"><%=rs("localArea")%></span>-<span style="color:#585858;"><%=rs("xxdz")%></span>  
	  <%if rs("fyclass")<>"" then%>
		  <span class="fyclass"><%=rs("fyclass")%></span>
		  <%end if%>		  </td>
      <td class="td_content"> <div align="center"><span style="color:#666666; font-family:Arial, Helvetica, sans-serif;"><%=trim(rs("zujin"))%></span></div></td>
      <td class="td_content" ><div align="center"><span style="color:#666666; font-family:Arial, Helvetica, sans-serif;"><%=rs("jushi")%>室<%=rs("ting")%>厅<%=rs("hxwei")%>卫</span></div></td>
      <td class="td_content"> <div align="center"><span style="color:#666666; font-family:Arial, Helvetica, sans-serif; "><%=year(rs("adddate"))%>-<%=month(rs("adddate"))%>-<%=day(rs("adddate"))%></span></div></td>
      </tr>
		 
			     <%rs.movenext
		  loop
		  rs.close
		  set rs=nothing%>
		   
		 
		 
        </table></td></tr> 
	  
    </table></td>
    <td width="330" align="right" valign="top">
	
	
	<table width="320" height="200" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="25" align="left" valign="middle" bgcolor="#74B646">&nbsp;&nbsp;<span class="STYLE1">个人介绍</span> </td>
      </tr>
      <tr>
        <td height="160" align="center" valign="top"><table width="98%" height="160" border="0" cellpadding="0" cellspacing="1" class="line6">
          <tr>
		  
		  
		  
		     
            <td  align="center"   valign="top"  width="100%">
			
			<table width="315" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="125" align="center" valign="top" style="padding:5px;">	
	
	    <%set rs=server.CreateObject("adodb.recordset")
	
rs.open "select * from member where id="&request.QueryString("id")&" order by id desc ",conn,1,1%>
	  <%if rs("touxiang")<>"" then%>
				  
			   <%tupian=rs("touxiang")%>
			
				  <%else%>
				  	  <%tupian="images/touxiang.jpg"%>
				 
				  <%end if%>
				  
				  <img src="<%=tupian%>" width="125" height="145" /></td>
    <td width="210" align="center" valign="middle"><table width="100%" height="145" border="0" cellpadding="0" cellspacing="0" style="font-size:12px;">
      <tr>
        <td  align="left" valign="middle" height="30" style="color:#666666;">&nbsp;&nbsp;<%=rs("truename")%>&nbsp;&nbsp;置业顾问 </td>
      </tr>
    <tr>
        <td  align="left" valign="middle" height="30" style="color:#666666;">&nbsp;&nbsp;区域: [ 蒸湘区 ] </td>
      </tr>
    <tr>
        <td  align="left" valign="middle" height="30" style="color:#666666;">&nbsp;&nbsp;手机:<font color="#0041D9"><%=rs("shouji")%></font></td>
      </tr>
	  
	       <tr>
        <td  align="left" valign="middle" height="30" style="color:#666666;">&nbsp;&nbsp;Q&nbsp;&nbsp;Q:<%=rs("qicq")%></td>
      </tr>
	  
	  <%		 set rs2=server.createobject("adodb.recordset")
	rs2.open "select * from twohouse where fabuzhe='"&rs("username")&"' order by id desc",conn,1,1%>
	  
	     <tr>
        <td  align="left" valign="middle" height="30" style="color:#666666;">&nbsp;&nbsp;有<font color="#0041D9" style="font-family:Arial, Helvetica, sans-serif;"><%=rs2.RecordCount%></font>套房源出售中</td>
      </tr>
	  
	  
	 
	  

    </table></td>
  </tr>
  

			
			
			
			
			
			




  
  
  
</table>
		
		
		
		
		
		
		</td>
			
		
	
		  
			
			
			     
          </tr>
        </table></td>
      </tr>
	  
	      <tr>
        <td height="25" align="left" valign="middle" bgcolor="#74B646">&nbsp;&nbsp;<span class="STYLE1">房源信息</span> </td>
      </tr>
      <tr>
        <td height="175" align="center" valign="top"><table width="100%"  border="0" cellpadding="0" cellspacing="1" class="line6">
 
		        <%
                  set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 15 * from twohouse where fabuzhe='"&username&"'  order by id desc",conn,1,1
		   %>
		   
		    <%do while not rs.eof%>
	  
          <tr>
		  <td width="55%" height="40" class="td_content" valign="middle"><table width="100%" height="40" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td align="left" height="20"  valign="middle" style="padding-left:2px;"><a class="cd4" href="viewhouse.asp?id=<%=rs("id")%>">
		  
		  <%if len(rs("fybt"))>25 then 
response.write left(rs("fybt"),24)&".."
else response.write rs("fybt")
end if %> 
		  
		  <%'=trim(rs("fybt"))%>
		  
		  </a></td>
        </tr>
        
        <tr>
          <td align="left" valign="middle" height="20" style="font-size:12px;">&nbsp;<span style="color:#666666; font-family:Arial, Helvetica, sans-serif;"><%=rs("jushi")%>室<%=rs("ting")%>厅<%=rs("hxwei")%>卫&nbsp;&nbsp;<%=rs("area")%>平方&nbsp;&nbsp;<%=rs("Floor")%>/<%=rs("zonglc")%>&nbsp;&nbsp;<%=rs("FitType")%>&nbsp;&nbsp;<%=rs("sale")%>万
</span></td>
        </tr>
      </table></td>
      </tr>
		 
			     <%rs.movenext
		  loop
		  rs.close
		  set rs=nothing%>
        </table></td>
      </tr> 
    </table>
	</td>
  </tr>
</table>
</td>
  </tr>
</table>
</body>
</html>
