package com.wgc.dao;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.metamodel.source.MetadataImplementor;
import org.hibernate.metamodel.source.internal.SessionFactoryBuilderImpl;
import org.springframework.stereotype.Repository;

import com.wgc.entity.Dept;
import com.wgc.util.PageModel;
import com.wgc.util.SessionFactoryUtil;

@Repository("deptDao")
public class DeptDaoImpl extends SessionFactoryUtil implements DeptDao {


	@Override
	public Integer findCount() {
		Session session = this.sessionFactory.getCurrentSession();
		String sql = "select count(*) from Dept d";
		//return (Integer) session.createQuery(sql).uniqueResult();
		//数据库返回是长整形,需要转换
		Long count = (Long) session.createQuery(sql).uniqueResult();
		//intValue(),输出int数据。
		//用于浮点型表示去掉小数点
		return count.intValue();
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Dept> selectDeptPage(PageModel pageModel) {
		Session session = this.sessionFactory.getCurrentSession();
		String sql = "select d from Dept d";
		return session.createQuery(sql)
				//开始数量
				.setFirstResult((pageModel.getPageIndex()-1)*pageModel.getPageSize())
				//每页显示数量
				.setMaxResults(pageModel.getPageSize())
				.list();
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Dept> selectDeptByName(PageModel pageModel,String name) {
		Session session = this.sessionFactory.getCurrentSession();
		String sql = "select d from Dept d where d.name like '%"+name+"%'";
		System.out.println(sql.toString());
		return session.createQuery(sql)
				//开始数量
				.setFirstResult((pageModel.getPageIndex()-1)*pageModel.getPageSize())
				//每页显示数量
				.setMaxResults(pageModel.getPageSize())
				.list();
	}

	@Override
	public Integer findCountByName(String name) {
		Session session = this.sessionFactory.getCurrentSession();
		String sql = "select count(*) from Dept d where d.name like '%"+name+"%'";
		//return (Integer) session.createQuery(sql).uniqueResult();
		//数据库返回是长整形,需要转换
		Long count = (Long) session.createQuery(sql).uniqueResult();
		System.out.println("kk>>>>>>"+count);
		//intValue(),输出int数据。
		//用于浮点型表示去掉小数点
		return count.intValue();
	}

	//添加
	@Override
	public void addDept(Dept dept) {
		Session session = this.sessionFactory.getCurrentSession();
		session.persist(dept);
	}
	/****************修改*******************/
	@Override
	public Dept getDeptId(Integer id) {
		return (Dept) this.sessionFactory.getCurrentSession().get(Dept.class, id);
	}

	@Override
	public void updateDept(Dept dept) {
		this.sessionFactory.getCurrentSession().update(dept);
	}
	/****************修改*******************/
}