📄 checkout.asp
字号:
<!--#include file="conn/conn.asp" -->
<% session("mName")=""
if request.Form("UserID")<>"" and request.Form("userPWD")<>"" then
session("ID1")=request.Form("UserID")
session("PWD")=request.Form("userPWD")
sql="SELECT userID, PassWord FROM tb_member WHERE userID='" & session("ID1")&"'"
set rs=conn.execute(sql)
if rs.eof then %>
<script language="javascript">
alert("登录失败!");
window.history.back();
</script>
<%else
if rs("password")=session("PWD") then
%>
<script language="javascript">
window.location.href="checkout_OK.ASP"
</script>
<%else%>
<script language="javascript">
alert("您输入的会员密码错误,请重新输入!");
history.back();
</script>
<%end if
end if
end if
'此处应用了视图v_deliver,该视图用于从tb_bookinfo和tb_fixprice数据表中获取图书的销售价
'没有定价的图书的销售价按定价计算
sql = "Select * from v_deliver Where barcode In (" & session("checkBook") & ")"
Set rs_C = conn.Execute( sql )
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>保存订单信息</title>
<LINK rel="stylesheet" href="CSS/STYLE.CSS" type="text/css">
<script language="JavaScript">
//检验会员ID号和密码
function check(){
if (form1.userID.value==""){
alert("请输入会员ID号!");form1.userID.focus();return;}
if (form1.userPWD.value==""){
alert("请输入会员密码!");form1.userPWD.focus();return;}
form1.submit();}
</script>
</head>
<body leftmargin="0" topmargin="0">
<table width="99%" height="10" border="0" align="center" cellpadding="-1" cellspacing="-1">
<tr>
<td height="20" bgcolor="#ffcf00"> </td>
</tr>
</table>
<table width="99%" height="273" border="0" align="center" cellpadding="-1" cellspacing="-1">
<tr>
<td height="273" valign="top"> <div align="center">
<form name="form1" method="POST" action="checkout.asp">
<table width="97%" height="119" border="0" cellpadding="-1" cellspacing="-1">
<tr>
<td height="37"> <div align="center"><strong><font color="#6699CC"> 如果您还不是我们的会员,请单击“注册”按钮注册会员!</font></strong></div></td>
</tr>
<tr>
<td> <table width="81%" height="70" border="0" align="center"
cellpadding="4" cellspacing="1" bgcolor="#FFCF00">
<tr>
<td width="32%" height="32" bgcolor="#FFFFFF"> <div align="right">会员ID号:</div></td>
<td width="36%" bgcolor="#FFFFFF"><input name="userID" type="text" id="userID"></td>
<td width="32%" bgcolor="#FFFFFF"> <a href="register.asp">注册</a></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">您的密码:</div></td>
<td bgcolor="#FFFFFF"><input name="userPWD" type="password" id="userPWD"></td>
<td bgcolor="#FFFFFF"><input type="button" name="Submit" value="保存" onClick="check()"></td>
</tr>
</table></td>
</tr>
</table>
<table width="97%" border="0" align="center" cellpadding="-1" cellspacing="-1">
<tr>
<td> <hr width="97%"></td>
</tr>
</table>
</form>
<table width="97%" height="27" border="0" align="center" cellpadding="-1" cellspacing="-1">
<tr>
<td><strong> 以下是您选购的图书:</strong></td>
</tr>
</table>
<table width="94%" border="1" align="center" cellpadding="0" cellspacing="0"
bordercolordark="#0000FF" bordercolorlight="#FFFFFF" bordercolor="#FFFFFF">
<tr>
<td width="17%" height="25"><div align="center">条形码</div></td>
<td width="39%"><div align="center">书名</div></td>
<td width="16%"><div align="center">单价</div></td>
<td width="11%"><div align="center">数量</div></td>
<td width="17%"><div align="center">金额</div></td>
</tr>
<% ASL=""
AID=""
ASL=split(session("sl"),",")
AID=split(session("checkBook"),",")
i=0
for i=0 to Ubound(AID)%>
<tr>
<td height="25"><div align="center"><%= rs_C("barcode") %></div></td>
<td> <%=rs_C("BookName")%></td>
<td><div align="right"> <%=rs_C("price")%>(元)</div></td>
<td><div align="center"><%= ASL(i)%></div></td>
<td><div align="right"> <%=CDBl(rs_C("price"))*ASL(i)%>(元)</div></td>
</tr>
<% rs_C.movenext
next %>
</table>
<br>
<input type="button" onClick="window.close();" value="关 闭">
</div></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -