<!-- #include file="head.asp" -->
<!-- #include file="session.asp" -->

<SCRIPT language=Javascript>
function confirmdel(id,table)
{
	if(confirm("你確實要刪除ID為"+id+"的記錄嗎？")==true)
	{
	window.location = "?tt="+table+"&del=true&id="+id;
	}
}
</script>
<TABLE width=760 border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="#FFFFFF" class=bk>
  <TBODY>
    <TR> 
      <TD colspan="2" align=middle vAlign=top>
	    
			  <!-- #include file="diao2.asp" --><br>
 
			  </TD>
            </TR>
            
        <TR> 
      <TD colspan="2" align=middle vAlign=top>
	    
			<% old2=request("old1")
			     old1=request("old2")
				 
				 if old1="_cs" then 
				 e1="出售"
				 e12="s_"
				 else
				 e1="出租"
				 e12="z_"
				 end if
				 
				  
				 if old2="zhu_zai" then 
				 e2="住宅"
				 else  if old2="xie_zi_lou" then 
				 e2="寫字樓"
				 old2="xie_zi"
				 else if old2="shang_pu" then 
				 e2="商鋪"
				 else
				  e2="廠房"
				 end if
				 end if
				 end if
				  response.Write "<div align=center><b><br>二手房 — "&e2&" — "&e1&" — "&e3&"信息</div></b><br>"
				   %>
 <!-- #include file="lwconn.asp" -->
 
 <%
 if request.querystring("del")="true" then 
 id=Request.QueryString("id")
sql="delete * from "&trim(request.querystring("tt"))&" where id="&id
conn.execute(sql)
response.write "<h3>該記錄刪除成功！</h3>"
response.end()
end if %>
 
 
			  <% table=e12&old2
			 
			   set rs=server.createobject("adodb.recordset") 
   sql ="select * from "&table&" order by  id desc " 
rs.open sql,conn,1,1
if rs.eof or rs.bof then 
response.Write("<br><div align=center>數(shù)據(jù)庫中暫無任何記錄！</div>")
else%>

			  <TABLE style="BORDER-COLLAPSE: collapse" 
                        borderColor=#dedede cellSpacing=0 cellPadding=4 
                        width="98%" align=center border=0>
               
                  <TR   vAlign=bottom bgColor=#00ccff>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff><div align="center"> 物業(yè)名稱　　 　　　　</div></TD>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff>地段</TD>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff> 物業(yè)類型</TD>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff>　 面積</TD>
                    
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff>信息類別 </TD>
                 
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff>修改 </TD>    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            bgColor=#99ccff>刪除 </TD> </TR>

<% 
			n=1
do while not rs.eof%>
 <TR bgColor=#f8f8f8>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            align=middle><%=rs("name2")%> </TD>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=left(rs("address"),10)&"..."%></TD>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("ttype")%></TD>
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("mian_ji")%></TD>
                    
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("info_type")%></TD>
                  <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><a href="info_edit3.asp?id=<%=rs("id")%>&old1=<%=e12%>&old2=<%=old2%>"><font color="#CC3300">修改</font></a></TD>
                       
                    <TD 
                            style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"> <a href="javascript:confirmdel('<%=rs("id")%>','<%=table%>')"><font color="#CC3300">刪除</font></a></TD>   
                       
                      
                            
                            
                             </TR>


 <%rs.movenext
n=n+1
if n>rs.pagesize then exit do
loop
%>            
</table>
<%   
	  end if
rs.close
set rs=nothing

			  
			  
			  %>
			 <p><br></p> </TD>
            </TR>     
            
          </TBODY>
        </TABLE>

         
        
      
       <!-- #include file="footer.asp" -->