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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
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. <jsp:useBean id="BusinessName" scope="session" class="com.vnex.intranet.pub.BusinessSession" />
  10. <%
  11. String startMonth = request.getParameter("yearStart")+"-"+request.getParameter("monthStart");
  12. String endMonth = request.getParameter("yearEnd")+"-"+request.getParameter("monthEnd");;
  13. int balanceYear = (new Integer(request.getParameter("yearEnd"))).intValue()-(new Integer(request.getParameter("yearStart"))).intValue();
  14. int balanceMonth = (new Integer(request.getParameter("monthEnd"))).intValue()-(new Integer(request.getParameter("monthStart"))).intValue();
  15.     int balanceYearMonth = balanceYear*12+balanceMonth;
  16.     int id = BusinessName.getDeptId();
  17.     String choose = request.getParameter("choose");
  18. String divisionName = BudgetListProxy.divisionName(id);
  19. double oneMonthBudget = 0.0d;
  20. double oneMonthActual = 0.0d;
  21. int changeMonth = 0;
  22. DecimalFormat dFormat = new DecimalFormat("##.##");    
  23. %>
  24. <HTML><jsp:include page="/vnex/page/FORM_HEAD.jsp" />
  25. <script language="JavaScript1.2" src="/vnex/menu/dockmenu_person.js"></script>
  26. <script language="JavaScript1.2" src="/vnex/menu/dockmenu.js"></script>
  28. <BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
  29. <DIV align=center>
  30. <form name="form1" method="post" action="">
  31.   <TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
  32.     <jsp:include page="/vnex/page/TTOA_TABLE_TOP.jsp" />
  33.     <TR> 
  34.         <TD colSpan=3 align="center" class="iframestyle" valign="top"> <br>
  35.           <table width="600" border="1" cellspacing="1" bordercolor="#666666">
  36.             <tr valign="top"> 
  37.               <td > 
  38.                 
  39.                 <table width="600" border="0" cellspacing="0" cellpadding="2">
  40.                   <tr> 
  41.                     <td bgcolor="#666666"><font class="strongw"><a href="/mainctrl/home/index"><font color="#FFFFFF">首页</font></a>&gt;&gt;<a href="/mainctrl/personal/main"><font color="#FFFFFF">个人办公</font></a>&gt;&gt;<a href="/mainctrl/budget/index"><font color="#FFFFFF">部门预算</font></a>&gt;&gt;<a href="/mainctrl/budget/resultDep"><font color="#FFFFFF">统计查询</font></a>&gt;&gt;<font color="#FFFFFF">查询结果</font></font></td>
  42.                   </tr>
  43.                 </table>
  44.                 <table class=title width="600" border="0" cellpadding="2" cellspacing="0">
  45.                   <tr bgcolor="#fafafa"> 
  46.                     <td colspan="5"> 
  47. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  48.                         <tr>
  49.                           <td width="80%"><font class="strong">&nbsp;下面是<%=startMonth%>至<%=endMonth%><%=divisionName%>的预算统计表(
  50.   <%
  51.   if(choose.equals("1"))
  52.   {
  53.      out.println("类别:预算");
  54.   }
  55.   else if(choose.equals("2"))
  56.   {
  57.      out.println("类别:实际");
  58.   }
  59.   else if(choose.equals("3"))
  60.   {
  61.      out.println("类别:预算和实际");
  62.   }
  63.   %>
  64.   )：</font> 
  65.                           </td>
  66.                           <td width="20%">
  67.                             <div align="right"><font class="strong">单位:元&nbsp;&nbsp;&nbsp;&nbsp;</font></div>
  68.                           </td>
  69.                         </tr>
  70.                       </table>
  71.                     </td>
  72.                   </tr>
  73.                 </table>
  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/budget/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=100  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=100> <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=100> <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. </tr>
  148. <%
  149. try
  150. {
  151.     int blue=0;
  152.         String rowColor="";
  153. int column = 0;
  154. Collection collAll = BudgetListProxy.getParseBudget(startMonth, endMonth, id);
  155. Iterator iterAll = collAll.iterator();
  156. if((choose.compareTo("3")) == 0)
  157. {
  158. while(iterAll.hasNext())
  159. {
  160.     column++;
  161. rowColor = ((column%2)==0)?"#fafafa":"#e0e0e0";
  162. %>
  163.                         <tr bgcolor=<%=rowColor%> align="center"> 
  164. <%
  165.     Collection coll = (Collection)iterAll.next();
  166. Iterator iter = coll.iterator();
  167. while(iter.hasNext())
  168. {
  169.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iter.next();
  170. if(blue==0)
  171. {
  172.     out.println("<td>"+budgetListValueBean.getMonth()+"</td>");
  173.     blue = 1;
  174.  }
  175.   if (budgetListValueBean.getDivision() == -1)
  176.   {
  177.       out.println("<td></td><td></td>");
  178.   }
  179.   else
  180.   {
  181.       out.println("<td>"+budgetListValueBean.getBudget()+"</td>");
  182.   if(budgetListValueBean.getActual() != -1f)
  183.   {
  184.   out.println("<td>"+budgetListValueBean.getActual()+"</td>");
  185.   oneMonthActual += budgetListValueBean.getActual();
  186.     }
  187.   else
  188.   {
  189.       out.println("<td></td>");
  190.   }
  191.   
  192.   oneMonthBudget += budgetListValueBean.getBudget();
  193.   changeMonth = 1;
  194.   }
  195.  }
  196.  blue = 0;
  197.  if (changeMonth == 1)
  198.  {
  199.  out.println("<td>"+dFormat.format(oneMonthBudget)+"</td><td>"+dFormat.format(oneMonthActual)+"</td></tr>");
  200.      }
  201.  else
  202.  {
  203.  out.println("<td></td><td></td></tr>");
  204.  }
  205.  oneMonthBudget = 0.0d;
  206.  oneMonthActual = 0.0d;
  207.  changeMonth = 0;
  208.     }
  209. }
  210. else if (((choose.compareTo("2")) == 0))
  211. {
  212. while(iterAll.hasNext())
  213. {
  214.     column++;
  215. rowColor = ((column%2)==0)?"#fafafa":"#e0e0e0";
  216. %>
  217.                         <tr bgcolor=<%=rowColor%> align="center"> 
  218. <%
  219.     Collection coll = (Collection)iterAll.next();
  220. Iterator iter = coll.iterator();
  221. while(iter.hasNext())
  222. {
  223.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iter.next();
  224. if(blue==0)
  225. {
  226.     out.println("<td>"+budgetListValueBean.getMonth()+"</td>");
  227.     blue = 1;
  228.  }
  229.   if (budgetListValueBean.getDivision() == -1)
  230.   {
  231.       out.println("<td></td>");
  232.   }
  233.   else
  234.   {
  235.   if(budgetListValueBean.getActual() != -1f)
  236.   {
  237.   out.println("<td>"+budgetListValueBean.getActual()+"</td>");
  238.   oneMonthActual += budgetListValueBean.getActual();
  239.     }
  240.   else
  241.   {
  242.       out.println("<td></td>");
  243.   }
  244.   changeMonth = 1;
  245.   }
  246.  }
  247.  blue = 0;
  248.  if (changeMonth == 1)
  249.  {
  250.  out.println("<td>"+dFormat.format(oneMonthActual)+"</td></tr>");
  251.      }
  252.  else
  253.  {
  254.  out.println("<td></td></tr>");
  255.  }
  256.  oneMonthActual = 0.0d;
  257.  changeMonth = 0;
  258.     }
  259. }
  260. else
  261. {
  262. while(iterAll.hasNext())
  263. {
  264.     column++;
  265. rowColor = ((column%2)==0)?"#fafafa":"#e0e0e0";
  266. %>
  267.                         <tr bgcolor=<%=rowColor%> align="center"> 
  268. <%
  269.     Collection coll = (Collection)iterAll.next();
  270. Iterator iter = coll.iterator();
  271. while(iter.hasNext())
  272. {
  273.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iter.next();
  274. if(blue==0)
  275. {
  276.     out.println("<td>"+budgetListValueBean.getMonth()+"</td>");
  277.     blue = 1;
  278.  }
  279.   if (budgetListValueBean.getDivision() == -1)
  280.   {
  281.       out.println("<td></td>");
  282.   }
  283.   else
  284.   {
  285.       out.println("<td>"+budgetListValueBean.getBudget()+"</td>");
  286.   oneMonthBudget += budgetListValueBean.getBudget();
  287.   changeMonth = 1;   
  288.   }
  289.  }
  290.  blue = 0;
  291.  if (changeMonth == 1)
  292.  {
  293.  out.println("<td>"+dFormat.format(oneMonthBudget)+"</td></tr>");
  294.      }
  295.  else
  296.  {
  297.  out.println("<td></td></tr>");
  298.  }
  299.  oneMonthBudget = 0.0d;
  300.  changeMonth = 0;
  301.     }
  302. }
  303. %>
  304.    <!--列表显示结束-->
  305.    <!--总计显示开始-->
  306. <%
  307.     Collection collTotal = BudgetListProxy.getDepTotal(startMonth, endMonth, id);
  308. Iterator iterTotal = collTotal.iterator();
  309. if(rowColor.equals("#fafafa")) rowColor = "#e0e0e0";
  310. else rowColor = "#fafafa";
  311. if((choose.compareTo("3")) == 0)
  312. {
  313.                 double budgetTotal = 0.0d;
  314. double actualTotal = 0.0d;
  315.                 out.println("<tr align=center bgcolor="+rowColor+"><td><font class=strong>总计:</font></td>");
  316. while(iterTotal.hasNext())
  317. {
  318.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iterTotal.next();
  319. budgetTotal += budgetListValueBean.getBudget();
  320. actualTotal += budgetListValueBean.getActual();
  321. out.println("<td>"+budgetListValueBean.getBudget()+"</td><td>"+budgetListValueBean.getActual()+"</td>");
  322. }
  323. out.println("<td>"+dFormat.format(budgetTotal)+"</td><td>"+dFormat.format(actualTotal)+"</td></tr>");
  324. }
  325. else if (((choose.compareTo("2")) == 0))
  326. {
  327. double actualTotal = 0.0d;
  328.                 out.println("<tr align=center bgcolor="+rowColor+"><td><font class=strong>总计</font></td>");
  329. while(iterTotal.hasNext())
  330. {
  331.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iterTotal.next();
  332. actualTotal += budgetListValueBean.getActual();
  333. out.println("<td>"+budgetListValueBean.getActual()+"</td>");
  334. }
  335. out.println("<td>"+dFormat.format(actualTotal)+"</td></tr>");
  336. }
  337. else if (((choose.compareTo("1")) == 0))
  338. {
  339.                 double budgetTotal = 0.0d;
  340.                 out.println("<tr align=center bgcolor="+rowColor+"><td><font class=strong>总计</font></td>");
  341. while(iterTotal.hasNext())
  342. {
  343.     BudgetListValueBean budgetListValueBean = (BudgetListValueBean)iterTotal.next();
  344. budgetTotal += budgetListValueBean.getBudget();
  345. out.println("<td>"+budgetListValueBean.getBudget()+"</td>");
  346. }
  347. out.println("<td>"+dFormat.format(budgetTotal)+"</td></tr>");
  348. }
  349. %>   
  350.    <!--总计显示结束-->   
  351. <%
  352. }
  353. catch(Exception e)
  354. {
  355.     out.println(e);
  356. }
  357. %>
  359.                 </table></div>
  360.                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  361.                   <tr  align="center"> 
  362.                     <td  bgcolor="#fafafa" height="30" align="center"> 
  363.                       <input type="button" name="Button22" value="返回" onClick="location='/mainctrl/budget/resultDep'" class="text">
  364.                     </td>
  365.                   </tr>
  366.   
  367.                 </table>
  368.               </td>
  369.             </tr>
  370.           </table>
  371.          <jsp:include page="/vnex/page/TTOA_HELP.jsp" />
  372.        </TD>
  373.     </TR>
  374.      <jsp:include page="/vnex/page/TTOA_TABLE_BOTTOM.jsp" />
  375.     </TABLE>
  376.     <BR>
  377.     <jsp:include page="/vnex/page/TTOA_PRODUCER_LOGO.jsp" />
  378. </form>
  379.   </DIV>
  380.  </BODY>
  381. </HTML>