⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 checkout.asp

📁 《网上图书订购系统》 1.后台数据库:SQL Server 2000 2.在IIS服务器中新建站点
💻 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">&nbsp;</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>&nbsp;&nbsp;以下是您选购的图书:</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>&nbsp; <%=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 + -