type.asp

ASP+SQL2000+

                <td height="52" valign=top> 
                  <%if mode<>4 then%>
                  <%
  if rseof=1 then
for i=1 to RecordCount
BigClassID=ArrayBigClassID(i)
BigClassName=ArrayBigClassName(i)
BigClassview=ArrayBigClassview(i)
if ArrayBigClassView(i)=1 then 
%>
                  <table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5">
                    <tr> 
                      <td height="25" background="IMAGES/menu-l-zj.gif">&nbsp;<img src=images/ico.gif>&nbsp;<font class=m_tittle><%=BigClassName%></font></td>
                    </tr>
                    <%set rs3=server.CreateObject("ADODB.RecordSet")
  if uselevel=1 then
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel=0) order by newsid DESC"
end if
if Request.cookies("key")="selfreg" then
	if Request.cookies("reglevel")=3 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
	end if
end if
else
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
while not rs3.EOF
if showyear=1 then
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>(" & year(rs3("UpdateTime"))  &"年"& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
else
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>("& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
end if
if rs3("picnews")=1 then
img="<img src='IMAGES/IMG.gif' border='0'>"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                    <tr> 
                      <td> <div align="center"> 
                          <table width="98%" border="0" cellpadding="0" cellspacing="0">
                            <tr> 
                              <td width="65%">&nbsp;&nbsp;<img src="IMAGES/006.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"> 
                                <%if mode="2" then%>
                                <%=img%> 
                                <%end if%>
                                <<%=rs3("titletype")%>><font color="<%=rs3("titlecolor")%>"> 
                                <%if showtime="1" then%>
                                <%if len(title)>24 then%>
                                <%=left(title,24)%> 
                                <%else%>
                                <%=title%> 
                                <%end if%>
                                <%else%>
                                <%if len(title)>24 then%>
                                <%=left(title,24)%> 
                                <%else%>
                                <%=title%> 
                                <%end if%>
                                <%end if%>
                                </font></<%=rs3("titletype")%>></a> </td>
                              <td width="7%" align="right"> 
                                <%if showauthor="1" then%>
                                <%=rs3("Author")%> 
                                <%end if%>
                              </td>
                              <td width="15%" align="left"> 
                                <%if showtime="1" then%>
                                <%=datetime%> 
                                <%end if%>
                                &nbsp;</td>
                              <td width="5%" align="center"> 
                                <%if showclick="1" then%>
                                <font color=#666666><%=rs3("click")%></font> 
                                <%end if%>
                              </td>
                              <td width="8%" align="left"> 
                                <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                                <img src="images/new.gif"> 
                                <%end if%>
                                <%if rs3("goodnews")="1" then%>
                                <img src="images/g.gif" > 
                                <%end if%>
                              </td>
                            </tr>
                          </table>
                        </div></td>
                    </tr>
                    <%

rs3.MoveNext
wend
%>
                    <tr> 
                      <td width=100% height="19" align=right><a class=class href='BigClass.asp?typeid=<%=typeid%>&BigClassid=<%=BigClassid%>'><img src="images/more.gif" border="0" alt="更多<%=BigClassName%>"></a>&nbsp;&nbsp;</td>
                    </tr>
                  </table>
                  <%
end if
next
'rs3.close
'set rs3=nothing
else 
Response.Write "<table width=98% border=0 height=25><tr><td>暂无大类</td></tr></table>"
end if
%>
                  <%else%>
                  <%
  if rseof=1 then
for i=1 to RecordCount
BigClassID=ArrayBigClassID(i)
BigClassName=ArrayBigClassName(i)
BigClassview=ArrayBigClassview(i)
if ArrayBigClassView(i)=1 then 
%>
                  <table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5">
                    <tr> 
                      <td height="25" background="IMAGES/menu-l-zj.gif">&nbsp;<img src=images/ico.gif>&nbsp;<font class=m_tittle><%=BigClassName%></font></td>
                    </tr>
                    <%
set rs3=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel=0) order by newsid DESC"
end if
if Request.cookies("key")="selfreg" then
	if Request.cookies("reglevel")=3 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
	end if
end if
else
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
while not rs3.EOF
if showyear=1 then
newsurl="soft.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>(" & year(rs3("UpdateTime"))  &"年"& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
else
newsurl="soft.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>("& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
end if
if rs3("picnews")=1 then
img="<img src=""IMAGES/IMG.gif"">"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                    <tr> 
                      <td height=18>&nbsp;&nbsp;<img src="IMAGES/006.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"> 
                        <%if mode="2" then%>
                        <%=img%> 
                        <%end if%>
                        <font color="<%=rs3("titlecolor")%>"> 
                        <%if len(title)>60 then%>
                        <%=left(title,60)%>... 
                        <%else%>
                        <%=title%> 
                        <%end if%>
                        </font></a><br> &nbsp;&nbsp;&nbsp;&nbsp;简介： 
                        <%if len(rs3("content"))>250 then%>
                        <%=left(rs3("content"),250)%>... 
                        <%else%>
                        <%=trim(rs3("content"))%> 
                        <%end if%>
                        <%if showtime="1" then%>
                        <%=datetime%> 
                        <%end if%>
                        <%if showclick="1" then%>
                        <font color=#666666>[<%=rs3("click")%>]</font> 
                        <%end if%>
                        <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                        <img src="images/new.gif"> 
                        <%end if%>
                        <%if rs3("goodnews")="1" then%>
                        <img src="images/g.gif" > 
                        <%end if%>
                      </td>
                    </tr>
                    <%

rs3.MoveNext
wend
%>
                    <tr> 
                      <td width=100% align=right height=18><a class=class href='BigClass.asp?typeid=<%=typeid%>&BigClassid=<%=BigClassid%>'><img src="images/more.gif" border="0" alt="更多<%=BigClassName%>"></a>&nbsp;&nbsp;</td>
                    </tr>
                  </table>
                  <%
end if
next
'rs3.close
'set rs3=nothing
else 
Response.Write "<table width=98% border=0 height=25><tr><td>暂无大类</td></tr></table>"
end if
%>
                  <%end if%>
                  <%if mode=2 then%>
                  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber5">
                    <tr> 
                      <td height="25" background="IMAGES/menu-l-zj.gif">&nbsp;<img src=images/ico.gif> 
                        <font color="#000000" class=m_tittle>本月最新</font></td>
                    </tr>
                    <%  dim ii
	ii = 0
	if uselevel=1 then
if Request.cookies("key")="" then
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel=0 order by click DESC,newsid desc"   '选择本月
end if
if Request.cookies("key")="selfreg" then
	if Request.cookies("reglevel")=3 then
	rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=3 order by click DESC,newsid desc"   '选择本月
	end if
	if Request.cookies("reglevel")=2 then
	rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=2 order by click DESC,newsid desc"   '选择本月
	end if
	if Request.cookies("reglevel")=1 then
	rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=1 order by click DESC,newsid desc"   '选择本月
	end if
end if
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc"   '选择本月
end if
else
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc"   '选择本月
end if
rs.Open rs.Source,conn,1,1
	if rs.bof and rs.eof then 
		response.write "<td align=center>本月无更新</td>" 
	else 
	do while not rs.eof 
title=trim(rs("title"))
title=replace(title,"<br>","")
%>
                    <tr> 
                      <td height="24"> <div align="center"> 
                          <table width="98%" border="0" cellpadding="3" cellspacing="0">
                            <tr> 
                              <td>&nbsp;&nbsp;<img src="IMAGES/006.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank"> 
                                <%if mode="2" then%>
                                <%if rs("picnews")=1 then%>
                                <img src='IMAGES/IMG.gif' border='0'> 
                                <%end if%>
                                <%end if%>
                                <font color="<%=rs("titlecolor")%>"><%=gottopic(title,50)%></font></a><font color="#666666">&nbsp;</font> 
                              </td>
                              <td width="5%" align="center"><font color="#666666"><%=rs("click")%></font> 
                              </td>
                              <td width="8%" align="left"><div align="center"></div></td>
                            </tr>
                          </table>
                          <font color="#666666"> </font> </div></td>
                    </tr>
                    <%  ii = ii + 1
    if ii>50 then exit do
	rs.movenext     
	loop
	end if  
	rs.close   
	set rs=nothing
%>
                  </table>
                  <br> 
                  <%end if%>
                  <%end if%>
                </td>
              </tr>
            </table></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr valign="top">
    <td height="20" background="IMAGES/menu-d-t.gif">&nbsp;</td>
    <td height="20" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="20" background="IMAGES/menu-l-t.gif" bgcolor="#FFFFFF" class="daohang">&nbsp;</td>
  </tr>
</table>
<!--#include file=include/bottom.asp -->