sort.asp

以前企业建网站

<!--#include file="top.asp"-->
<table width="780" bgcolor=
<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color")%>
<%rs.close%>
 border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="1" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color2")%>
<%rs.close%>>　</td>
<td width="146" valign="top" align=center> 
<!--#include file="left.asp"-->
</td>
<td width="1" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color2")%>
<%rs.close%>></td>
<td bgcolor="#FFFFFF" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<form name="form2" method="post" action="jump.asp">
<td bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color")%>
<%rs.close%>> 
                  <%sort_id=trim(request("sort_id"))
      if sort_id=empty then
          response.redirect "index.asp"
      end if
	        page=request.querystring("page")
      if page="" then page=1
      if not(isnumeric(page)) then page=1
      if page<1 then page=1
      page=int(page)
      sql="select * from hw where sort_id='"&sort_id&"' order by hw_id DESC"
      rs.open sql,conn,3,3
      if rs.eof then
          response.write "您所选的类别没有商品"
          response.end
      else
          rs.pagesize=8
          totalrec=rs.recordcount
          totalpage=rs.pagecount
          if page>totalpage then page=totalpage
          rs.absolutepage=page
          rs.cachesize=rs.pagesize
          i=0
          dim hw_id(),hw_name(),hw_cash(),hw_cash1(),hw_views(),hw_gg(),hw_buys(),hw_content(),hw_pic(),hw_date()
          do while not rs.eof and (i<rs.pagesize)
          i=i+1
          redim preserve hw_id(i),hw_name(i),hw_cash(i),hw_cash1(i),hw_views(i),hw_gg(i),hw_buys(i),hw_content(i),hw_pic(i),hw_date(i)
          hw_id(i)=rs("hw_id")
          hw_name(i)=rs("hw_name")
          hw_cash(i)=rs("hw_cash")
          hw_cash1(i)=rs("hw_cash1")
          hw_gg(i)=rs("hw_gg")
          hw_views(i)=rs("hw_views")
          hw_buys(i)=rs("hw_buys")
          hw_content(i)=rs("hw_content")
          hw_pic(i)=rs("hw_pic")
          hw_date(i)=rs("hw_date")
          rs.movenext
          loop
      end if
      rs.close
          %>
<div align="right">
共<font color="red"><%=totalpage%></font>页 第<%=page%>页 <font color="666666">       
                    <%if page-1>0 then%>
 <a href="sort.asp?sort_id=<%=sort_id%>&amp;page=<%=page-1%>">上一页</a>        
                    <%else%>       
 上一页        
                    <%end if%> 
                    <% dim tmppage,z       
					z=10 
					if totalpage>z then 
					 else z=totalpage 
					 end if %> 
                    <% for tmppage=1 to z %>       
 <a href="sort.asp?sort_id=<%=sort_id%>&amp;page=<%=tmppage%>">      
                    <% =tmppage %>
                    </a>&nbsp; <%next %>      
                    <%if page+1<=totalpage then%>      
 <a href="sort.asp?sort_id=<%=sort_id%>&amp;page=<%=page+1%>">下一页</a>        
                    <%else%>       
 下一页        
                    <%end if%> 
 </font><input type="hidden" name="sort_id" value="<%=sort_id%>"> 跳转到 <input type="text" name="jump" size="3" class="ipt">       
页<font color="666666"> &nbsp;&nbsp;</font>      
</div>
</td>
                    </form>
</tr>
<tr>
<td>
<table width="97%" border="0" cellspacing="1" cellpadding="3" align="center" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td width="60" align="center">　</td>
<td width="90" align="center">商品名称</td>
<td align="center">商品简介</td>
<td width="60" align="center">
<div align="center">
市场价格
</div>
</td>
<td width="70" align="center">
<div align="center">
会员优惠价
</div>
</td>
<td width="80" align="center">
<div align="center">
订购
</div>
</td>
</tr>
                    <%
      for i=1 to ubound(hw_id)
      %>
<tr bgcolor="#FFFFFF">
<td>
<div align="center">
<a href="watch.asp?hw_id=<%=hw_id(i)%>"><img border="1" src="picture/<%=hw_pic(i)%>" width="45" height="56" class="border" alt="详细介绍"></a>
</div>
</td>
<td><a href="watch.asp?hw_id=<%=hw_id(i)%>"><%=hw_name(i)%></a></td>
<td> 
                        <%if len(hw_content(i))>35 then
          hw_content(i)=left(hw_content(i),35)
          response.write hw_content(i)
          response.write "……"
          else
          response.write hw_content(i)
          end if
          %>
</td>
<td>
<div align="center">
￥<s><%=hw_cash(i)%></s>
</div>
</td>
<td>
<div align="center">
<font color="#ff0000">￥<%=hw_cash1(i)%></font>
</div>
</td>
<td>
<div align="center">
<a href="javascript:openbag(<%=hw_id(i)%>)"><img border="0" src="images/p2.jpg" width="93" height="26"></a>
</div>
</td>
</tr>
                    <%next%>
</table>
</td>
</tr>
<tr>
                    <form name="form3" method="post" action="jump.asp">
<td bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color")%>
<%rs.close%>>
<div align="right">
共<font color="red"><%=totalpage%></font>页 第<%=page%>页 <font color="666666">      
                    <%if page-1>0 then%>
 <a href="sort.asp?sort_id=<%=sort_id%>&amp;page=<%=page-1%>">上一页</a>       
                    <%else%>      
 上一页       
                    <%end if%> 
                    <% for tmppage=1 to z %>      
 <a href="sort.asp?sort_id=<%=sort_id%>&amp;page=<%=tmppage%>">     
                    <% =tmppage %>
                    </a>&nbsp; <%next %>     
                    <%if page+1<=totalpage then%>    
 <a href="sort.asp?sort_id=<%=sort_id%>&amp;page=<%=page+1%>">下一页</a>       
                    <%else%>      
 下一页       
                    <%end if%> 
 </font><input type="hidden" name="sort_id" value="<%=sort_id%>"> 跳转到 <input type="text" name="jump" size="3" class="ipt">      
页<font color="666666"> &nbsp;&nbsp;</font>     
</div>
</td>
</form>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
<td width="1" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color2")%>
<%rs.close%>></td>
</tr>
</table>
<!--#include file="copy.asp"-->