sctogw.asp

IMPORTANT YOU SHOUD LOAD IT DOWN FOR USING

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

username=request.Cookies("shopxp")("username")
shopxpptid=request("shopxpptid")

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

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

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

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