📄 shoucang.asp
字号:
<!--
┌─9911.com.cn────────────┐
│ 动感购物 WWW.9911.com.cn 版权所有 │
│ 动感购物2005Vb 联系：web@snsn.net │
└───────────9911.com.cn──┘
-->
<!--#include file="conn.asp"-->
<!--#include file="webconfig.asp"-->
<!--#include file="fuction.asp"-->
<!--#include file="webtop.asp"-->
<%
if session("username")="" then
response.write "<script language=javascript>alert('对不起，您还没有登陆！');window.history.go(-1);</script>"
response.End
end if
dim shopid,username,action
action=nosql(request.QueryString("action"))
username=nosql(trim(session("username")))
shopid=nosql(request.QueryString("id"))
'//删除收藏
select case action
case "del"
if Not isChkInteger(request.QueryString("actionid")) then
%>
<script language=javascript>
alert("参数错误！");
window.close();
</script>
<%
response.end
end if
conn.execute "delete from shop_action where actionid="&nosql(request.QueryString("actionid"))
if request.QueryString("ll")=1 then
response.redirect "user.asp?action=shoucang"
else
response.redirect "shoucang.asp?action=show"
end if
response.End
case "add"
'//收藏，判断是否存在
if not isChkInteger(shopid) then
%>
<script language=javascript>
alert("参数错误！");
window.close();
</script>
<%
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select shopid,username from shop_action where username='"&checkFFSQLStr(username)&"' and shopid="&shopid&" and zhuangtai=6",conn,1,1
if not rs.eof and not rs.bof then
response.write "<script language=javascript>alert('对不起，此商品已存在于您的收藏架中，不可以重复添加！');window.location.href='shoucang.asp?action=show';</script>"
response.end
rs.close
set rs=nothing
end if
rs.close
set rs=nothing
'//判断收藏数
set rs=server.CreateObject("adodb.recordset")
rs.open "select shopid,username from shop_action where username='"&checkFFSQLStr(username)&"' and zhuangtai=6",conn,1,1
if rs.recordcount>=10 then
response.write "<script language=javascript>alert('对不起，您最多只能收藏10件商品！');window.location.href='shoucang.asp?action=show';</script>"
response.end
else
rs.close
set rs=nothing
'//添加收藏
set rs=server.CreateObject("adodb.recordset")
rs.open "select shopid,username,zhuangtai,zonger from shop_action",conn,1,3
rs.addnew
rs("shopid")=shopid
rs("username")=username
rs("zhuangtai")=6
rs("zonger")=0
rs.update
rs.close
response.Redirect "shoucang.asp?action=show"
set rs=nothing
end if
case "show"
'//////////////////%><html>
<head>
<title><%=webname%>--我的收藏架</title>
<link rel="SHORTCUT ICON" href="/shortcut.ico">
<meta name="generator" content="snsn-shop">
<meta name=keywords content="<%=webgjz%>">
<meta name="description" content="<%=webmx%>">
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<meta http-equiv="MSThemeCompatible" content="Yes">
<link href="/css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onMouseOver="window.status='【<%=webname%>】<%=weburl%> 如果您喜欢本站,别忘了把本站介绍给您的好友哦！：）';return true">
<table width="940" align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="6" colspan="3"></td>
</tr>
<tr>
<td width="17"><img src="/img/index_1.gif" width="15" height="16"></td>
<td valign="bottom">您现在的位置是：<a href="<%=weburl%>"><%=webname%></a> -> <span class="table-shangxia">我的收藏架</span></td>
<td valign="bottom">
</td>
</tr>
<tr>
<td height="6" colspan="3"></td>
</tr>
</table>
<table width="945" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="8"></td>
</tr>
</table>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select shop_action.actionid,shop_action.shopid,shop_snsn.shopname,shop_snsn.shichangjia,shop_snsn.huiyuanjia,shop_snsn.vipjia,shop_snsn.dazhe from shop_snsn inner join shop_action on shop_snsn.shopid=shop_action.shopid where shop_action.username='"&checkFFSQLStr(session("username"))&"' and shop_action.zhuangtai=6",conn,1,1
%>
<table width=98% border=0 align=center cellpadding=0 cellspacing=1 bgcolor="#CCCCCC">
<form name='form1' method='post' action="sctogw.asp">
<tr bgcolor="f1f1f1">
<td width=8% height="25" >
<div align=center><strong><font color=#666666>选择</font></strong></div></td>
<td width=42% height="25" >
<div align=center><strong><font color=#666666>商品名称</font></strong></div></td>
<td width=14% height="25" >
<div align=center><strong><font color=#666666>市场价</font></strong></div></td>
<td width=14% height="25" >
<div align=center><strong><font color=#666666>会员价</font></strong></div></td>
<td width=14% height="25" >
<div align=center><strong><font color=#666666>VIP 价</font></strong></div></td>
<td width=8% height="25" >
<div align=center><strong><font color=#666666>删除</font></strong></div></td>
</tr>
<%do while not rs.eof%>
<tr bgcolor="#FFFFFF">
<td height="25" >
<div align=center>
<input name=shopid type=checkbox checked value=<%=rs("shopid")%> >
</div></td>
<td height="25" STYLE='PADDING-LEFT: 5px'>
<div align=left><a href=list.asp?id=<%=rs("shopid")%> target=_blank><%=rs("shopname")%></a> </div></td>
<td height="25" >
<div align=center><%=formatnumber(rs("shichangjia"),2)%>元</div></td>
<td height="25" >
<div align=center><font color=#dd6600><%=formatnumber(rs("huiyuanjia"),2)%>元</font></div></td>
<td height="25" >
<div align=center><font color=#FF3300><%=formatnumber(rs("vipjia"),2)%>元</font></div></td>
<td height="25" >
<div align=center> <a href=shoucang.asp?action=del&actionid=<%=rs("actionid")%>> <img src=img/trash.gif width=18 height=18 border=0></a></div></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
<tr>
<td height=36 colspan=6 bgcolor=#FFFFFF class="table-xiayou">
<div align=center>
<input name="Submit2" type="submit" class="go-wenbenkuang" value="放入购物车" onFocus="this.blur()">
<input name="Submit32" type="button" class="go-wenbenkuang" value="返回继续购物" onClick="javascript:window.history.go(-1)">
</div></td>
</tr>
</form>
</table>
<p>
<script language="Javascript">
function closeinfo(){window.close();}
setTimeout("closeinfo()", 600000);
</script>
<%
end select%>
</p>
<p> </p></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="copyright.asp"-->
</body>
</html>
<SCRIPT LANGUAGE="JavaScript">
<!--
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function checkk()
{
if(checkspace(document.form2.searchkey.value)&&((document.form2.action.value=="3")||(document.form2.action.value=="1"))) {
document.form2.searchkey.focus();
alert("请输入查讯关键字！");
return false;
}
document.form2.submit();
}
//-->
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -