📄 jszx.asp
字号:
%>
</b> <input name="userzhenshiname" type="hidden" value=<%=trim(request("userzhenshiname"))%>>
<input name="shousex" type="hidden" value=<%=trim(request("shousex"))%>>
<input name="useremail" type="hidden" value=<%=trim(request("useremail"))%>>
<input name="shouhuodizhi" type="hidden" value=<%=trim(request("shouhuodizhi"))%>>
<input name="youbian" type="hidden" value=<%=trim(request("youbian"))%>>
<input name="usertel" type="hidden" value=<%=trim(request("usertel"))%>>
<input name=userid type=hidden value="<%=request("userid")%>" >
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="32" colspan="2" align=center > <input type="button" name="Submit23" class="go-wenbenkuang" value="上一步" onClick="javascript:history.go(-1)">
<input type="submit" name="Submit424" class="go-wenbenkuang" value="下一步">
</td>
</tr>
</form>
</table>
<%
rs.close
set rs=nothing
'/////////////////////////////////////////
case "txxx3"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [shop_user] where username='"&request.cookies("snsn")("username")&"'",conn,1,1
%>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="f1f1f1" class="a1">
<td height="30" colspan="2" align="center" style='PADDING-LEFT: 20px'><b>请正确选择付款方式</b></td>
</tr>
<form name="shouhuoxx" method="post" action="jszx.asp?action=txxx4">
<tr bgcolor="#FFFFFF">
<td width="199" bgcolor="#FFFFFF" style='PADDING-LEFT: 20px'><b>付款方式：</b></td>
<td width="771" height="28" style='PADDING-LEFT: 20px' > <b>
<%
if cint(request("songhuofangshi"))=3 then
fukuan=1
else
fukuan=0
end if
'//////////判断支付方式
set rs3=server.CreateObject("adodb.recordset")
rs3.open "select * from shop_songhuo where fangshi=1 order by songidorder",conn,1,1
do while not rs3.eof
if not(fukuan=0 and trim(rs3("songid"))=4) then '显示不显示“货到付款”
response.Write "<input name=zhifufangshi type=radio value="&rs3("songid")
if rs3("songid")=21 then
response.Write " checked>"
else
response.Write ">"
end if
response.Write trim(rs3("subject"))
end if
rs3.movenext
loop
rs3.close
set rs3=nothing
%>
</b> <input name="userzhenshiname" type="hidden" value=<%=trim(request("userzhenshiname"))%>>
<input name="shousex" type="hidden" value=<%=trim(request("shousex"))%>>
<input name="useremail" type="hidden" value=<%=trim(request("useremail"))%>>
<input name="shouhuodizhi" type="hidden" value=<%=trim(request("shouhuodizhi"))%>>
<input name="youbian" type="hidden" value=<%=trim(request("youbian"))%>>
<input name="usertel" type="hidden" value=<%=trim(request("usertel"))%>>
<input name="songhuofangshi" type="hidden" value=<%=trim(request("songhuofangshi"))%>>
<input name=userid type=hidden value="<%=request("userid")%>" >
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="32" colspan="2" align=center > <input type="button" name="Submit24" class="go-wenbenkuang" value="上一步" onClick="javascript:history.go(-1)">
<input type="submit" name="Submit42" class="go-wenbenkuang" value="下一步">
</td>
</tr>
</form>
</table>
<%
rs.close
set rs=nothing
'/////////////////////////////////////////
case "txxx4"
%>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
<tr>
<td class="12v" > <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
<tr>
<td> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#FFFFFF">
<td align="center" valign="top" height=50 colspan=2>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select sum(shopcount) as Sum_jianshu,sum(zonger) as Sum_zonger from shop_action where username='"&request.cookies("snsn")("username")&"' and zhuangtai=7",conn,1,1
set rs=server.CreateObject("adodb.recordset")
rs.open "select shop_action.actionid,shop_action.shopid,shop_action.shopcount,shop_action.zonger,shop_snsn.shopname,shop_snsn.anclassid,shop_snsn.banci,shop_snsn.shichangjia,shop_snsn.huiyuanjia,shop_snsn.vipjia from shop_snsn inner join shop_action on shop_snsn.shopid=shop_action.shopid where shop_action.username='"&request.cookies("snsn")("username")&"' and shop_action.zhuangtai=7",conn,1,1
%>
<table width=100% border=0 align=center cellpadding=0 cellspacing=1 bgcolor="#CCCCCC" class="table-zuoshang">
<tr bgcolor="f1f1f1" class="a1">
<td width=21% height="22" > <div align=center>商品名称</div></td>
<td width=21% height="22" > <div align=center>市场价</div></td>
<td width=14% height="22" > <div align=center>单价
<%if request.cookies("snsn")("reglx")=2 then %>
(VIP)
<%else%>
<%if tmpPIFA=1 then %>
(批发)
<%else%>
(会员)
<%end if%>
<%end if%>
</div></td>
<td width=14% height="22" > <div align=center>数量</div></td>
<td width=14% height="22" > <div align=center>邮寄浮动<br>
(单价)</div></td>
<td width=14% height="22" > <div align=center>总价</div></td>
</tr>
<%shuliang=rs.recordcount
jianshu=0
zongji=0
fudongjia=0
do while not rs.eof%>
<tr bgcolor="#FFFFFF">
<td style='PADDING-LEFT: 5px' > <div align=left><%=rs("shopname")%>
<input name=shopid2 type=hidden value="<%=rs("shopid")%>" >
<%shopname=rs("shopname")%>
<input name=actionid2 type=hidden value="<%=rs("actionid")%>" >
</div></td>
<td align="center" ><s><%=rs("shichangjia")%></s>
元</td>
<td > <div align=center>
<%
if (request.Cookies("snsn")("reglx")=2) or (tmpPIFA=1) then
response.write rs("vipjia")
else
response.write rs("huiyuanjia")
end if%>
元</div></td>
<td > <div align=center> <%=rs("shopcount")%>
</div></td>
<td > <div align=center>
<%
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("snsn")("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("snsn")("reglx")=2 then
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 > <div align=center>
<%if tmpPIFA=1 then%>
<%=rs("vipjia")*rs("shopcount")%>
<%else%>
<%=rs("zonger")%>
<%end if%>
元</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 bgcolor="#FFFFFF">
<td height=36 colspan=7 > <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 bgcolor="#FFFFFF">
<td colspan="6" ><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" class="table-zuoshang">
<tr bgcolor="#FFFFFF">
<td height="23" colspan="2" ><b>您已选择的奖品清单</b></td>
</tr>
<tr align="center" bgcolor="f1f1f1" >
<td height="22" class="a1">奖品名称</td>
<td height="22" 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 bgcolor="#FFFFFF">
<td width="594" align="center" valign="top">
<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="16%" height="22" align="center" bgcolor="#FFFFFF" >姓名<br>
</td>
<td width="84%" ><%=request("userzhenshiname")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="16%" height="22" align="center" bgcolor="#FFFFFF" >邮编<br>
</td>
<td width="84%" ><%=request("youbian")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="16%" height="22" align="center" bgcolor="#FFFFFF" >地址<br>
</td>
<td width="84%" ><%=request("shouhuodizhi")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="16%" height="22" align="center" bgcolor="#FFFFFF" >电话<br>
</td>
<td width="84%" ><%=request("usertel")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="16%" height="22" align="center" bgcolor="#FFFFFF" >邮箱
</td>
<td width="84%" ><%=request("useremail")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="16%" height="22" align="center" bgcolor="#FFFFFF" >送货
</td>
<td width="84%" >
<%
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="16%" height="22" align="center" bgcolor="#FFFFFF" >支付</td>
<td width="84%" >
<%
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">
<table width="98%" border="0" align="right" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table-zuoshang">
<tr align="center" >
<td height="23" colspan="2" align="center" 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")
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -