bargetvalues.java

这是本人曾经在公司里用的,内部开发框架,基于struts+hibernate今天分享给大家

package cn.bway.foreigntrade.report;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BarGetValues {
	public Integer[] sum=staple.sum;
	public static Integer str[] = null;
	//询价产品统计
	public Integer[] getExport(String years,String month){
		sum[0]=new BarQuerydata().exportclient(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().exportclient(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().exportclient(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().exportclient(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().exportclient(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().exportclient(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().exportclient(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().exportclient(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().exportclient(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().exportclient(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().exportclient(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().exportclient(years+"-12-01",years+"-12-31");
		return sum;
	}
	//订单产品统计
	public Integer[] guestorder(String years,String month){
		sum[0]=new BarQuerydata().guestorder(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().guestorder(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().guestorder(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().guestorder(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().guestorder(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().guestorder(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().guestorder(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().guestorder(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().guestorder(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().guestorder(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().guestorder(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().guestorder(years+"-12-01",years+"-12-31");
		return sum;
	}

	//生产产品统计
	public Integer[] producenote(String years,String month){
		sum[0]=new BarQuerydata().producenote(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().producenote(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().producenote(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().producenote(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().producenote(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().producenote(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().producenote(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().producenote(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().producenote(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().producenote(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().producenote(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().producenote(years+"-12-01",years+"-12-31");
		return sum;
	}

	//生产产品统计
	public Integer[] buydocument(String years,String month){
		sum[0]=new BarQuerydata().buydocument(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().buydocument(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().buydocument(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().buydocument(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().buydocument(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().buydocument(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().buydocument(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().buydocument(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().buydocument(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().buydocument(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().buydocument(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().buydocument(years+"-12-01",years+"-12-31");
		return sum;
	}

	//入库产品统计
	public Integer[] instoredocument(String years,String month){
		sum[0]=new BarQuerydata().instoredocument(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().instoredocument(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().instoredocument(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().instoredocument(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().instoredocument(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().instoredocument(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().instoredocument(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().instoredocument(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().instoredocument(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().instoredocument(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().instoredocument(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().instoredocument(years+"-12-01",years+"-12-31");
		return sum;
	}
	//出库产品统计
	public Integer[] outstoredocument(String years,String month){
		sum[0]=new BarQuerydata().outstoredocument(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().outstoredocument(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().outstoredocument(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().outstoredocument(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().outstoredocument(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().outstoredocument(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().outstoredocument(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().outstoredocument(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().outstoredocument(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().outstoredocument(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().outstoredocument(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().outstoredocument(years+"-12-01",years+"-12-31");
		return sum;
	}
	//装箱产品统计
	public Integer[] incasementdocument(String years,String month){
		sum[0]=new BarQuerydata().incasementdocument(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().incasementdocument(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().incasementdocument(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().incasementdocument(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().incasementdocument(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().incasementdocument(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().incasementdocument(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().incasementdocument(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().incasementdocument(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().incasementdocument(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().incasementdocument(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().incasementdocument(years+"-12-01",years+"-12-31");
		return sum;
	}
	//样品产品统计
	public Integer[] sampledocument(String years,String month){
		sum[0]=new BarQuerydata().sampledocument(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().sampledocument(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().sampledocument(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().sampledocument(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().sampledocument(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().sampledocument(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().sampledocument(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().sampledocument(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().sampledocument(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().sampledocument(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().sampledocument(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().sampledocument(years+"-12-01",years+"-12-31");
		return sum;
	}
	//退货产品统计
	public Integer[] canceldocument(String years,String month){
		sum[0]=new BarQuerydata().canceldocument(years+"-01-01",years+"-01-31");
		sum[1]=new BarQuerydata().canceldocument(years+"-02-01",years+"-02-31");
		sum[2]=new BarQuerydata().canceldocument(years+"-03-01",years+"-03-31");
		sum[3]=new BarQuerydata().canceldocument(years+"-04-01",years+"-04-31");
		sum[4]=new BarQuerydata().canceldocument(years+"-05-01",years+"-05-31");
		sum[5]=new BarQuerydata().canceldocument(years+"-06-01",years+"-06-31");
		sum[6]=new BarQuerydata().canceldocument(years+"-07-01",years+"-07-31");
		sum[7]=new BarQuerydata().canceldocument(years+"-08-01",years+"-08-31");
		sum[8]=new BarQuerydata().canceldocument(years+"-09-01",years+"-09-31");
		sum[9]=new BarQuerydata().canceldocument(years+"-10-01",years+"-10-31");
		sum[10]=new BarQuerydata().canceldocument(years+"-11-01",years+"-11-31");
		sum[11]=new BarQuerydata().canceldocument(years+"-12-01",years+"-12-31");
		return sum;
	}

	
	public List getCount(String years,String Month){
		Date date=new Date();
		Integer[] sumcount=new Integer[12];
		if(null==years||"".equals(years)||"null".equals(years)){//默认为当年
			years=""+(date.getYear()+1900);
		}
		if(null==Month||"".equals(Month)||"null".equals(Month)){//默认为当年
			Month="all";
		}
		List list=new ArrayList();
		if("all".equals(Month)){//如果没选择月份
			list=new BarGetValues().getAllMonth(sumcount,years);
		}else{//已经选择月份
			if(Month.length()==1){//小于10月份执行
				Month="0"+Month;
				sumcount[0]=new BarQuerydata().exportclient(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[1]=new BarQuerydata().guestorder(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[2]=new BarQuerydata().producenote(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[3]=new BarQuerydata().buydocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[4]=new BarQuerydata().instoredocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[5]=new BarQuerydata().outstoredocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[6]=new BarQuerydata().incasementdocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[7]=new BarQuerydata().sampledocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[8]=new BarQuerydata().canceldocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				for(int y=0;y<=8;y++){
					System.out.println(sumcount[y]+"`````````````````````````````");
				}
				System.out.println("以上是第"+Month+"月:数据======"+years+"-"+Month+"-01"+"              "+years+"-"+Month+"-31");
			}else{//大于10月份,执行
				sumcount[0]=new BarQuerydata().exportclient(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[1]=new BarQuerydata().guestorder(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[2]=new BarQuerydata().producenote(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[3]=new BarQuerydata().buydocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[4]=new BarQuerydata().instoredocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[5]=new BarQuerydata().outstoredocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[6]=new BarQuerydata().incasementdocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[7]=new BarQuerydata().sampledocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[8]=new BarQuerydata().canceldocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				for(int y=0;y<=8;y++){
					System.out.println(sumcount[y]+"`````````````````````````````");
				}
				System.out.println("以上是第"+Month+"月:数据======"+years+"-"+Month+"-01"+"              "+years+"-"+Month+"-31");
			}
			list.add(sumcount.toString());
		}
		return list;
	}
	
	public List getAllMonth(Integer sumcount[],String years){//如果没有选择月份,则查询所有
		List list=new ArrayList();
		String Month="";
		Integer sum[] =staple.sum;
		for(int s=0;s<=8;s++){
			sum[s]=null;
		}
		for(int i=1;i<=12;i++){
			
			Month=""+i;
			if(Month.length()==1){//小于10月份执行
				Month="0"+i;
				sumcount[0]=new BarQuerydata().exportclient(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[1]=new BarQuerydata().guestorder(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[2]=new BarQuerydata().producenote(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[3]=new BarQuerydata().buydocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[4]=new BarQuerydata().instoredocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[5]=new BarQuerydata().outstoredocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[6]=new BarQuerydata().incasementdocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[7]=new BarQuerydata().sampledocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				sumcount[8]=new BarQuerydata().canceldocument(years+"-"+Month+"-01", years+"-"+Month+"-31");
				for(int y=0;y<=8;y++){
					sum[y]=sumcount[y];
					System.out.println(sumcount[y]+"`````````````````````````````");
				}

//				list.add(sum);
				System.out.println("以上是第"+i+"月:数据======"+years+"-"+Month+"-01"+"              "+years+"-"+Month+"-31");
			}else{//大于10月份,执行
				sumcount[0]=new BarQuerydata().exportclient(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[1]=new BarQuerydata().guestorder(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[2]=new BarQuerydata().producenote(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[3]=new BarQuerydata().buydocument(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[4]=new BarQuerydata().instoredocument(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[5]=new BarQuerydata().outstoredocument(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[6]=new BarQuerydata().incasementdocument(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[7]=new BarQuerydata().sampledocument(years+"-"+i+"-01", years+"-"+i+"-31");
				sumcount[8]=new BarQuerydata().canceldocument(years+"-"+i+"-01", years+"-"+i+"-31");
				for(int y=0;y<=8;y++){
				sum[y]=sumcount[y];
					System.out.println(sumcount[y]+"`````````````````````````````");
				}
				System.out.println("以上是第"+i+"月:数据======"+years+"-"+i+"-01"+"              "+years+"-"+i+"-31");
			}

			list.add(sum);
		}
		return list;
	}
	public static void main(String[] args) {
		List list=new BarGetValues().getCount("2008", "8");
		
		for(int i=0;i<list.size();i++){
			Integer[] in=(Integer[]) list.get(i);
			for(int y=0;y<i;y++){
				System.out.println(in[y]+"==================================");
			}
			System.out.println("以上是"+(i+1)+"数据:");
		}		
		
		
	}
}