?? bigclass.asp
字號:
<%@ Language=VBScript%>
<!--#include file=include/conn.asp -->
<!--#include file=include/function.asp -->
<%
request_BigClassID=Request.QueryString("BigClassID")
request_BigClassName=trim(Request.QueryString("BigClassName"))
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from BigClass order by BigClassID"
rs.Open rs.Source,conn,1,1
dim ArrayBigClassID(20),ArrayBigClassName(20)
BigClassCount=rs.RecordCount
for i=1 to BigClassCount
ArrayBigClassID(i)=rs("BigClassID")
ArrayBigClassName(i)=trim(rs("BigClassName"))
rs.MoveNext
next
set rs2=server.CreateObject("ADODB.RecordSet") '專題
rs2.Source="select Top 10 * from Special order by SpecialID DESC "
rs2.Open rs2.Source,conn,1,1
set rs4=server.CreateObject("Adodb.RecordSet")
rs4.source="select * from SmallClass Where BigClassName='" & request_BigClassName &"' order by SmallClassID"
rs4.open rs4.source,conn,1,1
SmallClassCount=rs4.RecordCount
dim ArraySmallClassID(20),ArraySmallClassName(20)
for i=1 to SmallClassCount
ArraySmallClassID(i)=rs4("SmallClassID")
ArraySmallClassName(i)=trim(rs4("SmallClassName"))
rs4.MoveNext
next
rs4.Close
set rs4=nothing
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=request_BigClassName%>__<%=redcaff%></title>
<LINK href=news.css rel=stylesheet>
<link href="../css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.lanmu {
font-size: 12px;
color: #FFFFFF;
text-decoration: none;
}
a:link {
font-size: 12px;
color: #FFFFFF;
}
a:visited {
font-size: 12px;
color: #FFffff;
text-decoration: none;
}
-->
</style>
</head>
<body text="#000000" topmargin="0">
<!--#include file=include/top.asp -->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="5" rowspan="2" background="images/bgimg_left.gif"> </td>
<td><table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="160" bgcolor="f4f4f4"> </td>
<td width="514" height="25" bgcolor="#F4f4f4" class="white_bg"><font color="#000000">當前位置：</font><font color="#FFFFFF"><a class=bai1 href="./" >首頁</a><font color="#000000">>></font></font><a class=bai1 href="BigClass.asp?BigClassID=<%=request_BigClassID%>&BigClassName=<%=request_BigClassName%>"><%=request_BigClassName%></a></td>
<td width="95" bgcolor="#F4f4f4"> </td>
</tr>
</table></td>
<td width="5" rowspan="2" background="images/bgimg_right.gif"> </td>
</tr>
<tr>
<td><table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#f4f4f4">
<tr>
<td width="134" height="1" align="center" valign="top" bgcolor="#f4f4f4">
</td>
<td width="607" rowspan="2" align="center" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="176" align="left" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellpadding="0" height="1" cellspacing="0">
<tr>
<td width="67%"></td>
<td width="33%"></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center">
<%
set rs3=server.CreateObject("ADODB.RecordSet")
for i=1 to SmallClassCount
SmallClassID=ArraySmallClassID(i)
SmallClassName=ArraySmallClassName(i)
rs3.Source="select top 3 NewsID,Title,UpdateTime,BigClassName,SmallClassName,SpecialID,click from News where SmallClassName='" & SmallClassName &"' order by NewsID DESC"
rs3.Open rs3.Source,conn,1,1
Response.Write "<tr><td width=100% valign=middle height=18><table width=100% valign=middle border=0 cellspacing=1 cellpadding=0 height=20><tr><td width=100% valign=middle><font color=000000> <img src=images/2.gif> :::: " & SmallClassName & "::::</font></td></tr></table></td></tr>"
if not rs3.EOF then
more=1
else more=0
end if
while not rs3.EOF
'定義標題顯示限制
Title=trim(rs3("Title"))
TitleLen=len(Title)
If TitleLen<21 then
TrString="<tr><td width=100% ><table width=100% height=18 border=0 cellspacing=0 cellpadding=0 height=20><tr><td width=100% valign=middle> <img src=images/arrow.gif> <a class=bai1 href='ReadNews.asp?NewsID=" & rs3("NewsID") & "&BigClassName="& rs3("BigClassName") &"&SmallClassName=" & rs3("SmallClassName") & "&SpecialID=" & rs3("SpecialId") & "' target=_blank>" & Title & "</a><<font color=#666666>("& Month(rs3("UpdateTime")) &"月"& Day(rs3("UpdateTime")) & "日)[<font color=#ff3333>"& rs3("click") &"</font>]</font></td></tr></table></td></tr>"
else
DisplayTitle=mid(Title,1,21)
TrString="<tr><td width=100% ><table width=100% height=18 border=0 cellspacing=0 cellpadding=0 height=20><tr><td width=100% valign=middle> <img src=images/arrow.gif> <a class=bai1 href='ReadNews.asp?NewsID=" & rs3("NewsID") & "&BigClassName="& rs3("BigClassName") &"&SmallClassName=" & rs3("SmallClassName") & "&SpecialID=" & rs3("SpecialId") & "' target=_blank>" & displaytitle & "...</a><font color=#666666>("& Month(rs3("UpdateTime")) &"月"& Day(rs3("UpdateTime")) & "日)[<font color=#ff3333>"& rs3("click") &"</font>]</font></td></tr></table></td></tr>"
end if
Response.Write TrString
rs3.MoveNext
wend
rs3.close
if more=1 then
%>
<tr>
<td width="98%" align=left valign=middle height="20">
<a href="SmallClass.asp?BigClassName=<%=request_BigClassName%>&SmallClassName=<%=SmallClassName%>"><img src="images/Bt_more.gif" width="35" height="7" border="0"></a>
<table width="85%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" align="left" bgcolor="#CCCCCC"></td>
</tr>
</table></td>
</tr>
<%
end if
%>
<tr>
<td> </td>
</tr>
<%next
%>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="160" align="center" valign="top" bgcolor="#f4f4f4"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="38"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" background="images/sousuo.gif"> </td>
</tr>
<tr>
<td><table width="100%" border="0" align=center cellpadding="0" cellspacing="0">
<form action=search.asp method=post target=_blank id=form1 name=form1>
<tr>
<td width="100%" height="30" align=center valign="middle" bgcolor="#f4f4f4">
<select size=1 name=select style=font-size:9pt;position:relative;width:110;height:23>
<option value=>請選擇搜索類別</option>
<option value=0 selected>所有類別</option>
<%for i=1 to BigClassCount%>
<option value=<%=ArrayBigClassID(i)%>><%=ArrayBigClassName(i)%></option>
<%next%>
</select>
</td>
</tr>
<tr>
<td width="100%" height="50" align=center valign="middle" bgcolor="#F4f4f4" >
<input type=text name=keyword2 size=14>
<br>
<input name=submit1 type=image src=images/serch.gif width="52" height="18">
</td>
</tr>
</form>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="11" background="images/bt_bg.gif"></td>
</tr>
<tr>
<td height="39"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F4f4f4">
<tr>
<td height="40" background="images/smallclass.gif"> </td>
</tr>
<tr>
<td><table width="100%" border="0" align=center cellpadding="1" cellspacing="0">
<tr>
<%
for i=1 to SmallClassCount
Response.Write "<tr><td align=center bgcolor=#f4f4f4><a class=bai1 href='SmallClass.asp?BigClassID=" & request_BigClassID & "&BigClassName="& request_BigClassName & "&SmallClassID=" & ArraySmallClassID(i)& "&SmallClassName="& ArraySmallClassName(i) &"'>" & ArraySmallClassName(i) & "</a></td></tr>"
next
%>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="11" background="images/bt_bg.gif"></td>
</tr>
<tr>
<td height="65"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" background="images/zhuanti.gif"> </td>
</tr>
<tr>
<td><table width="100%" height="45" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="5"></td>
<%
while not rs2.EOF
TrString="<tr><td width=100% height=18 bgcolor=#F4F4F4> <font color=#5284AD><img src=images/icon_arrow_04.gif></font><a class=BAI1 href=Special_News.asp?SpecialID=" & rs2("SpecialID") &"&SpecialName="& rs2("SpecialName") &"> " & trim(rs2("SpecialName")) & "</a></td></tr>"
Response.Write TrString
rs2.MoveNext
wend
rs2.Close
set rs2=nothing
%>
</tr>
<tr>
<td height="10" bgcolor="#F4F4F4"> <div align="right" class="bai1"><a href=special.asp class="bai1">更多專題...</a></div></td>
</tr>
<tr>
<td height="10" background="images/bt_bg.gif"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="780" height="1" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="5" height="1" background="images/bgimg_left.gif"></td>
<td height="1" bgcolor="cccccc"></td>
<td width="5" height="1" background="images/bgimg_right.gif"></td>
</tr>
</table>
<!--#include file=include/bottom.asp -->
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -