📄 jszx.asp
字号:
</tr>
<%shuliang=rs.recordcount
jianshu=0
zongji=0
fudongjia=0
do while not rs.eof
%>
<tr>
<td bgcolor=#FFF9E6 height="22" width="20%">
<%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%>
<div align=center><font color=#dd6600>
<%=rs_shj("name")%>
<%
rs_shj.close
set rs_shj=nothing
else
response.write "<div align=center><font color=#dd6600>网上商城"
end if%>
</font></div>
</td>
<td bgcolor=#FFF9E6 style='PADDING-LEFT: 5px'>
<div align=left><font color=blue><%=rs("bookname")%></font>
<input name=bookid2 type=hidden value="<%=rs("bookid")%>" >
<input name=actionid2 type=hidden value="<%=rs("actionid")%>" >
</div>
</td>
<td bgcolor=#FFF9E6 align="center"><s><%=rs("shichangjia")%></s>
元</td>
<td bgcolor=#FFF9E6>
<div align=center>
<%
if request.Cookies("songxf")("reglx")=2 then
response.write rs("vipjia")
else
response.write rs("huiyuanjia")
end if%>
元</div>
</td>
<td bgcolor=#FFF9E6>
<div align=center><font color=#dd6600> <%=rs("bookcount")%>
</font></div>
</td>
<td bgcolor=#FFF9E6>
<div align=center><font color=#dd6600>
<%
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from shop_fudong where id="&rs("banci"),conn,1,1
if cint(request("songhuofangshi"))=3 then '看是不是“送货上门”
if request.Cookies("songxf")("reglx")=2 then
fudongjia_dj=rs_s("smvip")
else
fudongjia_dj=rs_s("smhy")
end if
elseif cint(request("songhuofangshi"))=1 then '看是不是“平邮”
if request.Cookies("songxf")("reglx")=2 then
fudongjia_dj=rs_s("pyvip")
else
fudongjia_dj=rs_s("pyhy")
end if
else
if request.Cookies("songxf")("reglx")=2 then
fudongjia_dj=rs_s("emsvip")
else
fudongjia_dj=rs_s("emshy")
end if
end if
response.write fudongjia_dj
rs_s.close
set rs_s=nothing
%>
</font></div>
</td>
<td bgcolor=#FFF9E6>
<div align=center><font color=#FF3300><%=rs("zonger")%></font>元</div>
</td>
</tr>
<%
jianshu=jianshu+rs("bookcount")
zongji=zongji+rs("zonger")
'算每件商品的浮动价
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from shop_fudong where id="&rs("banci"),conn,1,1
fudongjia=fudongjia+rs("bookcount")*fudongjia_dj
rs_s.close
set rs_s=nothing
firstshjid=rs("shjiaid")
rs.movenext
if not rs.eof then
nextshjid=rs("shjiaid")
end if
if rs.recordcount<>1 and firstshjid<>nextshjid then
response.write "<script language=javascript>alert('对不起，您选购的商品不属于同一个商家，请重新下订单！');window.close();</script>"
exit do
end if
loop
rs.close
set rs=nothing%>
<tr>
<td height=36 colspan=7 bgcolor=#FFF9E6>
<div align=center> 货款总计：<%=zongji%>元</div>
</td>
</tr>
<%set songxf=server.CreateObject("adodb.recordset")
songxf.open "select * from shop_action_jp where username='"&request.cookies("songxf")("username")&"' and zhuangtai=7",conn,1,1
if songxf.recordcount>0 then%>
<tr>
<td colspan=7 bgcolor=#FFF9E6>
<table width="96%" border="0" cellspacing="1" cellpadding="1" bgcolor="#FFCC00" align="center">
<tr bgcolor="#FFF2CA">
<td colspan="2"><b>您已选择的奖品清单</b></td>
</tr>
<tr bgcolor="#FFE493" align="center">
<td><font color="#666666">奖品名称</font></td>
<td bgcolor="#FFE493"><font color="#666666">使用积分</font></td>
</tr>
<%
while not songxf.eof%>
<tr bgcolor="#FFF9E6">
<td>
<%
set songxf1=server.CreateObject("adodb.recordset")
songxf1.open "select * from shop_jiangpin where bookid="&songxf("bookid"),conn,1,1
if songxf1.recordcount=1 then
response.write "<font color=blue>"&songxf1("bookname")&"</font>"
end if
songxf1.close
set songxf1=nothing%>
</td>
<td align="center"><%=songxf("jifen")%></td>
</tr>
<%
songxf.movenext
wend%>
</table>
</td>
</tr>
<%end if
songxf.close
set songxf=nothing%>
</table>
</td>
</tr>
<tr bgcolor="#FFF9E6">
<td width="594" align="center" valign="top">
<table width="96%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2" height=8></td>
</tr>
<tr align="center" bgcolor="FFE493">
<td colspan="2" height="22"><b>您的订单信息</b></td>
</tr>
<tr>
<td width="23%">姓名<br>
</td>
<td width="77%"><%=request("userzhenshiname")%></td>
</tr>
<tr>
<td width="23%">邮编<br>
</td>
<td width="77%"><%=request("youbian")%></td>
</tr>
<tr>
<td width="23%">地址<br>
</td>
<td width="77%"><%=request("shouhuodizhi")%></td>
</tr>
<tr>
<td width="23%">电话<br>
</td>
<td width="77%"><%=request("usertel")%></td>
</tr>
<tr>
<td colspan="2" height=8></td>
</tr>
<tr>
<td width="23%">邮箱<br>
</td>
<td width="77%"><%=request("useremail")%></td>
</tr>
<tr>
<td colspan="2" height=8></td>
</tr>
<tr>
<td width="23%">送货<br>
</td>
<td width="77%">
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_songhuo where songid="&request("songhuofangshi"),conn,1,1
response.write rs("subject")
rs.close
set rs=nothing%>
</td>
</tr>
<tr>
<td width="23%">支付</td>
<td width="77%">
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_songhuo where songid="&request("zhifufangshi"),conn,1,1
response.write rs("subject")
rs.close
set rs=nothing%>
</td>
</tr>
<tr>
<td width="23%"><br>
</td>
<td width="77%"> </td>
</tr>
</table>
</td>
<td width="356" align="center" valign="top">
<table width="96%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2" height=8></td>
</tr>
<tr align="center" bgcolor="#00CCFF">
<td colspan="2" height="22" bgcolor="#FFE493"><b>送货费计算</b></td>
</tr>
<%
'计算费用
'先取出参数
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_sys ",conn,1,1
t_sm1=rs("sm1")
t_sm2=rs("sm2")
t_sm3=rs("sm3")
t_py1=rs("py1")
t_py2=rs("py2")
t_py3=rs("py3")
t_ems1=rs("ems1")
t_ems2=rs("ems2")
t_ems3=rs("ems3")
'先看是不是送货
'set rs=server.CreateObject("adodb.recordset")
'rs.open "select * from shop_songhuo where songid="&trim(request("songhuofangshi")),conn,1,1
if cint(request("songhuofangshi"))=3 then '先看是不是送货
'rs.close
if request.cookies("songxf")("reglx")=2 then
if zongji>=t_sm3 then
jijia=0
else
jijia=t_sm1
end if
else
if zongji>=t_sm2 then
jijia=0
else
jijia=t_sm1
end if
end if
feiyong=jijia+fudongjia
'fudongjia=0
else
'不是送货上门的还要看是什么方式送货
if cint(request("songhuofangshi"))=1 then '看是不是"普通平邮"
'rs.close
if request.cookies("songxf")("reglx")=2 then
if zongji>=t_py2 then
jijia=t_py1-t_py3
else
jijia=t_py1
end if
else
jijia=t_py1
end if
else
rs.close
if request.cookies("songxf")("reglx")=2 then
if zongji>=t_ems2 then
jijia=t_ems1-t_ems3
else
jijia=t_ems1
end if
else
jijia=t_ems1
end if
end if
'算商品基价+浮动价=费用
feiyong=jijia+fudongjia
if request("zhifufangshi")=17 then
'得到预存款
set rs2=server.CreateObject("adodb.recordset")
rs2.Open "select yucun from [user] where username='"&request.cookies("songxf")("username")&"'",conn,1,1
yucunkuan=rs2("yucun")
rs2.close
set rs2=nothing
if yucunkuan<feiyong+zongji then
response.write "<script language=javascript>alert('您的预存款不足，请更换支付方式！');history.go(-1);</script>"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -