📄 modifynews1.asp

📁 综合信息管理系统
💻 ASP
字号:
<!--#include file=conn.asp -->
<%
IF not(Session("KEY")="super" or Session("KEY")="input" or Session("KEY")="check") THEN
response.redirect "login.asp"
response.end
END IF

if session("KEY")<>"super" then
if  Request("BigClassName") ="" then
response.redirect "ModifyNews0.asp"
response.end
end if
end if

PageShowSize = 10            '每页显示多少个页
MyPageSize   = 16           '每页显示多少条文章
	
If Not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Or Request("page") <=0 Then
MyPage=1
Else
MyPage=Int(Abs(Request("page")))
End if

set rs=server.CreateObject("ADODB.RecordSet")
if session("KEY")="super" then
rs.Source="select * from News order by NewsID desc"
else
rs.Source="select * from News where BigClassName='" & Request("BigClassName") & "' order by NewsID desc"
end if
rs.Open rs.Source,conn,1,1

If Not rs.eof then
rs.PageSize     = MyPageSize
MaxPages         = rs.PageCount
rs.absolutepage = MyPage
total            = rs.RecordCount

%>

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=style.css rel=stylesheet>
</head>

<body>
<br>
<table border="0" width="90%" align=center bgcolor="#000000" cellspacing="1" cellpadding="0">
<tr>
    <td width="100%" bgcolor="#abb8d6" height="55" align="center"><b>修改<%=Request("BigClassName")%>类文章</b></td>
</tr>
<tr>
<form method="POST" action="ModifyNews2.asp">
      <td width="100%" height="60" align="center" bgcolor="#FFFFFF"><b>直接输入文章ID：</b> 
        <input type="text" name="NewsID" size="20">
<input type="submit" value="下一步>>" class=button>
</td>
</form>
</tr>
<tr>
    <td colspan=2 bgcolor=#abb8d6 align=center height=25>共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%> 
            页，每页 <%=MyPageSize%> 条</td>
</tr>
<tr>
<td colspan=2 bgcolor=#abb8d6 align=center height=25>
<table width="100%" border="0" cellspacing="1" cellpadding="0" height="25">
<tr align="center" bgcolor="#FFFFFF">
<td width="6%">ID号</td>
<td width="55%">标 &nbsp;&nbsp;&nbsp;题</td>
<td width="22%">日&nbsp;&nbsp;&nbsp;期</td>
<td width="3%">图</td>
<td width="3%">热</td>		
<td width="5%">编码</td>
<td width="6%">执行</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#abb8d6">
<table border="0" cellspacing="1" width="100%" cellpadding="0">
<%
for i=1 to rs.PageSize
if not rs.EOF then
TrString="<form method=""POST"" action=""ModifyNews2.asp""><input type=hidden name=NewsID value=" & rs("NewsID") & ">"

if rs("editor")=session("username") or session("key")="super" or Session("KEY")="check" then
			
TrString=TrString & "<tr bgcolor=ffffff><td width=6% align=center >" & rs("NewsID") & "</td>"
TrString=TrString & "<td width=55% >&nbsp;<a  href='../ReadNews.asp?NewsID=" & rs("NewsID") & "&BigClassName="& rs("BigClassName") &"&SmallClassName=" & rs("SmallClassName") & "&SpecialID=" & rs("SpecialId") & "' target=_blank>"& trim(rs("Title")) & "</a></td>"
TrString=TrString & "<td width=22% align=center >" & rs("UpdateTime") & "</td>"
TrString=TrString & "<td width=3% align=center >" & rs("image") &"</td>"
TrString=TrString & "<td width=3% align=center >" & rs("hot") &"</td>"
TrString=TrString & "<td width=5% align=center >" & trim(rs("EnCode")) &"</td>"			
			
TrString=TrString & "<td width=6% align=center ><input type=submit value=""修改"" class=button></td>"
TrString=TrString & "</form>"
Response.Write TrString
end if
rs.MoveNext
end if
next
%>

</table>
</td>
<tr>
    <td colspan=2 bgcolor=#abb8d6 align=center height=25>共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%> 
            页，每页 <%=MyPageSize%> 条 
            <%
if session("KEY")="super" then			
url="ModifyNews1.asp?" 
else
url="ModifyNews1.asp?BigClassName=" & Request("BigClassName") & "&"
end if									
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/rs.PageSize)+1

if PageNextSize >1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "<a class=black href='" & Url & "page=" & PagePrev & "' title='上" & PageShowSize & "页'>上一翻页</a> "
Response.write "<a class=black href='" & Url & "page=1' title='第1页'>页首</a> "
end if
if MyPage-1 > 0 then
Prev_Page = MyPage - 1
Response.write "<a class=black href='" & Url & "page=" & Prev_Page & "' title='第" & Prev_Page & "页'>上一页</a> "
end if

if Maxpages>=PageNextSize*PageShowSize then
PageSizeShow = PageShowSize
Else
PageSizeShow = Maxpages-PageShowSize*(PageNextSize-1)
End if
If PageSizeShow < 1 Then PageSizeShow = 1
for PageCounterSize=1 to PageSizeShow
PageLink = (PageCounterSize+PageNextSize*PageShowSize)-PageShowSize
if PageLink <> MyPage Then
Response.write "<a class=black href='" & Url & "page=" & PageLink & "'>[" & PageLink & "]</a> "
else
Response.Write "<B>["& PageLink &"]</B> "
end if
If PageLink = MaxPages Then Exit for
Next

if Mypage+1 <=Pagetpage  then
Next_Page = MyPage + 1
Response.write "<a class=black href='" & Url & "page=" & Next_Page & "' title='第" & Next_Page & "页'>下一页</A>"
end if

if MaxPages > PageShowSize*PageNextSize then
PageNext = PageShowSize * PageNextSize + 1
Response.write " <A class=black href='" & Url & "page=" & Pagetpage & "' title='第"& Pagetpage &"页'>页尾</A>"
Response.write " <a class=black href='" & Url & "page=" & PageNext & "' title='下" & PageShowSize & "页'>下一翻页</a>"
End if
%>
</td>
  </tr>
</table>
<br>
<%
else
%>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<table border="0" width="450" align=center bgcolor="#000000" cellpadding="0" cellspacing="1">
  <tr> 
    <td colspan=2 align="center" bgcolor="ffffff"> 
      <p>&nbsp;</p>
      <p>没有内容可选</p>
      <p>&nbsp;</p>
    </td>
  </tr>
</table>
<%				
End If
%>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing

%>
⌨️ 快捷键说明

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