barquerydata.java

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

package cn.bway.foreigntrade.report;

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

import org.hibernate.Criteria;
import org.hibernate.criterion.Expression;

import cn.bway.common.BwayHibernateException;
import cn.bway.common.dao.BaseDAOHibernate;
import cn.bway.common.vo.PageListVO;
import cn.bway.foreigntrade.order.exportclient.model.Exportclient;
import cn.bway.foreigntrade.order.exportproduct.impl.ExportproductManagerFactory;
import cn.bway.foreigntrade.order.exportproduct.model.Exportproduct;
import cn.bway.foreigntrade.order.guestorder.model.Guestorder;
import cn.bway.foreigntrade.order.orderproduct.impl.OrderproductManagerFactory;
import cn.bway.foreigntrade.order.orderproduct.model.Orderproduct;
import cn.bway.foreigntrade.order.producenote.model.Producenote;
import cn.bway.foreigntrade.order.produceproduct.impl.ProduceproductManagerFactory;
import cn.bway.foreigntrade.order.produceproduct.model.Produceproduct;
import cn.bway.foreigntrade.repertory.buydocument.model.Buydocument;
import cn.bway.foreigntrade.repertory.buyproduct.impl.BuyproductManagerFactory;
import cn.bway.foreigntrade.repertory.buyproduct.model.Buyproduct;
import cn.bway.foreigntrade.repertory.cancel.document.model.Canceldocument;
import cn.bway.foreigntrade.repertory.cancel.product.impl.CancelproductManagerFactory;
import cn.bway.foreigntrade.repertory.cancel.product.model.Cancelproduct;
import cn.bway.foreigntrade.repertory.incasement.document.model.Incasementdocument;
import cn.bway.foreigntrade.repertory.incasement.product.impl.IncasementproductManagerFactory;
import cn.bway.foreigntrade.repertory.incasement.product.model.Incasementproduct;
import cn.bway.foreigntrade.repertory.instore.document.model.Instoredocument;
import cn.bway.foreigntrade.repertory.instore.product.impl.InstoreproductManagerFactory;
import cn.bway.foreigntrade.repertory.instore.product.model.Instoreproduct;
import cn.bway.foreigntrade.repertory.outstore.document.model.Outstoredocument;
import cn.bway.foreigntrade.repertory.outstore.product.impl.OutstoreproductManagerFactory;
import cn.bway.foreigntrade.repertory.outstore.product.model.Outstoreproduct;
import cn.bway.foreigntrade.repertory.sample.document.model.Sampledocument;
import cn.bway.foreigntrade.repertory.sample.product.impl.SampleproductManagerFactory;
import cn.bway.foreigntrade.repertory.sample.product.model.Sampleproduct;

public class BarQuerydata extends BaseDAOHibernate{
	//询价产品统计
	public Integer exportclient(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Exportclient client=new Exportclient();
		Criteria criteria=session.createCriteria(Exportclient.class);
		criteria.add(Expression.ge("Dates",begin));
		criteria.add(Expression.le("Dates",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Exportclient) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Exportproduct product=new Exportproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) ExportproductManagerFactory.getExportproductManager().getAllExportproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Exportproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}	
//		System.out.println(sum+"--------------------");
		return sum;
	}
	
//	订单产品统计
	public Integer guestorder(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Guestorder client=new Guestorder();
		Criteria criteria=session.createCriteria(Guestorder.class);
		criteria.add(Expression.ge("times",begin));
		criteria.add(Expression.le("times",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Guestorder) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Orderproduct product=new Orderproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) OrderproductManagerFactory.getOrderproductManager().getAllOrderproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Orderproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}
	public static void main(String[] args) {
		Integer sum=new BarQuerydata().guestorder("2008-01-1","2008-02-1");
//		System.out.println(sum+"...........................");
	}
	
//	生产产品统计
	public Integer producenote(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Producenote client=new Producenote();
		Criteria criteria=session.createCriteria(Producenote.class);
		criteria.add(Expression.ge("confirmtime",begin));
		criteria.add(Expression.le("confirmtime",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Producenote) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Produceproduct product=new Produceproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) ProduceproductManagerFactory.getProduceproductManager().getAllProducenoteproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Produceproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getTotals());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
//				System.out.println(client.getId()+"============="+sum);
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}
	//采购产品统计
	public Integer buydocument(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Buydocument client=new Buydocument();
		Criteria criteria=session.createCriteria(Buydocument.class);
		criteria.add(Expression.ge("times",begin));
		criteria.add(Expression.le("times",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Buydocument) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Buyproduct product=new Buyproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) BuyproductManagerFactory.getBuyproductManager().getAllBuyproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Buyproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getTotals());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
//				System.out.println(client.getId()+"============="+sum);
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}

	//入库产品统计
	public Integer instoredocument(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Instoredocument client=new Instoredocument();
		Criteria criteria=session.createCriteria(Instoredocument.class);
		criteria.add(Expression.ge("intime",begin));
		criteria.add(Expression.le("intime",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Instoredocument) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Instoreproduct product=new Instoreproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) InstoreproductManagerFactory.getInstoreproductManager().getAllInstoreproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Instoreproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}
	//出库产品统计
	public Integer outstoredocument(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Outstoredocument client=new Outstoredocument();
		Criteria criteria=session.createCriteria(Outstoredocument.class);
		criteria.add(Expression.ge("outtime",begin));
		criteria.add(Expression.le("outtime",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Outstoredocument) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Outstoreproduct product=new Outstoreproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) OutstoreproductManagerFactory.getOutstoreproductManager().getAllOutstoreproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Outstoreproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}	
//		System.out.println(sum+"--------------------");		
		return sum;
	}

	//装箱产品统计
	public Integer incasementdocument(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Incasementdocument client=new Incasementdocument();
		Criteria criteria=session.createCriteria(Incasementdocument.class);
		criteria.add(Expression.ge("numbers",begin));
		criteria.add(Expression.le("numbers",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Incasementdocument) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Incasementproduct product=new Incasementproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) IncasementproductManagerFactory.getIncasementproductManager().getAllIncaseproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Incasementproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}
	//样品产品统计
	public Integer sampledocument(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Sampledocument client=new Sampledocument();
		Criteria criteria=session.createCriteria(Sampledocument.class);
		criteria.add(Expression.ge("times",begin));
		criteria.add(Expression.le("times",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Sampledocument) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Sampleproduct product=new Sampleproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) SampleproductManagerFactory.getSampleproductManager().getAllSampleproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Sampleproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}

	//退货产品统计
	public Integer canceldocument(String begin,String end){
		Integer sum = 0;
		session=currentSession();
		Canceldocument client=new Canceldocument();
		Criteria criteria=session.createCriteria(Canceldocument.class);
		criteria.add(Expression.ge("times",begin));
		criteria.add(Expression.le("times",end));
		List list=criteria.list();
		for(int i=0;i<list.size();i++){
			//得到单据ID
			client=(Canceldocument) list.get(i);
//			System.out.println(client.getDates()+"------------------------"+client.getId());
			PageListVO rvo = new PageListVO();
			Cancelproduct product=new Cancelproduct();
			try {
				//根据单据ID，得到数量
				rvo=(PageListVO) CancelproductManagerFactory.getCancelproductManager().getAllCancelproduct(client.getId());				
				ArrayList ListResult = (ArrayList) rvo.getretVO();
				for(int p=0;p<ListResult.size();p++){
					product=(Cancelproduct) ListResult.get(p);
					sum=sum+Integer.parseInt(product.getNumbers());
//					System.out.println(client.getId()+"============="+ListResult.size()+"============="+product.getNumbers());
				}
			} catch (BwayHibernateException e) {
				e.printStackTrace();
			}
		}		
//		System.out.println(sum+"--------------------");	
		return sum;
	}
}