departmentfeereport.java

(Java+SQL)-大型企业JAVA的ERP系统

package src.report;

import src.com.*;
import java.lang.*;
import java.sql.*;
import java.io.*;
import java.math.BigDecimal;


public class DepartmentFeeReport extends ShangObject 
{

   /**
部门
   */
   private String departmentName;
   
   /**
商品销售收入
   */
   private double invoiceMoney;   
   
   public double totalInvoiceMoney;

   /**
商品销售成本
   */
   private double saleCost;
   
   public double totalSaleCost;
   
   /**
增值税金额
   */
   private double valueAddedTax;
   
   public double totalValueAddedTax;
   
   /**
运杂费
   */
   private double transferCost;
   
   public double totalTransferCost;
      
   /**
仓储费
   */
   private double storeCost;      
   
   public double totalStoreCost;
      
   /**
资金占用利息
   */
   private double intest;      
   
   public double totalIntest;
   
   /**
二金一费印花税代理费
   */
   private double stamTax; 
   
   public double totalStamTax;        

   /**
其他费用
   */
   private double otherCost;  
   
   public double totalOtherCost;             
   
   /**
上交收益额
   */
   private double handinIncome; 
   
   public double totalHandinIncome;                 
      
   /**
部门收益额
   */
   private double departmentIncome;
   
   public double totalDepartmentIncome;
   
   /**
外部门结算付出
   */
   private double settlementOut;
   
   public double totalSettlementOut;
   
   /**
外部门结算收入
   */
   private double settlementIn;   
   
   public double totalSettlementIn;

   /**
工资
   */
   private double salary;   
   
   public double totalSalary;

   /**
旅差费
   */
   private double evectionCost;
   
   public double totalEventionCost;
 
   /**
通讯费
   */
   private double communicateCost; 
   
   public double totalCommunicateCost;  
   
   /**
招待费
   */
   private double serverCost;   
   
   public double totalServerCost;

   /**
办公费和其他
   */
   private double workCost;   
   
   public double totalWorkCost;
  
   /**
净利润额
   */
   private double profit;
   
   public double totalProfit;
   
   public int countNum;   
   
   /**
开始日期
   */
   public Timestamp beginDate;
   
   /**
结束日期
   */
   public Timestamp endDate;  
   
   private String whereClauseTemp="";
   
   private String department[];
   
   public String sql;


   public DepartmentFeeReport(){
	   numInOnePager = 10;  
   }
   
           
   public int loadAttr(){
       try{
	   	   departmentName = getRsString(rs,"deptName");
	   	   invoiceMoney = rs.getDouble("invoiceMoney");
	   	   saleCost = rs.getDouble("saleCost");
	   	   valueAddedTax = rs.getDouble("valueAddedTax");
	   	   transferCost = rs.getDouble("transferCost");
	   	   storeCost = rs.getDouble("storeCost");
	   	   intest = rs.getDouble("intest");
	   	   stamTax = rs.getDouble("stamTax"); 
	   	   otherCost = rs.getDouble("otherCost"); 
	   	   handinIncome = rs.getDouble("handinIncome");
	   	   departmentIncome = rs.getDouble("departmentIncome");
	   	   settlementOut = rs.getDouble("settlementOut");
	   	   settlementIn = rs.getDouble("settlementIn");
	   	   salary = rs.getDouble("salary");
	   	   evectionCost = rs.getDouble("evectionCost");
	   	   communicateCost = rs.getDouble("communicateCost");
	   	   serverCost = rs.getDouble("serverCost");
	   	   workCost = rs.getDouble("workCost");
	   	   profit = rs.getDouble("profit");
	   	   //countNum = rs.getInt("countNum");
	           return 1;
	   }catch(SQLException e){
			e.printStackTrace();
			System.out.println("query failed!");
			return -1;   
	    }		 
   }

    public int conditionSetup(javax.servlet.ServletRequest request) {
	String beginDaten;
	String beginDatey;
	String beginDater;	
	String endDaten;
	String endDatey;
	String endDater;
	whereClause="";	
	int yue;
	if((request.getParameter("beginDaten")!=null)&&(request.getParameter("beginDatey")!=null)&&(request.getParameter("beginDater")!=null)&&(!request.getParameter("beginDaten").equals(""))&&(!request.getParameter("beginDatey").equals(""))&&(!request.getParameter("beginDater").equals(""))){
		beginDaten = request.getParameter("beginDaten");
		beginDatey = request.getParameter("beginDatey");
		beginDater = request.getParameter("beginDater");
		beginDate=Timestamp.valueOf(beginDaten+"-"+beginDatey+"-"+beginDater+" 0:0:0.0");
	} else {
		yue = new Integer(getStringDate(getCurDate(),2)).intValue() - 1;
	        beginDatey = "" + yue;	
		beginDate = Timestamp.valueOf(getStringDate(getCurDate(),1)+"-"+beginDatey+"-"+getStringDate(getCurDate(),3)+" 0:0:0.0");		
	}		

	if((request.getParameter("endDaten")!=null)&&(request.getParameter("endDatey")!=null)&&(request.getParameter("endDater")!=null)&&(!request.getParameter("endDaten").equals(""))&&(!request.getParameter("endDatey").equals(""))&&(!request.getParameter("endDater").equals(""))){
		endDaten = request.getParameter("endDaten");
		endDatey = request.getParameter("endDatey");
		endDater = request.getParameter("endDater");
		endDate=Timestamp.valueOf(endDaten+"-"+endDatey+"-"+endDater+" 0:0:0.0");
	} else {
		endDate = getCurDate();	
	}
	if ((request.getParameterValues("department")!=null)&&(!request.getParameterValues("department").equals(""))) {
		department=request.getParameterValues("department");
		for (int i = 0; i < department.length; i++) {
			whereClause = orWhereClause(whereClause, "", "", "'", department[i]);
		}
       		whereClause=whereClause+ ")";
       		whereClause="deptId in (" + whereClause;
       		whereClauseTemp="department." + whereClause;
       	}		
		return 0;		
   }	    
   
   public String orWhereClause(String whereClause,   // 输入的已有的whereClause
    			String colName,        // 数据库的列名
    			String operator,       // 条件操作符号 >, < , like 
    			String fix,            // 引号 或 空 "'" , ""
    			String colValue) {     // 值
    	if( (colValue == null) || ( colValue.equals("")) )  // 未输入
		return whereClause;
    	if(fix.equals("'")){   // 字符型
		try {
	    		colValue = new String(colValue.getBytes("8859_1"));
		} catch(java.io.UnsupportedEncodingException e) {
			System.out.println("Baseservlet orWhereClause() : 编码不支持!!");
		}
	}
    	if( whereClause.equals("") == false) whereClause = whereClause + ",";
    	if(operator.equals("like"))
		whereClause = whereClause + fix + "%" + colValue + "%" + fix;
	else
		whereClause = whereClause + fix + colValue + fix;
    	return whereClause;
    }


	/**
    二级和算总表 
   */
   /*