?? allproduct.asp
字號:
<%@LANGUAGE="VBSCRIPT" %>
<!-- #include file="../common/conn.asp" -->
<!-- #include file="../common/status.html" -->
<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="10%">產品品牌</td>
<td width="15%">CPU</td>
<td width="12%">內存</td>
<td width="10%">硬盤</td>
<td width="25%">顯示器</td>
<td width="13%">價格</td>
</tr>
<%
Const MaxPerPage=10
dim totalPut
dim CurrentPage
dim TotalPages
dim j
if Not isempty(request("page")) then
currentPage=Cint(request("page"))
else
currentPage=1
end if
set rs=server.CreateObject("adodb.recordset")
sql="select product_id, product_num, product_brand, product_cpu, product_memory, product_harddisk, product_monitor, product_price from scott.product_info where product_isdel='n' order by product_id"
rs.open sql,connstr,1,1
if err.number<>0 then
response.write "<p>數據庫中暫時無數據</p>"
end if
if rs.eof And rs.bof then
%>
對不起，目前還沒有上架商品信息，請<a href="index.asp">返回主頁</a>。
<% else %>
<%
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage totalput,MaxPerPage,"allproduct.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage totalput,MaxPerPage,"allproduct.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"allproduct.asp"
end if
end if
end if
sub showContent
dim i
i=0
do while not rs.eof
%>
<tr align="center">
<td height="30"><a href="shp_detail.asp?id=<%=rs("product_id")%>" target="_blank"><%=rs("product_num") %></a></td>
<td><%=rs("product_brand") %></td>
<td><%=rs("product_cpu") %></td>
<td><%=rs("product_memory") %></td>
<td><%=rs("product_harddisk") %></td>
<td><%=rs("product_monitor") %></td>
<td><%=rs("product_price") %></td>
</tr>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.MoveNext
loop
rs.Close
set rs=nothing
%>
</table>
<%
end sub
Function showpage(totalnumber,maxperpage,filename)
Dim n
If totalnumber Mod maxperpage=0 Then
n= totalnumber \ maxperpage
Else
n= totalnumber \ maxperpage+1
End If %>
</td>
</tr>
<tr>
<td>
<form method="Post" action="<%=filename%>">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<% If CurrentPage<2 Then %>
<td width="8%" height="25"><span class="style2">首頁</span></td>
<td width="8%"><span class="style2">上一頁</span></td>
<% Else %>
<td width="8%"><a href=<%=filename%>?page=1 class="style2">首頁</a></td>
<td width="8%"><a href=<%=filename%>?page=<%=CurrentPage-1%> class="style2">上一頁</a></td>
<% end if %>
<% If n-currentpage<1 Then %>
<td width="8%"><span class="style2">下一頁</span></td>
<td width="8%"><span class="style2">末頁</span></td>
<% Else %>
<td width="8%"><a href=<%=filename%>?page=<%=(CurrentPage+1)%>><span class="style2">下一頁</span></a></td>
<td width="8%"><a href=<%=filename%>?page=<%=n%> class="style2">末頁</a></td>
<% end if %>
<td width="8%"><span class="style2">第<%=CurrentPage%>頁</span></td>
<td width="8%" class="style2">共<%=n%>頁</td>
<td width="16%" height="25" colspan="2" align="center" class="style2">共<%=totalnumber%>條記錄</td>
<td width="16%" colspan="2" align="center" class="style2">每頁<%=maxperpage%>條記錄</td>
<td colspan="2" align="center" width="20%"><span class="style2">轉到第
<input type="text" name="page" size="2" maxlength="10" value="<%=currentpage%>">
頁</span> <input type="submit" value="跳轉" name="cndok"></td>
</tr>
<tr><td height="20" colspan="13" align="right"> </td>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
End Function
%>
<!-- #include file="pagefooter.html" -->
</center>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -