index.asp

网络商城系统

<!--#include file="top.asp"-->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0"> 
<tr> 
  <td width="180" valign="top"> 
    <table width="761" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="FE9ACE">
      <tr> 
        <td width="180" valign="top"><!--#include file="left.asp"--></td>
        <td width="580" valign="top" bgcolor="#FFFFFF"> 
          <table width="2" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
            <tr> 
              <td height="3"></td>
            </tr>
          </table>
          <div align="center"><img src="images/new.gif" width="575">
            <table width="575" height="42" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
              <tr> 
                <td valign="top"> 
                  <%
			set rs=server.createobject("adodb.recordset")
			sql="select top 4 * from goods order by id desc"
			rs.open sql,conn,1,1
			if rs.eof then
			response.write"暂时没有最新商品"
			else
			%>
                  &nbsp; <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr> 
                      <%
			  i=0
			do while not rs.eof
			i=i+1
			  %>
                      <td><table width="246" height="80" border="0" cellpadding="0" cellspacing="0">
                          <tr> 
                            <td width="80" height="80" rowspan="4"><a href="goods.asp?id=<%=rs("id")%>"><img class="border3" border="0" src="<%=rs("sp_pic")%>" width="80" height="80"></a></td>
                            <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><font style="text-decoration:underline;color:#FF20AB"><%=rs("sp_name")%></font></a></div></td>
                          </tr>
                          <tr> 
                            <td><div align="center">市场价:<s><%=rs("marprice")%></s>元</div></td>
                          </tr>
                          <tr> 
                            <td><div align="center">会员价:<%=rs("memprice")%>元</div></td>
                          </tr>
                          <tr> 
                            <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><img border="0" src="images/look.gif" width="58" height="22"></a></div></td>
                          </tr>
                        </table></td>
                      <%
			if i mod 2=0 then
			%>
                    </tr>
                    <tr> 
                      <td height="15"></td>
                    </tr>
                    <%
			  end if
			if i>4 then exit do end if
			rs.movenext
			loop
			%>
                  </table>
                  <%
			end if
			rs.close
			set rs=nothing
			%>
                </td>
              </tr>
            </table>
          </div>
          <div align="center"><img src="images/tj.gif" width="575" height="24"> 
            <table width="575" height="42" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
              <tr> 
                <td valign="top"> 
                  <%
			set rs=server.createobject("adodb.recordset")
			sql="select top 4 * from goods where tj=true order by id desc"
			rs.open sql,conn,1,1
			if rs.eof then
			response.write"暂时没有推荐商品"
			else
			%>
                  &nbsp; <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr> 
                      <%
			  i=0
			do while not rs.eof
			i=i+1
			  %>
                      <td><table width="246" height="80" border="0" cellpadding="0" cellspacing="0">
                          <tr> 
                            <td width="80" height="80" rowspan="4"><a href="goods.asp?id=<%=rs("id")%>"><img class="border3" border="0" src="<%=rs("sp_pic")%>" width="80" height="80"></a></td>
                            <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><font style="text-decoration:underline;color:#FF20AB"><%=rs("sp_name")%></font></a></div></td>
                          </tr>
                          <tr> 
                            <td><div align="center">市场价:<s><%=rs("marprice")%></s>元</div></td>
                          </tr>
                          <tr> 
                            <td><div align="center">会员价:<%=rs("memprice")%>元</div></td>
                          </tr>
                          <tr> 
                            <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><img border="0" src="images/look.gif" width="58" height="22"></a></div></td>
                          </tr>
                        </table></td>
                      <%
			if i mod 2=0 then
			%>
                    </tr>
                    <tr> 
                      <td height="15"></td>
                    </tr>
                    <%
			  end if
			if i>4 then exit do end if
			rs.movenext
			loop
			%>
                  </table>
                  <%
			end if
			rs.close
			set rs=nothing
			%>
                </td>
              </tr>
            </table>
            <img src="images/cx.gif" width="575" height="24"> 
            <table width="575" height="42" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
              <tr> 
                <td width="561" valign="top"> 
                  <%
			set rs=server.createobject("adodb.recordset")
			sql="select top 4 * from goods where tejia=true order by id desc"
			rs.open sql,conn,1,1
			if rs.eof then
			response.write"暂时没有特价商品"
			else
			%>
                  &nbsp; <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr> 
                      <%
			  i=0
			do while not rs.eof
			i=i+1
			  %>
                      <td><table width="246" height="80" border="0" cellpadding="0" cellspacing="0">
                          <tr> 
                            <td width="80" height="80" rowspan="4"><a href="goods.asp?id=<%=rs("id")%>"><img class="border3" border="0" src="<%=rs("sp_pic")%>" width="80" height="80"></a></td>
                            <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><font style="text-decoration:underline;color:#FF20AB"><%=rs("sp_name")%></font></a></div></td>
                          </tr>
                          <tr> 
                            <td><div align="center">市场价:<s><%=rs("marprice")%></s>元</div></td>
                          </tr>
                          <tr> 
                            <td><div align="center">会员价:<%=rs("memprice")%>元</div></td>
                          </tr>
                          <tr> 
                            <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><img border="0" src="images/look.gif" width="58" height="22"></a></div></td>
                          </tr>
                        </table></td>
                      <%
			if i mod 2=0 then
			%>
                    </tr>
                    <tr> 
                      <td height="15"></td>
                    </tr>
                    <%
			  end if
			if i>4 then exit do end if
			rs.movenext
			loop
			%>
                  </table>
                  <%
			end if
			rs.close
			set rs=nothing
			%>
                </td>
              </tr>
            </table>
            <br>
          </div></td>
		  
      </tr>
    </table>
    <!--#include file="bottom.asp"-->