userinfo.asp

网上商场 帐户管理方面 1.实现了购物车和收藏夹的功能。 2.实现了历史订单查询以及即时订单跟踪。 3.实现了个人资料修改,查询以及送货人信息修改和查询。

<% 
response.write "<table width=180 border=0 align=center cellpadding=0 cellspacing=0 >"
if request.cookies("bookshop")("username")="" then
	
else
set rs=server.CreateObject("adodb.recordset")
rs.open "select shop_books.huiyuanjia,shop_action.bookcount from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid where shop_action.zhuangtai=1 and shop_action.username='"&trim(request.Cookies("bookshop")("username"))&"' ",conn,1,1
dim ckxp
set ckxp=server.CreateObject("adodb.recordset")
ckxp.Open "select distinct(dingdan) from shop_action where username='"&request.Cookies("bookshop")("username")&"' and zhuangtai=1 ",conn,1,1
    %>
	<tr><td><table width='100%'  border='0' align='center' cellpadding='0' cellspacing='0' background='images/menu_bar01.jpg'>
                   <tr> 
					    <TD width=11><IMG height=25 
                        src="images/cruises_top1b.gif" 
                        width=11></TD>

						 <TD 
                      background="images/cruises_topbg.gif">
                        <TABLE cellSpacing=0 cellPadding=0  border=0>
                          <TBODY>
                          <TR>
                            <TD width=19><IMG height=15 
                              src="images/icon03.gif" 
                              width=13></TD>
                            <TD class=white14><FONT 
                              color=#ffffff><STRONG>我的购物信息</STRONG></FONT></TD></TR></TBODY></TABLE></TD>
                      <TD align=right width=18><IMG height=25 
                        src="images/cruises_top2b.gif" 
                        width=18></TD></TR></TBODY></TABLE></TD>
					   
					   
				</tr>
          <tr><td ><div align=center>
		  <%
if ckxp.recordcount=0 then

response.write "<tr><td height=41 ><div align=center><IMG   src='images/2.gif'  border=0>欢迎<font color=red>"&Request.Cookies("bookshop")("username")&"</font>光临本站<br>您目前还没有未处理订单<br>共计:0.00元"
else
dim shopjiage
do while not rs.eof
shopjiage=round(shopjiage+rs("huiyuanjia")*rs("bookcount"),2)
rs.movenext
loop

                 
response.write "<tr><td height=41 ><div align=center><IMG   src='images/2.gif'  border=0>欢迎<font color=red>"&request.cookies("bookshop")("username")&"</font>光临本站<br>您目前有"&ckxp.recordcount&"笔未处理订单<br>共计："&shopjiage&"元(除邮费)"
end if
ckxp.Close
set ckxp=nothing
rs.close
set rs=nothing
end if
if request.cookies("bookshop")("username")="" then%>

                   <tr><td><table width='100%'  border='0' align='center' cellpadding='0' cellspacing='0' >
                       <tr> 
					    <TD width=11><IMG height=25 
                        src="images/cruises_top1b.gif" 
                        width=11></TD>

						 <TD 
                      background="images/cruises_topbg.gif">
                        <TABLE cellSpacing=0 cellPadding=0  border=0>
                          <TBODY>
                          <TR>
                            <TD width=19><IMG height=15 
                              src="images/icon03.gif" 
                              width=13></TD>
                            <TD class=white14><FONT 
                              color=#ffffff><STRONG>请先登陆或注册</STRONG></FONT></TD></TR></TBODY></TABLE></TD>
                      <TD align=right width=18><IMG height=25 
                        src="images/cruises_top2b.gif" 
                        width=18></TD></TR></TBODY></TABLE></TD>
					   
					   
				</tr>



           <tr><td height=41 ><div align=center>
                              <table width="99%" border="0" cellspacing="1" cellpadding="0" >
                                <form name=loginfo method=post action=chkuser.asp>
                                  
    <tr> 
      <td width="100%" height="110">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="5">
                                        <tr> 
                                          <td width="32%"> 
                                            <div align="center">客户：</div>
                                          </td>
                                          <td width="68%"> 
                                            <div align="center"> 
                                              <input name=username type=text  class=input id=username style="FONT-SIZE: 12px; WIDTH: 110px" size="10" maxlength="18">
                                            </div>
                                          </td>
                                        </tr>
                                        <tr> 
                                          <td> 
                                            <div align="center">密码：</div>
                                          </td>
                                          <td> 
                                            <div align="center"> 
                                              <input  name=userpassword type=password id=password style="FONT-SIZE: 12px; WIDTH: 110px"  size="10" class=input maxlength="18">
                                            </div>
                                          </td>
                                        </tr>
                                      </table>
                                      <div align="center"></div>
                                      
        <table width="90%" border="0" cellspacing="5" cellpadding="0" align="center">
          <tr> 
            <td width="80"><a href="reg.asp"><img src="images/reg.gif" width="81" height="25" border="0"></a></td>
            <td> <div align="center"> 
                <input align=absMiddle alt=登陆 cache name=submit2 src="images/login.gif" type=image tppabs=""  onclick="return check123();"width="56" height="25">
              </div></td>
          </tr>
        </table>
                                    </td>
</tr></form></table>
<%else
response.write "<br><a href=myuser.asp?action=dingdan>我的账户</a>&nbsp;&nbsp;<a href=logout.asp>注销登陆</a><br><IMG   src='images/1.gif'  height=20 border=0>客户服务热线<br><font color=red>0792-8360263</font><br>"
end if
response.write "</div></td></tr></table>"
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
function check123()
{
if(checkspace(document.loginfo.username.value))  {
	document.loginfo.username.focus();
	alert("对不起，您还没输入用户名");
	return false;
  }
else  if(checkspace(document.loginfo.userpassword.value))  {
	document.loginfo.userpassword.focus();
	alert("对不起，您还没输入密码");
	return false;
  }
  

   document.loginfo.submit();
}

//-->
</script>