?? add_new_shang_pu.asp
字號:
<!-- #include file="session.asp" -->
<!-- #include file="lwconn.asp" -->
<!-- #include file="head.asp" -->
<%if request.QueryString("add")="true" then
if request.form("s1")="省份" then
%>
<script language=javascript>
history.back()
alert("錯誤：請選擇所在地區！")
</script>
<%
Response.End
end if
name2=trim(request.Form("name2"))
if name2="" then
%>
<script language=javascript>
history.back()
alert("錯誤：樓盤名稱沒有填寫！")
</script>
<%
Response.End
end if
set rs=server.CreateObject ("Adodb.RecordSet")
rs.Source="select * from snew_shang_pu where id is null"
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"))
gui_hua=trim(request.Form("gui_hua"))
gui_hua=replace(gui_hua,chr(13)&chr(10),"<br>")
gui_hua=replace(gui_hua," "," ")
rs("gui_hua")=gui_hua
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("date1")=trim(request.Form("date1"))
rs("date2")=trim(request.Form("date2"))
rs("ttype")=trim(request.Form("ttype"))
rs("mian_ji")=trim(request.Form("mian_ji"))
rs("price")=trim(request.Form("price"))
rs("car")=trim(request.Form("car"))
rs("green")=trim(request.Form("green"))
rs("rong_ji")=trim(request.Form("rong_ji"))
rs("total_num")=trim(request.Form("total_num"))
rs("zhuang_xiu")=trim(request.Form("zhuang_xiu"))
rs("wu_guan")=trim(request.Form("wu_guan"))
rs("kfs")=trim(request.Form("kfs"))
rs("xkz")=trim(request.Form("xkz"))
rs("s_address")=trim(request.Form("s_address"))
rs("tel")=trim(request.Form("tel"))
content=trim(request.Form("content"))
content=replace(content,chr(13)&chr(10),"<br>")
content=replace(content," "," ")
rs("content")=content
kfs_content=trim(request.Form("kfs_content"))
kfs_content=replace(kfs_content,chr(13)&chr(10),"<br>")
kfs_content=replace(kfs_content," "," ")
rs("kfs_content")=kfs_content
rs("picurl1")=trim(request.Form("picurl1"))
rs("picurl2")=trim(request.Form("picurl2"))
rs("picurl3")=trim(request.Form("picurl3"))
rs("picurl4")=trim(request.Form("picurl4"))
rs("picurl5")=trim(request.Form("picurl5"))
rs("picurl6")=trim(request.Form("picurl6"))
rs("picurl7")=trim(request.Form("picurl7"))
rs("picurl8")=trim(request.Form("picurl8"))
rs("userid")=request.Cookies("user_name")
rs("click")=1
rs.update
rs.close
set rs=nothing
response.Write(" 信息成功添加！")
end if
else %>
<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="4"><strong>新樓盤－在售－商鋪信息</strong></td>
</tr>
<tr>
<td width="18%">樓盤名稱：</td>
<td colspan="3"><input name="name2" type="text" id="name2"></td>
</tr>
<tr>
<td valign="top">地塊/建筑規劃：</td>
<td colspan="3"><textarea name="gui_hua" cols="50" rows="8" wrap="VIRTUAL" id="gui_hua"></textarea></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 width="32%"><input name="date1" type="text" size="11">
<br>
（請寫明年月日） </td>
<td width="17%">交房日期*： </td>
<td width="33%"><input name="date2" type="text" size="11">
<br>
（請寫明年月日或現房）</td>
</tr>
<tr>
<td> 物業類型*： </td>
<td> <select name="ttype" size="1" id="ttype">
<option value="街面獨立商鋪" selected>街面獨立商鋪</option>
<option value="店中店">店中店</option>
</select> </td>
<td>面積范圍*：</td>
<td> <input name="mian_ji" type="text" size="11">
平方米 </td>
</tr>
<tr>
<td>售價*： </td>
<td colspan="3"><input name="price" type="text" size="11">
元／平方米 （請寫明均價、起價、價格區間或待定） </td>
</tr>
<tr>
<td>車位數*：</td>
<td><input name="car" type="text" size="11">個</td>
<td>綠化率*： </td>
<td><input name="green" type="text" size="11">%</td>
</tr>
<tr>
<td>容積率*：</td>
<td ><input name="rong_ji" type="text" size="11"></td>
<td>總套數*：</td>
<td><input name="total_num" type="text" size="11">套</td>
</tr>
<tr>
<td>裝修情況*：</td>
<td><select name="zhuang_xiu" id="zhuang_xiu">
<option value="毛坯" selected>毛坯</option>
<option value="精裝">精裝</option>
</select></td>
<td>物管*：</td>
<td><input name="wu_guan" type="text" size="18"></td>
</tr>
<tr>
<td>開發商*：</td>
<td><input name="kfs" type="text" size="18"></td>
<td>銷售許可證*：</td>
<td><input name="xkz" type="text" size="18"></td>
</tr>
<tr>
<td>售樓地址*： </td>
<td><input name="s_address" type="text" size="18"></td>
<td> 售樓電話*： </td>
<td><input name="tel" type="text" size="18"></td>
</tr>
<tr>
<td valign="top">備注* </td>
<td colspan="3"><textarea name="content" cols="50" rows="8" wrap="VIRTUAL"></textarea></td>
</tr>
<tr>
<td valign="top">開發商簡介*：</td>
<td colspan="3"><textarea name="kfs_content" cols="50" rows="8" wrap="VIRTUAL"></textarea> </td>
</tr>
<tr>
<td valign="top">建筑效果圖：</td>
<td colspan="3"><input name="picurl1" type=text id="picurl22" size="30" readonly>
<a href="#" onClick=window.open("upload_form1.asp","","width=480,height=200,menubar=no,scrollbar=no")>上傳圖片</a></td>
</tr>
<tr>
<td valign="top">地理位置圖：</td>
<td colspan="3"><input name="picurl2" type=text id="picurl2" size="30" readonly>
<a href="#" onClick=window.open("upload_form2.asp","","width=480,height=200,menubar=no,scrollbar=no")>上傳圖片</a></td>
</tr>
<tr> <td valign="top">房型圖一：</td>
<td colspan="3"><input name="picurl3" type=text size="30" readonly> <a href="#" onclick=window.open("upload_form3.asp","","width=480,height=200,menubar=no,scrollbar=no")> 上傳圖片</a>
</td></tr>
<tr> <td valign="top">房型圖二：</td>
<td colspan="3"><input name="picurl4" type=text size="30" readonly> <a href="#" onclick=window.open("upload_form4.asp","","width=480,height=200,menubar=no,scrollbar=no")> 上傳圖片</a>
</td></tr>
<tr> <td valign="top">房型圖三：</td>
<td colspan="3"><input name="picurl5" type=text size="30" readonly> <a href="#" onclick=window.open("upload_form5.asp","","width=480,height=200,menubar=no,scrollbar=no")> 上傳圖片</a>
</td></tr>
<tr> <td valign="top">房型圖四：</td>
<td colspan="3"><input name="picurl6" type=text size="30" readonly> <a href="#" onclick=window.open("upload_form6.asp","","width=480,height=200,menubar=no,scrollbar=no")> 上傳圖片</a>
</td></tr>
<tr> <td valign="top">房型圖五：</td>
<td colspan="3"><input name="picurl7" type=text size="30" readonly> <a href="#" onclick=window.open("upload_form7.asp","","width=480,height=200,menubar=no,scrollbar=no")> 上傳圖片</a>
</td></tr>
<tr> <td valign="top">房型圖六：</td>
<td colspan="3"><input name="picurl8" type=text size="30" readonly> <a href="#" onclick=window.open("upload_form8.asp","","width=480,height=200,menubar=no,scrollbar=no")> 上傳圖片</a>
</td></tr>
<tr>
<td colspan="4"><div align="center">
<input type="submit" name="Submit" value="確定">
<input type="reset" name="Submit2" value="重填">
</div></td>
</tr>
</table>
</form>
<%end if
conn.close
set conn=nothing
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -