order1.asp

来自「书店的管理系统。不错的一个源程序。提供给大家。」· ASP 代码 · 共 86 行

ASP
86
字号
<%@ Language=VBScript %>
<%
'if Session("log_name")="" then
'	Session("after_log_to")="../payment/orderque1.asp"
'	Response.Redirect ("../userlog/login.htm")
'else
'	Session("after_log_to")=""
'end if

%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
</HEAD>
<BODY>

<%
set con=server.createobject("ADODB.Connection")
con.open Application("str_con")

set res=server.createobject("ADODB.Recordset")
set res.ActiveConnection = con

res.source="select order_id,order_time,name,total_exes,书店名称 from order_main order by order_id desc" ' where log_name='"&Session("log_name")&"'"
res.cursorlocation=3
res.open ,,adOpenDaynamic

if res.recordcount<1 then
	Response.Write "现在没有订单!"
	
	Res.close 
	con.Close 
else
%>

	<TABLE WIDTH=75% BORDER=1 CELLSPACING=1 CELLPADDING=1 align=center style="font-size: 9pt">
		<TR>
			
    <TD bgcolor="PapayaWhip">
      <div align="center">订单号</div>
    </TD>
			
    <TD bgcolor="PapayaWhip">
      <div align="center">订购日期/书店</div>
    </TD>
			
    <TD bgcolor="PapayaWhip">
      <div align="center">收货人</div>
    </TD>
			
    <TD bgcolor="PapayaWhip">
      <div align="center">应付款</div>
    </TD>
			
    <TD bgcolor="PapayaWhip">
      <div align="center">详细情况</div>
    </TD>
		</TR>
<%	While Not res.Eof %>
		<TR>
			<TD><%=res("order_id")%></TD>
			<TD><%=res("order_time")%><br><%=res("书店名称")%></TD>
			<TD><%=res("name")%></TD>
			<TD><%=res("total_exes")%></TD>
			<TD>
				<form method="POST" action="order2.asp">
					<input type="hidden" name="order_id" value="<%=res("order_id")%>">
					<p><input type="submit" value="详细情况" name="B1" style="font-size: 9pt"></p>
				</form>
			</TD>
		</TR>
		
<%		res.MoveNext
	Wend %>
	</TABLE>

<%
	Res.close 
	con.Close 
end if
%>


</BODY>
</HTML>

⌨️ 快捷键说明

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