sshopxpanclass.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("dlgl")=0 then
response.Write "<p align=center><font color=red>您没有此项目管理权限！</font></p>"
response.End
end if
end if
%>
<%dim action,shopxpbe_id
shopxpbe_id=request.QueryString("id")
action=request.querystring("action")
select case action
'//添加新数据
case "add" 
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shopxp_btype",conn,1,3
rs.AddNew
rs("shopxpbe_name")=trim(request("anclass2"))
rs("shopxpbe_idorder")=int(request("anclassidorder2"))
rs("fudongjia")=int(request("fudongjia2"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "shopxpbe_name.asp"
'//修改数据
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shopxp_btype where shopxpbe_id="&shopxpbe_id,conn,1,3
rs("shopxpbe_name")=trim(request("shopxpbe_name"))
rs("shopxpbe_idorder")=int(request("shopxpbe_idorder"))
rs("fudongjia")=int(request("fudongjia"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "shopxpbe_name.asp"
'//删除数据
case "del"
conn.execute ("delete from shopxp_btype where shopxpbe_id="&shopxpbe_id)
conn.execute ("delete from shopxp_stype where shopxpbe_id="&shopxpbe_id)
conn.execute ("delete from shopxp_product where shopxpbe_id="&shopxpbe_id)
response.Redirect "shopxpbe_name.asp"
end select
%>