📄 manage_product.asp
字号:
<!--#include file="cookies.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<script language=JavaScript>
function Display(ID)
{
if( ID.style.display == "none" )
{
ID.style.display = "" ;
}
else
{
ID.style.display = "none" ;
}
}
function say()
{
document.sayform.submit()
}
function GoPage(n)
{
document.goform.page.value=n;
document.goform.submit()
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>爱斯特淋浴设备有限公司管理后台</title>
<link href="../file/css.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../js/validator.js"></script>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f0f0f0">
<tr align="center" bgcolor="#FFFFFF">
<td width="200" valign="top" bgcolor="#B5BCC7"><table width="179" border="0" cellpadding="2" cellspacing="1" class="TableBorder">
<tr align="center" bgcolor="#F0F0F0">
<th width="204" height="31" >产品类别列表</th>
</tr>
<tr align="center">
<td height="25" align="center" valign="top" bgcolor="#eeeee6">
<% set rs=server.createobject("adodb.recordset")
sql="select * from product_sort order by sx asc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
response.Write("暂无产品分类")
end if
%>
<table width="170" border="0" cellpadding="0" cellspacing="0">
<% do while not rs.eof %>
<tr align="center" >
<td width="25" height="22" align="center" ><img src="../img/leftarror.gif" width="15" height="20"></td>
<td width="152" align="left"><a href="javascript:Display(M<%= rs("id") %>)"><%= rs("sort") %></a></td>
</tr>
<% set rs1=server.createobject("adodb.recordset")
sql="select * from product_small_sort where big_sortid="&rs("id")&" order by sx asc"
rs1.open sql,conn,1,1
%>
<tr align="center" id="M<%= rs("id") %>" style="DISPLAY: ">
<td height="22" align="center" > </td>
<td align="left"><table width="150" border="0" cellpadding="0" cellspacing="0">
<% do while not rs1.eof %>
<tr>
<td width="10"><img src="../img/bclass3.gif" width="24" height="20"></td>
<td width="136"><a href="?sort_id=<%= rs1("id") %>&sort=<%= rs1("sort") %>"><%= rs1("sort") %></a></td>
</tr>
<% rs1.movenext
loop
rs1.close
set rs1=nothing %>
</table></td>
</tr>
<% rs.movenext
loop
'rs.close
'set rs=nothing %>
</table></td>
</tr>
</table>
</td>
<td align="left" valign="top" bgcolor="#B5BCC7"><% set rs=server.CreateObject("adodb.recordset")
if request.QueryString("sort_id")="" then
sql="select * from product_info order by sx asc"
else
sql="select * from product_info where sort_id="&request.QueryString("sort_id")&" order by sx asc"
end if
rs.open sql,conn,1,1
%>
<table cellpadding="2" cellspacing="1" border="0" width="96%" class="tableBorder" align=center>
<tr bgcolor="#f0f0f0">
<th height="25" colspan="8" bgcolor="#E8F1FF"><font color="#FF0000">[
<% If request.QueryString("sort")="" Then %>
所有产品
<% Else %>
<%= request.QueryString("sort") %>
<% End If %>
]</font>产品列表</th>
</tr><!--#include file="../page1.asp"-->
<tr align="center" bgcolor="#FFFFFF">
<td width="80" height="25" class="TableRow2">缩略图</td>
<td width="190" class="TableRow2">名称</td>
<td width="50" class="TableRow2">点击数</td>
<td width="80" class="TableRow2">是否推荐</td>
<td width="80" class="TableRow2">是否显示</td>
<td width="50" class="TableRow2">排序</td>
<td width="50" class="TableRow2">修改</td>
<td width="50" class="TableRow2" >删除</td>
</tr>
<% for i=1 to x %>
<form name="form1" method="post" action="?action=save" onSubmit="return Validator.Validate(this,2)">
<tr onMouseOver="this.bgColor='#FAF9E3';" onMouseOut="this.bgColor='#FFFFFF';" bgcolor=#ffffff>
<td height="50" align="center" class="TableRow2"><table width="40" height="40" border="0" cellpadding="0" cellspacing="1" bgcolor="#D4D0C8">
<tr>
<td align="center" valign="middle" bgcolor="#EEEEE6"><% if rs("small_img")<>"" then %>
<img src="../../<%= rs("small_img") %>" width="30" height="30" border=0>
<% Elseif rs("big_img")<>"" then %>
<img src="../../<%= rs("big_img") %>" width="30" height="30" border=0>
<% Else %>
<font color="gray">暂无</font>
<% End If %> </td>
</tr>
</table></td>
<td align="center" class="TableRow2"><input name="id" type="hidden" id="id" value="<%= rs("id") %>">
<%= rs("product_name") %></td>
<td align="center" class="TableRow2"><%= rs("click") %></td>
<td align="center" class="TableRow2"><% If rs("tuijian")=1 Then %>
<a href="save_product.asp?id=<%=rs("id")%>&action=utuijian">已推荐</a>
<% Else %>
<a href="save_product.asp?id=<%=rs("id")%>&action=tuijian">未推荐</a>
<% End If %> </td>
<td align="center" class="TableRow2"><% If rs("pass")=1 Then %>
<a href="save_product.asp?id=<%=rs("id")%>&action=upass">已显示</a>
<% Else %>
<a href="save_product.asp?id=<%=rs("id")%>&action=pass">未显示</a>
<% End If %></td>
<td align="center" class="TableRow2"><%=rs("sx")%></td>
<td align="center" class="TableRow2"><a href="mod_product.asp?id=<%=rs("id")%>">修改</a></td>
<td align="center" class="TableRow2"><a href="save_product.asp?id=<%=rs("id")%>&action=delete" onClick="return confirm('您确定要删除吗？');">删除</a></td>
</tr>
</form>
<%rs.movenext
next %>
<tr align="center" bgcolor="#FFFFFF">
<td height="35" colspan="8" class="TableRow2"><!--#include file="../page2.asp"--></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -