orderdao.java

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

package com.gensou.dao.sheji.order;

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

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

import com.gensou.hibernate.model.Changpinxinxi;
import com.gensou.hibernate.model.Client;
import com.gensou.hibernate.model.Dingdantiaomu;
import com.gensou.hibernate.model.Dingdanxinxi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.printService.PrintOrderService;
import com.gensou.logic.sheji.client.UpdateclientService;
import com.gensou.logic.sheji.order.AddorderService;
import com.gensou.logic.sheji.order.AddorderentryService;
import com.gensou.logic.sheji.order.QueryOrderEntryService;
import com.gensou.logic.sheji.order.QueryOrderOneServive;
import com.gensou.logic.sheji.order.QueryOrderService;
import com.gensou.logic.sheji.order.UpdateOrderService;
import com.gensou.util.Pagination;

public class OrderDao {
	/**
	 * 
	 * @param addorderService
	 * @return bo
	 */
  public String addorder(AddorderService addorderService){
	  String bo="";
		Query query;
		List list;
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		Dingdanxinxi order=new Dingdanxinxi(); 
		String dingdanid=addorderService.getDingdanId();
		
	    query = (Query) session.createQuery("from Dingdanxinxi where dingdanId=?");
	    query.setString(0,dingdanid);
		list=query.list();
		if(!list.isEmpty()){
			return bo;
		}else{
			order.setDingdanId(dingdanid);
			order.setClientName(addorderService.getClientName());
			order.setXiadanshijian(addorderService.getXiadanshijian());
			order.setShoudanshijian(addorderService.getShoudanshijian());
		    order.setBeizhu(addorderService.getBeizhu());
		    order.setFahuodidian(addorderService.getFahuodidian());
		    order.setMudidi(addorderService.getMudidi());
		    order.setPiId(addorderService.getPiId());
		    order.setYinhangName(addorderService.getYinhangName());
		    order.setYinhangZhanghu(addorderService.getYinhangZhanghu());
		    order.setZhifufangshi(addorderService.getZhifufangshi());
		    order.setZhuangtai(addorderService.getZhuangtai());
		    try{
			session.save(order);
			session.flush();
			tx.commit();
		    }catch(Exception e){
		    	e.printStackTrace();
		    }
					
		
			query = (Query) session.createQuery("from Dingdanxinxi where dingdanId=?");
		    query.setString(0,dingdanid);
		    list=query.list();
		    if(!list.isEmpty()){
		    	 order=(Dingdanxinxi) list.get(0);
		    	 session.flush();
			     session.close();
		    	return bo=order.getId()+"";
		    }else{
		    	session.flush();
		    	session.close();
		    	return bo;
		    }
		}
		
	 }
	  /**
	   * 
	   * @param addorderentryService
	   * @return
	   */
  public List addorderentry(AddorderentryService addorderentryService){
			Query query;
			List lists;
			List list=new ArrayList();
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			Dingdanxinxi order=new Dingdanxinxi(); 
			Dingdantiaomu orderentry=new Dingdantiaomu();
			Integer id=addorderentryService.getId();
			order=(Dingdanxinxi) session.load(Dingdanxinxi.class, id);
			Changpinxinxi product=(Changpinxinxi)session.load(Changpinxinxi.class, addorderentryService.getProid());
			orderentry.setDanjia(addorderentryService.getDanjia());
			orderentry.setShuliang(addorderentryService.getShuliang());
			orderentry.setDingdanxinxi(order);
			orderentry.setChangpinxinxi(product);
			try{
			session.save(orderentry);
			session.flush();
			tx.commit();
			}catch(Exception e){
				tx.rollback();
				session.close();
				e.printStackTrace();
				 return list;
			}
			query = (Query) session.createQuery("from Dingdantiaomu where dingdanxinxi=?");
		    query.setEntity(0,order);
		    lists=query.list();
		    for(int i=0;i<lists.size();i++){
		    	AddorderentryService service=new AddorderentryService();
		    	orderentry=(Dingdantiaomu)lists.get(i);
		    	service.setDanjia(orderentry.getDanjia());
		    	service.setDingdantiaomuId(orderentry.getChangpinxinxi().getChangpinxinxiId());
		    	service.setMiaoshu(orderentry.getChangpinxinxi().getModel());
		    	service.setShuliang(orderentry.getShuliang());
		    	service.setId(order.getId());
		    	service.setTiaomuid(orderentry.getId());
		    	list.add(service);
		    }
		    session.flush();
		    session.close();
		    return list;
		    
		
		
	 }
	 
  public List queryorder(String way,String term,int pag,int max){
		List order_info = new ArrayList();
		Session session=HibernateSessionFactory.getSession();
		Query query;
		String ways;
		String terms;
		List list=new ArrayList();
		try{
			ways=way;
			terms=term;
			if(way==null||way.equals("")||terms==null||terms.equals("")){
				query = (Query) session.createQuery("from Dingdanxinxi");
				Pagination pagination=new Pagination();
				order_info=pagination.getNowlist(query,pag,max);
				if(!order_info.isEmpty()){
				for(int i=0;i<order_info.size();i++){
					Dingdanxinxi order=new Dingdanxinxi();
					order=(Dingdanxinxi)order_info.get(i);
					QueryOrderService queryorderService=new QueryOrderService();
					queryorderService.setClientName(order.getClientName());
					queryorderService.setDingdanId(order.getDingdanId());
					queryorderService.setId(order.getId());
					queryorderService.setMudidi(order.getMudidi());
					queryorderService.setShoudanshijian(order.getShoudanshijian());
					queryorderService.setXiadanshijian(order.getXiadanshijian());
					queryorderService.setZhuangtai(order.getZhuangtai());
					list.add(queryorderService);
				}
				}
			    
			}else{
				String name="%"+term+"%";
				query = (Query) session.createQuery("from Dingdanxinxi where "+ways+" like ?");
				query.setString(0,name);
				Pagination pagination=new Pagination();
				order_info=pagination.getNowlist(query,pag,max);
				if(!order_info.isEmpty()){
				for(int i=0;i<order_info.size();i++){
					Dingdanxinxi order=new Dingdanxinxi();
					order=(Dingdanxinxi)order_info.get(i);
					QueryOrderService queryorderService=new QueryOrderService();
					queryorderService.setClientName(order.getClientName());
					queryorderService.setDingdanId(order.getDingdanId());
					queryorderService.setId(order.getId());
					queryorderService.setMudidi(order.getMudidi());
					queryorderService.setShoudanshijian(order.getShoudanshijian());
					queryorderService.setXiadanshijian(order.getXiadanshijian());
					queryorderService.setZhuangtai(order.getZhuangtai());
					list.add(queryorderService);
				}
				}
			}
		}catch(NullPointerException e){}
		session.flush();
	    session.close();
		return list; 
	 }
  
  public QueryOrderOneServive queryorderone(Integer id){
	  Session session=HibernateSessionFactory.getSession();
	  Dingdanxinxi dingdan=new Dingdanxinxi();
	  dingdan=(Dingdanxinxi)session.load(Dingdanxinxi.class, id);
	  QueryOrderOneServive queryone=new QueryOrderOneServive(dingdan);
	return queryone;
	  
  }
  
  public boolean updateorder(UpdateOrderService updateorder){
		 boolean bo=false;
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 
		 try{
			Dingdanxinxi diandan=new Dingdanxinxi();
			Integer id=updateorder.getId();
			diandan=(Dingdanxinxi)session.load(Dingdanxinxi.class, id);
			diandan.setClientName(updateorder.getClientName());
			diandan.setFahuodidian(updateorder.getFahuodidian());
			diandan.setMudidi(updateorder.getMudidi());
			diandan.setPiId(updateorder.getPiId());
			diandan.setShoudanshijian(updateorder.getShoudanshijian());
			diandan.setXiadanshijian(updateorder.getXiadanshijian());
			diandan.setYinhangName(updateorder.getYinhangName());
			diandan.setYinhangZhanghu(updateorder.getYinhangZhanghu());
			diandan.setZhifufangshi(updateorder.getZhifufangshi());
			diandan.setBeizhu(updateorder.getBeizhu());
			session.update(diandan);
			 session.flush();
			tx.commit();
			
			  session.close();
			bo=true;
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
			 return bo;
		 }
		 return bo; 
	 }
  public QueryOrderEntryService queryorderentry(Integer id){
	  Session session=HibernateSessionFactory.getSession();
	  Dingdanxinxi dingdan=new Dingdanxinxi();
	  List lists;
	  List list = new ArrayList();
	  Query query;
	  dingdan=(Dingdanxinxi) session.load(Dingdanxinxi.class, id);
	  query=session.createQuery("from Dingdantiaomu where dingdanxinxi=?");
	  lists=query.setEntity(0,dingdan).list();
	  if(!lists.isEmpty()){
		  for(int i=0;i<lists.size();i++){
		  Dingdantiaomu dingdatiaomu=new Dingdantiaomu();
		  dingdatiaomu=(Dingdantiaomu) lists.get(i);
		  AddorderentryService service = new AddorderentryService();
		  service.setDanjia(dingdatiaomu.getDanjia());
		  service.setDingdantiaomuId(dingdatiaomu.getChangpinxinxi().getChangpinxinxiId());
		  service.setId(dingdatiaomu.getId());
		  service.setMiaoshu(dingdatiaomu.getChangpinxinxi().getModel());
		  service.setShuliang(dingdatiaomu.getShuliang());
		  list.add(service);
	   }
	  }
	  QueryOrderEntryService queryOrderEntryService=new QueryOrderEntryService(dingdan,list);
	  session.flush();
	  session.close();
	  return queryOrderEntryService;  
  }
  
  public List querypartorder(Integer id){
	  Session session=HibernateSessionFactory.getSession();
	  Dingdanxinxi dingdan=(Dingdanxinxi)session.load(Dingdanxinxi.class,id);
	  List lists;
	  List list=new ArrayList();
	  Query query;
	  query=session.createQuery("from Dingdantiaomu where dingdanxinxi=?");
	  query.setEntity(0,dingdan);
	  lists=query.list();
	  if(!lists.isEmpty()){
		  Dingdantiaomu orderentry=new Dingdantiaomu();
		  for(int i=0;i<lists.size();i++){
		    	AddorderentryService service=new AddorderentryService();
		    	orderentry=(Dingdantiaomu)lists.get(i);
		    	service.setDanjia(orderentry.getDanjia());
		    	service.setDingdantiaomuId(orderentry.getChangpinxinxi().getChangpinxinxiId());
		    	service.setMiaoshu(orderentry.getChangpinxinxi().getModel());
		    	service.setShuliang(orderentry.getShuliang());
		    	service.setId(id);
		    	service.setTiaomuid(orderentry.getId());
		    	list.add(service);
		    }
	  }
	  session.flush();
	  session.close();
	  return list;
  }
  
  public List deleteorder(Integer id,Integer oid){
	  Session session=HibernateSessionFactory.getSession();
	  Transaction tx=session.beginTransaction();
	  List list=new ArrayList();
	  Dingdantiaomu dingdantiaomu;
	  dingdantiaomu=(Dingdantiaomu)session.load(Dingdantiaomu.class, id);
	  try{
	  session.delete(dingdantiaomu);
	  session.flush();
	  tx.commit();
	  session.close();
	  OrderDao orderDao=new OrderDao();
	  list=orderDao.querypter(oid);
	  }catch(Exception e){
		  tx.rollback();
		  session.close();
		  return list;
	  }
	  return list;
	}
  public List querypter(Integer id){
	  Session session=HibernateSessionFactory.getSession();
	    Query query;
	    List lists;
		List list=new ArrayList();
	    Dingdanxinxi order=new Dingdanxinxi(); 
	    order=(Dingdanxinxi)session.load(Dingdanxinxi.class, id);
		Dingdantiaomu orderentry=new Dingdantiaomu();
	    query = (Query) session.createQuery("from Dingdantiaomu where dingdanxinxi=?");
	    query.setEntity(0,order);
	    lists=query.list();
	    for(int i=0;i<lists.size();i++){
	    	AddorderentryService service=new AddorderentryService();
	    	orderentry=(Dingdantiaomu)lists.get(i);
	    	service.setDanjia(orderentry.getDanjia());
	    	service.setDingdantiaomuId(orderentry.getChangpinxinxi().getChangpinxinxiId());
	    	service.setMiaoshu(orderentry.getChangpinxinxi().getChangpinxinxiId());
	    	service.setShuliang(orderentry.getShuliang());
	    	service.setId(order.getId());
	    	service.setTiaomuid(orderentry.getId());
	    	list.add(service);
	    }
	    session.flush();
	    session.close();
	  return list;
  }
  public List printpartorder(Integer id){
	  Session session=HibernateSessionFactory.getSession();
	  Dingdanxinxi dingdan=(Dingdanxinxi)session.load(Dingdanxinxi.class,id);
	  List lists;
	  List list=new ArrayList();
	  Query query;
	  query=session.createQuery("from Dingdantiaomu where dingdanxinxi=?");
	  query.setEntity(0,dingdan);
	  lists=query.list();
	  if(!lists.isEmpty()){
		  Dingdantiaomu orderentry=new Dingdantiaomu();
		  for(int i=0;i<lists.size();i++){
			  PrintOrderService service=new PrintOrderService();
		    	orderentry=(Dingdantiaomu)lists.get(i);
		    	service.setDanjia(orderentry.getDanjia());
		    	service.setChangpinxinxiid(orderentry.getChangpinxinxi().getChangpinxinxiId());
		    	service.setModel(orderentry.getChangpinxinxi().getModel());
		    	service.setShuliang(orderentry.getShuliang());
		    	list.add(service);
		    }
	  }
	  session.flush();
	  session.close();
	  return list;
  }
}