⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 news.asp

📁 北方供求 V3.3 Sql 版 §V3.3更新功能 1、首页(自动生成静态
💻 ASP
字号:
<!--#include file="Common/Inc_DatConn.asp"-->
<!--#include file="Common/Inc_Config.asp"-->
<!--#include file="Common/Inc_Function.asp"-->
<%
'┌─  风云ASP在线  ────────────────────────┐
'│                                                                 │
'│  作者:赵振波.	http://www.fyasp.com	    				    │
'│                                                                 │
'│   Q Q:176189168  										   	    │
'│                                                                 │
'│ Email:fy96@163.com                                             │
'│                                                                 │
'│ 程序定做,系统开发,网站制作,提供高质量的网络产品、技术和服务!│
'│                                                                 │
'│【版权声明】                                                     │
'│                                                                 │
'│     本程序版权归坐看风云所有,未经授权擅自修改、复制或散布本程序│
'│                                                                 │
'│的部分或全部,将承受严厉的民事和刑事处罚,对已知的违反者将给予法 │
'│                                                                 │
'│律范围内的全面制裁。对非法使用此程序所造成的一切后果本人概不负责!│
'│                                                                 │
'└───────────────────  http://www.fyasp.com ──┘
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<title>行业动态-<% =strSiteName%></title>
<LINK href="hy/img/STYLE.css" type=text/css rel=stylesheet>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta content="分类,供求信息,北方供求,整站出售,免费源码,交友, 征友, 风云在线, 约会, 聊天, 征婚, 婚介, 爱情, 友情, 友谊, 朋友, 伙伴, 情人, 伴侣, 同性, 异性, 女人, 男士, 女士, 男孩, 女孩, 帅哥, 美女, 单身, 独身, 性感, 浪漫, 激情, 手机交友, 手机, 短信, 彩信, 铃声, 图片, 照片, 靓照, 贴图, 语音, 视频, 搜索, 文章, 商城" name="keywords">
<link href="Common/Style.css" type="text/css" rel="stylesheet">
</head>
<body leftMargin="0" topMargin="0" marginheight="0" marginwidth="0">
<!--#include file="Top.asp"-->
<div align="center">
<table cellSpacing="0" cellPadding="0" width="760" border="0">
	<tr vAlign="top">
		<td width="170" bgcolor="#F3F5F5">
		<!--#include file="left.asp"-->
		</td>
		<td>
		<table cellSpacing="0" cellPadding="0" border="0">
			<tr>
				<td>
				<img height="39" src="images/jiansuo.gif.gif" width="587"></td>
			</tr>
			<tr>
				<td background="images/lhtbg.gif.gif">
				<table cellSpacing="0" cellPadding="0" width="550" align="center" border="0">
					<tr>
							<td><!--#include file="Common/Inc_Searchnews.asp"--></td>
						</tr>
						<tr>
							<td height="6"></td>
						</tr>
				</table>
				</td>
			</tr>
			<tr>
				<td bgColor="#85bdef" height="1"></td>
			</tr>
		</table>
		<table height="3" cellSpacing="0" cellPadding="0" width="132" border="0">
			<tr>
				<td></td>
			</tr>
		</table>
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
			<tr vAlign="top">
				<td>
				<table cellSpacing="0" cellPadding="0" border="0">
					<tr>
						<td width="587" height="32" background="images/vxinxi.gif" align="center">
<b>行业动态</b></td>
					</tr>
				</table>
				<table cellSpacing="1" cellPadding="0" width="586" bgColor="#a8d70c" border="0">
					<tr>
						<td bgColor="#ffffff">
<table cellSpacing="0" cellPadding="0" width="100%" bordercolordark="#FFFFFF" borderColorLight="#3986CE" border="0">
            <tbody>
              <tr>
<table width="100%" height="22" border="0" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td height="23" valign="top"> 
                      <table width="100%" height="20" border="0" cellpadding="4" cellspacing="1" bgcolor="#FFFFFF">
<tr> 
                          <td width="70%" height="20"><font color="#3986CE">信息主题</font></td>
                          <td width="21%" align="center"><font color="#3986CE">
							发布时间</font></td>
                          <td width="9%" align="center"><font color="#3986CE">浏览</font></td>
                        </tr>                        <tr>
						  <td width="100%" colspan="3" height="1" background="images/dotline.gif"></td>
						</tr><%
Dim rdsNews
Dim sqlNews
Dim rdsTotalRec
Dim intPage       '/当前页/
Dim intTotalRec	  '/所有记录/
Dim intNewsCount
Dim n,p,ii	      '/定义一些临时变量/

intPage = Trim(Request("Page"))
if intPage = "" then
	intPage = 1
else
	intPage = Clng(intPage)
end if
                      
set rdsNews = Server.CreateObject("ADODB.Recordset")
set rdsTotalRec = Conn.Execute("Select Count(NewsKey) From Dat_News Where NewsClass = 2 And State = 1")
intTotalRec = rdsTotalRec(0)
sqlNews = "Select * From Dat_News Where NewsClass = 2 And State = 1 Order By NewsKey Desc"
rdsNews.Open sqlNews,Conn,1,1
if not rdsNews.EOF then
	if intTotalRec mod intNewsCot = 0 then
		n = intTotalRec \ intNewsCot
	else
		n = intTotalRec \ intNewsCot + 1
	end if
	rdsNews.MoveFirst
	if intPage > n then intPage = n
	if intPage < 1 then intPage = 1
	rdsNews.Move (intPage - 1) * intNewsCot
	do while not rdsNews.EOF and intNewsCount < Clng(intNewsCot)
		intNewsCount = intNewsCount + 1
%>
                       <tr> 
                          <td width="70%" height="20" class="F16">&nbsp;<img border="0" src="images/arrow_01.gif">&nbsp;<a href="View_News.asp?Id=<% = rdsNews("NewsKey")%>" target="_blank" class="a01"><% = rdsNews("Topic")%></a></td>
                          <td width="21%" align="center"><% = FormatTime(rdsNews("CreateTime"),5)%></td>
                          <td width="9%" align="center"><% = rdsNews("Hits")%></td>
                        </tr>
                        <tr>
						  <td width="100%" colspan="3" height="1" background="images/dotline.gif"></td>
						</tr>
<%
  		rdsNews.MoveNext
	loop
else
%>
						<tr>
						  <td width="100%" colspan="3" height="22">&nbsp;<font color="#FF0000">没有行业新闻信息</font>...</td>
						</tr>
<%
end if
rdsNews.Close
set rdsNews = nothing

if intPage - 1 mod 10 = 0 then
	p = (intPage - 1) \ 10
else
	p = (intPage - 1) \ 10
end if
%>
                      </table>
				    </td>
                  </tr>
                </table>
<table border="0" width="98%" cellspacing="0" cellpadding="0" align="center">
	    <form method="post" action="News.asp" name="Form2">
	    <input type="hidden" name="KeyWord" value="<% = strKeyWord%>">
	    <tr>
		  <td width="30%" height="30" valign="middle">页次:<b><%= intPage %></b>/<b><%= n %></b>页 每页<b><%= intNewsCot %></b>条 共<b><%= intTotalRec %></b>条</td>
		  <td width="70%" height="30" valign="middle"><div align="right">分页:
			<%
				if intPage = 1 then
					Response.Write "<font face=webdings>9</font>   "
				else
					Response.Write "<a href='?Page=1&KeyWord="& strKeyWord &"' title=首页><font face=webdings>9</font></a>   "
				end if
				if p * 10 > 0 then Response.Write "<a href='?Page="&Cstr(p*10)&"&KeyWord="& strKeyWord &"' title=上十页><font face=webdings>7</font></a>   "
				Response.Write "<b>"
				for ii = p * 10 + 1 to P * 10 + 10
					   if ii = intPage then
				          Response.Write "<font color=""#FF0000"">"+Cstr(ii)+"</font> "
					   else
					      Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"'>"+Cstr(ii)+"</a>   "
					   end if
					if ii = n then exit for
				next
				Response.Write "</b>"
				if ii < n then Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"' title=下十页><font face=webdings>8</font></a>   "
				if intPage=n then
					Response.Write "<font face=webdings>:</font>   "
				else
					Response.Write "<a href='?Page="&Cstr(n)&"&KeyWord="& strKeyWord &"' title=尾页><font face=webdings>:</font></a>   "
				end if
			%>
			转到:<input type="text" name="Page" size="2" maxlength="10" value="<%= intPage %>" class="face"> <input type="submit" value="Go" name="submit" class="button">
			</div></td>
		</tr>
		</form>
	  </table>
               </td>
              </tr>
            </tbody>
            </table>
</td>
					</tr>
				</table>
				<table height="6" cellSpacing="0" cellPadding="0" width="132" border="0">
					<tr>
						<td></td>
					</tr>
				</table>

				</td>
			</tr>
		</table>
		</td>
	</tr>
</table></div>
<!--开始-->
<div align="center">
	<table border="0" style="border-collapse: collapse" width="760">
		<tr>
			<td background="hy/img/2005_soft_mainbg.gif" height="7"></td>
		</tr>	</table>
</div>
<!--结束-->
<!--#include file="end.asp"-->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -