sctogw.asp

21世纪人才www.51zy.net 网站源码

<!--#include file="conn.asp"-->
<%
if request.cookies("godbook")("username")="" then
response.write "<script language=""javascript"" type=""text/javascript"">alert('对不起，您还没有登陆！');window.close();</script>"
response.End
end if

username=request.cookies("godbook")("username")
bookid=request("bookid")

if bookid="" then
response.write "<script language=""javascript"" type=""text/javascript"">alert('对不起，您没有选择商品！');window.close();</script>"
response.End
end if

Set rs_s=Server.CreateObject("Adodb.RecordSet")
rs_s.Open "Select * from shop_books where bookid in ("&bookid&")",Conn,3,3
while not rs_s.eof 

if request.Cookies("godbook")("reglx")=2 then 
	danjia=rs_s("vipjia")
else
	danjia=rs_s("huiyuanjia")
end if
kucun=rs_s("kucun")
bookname=rs_s("bookname")
if kucun<=0 then
response.write "<script language=""javascript"" type=""text/javascript"">alert('你选购的商品“"&bookname&"”暂时缺货不能放到购物车里，请选购其它商品！');window.close();</script>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_action where username='"&username&"' and bookid="&trim(rs_s("bookid"))&" and zhuangtai=7",conn,1,3

if rs.recordcount=1 then
'//修改数量
if kucun<(rs("bookcount")+1) then
response.write "<script language=""javascript"" type=""text/javascript"">alert('你选购的商品“"&bookname&"”暂时缺货不能放到购物车里，请选购其它商品！');window.close();</script>"
response.end
end if
rs("zonger")=(rs("bookcount")+1)*danjia
rs("bookcount")=rs("bookcount")+1
rs.update
rs.close
set rs=nothing
else
'//添加购物
rs.close
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_action",conn,1,3
rs.addnew
rs("bookid")=trim(rs_s("bookid"))
rs("username")=username
rs("zhuangtai")=7
rs("bookcount")=1
rs("zonger")=danjia
rs.update
rs.close
set rs=nothing
end if
rs_s.movenext
wend
rs_s.close
set rs_s=nothing
response.Redirect "gouwu.asp?action=show"%>