list2.jsp 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <%@page import="com.ws.content.Wzbdao"%>
  4. <%@ include file="public/showcontent.jsp" %>
  5. <%@page import="com.ws.content.WzbVDao"%>
  6. <%@page import="com.ws.content.*"%>
  7. <%@ include file="public/config.jsp"%>
  8. <%@ include file="public/function.jsp"%>
  9. <%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
  10. <%
  11. String path = request.getContextPath();
  12. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  13. %>
  14. <%
  15. //文章的业务逻辑
  16. WzDao wdao = new WzDao();
  17. LmDao ldao = new LmDao();
  18. WzbVDao wzvdao = new WzbVDao();
  19. Wzbdao wdo1 = new Wzbdao();
  20. long now = System.currentTimeMillis();
  21. SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  22. //栏目编号
  23. String lmids = request.getParameter("lmid");
  24. //通过栏目编号获取栏目对象
  25. Lmb lm = ldao.getLmbByLmid(lmids);
  26. if(lm==null){
  27. lm = new Lmb();
  28. }
  29. String lmmc = lm.getLmmc();//栏目名称
  30. String flmid = lm.getFlmid();//父栏目编号
  31. if("-1".equals(lmids)){
  32. lmmc = "部门动态";
  33. }else if("-2".equals(lmids)){
  34. lmmc = "分子公司动态";
  35. }
  36. Lmb flm = ldao.getLmbByLmid(flmid);
  37. if(flm==null){
  38. flm = new Lmb();
  39. }
  40. String flmmc = flm.getLmmc();
  41. //分页开始
  42. int offset = 0; //当前页
  43. try{
  44. offset =Integer.parseInt(request.getParameter("offset"));
  45. }catch(Exception e){
  46. offset=0;
  47. }
  48. long rows_num = 0;
  49. if("-1".equals(lmids)){
  50. List<Wzb> wzblist0 = new ArrayList<Wzb>();
  51. List<Lmb> gkzllist = lmDao.getValidSubLmb("10010002");
  52. String[] zzjgIds = new String[gkzllist.size()];//各个部门ID,根据部门ID进一步查询
  53. String[] fids = new String[gkzllist.size()]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  54. if(gkzllist!=null){
  55. String[] lmmcs = new String[gkzllist.size()];
  56. for (int i =0;i<gkzllist.size();i++) {
  57. if(gkzllist.size()>i){
  58. lmmcs[i] =gkzllist.get(i).getLmmc();
  59. zzjgIds[i]=gkzllist.get(i).getLmid();//集团总部各栏目ID
  60. if(lmDao.getValidSubLmb(zzjgIds[i],"部门动态")!=null&&lmDao.getValidSubLmb(zzjgIds[i],"部门动态").size()>0){
  61. fids[i] = lmDao.getValidSubLmb(zzjgIds[i],"部门动态").get(0).getLmid();
  62. }
  63. }else{
  64. lmmcs[i]="";
  65. zzjgIds[i]="";
  66. }
  67. wzblist0 = wdo1.getAllWzbForPage2(fids, 0, 9999);
  68. }
  69. }
  70. if(wzblist0!=null){
  71. rows_num =wzblist0.size();
  72. }
  73. }else if("-2".equals(lmids)){
  74. List<Wzb> wzblist0 = new ArrayList<Wzb>();
  75. List<Lmb> list_fzgs = lmDao.getValidSubLmb("10010001");
  76. int count=0;
  77. if(list_fzgs!=null&&list_fzgs.size()>0){count = list_fzgs.size();}
  78. String[] dtids = new String[count]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  79. if(list_fzgs!=null&&list_fzgs.size()>0){
  80. List<Lmb> lms =null;
  81. for(int i =0;i<list_fzgs.size();i++){
  82. lms = lmDao.getValidSubLmb(list_fzgs.get(i).getLmid(),"分子公司动态");
  83. if(lms!=null&&lms.size()>0){
  84. dtids[i]=lms.get(0).getLmid();
  85. }}
  86. }
  87. wzblist0 = wdo1.getAllWzbForPage2(dtids, 0, 9999);
  88. if(wzblist0!=null){
  89. rows_num =wzblist0.size();
  90. }
  91. }else{
  92. rows_num = (long)wzvDao.getCountsAllWzb(lmids);//总记录数
  93. }
  94. int page_size =30; //每页记录数
  95. pgDao.setInt_num(page_size);
  96. long Current_Page = offset; //当前页
  97. pgDao.Init(Current_Page, rows_num);
  98. int l_start = (int)pgDao.getStart();
  99. int l_end = (int)pgDao.getEnd();
  100. //分页设定结束
  101. %>
  102. <head>
  103. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  104. <title>长春市城市发展投资控股(集团)有限公司</title>
  105. <link href="css/main.css" rel="stylesheet" type="text/css" />
  106. </head>
  107. <body>
  108. <table width="1200" border="0" align="center" cellpadding="0" cellspacing="0">
  109. <%@include file="top.jsp" %>
  110. <tr>
  111. <td height="5" bgcolor="#FFFFFF"></td>
  112. </tr>
  113. </table>
  114. <table width="1200" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  115. <tr>
  116. <td align="left" valign="top"><table width="1200" border="0" cellspacing="0" cellpadding="0" class="borlm">
  117. <tr>
  118. <td height="29" align="center" valign="middle" background="images/index_19.jpg"><table width="98%" border="0" cellspacing="0" cellpadding="0">
  119. <tr>
  120. <td width="32%" align="left" valign="middle" class="blue14b"><%=lmmc %></td>
  121. <td width="68%" align="right" valign="middle"><img src="images/index_tb.gif" width="11" height="11" /><a href="index.jsp" style="text-decoration:none;color: black;"> 首页</a>&gt;&gt; <a href="list2.jsp?lmid=<%=lmids %>" style="text-decoration:none;color: black;"><%=lmmc %></a></td>
  122. </tr>
  123. </table></td>
  124. </tr>
  125. <tr>
  126. <td height="930" align="center" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0" class="mt10 mb8 black14">
  127. <tr>
  128. <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  129. <%
  130. List<Wzb> wzblist = new ArrayList<Wzb>();
  131. if(("-1".equals(lmids))){
  132. //wzblist = (List)wdo1.getAllWzbForPage2(new String[]{"1002001","1002002","1002003001","1002003002"}, l_start, page_size);
  133. List<Lmb> gkzllist = lmDao.getValidSubLmb("10010002");
  134. String[] zzjgIds = new String[gkzllist.size()];//各个部门ID,根据部门ID进一步查询
  135. String[] fids = new String[gkzllist.size()]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  136. if(gkzllist!=null){
  137. String[] lmmcs = new String[gkzllist.size()];
  138. for (int i =0;i<gkzllist.size();i++) {
  139. if(gkzllist.size()>i){
  140. lmmcs[i] =gkzllist.get(i).getLmmc();
  141. zzjgIds[i]=gkzllist.get(i).getLmid();//集团总部各栏目ID
  142. if(lmDao.getValidSubLmb(zzjgIds[i],"部门动态")!=null&&lmDao.getValidSubLmb(zzjgIds[i],"部门动态").size()>0){
  143. fids[i] = lmDao.getValidSubLmb(zzjgIds[i],"部门动态").get(0).getLmid();
  144. }
  145. }else{
  146. lmmcs[i]="";
  147. zzjgIds[i]="";
  148. }
  149. wzblist = wdo1.getAllWzbForPage2(fids, l_start, page_size);
  150. }
  151. }
  152. }else if("-2".equals(lmids)){
  153. List<Lmb> list_fzgs = lmDao.getValidSubLmb("10010001");
  154. int count=0;
  155. if(list_fzgs!=null&&list_fzgs.size()>0){count = list_fzgs.size();}
  156. String[] dtids = new String[count]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  157. if(list_fzgs!=null&&list_fzgs.size()>0){
  158. List<Lmb> lms =null;
  159. for(int i =0;i<list_fzgs.size();i++){
  160. lms = lmDao.getValidSubLmb(list_fzgs.get(i).getLmid(),"分子公司动态");
  161. if(lms!=null&&lms.size()>0){
  162. dtids[i]=lms.get(0).getLmid();
  163. }}
  164. }
  165. wzblist =(List)wdo1.getAllWzbForPage2(dtids, l_start, page_size);
  166. }else{
  167. wzblist =(List)wdo1.getAllWzbForPage(lmids, l_start, page_size);
  168. }
  169. if(wzblist != null){
  170. for(Wzb wzb:wzblist)
  171. {
  172. String wzbt = wzb.getWzbt();
  173. String time = wzb.getTjsj();
  174. String xwlx = wzb.getJtymc();
  175. long fb_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(time).getTime();
  176. if(wzbt.length() > 67)
  177. {
  178. wzbt=wzbt.substring(0,67)+"...";
  179. }
  180. %>
  181. <tr>
  182. <td width="3%" align="left" valign="middle" class="red14"> <%if(now - fb_time<432000000){ %>
  183. <%} %></td>
  184. <td width="90%" height="30" align="left" valign="middle"><a target="_blank" href="news.jsp?wzid=<%=wzb.getWzid()%>&&lmid=<%=lmids%>&&target=list2 ">
  185. <%=wzbt %> <%if("sp".equals(xwlx)){ %>
  186. <img src="images/index_35.jpg" width="16" height="12" />
  187. <%}else if("tp".equals(xwlx)){ %>
  188. <img src="images/index_31.jpg" width="16" height="12" />
  189. <%} %>
  190. </a></td>
  191. <td width="7%" align="left" valign="middle"><%=wzb.getTjsj().substring(0,10) %></td>
  192. </tr>
  193. <%
  194. }
  195. }
  196. %>
  197. </table>
  198. <!-- 分页显示 -->
  199. <script type="text/javascript">
  200. function page(cpage)
  201. {
  202. pageform.offset.value=cpage;
  203. pageform.submit();
  204. }
  205. </script>
  206. <form name="pageform" method="post" action="list2.jsp">
  207. <input type="hidden" name="offset" value="<%=offset %>">
  208. <input type="hidden" name="lmid" value="<%=lmids %>">
  209. <table cellspacing="0" align="center">
  210. <tbody>
  211. <tr height="30">
  212. <td>
  213. &nbsp;&nbsp;&nbsp;&nbsp;
  214. <span class="web">共</span><span class="red"><%=pgDao.getTotalpage()%></span><span class="web">页(</span>
  215. <span class="red"><%=pgDao.getCurpage()+1%></span><span class="web">/</span><span class="red"><%=pgDao.getTotalpage()%></span><span class="web">)
  216. &nbsp;&nbsp;&nbsp;&nbsp;
  217. 共</span><span class="red"><%=pgDao.getTotalnum()%></span><span class="web">条记录
  218. &nbsp;&nbsp;&nbsp;&nbsp;
  219. 本页显示第</span><span class="red"><%=l_start+1 %></span><span class="web">
  220. 条到第</span><span class="red"><%=l_end %></span><span class="web">条</span>
  221. <span class="web"><a href="javascript:page('0')" class="red" >首页</a></span>
  222. <span class="web"><a href="javascript:page('<%=pgDao.getPrepage()%>')" class="red">上页</a></span>
  223. <span class="web"><a href="javascript:page('<%=pgDao.getNextpage()%>')" class="red">下页</a></span>
  224. <span class="web"><a href="javascript:page('<%=pgDao.getTotalpage()-1%>')" class="red">尾页</a></span>
  225. <span class="web">转到第 <input type=text name=Query_Page size=3> 页</span>
  226. <span class="web"><input type="BUTTON" value="查看" class="BUTTON" style="cursor:hand" onClick="return page(Query_Page.value-1)"></span>
  227. </td>
  228. </tr>
  229. </tbody>
  230. </table>
  231. </form>
  232. <!-- 右侧页 -->
  233. </td>
  234. </tr>
  235. </table></td>
  236. </tr>
  237. </table></td>
  238. </tr>
  239. </table>
  240. <%@include file="Bottom.jsp" %>
  241. </body>
  242. </html>