left.asp

一个功能很全面占用空间的小商城程序,适合个人网上开店使用

      <table border="0" width="180" cellspacing="0" cellpadding="0">
<tr>
<Td>
     <table align=center border=0 cellpadding=0 cellspacing=0 height=17 
      width=180>
        <tbody> 
        <tr> 
          <td><img height=17 src="image/r_1.gif" 
            width=180></td>
        </tr>
        </tbody>
      </table>
  <%if session("user_name")<>"" then%>
 <%            user_name=session("user_name")
                sql="select * from member where user_name='"&user_name&"'"
                rs.open sql,conn,3,3
                if rs.eof then
                else
                user_company=rs("user_company")
                user_yes=rs("user_yes")
                end if
                rs.close%>
      <table align=center bgcolor=#fff9ff border=1 bordercolor=#e9a7c4 
      cellpadding=0 cellspacing=1 height=135 width=180>
        <tbody> 

<tr> 
          <td width="100%">欢迎您：<%=session("user_name")%></td>
        </tr>
<% if  user_yes=false then%>
<tr> 
          <td width="100%"><img src="img/top02.gif" border=0>&nbsp; <A href="reg2.asp"><font color=red>建我的商店</font></a>
          </td>
        </tr>
<%else%><tr> 
          <td width="100%"><img src="img/top02.gif" border=0>&nbsp; <A href="listcom.asp?user_company=<%=user_company%>&ob=1"><font color=red>进我的商店</font></a>
          </td>
        </tr>
<%end if%> 
        <tr> 
          <td width="100%"> <img src="img/top02.gif" border=0>&nbsp; <A href="favlist.asp" target="_blank"><font color=red>商品收藏夹</font></a> 
          </td>
        </tr>
        <tr> 
          <td width="100%"> <img src="img/top02.gif" border=0>&nbsp; <A href="mydan.asp" target="_blank"><font color=red>我所有订单</font></a> 
          </td>
        </tr>
        <tr> 
          <td width="100%"> <img src="img/top02.gif" border=0>&nbsp; <a href=javascript:openScript('MODIFY.ASP',500,220)><font color=red>重新改资料</font></a> 
          </td>
        </tr>
        <tr> 
          <td width="100%"> <img src="img/top02.gif" border=0>&nbsp; <a href="basket.asp"><font color=red>查看购物车</font></a> 
          </td>
        </tr>

        <tr> 
          <td width="100%"> <img src="img/top02.gif" border=0>&nbsp; <a href="quit.asp"><font color=red>退出本系统</font></a> 
          </td>
        </tr>

        </tbody>
      </table>
  <%else%>
     <table align=center bgcolor=#fff9ff border=1 bordercolor=#e9a7c4 
      cellpadding=0 cellspacing=1 height=135 width=180>
        <tbody> 
        <tr> 
          <td>
            <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" height="100%">
              <form action="login.asp" method="post">
                <tr> 
                  <td bgcolor="#818181" colspan="2" width="1"></td>
                </tr>
                 
                <tr> 
                  <td valign="bottom" nowrap> 
                    <div align="center">用户:<font color="#FFFFFF"> 
                      <input 
            name=user_name size=10 
            style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: 1px groove; BORDER-LEFT: 1px groove; BORDER-RIGHT: 1px groove; BORDER-TOP: 1px groove; FONT-FAMILY: 宋体; FONT-SIZE: 9pt">
                      </font></div>
                  </td>
                  
                </tr>
                <tr> 
                  <td valign="bottom" nowrap> 
                    <div align="center">密码:<font color="#FFFFFF"> 
                      <input name=user_pass
            size=10 
            style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: 1px groove; BORDER-LEFT: 1px groove; BORDER-RIGHT: 1px groove; BORDER-TOP: 1px groove; FONT-FAMILY: 宋体; FONT-SIZE: 9pt" 
            type=password>
                      </font></div>
                  </td>
                  
                </tr>
                <tr> 
                  <td colspan="2" height="2"> 
                    <table align=center border=0 cellpadding=0 cellspacing=0 height="50">
                      <tr> 
                        <td align=middle width="87" height="54"> 
                          <input name=Submit7 style="BACKGROUND-COLOR: #fff9ff; BORDER-BOTTOM: 1px ridge; BORDER-LEFT: 1px ridge; BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-FAMILY: 宋体; FONT-SIZE: 9pt" type=submit value=登录 class="forInput2">
                        </td>
                        <td align=middle width="72" height="54"> 
                          <input name=Button2 onClick="window.location='reg1.asp'" style="BACKGROUND-COLOR: #fff9ff; BORDER-BOTTOM: 1px ridge; BORDER-LEFT: 1px ridge; BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-FAMILY: 宋体; FONT-SIZE: 9pt" type=button value=注册 ?target="_blank" class="forInput2">
                        </td>

                      </tr>
                      <tbody> </tbody> 
                    </table>
                  </td>
                </tr>
                 
              </form>
            </table>
          </td>
        </tr>
        </tbody>
      </table>
  <%end if%>
</td>
</tr>
<tr><Td>
      <table align=center border=0 cellpadding=0 cellspacing=0 height=17 
      width=180>
        <tbody> 
        <tr> 
          <td><img height=17 src="image/r_5.gif" 
            width=180></td>
        </tr>
        </tbody>
      </table>
      <table align=center bgcolor=#ffffff border=1 bordercolor=#e9a7c4 
      cellpadding=4 cellspacing=1 height=1 width=180>
        <tbody> 
        <tr> 
          <td bgcolor=#ffffff class=p_flo>
<table width="100%" border="0" cellspacing="0" cellpadding="4" align="center" height="100%" bgcolor=#fff9ff>
  <tr>
    <td width="100%" valign="top"> 
      <form name="search" method="post" action="querygoods.asp" >
<table width="100%" border="0" cellspacing="5" cellpadding="0">
                                  <tr>
                                    <td>
                                      <div align="right" class="font_1">条件：</div>
                                    </td>
                                   <td>
                                     <select name="action" size="1">
                                     <option value="title">产品名称</option>
                                     </select>
                                    </td>
                                  </tr>
                                  <tr>
                                    <td>
                                      <div align="right" class="font_1">关键字：</div>
                                    </td>
                                    <td>
                                      <input type="text" name="keyword" size="8" class="line1">
                                    </td>
                                  </tr>
                                  <tr>
                                    <td>
                                      <div align="right" class="font_1">经销商：</div>
                                    </td>
                                    <td>
                                      <input type="text" name="company" size="8" class="line1">
                                       </td>
                                  </tr>
                                
 <tr> 
                                    <td width="62%">&nbsp;</td>
                                    <td width="38%" valign="top"><input type="image"  src="img/23.jpg" width="55" height="20"></td>
                                  </tr>
                                </table>
                               </form>
    </td>  
  </tr>
  <tr> 
    <form method="post" name="orderSearch" action="query.asp">
      <td>
        <div align="center">订单号: 
          <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: 1px groove; BORDER-LEFT: 1px groove; BORDER-RIGHT: 1px groove; BORDER-TOP: 1px groove; FONT-FAMILY: 宋体; FONT-SIZE: 9pt" type="text" size="10" name="sub_number"><p>
          <input style="BACKGROUND-COLOR: #fff9ff; BORDER-BOTTOM: 1px ridge; BORDER-LEFT: 1px ridge; BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-FAMILY: 宋体; FONT-SIZE: 9pt" type="submit" name="Submit3" value="订单搜索" class="forInput">
        </div>
      </td>
    </form>
  </tr>
</table>
      </td>
        </tr>
        </tbody>
      </table>
</td></tr>
<tr><Td>
<table align=center border=0 cellpadding=0 cellspacing=0 height=17 
      width=180>
        <tbody> 
        <tr> 
          <td> <img height=17 src="image/r_j.gif" 
            width=180></td>
        </tr>
        </tbody>
      </table>
      <table align=center border=1 bordercolor=#e9a7c4 cellpadding=4 
      cellspacing=1 width=180>
        <tbody> 
        <tr> 
          <td>
            <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
              <tr> 
                <td height=5></td>
              </tr>
              <tr> 
                <td width=100%>
 <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<%sql="select * from member where user_yes=true order by user_id DESC "
              rs.open sql,conn,3,3
              goodsno=rs.recordcount
              if hong<6 then hong=goodsno
              if hong >= 6 then hong=6
              if rs.eof then
                  response.write "暂且没有店铺"
              else
i=0
                  do while i<hong
                 i=i+1 %><tr> 
                  <td width=75%> <img src="img/top03.gif" border=0><a href="listcom.asp?user_company=<%=rs("user_company")%>&ob=1"><%=rs("user_company")%></a>
</td><td width=25%>商品<font color=red><%
                     set rs1=server.createobject("adodb.recordset")
                     user_company=rs("user_company")
                     sql1="select * from hw where user_company='"&user_company&"'"
                     rs1.open sql1,conn,3,3
                     response.write rs1.recordcount
                     rs1.close
                     %></font></td></tr>
<% rs.movenext
                  loop
              end if
              rs.close
              %>
       </table></td>
              </tr>