nsort.asp

国内第一数字点卡销售程序。功能强大。 完整无错！数据文件经MD5加密！经严格测试

<!--#include file="top.asp"-->
<td width="15" height="3">&nbsp;</td> 
<!--#include file="lest.asp"-->
</td>
		<td width="15" height="30">&nbsp;</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>
<td > 
<!--#include file="classid.asp"--></td>
</tr>

<tr>
<td > 
      <%nclassid=int(request("nclassid"))
       anclassid=int(request("anclassid"))
      if not isNumeric (nclassid) then
        response.write "参数必须为数字型!"
        response.end
      end if
      if not isNumeric (anclassid) then
        response.write "参数必须为数字型!"
        response.end
      end if

      if nclassid=empty then
          response.redirect "index.asp"
      end if
      sql="select * from hw where nclassid="&int(nclassid)&" order by hw_id DESC"
      rs.open sql,conn,3,3
      if rs.eof then
          rs.close
          response.write "您所选的类别没有商品"
      %>
      </td></tr></table>
      <br>
      </td>
      </tr>
      </table>
      </td>
		    <td width="1"  background="images/line.jpg"></td>
      </tr>
      </td>
      <!--#include file="copy.asp"-->
      <%
          response.end
      end if
      rs.pagesize=10
      page = cint(request("page"))
      if page = "" then page = 1
      if not(isnumeric(page)) then page=1
      if page<1 then page=1
      if page >= rs.pagecount then page = rs.pagecount
      rs.absolutepage = page
  %> 
</td>
</tr>
<tr>
<td>
<table width="760" border="0" cellspacing="1" cellpadding="3" align="center" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td width="60" align="center">　</td>
<td width="121" align="center">商品名称</td>
<td align="center" width="161">商品简介</td>
<td align="center" width="60">商品类型</td>
<td width="63" align="center">
<div align="center">
市场价格
</div>
</td>
<td width="64" align="center">
<div align="center">
会员价
</div>
</td>
<td width="66" align="center"><% if session("user_vip")="经销商会员" then%>
经销商会员
<%else%>
VIP会员价<%end if%></td>
</tr>
<%
for i=1 to rs.pagesize
%>
<tr bgcolor="#FFFFFF">
<td>
<div align="center">
<a href="basket.asp?hw_id=<%=rs("hw_id")%>"><img border="1" src="picture/<%=rs("hw_pic")%>" width="78" height="82" class="border" alt="详细介绍"></a>
</div>
</td>
<td><div align="center"><a href="basket.asp?hw_id=<%=rs("hw_id")%>"><%=rs("hw_name")%></a><br><br>                 
<a href=basket.asp?hw_id=<%=rs("hw_id")%>><img border="0" src="images/p2.jpg" width="93" height="26"></a></div> </td>
<td width="161"> 
         <%if len(rs("hw_content"))>35 then
          hw_content=left(rs("hw_content"),35)
          response.write hw_content
          response.write "……"
          else
          response.write rs("hw_content")
          end if
          %>
</td>
<td width="60" align="center">
<%typp=rs("hw_cz")
select case typp
    case 0
      hh="在线取卡"
    case 1
      hh="充值商品"    
   end select
%> 
<font color="#008000"><%=hh%></font>	
</td>
<td>
<div align="center">
￥<s><%=rs("hw_cash")%></s>
</div>
</td>
<td width="64">
<div align="center">
<font color="#ff0000">￥<%=rs("hw_cash1")%></font>
</div>
</td>
<td width="66">
<p align="center">
<font color="#ff0000">￥<% if session("user_vip")="经销商会员" then%><%=rs("hw_cash3")%><%else%><%=rs("hw_cash2")%><%end if%></font>
　</td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
%>
</table>
</td>
</tr>
<tr>
<td>
                    <p align="center">共有记录<%=rs.recordcount%>条&nbsp;                   
                    <%=page%>/<%=rs.pagecount%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="<%request.servervariables("document_name")%>?page=<%=page-1%>&nclassid=<%=nclassid%>&anclassid=<%=anclassid%>">上一页</A> <A href="<%request.servervariables("document_name")%>?page=<%=page+1%>&nclassid=<%=nclassid%>&anclassid=<%=anclassid%>">下一页</A>&nbsp;&nbsp;&nbsp; 转到第 <SELECT onchange="window.location='?nclassid=<%=nclassid%>&anclassid=<%=anclassid%>&page='+this.value" name=gopage>              
                    <%for x=1 to rs.pagecount%>
                    <OPTION <%if x=page then%>selected<%end if%> value=<%=x%>><%=x%></OPTION>
                    <%next%>      
                    </SELECT> 页        
                    </div>
                    <%rs.close%> 
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
		<td width="1"  background="images/line.jpg"></td>
</tr>
</table>
</div>
<!--#include file="copy.asp"-->