📄 save_list.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="session.asp"-->
<!--#include file="../include/code.asp"-->
<%
'**********************************
'版本:host_free 3.0 *
'官方网站:http://www.850518.com *
'技术论坛:http://forum.850518.com *
'qq:54455245 (欢迎咨询商业版) *
'msn: steven_bass@msn.com *
'手机:(0)13632779827 *
'mail:wtez@vip.163.com *
'版权所有，请保留该信息，谢谢合作 *
'**********************************
%>
<%
sub_number=request("sub_number")
set rs = server.createobject("adodb.recordset")
sql="select * from sub where sub_number='"&sub_number&"'"
rs.open sql,conn,3,3
sub_id=rs("sub_id")
%>
<html>
<head>
<meta http-equiv="content-language" content="zh-cn">
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<meta name="generator" content="microsoft frontpage 4.0">
<meta name="progid" content="frontpage.editor.document">
<link href="style.css" rel=stylesheet>
</head>
<body style="background-color: #eeeeee">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="1" width="600" bgcolor="#626262" height="451">
<tr>
<td height="18">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="50%"> <b><font color="#ffffff">订单号:<u><%=rs("sub_number")%></u></font></b></td>
<td width="50%"><font color="#ffffff"><b>状态:<u><%if rs("sub_check")=true then
response.write"确认订单"
else
response.write"<font color=#ff0000>未确认</font>"
end if%></u></b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="163" bgcolor="#ffffff">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" colspan="2"> </td>
</tr>
<tr>
<td width="25%" align="right" height="25">订购会员:</td>
<td width="75%" height="25"> <b><u><%=rs("d_name")%></u></b></td>
</tr>
<tr>
<td width="25%" align="right" height="25">联系电话:</td>
<td width="75%" height="25"> <b><u><%=rs("d_handphone")%></u></b></td>
</tr>
<tr>
<td width="25%" align="right" height="25">邮件地址:</td>
<td width="75%" height="25"> <b><u><%=rs("d_mail")%></u></b></td>
</tr>
<tr>
<td width="25%" align="right" height="25">qq或msn:</td>
<td width="75%" height="25"> <b><u><%=rs("d_oicq")%></u></b></td>
</tr>
<tr>
<td width="25%" align="right" height="25">用户备注:</td>
<td width="75%" height="25" style="border-collapse:collapse; word-break:break-all"> <%=rs("d_text")%></td>
</tr>
<tr>
<td width="100%" colspan="2"> </td>
</tr>
</table>
</td>
</tr>
<%rs.close
set rs=nothing
sub_number=request("sub_number")
set rss = server.createobject("adodb.recordset")
sql="select * from basket where sub_number='"&sub_number&"'"
rss.open sql,conn,3,3%>
<tr>
<td height="233" bgcolor="#ffffff">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="95%">
<tr>
<td width="100%"> </td>
</tr>
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="1" width="100%" bgcolor="#626262">
<tr>
<td width="25%" height="20" bgcolor="#626262" align="center"><font color="#ffffff">商品名称</font></td>
<td width="25%" height="20" bgcolor="#626262" align="center"><font color="#ffffff">商品单价</font></td>
<td width="25%" height="20" bgcolor="#626262" align="center"><font color="#ffffff">商品数量</font></td>
<td width="25%" height="20" bgcolor="#626262" align="center"><font color="#ffffff">商品总额</font></td>
</tr>
<%do while not rss.eof%>
<tr>
<td width="25%" height="20" bgcolor="#ffffff" align="center"><%=rss("sort_name")%></td>
<td width="25%" height="20" bgcolor="#ffffff" align="center"><%=rss("price")%>元/件</td>
<td width="25%" height="20" bgcolor="#ffffff" align="center"><%=rss("basket_count")%></td>
<td width="25%" height="20" bgcolor="#ffffff" align="center"><%=rss("basket_count")*rss("price")%>元</td>
</tr><%totalcash=totalcash+(rss("basket_count")*rss("price"))%>
<%rss.movenext
loop
%>
<tr>
<td width="102%" height="20" bgcolor="#ffffff" colspan="4"> 总额：<font color="#ff0000"><%=totalcash%></font>/元</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%"> </td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td height="25" bgcolor="#ffffff">
<p align="center"><a href="edit.asp?sub_id=<%=sub_id%>&action=pass">订单确认</a>
<a href="del.asp?sub_id=<%=sub_id%>&action=del_list_1">删除订单</a></p>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
<%
rss.close
set rss=nothing
conn.close
set conn=nothing%>
<%
'**********************************
'版本:host_free 3.0 *
'官方网站:http://www.850518.com *
'技术论坛:http://forum.850518.com *
'qq:54455245 (欢迎咨询商业版) *
'msn: steven_bass@msn.com *
'手机:(0)13632779827 *
'mail:wtez@vip.163.com *
'版权所有，请保留该信息，谢谢合作 *
'**********************************
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -