📄 info_edit3.asp
字号:
<!-- #include file="head.asp" -->
<!-- #include file="session.asp" -->
<TABLE width=760 border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="#FFFFFF" class=bk>
<TBODY>
<TR>
<TD colspan="2" align=middle vAlign=top>
<!-- #include file="diao2.asp" --><br>
</TD>
</TR>
<TR>
<TD colspan="2" align=middle vAlign=top>
<!-- #include file="lwconn.asp" -->
<%if request.querystring("save")="true" then
old1=request("old1")
old2=request("old2")
table=old1&old2
set rs2=server.createobject("adodb.recordset")
sql ="select * from "&table&" where id= "&trim(request.querystring("id"))
rs2.open sql,conn,1,3
if rs2.eof or rs2.bof then
response.Write("<br><div align=center>数据库 无该记录!</div>")
else
if rs2("userid")<>request.Cookies("user_name") then
%>
<script language=javascript>
history.back()
alert("你无权修改该记录!")
</script>
<%
Response.End
end if
if old1="z_" then
rs2("price")=trim(request.form("price"))
rs2("price2")=trim(request.form("price2"))
else
if old2<>"chang_fang" then
rs2("price")=trim(request.form("price"))
end if
rs2("total_price")=trim(request.form("total_price"))
end if
rs2("tel")=trim(request.form("tel"))
rs2("contact")=trim(request.form("contact"))
rs2("content")=trim(request.form("content"))
rs2.update
end if
rs2.close
set rs2=nothing
response.write "<center><h3>信息修改成功</h3></center>"
%>
<%else%>
<% old1=request("old1")
old2=request("old2")
%>
<% table=old1&old2
set rs=server.createobject("adodb.recordset")
sql ="select * from "&table&" where id= "&trim(request.querystring("id"))
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.Write("<br><div align=center>数据库中暂无任何记录!</div>")
else%>
<form action="?save=true&id=<%=request.querystring("id")%>&old1=<%=old1%>&old2=<%=old2%>"" method="post">
<TABLE style="BORDER-COLLAPSE: collapse"
borderColor=#dedede cellSpacing=0 cellPadding=4
width="65%" align=center border=1 bgColor=white>
<TR vAlign=bottom bgColor=#99ccff>
<TD colspan=2 align=center> 信息修改 </TD>
</TR>
<%if old1="z_" then %>
<TR vAlign=bottom ><TD width=100 bgColor=white><div align="center"> 租金 </div></TD><TD> <input name="price" type="text" id="price" size="10" value="<%=rs("price")%>">
元/月 </TD></TR>
<TR vAlign=bottom ><TD width=100 bgColor=white><div align="center"> 押金要求 </div></TD><TD> <input name="price2" type="text" id="price2" size="16" value="<%=rs("price2")%>">
元</TD></TR>
<%else
' chu shou
%>
<%if old2<>"chang_fang" then %>
<TR vAlign=bottom ><TD width=100 bgColor=white><div align="center"> 单价 </div></TD><TD><input name="price" type="text" id="price" size="10" value="<%=rs("price")%>">元/平方米 </TD></TR>
<%end if%>
<TR vAlign=bottom ><TD width=100 bgColor=white><div align="center"> 总价 </div></TD><TD> <input name="total_price" type="text" id="total_price" size="16" value="<%=rs("total_price")%>">
万元</TD></TR>
<%end if%>
<TR vAlign=bottom ><TD width=100 bgColor=white><div align="center"> 联系人 </div></TD><TD> <input value="<%=rs("contact")%>" name="contact" type="text" size="16"></TD></TR>
<TR vAlign=bottom >
<TD
><div align="center"> 联系电话 </div></TD>
<TD bgColor=white ><input name="tel" type="text" value="<%=rs("tel")%>" size="16"> </TD>
</TR><TR valign="top" ><TD width=100 bgColor=white><div align="center" > 备 注 </div></TD><TD><textarea name="content" cols="55" rows="16" wrap="VIRTUAL" id="content"><%=rs("content")%></textarea> </TD></TR>
<TR valign="top" ><TD width=100 bgColor=white><div align="center" > </div></TD><TD>
<div align="center">
<input type="submit" name="Submit" value="保存修改">
<input type="reset" name="Submit2" value="复 位">
</div>
</TD></TR>
</table></form>
<%
end if
rs.close
set rs=nothing
end if
conn.close
set conn=nothing %>
<p><br></p> </TD>
</TR>
</TBODY>
</TABLE>
<!-- #include file="footer.asp" -->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -