?? checknews01.asp
字號:
<!--#include file=conn.asp --><!--#include file="char.inc"-->
<!--#include file=../include/config.asp --><!--#include file="chkuser.asp" -->
<%bigclassid=request("bigclassid")
if request.cookies("KEY")="bigmaster" then
if bigclassid="" then
%>
<script language=javascript>
history.go(-1)
alert("請選擇文章大類")
</script>
<%
Response.End
end if
end if
IF not(request.cookies("KEY")="super" or request.cookies("KEY")="check" or request.cookies("KEY")="typemaster" or request.cookies("KEY")="bigmaster") THEN
response.redirect "index_face.asp"
response.end
else
usernamecookie=CheckStr(request.cookies("UserName"))
passwdcookie=replace(trim(Request.cookies("passwd")),"'","''")
KEYcookie=replace(trim(request.cookies("KEY")),"'","''")
if usernamecookie="" or passwdcookie="" then
response.redirect "login.asp"
response.end
else
'判斷用戶的合法性
set rs=server.createobject("adodb.recordset")
sql="select * from admin where username='"&usernamecookie&"'"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.redirect "login.asp"
response.end
end if
IF passwdcookie<>rs("passwd") THEN
response.redirect "login.asp"
response.end
END IF
'下面判斷用戶級別實際在有用戶級別是都應該判斷
if KEYcookie<>rs("OSKEY") then
response.redirect "index_face.asp"
response.end
end if
rs.close
set rs=nothing
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 rs4=server.createobject("adodb.recordset")
sql4="select * from type where typemaster='"&session("username")&"'"
rs4.open sql4,conn,3,3
set rs=server.CreateObject("ADODB.RecordSet")
if request.cookies("KEY")="bigmaster" then
if checkshow=1 then
rs.Source="select * from News01 where bigclassid="&bigclassid&" order by NewsID desc"
else
rs.Source="select * from News01 where checkked=0 and bigclassid="&bigclassid&" order by NewsID desc"
end if
end if
if request.cookies("KEY")="super" or request.cookies("KEY")="check" then
if checkshow=1 then
rs.Source="select * from News01 order by NewsID desc"
else
rs.Source="select * from News01 where checkked=0 order by NewsID desc"
end if
end if
if request.cookies("KEY")="typemaster" then
if checkshow=1 then
rs.Source="select * from News01 where typeid="&rs4("typeid")&" order by NewsID desc"
else
rs.Source="select * from News01 where checkked=0 and typeid="&rs4("typeid")&" order by NewsID desc"
end if
end if
rs.Open rs.Source,conn,3,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 5.0">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=site.css rel=stylesheet>
</head>
<title><%=copyright%><%=version%> <%=ver%> - 審核文章</title>
<body topmargin="0"><!--#include file=top.asp--><br>
<div align="center">
<center>
<table border="1" width="750" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="<%=border%>">
<tr>
<td width="100%" bgcolor="<%=m_top%>" height="30" align="center"><b>審核<%=Request("BigClassName")%>文章</b></td>
</tr>
<tr>
<td colspan=2 bgcolor=<%=m_top%> align=center height=25>共 <%=total%> 條，當前第 <%=Mypage%>/<%=Maxpages%>
頁，每頁 <%=MyPageSize%> 條</td>
</tr>
<tr>
<td colspan=2 bgcolor=#abb8d6 align=center height=25>
<table width="100%" border="1" cellspacing="0" cellpadding="0" height="25" bordercolor="<%=border%>" style="border-collapse: collapse">
<tr align="center" bgcolor="#FFFFFF">
<td width="7%">ID號</td>
<td width="51%">標 題</td>
<td width="16%">日 期</td>
<td width="3%">圖</td>
<td width="3%">核</td>
<td width="6%">執行</td>
<td width="6%">編輯</td>
<td width="6%">刪除</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#abb8d6">
<table border="1" cellspacing="0" width="100%" cellpadding="0" style="border-collapse: collapse" bordercolor="<%=border%>">
<%
for i=1 to rs.PageSize
if not rs.EOF then
%>
<form method="POST" target=_self action="<%if rs("checkked")="0" then%>checknews4.asp<%else%>checknews3.asp<%end if%>?newsid=<%=rs("NewsID")%>">
<tr bgcolor=ffffff>
<td width=7% align=center ><%=rs("NewsID")%> </td>
<td width=51% > <a href='../ReadNews.asp?NewsID=<%=rs("NewsID")%>' onMouseOver="window.status='查看文章“<%=trim(rs("Title"))%>”';return true;" onMouseOut="window.status='';return true;"target=_blank title="查看文章“<%=trim(rs("Title"))%>”"><%if len(rs("title"))>24 then%><%=left(rs("title"),24)%>...<%else%><%=trim(rs("title"))%><%end if%></a><%if request.cookies("KEY")="super" and session("purview")="99999" then%><font color=red>(<%=rs("editor")%>)</font><%end if%></td>
<td width=16% align=center ><%=rs("UpdateTime")%> </td>
<td width=3% align=center ><%=rs("picnews")%> </td>
<td width=3% align=center ><%=rs("checkked")%> </td>
<td width=6% align=center ><input type=hidden name=NewsID value="<%=rs("NewsID")%>">
<input type=submit value="<%if rs("checkked")="0" then%>通過<%else%>取消<%end if%>" class=button onMouseOver="window.status='按這個按鈕<%if rs("checkked")="0" then%>通過<%else%>取消<%end if%>審核文章“<%=trim(rs("Title"))%>”';return true;" onMouseOut="window.status='';return true;" title="按這個按鈕<%if rs("checkked")="0" then%>通過<%else%>取消<%end if%>審核文章“<%=trim(rs("Title"))%>”"></td>
<td width=6% align=center ><input type=button value="編輯" class=button onclick="javascript:window.open('newsedit.asp?newsid=<%=rs("newsid")%>','_self','')"></td>
<td width=6% align=center ><input type=button value="刪除" class=button onclick="javascript:window.open('newsdel.asp?newsid=<%=rs("newsid")%>','_self','')"></td>
</form>
<%
rs.MoveNext
end if
next
%>
</table>
</td>
<tr>
<td colspan=2 bgcolor=<%=m_top%> align=center height=25>共 <%=total%> 條，當前第 <%=Mypage%>/<%=Maxpages%>
頁，每頁 <%=MyPageSize%> 條
<%
url="checkNews1.asp?bigclassid="&bigclassid&"&"
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/rs.PageSize)+1
if PageNextSize >1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "<a target=_self class=black href='" & Url & "page=" & PagePrev & "' title='上" & PageShowSize & "頁'>上一翻頁</a> "
Response.write "<a target=_self class=black href='" & Url & "page=1' title='第1頁'>頁首</a> "
end if
if MyPage-1 > 0 then
Prev_Page = MyPage - 1
Response.write "<a target=_self 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 target=_self 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 target=_self target=_self 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 target=_self class=black href='" & Url & "page=" & Pagetpage & "' title='第"& Pagetpage &"頁'>頁尾</A>"
Response.write " <a target=_self class=black href='" & Url & "page=" & PageNext & "' title='下" & PageShowSize & "頁'>下一翻頁</a>"
End if
%>
</td>
</tr>
</table>
</center>
</div>
<br>
<%
else
%><meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=site.css rel=stylesheet>
<title><%=copyright%><%=version%> <%=ver%> - 審核文章</title>
<body topmargin="0"><!--#include file=top.asp-->
<p> </p>
<p> </p>
<p> </p>
<div align="center">
<center>
<table border="1" width="450" bgcolor="#000000" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="<%=border%>">
<tr>
<td colspan=2 align="center" bgcolor="ffffff">
<p> </p>
<p>沒有要審核的文章</p>
<p> </p>
</td>
</tr>
</table>
</center>
</div>
<%
End If
%>
</body>
</html>
<%rs4.close
set rs4=nothing
rs.close
set rs=nothing
conn.close
set conn=nothing
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -