📄 jszx.asp
字号:
<%
dim conn
dim connstr
Set conn=Server.CreateObject("ADODB.Recordset")
connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<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:active { color: #668DF4; 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 GSCOTT.shopping_bag_table where sb_consumername='"&uname&"'"
rs.open sql,connstr,1,1
if rs.eof then
response.write "<script language=javascript>alert('对不起，您的购物车内没有商品，请先选择合适的商品，再来结帐吧 :-)');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 GSCOTT.shopping_bag_table where sb_consumername='"&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>在最后结算前您还可以修改购物车内容</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">数量</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 GSCOTT.product_info_table where product_kindnum='"&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> 您的购物车里有商品：<%=shuliang%>件 总数量：<%=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 GSCOTT.user_info_table 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">联系电话：</font></div></td>
<td height="20"><%=rs("user_telphone")%></td>
<td height="20"><div align="right"><font size="-1">手机：</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">点击此处</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 GSCOTT.company_info_table 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"> 执照号：</font></div></td>
<td height="20"><%=rs("company_idcard")%></td>
<td><div align="right"><font size="-1">联系人：</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">联系电话：</font></div></td>
<td height="20"><%=rs("company_telphone")%></td>
<td height="20"><div align="right"><font size="-1">联系人手机：</font></div></td>
<td><%=rs("company_lmmobilephone")%></font></td>
</tr>
<tr>
<td height="20"><div align="right"><font size="-1">联系人Email：</font></div></td>
<td height="20"><%=rs("company_lmemail")%></td>
<td height="20"><div align="right"><font size="-1">传真：</font></div></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -