list2.jsp 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279
  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_parents = lmDao.getValidSubLmb("10010001");
  76. String [] parentIds = new String[list_fzgs_parents.size()];
  77. for(int i=0;i<list_fzgs_parents.size();i++){
  78. parentIds[i] = list_fzgs_parents.get(i).getLmid();
  79. }
  80. List<Lmb> list_fzgs = lmDao.getValidSubLmb(parentIds);
  81. // List<Lmb> list_fzgs = lmDao.getValidSubLmb("10010001");
  82. int count=0;
  83. if(list_fzgs!=null&&list_fzgs.size()>0){count = list_fzgs.size();}
  84. String[] dtids = new String[count]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  85. if(list_fzgs!=null&&list_fzgs.size()>0){
  86. List<Lmb> lms =null;
  87. for(int i =0;i<list_fzgs.size();i++){
  88. lms = lmDao.getValidSubLmb(list_fzgs.get(i).getLmid(),"分子公司动态");
  89. if(lms!=null&&lms.size()>0){
  90. dtids[i]=lms.get(0).getLmid();
  91. }}
  92. }
  93. wzblist0 = wdo1.getAllWzbForPage2(dtids, 0, 9999);
  94. if(wzblist0!=null){
  95. rows_num =wzblist0.size();
  96. }
  97. }else{
  98. rows_num = (long)wzvDao.getCountsAllWzb(lmids);//总记录数
  99. }
  100. int page_size =30; //每页记录数
  101. pgDao.setInt_num(page_size);
  102. long Current_Page = offset; //当前页
  103. pgDao.Init(Current_Page, rows_num);
  104. int l_start = (int)pgDao.getStart();
  105. int l_end = (int)pgDao.getEnd();
  106. //分页设定结束
  107. %>
  108. <head>
  109. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  110. <title>长春市城市发展投资控股(集团)有限公司</title>
  111. <link href="css/main.css" rel="stylesheet" type="text/css" />
  112. </head>
  113. <body>
  114. <table width="1200" border="0" align="center" cellpadding="0" cellspacing="0">
  115. <%@include file="top.jsp" %>
  116. <tr>
  117. <td height="5" bgcolor="#FFFFFF"></td>
  118. </tr>
  119. </table>
  120. <table width="1200" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  121. <tr>
  122. <td align="left" valign="top"><table width="1200" border="0" cellspacing="0" cellpadding="0" class="borlm">
  123. <tr>
  124. <td height="29" align="center" valign="middle" background="images/index_19.jpg"><table width="98%" border="0" cellspacing="0" cellpadding="0">
  125. <tr>
  126. <td width="32%" align="left" valign="middle" class="blue14b"><%=lmmc %></td>
  127. <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>
  128. </tr>
  129. </table></td>
  130. </tr>
  131. <tr>
  132. <td height="930" align="center" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0" class="mt10 mb8 black14">
  133. <tr>
  134. <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  135. <%
  136. List<Wzb> wzblist = new ArrayList<Wzb>();
  137. if(("-1".equals(lmids))){
  138. //wzblist = (List)wdo1.getAllWzbForPage2(new String[]{"1002001","1002002","1002003001","1002003002"}, l_start, page_size);
  139. List<Lmb> gkzllist = lmDao.getValidSubLmb("10010002");
  140. String[] zzjgIds = new String[gkzllist.size()];//各个部门ID,根据部门ID进一步查询
  141. String[] fids = new String[gkzllist.size()]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  142. if(gkzllist!=null){
  143. String[] lmmcs = new String[gkzllist.size()];
  144. for (int i =0;i<gkzllist.size();i++) {
  145. if(gkzllist.size()>i){
  146. lmmcs[i] =gkzllist.get(i).getLmmc();
  147. zzjgIds[i]=gkzllist.get(i).getLmid();//集团总部各栏目ID
  148. if(lmDao.getValidSubLmb(zzjgIds[i],"部门动态")!=null&&lmDao.getValidSubLmb(zzjgIds[i],"部门动态").size()>0){
  149. fids[i] = lmDao.getValidSubLmb(zzjgIds[i],"部门动态").get(0).getLmid();
  150. }
  151. }else{
  152. lmmcs[i]="";
  153. zzjgIds[i]="";
  154. }
  155. wzblist = wdo1.getAllWzbForPage2(fids, l_start, page_size);
  156. }
  157. }
  158. }else if("-2".equals(lmids)){
  159. List<Lmb> list_fzgs_parents = lmDao.getValidSubLmb("10010001");
  160. String [] parentIds = new String[list_fzgs_parents.size()];
  161. for(int i=0;i<list_fzgs_parents.size();i++){
  162. parentIds[i] = list_fzgs_parents.get(i).getLmid();
  163. }
  164. List<Lmb> list_fzgs = lmDao.getValidSubLmb(parentIds);
  165. // List<Lmb> list_fzgs = lmDao.getValidSubLmb("10010001");
  166. int count=0;
  167. if(list_fzgs!=null&&list_fzgs.size()>0){count = list_fzgs.size();}
  168. String[] dtids = new String[count]; //保存各个部门动态栏迷ID ,便于总部门动态栏目的查询
  169. if(list_fzgs!=null&&list_fzgs.size()>0){
  170. List<Lmb> lms =null;
  171. for(int i =0;i<list_fzgs.size();i++){
  172. lms = lmDao.getValidSubLmb(list_fzgs.get(i).getLmid(),"分子公司动态");
  173. if(lms!=null&&lms.size()>0){
  174. dtids[i]=lms.get(0).getLmid();
  175. }}
  176. }
  177. wzblist =(List)wdo1.getAllWzbForPage2(dtids, l_start, page_size);
  178. }else{
  179. wzblist =(List)wdo1.getAllWzbForPage(lmids, l_start, page_size);
  180. }
  181. if(wzblist != null){
  182. for(Wzb wzb:wzblist)
  183. {
  184. String wzbt = wzb.getWzbt();
  185. String time = wzb.getTjsj();
  186. String xwlx = wzb.getJtymc();
  187. long fb_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(time).getTime();
  188. if(wzbt.length() > 67)
  189. {
  190. wzbt=wzbt.substring(0,67)+"...";
  191. }
  192. %>
  193. <tr>
  194. <td width="3%" align="left" valign="middle" class="red14"> <%if(now - fb_time<432000000){ %>
  195. <img src="images/xin.gif"/>
  196. <%} %></td>
  197. <td width="90%" height="30" align="left" valign="middle"><a target="_blank" href="news.jsp?wzid=<%=wzb.getWzid()%>&&lmid=<%=lmids%>&&target=list2 ">
  198. <%=wzbt %> <%if("sp".equals(xwlx)){ %>
  199. <img src="images/index_35.jpg" width="16" height="12" />
  200. <%}else if("tp".equals(xwlx)){ %>
  201. <img src="images/index_31.jpg" width="16" height="12" />
  202. <%} %>
  203. </a></td>
  204. <td width="7%" align="left" valign="middle"><%=wzb.getTjsj().substring(0,10) %></td>
  205. </tr>
  206. <%
  207. }
  208. }
  209. %>
  210. </table>
  211. <!-- 分页显示 -->
  212. <script type="text/javascript">
  213. function page(cpage)
  214. {
  215. pageform.offset.value=cpage;
  216. pageform.submit();
  217. }
  218. </script>
  219. <form name="pageform" method="post" action="list2.jsp">
  220. <input type="hidden" name="offset" value="<%=offset %>">
  221. <input type="hidden" name="lmid" value="<%=lmids %>">
  222. <table cellspacing="0" align="center">
  223. <tbody>
  224. <tr height="30">
  225. <td>
  226. &nbsp;&nbsp;&nbsp;&nbsp;
  227. <span class="web">共</span><span class="red"><%=pgDao.getTotalpage()%></span><span class="web">页(</span>
  228. <span class="red"><%=pgDao.getCurpage()+1%></span><span class="web">/</span><span class="red"><%=pgDao.getTotalpage()%></span><span class="web">)
  229. &nbsp;&nbsp;&nbsp;&nbsp;
  230. 共</span><span class="red"><%=pgDao.getTotalnum()%></span><span class="web">条记录
  231. &nbsp;&nbsp;&nbsp;&nbsp;
  232. 本页显示第</span><span class="red"><%=l_start+1 %></span><span class="web">
  233. 条到第</span><span class="red"><%=l_end %></span><span class="web">条</span>
  234. <span class="web"><a href="javascript:page('0')" class="red" >首页</a></span>
  235. <span class="web"><a href="javascript:page('<%=pgDao.getPrepage()%>')" class="red">上页</a></span>
  236. <span class="web"><a href="javascript:page('<%=pgDao.getNextpage()%>')" class="red">下页</a></span>
  237. <span class="web"><a href="javascript:page('<%=pgDao.getTotalpage()-1%>')" class="red">尾页</a></span>
  238. <span class="web">转到第 <input type=text name=Query_Page size=3> 页</span>
  239. <span class="web"><input type="BUTTON" value="查看" class="BUTTON" style="cursor:hand" onClick="return page(Query_Page.value-1)"></span>
  240. </td>
  241. </tr>
  242. </tbody>
  243. </table>
  244. </form>
  245. <!-- 右侧页 -->
  246. </td>
  247. </tr>
  248. </table></td>
  249. </tr>
  250. </table></td>
  251. </tr>
  252. </table>
  253. <%@include file="Bottom.jsp" %>
  254. </body>
  255. </html>