saveto.asp

自做的购物网站

<!--#include file="conn.asp"-->
<!--#include file="css.asp"-->
<title>购物成功！</title>
<%
if session("user_name")="" then
	response.write  "<br>"
	response.write "<center>"
    response.write "1.你尚未登录!请登录后再订购本站商品!"
    response.write "<br>2.第一次来本站，请先注册会员（免费）!"
  	response.write  "<br>"
	response.write  "<br>"
    response.end
end if

dim sql,rs
set rs=server.createobject("adodb.recordset")
if request("action")="buy" then

if request("count")="" then
    count=1
else
    count=request("count")
end if

if request("hw_id")="" then
    response.write "没有此货物!"
else
    hw_id=request("hw_id")
end if

sql="select * from basket where hw_id='"&hw_id&"' and user_name='"&session("user_name")&"' and basket_check=false"
rs.open sql,conn,3,3
if rs.eof then
rs.addnew
rs("hw_id")=hw_id
rs("user_name")=session("user_name")
rs("basket_count")=count
rs("basket_date")=now()
rs("hw_name")=request("hw_name")
rs("hw_cash")=request("hw_cash")
else
rs("basket_count")=int(rs("basket_count"))+int(count)
end if
rs.update
rs.close
%>
<%end if%>
<br>
<tr> 
    
  <td valign="top"> 
    <tr> 
          
  <td valign="top" height="120">
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#525e6b cellSpacing=0 
      cellPadding=0 width="100%" align=center border=1>
      <TBODY>
        <TR> 
          <TD width="100%"> <TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 
            cellSpacing=0 cellPadding=0 width="100%" border=0>
              <TBODY>
                <TR> 
                  <TD vAlign=top width=300> <TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 
                  cellSpacing=0 cellPadding=0 width="100%" 
                  background="images/pics2/infobg.gif" 
                  border=0>
                      <TBODY>
                        <TR> 
                          <TD width=45><IMG height=32 
                        src="images/pics2/icon.gif" 
                        width=40 border=0></TD>
                          <TD vAlign=middle><b><font color="#FFFFFF"> 
                            <%
        if request("sub_number")="" then
        response.write "没有此订单信息"
        else
        sub_to=request("sub_to")
        sub_adds=request("sub_adds")
        sub_mail=request("sub_mail")
        sub_tel=request("sub_tel")
		sub_post=request("sub_post")
        sub_number=request("sub_number")
		qian=request("qian")
        other=request("other")
        sql="select * from sub where sub_number='"&sub_number&"'"
        rs.open sql,conn,3,3
        rs("sub_to")=sub_to
        rs("sub_tel")=sub_tel
		rs("sub_post")=sub_post
        rs("sub_mail")=sub_mail
        rs("sub_adds")=sub_adds
		rs("qian")=qian
		rs("other")=other
        rs.update
        rs.close
        %>
                            </font></b> <font color="#FFFFFF">购物成功！ </font></TD>
                          <TD width=43> <P align=right><IMG height=32 
                        src="images/pics2/edge(1).gif" 
                        width=43 border=0></P></TD>
                        </TR>
                      </TBODY>
                    </TABLE></TD>
                  <TD align=right 
                background="images/pics2/rightbg.gif"> <IMG 
                  alt=- 
                  src="images/pics2/space1.gif" width="3" height="32"></TD>
                </TR>
              </TBODY>
            </TABLE></TD>
        </TR>
        <TR> 
          <TD width="100%"> <TABLE id=AutoNumber6 style="BORDER-COLLAPSE: collapse" 
            borderColor=#111111 cellSpacing=0 cellPadding=2 width="100%" 
            border=0>
              <TBODY>
                <TR> 
                  <TD width="100%"><br>
                    <div align="center">请记牢本订单号，你可以使用本订单号对成交情况进行查询和投诉<br>
                      <br>
                    </div>
                    <table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" background="IMAGES/pics2/infobg.gif">
                      <tr> 
                        <td height="25" bgcolor="#FFFFFF"><div align="right"><font color="#333333">您的订单号：</font> 
                            <font color="#333333"></font></div></td>
                        <td height="25" bgcolor="#FFFFFF"><div align="center"><font color="#FF3300"><b><%=sub_number%></b></font></div></td>
                      </tr>
                      <tr> 
                        <td width="26%" height="25" bgcolor="#FFFFFF"> <div align="right">收货人 
                            ：</div></td>
                        <td width="74%" height="25" bgcolor="#FFFFFF"> <div align="center"><%=sub_to%> 
                          </div></td>
                      </tr>
                      <tr> 
                        <td width="26%" height="25" bgcolor="#FFFFFF"> <div align="right">地址 
                            ：</div></td>
                        <td width="74%" height="25" bgcolor="#FFFFFF"> <div align="center"><%=sub_adds%> 
                          </div></td>
                      </tr>
                      <tr> 
                        <td width="26%" height="25" bgcolor="#FFFFFF"> <div align="right">邮编：</div></td>
                        <td width="74%" height="25" bgcolor="#FFFFFF"> <div align="center"><%=sub_post%> 
                          </div></td>
                      </tr>
                      <tr> 
                        <td width="26%" height="25" bgcolor="#FFFFFF"> <div align="right">电话：</div></td>
                        <td width="74%" height="25" bgcolor="#FFFFFF"> <div align="center"><%=sub_tel%> 
                          </div></td>
                      </tr>
                      <tr> 
                        <td width="26%" bgcolor="#FFFFFF" height="25"> <div align="right">E-mail：</div></td>
                        <td width="74%" bgcolor="#FFFFFF" height="25"> <div align="center"><%=sub_mail%> 
                          </div></td>
                      </tr>
                      <tr> 
                        <td width="26%" bgcolor="#FFFFFF" height="12"> <div align="right">付款方式：</div></td>
                        <td width="74%" bgcolor="#FFFFFF" height="25"> <div align="center"><%=qian%> 
                          </div></td>
                      </tr>
                      <tr> 
                        <td width="26%" bgcolor="#FFFFFF" height="12"> <div align="right">备注：</div></td>
                        <td width="74%" bgcolor="#FFFFFF" height="25"> <div align="center"><%=other%></div></td>
                      </tr>
                      <tr> 
                        <td colspan="2" bgcolor="#FFFFFF" height="21"> <table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
                            <tr> 
                              <td> <p style="word-spacing: 2; line-height: 150%; margin-top: 4; margin-bottom: 6"> 
                                  <font color="#666666">&nbsp;&nbsp;1.谢谢您在本站购物，如果您选择送货上门服务，请您放心，我们的工作人员会很快将商品送到府上。<br>
                                  &nbsp;&nbsp;2.如果您选择中国建设银行龙卡转帐方式，请您尽快转帐，并在转帐成功后马上给我们打电话确认最快只要半小时就给您发货！<br>
                              &nbsp;&nbsp;3.建行龙卡汇款：4367 4201 1073 8154 465<br>
                              汇款持卡人：任志华汇款城市：河北省邯郸市</font>
                          </td>
                            </tr>
                          </table></td>
                      </tr>
                    </table>
                    <br> <div align="center"><a href="javascript:history.go(-1)"><img src="IMAGES/pics2/back.gif" width="45" height="20" border="0"></a></div>
                <br> </TD>
                </TR>
              </TBODY>
            </TABLE></TD>
        </TR>
        <TR> 
          <TD width="100%" height="20" bgColor=#3e3e4b>&nbsp; </TD>
        <%end if%>
		</TR>
      </TBODY>
    </TABLE>