?? 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 + -