sshopxpnclass.asp

IMPORTANT YOU SHOUD LOAD IT DOWN FOR USING

<!--#include file="xp.asp"-->
<%if session("shopxpadmin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='shopxplogin.asp';</script>"
response.End
else
if session("xlgl")=0 then
response.Write "<p align=center><font color=red>您没有此项目管理权限！</font></p>"
response.End
end if
end if
%>
<%dim action,url,i,abc,shopxpbe_id,shopxpbe_name
shopxpbe_id=request("shopxpbe_id")
shopxpbe_name=request.QueryString("shopxpbe_name")
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 shopxp_stype",conn,1,3
rs.AddNew
rs("shopxpse_name")=trim(request("nclass2"))
rs("shopxpse_idorder")=int(request("nclassidorder2"))
rs("shopxpbe_id")=int(request("shopxpbe_id"))
'rs("changyong")=int(request("changyong"))
rs.Update
rs.Close
set rs=nothing
response.redirect url&"shopxpse_name.asp?id="&shopxpbe_id&"&shopxpbe_name="&shopxpbe_name
'//修改数据
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shopxp_stype where shopxpse_id="&request.QueryString("id"),conn,1,3
rs("shopxpse_name")=trim(request("shopxpse_name"))
rs("shopxpse_idorder")=int(request("shopxpse_idorder"))
'rs("changyong")=int(request("changyong"))
rs.update
rs.close
set rs=nothing
response.redirect url&"shopxpse_name.asp?id="&shopxpbe_id&"&shopxpbe_name="&shopxpbe_name
'//删除数据
case "del"
shopxpbe_id=request.QueryString("shopxpbe_id")
conn.execute ("delete from shopxp_stype where shopxpse_id="&request.QueryString("id"))
conn.execute ("delete from shopxp_product where shopxpse_id="&request.QueryString("id"))
response.redirect url&"shopxpse_name.asp?id="&shopxpbe_id&"&shopxpbe_name="&shopxpbe_name
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
%>