mostsold.asp

一个电子商务网站完整代码,在.net平台下开发

<TABLE cellSpacing=0 cellPadding=0 width=160 border=0>
        <TR>
          <TD width=9><IMG height=9 src="images/vipasp_cornerl.gif" width=9></TD>
          <TD width=142 background=images/vipasp_top.gif></TD>
          <TD width=9><IMG height=9 src="images/vipasp_cornerr.gif" width=9></TD></TR>
        <TR>
          <TD width=9 background=images/vipasp_l.gif></TD>
              <TD vAlign=top width=142>
			  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td colspan="2" align="center"><strong><font color="#666699">最畅销商品</font></strong></td>
                      </tr>
                    
                        <%set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 1 id,name,solded,pic,introduce,price1,price2 from product order by solded desc",conn,1,1
		  if rs.eof and rs.bof then
			  response.write " <tr><td>对不起，请您先到商城后台添加商品。</td></tr>"
			  else
			 %>
                         <tr><td width="23%"> <A  HREF=product.asp?id=<%=rs("id")%> TARGET=_blank> 
                          <IMG ALT=<%=trim(rs("name"))%> SRC=<%if trim(rs("pic"))="" then
				  response.write "images/emptybook.gif"
				  else
				  response.write trim(rs("pic"))
				  end if%> BORDER=0></A> </td>
                        <td width="77%" valign="top">
                          <% response.write "<a href=product.asp?id="&rs("id")&" target=_blank title=此商品被出售"&rs("solded")&"次>"
				if len(trim(rs("introduce")))>30 then
				response.write left(trim(rs("introduce")),28)&"..."
				else
				response.write trim(rs("introduce"))
				end if
				response.write "</a>"
			  %>
                        </td>
                      </tr>
                      <tr> 
                        <td colspan="2">
						市场价：<%=rs("price1")%>元<BR>
                        会员价：<FONT COLOR=#FF6600><%=rs("price2")%></FONT>元</td>
                      </tr>
                      <tr> 
                        <td colspan="2" align="center">
                          <a href=# onClick="javascript:window.open('cart.asp?id=<% = rs("id") %>','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"><img src=images/cart.gif width=50 height=19 align=absmiddle border=0></a> <a href=# onClick="javascript:window.open('addto.asp?id=<% = rs("id") %>&action=add','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"><img src=images/addto.gif width=50 height=19 align=absmiddle border=0></a>
						  <%  end if
						  rs.close
			  set rs=nothing %>
                        </td>
                      </tr>
                    </table> </TD>
          <TD width=9 background=images/vipasp_r.gif></TD></TR>
        <TR>
          <TD width=9><IMG height=9 
            src="images/vipasp_cornerbl.gif" width=9></TD>
          <TD width=142 background=images/vipasp_b.gif></TD>
          <TD vAlign=bottom width=9><IMG height=9 
            src="images/vipasp_cornerbr.gif" 
      width=9></TD></TR></TABLE>