开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
Fin_Result_Dep_result.jsp
资源名称：NetOffice.rar　[点击查看]
上传用户：guhaomin
上传日期：2007-06-10
资源大小：23203k
文件大小：13k
源码类别：

电子政务应用

开发平台：

Java

Fin_Result_Dep_result.jsp：源码内容
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  2. <%@ page errorPage="/vnex/ErrorPage.jsp" %>
  3. <%@ page language="java" %>
  4. <%@ page import="java.util.*" %>
  5. <%@ page import="java.lang.*" %>
  6. <%@ page import="com.vnex.intranet.budget.value.*" %>
  7. <%@ page import="java.text.DecimalFormat" %>
  8. <jsp:useBean id="BudgetListProxy" scope="application" class="com.vnex.intranet.budget.proxy.BudgetListProxyBean" />
  9. <%
  10. String startMonth = request.getParameter("yearStart")+"-"+request.getParameter("monthStart");
  11. String endMonth = request.getParameter("yearEnd")+"-"+request.getParameter("monthEnd");;
  12. int balanceYear = (new Integer(request.getParameter("yearEnd"))).intValue()-(new Integer(request.getParameter("yearStart"))).intValue();
  13. int balanceMonth = (new Integer(request.getParameter("monthEnd"))).intValue()-(new Integer(request.getParameter("monthStart"))).intValue();
  14.     int balanceYearMonth = balanceYear*12+balanceMonth;
  15.     int id = Integer.parseInt(request.getParameter("id"));
  16.     String choose = request.getParameter("choose");
  17. String divisionName = BudgetListProxy.divisionName(id);
  18. double oneMonthBudget = 0.0d;
  19. double oneMonthActual = 0.0d;
  20. int changeMonth = 0;    
  21. DecimalFormat dFormat = new DecimalFormat("##.##");    
  22. %>
  23. <HTML><jsp:include page="/vnex/page/FORM_HEAD.jsp" />
  24. <script language="JavaScript1.2" src="/vnex/menu/dockmenu_finance.js"></script><script language="JavaScript1.2" src="/vnex/menu/dockmenu.js"></script>
  26. <BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
  27. <DIV align=center>
  28. <form name="form1" method="post" action="">
  29.   <TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
  30.      
  31.     <jsp:include page="/vnex/page/TTOA_TABLE_TOP.jsp" />
  32.     <TR> 
  33.         <TD colSpan=3 align="center" class="iframestyle" valign="top"> <br>
  34.           <table width="600" border="1" cellspacing="1" bordercolor="#666666">
  35.             <tr valign="top"> 
  36.               <td > 
  37.                 
  38.                 <table width="600" border="0" cellspacing="0" cellpadding="2">
  39.                   <tr> 
  40.                     <td bgcolor="#666666"><font class="strongw"><a href="/mainctrl/home/index"><font color="#FFFFFF">首页</font></a>&gt;&gt;<a href="/mainctrl/finance/main"><font color="#FFFFFF">财务</font></a>&gt;&gt;<a href="/mainctrl/financial/finIndex"><font color="#FFFFFF">统计查看</font></a>&gt;&gt;<a href="/mainctrl/financial/resultDep"><font color="#FFFFFF">单个部门</font></a>&gt;&gt;统计结果</font></td>
  41.                   </tr>
  42.                 </table>
  43.                 <table class=title width="600" border="0" cellpadding="2" cellspacing="0">
  44.                   <tr bgcolor="#fafafa"> 
  45.                     <td colspan="5"> 
  46. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  47.                         <tr>
  48.                           <td width="80%"><font class="strong">&nbsp;下面是<%=startMonth%>至<%=endMonth%><%=divisionName%>的预算统计表(
  49.   <%
  50.   if(choose.equals("1"))
  51.   {
  52.      out.println("类别:预算");
  53.   }
  54.   else if(choose.equals("2"))
  55.   {
  56.      out.println("类别:实际");
  57.   }
  58.   else if(choose.equals("3"))
  59.   {
  60.      out.println("类别:预算和实际");
  61.   }
  62.   %>
  63.   )：</font>
  64.                           </td>
  65.                           <td width="20%">
  66.                             <div align="right"><font class="strong">单位:元&nbsp;&nbsp;&nbsp;&nbsp;</font></div>
  67.                           </td>
  68.                         </tr>
  69.                       </table>
  70.                     </td>
  71.                   </tr>
  72.                 </table>
  73. <!--列表显示开始-->
  74. <%
  75.                 //列出各个项目开始
  76.     int col = 0;
  77. Collection collItem = BudgetListProxy.allUseItem(startMonth, endMonth, id);
  78. int allRecord = collItem.size();
  79. if (allRecord == 0)
  80.                             response.sendRedirect("/mainctrl/financial/resultDepResultFail");
  81.     if(balanceYearMonth<14)
  82. {
  83.  out.println("<div id="Layer1" style="width:600px; height:"+(balanceYearMonth*20+128)+"px; z-index:1; overflow:auto" >");
  84. }
  85. else
  86. {
  87.  out.println("<div id="Layer1" style="width:600px; height:365px; z-index:1; overflow:auto" >");
  88. }
  89. Iterator iterItem = collItem.iterator();
  90. BudgetValueBean valueItem = null;
  91. int theWidth = 0;
  93. if(choose.equals("1"))
  94. {
  95.             theWidth = allRecord*50+150;
  96. }
  97. else if(choose.equals("2"))
  98. {
  99.             theWidth = allRecord*50+150;
  100. }
  101. else
  102. {
  103.             theWidth = allRecord*100+150;
  104. }
  106.             //int theWidth = allRecord*100+150;
  107. theWidth = (theWidth<=600)?600:theWidth;
  108. out.println("<table class=title width="+theWidth+" border=0 cellpadding=2 cellspacing=1>");
  109. if((choose.compareTo("3")) == 0)
  110. {
  111. out.println("<tr align=center bgcolor=#b4b4b4><td width=150  height=2 rowspan=2><font class=strong>月份</font></td>");
  112. while(iterItem.hasNext())
  113. {
  114.     col++;
  115.     valueItem = (BudgetValueBean)iterItem.next();
  116. out.println("<td width=100 colspan=2><font class=strong >"+valueItem.getName()+"</font></td>");
  117.     }
  118. out.println("<td width=100 colspan=2><font class=strong >总计</font></td></tr><tr align=center bgcolor=#b4b4b4>");
  119. for(int i=-1; i<col; i++)
  120. {
  121.     out.println("<td width=50>预算</td><td width=50>实际</td>");
  122.     }
  123. }
  124. else if (((choose.compareTo("2")) == 0))
  125. {
  126. out.println("<tr align=center bgcolor=#b4b4b4><td align=center width=150> <font class=strong>月份</font></td>");
  127. while(iterItem.hasNext())
  128. {
  129.     col++;
  130.     valueItem = (BudgetValueBean)iterItem.next();
  131. out.println("<td width=50><font class=strong >"+valueItem.getName()+"</font></td>");
  132.     }
  133. out.println("<td width=100><font class=strong >总计</font></td>");
  134. }
  135. else
  136. {
  137. out.println("<tr align=center bgcolor=#b4b4b4><td width=150> <font class=strong>月份</font></td>");
  138. while(iterItem.hasNext())
  139. {
  140.     col++;
  141.     valueItem = (BudgetValueBean)iterItem.next();
  142. out.println("<td width=50><font class=strong >"+valueItem.getName()+"</font></td>");
  143.     }
  144. out.println("<td width=100><font class=strong >总计</font></td>");
  145. }
  146.                 //列出项目结束.
  147. %>
  148. </tr>
  149. <%
  150. try
  151. {
  152.     //列出数据开始.
  153.     int blue=0;
  154.         String rowColor="";
  155. int column = 0;
  156. Collection collAll = BudgetListProxy.getParseBudget(startMonth, endMonth, id);
  157. Iterator iterAll = collAll.iterator();
  158. if((choose.compareTo("3")) == 0)
  159. {
  160. while(iterAll.hasNext())
  161. {
  162.     column++;
  163. rowColor = ((column%2)==0)?"#fafafa":"#e0e0e0";
  164. %>
  165.                         <tr bgcolor=<%=rowColor%> align="center"> 
  166. <%
  167.     Collection coll = (Collection)iterAll.next();
  168. Iterator iter = coll.iterator();
  169. while(iter.hasNext())
  170. {
  171.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iter.next();
  172. if(blue==0)
  173. {
  174.     out.println("<td>"+budgetListValueBean.getMonth()+"</td>");
  175.     blue = 1;
  176.  }
  177.   if (budgetListValueBean.getDivision() == -1)
  178.   {
  179.       out.println("<td></td><td></td>");
  180.   }
  181.   else
  182.   {
  183.       out.println("<td>"+budgetListValueBean.getBudget()+"</td>");
  184.   if(budgetListValueBean.getActual() != -1f)
  185.   {
  186.   out.println("<td>"+budgetListValueBean.getActual()+"</td>");
  187.   oneMonthActual += budgetListValueBean.getActual();
  188.     }
  189.   else
  190.   {
  191.       out.println("<td></td>");
  192.   }
  193.   
  194.   oneMonthBudget += budgetListValueBean.getBudget();
  195.   changeMonth = 1;
  196.   }
  197.  }
  198.  blue = 0;
  199.  if (changeMonth == 1)
  200.  {
  201.  out.println("<td>"+dFormat.format(oneMonthBudget)+"</td><td>"+dFormat.format(oneMonthActual)+"</td></tr>");
  202.      }
  203.  else
  204.  {
  205.  out.println("<td></td><td></td></tr>");
  206.  }
  207.  oneMonthBudget = 0.0d;
  208.  oneMonthActual = 0.0d;
  209.  changeMonth = 0;
  210.     }
  211. }
  212. else if (((choose.compareTo("2")) == 0))
  213. {
  214. while(iterAll.hasNext())
  215. {
  216.     column++;
  217. rowColor = ((column%2)==0)?"#fafafa":"#e0e0e0";
  218. %>
  219.                         <tr bgcolor=<%=rowColor%> align="center"> 
  220. <%
  221.     Collection coll = (Collection)iterAll.next();
  222. Iterator iter = coll.iterator();
  223. while(iter.hasNext())
  224. {
  225.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iter.next();
  226. if(blue==0)
  227. {
  228.     out.println("<td>"+budgetListValueBean.getMonth()+"</td>");
  229.     blue = 1;
  230.  }
  231.   if (budgetListValueBean.getDivision() == -1)
  232.   {
  233.       out.println("<td></td>");
  234.   }
  235.   else
  236.   {
  237.   if(budgetListValueBean.getActual() != -1f)
  238.   {
  239.   out.println("<td>"+budgetListValueBean.getActual()+"</td>");
  240.   oneMonthActual += budgetListValueBean.getActual();
  241.     }
  242.   else
  243.   {
  244.       out.println("<td></td>");
  245.   }
  246.   changeMonth = 1;
  247.   }
  248.  }
  249.  blue = 0;
  250.  if (changeMonth == 1)
  251.  {
  252.  out.println("<td>"+dFormat.format(oneMonthActual)+"</td></tr>");
  253.      }
  254.  else
  255.  {
  256.  out.println("<td></td></tr>");
  257.  }
  258.  oneMonthActual = 0.0d;
  259.  changeMonth = 0;
  260.     }
  261. }
  262. else
  263. {
  264. while(iterAll.hasNext())
  265. {
  266.     column++;
  267. rowColor = ((column%2)==0)?"#fafafa":"#e0e0e0";
  268. %>
  269.                         <tr bgcolor=<%=rowColor%> align="center"> 
  270. <%
  271.     Collection coll = (Collection)iterAll.next();
  272. Iterator iter = coll.iterator();
  273. while(iter.hasNext())
  274. {
  275.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iter.next();
  276. if(blue==0)
  277. {
  278.     out.println("<td>"+budgetListValueBean.getMonth()+"</td>");
  279.     blue = 1;
  280.  }
  281.   if (budgetListValueBean.getDivision() == -1)
  282.   {
  283.       out.println("<td></td>");
  284.   }
  285.   else
  286.   {
  287.       out.println("<td>"+budgetListValueBean.getBudget()+"</td>");
  288.   oneMonthBudget += budgetListValueBean.getBudget();
  289.   changeMonth = 1;   
  290.   }
  291.  }
  292.  blue = 0;
  293.  if (changeMonth == 1)
  294.  {
  295.  out.println("<td>"+dFormat.format(oneMonthBudget)+"</td></tr>");
  296.      }
  297.  else
  298.  {
  299.  out.println("<td></td></tr>");
  300.  }
  301.  oneMonthBudget = 0.0d;
  302.  changeMonth = 0;
  303.     }
  304. }
  305.                 //列出数据结束.
  306. %>
  307.    <!--列表显示结束-->
  308.    <!--总计显示开始-->
  309. <%
  310.     Collection collTotal = BudgetListProxy.getDepTotal(startMonth, endMonth, id);
  311. Iterator iterTotal = collTotal.iterator();
  312. if(rowColor.equals("#fafafa")) rowColor = "#e0e0e0";
  313. else rowColor = "#fafafa";
  314. if((choose.compareTo("3")) == 0)
  315. {
  316.                 double budgetTotal = 0.0d;
  317. double actualTotal = 0.0d;
  318.                 out.println("<tr align=center bgcolor="+rowColor+"><td><font class=strong>总计:</font></td>");
  319. while(iterTotal.hasNext())
  320. {
  321.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iterTotal.next();
  322. budgetTotal += budgetListValueBean.getBudget();
  323. actualTotal += budgetListValueBean.getActual();
  324. out.println("<td>"+budgetListValueBean.getBudget()+"</td><td>"+budgetListValueBean.getActual()+"</td>");
  325. }
  326. out.println("<td>"+dFormat.format(budgetTotal)+"</td><td>"+dFormat.format(actualTotal)+"</td></tr>");
  327. }
  328. else if (((choose.compareTo("2")) == 0))
  329. {
  330. double actualTotal = 0.0d;
  331.                 out.println("<tr align=center bgcolor="+rowColor+"><td><font class=strong>总计</font></td>");
  332. while(iterTotal.hasNext())
  333. {
  334.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iterTotal.next();
  335. actualTotal += budgetListValueBean.getActual();
  336. out.println("<td>"+budgetListValueBean.getActual()+"</td>");
  337. }
  338. out.println("<td>"+dFormat.format(actualTotal)+"</td></tr>");
  339. }
  340. else if (((choose.compareTo("1")) == 0))
  341. {
  342.                 double budgetTotal = 0.0d;
  343.                 out.println("<tr align=center bgcolor="+rowColor+"><td><font class=strong>总计</font></td>");
  344. while(iterTotal.hasNext())
  345. {
  346.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iterTotal.next();
  347. budgetTotal += budgetListValueBean.getBudget();
  348. out.println("<td>"+budgetListValueBean.getBudget()+"</td>");
  349. }
  350. out.println("<td>"+dFormat.format(budgetTotal)+"</td></tr>");
  351. }
  352. %>   
  353.    <!--总计显示结束-->
  354. <%
  355. }
  356. catch(Exception e)
  357. {
  358.     out.println(e);
  359. }
  360. %>
  361.                 </table></div>
  362.                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  363.                   <tr  align="center"> 
  364.                     <td  bgcolor="#fafafa" height="30" align="center"> 
  365.                       <input type="button" name="Button22" value="返回" onClick="location='/mainctrl/financial/resultDep'" class="text">
  366.                     </td>
  367.                   </tr>
  368.   
  369.                 </table>
  370.               </td>
  371.             </tr>
  372.           </table>
  373.           <jsp:include page="/vnex/page/TTOA_HELP.jsp" />
  374.        </TD>
  375.     </TR>
  376.      <jsp:include page="/vnex/page/TTOA_TABLE_BOTTOM.jsp" />
  377.     </TABLE>
  378.     <BR>
  379.     <jsp:include page="/vnex/page/TTOA_PRODUCER_LOGO.jsp" />
  380. </form>
  381.   </DIV>
  382.  </BODY>
  383. </HTML>