savegouwuliucheng.asp

来自「网络商店源码 实现商品浏览 购物车 后台管理等」· ASP 代码 · 共 56 行

<!--#include file="conn.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登录！');window.location.href='login.asp';</script>"
response.End
else
if session("flag")>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
end if
%>
<%dim action,id
id=request.QueryString("id")
action=request.querystring("action")
select case action
'//添加新数据
case "add" 
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_gouwuliucheng",conn,1,3
rs.AddNew
rs("jiage1")=int(request("jiage1"))
rs("zengpin1")=trim(request("zengpin1"))
rs("jiage2")=int(request("jiage2"))
rs("zengpin2")=trim(request("zengpin2"))
rs("jiage3")=int(request("jiage3"))
rs("zengpin3")=trim(request("zengpin3"))
rs("jiage4")=int(request("jiage4"))
rs("zengpin4")=trim(request("zengpin4"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "gouwuliucheng.asp"
'//修改数据
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_gouwuliucheng where gouwuliuchengid="&id,conn,1,3
rs("jiage1")=int(request("jiage1"))
rs("zengpin1")=trim(request("zengpin1"))
rs("jiage2")=int(request("jiage2"))
rs("zengpin2")=trim(request("zengpin2"))
rs("jiage3")=int(request("jiage3"))
rs("zengpin3")=trim(request("zengpin3"))
rs("jiage4")=int(request("jiage4"))
rs("zengpin4")=trim(request("zengpin4"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "gouwuliucheng.asp"
'//删除数据
'case "del"
'conn.execute ("delete from shop_gouwuliucheng where gouwuliuchengid="&id)
'conn.execute ("delete from shop_nclass where gouwuliuchengid="&id)
'conn.execute ("delete from shop_snsn where gouwuliuchengid="&id)
'response.Redirect "gouwuliucheng.asp"
end select
%>