?? snsn.asp
字號:
<tr bgcolor="#FFFFFF">
<td width="160" valign="middle" bgcolor="#E6F7FB" style='PADDING-LEFT: 20px'>送貨方式選擇：</td>
<td width="771" height="28" style='PADDING-LEFT: 20px'>
<%
set rs2=server.CreateObject("adodb.recordset")
rs2.Open "select * From shop_youbian where youbian like '"&nosql(left(trim(request("youbian")),4))&"%'",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_sys order by px",conn,1,1
do while not rs3.EOF
if not(shangmen=0 and trim(rs3("songid"))=1) then '顯示不顯示“送貨上門”
response.Write "<input name=songhuofangshi type=radio value="&rs3("songid")
response.Write " checked>"
response.Write trim(rs3("fsh"))
end if
rs3.MoveNext
loop
rs3.Close
set rs3=nothing
%>
(必需選擇)</td>
</tr>
</table>
<%
rs.close
set rs=nothing
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [shop_action] where userzhenshiname=userzhenshiname",conn,1,1
%>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="73D1E9">
<tr bgcolor="#C0E9F5" class="a1">
<td height="25" colspan="2" style='PADDING-LEFT: 20px'><b>請正確選擇付款方式</b></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="160" bgcolor="#E6F7FB" style='PADDING-LEFT: 20px'>付款方式選擇：</td>
<td width="771" height="28" style='PADDING-LEFT: 20px'>
<%
'//////////判斷支付方式
set rs4=server.CreateObject("adodb.recordset")
rs4.open "select * from shop_songhuo where songid<>1 order by songidorder",conn,1,1
do while not rs4.eof
response.Write "<input name=zhifufangshi type=radio value="&rs4("songid")
response.Write ">"
response.Write trim(rs4("subject"))
rs4.movenext
loop
rs4.close
set rs4=nothing
%><input name=userid type=hidden value="<%=request("userid")%>" >
(必需選擇) </td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="32" colspan="2" align=center >
<input name="Submit2" type="button" class="go-wenbenkuang" value="修改購物車" onClick="javascript:window.history.go(-1)">
<input type="button" name="Submit23" class="go-wenbenkuang" value="上一步" onClick="javascript:history.go(-1)">
<input type="submit" name="Submit42" class="go-wenbenkuang" value="下一步" onClick='return ssxx();'>
</td>
</tr>
</table></form>
<%
rs.close
set rs=nothing
case "a"
if request("songhuofangshi")="" then
response.write "<script language=javascript>alert('請?zhí)顚懰拓浄绞剑?#039;);window.history.go(-1);</script>"
response.end
end if
if request("zhifufangshi")="" then
response.write "<script language=javascript>alert('請?zhí)顚懼Ц斗绞剑?#039;);window.history.go(-1);</script>"
response.end
end if
%>
<table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
<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>
<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='"&nosql(session("tmp_usersessionid"))&"' and zhuangtai=7",conn,1,1
if (rs("Sum_jianshu")>clng(pifa_s)) or (rs("Sum_zonger")>clng(pifa_e)) then
tmpPIFA=1
else
tmpPIFA=0
end if
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,shop_snsn.pifajia from shop_snsn inner join shop_action on shop_snsn.shopid=shop_action.shopid where shop_action.username='"&nosql(session("tmp_usersessionid"))&"' and shop_action.zhuangtai=7",conn,1,1
%>
<table width=100% border=0 align=center cellpadding=0 cellspacing=1 bgcolor="73D1E9" class="table-zuoshang">
<tr bgcolor="#C0E9F5" class="a1">
<td height="23" bgcolor="#C0E9F5" >
<div align=center><strong>商品名稱</strong></div></td>
<td height="23" >
<div align=center><%=jiagename2%></div></td>
<td height="23" >
<div align=center><strong>單價 </strong></div></td>
<td height="23" >
<div align=center><strong>數(shù)量</strong></div></td>
<td height="23" >
<div align=center><strong>郵寄浮動
(單價)</strong></div></td>
<td height="23" >
<div align=center><strong><font color="<%=flzhbt%>">總價</font></strong></div></td>
</tr>
<%
shuliang=rs.recordcount
jianshu=0
zongji=0
fudongjia=0
do while not rs.eof
%>
<tr>
<td bgcolor="#FFFFFF" style='PADDING-LEFT: 5px' >
<div align=left><a href="research.asp?searchkey=<%=rs("shopname")%>" target="_blank"><%=rs("shopname")%></a>
<%shopname=rs("shopname")%><input name=shopname type=hidden value="<%=rs("shopname")%>" >
<input name=shopid type=hidden value="<%=rs("shopid")%>" >
<input name=actionid type=hidden value="<%=rs("actionid")%>" >
</div></td>
<td align="center" bgcolor="#FFFFFF" ><s><%=rs("shichangjia")%></s> 元</td>
<td bgcolor="#FFFFFF" >
<div align=center>
<%if tmpPIFA=1 then%>
<%=rs("pifajia")%>
<%else%>
<%=rs("shichangjia")%>
<%end if%>
元</div></td>
<td bgcolor="#FFFFFF" >
<div align=center> <%=rs("shopcount")%> </div></td>
<td bgcolor="#FFFFFF" >
<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 session("reglx")=2 then
fudongjia_dj=rs_s("smvip")
else
fudongjia_dj=rs_s("smhy")
end if
elseif cint(request("songhuofangshi"))=1 then '看是不是“平郵”
if session("reglx")=2 then
fudongjia_dj=rs_s("pyvip")
else
fudongjia_dj=rs_s("pyhy")
end if
else
if session("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("pifajia")*rs("shopcount")%>
<%else%>
<%=rs("zonger")%>
<%end if%>
</font>元</div></td>
</tr>
<%
jianshu=jianshu+rs("shopcount")
if tmpPIFA=1 then
zongji=zongji+rs("pifajia")*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=6 bgcolor="#FFFFFF" >
<div align=center> 貨款總計：<%=zongji%>元</div></td>
</tr>
</table>
<br>
</td>
</tr>
<tr>
<td width="594" align="center" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="73D1E9" class="table-zuoshang">
<tr align="center" bgcolor="#C0E9F5" class="a1">
<td height="23" colspan="2" ><b>您的訂單信息</b></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="23%" height="23" align="center" >姓名<br> </td>
<td width="77%" height="23" > <%=checkFFSQLStr(trim(request("userzhenshiname")))%></td>
</tr>
<tr bgcolor="#FFFFFF">
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -