carfreequery.java

办公自动化项目

package com.t60.oa.service.car;

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

import com.t60.oa.po.Car;
import com.t60.oa.web.car.FreeCarQueryForm;
import hong.javanet.dao.HibernateUtil;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.hibernate.criterion.Projections;
import org.hibernate.Transaction;
import org.hibernate.Query;
import com.t60.oa.po.Apply;
public class CarFreeQuery {
    private FreeCarQueryForm form= new FreeCarQueryForm();
    private List result;
    private String message;

    private int pageIndex;
    private int pageSize= 3;
    private boolean needCount;

    private int rowCount;
    private int pageCount;

    private Integer applyId;
    public void carFreeQuery()
    {
        Session session= HibernateUtil.currentSession();
        Criteria criCar=session.createCriteria(Car.class);
        if(form.getCar_num().trim().toString()!=null && form.getCar_num().trim().toString().length()>0 )
        {
            String num=form.getCar_num();
            //criCar.add(Restrictions.like("数据库的持久类的属性名",表单中的字段名));
            criCar.add(Restrictions.like("num","%"+num+"%"));
        }
        if(form.getCar_state().trim().toString()!=null &&form.getCar_state().trim().toString().length()>0)
        {
            String state=form.getCar_state();
            criCar.add(Restrictions.eq("state",state));
        }
        if(form.getCar_type().trim().toString()!=null && form.getCar_type().trim().toString().length()>0)
        {
            String type= form.getCar_type();
            criCar.add(Restrictions.eq("type",type));
        }

        criCar.setMaxResults(this.pageSize);
        criCar.setFirstResult((this.pageIndex-1)*this.pageSize);
        this.result=criCar.list();

        if(this.needCount)
        {
            criCar.setProjection(Projections.rowCount());
            //criCar.uniqueResult是指
            this.rowCount=((Integer)criCar.uniqueResult()).intValue();
            this.pageCount=(this.rowCount-1)/this.pageSize+1;
        }


        Iterator iter = result.iterator();
        while (iter.hasNext()) {
            Car item = (Car) iter.next();
            org.hibernate.Hibernate.initialize(item);
        }
        HibernateUtil.closeSession();
    }

    public void state()
    {
        Session session = HibernateUtil.currentSession();
        Apply apply = (Apply)session.load(Apply.class,this.getApplyId());
        if(apply.getState()=="空闲")
        {
            sendCar();
        }
        else
        {
            return ;
        }
    }
    public void sendCar()
    {
        Session session = HibernateUtil.currentSession();
        String [] carNum =form.getSelectCar();
        int length = carNum.length;
        System.out.println("carNum长度:-->"+length);
        System.out.println("carNum[0]:-->"+carNum[0]);
        Car [] car= new Car[length];
//        Query query = session.createQuery("update Car set state='使用中' where num in :carNum");
//        query.setParameterList("carNum",carNum);
//        query.executeUpdate();
        //Transaction tran = session.beginTransaction();
        for (int i=0;i<length;i++)
        {
            car[i] =(Car)session.load(Car.class,carNum[i]);
            car[i].setState("使用中");
            session.saveOrUpdate(car[i]);
            System.out.println("Car["+i+"]"+car[i].getState());
         //   tran.commit();
        }
        Apply apply = (Apply)session.load(Apply.class,this.getApplyId());
        apply.setState("已派车");
        session.saveOrUpdate(apply);
       // HibernateUtil.closeSession();
    }
    public void noCar()
    {

    }
    public FreeCarQueryForm getForm() {
        return form;
    }

    public String getMessage() {
        return message;
    }

    public List getResult() {
        return result;
    }

    public boolean isNeedCount() {
        return needCount;
    }

    public int getPageCount() {
        return pageCount;
    }

    public int getPageIndex() {
        return pageIndex;
    }

    public int getPageSize() {
        return pageSize;
    }

    public int getRowCount() {
        return rowCount;
    }

    public Integer getApplyId() {
        return applyId;
    }

    public void setResult(List result) {
        this.result = result;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public void setForm(FreeCarQueryForm form) {
        this.form = form;
    }

    public void setRowCount(int rowCount) {
        this.rowCount = rowCount;
    }

    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    public void setPageIndex(int pageIndex) {
        this.pageIndex = pageIndex;
    }

    public void setPageCount(int pageCount) {
        this.pageCount = pageCount;
    }

    public void setNeedCount(boolean needCount) {
        this.needCount = needCount;
    }

    public void setApplyId(Integer applyId) {
        this.applyId = applyId;
    }

}