?? dingdan.asp
字號(hào):
<!--#include file="conn.asp"--><html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#799AE1">
<table width="86%" border="1" cellspacing="0" cellpadding="1" bordercolor="#336699" align="center">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="../images/back_3.gif" 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="96" width="100%">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" height="128">
<tr>
<td height="20" bgcolor="#FFFFFF">
<div align="center"><font color="#000000">定單管理</font></div>
</td>
</tr>
<tr>
<td height="2" valign="top" bgcolor="#E8F1FF"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="24">
<tr>
<td width="4%">ID</td>
<td width="8%">客戶</td>
<td width="12%">商品</td>
<td width="5%">總價(jià)</td>
<td width="4%">數(shù)量</td>
<td width="9%">支付方式</td>
<td width="20%">地址</td>
<td width="9%">電話</td>
<td width="11%">備注</td>
<td width="18%">時(shí)間</td>
</tr>
</table>
<% set rs=server.createobject("adodb.recordset")
sql="SELECT * from shop order by time desc"
rs.open sql,conn,1,3
page=1 ' 設(shè)置變量PAGE=1
rs.pagesize=20
if Not IsEmpty(Request("Page")) then '如果PAGE已經(jīng)初始化...
Page = CInt(Request("Page")) '接收PAGE并化為數(shù)字型賦給PAGE變量
if Page > rs.PageCount then '如果接收的頁數(shù)大于總頁數(shù)
rs.AbsolutePage = rs.PageCount '設(shè)置當(dāng)前顯示頁等于最后頁
else
rs.AbsolutePage = Page '顯示當(dāng)前頁等于接收的頁數(shù)
end if
else
Page = 1 '如果page未被初始化則設(shè)為1
End if
rs.AbsolutePage=page
%>
<%
For i = 1 to rs.PageSize
if rs.EOF then
Exit For
end if '利用for next 循環(huán)依次讀出記錄
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="13">
<tr>
<td width="4%"><%=rs("id")%></td>
<td width="8%"><%=rs("name")%></td>
<td width="12%"><%=rs("sname")%></td>
<td width="5%"><%=rs("jiage")%></td>
<td width="4%"><%=rs("shu")%></td>
<td width="9%">
<% if rs("zhifu")=1 then %>
<font color="#990000">定單購買</font>
<% else %>
在線支付
<% end if %>
</td>
<td width="22%"><%=rs("dizhi")%></td>
<td width="14%"><%=rs("dianhua")%></td>
<td width="4%"><img src="images/1.gif" width="18" height="18" alt="<%=rs("beizhu")%>"></td>
<td width="18%"><img src="images/1.gif" width="18" height="18" alt="<%=rs("time")%>"><img src="images/delete.gif" alt="刪除" width="12" height="12" border="0" onClick="if(confirm('您確定要?jiǎng)h除嗎？')){location='del.asp?id=<%=rs("id")%>'}else{return(false)}" onMouseMove="this.style.cursor='hand'">
<% if rs("ding")=0 then %>未處理
<% else %>
<font color="#990000">已完成</font>
<% end if %>
<img src="images/8.gif" width="18" height="18" border="0" onClick="if(confirm('您確定嗎？')){location='dingdanadd.asp?id=<%=rs("id")%>'}else{return(false)}" onMouseMove="this.style.cursor='hand'">
</td>
</tr>
</table><%rs.movenext
next %>
</td>
</tr>
<tr>
<td height="106" valign="top" bgcolor="#E8F1FF"><div align="right"><br>
<%if request("page")>1 then%>
<a Href="dingdan.asp?Page=<% = 1%>">首頁</a> <a Href="dingdan.asp?Page=<% =request("page") -1 %>">上一頁</a>
<%end if %>
<%if request("page")<>rs.pagecount then %>
<a Href="dingdan.asp?Page=<% =request("page") + 1%>">下一頁</a>
<a Href="dingdan.asp?Page=<% = rs.PageCount%>">尾頁</a>
<% end if %>
</div></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -