monthreport.jsp

tomcat最新安装程序

                    </select> &nbsp;&nbsp;
                    <input name="button" type="button" class="button1" onClick="javascript:MonthAnalysis();"    onMouseOver="this.className='button2'" onMouseOut="this.className='button1'" value="查 询" > 
                  </td>
                </tr>
              </table>		  
            </td>
        </tr>  <input name="module" type="hidden" value="income">
 </form>     </table> 
	  

	
        
      <table border="0" cellpadding="0" cellspacing="0" width="98%" class="collapse" align="center">

        <tr class="tdA"> 
          <td colspan="8" align="center" >
            <%=sYear%>年<%=sMonth%>月任务收支报表（万元）</td>
        </tr>
        <tr> 
          <td width="6%" rowspan="2" align="center" class="tdB">编号</td>
          <td width="24%" rowspan="2" align="center" class="tdB">任务名称</td>
          <td colspan="3" align="center" class="tdB">收入</td>
          <td colspan="3" align="center" class="tdB">支出</td>
        </tr>
        <tr> 
          <td width="11%" align="center" class="tdB" nowrap>期初余额</td>
          <td width="11%" align="center" class="tdB" nowrap>本月发生</td>
          <td width="13%" align="center" class="tdB" nowrap>本月累计</td>
          <td width="11%" align="center" class="tdB" nowrap>期初余额</td>
          <td width="11%" align="center" class="tdB" nowrap>本月发生</td>
          <td width="13%" align="center" class="tdB" nowrap>本月累计</td>
        </tr>
        <%
		  float sumfincomePre=0;
		  float sumfincomeMonth=0;
		  float sumincome=0;
		  float sumfpayoutPre=0;
		  float sumfpayoutMonth=0;
		  float sumpayout=0;
		  String month = sMonth;
	      String year  = sYear;
		  DecimalFormat df11 = new DecimalFormat("#####0.0");
		  if(detailRs!=null){
		  int num=1;
		      while(detailRs.next()){
			  String incomeMonth="0";
			  String incomePre="0";
			  if(incomeRs!=null){
			     incomeRs.beforefirst();
				 while(incomeRs.next()){
				   if((detailRs.getD_Serial()).equals(incomeRs.getTI_TaskID())){
				   incomeMonth=incomeRs.getTI_Money();
				   break;
				   }
				 }
			  }
			  if(incomePreRs!=null){
			     incomePreRs.beforefirst();
				 while(incomePreRs.next()){
				   if((detailRs.getD_Serial()).equals(incomePreRs.getTI_TaskID())){
				   incomePre=incomePreRs.getTI_Money();
				   break;
				   }
				 }
			  }
			  float fincomePre=Float.parseFloat(incomePre)/10000;
			  sumfincomePre=sumfincomePre+fincomePre;
			  float fincomeMonth=Float.parseFloat(incomeMonth)/10000;
			  sumfincomeMonth=sumfincomeMonth+fincomeMonth;
			  float income=fincomePre+fincomeMonth;
			  sumincome=sumincome+income;
			  
			  String payoutPre="0";
			  String payoutMonth="0";//getMoneySum()
			  if(outPreRs!=null){
			     outPreRs.beforefirst();
				 while(outPreRs.next()){
				   if((detailRs.getD_Serial()).equals(outPreRs.getEI_ItemID())){
				   payoutPre=outPreRs.getMoneySum();
				   break;
				   }
				 }
			  }
			  if(outRs!=null){
			     outRs.beforefirst();
				 while(outRs.next()){
				   if((detailRs.getD_Serial()).equals(outRs.getEI_ItemID())){
				   payoutMonth=outRs.getMoneySum();
				   break;
				   }
				 }
			  }
			  String processPre="0";
			  String process="0";
			  if(processRs!=null){
			     processRs.beforefirst();
				 while(processRs.next()){
				   if((detailRs.getD_Serial()).equals(processRs.getPI_TaskID())){
				   process=processRs.getPI_Money();
				   break;
				   }
				 }
			  }
			  if(processPreRs!=null){
			     processPreRs.beforefirst();
				 while(processPreRs.next()){
				   if((detailRs.getD_Serial()).equals(processPreRs.getPI_TaskID())){
				   processPre=processPreRs.getPI_Money();
				   break;
				   }
				 }
			  }
			  String pastPre="0";
			  String past="0";
			  if(pastRs!=null){
			     pastRs.beforefirst();
				 while(pastRs.next()){
				   if((detailRs.getD_Serial()).equals(pastRs.getIP_TaskID())){
				   past=pastRs.getIP_Money();
				   break;
				   }
				 }
			  }
			  if(pastPreRs!=null){
			     pastPreRs.beforefirst();
				 while(pastPreRs.next()){
				   if((detailRs.getD_Serial()).equals(pastPreRs.getIP_TaskID())){
				   pastPre=pastPreRs.getIP_Money();
				   break;
				   }
				 }
			  }			  			  			  			  
			  float fpayoutPre=(Float.parseFloat(payoutPre)+Float.parseFloat(pastPre)+Float.parseFloat(processPre))/10000;
			  sumfpayoutPre=sumfpayoutPre+fpayoutPre;
			  float fpayoutMonth=(Float.parseFloat(payoutMonth)+Float.parseFloat(past)+Float.parseFloat(process))/10000;
			  sumfpayoutMonth=sumfpayoutMonth+fpayoutMonth;
			  float payout=fpayoutPre+fpayoutMonth;
			  sumpayout=sumpayout+payout;			  			  
		  %>
        <tr<%
		if(num%2==0){
		%> class="bgcolor"<%}%>> 
          <td align="center" class="common"><%=StringFormat.changeHTMLTags(detailRs.getD_Num())%></td>
          <td align="center" class="common"><%=StringFormat.changeHTMLTags(detailRs.getD_Topic())%></td>
          <td align="center" class="common"><%=df11.format(fincomePre)%></td>
          <td align="center" class="common"><a href="/krm/servlet/FinIncomeServlet?status=q&module=in&Year=<%=sYear%>&Month=<%=sMonth%>&TaskID=<%=detailRs.getD_Serial()%>"><%=df11.format(fincomeMonth)%></a></td>
          <td align="center" class="common"><%=df11.format(income)%></td>
          <td align="center" class="common"><%=df11.format(fpayoutPre)%></td>
          <td align="center" class="common"><a href="/krm/servlet/FinIncomeServlet?status=q&module=out&Year=<%=sYear%>&Month=<%=sMonth%>&TaskID=<%=detailRs.getD_Serial()%>"><%=df11.format(fpayoutMonth)%></a></td>
          <td align="center" class="common"><%=df11.format(payout)%></td>
        </tr>
        <%
		num++;
		      }
		   }
		  %>
        <tr class="common"> 
          <td colspan="2" align="center">合计：</td>
          <td align="center"><%=df11.format(sumfincomePre)%></td>
          <td align="center"><%=df11.format(sumfincomeMonth)%></td>
          <td align="center"><%=df11.format(sumincome)%></td>
          <td align="center"><%=df11.format(sumfpayoutPre)%></td>
          <td align="center" ><%=df11.format(sumfpayoutMonth)%></td>
          <td align="center"><%=df11.format(sumpayout)%></td>
        </tr>
        <tr> 
          <td width="6%" rowspan="2" align="center"  class="tdB" >编号</td>
          <td width="25%" rowspan="2" align="center"  class="tdB" >任务名称</td>
          <td align="center" class="tdB">期初余额</td>
          <td align="center" class="tdB">本月发生</td>
          <td align="center" class="tdB">本月累计</td>
          <td align="center" class="tdB">期初余额</td>
          <td align="center" class="tdB">本月发生</td>
          <td align="center" class="tdB">本月累计</td>
        </tr>
        <tr > 
          <td colspan="3" align="center" nowrap class="tdB">收入</td>
          <td colspan="3" align="center" nowrap class="tdB">支出</td>
        </tr>
		 <tr>
       <td colspan="8" align="center" class="tdC">
       <input type="button"  onClick="javascript:history.back(1);" value="返 回"   onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" >
       </td>
      </tr>
      </table>	  
	  </td>
  </tr>
</table>
              
</body>
</html>