cash.asp

ASP入门与提高实用教程 源文件(上传网站)

<!--#include file="top.asp"-->
<center>


<table border="0" width="760" cellspacing="0" cellpadding="0" height="312">
  <tr>
    <td width="190" height="312" valign="top" align="left">
    <table border="0" width="190" cellspacing="0" cellpadding="0">
      <tr>
        <td width="190" valign="top" align="left"><!--#include file="left.asp"--></td>
      </tr>
    </table>
    </td>
</center>
    <td width="380" valign="top" align="left">
    <table border="0" width="380" cellspacing="0" cellpadding="0" height="5">
      <tr>
        <td width="380" bgcolor="#FF9A31" height="18">
        你订购的物品如下:
        </td>
      </tr>
      <tr>
  <td width="100%">
    <form method="POST" action="cashsave.asp">
<table border="0" width="100%" cellspacing="1">
      <tr>
        <td width="25%" bgcolor="#FFFFFF">商品名称</td>
        <td width="25%" bgcolor="#FFFFFF">单价</td>
        <td width="25%" bgcolor="#FFFFFF">数量</td>
        <td width="26%" bgcolor="#FFFFFF">合计</td>
      </tr>
      
      <%
      user_name=session("user_name")
      sql="select * from basket where user_name='"&user_name&"' and basket_check=false"
      rs.open sql,conn,3,3
      if rs.eof then
          response.write "你没有订购任何商品"
      else
      do while not rs.eof
      %>
      <tr>
        <td width="25%"><%=rs("hw_name")%></td>
        <td width="25%"><%=rs("hw_cash")%></td>
        <td width="25%"><%=rs("basket_count")%></td>
        <td width="26%"><%=rs("hw_cash")*rs("basket_count")%></td>
      </tr><%totalcash=totalcash+(rs("hw_cash")*rs("basket_count"))%><%rs.movenext
      loop
      end if
      rs.close
      %>
      <tr>
        <td width="105%" bgcolor="#FFFFFF" colspan="4">总计：<font color=red><%=totalcash%></font>元</td>
      </tr>
      <tr>
        <td width="105%" bgcolor="#FFFFFF" colspan="4"><input type="submit" value="确定" name="B1"></td>
      </tr>
    </table></form>

<center>


<tr>
  <td width="100%"></td>
</tr>


<tr>
  <td width="100%">
</td>
</tr>
      </table>
    </td>
    <td width="190" valign="top" align="left">
    <table border="0" width="190" cellspacing="0" cellpadding="0">
      <tr>
        <td width="190"><!--#include file="right.asp"--></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
<!--#include file="copy.asp"-->