addhouse.asp

房屋中介系统

<!--#include file ="conn.asp"-->
<!--#include file ="head.asp"-->
<script Language="JavaScript">
function check(theForm)
{
  if (theForm.address.value == "")
  {
    alert("请在 房屋地址 域中输入值。");
    theForm.address.focus();
    return (false);
  }
  if (theForm.frame.value == "")
  {
    alert("请在 户型 域中输入值。");
    theForm.frame.focus();
    return (false);
  }
  if (theForm.buildarea.value == "")
  {
    alert("请在 建筑面积 域中输入值。");
    theForm.buildarea.focus();
    return (false);
  }
  if (theForm.floor.value == "")
  {
    alert("请在 楼层 域中输入值。");
    theForm.floor.focus();
    return (false);
  }
  if (theForm.price.value == "")
  {
    alert("请在 房价 域中输入值。");
    theForm.price.focus();
    return (false);
  }
  if (theForm.linkman.value == "")
  {
    alert("请在 联系人 域中输入值。");
    theForm.linkman.focus();
    return (false);
  }

  if (theForm.connect.value == "")
  {
    alert("请在 联系方式 域中输入值。");
    theForm.connect.focus();
    return (false);
  }
  return (true);
}
</script>
<%
if request("B1")<>"" then
sql = "select * from house"
Set rs = Server.CreateObject("ADODB.RecordSet")
nowdate = Now()
rs.Open sql,conn,1,3
rs.addnew
rs("region")=request("region")
rs("puttype")=request("puttype")
rs("address")=request("address")
rs("right")=request("right")
rs("frame")=request("frame")
rs("base")=request("base")
rs("equipment")=request("equipment")
rs("fitment")=request("fitment")
rs("buildarea")=request("buildarea")
rs("floor")=request("floor")
rs("price")=request("price")
rs("effectdays")=request("effectdays")
rs("linkman")=request("linkman")
rs("connect")=request("connect")
rs("demo")=request("demo")
rs("checkup")=0
rs.update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>
<h2 align="center">成功，但不会马上显示出来</h2>
<h2 align="center">需管理员审核后方会显示</h2>
<hr>
<div align="center"><a href=index.asp><font size=4>返回首页</font></a></div>
<% 
response.end
end if 
%>
<form method="post" onsubmit="return check(this)" action="">
		<table width="100%">
			<tr>
				<td>区域</td>
				<td>
				<select name="region">
				<option>中山区</option>
				<option>沙河口区</option>
				<option>西岗区</option>
				<option>甘井子区</option>
				<option>旅顺</option>
				<option>开发区</option>
				<option>金州</option>
				<option>其他市区</option>
				</select>
			</tr>
			<tr>
				<td>发布类型</td>
				<td><select size="1" name="puttype">
                  <option>求租</option>
                  <option>出租</option>
                  <option>求购</option>
                  <option>出售</option>
                </select></td>
			</tr>
			<tr>
				<td>房屋地址</td>
				<td>
				<input type="text" name="address" size="50" > 
				如：软件园18号等</td>
			</tr>
			<tr>
				<td>房屋权限</td>
				<td>
				<select  name="right">
				<option>产权</option>
				<option>地产</option>
				<option>军产</option>
				<option>使用权</option>
				<option>发票</option>
				<option>其他</option>
				</select></td>
			</tr>
			<tr>
				<td>户型</td>
				<td>
				<input type="text" name="frame" size="30">如：两室一厅一卫
				</td>
			</tr>
			
			<tr>
				<td>基础设施</td>
				<td>
				<input type="text" name="base" size="30" value="水、电、煤气">如：水、电、煤气、有线电视、宽带网
				</td>
			</tr>
			<tr>
				<td>设备情况</td>
				<td>
				<input type="text" name="equipment">如：电视、空调、冰箱、热水器、家具等
				</td>
			</tr>
			<tr>
				<td>装修程度</td>
				<td>
                  <select size="1" name="fitment">
                    <option>简装</option>
                    <option>精装</option>
                    <option>豪装</option>
                    <option>清水</option>
                    <option>无装修</option>
                  </select>
</td>
			</tr>
			<tr>
				<td>建筑面积</td>
			  <td>
                <table width="514" border="0">
                  <tr>
                    <td width="187"><input type="text" name="buildarea" size="10">平方米</td>
                    <td width="28">楼层</td>
                    <td width="142"><input type="text" name="floor" size="10">楼</td>
                    <td width="35">房价</td>
                    <td width="100"><input type="text" name="price" size="10"></td>
                  </tr>
                </table>
			</td>
			</tr>
			<tr>
				<td>登记日期</td>
				<td>
				<table border="0" width="100%">
					<tr>
						<td width="14%"><%=date()%></td>
						<td width="8%">有效天数</td>
						<td width="78%">
						<select size="1" name="effectdays">
						<option>3</option>
						<option>7</option>
						<option>30</option>
						<option>60</option>
						<option>180</option>
						<option>365</option>
						</select>天
						</td>
					</tr>
				</table>
			</td>
			</tr>
			<tr>
				<td>联系人</td>
				<td>
				<table border="0">
					<tr>
						<td>
						<input type="text" name="linkman" size="30"></td>
						<td>
						<p align="right">联系方式：</td>
						<td>
						<input type="text" name="connect" size="30">
						</td>
					</tr>
				</table>
				</td>
			</tr>
			<tr>
				<td>备注</td>
				<td>
				<textarea rows="5" name="demo" cols="74"></textarea></td>
			</tr>
		</table>
	<p align="center">
	<input type="submit" value="确定" name="B1" style="border-style: solid; border-width: 1px; background-color: #FFFFFF">
	<input type="reset" value="重置" name="B2" style="border-style: solid; border-width: 1px; background-color: #FFFFFF"></p>
</form>
		</td>
	</tr>
	</table>
</body>
</html>