?? bigclass.asp
字號:
<%@ Language=VBScript%>
<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<!--#include file="function.asp"-->
<!--#include file="char.inc"-->
<%
typeid=checkstr(request("typeid"))
request_BigClassID=Request.QueryString("BigClassID")
if typeid="" or request_bigclassid="" then
Show_Err("未指定參數(shù)<br><br><a href='javascript:history.back()'>返回</a>")
response.end
else
if not IsNumeric(request_BigClassID) or not IsNumeric(typeid) then
Show_Err("非法參數(shù)<br><br><a href='javascript:history.back()'>返回</a>")
response.end
else
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_BigClass_Table &" where bigclassid=" & request_bigclassid &" order by BigClassorder"
rs.Open rs.Source,conn,1,1
bigclassname=rs("bigclassname")
bigclassorder=rs("bigclassorder")
bigclasszs=rs("bigclasszs")
rs.close
set rs=nothing
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_BigClass_Table &" where typeid=" & typeid &" order by BigClassorder"
rs.Open rs.Source,conn,1,1
dim digclassid
bigclassid=checkstr(request("bigclassid"))
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_smallClass_Table &" where bigclassid="& bigclassid &" order by smallClassorder"
rs.Open rs.Source,conn,1,1
i=1
Dim ArraytypeID(10000),ArraybigclassName(10000),ArraysmallClassView(10000)
if not rs.EOF then
rseof=1
end if
end if
while not rs.EOF
abcount=rs.RecordCount
smallClassView=rs("smallClassView")
smallClassID=rs("smallClassID")
smallClassName=trim(rs("smallClassName"))
ArraysmallClassView(i)=smallClassView
ArraysmallClassID(i)=smallClassID
ArraysmallClassName(i)=smallClassName
i=i+1
rs.MoveNext
wend
rs.close
set rs2=server.CreateObject("ADODB.RecordSet") '專題
rs2.Source="select Top " & top_sp & " * from "& db_Special_Table &" order by SpecialID DESC "
rs2.Open rs2.Source,conn,1,1
rs2.close
set rs2=nothing
set rs4=server.CreateObject("Adodb.RecordSet")
rs4.source="select * from "& db_SmallClass_Table &" Where BigClassid=" & request_BigClassid &" order by SmallClassorder"
rs4.open rs4.source,conn,1,1
SmallClassCount=rs4.RecordCount
dim ArraySmallClassID(10000),ArraySmallClassName(10000)
for i=1 to SmallClassCount
ArraySmallClassID(i)=rs4("SmallClassID")
ArraySmallClassName(i)=rs4("SmallClassName")
rs4.MoveNext
next
rs4.Close
set rs4=nothing
dim typename
set rs5=server.CreateObject("ADODB.RecordSet")
rs5.Source="select * from "& db_Type_Table &" where typeid=" & typeid &" order by typeorder"
rs5.Open rs5.Source,conn,1,1
typename=rs5("typename")
typeorder=rs5("typeorder")
rs5.Close
set rs5=nothing
end if
%>
<html><head>
<meta http-equiv="Content-Type" content="">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=BigClassName%>__<%=typeName%>__<%=jjgn%></title>
<LINK href=news.css rel=stylesheet>
</head>
<body topmargin="0">
<!--#include file="top.asp"-->
<%
dim bigclassname
bigclassid=checkstr(request("bigclassid"))
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_bigclass_Table &" where typeid="& bigclassid &" order by bigclassorder"
rs.Open rs.Source,conn,1,1
bigclassname=rs("bigclassname")
rs.close
set rs=nothing
%>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr valign="top">
<td width="180" background="IMAGES/menu-d.gif" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="645" valign="top" background="IMAGES/menu-d.gif" bgcolor="#FFFFFF">
<table width="102%" border="0" cellspacing="0" cellpadding="2">
<tr bgcolor="#FFFFFF">
<td height="25" align="center" background="IMAGES/menu-d-fl.gif" bgcolor="efefef"><font color="#000000"><%=BigClassName%>·大類 <%=Typeorder%>-<%=bigclassorder%></font>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="30%" align="center" valign="top" background="IMAGES/menu-d.gif">
<table width="100%" border="0" cellpadding="3" cellspacing="0" id="AutoNumber2" style="border-collapse: collapse">
<%
set rs6=server.CreateObject("ADODB.RecordSet")
rs6.Source="select * from "& db_SmallClass_Table &" where BigClassId="&request_bigclassid&" order by SmallClassorder"
rs6.Open rs6.Source,conn,1,1
do while not rs6.eof%>
<tr>
<td align=center valign="middle">
<a class=class href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=rs6("bigclassid")%>&smallclassid=<%=rs6("smallclassid")%>"><%=rs6("smallclassname")%></a>
</td>
</tr>
<%rs6.movenext
loop
rs6.Close
set rs6=nothing
%>
</table>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#999999" width="100%" id="AutoNumber4" height="25">
<tr>
<td height="25" align=center background="IMAGES/menu-d-pic.gif"><font color="#000000">最新圖文</font>
</td>
</tr>
<tr>
<td width="100%" height="20" align=center><br>
<%
set rs3=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies(Forcast_SN)("key")="super" or Request.cookies(Forcast_SN)("key")="typemaster" or Request.cookies(Forcast_SN)("key")="bigmaster" or Request.cookies(Forcast_SN)("key")="smallmaster" or Request.cookies(Forcast_SN)("key")="check" then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(Forcast_SN)("key")="" then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and newslevel=0 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(Forcast_SN)("key")="selfreg" then
if Request.cookies(Forcast_SN)("reglevel")=3 then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(Forcast_SN)("reglevel")=2 then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(Forcast_SN)("reglevel")=1 then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
end if
else
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
rs3.Open rs3.Source,conn,1,1
if not rs3.EOF then
while not rs3.EOF
fileExt=lcase(getFileExtName(rs3("picname")))
Content=htmlencode4(rs3("Content"))
%>
<table width="90%" border="0" cellspacing="0" cellpadding="3" align="center" style="TABLE-LAYOUT: fixed">
<tr>
<td style="WORD-WRAP: break-word">
<a class=middle href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=htmlencode4(rs3("title"))%>">
<%if fileext="jpg" or fileext="bmp" or fileext="png" or fileext="gif" then%>
<img src="<%=FileUploadPath & rs3("picname")%>" width="65" height="65" border=0 align="left">
<%end if%>
<%if fileext="swf" then%>
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' width="65" height="65" border=0 align="left">
<param name=movie value="<%=FileUploadPath & rs3("picname")%>">
<param name=quality value=high>
<param name='Play' value='-1'>
<param name='Loop' value='0'>
<param name='Menu' value='-1'>
<embed src="<%=FileUploadPath & rs3("picname")%>" width="65" height="65" border=0 align="left" pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash'></embed>
</object>
<%end if%>
<%=rs3("title")%>
</a>
</td>
</tr>
</table>
<%
rs3.MoveNext
wend
else
Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" align=""center"" style=""TABLE-LAYOUT: fixed""><tr><td width=100% align=center height=18 background='IMAGES/menu-d.gif'>暫無</td></tr></table>"
end if
rs3.close
set rs3=nothing
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="6"> </td>
<td background="IMAGES/menu-l.gif">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25" background="IMAGES/menu-l-m.gif"> <font class=m_tittle> </font>欄目導(dǎo)航 <a href="./" class="daohang">網(wǎng)站首頁</a>>><a href=type.asp?typeid=<%=typeid%> class="daohang"><%=typename%></a>
<% Response.Write ">>" & BigClassName & "" %>
</td>
</tr>
<tr>
<td background="IMAGES/menu-l.gif">
</td>
</tr>
<tr>
<td height="25" background="IMAGES/menu-l-zj.gif"> <font class=body> 無小類文章區(qū)</font></td>
</tr>
<tr>
<!--無小類文章區(qū)開始-->
<% select case bigclasszs%>
<% case 1 %>
<!--圖片模版-->
<table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5">
<%set rsnosmall=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies(Forcast_SN)("key")="super" or Request.cookies(Forcast_SN)("key")="typemaster" or Request.cookies(Forcast_SN)("key")="bigmaster" or Request.cookies(Forcast_SN)("key")="smallmaster" or Request.cookies(Forcast_SN)("key")="check" then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1) order by newsid DESC"
end if
if Request.cookies(Forcast_SN)("key")="" then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(Forcast_SN)("key")="selfreg" then
if Request.cookies(Forcast_SN)("reglevel")=3 then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(Forcast_SN)("reglevel")=2 then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(Forcast_SN)("reglevel")=1 then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -