savedingdan.asp

创建和运行动态、交互的Web服务器应用程序

<!--#include file="conn.asp"-->
<%
if session("admin")="" then
     response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.reload('login.asp')</script>"
     response.End
else
   if session("flag")=2 then
      response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
      response.End
   end if
end if

dim action,dingdan,username,bookid,bookcount,bkzhuangtai,rs_bk

    action  = request.QueryString("action")
    dingdan = request.QueryString("dan")
    username= request.QueryString("username")

select case action
       case "save"
if request("zhuangtai")<>"" then
   set rs=server.CreateObject("adodb.recordset")
       rs.Open "select bookid,bookcount,zhuangtai from shop_action where dingdan='"&dingdan&"'",conn,1,3

       do while not rs.EOF

          bookid     = rs("bookid")
          bookcount  = rs("bookcount")
          bkzhuangtai= rs("zhuangtai")

          rs("zhuangtai")=request("zhuangtai")
          rs.Update

          if bkzhuangtai=1 then
             set rs_bk=server.CreateObject("adodb.recordset")
                 rs_bk.open "select * from shop_books where bookid="&bookid,conn,1,3
                 rs_bk("sumxs")=rs_bk("sumxs")+bookcount
                 rs_bk("sumkc")=rs_bk("sumcg")-rs_bk("sumxs")-rs_bk("sumts")
                 rs_bk.update
          end if

        rs.MoveNext
        loop
        rs.Close
        set rs=nothing
        set rs_bk=nothing
end if
response.Write "<script language=javascript>alert('订单状态修改成功!');window.location.reload('viewdingdan.asp?dan="&dingdan&"&username="&username&"')</script>"
response.Write dingdan
case "del"
conn.execute "delete from shop_action where dingdan='"&dingdan&"' "
response.Write "<script language=javascript>alert('订单删除成功！');window.location.reload('javascript:window.close()')</script>"

end select

%>