user_inc.asp

网页源码,是最好的网店代码。可以支持批量上传产品等功能。

<%
sub dindan()
if request.cookies("Cnhww")("username")="" then
response.Redirect "user.asp"
response.End
end if
%>
<style type="text/css">
<!--
.style1 {	color: #99CC00;
	font-weight: bold;
}
-->
</style>

<table width="90%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr> 
<td width="100%" align="right"><img src="images/mingle/state.gif" width="20" height="18" />请选择查找不同状态下的订单
  <select name="zhuangtai" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" >
<option value="user.asp?action=dindan&zhuangtai=0" selected>==请选择查讯状态==</option>
<option value="user.asp?action=dindan&zhuangtai=0" >全部订单状态</option>
<option value="user.asp?action=dindan&zhuangtai=1" >未作任何处理</option>
<option value="user.asp?action=dindan&zhuangtai=2" >用户已经划出款</option>
<option value="user.asp?action=dindan&zhuangtai=3" >服务商已经收到款</option>
<option value="user.asp?action=dindan&zhuangtai=4" >服务商已经发货</option>
<option value="user.asp?action=dindan&zhuangtai=5" >用户已经收到货</option>
</select>
</td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F1F1F1">
	<tr bgcolor="#F1F1F1" align="center"> 
	<td height="12">订单号</td>
	<td height="12">货款</td>
	<td height="12">费用</td>
	<td height="12">订单状态</td>
	</tr>
  <%set rs=server.CreateObject("adodb.recordset")
   dim zhuangtai
  zhuangtai=request.QueryString("zhuangtai")
  if zhuangtai=0 or zhuangtai="" then
  select case zhuangtai
  case "0"
  rs.open "select distinct(dingdan),userzhenshiname,actiondate,shouhuoname,songhuofangshi,zhifufangshi,zhuangtai from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai<6 order by actiondate desc",conn,1,1
  case ""
  rs.open "select distinct(dingdan),userzhenshiname,actiondate,shouhuoname,songhuofangshi,zhifufangshi,zhuangtai from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai<5 order by actiondate desc",conn,1,1
  end select
  else
  rs.open "select distinct(dingdan),userzhenshiname,actiondate,shouhuoname,songhuofangshi,zhifufangshi,zhuangtai from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai="&zhuangtai&" order by actiondate",conn,1,1

  end if

  do while not rs.eof
   %>
	<tr bgcolor="#FFFFFF" align="center"> 
	<td> 
	<a href="order.asp?dan=<%=trim(rs("dingdan"))%>" target="_blank"><%=trim(rs("dingdan"))%></a></div>
    </td>
    <td > 
        <%dim cnhw,rs2
	'////
	set cnhw=server.CreateObject("adodb.recordset")
	cnhw.open "select sum(zonger) as zonger from orders where dingdan='"&trim(rs("dingdan"))&"' ",conn,1,1
	response.write "<font color=#FF0000>"&cnhw("zonger")&"</font> 元"
	cnhw.close
	set cnhw=nothing%>
	</td>
	<td> 
        <%
	set cnhw=server.CreateObject("adodb.recordset")
	cnhw.open "select feiyong from orders where dingdan='"&trim(rs("dingdan"))&"' ",conn,1,1
	response.write "<font color=#FF0000>"&cnhw("feiyong")&"</font> 元"
	cnhw.close
	set cnhw=nothing%>
    </td>
    <td> 
        <%select case rs("zhuangtai")
	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><br>
<%
end sub
sub myinfo()
if request.cookies("Cnhww")("username")<>"" then
%>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F1F1F1">
	<tr align="center"> 
	<td colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="5%" align="center"></td>
          <td width="95%">我的统计信息</td>
        </tr>
      </table></td>
	</tr>
  <%
	set cnhw=server.CreateObject("adodb.recordset")
	cnhw.open "select * from [user] where username='"&request.cookies("Cnhww")("username")&"' ",conn,1,1
	ky_jifen=cnhw("jifen")
	%>
  <tr bgcolor="#ffffff" align="center"> 
    <td width="21%">用户类型：</td>
    <td width="79%" align="left">
	
	<font color=red> 
		<%if request.Cookies("cnhww")("reglx")=2 then%>
	VIP用户 
	<%else%>
	普通会员 
	<%end if%>
	</font>
		<%if request.Cookies("cnhww")("reglx")=2 then%>
	期限：<%=cnhw("vipdate")%> 
	<%end if%>
	
	</td>
  </tr>
  <tr bgcolor="#ffffff" align="center">  
    <td>登录次数：</td>
    <td align="left"><%=cnhw("logins")%></td>
  </tr>
  <tr bgcolor="#ffffff" align="center"> 
    <td>累计积分：</td>
    <td align="left"><%=cnhw("jifen")%></td>
  </tr>
  <%
	set cnhww=server.CreateObject("adodb.recordset")
	cnhww.open "select sum(zonger) as sum_jine from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai<=5",conn,1,1
	%>
  <tr bgcolor="#ffffff" align="center"> 
    <td>总购物金额：</td>
    <td align="left"><%=cnhww("sum_jine")%></td>
  </tr>
  <%cnhww.close
	set cnhww=nothing%>
  <tr bgcolor="#ffffff" align="center"> 
    <td><font color="#FF0000">预存款：</font></td>
    <td align="left"><%=cnhw("yucun")%></td>
  </tr>
  <%if request.cookies("Cnhww")("reglx")=2 then%>
  <tr bgcolor="#ffffff" align="center"> 
    <td>VIP期限：</td>
    <td align="left"><%=cnhw("vipdate")%></td>
  </tr>
  <%end if%>
  <%
	set cnhww=server.CreateObject("adodb.recordset")
	cnhww.open "select count(*) as rec_count from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai=6",conn,1,1
	%>
  <tr bgcolor="#ffffff" align="center"> 
    <td>收藏的商品数：</td>
    <td align="left"><%=cnhww("rec_count")%></td>
  </tr>
  <%cnhww.close
	set cnhww=nothing%>
  <%cnhw.close
	set cnhw=nothing%>
</table>
<%else%>
<table width="90%" height="60"  border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F1F1F1">
  <tr>
    <td bgcolor="#FFFFFF"><table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="528" background="images/mingle/shopcart_bg.gif"><img src="images/mingle/shopcart2.gif" width="219" height="50" /></td>
      </tr>
      <tr>
        <td height="30">&nbsp;</td>
      </tr>
      <tr>
        <td height="30"><table width="598"  border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td height="105" colspan="3" bgcolor="#FFFFFF"><img src="images/mingle/login_1.gif" width="598" height="105" /></td>
            </tr>
            <tr>
              <td height="120" colspan="3" background="images/mingle/login_bg.gif" bgcolor="#FFFFFF">
			  <%if request.cookies("Cnhww")("username")="" then%>
			  <table width="370" border="0" align="center" cellpadding="0" cellspacing="0">
                 <form name="fkinfo" method="post" action="checkuserlogin.asp">
				  <tr>
                    <td width="10" rowspan="3" background="images/mingle/login_bg3.gif">&nbsp;</td>
                    <td width="75" height="30"><span class="style1">·</span>账　号：</td>
                    <td width="152"><input name="username" class="wenbenkuang" type="text" id="username" maxLength="18" size="18"></td>
                    <td width="133" rowspan="3" align="center"><input type=image  src="images/mingle/login_4.gif" name="imageField" value="管理登陆"  ></td>
                  </tr>
                  <tr>
                    <td height="30"><span class="style1">·</span>密　码：</td>
                    <td width="152"><input name="userpassword" class="wenbenkuang" type="password" id="userpassword" maxLength="18" size="18">
<input class="wenbenkuang" type="hidden" name="linkaddress" value="<%=request.servervariables("http_referer")%>"></td>
                  </tr>
<tr> 
<td width="75"  height="30"><span class="style1">·</span>验证码：</td>
<td width="152">
<input class=wenbenkuang name=verifycode type=text value="<%If GetCode=9999 Then Response.Write "9999"%>" maxLength=4 size=10>
<img src=GetCode.asp></td>
</tr>
              </table>
			  <%else%>
<%response.redirect("index.asp")%>
<%end if%>			  </td>
            </tr>
            <tr>
              <td width="115" height="105" bgcolor="#FFFFFF"><img src="images/mingle/login3.gif" width="115" height="123" /></td>
              <td width="230" height="123" background="images/mingle/login4.gif" ><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td colspan="3">&nbsp;</td>
                </tr>
                <tr>
                  <td height="40" colspan="3">&nbsp;</td>
                </tr>
                <tr>
                  <td height="42">&nbsp;</td>
                  <td><a href="register.asp"><img src="images/mingle/reg.gif" border="0" /></a></td>
                  <td>&nbsp;</td>
                </tr>
              </table></td>
              <td width="253" height="123" background="images/mingle/login5.gif" ><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td colspan="3">&nbsp;</td>
                </tr>
                <tr>
                  <td height="40" colspan="3">&nbsp;</td>
                </tr>
                <tr>
                  <td width="10%" height="42">&nbsp;</td>
                  <td width="82%"><a href="#"  onClick="javascript:window.open('getpwd.asp','shouchang','width=450,height=300');"><img src="images/mingle/find.gif" width="124" height="31" border="0" /></a></td>
                  <td width="8%">&nbsp;</td>
                </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<%end if%>
<br>
<%
end sub
sub jifen()
if request.cookies("Cnhww")("username")="" then
response.Redirect "user.asp"
response.End
end if
%>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F1F1F1">
	<tr  align="center"> 
    <td align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="10%" align="center">&nbsp;</td>
        <td width="90%">积分兑换奖品说明</td>
      </tr>
    </table></td>
  </tr>
  <tr bgcolor="#FFFFFF" align="center"> 
    <td> 
      <table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr>
          <td>
            <%set rs=server.createobject("adodb.recordset")
                              rs.open "select jfhj from webinfo ",conn,1,1
                              response.write rs("jfhj")
                              rs.close
                              set rs=nothing
                              %>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="10%" align="center">&nbsp;</td>
        <td width="90%">我的积分情况</td>
      </tr>
    </table></td>
  </tr>
  <tr bgcolor="#FFFFFF" align="center"> 
    <td> 
        <table width="95%" height="24" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr>
        <%
	set cnhw=server.CreateObject("adodb.recordset")
	cnhw.open "select jifen from [user] where username='"&request.cookies("Cnhww")("username")&"' ",conn,1,1
	ky_jifen=cnhw("jifen")
	cnhw.close
	set cnhw=nothing%>
	<td width="50%">我的可用积分：<font color=#FF0000><%=ky_jifen%></font></td>
        <%
	set cnhw=server.CreateObject("adodb.recordset")
	cnhw.open "select sum(zonger) as sum_jine from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai<=5",conn,1,1
	ky_jifen=cnhw("sum_jine")
	cnhw.close
	set cnhw=nothing%>
	<td width="50%">累计购物金额(不含费用)：<font color=#FF0000><%=ky_jifen%></font> 元</td>
	</tr>
	</table>
    </td>
  </tr>
	  <tr> 
    <td align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="10%" align="center">&nbsp;</td>
          <td width="90%">积分与预存款换算</td>
        </tr>
      </table></td>
  </tr>
  <tr bgcolor="#FFFFFF" align="center"> 
    <td> 
        <table width="100%" height="24" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr><form name="form2" method="post" action="conversion.asp">
	<td>
  把
      <input name="jifen" type="text" id="jifen" size="10">
积分换算成预存款
<input type="submit" name="Submit" value="换算">
<input name="act" type="hidden" id="act" value="jifen">
    </td></form>
	<form name="form2" method="post" action="conversion.asp">
	<td>
  把
      <input name="cunkuan" type="text" id="cunkuan" size="10">
  元预存款换算成积分
  <input type="submit" name="Submit" value="换算">
  <input name="act" type="hidden" id="act" value="cunkuan">
            </td></form>
	</tr>
	        <tr>
	          <td colspan="2"><div align="center"><font color="#FF0000">换算:1元=2积分</font></div></td>
	          <%
	set cnhw=server.CreateObject("adodb.recordset")
	cnhw.open "select sum(zonger) as sum_jine from orders where username='"&request.cookies("Cnhww")("username")&"' and zhuangtai<=5",conn,1,1
	ky_jifen=cnhw("sum_jine")
	cnhw.close
	set cnhw=nothing%>
          </tr>
	</table>
    </td>
  </tr>
</table>
<br>
<%
end sub
sub shoucang()
if request.cookies("Cnhww")("username")="" then
response.Redirect "user.asp"
response.End
end if
%>
<script language="JavaScript">
<!--
var newWindow = null
function windowOpener(loadpos)
{	
  newWindow = window.open(loadpos,'newwindow','width=450,height=350,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');
	newWindow.focus();
}
//-->
</script>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F1F1F1">
<tr>
  <td width="5%" align=center>&nbsp;</td>
  <td width="95%" align=left>商品收藏数量 10 种</td>
</tr></table>
<%
set rs=server.CreateObject("adodb.recordset")

rs.open "select orders.actionid,orders.bookid,products.bookname,products.shichangjia,products.huiyuanjia,products.dazhe from products inner join  orders on products.bookid=orders.bookid where orders.username='"&request.cookies("Cnhww")("username")&"' and orders.zhuangtai=6",conn,1,1 

%>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F1F1F1">
  <form action="stowcart.asp" target="newwindow" method=post name=form1 onsubmit="windowOpener('')">
    <tr bgcolor="#FFFFFF" align="center"> 
      <td width=8%>选择</td>
      <td width=42%>商品名称</td>
      <td width=14%>市场价</td>
      <td width=14%>会员价</td>
      <td width=8%>删除</td>
    </tr>
    <%do while not rs.eof%>
    <tr bgcolor="#ffffff" align=center> 
      <td><input name=bookid type=checkbox checked value="<%=rs("bookid")%>" ></td>
      <td align=left><a href=products.asp?id=<%=rs("bookid")%> ><%=rs("bookname")%></a></td>
      <td><s><%=rs("shichangjia")%></s>元</td>
      <td><%=rs("huiyuanjia")%>元</td>
      <td><a href=stow.asp?action=del&actionid=<%=rs("actionid")%>&ll=1><img src=images/trash.gif width=15 height=17 border=0></a>
      </td>
    </tr>
    <%
rs.movenext
loop
rs.close
set rs=nothing
%>
	<tr bgcolor="#ffffff" align=center>
	<td height=25 colspan=6>