📄 news.asp
字号:
<!--#include File="Conn.asp"-->
<!--#include File="Left.asp"-->
<%
'==================================新闻分类
Set Rs = Conn.Execute("Select * From NewsClass Where ShopNumberID = '"& ShopNumberID &"'")
While Not Rs.Eof
NewsClassArr = NewsClassArr & "·<a href=News.asp?C="& Rs("NumberID") &">"& Rs("Class") &"</A><br>"
Rs.MoveNext
Wend
Rs.Close
Set Rs = Nothing
Dim NewsClass
Dim NewsClassName
NewsClass = Trim(Request.QueryString("C"))
NavigationArr = "<a href=./ class=none1>首页</a> > <a href=./News.asp class=none1>新闻动态</a>"
IF Not Isnull(NewsClass) and NewsClass <> "" Then
N = len(NewsClass)/3
x = 0
For i = 1 to N
x = x + 3
Set Rs = Conn.Execute("Select * From NewsClass where NumberID = '"& Left(NewsClass,x) &"' and ShopNumberID = '"& ShopNumberID &"'")
IF Not (rs.bof and rs.bof) Then
NavigationArr = NavigationArr &" > <a href=./News.asp?N="& Left(NewsClass,x) &" class=none1>"& Rs("Class") &"</a>"
End if
Rs.Close
Next
End IF
'=======================================================
Dim NewsID
Dim NewsTitle
Dim NewsContent
Dim DateTime
NewsID = Trim(Request.QueryString("NewsID"))
IF NewsID <> "" AND Not Isnull(NewsID) Then
Set Rs = Conn.Execute("Select * From News Where ShopNumberID = '"& ShopNumberID &"' and ID = "& NewsID &"")
IF Not Rs.eof Then
NewsContent = Rs("Content")
NewsTitle = Rs("Title")
DateTime = Rs("DateTime")
NavigationArr = NavigationArr &" > "& NewsTitle &""
End IF
Rs.Close
Set Rs = Nothing
End IF
'==================================================================上一条，下一条
IF Request.QueryString("NewsID")<> "" AND Not Isnull(Request.QueryString("NewsID")) Then
C = Trim(Request.QueryString("C"))
if C <> "" and not isnull(C) then
SQLC = "Class like '"& C &"%' and "
end if
Set Rs = Conn.Execute("Select * From News where "& SQLC &" ID>"& Request.QueryString("NewsID") &" AND ShopNumberID='"& ShopNumberID &"' order by ID")
IF Not Rs.bof Then
NewsNextArr = ("<A href=News.asp?C="& C &"&NewsID="& Rs("ID") &" Class=None1>阅读上一条</a> ")
NewsNextStr = true
End IF
Rs.Close
Set Rs = Nothing
Set Rs = Conn.Execute("Select * From News where "& SQLC &" ID<"& Request.QueryString("NewsID") &" AND ShopNumberID='"& ShopNumberID &"' order by ID Desc")
IF Not Rs.bof Then
NewsNextArr = NewsNextArr & ("<A href=News.asp?C="& C &"&NewsID="& Rs("ID") &" Class=None1>阅读下一条</a>")
NewsNextStr = true
End IF
Rs.Close
Set Rs = Nothing
IF NewsNextStr <> true Then
NewsNextArr =("<a href=News.asp?C="& C &" Class=None1>返回列表</a>")
End IF
End IF
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新闻动态-<%=HTMLEncodeNO(ShopName)%>-<%=HTMLEncodeNO(ShopTitle)%>-互联之光大卖场</title>
<meta name="keywords" content="<%=HTMLEncodeNO(ShopKey)%>">
<meta name="description" content="<%=HTMLEncodeNO(ShopContent)%>">
<link href="CSS.CSS" rel="stylesheet" type="text/css"></head>
<body background="images/bg.gif" leftmargin="0" topmargin="0">
<!--#include File="Top.asp"-->
<table width="760" height="400" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="ffffff">
<tr>
<td width="224" valign="top" background="images/i_39.gif"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<%Call Login()%>
</td>
</tr>
</table>
<table width="172" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/i_58.gif" width="224" height="23"></td>
</tr>
<tr>
<td background="images/i_44.gif"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <%=NewsClassArr%></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/i_47.gif" width="224" height="6"></td>
</tr>
</table></td>
<td width="86" valign="top" background="images/i_21.gif"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/i_13.gif" width="47" height="60"></td>
</tr>
</table></td>
<td width="489" valign="top" background="images/i_27.gif">
<table width="489" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" height="41" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="bottom" background="images/i_15.gif"> <table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20"><%=NavigationArr%></td>
</tr>
</table></td>
<td width="7"><img src="images/i_16.gif" width="7" height="41"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/i_17.gif" width="489" height="3"></td> </tr>
</table>
<table width="489" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<%
IF NewsID = "" or Isnull(NewsID) Then
%>
<table width="92%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <!--#include File="News_A.asp"--> </td>
</tr>
</table>
<%
Else
%>
<table width="92%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" align="center"><font size="2"><strong><%=NewsTitle%></strong></font></td>
</tr>
<tr>
<td align="center"><%=DateTime%><br>
<%if NewsTitle <> "" Then%>
<hr width="100%" size="1" color="#cccccc" noshade>
<%enD IF%>
</td>
</tr>
<tr>
<td height="300" valign="top"><strong><%=NewsContent%></strong></td>
</tr>
<tr>
<td height="25" align="right">
<%
Response.Write(NewsNextArr)
%>
</td>
</tr>
</table>
<%End IF%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--#include File="End.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -