📄 ordersave.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("user")="" then
response.write"<br><div align=center>你已过购物期限，请重新购物</div>"
end if
if request.form("yourname")="" then
response.write"<script language=javascript>alert('姓名请您填写');this.location.href='javascript:history.go(-1)';</script>"
end if
if request.form("phone")="" then
response.write"<script language=javascript>alert('电话号码请您填写');this.location.href='javascript:history.go(-1)';</script>"
end if
if request.form("email")="" then
response.write"<script language=javascript>alert('E-mail请您填写');this.location.href='javascript:history.go(-1)';</script>"
end if
if request.form("post")="" then
response.write"<script language=javascript>alert('邮编请您填写');this.location.href='javascript:history.go(-1)';</script>"
end if
if request.form("address")="" then
response.write"<script language=javascript>alert('地址请您填写');this.location.href='javascript:history.go(-1)';</script>"
end if
set rs=server.createobject("adodb.recordset")
sql="select * from songhuo where songid="&request("shfs")
rs.open sql,conn,1,1
if not rs.eof then
shfs=rs("subject")
fee=rs("money")
end if
rs.close
sql="select * from payment where id="&request("fkfs")
rs.open sql,conn,1,1
if not rs.eof then
fkfs=rs("bank")
acc=rs("account")
end if
rs.close
ornum=request("num")
sql="select * from theorder where order_number='"&ornum&"'"
rs.open sql,conn,3,3
if rs.eof then
response.write"<br><div align=center>没有此订单信息</div>"
response.end
else
rs("reciver")=trim(request("yourname"))
rs("guest_tel")=trim(request("phone"))
rs("guest_addr")=trim(request("address"))
rs("guest_post")=trim(request("post"))
rs("email")=trim(request("email"))
rs("way")=shfs
rs("money")=fkfs
rs("other")=trim(request("words"))
rs.update
end if
rs.close
%>
<html>
<head>
<title>购物成功</title>
<link href="css.css" rel="stylesheet">
</head>
<body>
<table width="480" border="0" align="center" cellpadding="0" cellspacing="0">
<tr class="tabbgcolorli">
<td> <font color="#FFFFFF">祝贺您购物成功</font></td>
</tr>
</table>
<br>
<table class="border3" width="480" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<% total=request("total")
%>
总费用为: <%=total%>元(商品费用)+<%=fee%>元(运输费用)=
<%response.Write formatnumber(total+fee,2)%>
元</td>
</tr>
</table>
<br>
<table class="border3" width="480" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">您所选择的<%=fkfs%>账号为:<br>
<%=acc%> <br>
如果您有其他问题，可以随时联系我们！ </div></td>
</tr>
</table>
<div align="center"><br>
</div>
<div align="center"><a href="javascript:window.close()"><font color="#000000">[关闭窗口]</font></a></div>
<%set rs=nothing%>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -