savesclass.asp

来自「电子商务网络购物系统」· ASP 代码 · 共 63 行

<!--#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=50 color=red><b>你的权限不够！</b></font></div>"
response.End
end if
end if
%>
<%dim action,url,i,abc,categoryid,category
categoryid=request("categoryid")
category=request.QueryString("category")
url="http://" & Request.ServerVariables("http_host") & finddir(Request.ServerVariables("url"))
action=request.QueryString("action")

select case action
case "add"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from sorts",conn,1,3
rs.AddNew
rs("sorts")=trim(request("sorts2"))
rs("sortsorder")=int(request("sortsorder2"))
rs("categoryid")=int(request("categoryid"))
rs("first")=int(request("first"))
rs.Update
rs.Close
set rs=nothing
response.redirect url&"sclass.asp?id="&categoryid&"&category="&category

case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from sorts where sortsid="&request.QueryString("id"),conn,1,3
rs("sorts")=trim(request("sorts"))
rs("sortsorder")=int(request("sortsorder"))
rs("first")=int(request("first"))
rs.update
rs.close
set rs=nothing
response.redirect url&"sclass.asp?id="&categoryid&"&category="&category

case "del"
categoryid=request.QueryString("categoryid")
conn.execute ("delete from sorts where sortsid="&request.QueryString("id"))
conn.execute ("delete from product where sortsid="&request.QueryString("id"))
response.redirect url&"sclass.asp?id="&categoryid&"&category="&category
end select
%>
<%
Function finddir(filepath)
	finddir=""
	for i=1 to len(filepath)
	if left(right(filepath,i),1)="/" or left(right(filepath,i),1)="\" then
	  abc=i
	  exit for
	end if
	next
	if abc <> 1 then
	finddir=left(filepath,len(filepath)-abc+1)
	end if
end Function
%>