DeptService (service.impl)

package cn.et.food.service.impl;


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

import org.apache.ibatis.session.RowBounds;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.et.food.Tools.EPageTools;
import cn.et.food.dao.DeptMapper;
import cn.et.food.dao.EmpMapper;
import cn.et.food.entity.Dept;
import cn.et.food.entity.DeptExample;
import cn.et.food.entity.Emp;
import cn.et.food.entity.EmpExample;
import cn.et.food.entity.Student;
import cn.et.food.entity.TreeNode;
import cn.et.food.entity.EmpExample.Criteria;
import cn.et.food.service.DeptService;


@Service
public class DeptServiceImpl implements DeptService  {
	@Autowired
	DeptMapper dm;
	@Autowired
	EmpMapper em;
	/* (non-Javadoc)
	 * @see cn.et.food.service.impl.StudentService#queryStudent(java.lang.String)
	 */
	/* (non-Javadoc)
	 * @see cn.et.food.service.impl.deptService#queryTreeNode(java.lang.Integer)
	 */
	public List<TreeNode> queryTreeNode(Integer pid){
		DeptExample de=new DeptExample();
		de.createCriteria().andPidEqualTo(pid);
		List<Dept> dept=dm.selectByExample(de);
		List<TreeNode> deptList=new ArrayList<TreeNode>();
		for(Dept d:dept){
			TreeNode tn=new TreeNode();
			tn.setId(d.getId());
			tn.setText(d.getDname());
			// 判断当前节点是否还存在自节点
			if(queryTreeNode(d.getId()).size()==0){
				tn.setState("onpen");
			}
			deptList.add(tn);
		}
		return deptList;
	}
	public EPageTools queryEmp(Integer id,String sname,Integer page,Integer rows){
		EmpExample ee=new EmpExample();
		Criteria cr = ee.createCriteria();
		if(id!=null){
			 cr.andDeptidEqualTo(id);
		}
		if(sname !=null){
			cr.andEnameLike("%"+sname+"%");
		}
		
		int total=queryEmpCount(ee);
		//发起sql语句查询总记录数
		
		EPageTools p=new EPageTools(page, rows, total);
		RowBounds rb=new RowBounds(p.getStartIndex()-1, rows);
		List<Emp> empList=em.selectByExampleWithRowbounds(ee, rb);
		p.setRows(empList);
		return p;
	}
	public int queryEmpCount(EmpExample ee){
		int total=(int)em.countByExample(ee);
		return total;
	}
	public void deleteemp(Integer id){
		em.deleteByPrimaryKey(id);
	}
	public void updateEmp(Emp e){
		em.updateByPrimaryKey(e);
	}
	public void saveEmp(Emp e){
		em.insertSelective(e);
	}
}