📄 default.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="include/const.asp"-->
<%
dim rs,sql, rs1
dim classid
dim classname
if request.querystring("classid")<>"" then
classid=int(request.querystring("classid"))
else
classid=0
end if
set rs = server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql="select * from Aclass where classID="&cstr(classid)
rs.open sql,conn,1,1
if not rs.eof then
classname=rs("class")
end if
rs.close
%><script language=Javascript>
<!--
function onChange(i){
childSort=document.all("child" + i);
//theTd=document.all("td" + i);
if(childSort.style.display=="none"){
// theTd.bgcolor="#ffffff";
childSort.style.display="";}
else{
// theTd.bgcolor="#000000";
childSort.style.display="none";}
}
//-->
</script>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<meta HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<LINK href="include/STYLE.CSS" rel=stylesheet>
<title><%=classname%></title>
</head>
<body>
<table width="779" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="779"><!--#include file="head.inc" -->
</td>
</tr>
<tr>
<td><TABLE cellSpacing=0 cellPadding=4 width="100%" border=0 align=center>
<TR>
<TD height="32" background="images/bg_2.gif"> <%
sql="select class,classid from Aclass"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "还没有任何栏目"
else
do while not rs.eof
%>
| <a href="default.asp?classid=<%=rs("classid")%>">
<%if cint(rs("classid"))=cint(classid) then%>
<font color=red><%=rs("class")%></font>
<%else%>
<%=rs("class")%>
<%end if%>
</a> | <%
rs.movenext
loop
end if
rs.close
%> </TD>
</TR>
<TR>
<TD class="title2"> <%
if classid>0 then
sql="select Nclass,Nclassid from ANclass where classID="&cstr(classid)
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "还没有任何栏目"
else
do while not rs.eof
%> <a href="productclass.asp?classid=<%=classid%>&Nclassid=<%=rs("Nclassid")%>"><%=rs("Nclass")%></a> <%
rs.movenext
loop
end if
rs.close
end if
%>
</TD>
</TR>
<TR>
<TD height="10"></TD>
</TR>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="160" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="32" background="images/bg_2.gif">推荐产品</td>
</tr>
<tr>
<td><%dim recommend
recommend=request("recommend")
sql="select top 4 * from product where recommend=1 order by dateandtime desc"
set rs=conn.execute(sql)%> <%
while not rs.eof
%> <table width="100%" border="0" cellspacing="2" cellpadding="1">
<tr>
<td> <div align="center">
<p>
<% if rs("images")="" then %>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="images/nopic.gif" border="0"></a>
<%else%>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="<%=rs("images")%>" border="0" width="95" height="95"></a>
<%end if%>
</p>
<p><font style=line-height:150%>名称：<a href="productview.asp?id=<%=rs("productid")%>" title=<%=left(rs("Nkey"),20)%>><%=left(rs("title"),13)%>...</a><br>
价格：
<%if not isnull(rs("price")) then%>
<%=rs("price")%>
<%else%>
不详
<%end if%>
</font></p>
</div></td>
</tr>
<tr>
<td height="5" background="images/bg.gif"></td>
</tr>
</table>
<%rs.movenext
wend
rs.close
'set rs=nothing
'conn.close
'set conn=nothing %> </td>
</tr>
<tr>
<td height="32" background="images/bg_2.gif">产品查询</td>
</tr>
<tr>
<td bgcolor="#F4FAED"><!--#include file=query.asp--></td>
</tr>
</table></td>
<td valign="top"><TABLE width="98%" border=0 align="center" cellPadding=4 cellSpacing=0>
<TR>
<TD height="32" background="images/bg_2.gif"><B><%=classname%></B>最新产品 </TD>
</TR>
<TR>
<TD> <font style=line-height:150%>
<%
sql="select top 4 "
sql=sql&"product.nkey,product.productid,product.title,product.dateandtime,product.hits,product.classid,product.images,product.content,product.price,product.state,product.Nclassid,ANclass.Nclass "
sql=sql&" from product,ANclass where product.Nclassid=ANclass.Nclassid"
if classid>0 then sql=sql&" and product.classid="&classid
sql=sql&" order by product.productid desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
没有更新任何产品
<%else%>
<%do while not rs.eof%>
</font> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<tr>
<td height="5" background="images/bg.gif"></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> <div align="center">
<% if rs("images")="" then %>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="images/nopic.gif" border="0"></a>
<%else%>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="<%=rs("images")%>" border="0" width="95" height="95"></a>
<%end if%>
</div></td>
<td><table width="98%" border="0" align="center" cellpadding="1" cellspacing="2">
<tr>
<td><strong>[<font style=line-height:150%><a href="productview.asp?id=<%=rs("productid")%>" title=<%=left(rs("Nkey"),20)%>><%=left(rs("title"),13)%>...</a></font>]<br>
</strong><font style=line-height:150%><%=left(rs("content"),45)%>...</font><strong> <br>
</strong></td>
</tr>
<tr>
<td><div align="right"><a href="productview.asp?id=<%=rs("productid")%>" title=<%=left(rs("Nkey"),20)%>><img src="images/1.gif" width="78" height="18" border="0"></a> </div></td>
</tr>
</table></td>
<td width="100">分类:<a href='productclass.asp?classid=<%=rs("classid")%>&Nclassid=<%=rs("Nclassid")%>'><%=rs("Nclass")%></a><br>
价格:<%if not isnull(rs("price")) then%>
<%=rs("price")%>
<%else%>
不详
<%end if%>
</font></font><br>
状态:<%if not isnull(rs("state")) then%>
<%=rs("state")%>
<%else%>
不详
<%end if%>
<br>
日期:<%if rs("dateandtime")=date() then%>
<font color=red><%=month(rs("dateandtime"))%>月<%=day(rs("dateandtime"))%>日</font>
<%else%>
<font color='#999999'><%=month(rs("dateandtime"))%>月<%=day(rs("dateandtime"))%>日</font>
<%end if%>
</font><br>
查看: <font style=line-height:150%><font color=green><%=rs("hits")%></font></font></td>
</tr>
</table></td>
</tr>
</table>
<font style=line-height:150%>
<%
rs.movenext
loop
end if
rs.close
%>
</font> </TD>
</TR>
</table></td>
<td width="165" valign="top"><TABLE cellSpacing=0 cellPadding=4 width="100%" border=0>
<TR>
<TD height="32" background="images/bg_2.gif">近期热门产品 </TD>
</TR>
<TR>
<TD class="tdbg"> <font style=line-height:150%>
<%
function gotTopic(str,strlen)
dim l,t,c, i
l=len(str)
t=0
for i=1 to l
c=Abs(Asc(Mid(str,i,1)))
if c>255 then
t=t+2
else
t=t+1
end if
if t>=strlen then
gotTopic=left(str,i)&"..."
exit for
else
gotTopic=str&" "
end if
next
end function
if classid=0 then hotkind=1
select case hotkind
case "1" sql="SELECT top 10 * FROM product where DateDiff('d',dateandtime,Date())<="&DateNum&" order by hits desc,title"
case "2" sql="SELECT top 10 * FROM product where DateDiff('d',dateandtime,Date())<="&DateNum&" and classid="&classid&" order by hits desc,title"
end select
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "近期无更新文章"
else
do while not rs.eof
%>
<li><a href="productview.asp?id=<%=rs("productid")%>" title="<%=rs("title")%>" target=_top><%=gottopic(rs("title"),25)%></a>[<font color=red><%=rs("hits")%></font>]<br>
<% rs.movenext
loop
end if
rs.close
%>
</font> </TD>
</TR>
<TR>
<TD height="32" background="images/bg_2.gif"><div align="left">产品分类导航</div></TD>
</TR>
<TR>
<TD class="tdbg"> <font style=line-height:150%>
<%
sql="select class,classid from Aclass"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "没有任何分类"
else
do while not rs.eof
%>
<strong><img src="images/newdian_1.gif" width="9" height="9"> [<a href="default.asp?classid=<%=rs("classid")%>"><%=rs("class")%></a>]</strong><br>
<%
sql="select Nclass,Nclassid,classid from ANclass where classid="&rs("classid")
rs1.open sql,conn,1,1
do while not rs1.eof
%>
<img src="images/newdian_2.gif"> <a href="productclass.asp?classid=<%=rs1("classid")%>&Nclassid=<%=rs1("Nclassid")%>"><%=rs1("Nclass")%></a><br>
<%
rs1.movenext
loop
rs1.close
%>
<br>
<%
rs.movenext
loop
end if
rs.close
conn.close
set conn=nothing
%>
</font> </TD>
</TR>
</table></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><!--#include file="foot.inc" -->
</td>
</tr>
</table>
<br>
<div align="center"> <center> </div>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -