save.asp

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

<!--#include file="conn.asp"-->
<%dim goods,action
action=request.QueryString("action")
goods=request.QueryString("dan")
select case action
case "save"
if request("state")<>"" then
set rs=server.CreateObject("adodb.recordset")
rs.Open "select state from orders where goods='"&goods&"'",conn,1,3
do while not rs.EOF
rs("state")=request("state")
rs.Update
rs.MoveNext
loop
rs.Close
set rs=nothing
end if
response.Write "<script language=javascript>alert('订单状态修改成功！');history.go(-1);</script>"
case "del"
set rs=server.CreateObject("adodb.recordset")
rs.open "select username,goods from orders where goods='"&goods&"' " ,conn,1,1

if request.Cookies("timesshop")("username")<>trim(rs("username")) then
response.Write "您无权删除此订单!"
response.End
end if
conn.execute "delete from orders where goods='"&goods&"' "
response.Write "<script language=javascript>alert('订单删除成功！');history.go(-1);</script>"
end select

%>