package cn.handson.dao;

import java.util.Date;
import java.util.Iterator;
import java.util.List;

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

import cn.handson.base.*;
import cn.handson.utils.*;

public class ConstructDao {
	
	/*
	 * 此方法用來得到所有的施工表對(duì)象。。。
	 * 
	 * 
	 */
	
	public List getAllConstruct() {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
		Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		String sql="select b from Construct as b";
		Query query=session.createQuery(sql);
		List list=query.list();
		tx.commit();//提交事務(wù)
		//HibernateUtil.closeSession();
		return list;
		
	}
	
	/*
	 * 此方法用來得到所有constover=1的施工對(duì)象。。。。
	 * 
	 */
	
	public List getAll() {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
		Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		String sql="select b from Construct as b where b.constOver=1";
		Query query=session.createQuery(sql);
		List list=query.list();
		tx.commit();//提交事務(wù) 
		//HibernateUtil.closeSession();
		return list;
		
	}
	
	
	/*
	 * 此方法用來得到所有Emplyee=null的施工對(duì)象。。。。
	 * 
	 */
	
	public List getAllByemplyee() {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
		Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		String sql="select b from Construct as b where b.employee is null";
		Query query=session.createQuery(sql);
		List list=query.list();
		tx.commit();//提交事務(wù) 
		//HibernateUtil.closeSession();
		return list;
		
	}
	
	
	/*
	 * 此方法用來得到登陸用戶的所有任務(wù)。。包括故障，停機(jī)，施工。。。
	 * 
	 */
	
	public List getAllByEmployee(Employee user) {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
		Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		String sql="select b from Construct as b where b.constOver=1 and b.employee.employeeId="+user.getEmployeeId();
		Query query=session.createQuery(sql);
		List list=query.list();
		tx.commit();//提交事務(wù) 
		//HibernateUtil.closeSession();
		return list;
		
	}
	
	/*
	 * 此方法通過Userid來得到一個(gè)故障表的對(duì)象。。。
	 * 
	 */
	
	
	public List getAllbyuserid() {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
		Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		String sql="select b from Construct as b where b.user1.userId=1";
		Query query=session.createQuery(sql);
		List list=query.list();
		tx.commit();//提交事務(wù) 
		//HibernateUtil.closeSession();
		return list;
		
	}
	
	/*
	 * 此方法用來刪除施工表對(duì)象.....
	 * 
	 */
	public boolean deleteConstruct(Construct ct){
		Session session=HibernateUtil.currentSession();
		Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		session.delete(ct);
		tx.commit();//提交事務(wù)
		//HibernateUtil.closeSession();
		return true;
	}
	
	/*
	 * 此方法用來通過施工表ID來得到一個(gè)施工表的對(duì)象。。。
	 * 
	 * 
	 */
	
	public Construct getConstructById(Integer id) {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
        Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
        Construct ct=(Construct)session.get(Construct.class, id);
		tx.commit();//提交事務(wù)
		//HibernateUtil.closeSession();
		return ct;
	}
    
	/*
	 * 此方法用來更新數(shù)據(jù)庫(kù)中的施工表。。。
	 * 
	 */
	
	public void updateConstruct(Construct ct,Date wu) {
		// TODO Auto-generated method stub
		User1 hai=new User1();
		hai=ct.getUser1();
		hai.setUserType(new Integer(0));
		Session session=HibernateUtil.currentSession();
        Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
        Construct us=(Construct)session.get(Construct.class, ct.getConstId());
		us.setUser1(hai);
		us.setEmployee(ct.getEmployee());
		us.setType1(ct.getType1());
		us.setConstCause(ct.getConstCause());
		us.setConstDate(ct.getConstDate());
		us.setConstOverDate(wu);
		us.setConstFeedback(ct.getConstFeedback());
		us.setConstOver(new Integer(0));
		us.setConstRemark(ct.getConstRemark());
		session.save(us);
		tx.commit();//提交事務(wù)
		//HibernateUtil.closeSession();
	}
	
	
	/*
	 * 此方法用來更新數(shù)據(jù)庫(kù)中的施工表。。。
	 * 
	 */
	
	public void update(Construct ct) {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
        Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
        Construct us=(Construct)session.get(Construct.class, ct.getConstId());
		us.setUser1(ct.getUser1());
		us.setEmployee(ct.getEmployee());
		us.setType1(ct.getType1());
		us.setConstCause(ct.getConstCause());
		us.setConstDate(ct.getConstDate());
		us.setConstOverDate(ct.getConstOverDate());
		us.setConstFeedback(ct.getConstFeedback());
		us.setConstOver(ct.getConstOver());
		us.setConstRemark(ct.getConstRemark());
		session.save(us);
		tx.commit();//提交事務(wù)
		//HibernateUtil.closeSession();
	}
	
	
	/*
	 * 此方法用來添加施工表。。。。
	 * 
	 * 
	 */
	
	public void addConstruct(Construct ct) {
		// TODO Auto-generated method stub
		Session session=HibernateUtil.currentSession();
        Transaction tx=session.beginTransaction();//定義一個(gè)事務(wù) 
		session.save(ct);
		tx.commit();//提交事務(wù)
	//	HibernateUtil.closeSession();
		
	}
	
	

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		List list=new ConstructDao().getAllByemplyee();
		Iterator iter=list.iterator();
		while(iter.hasNext()){
			Construct aa=(Construct)iter.next();
			System.out.println(aa.getConstId());
			
		}
		/*
		Construct us=new Construct();
		us.setUser1(ct.getUser1());
		us.setType1(ct.getType1());
		us.setConstCause(ct.getConstCause());
		us.setConstDate(ct.getConstDate());
		us.setConstOver(ct.getConstOver());
		*/
	}

}