gusucode.com > 爱美尔女性商城源码 1.0源码程序 > admintouch/saveanclass.asp
<!--#include file="conn.asp"--> <%if session("bjxadmin")="" then response.Write "<script language='javascript'>alert('网络超时或您还没有登陆!');window.location.href='login.asp';</script>" response.End else if session("flag")>1 then response.Write "<p align=center><font color=red>您没有此项目管理权限!</font></p>" response.End end if end if %> <%dim action,anclassid anclassid=request.QueryString("id") action=request.querystring("action") typeid=request("typeid") select case action '//添加新数据 case "add" set rs=server.CreateObject("adodb.recordset") rs.open "select * FROM BJX_class1",conn,1,3 rs.AddNew rs("anclass")=trim(request("anclass2")) rs("anclassidorder")=int(request("anclassidorder2")) rs("fudongjia")=int(request("fudongjia2")) rs("typeid")=int(request("typeid")) rs.Update rs.Close set rs=nothing response.Redirect "anclass.asp?typeid="&typeid&"" '//修改数据 case "edit" set rs=server.CreateObject("adodb.recordset") rs.open "select * FROM BJX_class1 where anclassid="&anclassid,conn,1,3 rs("anclass")=trim(request("anclass")) rs("anclassidorder")=int(request("anclassidorder")) rs("fudongjia")=int(request("fudongjia")) rs.Update rs.Close set rs=nothing response.Redirect "anclass.asp?typeid="&typeid&"" '//删除数据 case "del" conn.execute ("delete FROM BJX_class1 where anclassid="&anclassid) conn.execute ("delete FROM BJX_class2 where anclassid="&anclassid) conn.execute ("delete from BJX_goods where anclassid="&anclassid) response.Redirect "anclass.asp?typeid="&typeid&"" end select %>