⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 snsn.asp

📁 购物系统(本版为正式商业版
💻 ASP
📖 第 1 页 / 共 3 页
字号:
                <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('请填写送货方式!');window.history.go(-1);</script>"
response.end
end if
if request("zhifufangshi")="" then
response.write "<script language=javascript>alert('请填写支付方式!');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>数量</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"  >&nbsp;<%=checkFFSQLStr(trim(request("userzhenshiname")))%></td>
                                            </tr>
                                            <tr bgcolor="#FFFFFF">

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -