?? jszx.asp
字號:
<!--#include file="../common/conn.asp"-->
<script language="JavaScript">
<!--
function demo(Page,scrl){
if (false)window.close();
if (!window.win || win.closed)
{
win=open(Page,"gouwu","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,top=2,width=450,height=350,scrollbars="+scrl+",resizable=1");
}
else{
win.close();
win=open(Page,"gouwu","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,top=2,width=450,height=350,scrollbars="+scrl+",resizable=1");
}
}
//-->
</script>
<%
if session("user_name")="" and session("company_name")="" then
response.write "<script language=javascript>alert('對不起，您還沒有登陸！');window.close();</script>"
response.End
end if
if session("user_name")<>"" then
uname=session("user_name")
else
uname=session("company_name")
end if
%>
<html>
<head>
<title>我要下訂單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
a:link { color: #4157F1; text-decoration: none }
a:visited { color: #4157F1; text-decoration: none }
a:hover { color: #668DF4; text-decoration: none; position: relative; right: 0px; top: 1px }
-->
</style>
<style>
td{font-size:x-small}
</style>
</head>
<body leftmargin="0" topmargin="5" marginwidth="0" marginheight="0">
<table width="96%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr>
<td> </td>
</tr>
</table>
<%
dim proname,action,i
action=request("action")
set rs=server.CreateObject("adodb.recordset")
sql="select * from scott.shopping_bag where sb_uname='"&uname&"'"
rs.open sql,connstr,1,1
if rs.eof then
response.write "<script language=javascript>alert('對不起，您的購物車內(nèi)沒有商品，請先選擇合適的商品，再來結(jié)帳吧 :-)');window.close();</script>"
response.End
end if
rs.close
set rs=nothing
select case action
case ""
set rs=server.CreateObject("adodb.recordset")
sql="select * from scott.shopping_bag where sb_uname='"&uname&"'"
rs.open sql,connstr,1,1
%>
<table width="96%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr>
<td height="40"><font color="#FF6633"><b>在最后結(jié)算前您還可以修改購物車內(nèi)容</b></font></td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFCC00">
<form name="form1" method="post" action="jszx.asp?action=txxx">
<tr bgcolor="#FFE697">
<td width="25%">
<div align="center"><font color="#666666">商品型號</font></div>
</td>
<td width="20%">
<div align="center"><font color="#666666">單價</font></div>
</td>
<td width="20%">
<div align="center"><font color="#666666">數(shù)量</font></div>
</td>
<td width="15%" bgcolor="#FFE697">
<div align="center"><font color="#666666">總價</font></div>
</td>
</tr>
<%
shuliang=rs.recordcount
jianshu=0
zongji=0
do while not rs.eof
sql="select product_id from scott.product_info where product_num='"&rs("sb_proname")&"'"
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open sql,connstr,1,1
%>
<tr bgcolor="#FFF9E6">
<td height="22">
<div align="center">
<a href=shp_detail.asp?id=<%=rs_s("product_id")%> target=_blank><%=rs("sb_proname")%></a> </div>
</td>
<td>
<div align="center">
<%=rs("sb_price")%> </div>
</td>
<td>
<div align="center"><%=rs("sb_amount")%></div>
</td>
<td bgcolor="#FFF9E6">
<div align="center"><font color="#FF3300"><%=rs("sb_total")%></font>元</div>
</td>
</tr>
<%
jianshu=jianshu+cint(rs("sb_amount"))
zongji=zongji+clng(rs("sb_total"))
rs.movenext
loop
rs_s.close
set rs_s=nothing
rs.close
set rs=nothing
%>
<tr bgcolor="#FFF9E6">
<td height="36" colspan="5">
<div align=center>
<input type="button" name="Submit" value="修改購物車" onClick="javascript:window.open('gouwu.asp?action=show&lx=1','gouwu','width=450,height=350,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');window.close()">
<input type="submit" name="Submit2" value="下一步">
</div>
</td>
</tr>
<tr bgcolor="#FFF9E6">
<td height="36" colspan="5">
<div align=center> 您的購物車?yán)镉猩唐罚?lt;%=shuliang%>件 總數(shù)量：<%=jianshu%>件 共計：<font color="#FF3300"><%=zongji%></font>元
</div>
</td>
</tr>
</form>
</table>
<%
case "txxx"
if session("company_name")="" then
set rs=server.createobject("adodb.recordset")
sql="select * from scott.user_info where user_id='"&uname&"'"
rs.open sql,connstr,1,1
%>
<form name="shouhuoxx" method="post" action="jszx.asp?action=txxx2">
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFF9E6">
<tr>
<td height="20" colspan="4" align="center" bgcolor="FFE697"><font color="#0000FF" size="-1">這是您注冊時的收貨信息，請核查</font></td>
</tr>
<tr>
<td width="20%" height="20" align="right"><font size="-1">客戶ID：</font></td>
<td width="30%" height="20">
<font size="-1"><%=rs("user_id")%> </font> </td>
<td width="20%"></td>
<td width="30%"></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1"> 客戶姓名：</font></div></td>
<td height="20"><%=rs("user_name")%></td>
<td><div align="right"><font size="-1">身份證號：</font></div></td>
<td><%=rs("user_idcard")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1"> 所在省份：</font></div></td>
<td height="20"><%=rs("user_province")%></td>
<td height="20"><div align="right"> <font size="-1">所在城市：</font></div></td>
<td><%=rs("user_city")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1"> 客戶地址：</font></div></td>
<td height="20"><%=rs("user_address")%></td>
<td height="20"><div align="right"><font size="-1">郵編： </font></div></td>
<td><%=rs("user_zipcode")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1">聯(lián)系電話：</font></div></td>
<td height="20"><%=rs("user_telphone")%></td>
<td height="20"><div align="right"><font size="-1">手機(jī)：</font></div></td>
<td><%=rs("user_mobilephone")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1">Email：</font></div></td>
<td height="20"><%=rs("user_email")%></td>
<td height="20" colspan="2" align="right"><font size="-1">如有錯誤，請<a href="update_user.asp" target="_blank">點(diǎn)擊此處</a>修改</font></td>
</tr>
<tr>
<td height="32" colspan="4" align=center>
<input type="button" name="Submit3" value="上一步" onclick="javascript:history.go(-1)">
<input type="submit" name="Submit4" value="下一步">
</td>
</tr>
</table>
</form>
<%
rs.close
set rs=nothing
else
set rs=server.createobject("adodb.recordset")
sql="select * from scott.company_info where company_name='"&uname&"'"
rs.open sql,connstr,1,1
%>
<form name="shouhuoxx" method="post" action="jszx.asp?action=txxx2">
<div align="center">
<table width="80%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFF9E6">
<tr>
<td height="20" colspan="4" align="center" bgcolor="FFE697"><font color="#0000FF" size="-1">這是您注冊時的收貨信息，請核查</font></td>
</tr>
<tr>
<td width="23%" height="20" align="right"><font size="-1">公司名稱：</font></td>
<td width="27%" height="20">
<font size="-1"><%=rs("company_name")%> </font> </td>
<td width="23%"></td>
<td width="27%"></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1"> 執(zhí)照號：</font></div></td>
<td height="20"><%=rs("company_idcard")%></td>
<td><div align="right"><font size="-1">聯(lián)系人：</font></div></td>
<td><%=rs("company_linkman")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1"> 所在省份：</font></div></td>
<td height="20"><%=rs("company_province")%></td>
<td height="20"><div align="right"> <font size="-1">所在城市：</font></div></td>
<td><%=rs("company_city")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1"> 公司地址：</font></div></td>
<td height="20"><%=rs("company_address")%></td>
<td height="20"><div align="right"><font size="-1">郵編： </font></div></td>
<td><%=rs("company_zipcode")%></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1">聯(lián)系電話：</font></div></td>
<td height="20"><%=rs("company_telphone")%></td>
<td height="20"><div align="right"><font size="-1">聯(lián)系人手機(jī)：</font></div></td>
<td><%=rs("company_lmmobilephone")%></font></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1">聯(lián)系人Email：</font></div></td>
<td height="20"><%=rs("company_lmemail")%></td>
<td height="20"><div align="right"><font size="-1">傳真：</font></div></td>
<td><%=rs("company_fax")%></td>
</tr>
<tr align="center">
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -