c0ec17f445ba001b1380e925f7497a16

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

package com.gensou.util;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;


import com.gensou.dao.sheji.order.OrderDao;
import com.gensou.dao.sheji.plan.PlanJDBC;
import com.gensou.hibernate.model.Bumengongzi;
import com.gensou.hibernate.model.Changpinxinxi;
import com.gensou.hibernate.model.Pejianmiddle;
import com.gensou.hibernate.model.Sucaixinxiguanlian;
import com.gensou.hibernate.model.Yuangonggongzi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.View.QueryViewService;
import com.gensou.logic.printService.BumengongziService;
import com.gensou.logic.printService.CaigouService;
import com.gensou.logic.printService.PrintSucai;
import com.gensou.logic.printService.PrintZuzuangtuziService;
import com.gensou.logic.printService.YuangongziService;
import com.gensou.logic.sheji.order.QueryOrderOneServive;

public class ServicePrint {
//	 private String path="/pdf/";
     public String printBumengongzi(String dateStr,String jr){
    	 List beanList=new ArrayList();
    	 Session session=HibernateSessionFactory.getSession();
    	 Query query=session.createQuery("from Bumengongzi where yuefen like ?");
    	 query.setString(0,dateStr+"%");
    	 List list=query.list();
    	 for(int i=0;i<list.size();i++){
    		 beanList.add(new BumengongziService((Bumengongzi) list.get(i)));
    	 }
    	 session.flush();
    	 session.clear();
    	 session.close();
    	 HashMap hm=new HashMap();
    	 hm.put("yuefen",dateStr);
    	 String jrxml="D:/jrxml/bumengongzi.jrxml";
    	 String filepath="/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
    	 Print.printb(beanList,hm,jrxml,jr+filepath,null,null);
    	 return filepath;
     }
     public String printYuangongzi(String dateStr,String jr){
    	 List beanList=new ArrayList();
    	 Session session=HibernateSessionFactory.getSession();
    	 Query query=session.createQuery("from Yuangonggongzi where yuefen like ?");
    	 query.setString(0,dateStr+"%");
    	 List list=query.list();
    	 for(int i=0;i<list.size();i++){
    		 beanList.add(new YuangongziService((Yuangonggongzi) list.get(i)));
    	 }
    	 session.flush();
    	 session.clear();
    	 session.close();
    	 HashMap hm=new HashMap();
    	 hm.put("yuefen",dateStr);
    	 String jrxml="D:/jrxml/gongzi.jrxml";
    	 String filepath="/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
    	 Print.printb(beanList,hm,jrxml,jr+filepath,null,null);
    	 return filepath;
     }
     
     public String printZuzuangtuzi (int id,String jr){
    	 List beanList = new ArrayList();
    	 Session session = HibernateSessionFactory.getSession();
    	 Changpinxinxi changpin = (Changpinxinxi)session.get(Changpinxinxi.class,new Integer(id));
    	 Query query = session.createQuery("from Pejianmiddle where changpinxinxi=?");
    	 query.setEntity(0,changpin);
    	 List list = query.list(); 
    	 for(int i=0;i<list.size();i++){
    		 Pejianmiddle middle = (Pejianmiddle) list.get(i);
    		 PrintZuzuangtuziService printZS = new PrintZuzuangtuziService();
    		 printZS.setPeijianxinxiId(middle.getPeijianxinxi().getPeijianxinxiId());
    		 printZS.setPinming(middle.getPeijianxinxi().getPinming());
    		 printZS.setCaizhi(middle.getPeijianxinxi().getCaizhi());
    		 printZS.setGuige(middle.getPeijianxinxi().getGuige());
    		 printZS.setBeizhu(middle.getPeijianxinxi().getBeizhu()!=null ? middle.getPeijianxinxi().getBeizhu() : " ");
    		 printZS.setNumber(middle.getNumber().toString());
    		 beanList.add(printZS);
    	 }
    	 
    	 HashMap hm = new HashMap();
    	 hm.put("changpinxinxiId",changpin.getChangpinxinxiId());
    	 hm.put("buyer",changpin.getBuyer());
    	 hm.put("zaizhongliang",changpin.getZaizhongliang());
    	 hm.put("model",changpin.getModel());
    	 hm.put("zhizouriqi",(new SimpleDateFormat("yyyy-MM-dd").format(changpin.getZhizuoriqi())));
    	 hm.put("tuzi",changpin.getZuzhuangtuzi().getTupianUri());
    	 
    	 session.flush();
    	 session.clear();
    	 session.close();
    	 String jrxml = "D:/jrxml/zuzuangtuzi.jrxml";
    	 String filepath="/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
    	 Print.printb(beanList,hm,jrxml,jr+filepath,null,null);
    	 return filepath;
     }
     
     public String printSucai (int id,String jr){
    	 List beanList = new ArrayList();
    	 List list = new ArrayList();
    	 Session session = HibernateSessionFactory.getSession();
    	 Changpinxinxi changpin = (Changpinxinxi)session.get(Changpinxinxi.class,new Integer(id));
    	 try{
    	 Query query = session.createQuery("from Sucaixinxiguanlian where changpinxinxi=?");
    	 query.setEntity(0,changpin);
    	 list = query.list();
    	 }catch(Exception e){
    		 e.printStackTrace();
    	 }
    	 for(int i=0;i<list.size();i++){
    		 Sucaixinxiguanlian sucaiguanlian = (Sucaixinxiguanlian) list.get(i);
    		 PrintSucai printSucai = new PrintSucai();
    		 printSucai.setQufen(sucaiguanlian.getQufen());
    		 printSucai.setBuhao(sucaiguanlian.getSucaixinxi().getBuguige());
    		 printSucai.setGeshu(sucaiguanlian.getSucaixinxi().getMeipiangeshu().toString());
    		 printSucai.setChangdu(sucaiguanlian.getSucaixinxi().getChangdu().toString());
    		 beanList.add(printSucai);
    	 }
    	 
    	 HashMap hm = new HashMap();
    	 hm.put("chanpinxinxi_id",changpin.getChangpinxinxiId());
    	 hm.put("buyer",changpin.getBuyer());
    	 hm.put("zaizhongliang",changpin.getZaizhongliang());
    	 hm.put("model",changpin.getModel());
    	 hm.put("zhizuoriqi",(new SimpleDateFormat("yyyy-MM-dd").format(changpin.getZhizuoriqi())));
    	 hm.put("imageurl",changpin.getSucaituzi().getSucaiUrl());
    	 
    	 session.flush();
    	 session.clear();
    	 session.close();
    	 String jrxml = "D:/jrxml/sucai.jrxml";
    	 String filepath="/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
    	 Print.printb(beanList,hm,jrxml,jr+filepath,null,null);
    	 return filepath;
     }
     
     public String prinCaigou (Integer id,int bili,String jr){
    	 List beanList = new ArrayList();
    	 PlanJDBC planJdbc = new PlanJDBC();
    	 List list = planJdbc.querysucaiplan(id, bili);
    	 for(int i=0;i<list.size();i++){
    		 QueryViewService queryViewService = (QueryViewService) list.get(i);
    		 CaigouService caigouService = new CaigouService();
    		 caigouService.setPinming(queryViewService.getPinming());
    		 caigouService.setGuige(queryViewService.getGuige());
    		 caigouService.setShuliang(queryViewService.getHeji()+"");
    		 beanList.add(caigouService);
    	 }
    	 String jrxml = "D:/jrxml/caigou_report_1.jrxml";
    	 String filepath = "/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
         Print.printb(beanList, null, jrxml, jr+filepath, null, null);
    	 return filepath;
     }
     public String printorder(Integer id,String jr){
    	OrderDao order=new OrderDao();
    	QueryOrderOneServive orderservice=order.queryorderone(id);
    	HashMap hash=new HashMap();
    	hash.put("clientname", orderservice.getClientName());
    	List list=order.printpartorder(id);
    	String jrxml = "D:/jrxml/dingdan_report_1.jrxml";
    	String filepath= "/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
    	 Print.printb(list, null, jrxml, jr+filepath, null, null);
		return filepath; 
     }
}