📄 product_list.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
response.redirect "error.asp?error=001"
end if
product_name=request("product_name")
sort_name=request("sort_name")
csort_name=request("csort_name")
%>
<%
'开始删除操作
if request("del")="true" then
id=request("id")
conn.execute "delete * from 56770_product where id=" & id
url="product_list.asp?page=" & request("page")& "&sort_name=" & request("sort_name")& "&csort_name=" & request("csort_name")
response.redirect url
end if
%>
<link rel="stylesheet" href="css.css" type="text/css">
<body text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#FFFFFF" vspace="0" hspace="0">
<tr>
<td height="27" background="images/admin_bg_1.gif">.:: 您可以在这里进行商品相关操作</td>
</tr>
</table>
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#000000" align="center" width="100%">
<tr bgcolor="#6699CC">
<td colspan="2">商品搜索/管理</td>
</tr>
<form name="searchuser" method="post" action="product_list.asp">
<tr bgcolor="#B0CBE6">
<td align="right" width="29%">商品名:</td>
<td width="71%">
<input type="text" name="product_name" class="form">
</td>
</tr>
<tr bgcolor="#FFFF99">
<td colspan="2" align="center" bgcolor="#B0CBE6">
<input type="submit" name="Submit" value="确 定">
</td>
</tr>
</form>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="right">
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from 56770_sort order by sort_id", conn, 1, 1
if rs.eof and rs.bof then
response.write "目前还没有分类"
else%>
<select name="anclassid" onChange="var jmpURL=this.options[this.selectedIndex].value ;if(jmpURL!='') {window.location=jmpURL; }else{ this.selectedIndex=0; }" >
<option selected>--请选择商品分类--</option>
<option value=product_list.asp>查看全部商品</option>
<option value="product_list.asp?type=1">总会员价排列</option>
<option value="product_list.asp?type=2">总销售量排列</option>
<%do while not rs.eof%>
<option value="product_list.asp?sort_name=<%=rs("sort_name")%>"><%=trim(rs("sort_name"))%></option>
<%rs.movenext
loop
end if
rs.close
set rs=nothing
%>
<option value="product_list.asp?product_name=<%=product_name%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&type=1">此类会员价排列</option>
<option value="product_list.asp?product_name=<%=product_name%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&type=2">此类销售量排列</option>
</select>
</td>
</tr>
</table>
<table border="0" cellspacing="1" cellpadding="2" width="100%" align="center" background="images/admin_bg_1.gif">
<tr>
<td bgcolor="#6699CC" height="22" background="images/admin_bg_1.gif" width="5%">ID</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="23%">商品名</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="9%">一级分类</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="9%">二级分类</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="6%" align="center">推荐</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="6%" align="center">促销</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="6%" align="center">价格</td>
<td bgcolor="#6699CC" background="images/admin_bg_1.gif" width="6%" align="center">销量</td>
<td bgcolor="#6699CC" colspan="2" background="images/admin_bg_1.gif">操作</td>
</tr>
<%
product_name=request("product_name")
sort_name=request("sort_name")
csort_name=request("csort_name")
sql="select * from 56770_product where product_name<>''"
if product_name<>"" then sql=sql + " and product_name like '%"&product_name&"%'"
if sort_name<>"" then sql=sql + " and sort_name='"&sort_name&"'"
if csort_name<>"" then sql=sql + " and csort_name='"&csort_name&"'"
if request("type")="" then sql=sql + " order by day desc"
if request("type")="1" then sql=sql + " order by price desc"
if request("type")="2" then sql=sql + " order by buys desc"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sql, conn, 1, 2
if rs.eof then
Response.Write("<tr bgcolor=""#B0CBE6"">")
Response.Write("<td colspan=""11"" height=""50"" align=""center"" >目前本类还没有商品，请<a href=""product_add1.asp"">添加一个商品</a></td>")
Response.Write("</tr>")
else
if not isempty(request("page"))then
pagecount=cint(request("page"))
else
pagecount=1
end if
rs.pagesize=20
rs.AbsolutePage=pagecount
do while not rs.eof
%>
<tr bgcolor="#B0CBE6">
<td height="22" width="5%" ><%=rs("id")%></td>
<td width="20%"><%=rs("product_name")%></td>
<td width="9%"><%=rs("sort_name")%></td>
<td width="12%"><%=rs("csort_name")%></td>
<td align="center" width="5%">
<%if rs("stj")=true then response.write"<font color=#FF0000>是</font>" else response.write"否" end if %>
</td>
<td align="center" width="5%">
<%if rs("cx")=true then response.write"<font color=#FF0000>是</font>" else response.write"否" end if %>
</td>
<td align="center" width="5%"><%=rs("price")%></td>
<td align="center" width="5%"><%=rs("buys")%></td>
<td width="10%"><a href="product_edit.asp?id=<%=rs("id")%>">查看|编辑</a></td>
<td width="6%"> <a href="product_list.asp?del=true&id=<%=rs("id")%>&product_name=<%=rs("product_name")%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&page=<%=cstr(pagecount)%>">[删除]</a>
</td>
</tr>
<%
rs.movenext
i=i+1
if i >= rs.pagesize then exit do
loop
%>
<tr bgcolor="#D6DFF7">
<form action="product_list.asp" method="post">
<td height="35" colspan="11">
<div align="center"> 共 <b><%=rs.recordcount%></b> 个商品, 页次: <b><font color=red><%=pagecount%></font>/<%=rs.pagecount%></b>,
当前从第
<%
if pagecount <= 1 then
response.write "<font color=red>1</font>"
else
response.write "<font color=red>" & pagecount*rs.pagesize-rs.pagesize+1 & "</font>"
end if
%>
个开始。
<% if pagecount=1 and rs.pagecount<>pagecount and rs.pagecount<>0 then%>
<a href="product_list.asp?product_name=<%=product_name%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&page=<%=cstr(pagecount+1)%>&type=<%=request("type")%>">下一页</a>
<% end if %>
<% if rs.pagecount>1 and rs.pagecount=pagecount then %>
<a href="product_list.asp?product_name=<%=product_name%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&page=<%=cstr(pagecount-1)%>&type=<%=request("type")%>">
上一页</a>
<%end if%>
<% if pagecount<>1 and rs.pagecount<>pagecount then%>
<a href="product_list.asp?product_name=<%=product_name%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&page=<%=cstr(pagecount-1)%>&type=<%=request("type")%>">
上一页</a><ahref="product_list.asp?product_name=<%=product_name%>&sort_name=<%=sort_name%>&csort_name=<%=csort_name%>&page=<%=cstr(pagecount+1)%>&type=<%=request("type")%>">
下一页</a>
<% end if%>
直接到第
<select name="page">
<%for i=1 to rs.pagecount%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
页
<input type="submit" name="go" value="Go">
<input type="hidden" name="product_name" value=<%=product_name%>>
<input type="hidden" name="sort_name" value=<%=sort_name%>>
<input type="hidden" name="csort_name" value=<%=csort_name%>>
<input type="hidden" name="type" value=<%=request("type")%>>
</div>
</td>
</form>
</tr>
</table>
<%
end if
rs.close
set rs=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -