📄 subpass.asp
字号:
<%@LANGUAGE="VBSCRIPT" %>
<%
dim conn
dim connstr
Set conn=Server.CreateObject("ADODB.Recordset")
connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>我的订单</title>
<style type="text/css">
<!--
.style2 {font-size: x-small}
-->
</style>
<style>
td {
font-size: 13px;
}
</style>
</head>
<body>
<div align="left"><!-- #include file="pagetop.asp" --></div>
<div align="center"><center>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr height="20">
<td colspan="2"></td>
</tr>
<tr>
<td width="180px" valign="top">
<table width="180" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><!-- #include file="userinfo.asp" --></td>
</tr>
<tr>
<td><!-- #include file="companyinfo.asp" --></td>
</tr>
<tr>
<td><!-- #include file="search_easy.asp" --></td>
</tr>
</table>
</td>
<td valign="top">
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td width="15%" height="30">订单号</td>
<td width="20%">生成时间</td>
<td width="15%">总价</td>
<td width="15%">是否处理</td>
<td width="25%"></td>
<td width="10%"></td>
</tr>
<% if session("user_name")<>"" then
set rs=server.CreateObject("adodb.recordset")
sql="select distinct uof_id,uof_totalprice,uof_datetime,uof_consignment from GSCOTT.user_orderform_table where uof_userid='"&session("user_name")&"'"
rs.open sql,connstr,1,1
if err.number<>0 then
response.write "<p>数据库中暂时无数据</p>"
end if
if rs.eof And rs.bof then
%>
对不起，目前还没有您的订单信息。
<% else
do while not rs.eof
%>
<tr align="center">
<td height="30"><a href="spu_detail.asp?id=<%=rs("uof_id")%>" target="_blank"><%=rs("uof_id") %></a></td>
<td><%=rs("uof_datetime") %></td>
<td>
<%
set rs1=server.CreateObject("adodb.recordset")
sql1="select uof_totalprice,uof_sentmethod from GSCOTT.user_orderform_table where uof_id="&rs("uof_id")
rs1.open sql1,connstr,1,1
do while not rs1.eof
totalprice=0
totalprice=totalprice + clng(rs("uof_totalprice"))
rs1.movenext
loop
rs1.movefirst
if rs1("uof_sentmethod")="EMS特快专递" then
totalprice=totalprice + 10
else
totalprice=totalprice + 5
end if
%><%=totalprice%>
</td>
<td><%=rs("uof_consignment") %></td>
<td><a href="spc_detail.asp?id=<%=rs("uof_id")%>" target="_blank">浏览详细订单信息</a></td>
<td>
<%if rs("uof_consignment")= "否" then%>
<%orderid=rs("uof_id")%>
<a href="del_uorder_certain.asp?id=<%=orderid%>" target="_blank">删除</a>
<%else%>
订单已被处理 <%end if%>
</td>
</tr>
<%
rs.MoveNext
loop
rs1.Close
set rs1=nothing
rs.Close
set rs=nothing
end if
else
set rs=server.CreateObject("adodb.recordset")
sql="select distinct cof_id,cof_totalprice,cof_datetime,cof_consignment from GSCOTT.company_orderform_table where cof_companyname='"&session("company_name")&"'"
rs.open sql,connstr,1,1
if err.number<>0 then
response.write "<p>数据库中暂时无数据</p>"
end if
if rs.eof And rs.bof then
%>
对不起，目前还没有您的订单信息。
<% else
%>
<tr align="center">
<td height="30"><a href="spc_detail.asp?id=<%=rs("cof_id")%>" target="_blank"><%=rs("cof_id") %></a></td>
<td><%=rs("cof_datetime") %></td>
<td>
<%
do while not rs.eof
set rs1=server.CreateObject("adodb.recordset")
sql1="select cof_totalprice,cof_sentmethod from GSCOTT.company_orderform_table where cof_id="&rs("cof_id")
do while not rs1.eof
totalprice=0
rs1.open sql1,connstr,1,1
totalprice=totalprice + clng(rs("cof_totalprice"))
rs1.movenext
loop
if rs1("cof_sentmethod")="EMS特快专递" then
totalprice=totalprice + 10
else
totalprice=totalprice + 5
end if
%><%=totalprice%>
</td>
<td><%=rs("cof_consignment") %></td>
<td><a href="spc_detail.asp?id=<%=rs("cof_id")%>" target="_blank">浏览详细订单信息</a></td>
<td>
<%if rs("cof_consignment")= "否" then%>
<%orderid=rs("cof_id")%>
<a href="del_corder_certain.asp?id=<%=orderid%>"> target="_blank">删除</a>
<%else%>
订单已被处理 <%end if%>
</td>
</tr>
<%
rs.MoveNext
loop
rs1.Close
set rs1=nothing
rs.Close
set rs=nothing
end if
end if%>
</table>
</td>
</tr>
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<!-- #include file="pagefooter.html" -->
</center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -