📄 jszx.asp
字号:
</td>
<td width="77%"><%=rs("user_telphone")%></td>
</tr>
<tr>
<td colspan="2" height=8></td>
</tr>
<tr>
<td width="23%">邮箱<br>
</td>
<td width="77%"><%=rs("user_email")%></td>
</tr>
<%
else
sql="select * from GSCOTT.company_info_table where company_name='"&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("company_name")%></td>
</tr>
<tr>
<td width="23%">邮编<br>
</td>
<td width="77%"><%=rs("company_zipcode")%></td>
</tr>
<tr>
<td width="23%">地址<br>
</td>
<td width="77%"><%=rs("company_address")%></td>
</tr>
<tr>
<td width="23%">电话<br>
</td>
<td width="77%"><%=rs("company_telphone")%></td>
</tr>
<tr>
<td colspan="2" height=8></td>
</tr>
<tr>
<td width="23%">联系人<br>
</td>
<td width="77%"><%=rs("company_linkman")%></td>
</tr>
<% end if %>
<tr>
<td colspan="2" height=8></td>
</tr>
<tr>
<td width="23%">送货方式<br>
</td>
<td width="77%">
<%=songhuo%> </td>
</tr>
<tr>
<td width="23%">付款方式</td>
<td width="77%">
<%=fukuan%>
</td>
</tr>
<tr>
<td width="23%"><br>
</td>
<td width="77%"> </td>
</tr>
</table>
</td>
<td width="356" align="center" valign="top">
<table width="96%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2" height=8></td>
</tr>
<tr align="center" bgcolor="#00CCFF">
<td colspan="2" height="22" bgcolor="#FFE493"><b>送货费计算</b></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td style='PADDING-right: 20px' align=right>您的送货费用计： <%=money%> 元<br>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td style='PADDING-right: 20px' align=right><b><font color=red>您的订单总金额： <%=money+zongji%> 元</font></b></td>
</tr>
<tr>
<td height=20></td>
</tr>
<tr>
<td align=right><a href="faq.asp#sh" target=_blank>查看送货费用说明</a></td>
</tr>
</table>
</td>
</tr>
<form name="shouhuoxx" method="post" action="jszx.asp?action=ok">
<tr bgcolor="#FFF9E6" align="center">
<td colspan="2">
<table width="98%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="27%">
<% if session("user_name")="" then %>
<input type="checkbox" name="huitan" value="1">是否会谈
<% end if %>
<input name="feiyong" type="hidden" value="<%=money+zongji%>" >
<input name="fukuan" type="hidden" value="<%=fukuan%>" >
<input name="songhuo" type="hidden" value="<%=songhuo%>" >
</td>
<td width="42%">您对此订单的特殊说明(30字内) <br>
<input type="text" name="liuyan" size="30" maxlength="30">
</td>
<td width="31%" align="center" height="60">
<input type="button" name="Submit22" value="上一步" onClick="javascript:history.go(-1)">
<input type="submit" name="Submit42" value=" 完 成 ">
</td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
case "ok"
if request("huitan")=1 then
negotiate="否"
else
negotiate="是"
end if
set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
sql="select * from GSCOTT.shopping_bag_table where sb_consumername='"&uname&"'"
rs.open sql,connstr,1,1
if session("company_name")="" then
sql="select * from GSCOTT.user_orderform_table"
else
sql="select * from GSCOTT.company_orderform_table"
end if
rs1.open sql,connstr,3,3
if rs1.eof then
id=1
else
rs1.movelast
id=cint(rs1(0))+1
end if
do while not rs.eof
rs1.addnew
if session("company_name")="" then
rs1("uof_id")=id
rs1("uof_userid")=uname
rs1("uof_pid")=rs("sb_proname")
rs1("uof_number")=rs("sb_amount")
rs1("uof_totalprice")=request("feiyong")
rs1("uof_paymethod")=request("fukuan")
rs1("uof_sentmethod")=request("songhuo")
rs1("uof_datetime")=now
rs1("uof_consignment")="否"
rs1("uof_remark")=request("liuyan")
else
rs1("cof_id")=id
rs1("cof_companyname")=uname
rs1("cof_pid")=rs("sb_proname")
rs1("cof_number")=rs("sb_amount")
rs1("cof_totalprice")=request("feiyong")
rs1("cof_paymethod")=request("fukuan")
rs1("cof_sentmethod")=request("songhuo")
rs1("cof_datetime")=now
rs1("cof_consignment")="否"
rs1("cof_remark")=request("liuyan")
rs1("cof_conversation")=negotiate
end if
rs1.update
rs.movenext
loop
rs1.close
set rs1=nothing
conn.Open connstr
conn.execute("delete from GSCOTT.shopping_bag_table where sb_consumername='"&uname&"'")
conn.close
rs.close
set rs=nothing
%>
<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>
<td height="23" bgcolor="FFF9E6">
<div align="center"><font color="#FF6600"><b>您的订单已经成功提交，我们会在第一时间进行处理，请记清您的订单号以备查询。</b></font></div>
</td>
</tr>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>订单号：<font color=red><%=id%></font></td>
</tr>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>订单查询：您可通过“<a href="javascript:;" onclick="javascript:window.open('user.asp?action=dingdan','','')">我的订单</a>”查询您的订单状态。</td>
</tr>
<%if request("fukuan")="货到付款" then %>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>您是选择的“货到付款”，我们会尽快给您送货的！</td>
</tr>
<% else %>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>请您在一周内依照您选择的支付方式进行汇款，汇款时请注明您的<font color="#FF0000">订单号</font>！</td>
</tr>
<% end if %>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>
<div align="right"><a href="#" onClick=javascript:window.close()>
关闭窗口</a></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%end select%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -