📄 jszx.asp
字号:
<!--#include file="conn.asp"-->
<%if request.cookies("godbook")("username")="" then
response.write "<script language=javascript>alert('对不起，您还没有登陆！');history.go(-1);</script>"
response.End
end if%>
<!--#include file="webconfig.asp"-->
<html><head><title><%=webname%>--我要下订单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!--#include file="webtop.asp"-->
<%dim bookid,action,i
action=request("action")
set rs=server.CreateObject("adodb.recordset")
rs.open "select count(*) as rec_count from shop_action where username='"&request.cookies("godbook")("username")&"' and zhuangtai=7",conn,1,1
if rs("rec_count")=0 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")
rs.open "select shop_action.actionid,shop_action.bookid,shop_action.bookcount,shop_action.zonger,shop_books.bookname,shop_action.shjiaid,shop_books.shichangjia,shop_books.huiyuanjia,shop_books.vipjia from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid where shop_action.username='"&request.cookies("godbook")("username")&"' and shop_action.zhuangtai=7",conn,1,1
%>
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr>
<td class="table-shangxia" background="images/class_bg.jpg" height=50> <img src="images/ring02.gif" width="23" height="15" align="absmiddle"> <a href=index.asp><%=webname%></a> >> 下定单 <font color="#FF6633"><b>(在最后结算前您还可以修改购物车内容)</b></font></td>
</tr>
</table>
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr><td bgColor=#ffffff colSpan=6 height=1></TD></tr>
<form name='form1' method='post' action=jszx.asp?action=shop1>
<tr bgcolor="#f1f1f1" align="center">
<td width=20% height="30">商家名称</td>
<td width=25%>商品名称 </td>
<td width=15%>市场价</td>
<td width=15%>单价
<%if request.cookies("godbook")("reglx")=2 then %>
(VIP)
<%else%>
(会员)
<%end if%>
</td>
<td width=15%>数量</td>
<td width=10%>总价</td>
</tr>
<tr><td bgColor=#cccccc colSpan=6 height=1></TD></tr>
<tr><td bgColor=#f1f1f1 colSpan=6 height=3></TD></tr>
<%shuliang=rs.recordcount
jianshu=0
zongji=0
do while not rs.eof%>
<tr bgcolor="#ffffff">
<td height="30" width="20%" align="center" class="table-xia"><%id=rs("shjiaid")
if id>1 then
set rs_shj=server.CreateObject("adodb.recordset")
rs_shj.open "select name from shjia where shjiaid="&id,conn,1,1%>
<font color=#ff6600><%=rs_shj("name")%>
<%
rs_shj.close
set rs_shj=nothing
else
response.write "<font color=#ff6600>"&webname&""
end if%>
</font></td>
<td height="30" width="25%" class="table-xia">
<%=rs("bookname")%>
<input name=bookid type=hidden value="<%=rs("bookid")%>">
<input name=actionid type=hidden value="<%=rs("actionid")%>">
</td>
<td align="center" class="table-xia"><%=rs("shichangjia")%></td>
<td align="center" class="table-xia">
<%
if request.Cookies("godbook")("reglx")=2 then
response.write rs("vipjia")
else
response.write rs("huiyuanjia")
end if%>
元</td>
<td align="center" class="table-xia"><%=rs("bookcount")%></td>
<td align="center" class="table-xia"><%=rs("zonger")%> 元</td>
</tr>
<%
jianshu=jianshu+rs("bookcount")
zongji=zongji+rs("zonger")
rs.movenext
loop
rs.close
set rs=nothing%>
<tr bgcolor=#ffffff align=center>
<td height=30 colspan=6>
您的购物车里有商品：<%=shuliang%> 件 总数量：<%=jianshu%> 件 共计：<font color=red><%=zongji%></font> 元 您有预存款：<%=request.cookies("godbook")("yucun")%> 元
</td>
</tr>
<tr bgcolor=#ffffff align=center>
<td height=40 colspan=6>
<input class="go-wenbenkuang" type="button" name="Submit" value="修改购物车" onClick="this.form.action='gouwu.asp?action=show';this.form.submit()">
<input class="go-wenbenkuang" type="submit" name="Submit3" value="OK,下一步">
</td>
</tr>
<%set godbook=server.CreateObject("adodb.recordset")
godbook.open "select * from shop_action_jp where username='"&request.cookies("godbook")("username")&"' and zhuangtai=7",conn,1,1
if godbook.recordcount>0 then%>
<tr bgcolor="#ffffff">
<td colspan=6>
<table width="95%" border="0" cellspacing="1" cellpadding="1" bgcolor="#cccccc" align="center">
<tr bgcolor="#ffffff">
<td colspan="2" align="center" height="30">您已选择的奖品清单</td>
</tr>
<tr bgcolor="#cccccc" align="center">
<td height="30"><b><font color="#ffffff">奖品名称</font></b></td>
<td height="30"><b><font color="#ffffff">使用积分</font></b></td>
</tr>
<%while not godbook.eof%>
<tr bgcolor="#ffffff">
<td>
<%
set godbook1=server.CreateObject("adodb.recordset")
godbook1.open "select * from shop_jiangpin where bookid="&godbook("bookid"),conn,1,1
if godbook1.recordcount=1 then
response.write "<font color=blue>"&godbook1("bookname")&"</font>"
end if
godbook1.close
set godbook1=nothing%>
</td>
<td align="center"><%=godbook("jifen")%></td>
</tr>
<%godbook.movenext
wend%>
</table></td></tr>
<%end if
godbook.close
set godbook=nothing%>
</form>
</table>
<%
/////////////////////////////////////////
case "shop1"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [user] where username='"&request.cookies("godbook")("username")&"'",conn,1,1
userid=rs("userid")
%>
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr>
<td class="table-shangxia" background="images/class_bg.jpg" height=50> <img src="images/ring02.gif" width="23" height="15" align="absmiddle"> <a href=index.asp><%=webname%></a> >> 填写收货信息</td>
</tr>
</table>
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr><td bgColor=#ffffff colSpan=2 height=1></TD></tr>
<tr bgcolor="#ffffff">
<td bgColor="#f1f1f1" colspan="2" height="30" align="center">请正确填写以下收货信息</td>
</tr>
<tr><td bgColor=#cccccc colSpan=2 height=1></TD></tr>
<tr><td bgColor=#f1f1f1 colSpan=2 height=3></TD></tr>
<form name="shouhuoxx" method="post" action="jszx.asp?action=shop2" onsubmit="ssxx">
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">收货人真实姓名：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<input name=userid type=hidden value="<%=userid%>">
<input name="userzhenshiname" class="wenbenkuang" type="text" id="userzhenshiname" size="16" value=<%=trim(rs("userzhenshiname"))%>>
性别：
<select class="wenbenkuang" name="shousex" id="shousex">
<option value=1 <%if rs("sex")="1" then%>selected<%end if%>>男</option>
<option value=2 <%if rs("sex")="0" then%>selected<%end if%>>女</option>
<option value=0 <%if rs("sex")="2" then%>selected<%end if%>>保密</option>
</select>
</td>
</tr>
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">详细地址：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<input class="wenbenkuang" name="shouhuodizhi" type="text" id="shouhuodizhi" size="50" value=<%=trim(rs("shouhuodizhi"))%>>
</td>
</tr>
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">邮政编码：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<input class="wenbenkuang" name="youbian" type="text" id="youbian" size="16" value="<%=rs("youbian")%>" ONKEYPRESS="event.returnValue=IsDigit();"></td>
</tr>
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">联系电话：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<input class="wenbenkuang" name="usertel" type="text" id="usertel" size="16" value=<%=trim(rs("usertel"))%>>
</td>
</tr>
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">电子邮件：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<input class="wenbenkuang" name="useremail" type="text" id="useremail" size="30" value=<%=trim(rs("useremail"))%>>
</td>
</tr>
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">送货方式：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<%
set rs2=server.CreateObject("adodb.recordset")
rs2.Open "select * from youbian where youbian='"&trim(request("youbian"))&"'",conn,1,1
if rs2.recordcount=1 then
shangmen=1
else
shangmen=0
end if
rs2.close
set rs2=nothing
'//////////判断送货方式
set rs3=server.CreateObject("adodb.recordset")
rs3.Open "select * from shop_songhuo where fangshi=0 order by songidorder",conn,1,1
response.Write "<select name=songhuofangshi size=5 style='width:180px'>"
do while not rs3.EOF
if not(shangmen=3 and trim(rs3("songid"))=3) then '显示不显示“送货上门”
response.Write "<option value="&rs3("songid")
if int(rs("songhuofangshi"))=int(rs3("songid")) then
response.Write " selected>"
else
response.Write ">"
end if
response.Write trim(rs3("subject"))&"</option>"
end if
rs3.MoveNext
loop
response.Write "</select>"
rs3.Close
set rs3=nothing
%>
</td>
</tr>
<tr bgcolor="#ffffff">
<td width="30%" height="30" align="right" class="table-xia">支付方式：</td>
<td width="70%" height="30" style="PADDING-LEFT: 20px" class="table-xia">
<%
'set rs2=server.CreateObject("adodb.recordset")
'rs2.Open "select * from shop_songhuo where songid="&trim(request("songhuofangshi")),conn,1,1
if cint(request("songhuofangshi"))=3 then
fukuan=1
else
fukuan=0
end if
'rs2.close
'set rs2=nothing
'//////////判断支付方式
set rs3=server.CreateObject("adodb.recordset")
rs3.open "select * from shop_songhuo where fangshi=1 order by songidorder",conn,1,1
response.Write "<select name=zhifufangshi size=5 style='width:180px'>"
do while not rs3.eof
if not(fukuan=4 and trim(rs3("songid"))=4) then '显示不显示“货到付款”
response.Write "<option value="&rs3("songid")
if int(rs("zhifufangshi"))=int(rs3("songid")) then
response.Write " selected>"
else
response.Write ">"
end if
response.Write trim(rs3("subject"))&"</option>"
end if
rs3.movenext
loop
response.Write "</select>"
rs3.close
set rs3=nothing
%>
</td>
</tr>
<tr bgcolor="#ffffff">
<td height="40" colspan="2" align=center>
<input class="go-wenbenkuang" type="button" name="Submit2" value="上一步" onclick="javascript:history.go(-1)">
<input class="go-wenbenkuang" type="submit" name="Submit4" value="OK,下一步" onclick='return ssxx();'>
</td>
</tr>
</form>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
function IsDigit()
{
return ((event.keyCode >= 48) && (event.keyCode <= 57));
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function ssxx()
{
if(checkspace(document.shouhuoxx.userzhenshiname.value)) {
document.shouhuoxx.userzhenshiname.focus();
alert("对不起，请填写收货人姓名！");
return false;
}
if(checkspace(document.shouhuoxx.shouhuodizhi.value)) {
document.shouhuoxx.shouhuodizhi.focus();
alert("对不起，请填写收货人详细收货地址！");
return false;
}
if(checkspace(document.shouhuoxx.youbian.value)) {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -