📄 snsn.asp
字号:
fudongjia_dj=rs_s("pyvip")
else
fudongjia_dj=rs_s("pyhy")
end if
else
if request.Cookies("snsn")("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
%>
</div></td>
<td bgcolor="#FFFFFF" > <div align=center><font color=#FF3300>
<%if tmpPIFA=1 then%>
<%=rs("vipjia")*rs("shopcount")%>
<%else%>
<%=rs("zonger")%>
<%end if%>
</font>元</div></td>
</tr>
<%
jianshu=jianshu+rs("shopcount")
if tmpPIFA=1 then
zongji=zongji+rs("vipjia")*rs("shopcount")
else
zongji=zongji+rs("zonger")
end if
'算每件商品的浮动价
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from shop_fudong where id="&rs("banci"),conn,1,1
fudongjia=fudongjia+rs("shopcount")*fudongjia_dj
rs_s.close
set rs_s=nothing
rs.movenext
loop
rs.close
set rs=nothing%>
<tr>
<td height=36 colspan=7 bgcolor="#FFFFFF" >
<div align=center> 货款总计：<%=zongji%>元</div></td>
</tr>
<%set snsn=server.CreateObject("adodb.recordset")
snsn.open "select * from shop_action_jp where username='"&request.cookies("snsn")("username")&"' and zhuangtai=7",conn,1,1
if snsn.recordcount>0 then%>
<tr>
<td colspan="6" bgcolor="#FFFFFF" ><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><IMG height=5 src="images/block.gif" width=1></td>
</tr>
</table>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" >
<tr bgcolor="#FFFFFF">
<td height="23" colspan="2" ><b>您已选择的奖品清单</b></td>
</tr>
<tr align="center" bgcolor="f1f1f1" >
<td height="23" class="a1">奖品名称</td>
<td height="23" class="a1">使用积分</td>
</tr>
<%
while not snsn.eof%>
<tr bgcolor="#FFFFFF" >
<td>
<%
set snsn1=server.CreateObject("adodb.recordset")
snsn1.open "select * from shop_jiangpin where shopid="&snsn("shopid"),conn,1,1
if snsn1.recordcount=1 then
response.write "<font color=blue>"&snsn1("shopname")&"</font>"
end if
snsn1.close
set snsn1=nothing%>
</td>
<td align="center"><%=snsn("jifen")%></td>
</tr>
<%
snsn.movenext
wend%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><IMG height=5 src="images/block.gif" width=1></td>
</tr>
</table></td>
</tr>
<%end if
snsn.close
set snsn=nothing%>
</table>
<br> </td>
</tr>
<tr>
<td width="594" align="center" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table-zuoshang">
<tr align="center" bgcolor="f1f1f1" class="a1">
<td height="23" colspan="2" ><b>您的订单信息</b></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" >姓名<br>
</td>
<td width="77%" height="23" ><%=request("userzhenshiname")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" >邮编<br>
</td>
<td width="77%" height="23" ><%=request("youbian")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" >地址<br>
</td>
<td width="77%" height="23" ><%=request("shouhuodizhi")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" >电话<br>
</td>
<td width="77%" height="23" ><%=request("usertel")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" >邮箱
</td>
<td width="77%" height="23" ><%=request("useremail")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" >送货
</td>
<td width="77%" height="23" >
<%
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 bgcolor="#FFFFFF">
<td width="23%" height="23" >支付</td>
<td width="77%" height="23" >
<%
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>
</table></td>
<td width="356" align="center" valign="top" bgcolor="#FFFFFF">
<table width="98%" border="0" align="right" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table-zuoshang">
<tr align="center" >
<td height="22" colspan="2" bgcolor="f1f1f1" class="a1"><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")
if cint(request("songhuofangshi"))=3 then '先看是不是送货
'rs.close
if request.cookies("snsn")("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
else
'不是送货上门的还要看是什么方式送货
if cint(request("songhuofangshi"))=1 then '看是不是"普通平邮"
'rs.close
if request.cookies("snsn")("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("snsn")("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 [shop_user] where username='"&request.cookies("snsn")("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>"
end if
end if
end if
%>
<tr>
<td height="23" bgcolor="#FFFFFF" > </td>
</tr>
<tr>
<td height="23" align=right bgcolor="#FFFFFF" style='PADDING-right: 20px' >您的送货费用计： <%=feiyong%>
元</td>
</tr>
<tr>
<td height="23" align=right bgcolor="#FFFFFF" style='PADDING-right: 20px' >(其中 基价：<%=jijia%>元)</td>
</tr>
<tr>
<td height="23" align=right bgcolor="#FFFFFF" style='PADDING-right: 20px' >(浮动价：<%=fudongjia%>元)</td>
</tr>
<tr>
<td height="23" bgcolor="#FFFFFF" > </td>
</tr>
<tr>
<td height="23" align=right bgcolor="#FFFFFF" style='PADDING-right: 20px' ><b><font color="#FF0000">您的订单总金额： <%=feiyong+zongji%>
元</font></b></td>
</tr>
<tr>
<td height="23" align=right bgcolor="#FFFFFF" ><a href="help.asp?action=feiyong" target=_blank>查看送货费用说明</a></td>
</tr>
</table></td>
</tr>
<form name="shouhuoxx" method="post" action="snsn.asp?action=ok">
<tr align="center">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -