📄 admin_sortmanage.asp
字号:
<!-- #include file="inc/config.asp" -->
<!-- #include file="inc/md5.asp" -->
<!-- #include file="inc/conn.asp" -->
<%
if session("adminname")="" then
response.redirect "admin_login.asp"
response.end
end if
%>
<HTML>
<HEAD>
<TITLE>商品类别管理</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<style type=text/css>
body { background:#AEC9FB; margin:0px; font:normal 12px 宋体;
SCROLLBAR-FACE-COLOR: #799AE1; SCROLLBAR-HIGHLIGHT-COLOR: #799AE1;
SCROLLBAR-SHADOW-COLOR: #799AE1; SCROLLBAR-DARKSHADOW-COLOR: #799AE1;
SCROLLBAR-3DLIGHT-COLOR: #799AE1; SCROLLBAR-ARROW-COLOR: #FFFFFF;
SCROLLBAR-TRACK-COLOR: #AABFEC;
}
table { border:0px; }
td { font:normal 12px 宋体; }
img { vertical-align:bottom; border:0px; }
a { font:normal 12px 宋体; color:#000000; text-decoration:none; }
a:hover { color:#428EFF;text-decoration:underline; }
.sec_menu { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title { }
.menu_title span { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2 { }
.menu_title2 span { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
</style>
<BODY>
<p> </p>
<%
dim action,rs,sid,rs1
sid=request.querystring("id")
action=request.querystring("action")
select case action
case "add"
call sort_add()
case "del"
call sort_del()
case "edit"
call sort_edit()
case else
call sort_list()
end select
sub sort_add
set rs=server.createobject("adodb.recordset")
rs.open "select * from goods_sort",conn,1,3
rs.addnew
rs("sortname")=trim(request("sortname"))
rs("sortorder")=trim(request("sortorder"))
rs.update
rs.close
set rs=nothing
response.write"<script>alert('添加成功！');location.assign('admin_sortmanage.asp');</script>"
end sub
sub sort_del()
conn.execute("delete from goods_sort where sid="&sid)
response.redirect"admin_sortmanage.asp"
end sub
sub sort_edit()
set rs=server.createobject("adodb.recordset")
rs.open "select * from goods_sort where sid="&sid,conn,1,3
rs("sortname")=trim(request("sortname2"))
rs("sortorder")=trim(request("sortorder2"))
rs.update
rs.close
set rs=nothing
response.write"<script>alert('修改成功！');location.assign('admin_sortmanage.asp');</script>"
end sub
sub sort_list()
%>
<table cellpadding="0" cellspacing="1" border="0" align=center width="70%" bgcolor="#cacaca">
<tr><td colspan=4 align=center height=30 bgcolor=#ffffff>商品类别管理</td></tr>
<tr align=center bgcolor=#BADCF8 height=25><td>类别名称</td>
<td width=50>排序</td><td width=50>编辑</td><td width=40>删除</td>
</tr>
<%
set rs=conn.execute("select * from goods_sort order by sortorder")
do while not rs.eof
%>
<form action="admin_sortmanage.asp?action=edit&id=<%=rs("sid")%>" method=post name="sort_edit">
<tr bgcolor=#D7E8F9 height=25><td>
<INPUT TYPE="text" NAME="sortname2" size=30 value=<%=rs("sortname")%>></td>
<td align=center><INPUT TYPE="text" NAME="sortorder2" size=4 value=<%=rs("sortorder")%>></td>
<td align=center><INPUT TYPE="submit" value="编辑"></td>
<td align=center><A HREF="admin_sortmanage.asp?action=del&id=<%=rs("sid")%>"><FONT COLOR="red">删除</FONT></A></td></tr>
</form>
<%
rs.movenext
loop
rs.close
set rs=nothing
set rs1=conn.execute("select max(sortorder) as mpx from goods_sort")
%>
</table>
<p style="margin-top:10"></p>
<form action="?action=add" method=post name="sort_add">
<table cellpadding="0" cellspacing="1" border="0" align=center width="70%" bgcolor="#cacaca">
<tr><td colspan=3 align=center height=30 bgcolor=#ffffff>商品类别添加</td></tr>
<tr align=center bgcolor=#BADCF8 height=25><td>类别名称</td>
<td width=50>排序</td><td width=90>操作</td>
</tr>
<tr bgcolor=#D7E8F9 height=25><td> <INPUT TYPE="text" NAME="sortname" size=30></td>
<td align=center><INPUT TYPE="text" NAME="sortorder" size=4 value="<%=rs1("mpx")+1%>"></td>
<td align=center><INPUT TYPE="submit" value="添加类别"></td></tr>
</table></form>
<%
rs1.close
set rs1=nothing
end sub
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -