jszx.asp

oracle9i程序事例集

    <td><%=rs("company_fax")%></td>
  </tr>
  <tr align="center">
    <td height="20" colspan="4" align="right"><font size="-1">如有错误，请<a href="update_company.asp" target="_blank">点击此处</a>修改</font></td>
  </tr>
  <tr bgcolor="#FFF9E6"> 
    <td height="32" colspan="4" align=center> 
    <input type="button" name="Submit3" value="上一步" onclick="javascript:history.go(-1)">
    <input type="submit" name="Submit4" value="下一步">
    </td>
  </tr>
</table>
</div>
</form>
<%
rs.close
set rs=nothing
end if
%>


<%
case "txxx2"
%>
<table width="96%" border="0" cellspacing="0" cellpadding="1" 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="2" cellspacing="1" bgcolor="#FFCC00">
                          <tr bgcolor="#FFF9E6"> 
                            <td colspan="2" style='PADDING-LEFT: 20px' height="40" align="center"><b><font color="#0000FF">请正确选择付款方式</font></b></td>
                          </tr>
                          <form name="shouhuoxx" method="post" action="jszx.asp?action=txxx3">
                            <tr bgcolor="#FFF9E6"> 
                              <td width="199" align="center">付款方式：</td>
                              <td width="771" height="28" style='PADDING-LEFT: 20px'> 
                              <select name="fukuan">
							  <option value="0">货到付款</option>
							  <option value="1">邮政汇款</option>
							  <option value="2">银行汇款</option>
							  </select></td>
                            </tr>
                            <tr bgcolor="#FFF9E6"> 
                              <td height="32" colspan="2" align=center> 
                                <input type="button" name="Submit2" value="上一步" onclick="javascript:history.go(-1)">
                                <input type="submit" name="Submit4" value="下一步">
                              </td>
                            </tr>
                          </form>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>


<%
case "txxx3"
%>

<table width="96%" border="0" cellspacing="0" cellpadding="1" 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="2" cellspacing="1" bgcolor="#FFCC00">
                          <tr bgcolor="#FFF9E6"> 
                            <td colspan="2" style='PADDING-LEFT: 20px' height="40" align="center"><b><font color="#0000FF">请正确选择送货方式</font></b></td>
                          </tr>
                          <form name="shouhuoxx" method="post" action="jszx.asp?action=txxx4">
						  <input name="fukuan" type="hidden" value="<%=request("fukuan")%>">
                            <tr bgcolor="#FFF9E6"> 
                              <td width="199" align="center">送货方式：</td>
                              <td width="771" height="28"> 
                              <select name="songhuo">
							  <option value="0">送货上门</option>
							  <option value="1">普通邮寄</option>
							  <option value="2">EMS特快专递</option>
							  </select>
							  </td>
                            </tr>
                            <tr bgcolor="#FFF9E6"> 
                              <td height="32" colspan="2" align=center> 
                                <input type="button" name="Submit2" value="上一步" onclick="javascript:history.go(-1)">
                                <input type="submit" name="Submit4" value="下一步">
                              </td>
                            </tr>
                          </form>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<%
case "txxx4"
fukuan=request("fukuan")
songhuo=request("songhuo")
select case fukuan
case "0"
fukuan="货到付款"
case "1"
fukuan="邮政汇款"
case "2"
fukuan="银行汇款"
end select

select case songhuo
case "0"
songhuo="送货上门"
money=5
case "1"
songhuo="普通邮寄"
money=5
case "2"
songhuo="EMS特快专递"
money=10
end select
%>
<table width="96%" border="0" cellspacing="0" cellpadding="1" 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="2" cellspacing="1" bgcolor="#FFCC00">
                          <tr bgcolor="#FFF9E6"> 
                            <td align="center" valign="top" height=50 colspan=2> 
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from GSCOTT.shopping_bag_table where sb_consumername='"&uname&"'"
rs.open sql,connstr,1,1 
%>
                              <table width=98% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFCC00>
                                <tr bgcolor="#FFE493">
								  <td width=20%> 
                                    <div align=center><font color="#666666">商品型号</font></div>
                                  </td>
                                  <td width=20%> 
                                    <div align=center><font color="#666666">单价</font></div>
                                  </td>
                                  <td width=20%> 
                                    <div align=center><font color="#666666">数量</font></div>
                                  </td>
                                  <td width=20%><div align=center><font color="#666666">商品总价</font></div></td>
                                </tr>
<%
shuliang=rs.recordcount
jianshu=0
zongji=0
do while not rs.eof
sql="select product_id from GSCOTT.product_info_table where product_kindnum='"&rs("sb_proname")&"'"
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open sql,connstr,1,1
%>
      <tr>
		<td height="22" bgcolor=#FFF9E6 style='PADDING-LEFT: 5px'> 
		<div align="center">
		<a href=shp_detail.asp?id=<%=rs_s("product_id")%> target=_blank><%=rs("sb_proname")%></a> 
        </div>
		</td>
        <td bgcolor=#FFF9E6> 
        <div align=center><%=rs("sb_price")%>元</div>
         </td>
                                  <td bgcolor=#FFF9E6> 
                                    <div align=center><font color=#dd6600> <%=rs("sb_amount")%> 
                                      </font></div>
                                  </td>
                                  <td bgcolor=#FFF9E6><div align=center><font color=#dd6600><%=rs("sb_total")%>元</font></div></td>
                                </tr>
                                <%
jianshu=jianshu+cint(rs("sb_amount"))
zongji=zongji+clng(rs("sb_total"))
rs_s.close
set rs_s=nothing
rs.movenext
loop
rs.close
set rs=nothing%>
                                <tr> 
                                  <td height=36 colspan=4 bgcolor=#FFF9E6> 
        <div align=center> 购物车里有商品：<%=shuliang%>件　总数：<%=jianshu%>件　共计：<font color=#FF3300><%=zongji%></font>元</div>
                                  </td>
                                </tr>
                              </table>
                            </td>
					      </tr>
                          <tr bgcolor="#FFF9E6"> 
                            <td width="594"  align="center" valign="top"> 
                              <table width="96%" border="0" cellspacing="0" cellpadding="2">
                                <tr> 
                                  <td colspan="2" height=8></td>
                                </tr>
<%
set rs=server.CreateObject("adodb.recordset")
if session("user_name")<>"" then
sql="select * from GSCOTT.user_info_table where user_id='"&uname&"'"
rs.open sql,connstr,1,1
%>                                
								<tr align="center" bgcolor="FFE493"> 
                                  <td colspan="2" height="22"><b>您的订单信息</b></td>
                                </tr>
                                <tr> 
                                  <td width="23%">姓名<br>
                                  </td>
                                  <td width="77%"><%=rs("user_name")%></td>
                                </tr>
                                <tr> 
                                  <td width="23%">邮编<br>
                                  </td>
                                  <td width="77%"><%=rs("user_zipcode")%></td>
                                </tr>
                                <tr> 
                                  <td width="23%">地址<br>
                                  </td>
                                  <td width="77%"><%=rs("user_address")%></td>
                                </tr>
                                <tr> 
                                  <td width="23%">电话<br>