savebclass.asp

时代购物系统 4.0功能升级说明 <1>完善了3.0的VIP

<!--#include file="conn.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('请先登录！');history.go(-1);</script>"
response.End
else
if session("rank")>1 then
response.Write "<div align=center><font size=5 color=red><b>你的权限不够！</b></font></div>"
response.End
end if
end if
%>
<%dim action,categoryid
categoryid=request.QueryString("id")
action=request.querystring("action")
select case action

case "add" 
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from category",conn,1,3
rs.AddNew
rs("category")=trim(request("category2"))
rs("categoryorder")=int(request("categoryorder2"))
rs("first")=int(request("first2"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "bclass.asp"

case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from category where categoryid="&categoryid,conn,1,3
rs("category")=trim(request("category"))
rs("categoryorder")=int(request("categoryorder"))
rs("first")=int(request("first"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "bclass.asp"

case "del"
conn.execute ("delete from category where categoryid="&categoryid)
conn.execute ("delete from sorts where categoryid="&categoryid)
conn.execute ("delete from product where categoryid="&categoryid)
response.Redirect "bclass.asp"
end select
%>