disuser.asp

时代购物系统 4.0功能升级说明 <1>完善了3.0的VIP

end sub

sub repass()
dim shop
shop=request.QueryString("shop")
select case shop
'//输入用户名
case ""
response.Write "<br><table width=96% border=0 align=center cellpadding=01 cellspacing=1>"
response.Write "<form name=shop0 method=post action=profile.asp?action=repass&shop=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=submit name=Submit value=确&nbsp;定 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.form("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=shop1 method=post action=profile.asp?action=repass&shop=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.form("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=submit name=Submit2 value=确&nbsp;定 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.form("username1"))&"' ",conn,1,1
'//判断答案是否正确
if trim(rs("answer"))<>md5(trim(request.form("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=shop2 method=post action=saveprofile.asp?action=repass>"
response.Write "<tr><td width=20% bgcolor=#EFF5FE STYLE='PADDING-LEFT: 20px'>请输入新密码：</td><td width=80% height=28 bgcolor=#EFF5FE STYLE='PADDING-LEFT: 20px'><input name=userpassword1 type=password id=userpassword1><input type=hidden name=username2 value="&trim(request.form("username1"))&"></td></tr>"
response.Write "<tr><td bgcolor=#EFF5FE STYLE='PADDING-LEFT: 20px'>输入确认密码：</td><td height=28 bgcolor=#EFF5FE STYLE='PADDING-LEFT: 20px'><input name=userpassword2 type=password id=userpassword2></td></tr>"
response.Write "<tr><td height=32 colspan=2 bgcolor=#EFF5FE STYLE='PADDING-LEFT: 50px'><input type=submit name=Submit3 value=确&nbsp;定 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("timesshop")("username")="" then
response.Write "<center>请先登录</center>"
response.End
end if

dim joindtm,myorder,successed,successedsum,lastorder
set rs=server.CreateObject("adodb.recordset")
rs.open "select adddate from [user] where username='"&request.cookies("timesshop")("username")&"'",conn,1,1
joindtm=rs("adddate")
rs.close
rs.open "select distinct(goods),actiondate from orders where username='"&request.cookies("timesshop")("username")&"' and state<6 ",conn,1,1
if rs.eof and rs.bof then
response.write ""
else
rs.movelast
lastorder=rs("actiondate")
myorder=rs.recordcount
end if
rs.close
rs.open "select sum(paid) as paid from orders where username='"&request.cookies("timesshop")("username")&"' and state<6 and state>3",conn,1,1 
if rs("paid")>0 then
successedsum=rs("paid")
else
successedsum=0
end if
rs.close
rs.open "select distinct(goods) from orders where username='"&request.cookies("timesshop")("username")&"' and state<6 and state>3",conn,1,1
successed=rs.recordcount
set rs=nothing %>

这是免费版，需要VIP，积分，预存款功能清购买正式版
<%
end sub

sub goods()
if request.cookies("timesshop")("username")="" then
response.Write "<center><center>请先登录</center></center>"
response.End
end if
%>
<table border="0" cellpadding="0" cellspacing="0" align="center" width="100%"> 
<tr><td> 
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1"> 
<tr><td width="55%" align="right"><B>我 的 订 单</B></td>
<td width="49%" align="right">
<select name="state" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" > 
<option value="profile.asp?action=goods&state=0" selected>--请选择查询状态--</option> 
<option value="profile.asp?action=goods&state=0" >全部订单状态</option> 
<option value="profile.asp?action=goods&state=1" >未作任何处理</option> 
<option value="profile.asp?action=goods&state=2" >用户已划出款</option> 
<option value="profile.asp?action=goods&state=3" >服务商已收到款</option> 
<option value="profile.asp?action=goods&state=4" >服务商已发货</option> 
<option value="profile.asp?action=goods&state=5" >用户已经收到货</option> 
</select></td></tr> </table>
          <table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor=<%=bgclr1%>>
            <tr align="center"> 
              <td><font color="#FFFFFF">订单号</font></td>
              <td><font color="#FFFFFF">合计金额</font></td>
              <td><font color="#FFFFFF">积分</font></td>
              <td><font color="#FFFFFF">订货人</font></td>
              <td><font color="#FFFFFF">付款方式</font></td>
              <td><font color="#FFFFFF">收货方式</font></td>
              <td><font color="#FFFFFF">订单日期</font></td>
              <td><font color="#FFFFFF">订单状态</font></td>
            </tr>
            <%set rs=server.CreateObject("adodb.recordset")
  dim state
  state=request.QueryString("state")
  if state=0 or state="" then
  select case state
  case "0"
  rs.open "select distinct(goods),realname,actiondate,deliverymethord,paymethord,state from orders where username='"&request.cookies("timesshop")("username")&"' and state<6 order by actiondate desc",conn,1,1
  case ""
  rs.open "select distinct(goods),realname,actiondate,deliverymethord,paymethord,state from orders where username='"&request.cookies("timesshop")("username")&"' and state<6 order by actiondate desc",conn,1,1
  end select
  else
  rs.open "select distinct(goods),realname,actiondate,deliverymethord,paymethord,state from orders where username='"&request.cookies("timesshop")("username")&"' and state="&state&" order by actiondate",conn,1,1
  end if

  do while not rs.eof
   %>
            <tr bgcolor=#ffffff align="center"> 
			<% dim shop,rs2 
			set shop=server.CreateObject("adodb.recordset")
			shop.open "select sum(paid) as paid,sum(score) as score from orders where goods='"&trim(rs("goods"))&"' ",conn,1,1
				%>
              <td ><a href=# onClick="javascript:window.open('chkorder.asp?dan=<%=trim(rs("goods"))%>&score=<% = trim(shop("score")) %>','','width=710,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"><%=trim(rs("goods"))%></a></td>
              <td> 
			  <%
				set rs2=server.CreateObject("adodb.recordset")
				rs2.open "select * from delivery where deliveryid="&rs("deliverymethord"),conn,1,1
	response.write "<font color=#FF6600>"&shop("paid")+rs2("fee")&"元</font>" 
	rs2.close
	set rs2=nothing %>
              </td>
              <td>
                <% = shop("score") %>
                <%
	shop.close
	set shop=nothing
	%>
              </td>
              <td><%=trim(rs("realname"))%></td>
              <td> 
                <%set rs2=server.CreateObject("adodb.recordset")
        rs2.open "select * from delivery where deliveryid="&rs("paymethord"),conn,1,1
        response.Write trim(rs2("subject"))
        rs2.close
        set rs2=nothing%>
              </td>
              <td align="center">
                <%set rs2=server.CreateObject("adodb.recordset")
        rs2.open "select * from delivery where deliveryid="&rs("deliverymethord"),conn,1,1
        response.Write trim(rs2("subject"))
        rs2.close
        set rs2=nothing
        %>
              </td>
              <td><%=trim(rs("actiondate"))%></td>
              <td>
                <%select case rs("state")
	case "1"
	response.write "未作任何处理"
	case "2"
	response.write "订单处理中"
	case "3"
	response.write "服务商收到款"
	case "4"
	response.write "服务商已发货"
	case "5"
	response.write "用户已收到货"
	end select%>
              </td>
            </tr>
            <%
   rs.movenext
  loop
  rs.close
  set rs=nothing%>
          </table>
  <%end sub
sub loginnum()
dim url
url=Request.ServerVariables("HTTP_REFERER") %>
          <table width=30% border=0 align=center cellpadding=0 cellspacing=0 bgcolor=#FFFFFF>
            <form name=loginfo method=post action=chkuser.asp>
              <tr bgcolor=#ffffff> 
                <td width=38% height=19 align=right nowrap style='padding-left:1px'>用户 
                </td>
                <td width=62% style='padding-left:1px'><input name=username3 type=text id=username2 size=9> 
                </td>
                <td width=62% nowrap style='padding-left:1px' align="center">密 
                  码</td>
                <td width=62% style='padding-left:1px'><input name=password3 type=password id=password3 size=10></td>
              </tr>
              <tr bgcolor=#ffffff> 
                <td height=18 style='padding-left:1px' align=right>验证 </td>
                <td style='padding-left:1px'><input name=passcode type=text id=passcode size=9></td>
                <td style='padding-left:1px'><img src="code.asp"></td>
                <td style='padding-left:1px'> <input type=submit name=Submit4 value="登录" onClick="return checkuu();">
                  &nbsp;<a href="reg.asp">注册</a> <input name=comeurl type=hidden value=<% = url %>></td>
              </tr>
            </form>
          </table>
          <%
end sub
%> </td></tr> </table>