📄 checkout.asp
字号:
<!--#INCLUDE FILE="odbc_connection.asp"-->
<!--#INCLUDE FILE="function1.asp"-->
<html>
<head>
<title>结账</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
'下面一句调用函数，执行结账操作，并返回产生的订单号
Dim OrderId
OrderId=CheckOut()
'下面显示该订单的有关信息，主要是显示给顾客看看
Dim strSql,rs,UserId,TotalNum,TotalMoney,SubmitDate,ConsignDate
strSql ="Select * From Orders where OrderId=" & OrderId
Set rs=db.Execute(strSql)
UserId=rs("UserId")
TotalNum=rs("TotalNum")
TotalMoney=rs("TotalMoney")
SubmitDate=rs("SubmitDate")
ConsignDate=rs("ConsignDate")
%>
<h2 align="center">请记住您的订单号:<%=OrderId%></h2>
<center>
<table border="0" width="80%" align="center" >
<%
'获取该订单的顾客详细信息
strSql ="Select * From Users where UserId='" & UserId & "'"
Set rs=db.Execute(strSql)
%>
<tr bgcolor="#F2F2F2">
<td width="20%">姓名：</td><td><%=rs("RealName")%></td>
</tr>
<tr bgcolor="#F2F2F2">
<td>通讯地址：</td><td><%=rs("Address")%></td>
</tr>
<tr bgcolor="#F2F2F2">
<td>邮政编码：</td><td><%=rs("Postalcode")%></td>
</tr>
<tr bgcolor="#F2F2F2">
<td>电话</td><td><%=rs("Tel")%></td>
</tr>
<tr bgcolor="#F2F2F2">
<td>E-mail：</td><td><%=rs("Email")%></td>
</tr>
<tr bgcolor="#F2F2F2">
<td>订货日期</td><td><%=SubmitDate%></td>
</tr>
<table>
<br>
<table border="0" width="80%" align="center" >
<caption align="left">订单明细</caption>
<tr bgcolor="#B7B7B7" align="center">
<td>图书编号</td><td>名称</td><td>单价</td><td>数量</td><td>小计</td>
</tr>
<%
'获取该订单的图书详细信息,这里使用联合查询，请对照SQL语言学习本语句
strSql="Select book.BookId,book.BookName,book.BookPrice,Orders_particular.BuyNum,(Book.BookPrice * Orders_particular.BuyNum) As subtotal From Orders_particular,book"
strSql=strSql & " where Orders_particular.OrderId=" & OrderId
strSql=strSql & " And Orders_particular.BookId=book.BookId"
strSql=strSql & " Order By book.BookId"
Set rs=db.Execute(strSql)
Do While Not rs.Eof
%>
<tr bgcolor="#F2F2F2" align="center">
<td><%=rs("BookId")%></td>
<td><%=rs("BookName")%></td>
<td><%=rs("BookPrice")%></td>
<td><%=rs("BuyNum")%></td>
<td><%=rs("subtotal")%></td>
</tr>
<%
rs.MoveNext
Loop
%>
<tr bgcolor="#F2F2F2" align="center">
<td colspan="3">总计</td><td><%=TotalNum%></td><td><%=FormatCurrency(TotalMoney)%></td>
</tr>
</table>
<p align=center><a href="JavaScript:close();">关闭窗口</a>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -