cash.asp

以前企业建网站

<!--#include file="top.asp"-->
<center>
<table bgcolor=
<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color")%>
<%rs.close%>
 border="0" width="780" cellspacing="0" cellpadding="0" height="312">
<tr>
<td width="150" valign="top" align="center">
<table border="0" width="150" cellspacing="0" cellpadding="0">
<tr>
<td width="150" valign="top" align="center" bgcolor=f7f7f7><!--#include file="left.asp"--></td>
</tr>
</table>
</td>
</center>
<td width="470" valign="top" align="center">
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="5">
<tr>
<td width="470"  align="center"><br>
<font size="3" color="#808080">您订购的物品如下：</font><b><br>
　</b></td>
</tr>
<tr>
<td width="470">
<form method="POST" action="cashsave.asp">
<table border="1" width="100%" cellspacing="1" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<tr>
<td width="25%" bgcolor="#FFFFFF">商品名称</td>
<td width="25%" bgcolor="#FFFFFF">单价</td>
<td width="25%" bgcolor="#FFFFFF">数量</td>
<td width="25%" 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%" bgcolor="#FFFFFF" height="30"><%=rs("hw_name")%></td>
<td width="25%" bgcolor="#FFFFFF" height="30"><%=rs("hw_cash")%></td>
<td width="25%" bgcolor="#FFFFFF" height="30"><%=rs("basket_count")%></td>
<td width="25%" bgcolor="#FFFFFF" height="30"><%=rs("hw_cash")*rs("basket_count")%></td>
</tr>
<%totalcash=totalcash+(rs("hw_cash")*rs("basket_count"))%><%rs.movenext
      loop
   session("sub_totalcash")=totalcash
   
      end if
      rs.close
      if mid(trim(session("sub_totalcash")),1,1)="." then
           session("sub_totalcash")="0"&session("sub_totalcash")
        end if
      %>
<tr>
<td width="105%" bgcolor="#FFFFFF" colspan="4">总计：<font color="red"><%=session("sub_totalcash")%></font>元</td>
</tr>
<tr>
<td width="105%" bgcolor="#FFFFFF" colspan="4">
<p align="center"><input type="submit" value="确定" name="B1"></td>
</tr>
</table>
</form>
</table>
</td>
<td width="160" valign="top" align="center" bgcolor=f7f7f7>
<table border="0" width="160" cellspacing="0" cellpadding="0">
<tr>
<td width="160" align="center"><!--#include file="right.asp"--></td>
</tr>
</table>
</td>
</tr>
</table>
<!--#include file="copy.asp"-->