package com.sxl.daoImpl;

import java.sql.SQLException;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.HibernateException;

import org.hibernate.Session;

import org.springframework.orm.hibernate3.HibernateCallback;

import org.springframework.orm.hibernate3.HibernateTemplate;

import com.sun.istack.internal.FinalArrayList;

import com.sxl.dao.ComputRoomDao;

import com.sxl.pojos.TComputroom;

public class ComputRoomDaoImpl implements ComputRoomDao {

    private HibernateTemplate template;

    public HibernateTemplate getTemplate() {

        return template;

    }

    public void setTemplate(HibernateTemplate template) {

        this.template = template;

    }

    public List<TComputroom> findAll() {

        // TODO Auto-generated method stub

        List<TComputroom> ls=template.find("from TComputroom");

        return ls;

    }

    public List<TComputroom> findByCondition(TComputroom tc) {

        // TODO Auto-generated method stub

        return null;

    }

    public boolean addComputRoom(TComputroom tc) {

        // TODO Auto-generated method stub

        template.save(tc);

        return true;

    }

    public boolean updateComputRoom(TComputroom tc) {

        // TODO Auto-generated method stub

        //……

        return false;

    }

    public boolean delComputRoom(TComputroom tc) {

        // TODO Auto-generated method stub

        TComputroom tc2=template.load(TComputroom.class, tc.getCrId());

        template.delete(tc2);

        return true;

    }

    public List<TComputroom> getPage(final int page,final int rows) {

        // TODO Auto-generated method stub

        List<TComputroom> ls=template.execute(new HibernateCallback<List>() {

            public List doInHibernate(Session session)

                    throws HibernateException, SQLException {

                // TODO Auto-generated method stub

                Query query=session.createQuery("from TComputRoom order by cr_id");

                query.setFirstResult((page-1)*rows);

                query.setMaxResults(rows);

                return query.list();

            }

        });

        return ls;

    }

    public int getAllrows() {

        // TODO Auto-generated method stub

        List<TComputroom> ls=template.find("from TComputRoom");

        int allrows = ls.size();

        System.out.println(allrows);

        return allrows;

    }

    public List<TComputroom> pageTComputroom(final int page,final int rows,

            final String searchid,final String searchname) {

        // TODO Auto-generated method stub

        String HQL=null;

        if (!searchid.equals("")&&!searchname.equals("")) {

            HQL = "from TComputroom where cr_id ='"+searchid+"' cr_name like '"+searchname+"%' order by cr_id";

        }

        if (!searchname.equals("")&&searchid.equals("")) {

            HQL="from TComputroom where cr_name like '%"+searchname+"%' order by cr_id";

        }

        if (!searchid.equals("")&&searchname.equals("")) {

            HQL="from TComputroom where cr_id='"+searchid+"' order by cr_id";

        }

        if (searchid.equals("")&&searchname.equals("")) {

            HQL="from TComputroom order by cr_id";

        }

        final String h=HQL;

        List<TComputroom> ls=template.execute(new HibernateCallback<List>() {

            public List doInHibernate(Session session)

                    throws HibernateException, SQLException {

                // TODO Auto-generated method stub

                Query query=session.createQuery(h);

                query.setFirstResult((page-1)*rows);

                query.setMaxResults(rows);

                return query.list();

            }

        });

        return ls;

    }

    public int getAllrows(String searchid, String searchname) {

        // TODO Auto-generated method stub

        String HQL=null;

        if (!searchid.equals("")&&!searchname.equals("")) {

            HQL="from TComputroom where cr_id='"+searchid+"'and cr_name like'%"+searchname+"%' order by cr_id";

        }

        if (!searchname.equals("")&&searchid.equals("")) {

            HQL="from TComputroom where cr_name ='"+searchname+"' order by cr_id";

        }

        if (searchname.equals("")&&!searchid.equals("")) {

            HQL="from TComputroom where cr_id ='"+searchid+"' order by cr_id";

        }

        if (searchname.equals("")&&searchid.equals("")) {

            HQL="from TComputroom  order by cr_id";

        }

        List<TComputroom> ls=template.find(HQL);

        int allrows =ls.size();

        System.out.println(allrows);

         return allrows;

    }

}