www.gusucode.com > 书生图片管理Asp源码程序 > code/manage.asp
<!--#include file="articleconn.asp"--> <!--#include file="security.asp"--> <!--#include file="home1.asp"--> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>管理页</title> <script language="javascript"> if(top.frames.length == 0) { document.location = "mimi.asp"; } else { if(parent.ryan_bar) { } else { parent.location = "mimi.asp"; } } </script> <meta name="GENERATOR" content="Microsoft FrontPage 3.0"> <link rel="stylesheet" type="text/css" href="css/style.css"> <script language="javascript"> function popwin2(id,path) { window.open("openarticle.asp?id="+id+"&ppath="+path,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); } </script> </head> <% dim rs MaxPerPage=rs("duo") dim totalPut dim CurrentPage dim TotalPages dim i,j dim typename typename="" if not isempty(request("page")) then currentPage=cint(request("page")) else currentPage=1 end if dim sql dim rstype dim typesql dim typeid,typename1 if not isEmpty(request("typeid")) then typeid=request("typeid") else typeid=0 end if set rstype=server.createobject("adodb.recordset") typesql="select * from type where typeid="&typeid&"" rstype.open typesql,conn,1,1 if not rstype.eof then typename1=rstype("type") else typename1="全部文章" end if rstype.close set rst=server.CreateObject("ADODB.RecordSet") %> <body marginwidth="0" leftmargin="0" bgcolor="#FFFFFF" > <div align="center"> <center> <br> <!--#include file="home.asp" --> </center> </div> <div align="center"> <center> <table border="0" width="760" cellspacing="0" cellpadding="0"> <tr> <td width="100%" > <p align="left"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="100%" > <p align="left"> <span style="font-size:12pt;"><a href=" <%=rs("url")%> " ><font face="楷体_GB2312, 隶书, 宋体" size="4" color="#009900"><%=rs("homes")%></font></a>>><a href=" <%=rs("urls")%> " ><font face="楷体_GB2312, 隶书, 宋体" size="4" color="#009900"><%=rs("home")%></font></a>>><font color="#FF0000"><%response.write ""&typename1&""%></font></span><br> </table> <p align="left"><hr> <% rst.open "select * from type",conn,1 if rst.EOF then response.write "没有栏目:" else %> <div align="center">|<a href="manage.asp?typeid=0">全部图片</a>|<%do while NOT rst.EOF%><a href="manage.asp?typeid=<%=rst("typeid")%>"><%=rst("type")%></a>|<% rst.MoveNext loop end if rst.close %><br><a href="changepass.asp" title="修改密码名称以及增加修改删除栏目和程序高级设置"><font color=red> 高级管理页面</font></a> | <a href="addarticle.asp" title="加入新的文章"><font color=red>添加新图片</font></a> | <a href="Default.asp" title="退出管理页,进入正常页面" target="_top"> <font color=red>退出管理页面</font></a> </div> <hr> <div align="center"> </div> </td> </tr> </table> <% if typeid=0 then sql="select * from learning order by articleid desc" else sql="select * from learning where typeid="+cstr(typeid)+" order by articleid desc" end if Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 if rs.eof and rs.bof then response.write "<p align='center'> 还 没 有 任 何 图 片</p>" else totalPut=rs.recordcount totalPut=rs.recordcount if currentpage<1 then currentpage=1 end if if (currentpage-1)*MaxPerPage>totalput then if (totalPut mod MaxPerPage)=0 then currentpage= totalPut \ MaxPerPage else currentpage= totalPut \ MaxPerPage + 1 end if end if if currentPage=1 then showpage totalput,MaxPerPage,"manage.asp" showContent showpage totalput,MaxPerPage,"manage.asp" else if (currentPage-1)*MaxPerPage<totalPut then rs.move (currentPage-1)*MaxPerPage dim bookmark bookmark=rs.bookmark showpage totalput,MaxPerPage,"manage.asp" showContent showpage totalput,MaxPerPage,"manage.asp" else currentPage=1 showpage totalput,MaxPerPage,"manage.asp" showContent showpage totalput,MaxPerPage,"manage.asp" end if end if rs.close end if set rs=nothing conn.close set conn=nothing sub showContent dim i i=0 %> <div align="center"> <center> <table border="1" cellspacing="0" width="650" bordercolorlight="#000000" cellpadding="0" bordercolordark="#FFFFFF"> <tr bgcolor="#CCCCCC"> <td width="46" align="center" background="IMAGES/mmto.gif" height="20"><font color="#FFFFFF"><b><font color="#000000">ID号</font></b></font></td> <td width="400" align="center" background="IMAGES/mmto.gif"><font color="#FFFFFF"><b><font color="#000000">缩 图 列 表</font></b></font></td> <td width="50" align="center" background="IMAGES/mmto.gif"><font color="#FFFFFF"><b><font color="#000000">修改</font></b></font></td> <td width="50" align="center" background="IMAGES/mmto.gif"><font color="#FFFFFF"><b><font color="#000000">删除</font></b></font></td> </tr> <%do while not rs.eof%> <tr> <td height="23" width="46"> <p align="center"><%=rs("articleid")%> </td> <td> <table width="100%"> <tr> <td width="300"> <div align="center"><a href="javascript:popwin2(<%=rs("articleid")%>)"><% if not isnull(rs("images")) and rs("images")<> "" then response.write "<img src=" + rs("images") + " border=0 >" end if %></a></div> </td> <td width="40%" valign="bottom"> <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#FFFFCC"> <tr> <td>图片名称:<%=rs("title")%></td> </tr> <tr> <td>浏览次数:<%=rs("hits")%></td> </tr> <tr> <td>加入日期:<%=rs("dateandtime")%></td> </tr> <tr> <td><font face="Webdings" size="4" color="#FF0000">q</font> <a href="review.asp?ID=<%=rs("articleid")%>" target="_blank">图 片 点 评</a> <font color="#FF0000"><%=rs("reviewcount")%> 篇</font></td> </tr> </table> </td> </tr> </table> </td> <td width="50"> <p align="center"><a href="edit.asp?id=<%=rs("articleid")%>">修改</a> </td> <td width="50"> <p align="center"><a href="delete.asp?id=<%=rs("articleid")%>">删除</a> </td> </tr> <% i=i+1 if i>=MaxPerPage then exit do rs.movenext loop %> </table> <table width="650" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="IMAGES/bian.gif" width="650" height="13"></td> </tr> </table> </center> </div> <% end sub function showpage(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n= totalnumber \ maxperpage else n= totalnumber \ maxperpage+1 end if response.write "<form method=Post action="&filename&"?typeid="&typeid&">" if CurrentPage<2 then response.write "<font color='#000080'>首页 上一页</font> " else response.write "<a href="&filename&"?page=1&typeid="&typeid&">首页</a> " response.write "<a href="&filename&"?page="&CurrentPage-1&"&typeid="&typeid&">上一页</a> " end if if n-currentpage<1 then response.write "<font color='#000080'>下一页 尾页</font>" else response.write "<a href="&filename&"?page="&(CurrentPage+1)&"&typeid="&typeid&">" response.write "下一页</a> <a href="&filename&"?page="&n&"&typeid="&typeid&">尾页</a>" end if response.write "<font color='#000080'> 页次:</font><strong><font color=red>"&CurrentPage&"</font><font color='#000080'>/"&n&"</strong>页</font> " response.write "<font color='#000080'> 共<b>"&totalnumber&"</b>幅图片 <b>"&maxperpage&"</b>幅图片/页</font> " response.write " <font color='#000080'>转到:</font><input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">" response.write "<input class=buttonface type='submit' value='Goto' name='cndok'></span></p></form>" end function %> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr valign="top"> <td height="19"><iframe src="bar.asp" width="100%" height=35 marginwidth="0" marginheight="0" hspace="0" vspace="0" frameborder="0" scrolling="NO"></iframe> </td> </tr> </table> <p><!--#include file="homes.asp" --> </center> </div> </body> </html>