📄 adminnews_body.asp
字号:
<%sub adminnews_body()
dim totalnews,Currentpage,totalpages,i
opennews
sql="select * from news order by news_id DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<link rel="stylesheet" href="site_css.css" type="text/css">
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="3" height="8" bgcolor="#FFFFFF">
<link href="style.css" type="text/css" rel="stylesheet">
<div align="center">
<center>
<table width="760" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="760"> <table border="0" cellpadding="0" cellspacing="0" width="760">
<!-- fwtable fwsrc="ibei.png" fwbase="cn.jpg" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->
<tr>
<td><img src="../images/spacer.gif" width="40" height="1" border="0" alt="" name="undefined_3"></td>
<td><img src="../images/spacer.gif" width="240" height="1" border="0" alt="" name="undefined_3"></td>
</tr>
<tr>
<td height="165" colspan="2" align="left" valign="top" background="images/topgg.jpg" ><div id="Layer1" style="position:absolute; left:138px; top:20px; width:527px; height:162px; z-index:1">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"
width="630" height="165" align="">
<param name=movie value="images/2.swf">
<param name=quality value=high>
<param name=wmode value=transparent>
<param name=bgcolor value=#FFFFFF>
<embed src="images/2.swf" quality=high wmode=transparent bgcolor=#FFFFFF width="630" height="165" align=""
type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"></embed>
</object>
</div>
<script src="tong/mystat.asp"></script></td>
</tr>
</table></td>
</tr>
<tr>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="99%" valign="middle"><table width="100%" border=1 align=right cellpadding=1 cellspacing=1 bordercolor="#FFFFFF" bgcolor="#000000" class=table1 id="dh">
<tbody>
<tr style="FONT-SIZE: 9pt; LINE-HEIGHT: 9pt" align=middle>
<td width=12% height="25"><a href="index.asp">首页</a></td>
<td width=12%><a href="web/index.asp" >网站建设</A></td>
<td width=12%><a href="news.asp">最新新闻</a></td>
<td width=12%><a href="article.asp">网络教程</a></td>
<td width=12%><a href="download.asp">资源下载</a></td>
<td width=12%><a href="ibook/index.asp">在线留言</a></td>
<td width=12%><a href="web/about.asp">关于E-style</a></td>
<td width=12%><a href="coolsites.asp">友情连接</a></td>
</tr>
</tbody>
</table></td>
</tr>
</table></td>
</tr>
</table>
</center>
</div>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" bgcolor="#FFFFFF"></td>
</tr>
</table>
<p></td>
</tr>
<tr>
<td width="205" bgcolor="#FFFFFF" valign="top">
<%call adminmenu()%>
</td>
<td width="1" background="images/dotlinev.gif"></td>
<td width="554" bgcolor="#FFFFFF" valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="6"><table width="98%" height="24" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#C7C7C7">
<tr align="center" bgcolor="#E8E8E8">
<td width="50%" background="images/bg3.gif" class="chinese"><a href="admin_news.asp">新闻管理</a></td>
<td width="50%" class="chinese" background="images/bg3.gif"><a href="admin_news.asp?action=newnews#newnews">新增新闻</a></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="6"></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#C0C0C0" style="border-collapse: collapse">
<tr>
<td class="diaryhead" colspan="3">
<table width="100%" height="23" border="0" cellpadding="0" cellspacing="0" background="images/bg3.gif">
<tr>
<td><font color="#333333"> 新闻管理</font></td>
</tr>
</table> </td>
</tr>
<tr bgcolor="#E8E8E8" align="center">
<td class="chinese" width="10%" bgcolor="#F5F5F5">编号</td>
<td class="chinese" width="70%" bgcolor="#F5F5F5">标题&发表时间</td>
<td class="chinese" width="20%" bgcolor="#F5F5F5">操作</td>
</tr>
<%if not rs.eof then
rs.movefirst
rs.pagesize=newsperpage
if trim(request("page"))<>"" then
currentpage=clng(request("page"))
if currentpage>rs.pagecount then
currentpage=rs.pagecount
end if
else
currentpage=1
end if
totalnews=rs.recordcount
if currentpage<>1 then
if (currentpage-1)*newsperpage<totalnews then
rs.move(currentpage-1)*newsperpage
dim bookmark
bookmark=rs.bookmark
end if
end if
if (totalnews mod newsperpage)=0 then
totalpages=totalnews\newsperpage
else
totalpages=totalnews\newsperpage+1
end if
i=0
do while not rs.eof and i<newsperpage%>
<tr>
<td bgcolor="#FFFFFF" class="chinese" align="center"><%=rs("news_id")%> </td>
<td bgcolor="#FFFFFF" class="chinese"><a href="shownews.asp?news_id=<%=rs("news_id")%>" target="_blank"><%=rs("news_title")%></a> <span class="date"><%=rs("news_date")%></span> </td>
<td bgcolor="#FFFFFF" class="chinese" align="center"><a href="admin_news.asp?id=<%=rs("news_id")%>&action=editnews#editnews">edit</a>
<a href="admin_news.asp?id=<%=rs("news_id")%>&action=delnews#delnews">del</a> <a href="shownews.asp?news_id=<%=rs("news_id")%>" target="_blank">view</a></td>
</tr>
<%i=i+1
rs.movenext
loop
else
if rs.eof and rs.bof then%>
<tr align="center">
<td bgcolor="#FFFFFF" colspan="3" class="chinese">当前没有新闻！</td>
</tr>
<%end if
end if%>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<form name="form2" method="post" action="admin_news.asp">
<tr>
<td class="chinese" align="right"><%=currentpage%> /<%=totalpages%>页,<%=totalnews%>条记录/<%=newsperpage%>篇每页.
<%
i=1
showye=totalpages
if showye>10 then
showye=10
end if
for i=1 to showye
if i=currentpage then
%>
<%=i%>
<%else%>
<a href="admin_news.asp?page=<%=i%>"><%=i%></a>
<%end if
next
if totalpages>currentpage then
if request("page")="" then
page=1
else
page=request("page")+1
end if%>
<a href="admin_news.asp?page=<%=page%>" title="下一页">>></a>
<%end if%>
<input type="text" name="page" class="textarea" size="4">
<input type="submit" name="Submit" value="Go" class="button"></td>
</tr>
</form>
</table>
<br>
<%if request.QueryString("action")="newnews" then%>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="<%=MM_editAction%>">
<tr>
<td class="diaryhead"> <table width="100%" height="23" border="0" cellpadding="0" cellspacing="0" background="images/bg3.gif">
<tr>
<td><font color="#333333"><a name="newnews"> 新的新闻</a></font></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">作者-
<input type="text" name="news_author" size="20" class="textarea">
关键字-
<input type="text" name="news_keyword" size="20" class="textarea">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">来源-
<input type="text" name="news_ahome" class="textarea" size="50">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">标题-
<input type="text" name="news_title" class="textarea" size="50">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese"><%call ubbshow()%> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">
<textarea name="news_content" cols="85" rows="12" class="textarea"></textarea>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" class="chinese" height="30" align="center">
<input type="submit" name="Submit2" value="确定新增" class="button">
<input type="reset" name="Reset" value="清空重填" class="button">
</td>
</tr>
<input type="hidden" name="action" value="newnews">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if
if request.QueryString("action")="editnews" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
call diserror()
response.end
else
if not isinteger(request.querystring("id")) then
errmsg=errmsg+"<br>"+"<li>非法的新闻ID参数！"
call diserror()
response.end
end if
end if
sql="select * from news where news_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="<%=MM_editAction%>">
<tr>
<td class="diaryhead"><table width="100%" height="23" border="0" cellpadding="0" cellspacing="0" background="images/bg3.gif">
<tr>
<td><font color="#333333"><a name="editnews"> 修改新闻</a></font></td>
</tr>
</table> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">作者-
<input type="text" name="news_author" size="20" class="textarea" value="<%=rs("news_author")%>">
关键字-
<input type="text" name="news_keyword" size="20" class="textarea" value="<%=rs("news_keyword")%>">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">来源-
<input type="text" name="news_ahome" class="textarea" size="50" value="<%=rs("news_ahome")%>">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">标题-
<input type="text" name="news_title" class="textarea" size="50" value="<%=rs("news_title")%>">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">
<%call ubbshow()%> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese"> <textarea name="news_content" cols="85" rows="12" class="textarea" id="news_content"><%=rs("news_content")%></textarea>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" class="chinese" height="30" align="center">
<input type="submit" name="Submit" value="确定修改" class="button">
<input type="reset" name="Reset" value="清空重填" class="button">
[<a href="admin_news.asp">返回</a>] </td>
</tr>
<input type="hidden" name="id" value="<%=rs("news_id")%>">
<input type="hidden" name="action" value="editnews">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if
if request.QueryString("action")="delnews" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
call diserror()
response.end
else
if not isinteger(request.querystring("id")) then
errmsg=errmsg+"<br>"+"<li>非法的新闻ID参数！"
call diserror()
response.end
end if
end if
sql="select * from news where news_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="<%=MM_editAction%>">
<tr>
<td class="diaryhead"> <table width="100%" height="23" border="0" cellpadding="0" cellspacing="0" background="images/bg3.gif">
<tr>
<td><font color="#333333"><a name="delnews" id="delnews"> 删除新闻</a></font></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">作者- <%=rs("news_author")%>
关键字- <%=rs("news_keyword")%>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">来源- <%=rs("news_ahome")%>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">标题- <%=rs("news_title")%>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese"><%=ubb2html(formatStr(autourl(rs("news_content"))), true, true)%> </td>
</tr>
<tr>
<td bgcolor="#F5F5F5" class="chinese" height="30" align="center">
<input name="Submit" type="submit" class="button" id="Submit" value="确定删除">
[<a href="admin_news.asp">返回</a>] </td>
</tr>
<input type="hidden" name="id" value="<%=rs("news_id")%>">
<input type="hidden" name="action" value="delnews">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if%>
<br>
</td>
</tr>
<tr>
<td colspan="3" height="2" background="images/dotlineh.gif"></td>
</tr>
</table>
<%
rs.close
set rs=nothing
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -