<!--┌─9911.com.cn────────────┐│  動感購物 WWW.9911.com.cn 版權所有  ││  動感購物2005Vb  聯系：web@snsn.net │└───────────9911.com.cn──┘-->
<!--#include file="conn.asp"-->
<!--#include file="fuction.asp"-->
<%
if session("username")="" then
response.write "<script language=javascript>alert('對不起，您還沒有登陸！');window.close();</script>"
response.End
end if
dim shopid,username,action
action=nosql(request.QueryString("action"))
username=nosql(trim(session("username")))
shopid=nosql(request.QueryString("id"))
if action="del" then
'//刪除收藏
conn.execute "delete from shop_action_jp where actionid="&nosql(request.QueryString("actionid"))
if request("ll")=22 then
response.redirect "gouwu.asp?action=show"
else
response.redirect "user.asp?action=jifen"
end if
response.End
end if

if action="add" then
'判斷用戶是否已換這個獎品
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select count(*) as rec_count from shop_action_jp where shopid="&shopid&" and zhuangtai=7 and username='"&session("username")&"'",conn,1,1

if rs_s("rec_count")>0 then
	rs_s.close
	set rs_s=nothing
	response.write "<script language=javascript>alert('這個獎品您已經選了，請再選其他獎品！');history.go(-1);</script>"
	response.end
end if
rs_s.close
set rs_s=nothing
'判斷用戶的現有積分
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select jifen from [shop_user] where username='"&session("username")&"'",conn,1,1
jifen_xy=rs_s("jifen")
rs_s.close
set rs_s=nothing
'判斷用戶的已準備換的積分
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select jifen from shop_action_jp where username='"&session("username")&"' and zhuangtai=7",conn,1,1
jifen_yy=0
while not rs_s.eof
jifen_yy=jifen_yy+rs_s("jifen")
rs_s.movenext
wend
rs_s.close
set rs_s=nothing
'判斷獎品需要的積分
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select jifen from shop_jiangpin where shopid="&shopid,conn,1,1
jifen_y=rs_s("jifen")
rs_s.close
set rs_s=nothing
if jifen_xy<(jifen_yy+jifen_y) then
	response.write "<script language=javascript>alert('您現有的積分不夠兌換本獎品，請更換其他獎品！');history.go(-1);</script>"
	response.end
end if
'//商品，判斷是否存在
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_action_jp",conn,1,3
rs.addnew
rs("shopid")=shopid
rs("username")=username
rs("zhuangtai")=7
rs("jifen")=jifen_y
rs("shopcount")=1
rs.update
rs.close
set rs=nothing
response.Redirect "user.asp?action=jifen"
end if
%>