📄 list_need.asp
字号:
<!--#include file=conn/conn.asp -->
<%
dim typeto
typeto=trim(request("typeto"))
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from "& typeto &" where zid="&request("zid")
rs.open sql,conn,1,1
name1=(rs.Fields.Item("username").Value)
fdat=(rs.Fields.Item("dat").Value)
Num1=Cstr(year(fdat))
Num2=Cstr(month(fdat))
Num3= Cstr(day(fdat))
%>
<%
set Rs1 = Server.CreateObject("ADODB.Recordset")
Rs1.ActiveConnection = "DBQ="+server.mappath("data/housedata.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;"
Rs1.Source = "SELECT * FROM admin WHERE username='" & name1 & "'"
Rs1.CursorType = 0
Rs1.CursorLocation = 2
Rs1.LockType = 3
Rs1.Open
Rs1_numRows = 0
Set Conn=Server.CreateObject("ADODB.Connection")
sql1="SELECT * FROM admin WHERE name='" & name1 & "'"
conn.Execute(sql1)
%>
<html>
<head>
<title>房源详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.9size { font-family: "宋体"; font-size: 9pt; color: #000000; text-decoration: none}
a:hover { font-family: "宋体"; font-size: 9pt; color: #FFFFFF; text-decoration: underline}
-->
</style>
</head>
<SCRIPT language=JavaScript1.2>
var bookmarkurl=<% =url %>
var bookmarktitle=<% =name %>
function addbookmark(){
if (document.all)
window.external.AddFavorite(bookmarkurl,bookmarktitle)
}
</SCRIPT>
<body bgcolor="#FFFFFF" background="img/bg.gif">
<div align="center">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td>
<div align="center">
<center>
<table width="98%" border="3" cellspacing="1" cellpadding="2" class="9size" bordercolorlight="#BDBD79" bordercolordark="#BDBD79" style="border-collapse: collapse" bordercolor="#111111">
<tr bgcolor="#6666FF">
<td height="38" colspan="4" bgcolor="#F2F6DB" width="98%">
<p align="center">
<b><span style="font-size: 10.5pt">第 <font color="#FF0000"><%=(rs.Fields.Item("zid").Value)%> </font>号需求详细信息</span></b></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="58" class="plaintext" bgcolor="#EDF2CE">需求<font color="#000000">地域:</font></td>
<td width="192" class="plaintext" height="25" bgcolor="#F2F6DB"><%=(rs.Fields.Item("Diduan").Value)%> </td>
<td width="55" class="plaintext" height="25" bgcolor="#EDF2CE">产权要求:</td>
<td width="235" class="plaintext" height="25" bgcolor="#F2F6DB"><%=(rs.Fields.Item("quansh").Value)%></td>
</tr>
<tr bgcolor="#6666FF">
<td width="58" class="plaintext" bgcolor="#EDF2CE">需求类别:</td>
<td width="192" class="plaintext" height="25" bgcolor="#F2F6DB"><%=(rs.Fields.Item("Fangx").Value)%> </td>
<td class="plaintext" height="25" width="55" bgcolor="#EDF2CE">装修要求:</td>
<td class="plaintext" height="25" width="235" bgcolor="#F2F6DB"><%=(rs.Fields.Item("zx").Value)%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="58" class="plaintext" bgcolor="#EDF2CE">需求套型:</font></td>
<td width="192" class="plaintext" height="25" bgcolor="#F2F6DB"><%=(rs.Fields.Item("Taox").Value)%> </td>
<td class="plaintext" height="25" width="55" bgcolor="#EDF2CE"> </td>
<td class="plaintext" height="25" width="235" bgcolor="#F2F6DB"> </td>
</tr>
<tr bgcolor="#6666FF">
<td width="58" class="plaintext" bgcolor="#EDF2CE">具体路段:</td>
<td width="192" class="plaintext" height="25" bgcolor="#F2F6DB"><%=(rs.Fields.Item("xiaoqm").Value)%> </td>
<td class="plaintext" height="25" width="55" bgcolor="#EDF2CE">有 效 期:
</td>
<td class="plaintext" height="25" width="235" bgcolor="#F2F6DB"><%=(rs.Fields.Item("D").Value)%> 天</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="58" class="plaintext" height="26" bgcolor="#EDF2CE">需求<font color="#000000">面积</font>:</td>
<td width="192" class="plaintext" height="26" bgcolor="#F2F6DB"><%=(rs.Fields.Item("Mianj").Value)%><font color="#000000">平方米</font></td>
<td class="plaintext" height="26" width="55" bgcolor="#EDF2CE"><font color="#000000">登记时间</font>:</td>
<td class="plaintext" height="26" width="235" bgcolor="#F2F6DB"> <% =Num1 %> <font color="#000000">年</font> <% =Num2 %> <font color="#000000">月</font> <% =Num3 %> <font color="#000000">日</font></td>
</tr>
<tr bgcolor="#6666FF">
<td width="58" class="plaintext" bgcolor="#EDF2CE">价格要求:</td>
<td width="192" class="plaintext" height="25" bgcolor="#F2F6DB"><%=(rs.Fields.Item("jiag").Value)%>万元</td>
<td class="plaintext" height="25" width="55" bgcolor="#EDF2CE"><font color="#FF0000">
需 求 人:</font></td>
<td class="plaintext" height="25" width="235" bgcolor="#F2F6DB"><font color="#FF0000">
<%=(rs.Fields.Item("Contperson").Value)%></font> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="58" class="plaintext" height="24" bgcolor="#EDF2CE"><font color="#000000">
楼层要求</font>:</td>
<td width="192" class="plaintext" height="24" bgcolor="#F2F6DB"><font color="#000000">第</font><%=(rs.Fields.Item("lc").Value)%><font color="#000000">层</font></td>
<td class="plaintext" height="24" width="55" bgcolor="#EDF2CE"><font color="#FF0000">
联系电话:</font></td>
<td class="plaintext" height="24" width="235" bgcolor="#F2F6DB"><font color="#FF0000">
<%=(rs.Fields.Item("tele").Value)%> </font> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td class="plaintext" height="25" width="58" bgcolor="#EDF2CE"><font color="#000000">备 注:</font></td>
<td class="plaintext" colspan="3" height="25" bgcolor="#F2F6DB" width="494"> <font size="2">
<% if (rs.Fields.Item("Content").Value)=" " then %>
无
<% else %>
<% =(rs.Fields.Item("Content").Value)%>
<% end if %>
</font> </td>
</tr>
<tr valign="bottom" bgcolor="#6666FF">
<td height="25" colspan="4" bgcolor="#F2F6DB" class="plaintext" width="558">
<div align="center"> [<a href="javascript:window.close()" class="9size">关闭窗口</a>]
</div></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -