?? goods_manage.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="Cookies.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>發貨管理</title>
<style type="text/css">
<!--
.style1 {color: #0000FF}
-->
</style>
</head>
<body>
<h1 align="center" class="style1"> </h1>
<h1 align="center" class="style1">貨物發布管理</h1>
<%
dim rs,us
set rs=server.CreateObject("adodb.recordset")
us="select * From goods"
rs.Open us,conn,1
%>
<table width="98%" height="82" border="1" bordercolor="#0000FF">
<tr>
<th width="7%" height="44" scope="col">物品ID</th>
<th width="9%" scope="col">物品名稱</th>
<th width="9%" scope="col">一級類別</th>
<th width="9%" scope="col">二級類別</th>
<th width="5%" scope="col">單價</th>
<th width="9%" scope="col">面向地區</th>
<th width="7%" scope="col">存貨量</th>
<th width="9%" scope="col">已售出量</th>
<th width="9%" scope="col">折扣信息</th>
<th width="7%" scope="col">查看</th>
</tr>
<%
if Not rs.EOF and Not rs.BOF then
if Request.QueryString("page_no")="" then
page_no=1
else
page_no=cint(Request.QueryString("page_no"))
end if
rs.PageSize=10
rs.AbsolutePage=page_no
dim I
I=rs.PageSize
do while Not rs.EOF and I>0
I=I-1
%>
<tr>
<th height="30" scope="row"><%=rs("goods_id")%></th>
<th><%=rs("name")%></th>
<th><%=rs("class1")%></th>
<th><%=rs("class2")%></th>
<th><%=rs("price")%></th>
<th><%=rs("area")%></th>
<th><%=rs("inventory")%></th>
<th><%=rs("sale_num")%></th>
<th><%=rs("discount")%></th>
<th> <a href="goodsinfo.asp?goods_id=<%=rs("goods_id")%>">查看</a></th>
</tr>
<%
rs.MoveNext
loop
%>
</table>
<table width="751" border="0">
<tr>
<th width="745" scope="col">請選擇頁面：
<%
for I=1 to rs.PageCount
if I=page_no then
Response.Write I & " "
else
Response.Write ("<a href='goods_manage.asp?page_no=" & I & "'>" & I & "</a>")
end if
next
else
Response.Write "沒有用戶!"
end if
%> </th>
</tr>
</table>
<%
rs.close
set rs=nothing
call closedb()
%>
<table width="751" border="1">
<tr>
<th width="307" scope="col"> </th>
<th width="270" scope="col"><a href="goods_add.asp">添加貨物</a></th>
<th width="152" scope="col"> </th>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -