<!--#include file="conn.asp" -->
<!--#include file="inc/usdl.asp" -->
<% page_help="2" '分配本页帮助参数
%> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=page_title%>购物车...</title>
<link href="css.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>
<% user=session("us") 
if Trim(Request.QueryString("w"))="del" then

conn.execute("delete * from shop where bh="&Request.QueryString("id"))

ll=Trim(Request.QueryString("ll"))
sql="delete * from "&ll&"_shop where bh="&Request.QueryString("id")
conn.execute(sql)
end if

%>

<body leftmargin="3" topmargin="2" bgcolor="#C0C0C0">

<!--#include file="head.asp" -->
<table width="888" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="143" valign="top" bgcolor="#C0C0C0"> 
      　</td>
    <td width="134" valign="top" bgcolor="#FFFFFF"> 
      <p align="center">　</p>
      <p align="center"> 
        <!--#include file="in.asp" -->
        <!--#include file="helt_inc.asp" --></p>
      　</td>
    <td width="1" bgcolor="#FFFFFF"> </td>
    <td width="612" valign="top" bgcolor="#FFFFFF"> <p>&nbsp;</p>
      <table width="554" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr bgcolor="#EBEBEB"> 
          <td height="19" colspan="3" bgcolor="#000066" width="582"> <div align="left"><font color="#FFFFFF">尊敬的<strong><%= session("us") %></strong>，以下是您已购买的产品。购买完成可去收银台。</font></div></td>
        </tr>
        <tr valign="top"> 
          <td height="94" colspan="3" width="582"> <table width="550" border="1" cellpadding="0" cellspacing="0" bordercolor="#F9F9F9">
              <tr bgcolor="#EEEEEE"> 
                <td width="58" height="22"> 
                  <div align="center"><font color="#000099">商品编号</font></div></td>
                <td width="94"> 
                  <div align="center"><font color="#000099">商品名字</font></div></td>
                <td width="72"> 
                  <div align="center"><font color="#000099">商品价格</font></div></td>
                <td width="95"> 
                  <div align="center"><font color="#000099">商品数量</font></div></td>
                <td width="70"> 
                  <div align="center"><font color="#000099">删除</font></div></td>
                <td width="59"> 
                  <div align="center"><font color="#000099">总共价格</font></div></td>
                <td width="86"> 
                  <div align="center">结 账</div></td>
              </tr>
              <% 
			  zje=0
			  userid=session("us")
			  sql="select * from shop where userid='"&userid&"'and not jf"
			  rs.open sql,conn,1,1
			  if not rs.eof then 
			  while not rs.eof 
			   %>
              <tr onmouseover="this.style.backgroundColor='#EEF7FF';return true;" onmouseout="this.style.backgroundColor='#ffffff';"> 
                <td height="22" width="58"><div align="center"><%= rs("bh") %></div></td>
                <td width="94"><div align="center"><%= rs("mc") %></div></td>
                <td width="72"><div align="center">￥<%= rs("jg") %></div></td>
                <td width="95"><div align="center"><%= rs("sl") %></div></td>
                <td width="70"><div align="center"><a href="myshop.asp?w=del&id=<%= rs("bh") %>&ll=<%=rs("ll")%>"><img src="images/delete.gif" width="18" height="18" border="0"></a></div></td>
                <td width="59"><div align="center">￥<%= rs("je") %></div></td>
                <td width="86"><div align="center"><a href="user7.asp?w=jz&id=<%=rs("id")%>">－结账－</a></div></td>
              </tr>
              <%  
			  zje=zje+rs("je")
			  rs.movenext
			  wend
			  
			  else
			  Response.Write "<tr><td colspan=6><b>您的购物车里没有物品......</b></td></tr>"
			  end if
			  rs.close %>
              <tr > 
                <td height="1" colspan="7" width="546"><hr size="1"color="#FF9900"> </td>
              </tr>
              <tr> 
                <td height="22" colspan="5" width="397"><div align="right"><strong>总金额:</strong></div></td>
                <td height="22" colspan="2" width="147"><div align="center"><font color="#FF0000">￥<%= zje %></font></div></td>
              </tr>
            </table>
            <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td height="31" colspan="3" bgcolor="#EBEBEB" width="582"> <div align="center"> 
              <input name="Submit2" type="submit" onClick="MM_goToURL('parent','user7.asp');return document.MM_returnValue" value="-进入结账-">
              　　　<a href="default.asp">〖继续购物〗</a><br>
            </div></td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <table width="472" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="24"><img src="pic/bh.gif" width="17" height="8"></td>
          <td width="79"><a href="help.asp">支付方式</a></td>
          <td width="23"><img src="pic/bh.gif" width="17" height="8"></td>
          <td width="69"><a href="q5.asp">付款事宜</a></td>
          <td width="27"><img src="pic/bh.gif" width="17" height="8"></td>
          <td width="67"><a href="user.asp">产品价格</a></td>
          <td width="31"><img src="pic/bh.gif" width="17" height="8"></td>
          <td width="152"><a href="q3.asp">常见问题</a></td>
        </tr>
      </table>
      <p>&nbsp;</p></td>
  </tr>
</table>
<!--#include file="top.asp" -->

</body>
</html>
























