notice_m.jsp
上传用户:jhtang88
上传日期:2014-01-27
资源大小:28528k
文件大小:8k
源码类别:

Jsp/Servlet

开发平台:

Java

  1. <%@ page contentType="text/html;charset=gb2312"%>
  2. <%@ page import = "java.net.URLEncoder"%>
  3. <%@ page import = "com.redmoon.oa.db.PageQuery"%>
  4. <%@ page import = "com.redmoon.oa.db.Conn"%>
  5. <%@ include file="../inc/inc.jsp"%>
  6. <jsp:useBean id="fchar" scope="page" class="cn.js.fan.util.StrUtil"/>
  7. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  8. <html>
  9. <head>
  10. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  11. <title>通知管理</title>
  12. <link href="../common.css" rel="stylesheet" type="text/css">
  13. <%@ include file="../inc/nocache.jsp"%>
  14. <script language="JavaScript" type="text/JavaScript">
  15. <!--
  16. function MM_preloadImages() { //v3.0
  17.   var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
  18.     var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
  19.     if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
  20. }
  21. //-->
  22. </script>
  23. <script language=javascript>
  24. <!--
  25. function openWin(url,width,height)
  26. {
  27.   var newwin=window.open(url,"_blank","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,top=50,left=120,width="+width+",height="+height);
  28. }
  29. //-->
  30. </script>
  31. </head>
  32. <body background="" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
  33. <jsp:useBean id="privilege" scope="page" class="com.redmoon.oa.pvg.Privilege"/>
  34. <jsp:setProperty name="privilege" property="defaulturl" value="../index.jsp"/>
  35. <!--重定向至 :<jsp:getProperty name="privilege" property="defaulturl"   />-->
  36. <%
  37. String priv="admin";
  38. String priv1="notice_public";
  39. boolean isadmin = false, isdepartment = false;
  40. isadmin = privilege.isUserPrivValid(request,priv);
  41. isdepartment = privilege.isUserDepartmentPrivValid(request,priv1);
  42. if (!isadmin && !isdepartment)
  43. {
  44. out.println(cn.js.fan.web.SkinUtil.makeErrMsg(request, cn.js.fan.web.SkinUtil.LoadString(request, "pvg_invalid")));
  45. return;
  46. }
  47. %>
  48. <table width="494" border="0" align="center" cellpadding="0" cellspacing="0">
  49.   <tr> 
  50.     <td height="23" valign="bottom" background="../images/tab-b-top.gif">     <span class="right-title">公 共 通 
  51.       知 管 理</span></td>
  52.   </tr>
  53.   <tr> 
  54.     <td valign="top" background="../images/tab-b-back.gif">
  55.         <%
  56. PageQuery pagebean = new PageQuery("ttoa");
  57. String sql;
  58. String myname = privilege.getUser(request);
  59. String department_id = privilege.getDepartmentID(request);
  60. if (isadmin)
  61. sql = "select id,title,mydate from notice order by mydate desc";
  62. else
  63. sql = "select id,title,mydate from notice where department_id="+department_id+" order by mydate desc";
  64. int pagesize = 10;
  65. pagebean.setPageSize(pagesize);
  66. String Query = fchar.getNullString(request.getParameter("Query"));
  67. if (!Query.equals(""))
  68. sql = Query;
  69. ResultSet rs=pagebean.myQuery(sql,request) ; 
  70. pagebean.PageLegend(response);
  71. int curpage,totalpages;
  72. curpage = pagebean.getCurrentPages();
  73. totalpages = pagebean.getTotalPages();
  74. if (totalpages==0)
  75. {
  76. curpage = 1;
  77. totalpages = 1;
  78. }
  79. int i = 0;
  80. String id="",title="",mydate="";
  81. try
  82. {
  83.   if (rs!=null )
  84.   {
  85.     if (pagebean.getTotalPages()>0)
  86. {
  87. %>
  88. <br>
  89.       <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
  90.         <tr> 
  91.           <td width="47"><img src="../images/title1-l.gif" width="47" height="25"></td>
  92.           <td valign="top" background="../images/title1-back.gif"><div align="center" class="title1">找到符合条件的记录 
  93.               <b><%=pagebean.getTotal() %></b> 条 每页显示 <b><%=pagebean.getPageSize() %></b> 
  94.               条 页次 <b><%=curpage %>/<%=totalpages %></b></div></td>
  95.           <td width="47"><img src="../images/title1-r.gif" width="47" height="25"></td>
  96.         </tr>
  97.       </table>
  98.       <br>
  99.       <table width="98%" border="0" align="center" cellpadding="2" cellspacing="1">
  100.         <tr bgcolor="#EFEFEF"> 
  101.           <td> <div align="center">标题</div></td>
  102.           <td width="28%">日期</td>
  103.           <td width="15%">删除</td>
  104.         </tr>
  105.       </table>
  106.       <%
  107. do
  108. {
  109. i++;
  110. id = rs.getString("id");
  111. title = rs.getString("title");
  112. mydate = rs.getString("mydate").substring(0,10);
  113. %>
  114.       <table width="98%" border="0" align="center" cellpadding="2" cellspacing="0" class="line-st-1">
  115.         <tr> 
  116.           <td> &nbsp;<a href=notice_show.jsp?id=<%=id%>><%=title%></a></td>
  117.           <td width="28%"><%=mydate.substring(0,10)%></td>
  118.           <td width="15%"><a href="notice_del.jsp?id=<%=id%>">删除</a></td>
  119.         </tr>
  120.       </table>
  121.       <%
  122. }
  123. while(i<pagesize && rs.next());
  124. }
  125. else
  126. out.println(fchar.p_center("暂无通知!"));
  127.   }
  128.   else
  129. out.println(fchar.p_center("暂无通知!"));
  130.   
  131. }
  132. catch(SQLException e)
  133. {
  134.   out.print("出错: ");
  135.   out.print(e);
  136.   out.print(e.getMessage());
  137. }
  138. if (rs!=null)
  139. {
  140. rs.close();
  141. rs = null;
  142. }
  143. pagebean.clear();
  144. %>
  145.       <table width="98%" border="0" cellspacing="1" cellpadding="3" align="center" class="9black">
  146.         <tr> 
  147.           <td width="100%" height="23"> 
  148.             <div align="right"> 
  149.               <%
  150.   String querystr = "";
  151.   %>
  152.               <%if(!pagebean.getFirstPage().equals("none")) {%>
  153.               <a href="address.jsp?<%=pagebean.getFirstPage()+querystr%>"><img src="../images/first.gif" width="41" height="12" border="0"></a> 
  154.               <% }
  155.     if(!pagebean.getPrevPage().equals("none")){
  156.      %>
  157.               &nbsp;<a href="address.jsp?<%=pagebean.getPrevPage()+querystr%>"><img src="../images/forward.gif" width="47" height="12" border="0"></a> 
  158.               <% } 
  159.     
  160.   if(!pagebean.getNextPage().equals("none")){%>
  161.               &nbsp;<a href="address.jsp?<%=pagebean.getNextPage()+querystr%>"><img src="../images/next.gif" width="47" height="12" border="0"></a> 
  162.               <% }
  163.                   if(!pagebean.getLastPage().equals("none")){   %>
  164.               &nbsp;<a href="address.jsp?<%=pagebean.getLastPage()+querystr%>"><img src="../images/last.gif" width="41" height="12" border="0"></a> 
  165.               <% }%>
  166.               &nbsp;</div></td>
  167.         </tr>
  168.       </table>
  169.       <br> 
  170.       <table width="95%" border="0" align="center" cellpadding="2" cellspacing="0" class="p9">
  171.         <tr> 
  172.           <td width="11%" height="21" align="center" bgcolor="#C4DAFF" class="stable">&nbsp;</td>
  173.           <td height="21" colspan="2" bgcolor="#C4DAFF" class="stable">撰写通知</td>
  174.         </tr>
  175.         <form name="form1" enctype="MULTIPART/FORM-DATA" action="notice_add_do.jsp" method="post" onSubmit="">
  176.           <tr> 
  177.             <td height="19" align="center" bgcolor="#EEEEEE" class="stable">标&nbsp;&nbsp;题</td>
  178.             <td height="19" colspan="2" class="stable"> <input name=title class="singleboarder" size=45> 
  179.             </td>
  180.           </tr>
  181.           <tr> 
  182.             <td height="20" align="center" bgcolor="#EEEEEE" class="stable">附&nbsp;&nbsp;件</td>
  183.             <td height="20" colspan="2" class="stable"> <p> 
  184.                 <input name=filename type=file class="singleboarder" id="filename">
  185.                 选择要上载的文件</p></td>
  186.           </tr>
  187.           <tr> 
  188.             <td width="11%" height="17" align="center" bgcolor="#EEEEEE" class="stable">内&nbsp;&nbsp;容</td>
  189.             <td height="17" colspan="2" class="stable"> <textarea name=content cols="60" class="singleboarder" rows="15"></textarea> 
  190.             </td>
  191.           </tr>
  192.           <tr> 
  193.             <td colspan="3" align="center">&nbsp; </td>
  194.           </tr>
  195.           <tr> 
  196.             <td align="center">&nbsp; </td>
  197.             <td width="40%"> <input name="submit" type=submit class="singleboarder" value="发送">
  198.               &nbsp;&nbsp;&nbsp; </td>
  199.             <td width="49%"><input name="reset" type=reset class="singleboarder" value="取消"></td>
  200.           </tr>
  201.           <tr> 
  202.             <td colspan="3" align="center">&nbsp;</td>
  203.           </tr>
  204.         </form>
  205.       </table></td>
  206.   </tr>
  207.   <tr> 
  208.     <td height="9"><img src="../images/tab-b-bot.gif" width="494" height="9"></td>
  209.   </tr>
  210. </table>
  211. </body>
  212. </html>