📄 jsactionshopxp.asp
字号:
<td><%
if request.Cookies("shopxp")("reglx")=2 then
response.write rs("shopxpvjia")
else
response.write rs("shopxphyjia")
end if%>
元</td>
<td><%=rs("productcount")%></td>
<td><%=rs("zonger")%> 元</td>
</tr>
<%
jianshu=jianshu+rs("productcount")
zongji=zongji+rs("zonger")
'算每件商品的浮动价
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from shopxp_fudong where id="&rs("banci"),conn,1,1
fudongjia=fudongjia+rs("productcount")*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 bgcolor=#ffffff>
<td height=30 colspan=6 align=center>货款总计：<font color=red><%=zongji%></font> 元
</td>
</tr>
<%set Godbook=server.CreateObject("adodb.recordset")
Godbook.open "select * from shopxp_action_jp where username='"&username&"' and zhuangtai=7",conn,1,1
if Godbook.recordcount>0 then%>
<tr>
<td colspan=6 bgcolor=#ffffff><table width="95%" border="0" cellspacing="1" cellpadding="1" bgcolor="#cccccc" align="center">
<tr bgcolor="#ffffff">
<td colspan="2" align="center">您已选择的奖品清单</td>
</tr>
<tr align="center" bgcolor="#f1f1f1">
<td>奖品名称</td>
<td>使用积分</td>
</tr>
<%
while not Godbook.eof%>
<tr bgcolor="#ffffff">
<td align="center"><%
set Godbook1=server.CreateObject("adodb.recordset")
Godbook1.open "select * from shopxp_jiangpin where shopxpptid="&Godbook("shopxpptid"),conn,1,1
if Godbook1.recordcount=1 then
response.write "<font color=blue>"&Godbook1("shopxpptname")&"</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%>
</table>
<br>
</td>
</tr>
<tr bgcolor="#ffffff">
<td width="50%" align="center" valign="top"><table width="90%" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="2" height="24" bgcolor="#f1f1f1" align="center">您的订单信息</td>
</tr>
<tr bgcolor="ffffff">
<td width="30%" align="center">姓名：</td>
<td width="70%" style="PADDING-LEFT: 20px"><%=request("shopxp_shiname")%></td>
</tr>
<tr bgcolor="ffffff">
<td align="center">邮编：</td>
<td style="PADDING-LEFT: 20px"><%=request("youbian")%></td>
</tr>
<tr bgcolor="ffffff">
<td align="center">地址：</td>
<td style="PADDING-LEFT: 20px"><%=request("shopxp_shdz")%></td>
</tr>
<tr bgcolor="ffffff">
<td align="center">电话：</td>
<td style="PADDING-LEFT: 20px"><%=request("usertel")%></td>
</tr>
<tr bgcolor="ffffff">
<td align="center">邮箱：</td>
<td style="PADDING-LEFT: 20px"><%=request("useremail")%></td>
</tr>
<tr bgcolor="ffffff">
<td align="center">送货：</td>
<td style="PADDING-LEFT: 20px"><%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shopxp_songhuo where songid="&request("shopxp_shfs"),conn,1,1
response.write rs("subject")
rs.close
set rs=nothing%>
</td>
</tr>
<tr bgcolor="ffffff">
<td align="center">支付：</td>
<td style="PADDING-LEFT: 20px"><%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shopxp_songhuo where songid="&request("zhifufangshi"),conn,1,1
response.write rs("subject")
rs.close
set rs=nothing%>
</td>
</tr>
</table></td>
<td width="50%" align="center" valign="top"><table width="90%" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="2" height="24" bgcolor="#f1f1f1" align="center">送货费计算</td>
</tr>
<%
'计算费用
'先取出参数
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shopxp_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 shopxp_songhuo where songid="&trim(request("shopxp_shfs")),conn,1,1
if cint(request("shopxp_shfs"))=3 then '先看是不是送货
rs.close
if request.Cookies("shopxp")("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("shopxp_shfs"))=1 then '看是不是"普通平邮"
rs.close
if request.Cookies("shopxp")("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("shopxp")("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 [Dv_User] where username='"&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
zj=feiyong+zongji
%>
<tr>
<td style="PADDING-right: 20px" align="right" bgcolor="ffffff"><%
set rs5=server.CreateObject("adodb.recordset")
rs5.open "select * from shopxp_songhuo where songid="&request("shopxp_shfs"),conn,1,1
response.write rs5("subject")&" "
response.write rs5("jsmoney")&"元"
jsmoney=rs5("jsmoney")
rs5.close
set rs5=nothing%>
</td>
</tr>
<tr>
<td style="PADDING-right: 20px" align="right" bgcolor="ffffff"><font color=red>您的订单总金额：<%=jsmoney+zongji%> 元 </font><%feiyong=jsmoney%></td>
</tr><% session("payall")=feiyong+zongji %>
<tr>
<td style="PADDING-right: 20px" align="right" bgcolor="ffffff"><a href="shopxphelp.asp?action=feiyong" >查看送货费用说明</a></td>
</tr>
</table></td>
</tr>
<form name="shouhuoxx" method="post" action="jsactionshopxp.asp?action=ok">
<tr bgcolor="#ffffff" align="center">
<td colspan="2"><table width="95%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="20%"><input type="checkbox" name="fapiao" value="1">
是否要发票？
<input name="shopxp_shiname" type="hidden" value=<%=trim(request("shopxp_shiname"))%>>
<input name="shousex" type="hidden" value=<%=trim(request("shousex"))%>>
<input name="useremail" type="hidden" value=<%=trim(request("useremail"))%>>
<input name="shopxp_shdz" type="hidden" value=<%=trim(request("shopxp_shdz"))%>>
<input name="youbian" type="hidden" value=<%=trim(request("youbian"))%>>
<input name="usertel" type="hidden" value=<%=trim(request("usertel"))%>>
<input name="shopxp_shfs" type="hidden" value=<%=trim(request("shopxp_shfs"))%>>
<input name="zhifufangshi" type="hidden" value=<%=trim(request("zhifufangshi"))%>>
<input name="feiyong" type="hidden" value=<%=feiyong%>>
<input name="zongji" type="hidden" value=<%=zongji%>>
<input name=userid type=hidden value="<%=request("userid")%>" >
</td>
<td width="60%"><input class="wenbenkuang" type="text" name="liuyan" size="35" maxlength="30">
您对此订单的特殊说明(30字内) </td>
<td width="20%" align="center" height="60"><input class="go-wenbenkuang" type="button" name="Submit22" value="上一步" onClick="javascript:history.go(-1)">
<input class="go-wenbenkuang" type="submit" name="Submit42" value="完 成">
</td>
</tr>
</table></td>
</tr>
</form>
</table></td>
</tr>
</table>
<%
case "ok"
'/////////////////////////////////////////////////
function HTMLEncode2(fString)
fString = Replace(fString, CHR(13), "")
fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
fString = Replace(fString, CHR(10), "<BR>")
HTMLEncode2 = fString
end function
'修改用户的送货信息
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [Dv_User] where username='"&username&"'",conn,1,3
rs("shopxp_shiname")=trim(request("shopxp_shiname"))
rs("sex")=trim(request("shousex"))
rs("useremail")=trim(request("useremail"))
rs("shopxp_shdz")=trim(request("shopxp_shdz"))
rs("youbian")=trim(request("youbian"))
rs("usertel")=trim(request("usertel"))
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -