subuser.asp

佳可商务购物程序v1.0

'////////////支付方式
rs2.Open "select * from shop_songhuo where fangshi=1 order by songidorder",conn,1,1
do while not rs2.EOF
if rs("zhifufangshi")=rs2("songid") then
response.Write "<option value="&rs2("songid")&" selected>"&trim(rs2("subject"))&"</option>"
else
response.Write "<option value="&rs2("songid")&">"&trim(rs2("subject"))&"</option>"
end if
rs2.MoveNext
loop
rs2.Close
set rs2=nothing
response.Write "</select><font color=red>*</font></td></tr>"
%>
        <tr> 
          <td height=32 colspan=2 > 
            <div align=center>
              <input  type="image" border="0" name="submit" src="images/bc.gif" width="54" height="18" onclick='return checkshouhuoxx();'>
            </div></td></tr>
</form></table> 
<%
rs.close
set rs=nothing
end sub

'////////////////////////暂存款查询
sub zhancunkuan()
if request.cookies("bookshop")("username")="" then
response.Redirect "myuser.asp?action=login"
response.End
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select xbjq from [user] where username='"&request.cookies("bookshop")("username")&"' ",conn,1,1
response.Write "<table width=96% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<form name=userinfo method=post action=saveuserinfo.asp?action=zhancunkuan>"
response.Write "<br><table width=96% border=0 align=center cellpadding=1 cellspacing=1>"
response.Write "<tr><td width=7% height=16 bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><font color=#FF3300>★</font></td><td width=93% bgcolor=#ffffff STYLE='PADDING-LEFT: 10px'>您目前的暂存款金额为：<font color=#FF6600>"&rs("xbjq")&"</font>元（人民币）</td></tr>"
response.Write "<tr><td height=16 bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><font color=#FF3300>★</font></td><td bgcolor=#ffffff STYLE='PADDING-LEFT: 10px'>退款记录</td></tr>"
response.Write "<tr><td height=16 bgcolor=#ffffff STYLE='PADDING-LEFT: 10px'>&nbsp;</td><td bgcolor=#ffffff STYLE='PADDING-LEFT: 10px'><font color=#FF3300></font></td></tr>"
response.Write "</table>"
end sub
'////////////////////////我的购物券
sub gouwujuan()
if request.cookies("bookshop")("username")="" then
response.Redirect "myuser.asp?action=login"
response.End
end if
response.Write "<table width=96% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<tr bgcolor=#FFFFFF><td colspan=2 STYLE='PADDING-LEFT: 20px'><font color=#FF3300>★</font> &nbsp;您现在共有 <font color=#FF3300>0</font> 张购物券。总计金额 <font color=#FF3300>0</font> 元。</td></tr>"
response.Write "<tr><td width=24% bgcolor=#ffffff><div align=center>购物券编号</div></td><td width=76% ><div align=center>购物券金额</div></td></tr>"
response.Write "<tr><td bgcolor=#ffffff>&nbsp;</td><td >&nbsp;</td></tr>"
response.Write "<tr><td colspan=2 bgcolor=#ffffff><div align=center><font color=#FF3300>对不起，目前还不支持此功能！请及时关注版本信息</font></div></td></tr>"
response.Write "</table>"
end sub
'////////////////////////用户个人资料
sub userziliao()
if request.cookies("bookshop")("username")="" then
response.Redirect "myuser.asp?action=login"
response.End
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select useremail,quesion,userzhenshiname from [user] where username='"&request.cookies("bookshop")("username")&"' ",conn,1,1
response.Write "<table width=96% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<form name=userinfo method=post action=saveuserinfo.asp?action=userziliao>"
response.Write "<tr><td bgcolor=#ffffff><div align=center><font color=#FF0000>尊敬的用户，我们向您承诺：以下信息将被严格保密，绝对不提供给第三方或用作它用。</font></div></td></tr>"
response.Write "<tr><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 70px'>用 户 名： <font color=#FF6600>"&request.cookies("bookshop")("username")&"</font></td></tr>"
response.Write "<tr><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 70px'>E-Mail&nbsp;&nbsp; ： <input name=useremail type=text id=useremail2 value="&trim(rs("useremail"))&"></td></tr>"
response.Write "<tr><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 70px'>真实姓名： <input name=userzhenshiname type=text id=userzhenshiname value="&trim(rs("userzhenshiname"))&"></td></tr>"
response.Write "<tr><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 70px'>密码提问： <input name=quesion type=text id=quesion value="&trim(rs("quesion"))&">(用于密码遗忘时使用)</td></tr>"
response.Write "<tr><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 70px'>密码答案： <input name=answer type=text id=answer>(密码遗忘时将验证此答案)</td></tr>"
response.Write "<tr><td height=32 bgcolor=#ffffff STYLE='PADDING-LEFT: 70px'><input  type=image border=0 name=submit2 src=images/bc.gif width=54 height=18 onclick='return checkuserinfo();'></td></tr>"
response.Write "</form></table>"
rs.close
set rs=nothing
end sub
'////////////////////////用户修改密码
sub savepass()
if request.cookies("bookshop")("username")="" then
response.Redirect "myuser.asp?action=login"
response.End
end if
response.write "<br><table width=96% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<form name=userpass method=post action=saveuserinfo.asp?action=savepass>"
response.Write "<tr><td width=16% bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>用户名：</td><td width=84% bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><font color=#FF6600>"&request.cookies("bookshop")("username")&"</font></td></tr>"
response.Write "<tr><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>原密码：</td><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><input name=userpassword type=password id=userpassword></td></tr>" 
response.Write "<tr><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>新密码：</td><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><input name=userpassword1 type=password id=userpassword1></td></tr>"
response.Write "<tr><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>确认密码：</td><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><input name=userpassword2 type=password id=userpassword2></td></tr>"
response.Write "<tr><td height=32 colspan=2 bgcolor=#ffffff STYLE='PADDING-LEFT: 50px'><input  type=image border=0 name=submit src=images/xx.gif width=54 height=18 onclick='return checkrepass();'></td></tr>"
response.Write "</form></table>"
end sub
'////////////////////////取回密码
sub repass()
dim ckxp
ckxp=request.QueryString("ckxp")
select case ckxp
'//输入用户名
case ""
response.Write "<br><table width=96% border=0 align=center cellpadding=01 cellspacing=1>"
response.Write "<form name=ckxp0 method=post action=myuser.asp?action=repass&ckxp=1>"
response.Write "<tr><td height=28 bgcolor=#ffffff><div align=center>请输入您的用户名： <input name=username type=text id=username size=16></div></td></tr>"
response.Write "<tr><td height=32 bgcolor=#ffffff><div align=center><input  type=image border=0 name=submit src=images/xx.gif width=54 height=18 onclick='return check0();'></div></td></tr>"
response.Write "</form></table>"
'//输入问题答案
case "1"
set rs=server.CreateObject("adodb.recordset")
rs.open "select quesion,answer from [user] where username='"&trim(request("username"))&"' ",conn,1,1
if rs.eof and rs.bof then
response.write "<center><br>查无此用户，请返回！</center>"
else
response.Write "<br><table width=96% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<form name=ckxp1 method=post action=myuser.asp?action=repass&ckxp=2>"
response.Write "<tr><td width=21% bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>您的密码提问：</td><td width=79% height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><font color=red>"&trim(rs("quesion"))&"</font><input type=hidden name=username1 value="&trim(request("username"))&" ID=Hidden1></td></tr>"
response.Write "<tr><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>您的密码答案：</td><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><input name=answer type=text id=answer></td></tr>"
response.Write "<tr bgcolor=#ffffff><td height=32 colspan=2 STYLE='PADDING-LEFT: 50px'><input  type=image border=0 name=submit src=images/xx.gif width=54 height=18 onclick='return check1();'></td></tr>"
response.Write "</form></table>"
end if
rs.close
set rs=nothing
'//输入新密码
case "2"
set rs=server.CreateObject("adodb.recordset")
rs.open "select answer from [user] where username='"&trim(request("username1"))&"' ",conn,1,1
'//判断答案是否正确
if trim(rs("answer"))<>md5(trim(request("answer"))) then
response.write "<script language=javascript>alert('对不起，您输入的问题答案不正确');history.go(-1);</script>"
response.end
else
response.Write "<br><table width=96% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<form name=ckxp2 method=post action=saveuserinfo.asp?action=repass>"
response.Write "<tr><td width=20% bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>请输入新密码：</td><td width=80% height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><input name=userpassword1 type=password id=userpassword1><input type=hidden name=username2 value="&trim(request("username1"))&"></td></tr>"
response.Write "<tr><td bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'>输入确认密码：</td><td height=28 bgcolor=#ffffff STYLE='PADDING-LEFT: 20px'><input name=userpassword2 type=password id=userpassword2></td></tr>"
response.Write "<tr><td height=32 colspan=2 bgcolor=#ffffff STYLE='PADDING-LEFT: 50px'><input  type=image border=0 name=submit3 src=images/xx.gif width=54 height=18 onclick='return check2();'></td></tr>"
response.Write "</form></table>"
end if
rs.close
set rs=nothing
end select
end sub
'////////////////////////信息统计
sub statinfo()
if request.cookies("bookshop")("username")="" then
response.Redirect "myuser.asp?action=login"
response.End
end if
'//添加到数据库
dim zhucedate,xiadan,chengjiao,chengjiaozonger,lastxiadan
set rs=server.CreateObject("adodb.recordset")
rs.open "select adddate from [user] where username='"&request.cookies("bookshop")("username")&"'",conn,1,1
zhucedate=rs("adddate")
rs.close
rs.open "select distinct(dingdan),actiondate from shop_action where username='"&request.cookies("bookshop")("username")&"' and zhuangtai<6 ",conn,1,1
if rs.eof and rs.bof then
response.write ""
else
rs.movelast
lastxiadan=rs("actiondate")
xiadan=rs.recordcount
end if
rs.close
rs.open "select sum(zonger) as zonger from shop_action where username='"&request.cookies("bookshop")("username")&"' and zhuangtai<6 and zhuangtai>3",conn,1,1 
if rs("zonger")>0 then
chengjiaozonger=formatnumber(rs("zonger"),2)
else
chengjiaozonger=0
end if
rs.close
rs.open "select distinct(dingdan) from shop_action where username='"&request.cookies("bookshop")("username")&"' and zhuangtai<6 and zhuangtai>3",conn,1,1
chengjiao=rs.recordcount
set rs=nothing
'//HTML显视
response.Write "<table width=96% border=0 align=center cellpadding=2 cellspacing=1 bgcolor=#FFFFFF>"
response.Write "<tr><td height=22 colspan=2>以下是您在本站的一些历史记录的统计信息</td></tr>"
response.Write "<tr><td width=30% height=22 bgcolor=#ffffff><div align=right>会员注册日期：</div></td><td width=78% bgcolor=#ffffff>&nbsp;"&zhucedate&"</td></tr>"
response.Write "<tr><td height=22 bgcolor=#ffffff><div align=right>下单次数：</div></td><td bgcolor=#ffffff>&nbsp;"&xiadan&"次</td></tr>"
response.Write "<tr><td height=22 bgcolor=#ffffff><div align=right>成交次数：</div></td><td bgcolor=#ffffff>&nbsp;"&chengjiao&"次</td></tr>"
response.Write "<tr><td height=22 bgcolor=#ffffff><div align=right>成交订单总金额：</div></td><td bgcolor=#ffffff>&nbsp;"&chengjiaozonger&"元</td></tr>"
response.Write "<tr><td height=22 bgcolor=#ffffff><div align=right>上一次下单时间：</div></td><td bgcolor=#ffffff>&nbsp;"&lastxiadan&"</td></tr>"