📄 building_addaction.asp
字号:
<!--#include file=../conn/conn1.asp -->
<body bgcolor="#FFFFFF">
<% if request("price")="" or request("phone")="" or request("person")="" or request("name")="" then %>
<script language=vbs>
<!--
MsgBox "您没有输入完整的信息,请仔细检查!"
window.location.href="building_add.asp"
-->
</script>
<%else
qushu=Request.Form("dd")
qushu=Request.Form("dd")
cjyt=Request.Form("cjyt")
square=Request.form("square")
price=Request.Form("price")
name1=Request.Form("name")
phone=Request.Form("phone")
upfile=Request.Form("upfile")
person=Request.Form("person")
enddate=Request.Form("enddate")
addr=Request.Form("addr")
who=Request.Form("who")
content1=Request.Form("content1")
if 8<Csng(price) and Csng(price)<=10 then
J="B"
end if
if 10<Csng(price) and Csng(price)<=12 then
J="C"
end if
if 12<Csng(price) and Csng(price)<=15 then
J="D"
end if
if 15<Csng(price) and Csng(price)<=20 then
J="E"
end if
if 20<Csng(price) and Csng(price)<=25 then
J="F"
end if
if 25<Csng(price) and Csng(price)<=30 then
J="G"
end if
if 30<Csng(price) and Csng(price)<=40 then
J="H"
end if
if 40<Csng(price) and Csng(price)<=50 then
J="I"
end if
if 50<Csng(price) and Csng(price)<=100 then
J="J"
end if
if 100<Csng(price) and Csng(price)<=200 then
J="K"
end if
if 200<Csng(price) then
J="L"
end if
if content1="" then
content1=" "
end if
if addr="" then
addr=" "
end if
if enddate="" then
enddate=" "
end if
if who="" then
who=" "
end if
if square="" then
square=" "
end if
%>
<%
sql = "INSERT into building (name,qushu,cjyt,picture,addr,price,enddate,who,square,content,J,Tele, Contperson ) VALUES ('"& name1 &"','"& qushu &"','"& cjyt &"','"& upfile &"','"& addr &"','"& price &"','"& enddate &"','"& who &"','"& square &"','"& content1 &"','"& J &"','"& phone &"', '"& person &"')"
conn.Execute(sql)
%>
<script language=vbs>
<!--
MsgBox "您的信息已成功登记!点击继续……"
window.location.href="building_add.asp"
-->
</script>
<% End If %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -