add_zhu_zai_old.asp

看房直达车 后台路径:admin/login.asp 用户名:manage 密码:fansyou

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


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

<%if request.QueryString("add")="true" then %>
<!-- #include file="check_empty.asp" -->
  


 <%   if request.form("s1")="省份" then 
		 %>
<script language=javascript>
   history.back()
   alert("错误：请选择所在地区！")
</script> 
<%
Response.End
		 end if

name2=trim(request.Form("name2"))
		house_id=trim(request.Form("house_id"))
		 if name2="" or house_id="" then 
		 %>
<script language=javascript>
   history.back()
   alert("错误：物业名称或房产证号没有填写！")
</script> 
<%
Response.End
		 end if
set rs=server.CreateObject ("Adodb.RecordSet")
rs.Source="select * from s_zhu_zai where house_id='"&house_id&"'"
rs.Open rs.Source,conn,1,3
if not rs.eof then
%>
<script language=javascript>
   history.back()
   alert("该信息已经存在，请不要重复添加！")
</script> 
<%
Response.End
else
rs.addnew
rs("name2")=trim(request.Form("name2"))
rs("house_id")=trim(request.Form("house_id"))
rs("area1")=trim(request.Form("s1"))
rs("area2")=trim(request.Form("s2")) 
rs("area3")=trim(request.Form("s3"))
rs("address")=trim(request.Form("address"))
rs("ttype")=trim(request.Form("ttype"))
rs("floor")=trim(request.Form("floor")) 
rs("total_floor")=trim(request.Form("total_floor"))
rs("room_type")=trim(request.Form("room_type"))
rs("direct")=trim(request.Form("direct"))
rs("mian_ji")=trim(request.Form("mian_ji")) 
rs("price")=trim(request.Form("price"))
rs("car")=trim(request.Form("car"))
rs("total_price")=trim(request.Form("total_price"))
rs("info_type")=trim(request.Form("info_type")) 
rs("company")=trim(request.Form("company"))
rs("contact")=trim(request.Form("contact"))
rs("tel")=trim(request.Form("tel"))
rs("content")=trim(request.Form("content")) 
rs("picurl")=trim(request.Form("picurl"))
rs("userid")=request.Cookies("user_name")
rs("click")=1 
rs.update
rs.close
set rs=nothing
response.Write(" 信息成功添加！")
end if
end if
 
 
 %>
<script language="JavaScript">
function CheckForm()
{  if (document.form1.name2.value.length == 0) {
		alert("请输入物业名称.");
		document.ADDUser.yinye.focus();
		return false;
	}
	 if (document.form1.house_id.value.length == 0) {
		alert("请输入房产证号法人姓名.");
		document.ADDUser.fa_ren.focus();
		return false;
	}
	if (document.ADDUser.company.value.length == 0) {
		alert("请输入公司名称.");
		document.ADDUser.company.focus();
		return false;
	}
	return true;
	}
	</script>
<form action="?add=true" method="post"  name="form1" >
<TABLE width="582" height="53" border="1" align="center" cellpadding="4" cellspacing="1" bordercolor="#111111" bordercolorlight="#E0E0C2" bordercolordark="#E0E0C2" style="border-collapse: collapse">
  <tr>
    <td colspan="3"><strong>二手房－住宅－出售信息</strong></td>
    <td width="31%">&nbsp;</td>
  </tr>
  <tr>
    <td width="17%">物业名称*：</td>
    <td width="32%"><input name="name2" type="text" id="name2"></td>
    <td width="20%">房产证号*：    </td>
    <td><input name="house_id" type="text" id="house_id"></td>
  </tr>
  <tr>
    <td>所在地区*：</td>
    <td colspan="3"> <!--  #include file="area_form2.asp" --></td>
   </tr><tr> <td>详细地址*：    </td>
    <td colspan="3"><input name="address" type="text" id="address"></td>
  </tr>
  <tr>
    <td> 物业类型*：　</td>
    <td> <select name="ttype" size="1" id="ttype">
      <option value="高层" selected>高层</option>
      <option value="小高层">小高层</option>
      <option value="多层">多层</option>
      <option value="排屋">排屋</option>
	  <option value="别墅">别墅</option>
	   <option value="小户型">小户型</option>
    </select>    </td>
    <td> 所在楼层*：</td>
    <td>第
      <input name="floor" type="text" id="floor" size="4"> 
    层共
    <input name="total_floor" type="text" id="total_floor" size="4"> 
    层</td>
  </tr>
  <tr>
    <td>房型*：</td>
    <td colspan="3"><input name="room_type" type="text" id="room_type2" value=" 室 厅 厨 卫"> 
 （例如：3室2厅1厨1卫）</td>
  </tr>
  <tr>
  
    <td> 朝向*：    </td>
    <td colspan="3"><select name="direct" size="1" id="direct">
        <option value="东" selected>东</option>
	    <option value="西">西</option>
	    <option value="南">南</option>
	    <option value="北">北</option>
            </select></td>
  </tr>
  <tr>
    <td> 建筑面积*：　　　　 </td>
    <td><input name="mian_ji" type="text" id="mian_ji" size="10">
    平方米</td>
    <td> 单价*：      </td>
    <td><input name="price" type="text" id="price" size="10">
    元/平方米</td>
  </tr>
  <tr>
    <td>车位*：</td>
    <td><select name="car" size="1" id="car">
      <option value="有">有</option>
      <option value="无" selected>无</option>
    </select></td>
    <td>总价*：　　      　　　</td>
    <td> <input name="total_price" type="text" id="total_price" size="16">
    万元</td>
  </tr>
  <tr>
    
    
      <td>联系人*： </td>
    <td><input name="contact" type="text" id="contact2" size="16"></td>
    
    
    <td> 联系电话*：
    </td>
    <td><input name="tel" type="text" id="tel" size="16"></td>
  </tr>
  <tr>
  <td>信息类别*：</td>
    <td><select name="info_type" size="1" id="info_type">
      
	      <option selected value="1">中介</option>
	       
	     <option   value="2">非中介</option>
	  
    </select></td>
    <td>中介简称： </td>
    <td ><input name="company" type="text" id="company2" size="16">
    （限四个汉字以内） 
 </td>
  </tr>
  <tr>
    <td valign="top">上传图片：</td>
    <td colspan="3"><input name="picurl" type=text id="picurl" size="30" readonly><a href="#" onclick=window.open("upload_form.asp","","width=480,height=200,menubar=no,scrollbar=no")>无组件上传图片</a>	
	 
	
	</td>
  </tr>
  <tr>
    <td valign="top">备注*：</td>
    <td colspan="3"><textarea name="content" cols="55" rows="16" wrap="VIRTUAL" id="content"></textarea></td>
  </tr>
  <tr>
    <td colspan="4"><div align="center">
      <input type="submit" name="Submit" value="确定">
      &nbsp;&nbsp;&nbsp;&nbsp;
      <input type="reset" name="Submit2" value="重填">
    </div></td>
  </tr>
</table>
</form>
<% 
conn.close
set conn=nothing
%>