deptdao.java

JAVA实现的中小型企业CRM客户关系管理系统

package com.crm.dept;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.crm.common.Page;
import com.crm.dao.CommonDAO;
import com.crm.dept.po.Dept;

public class DeptDAO extends CommonDAO implements IDeptDAO {

	public boolean addDept(Dept dept) {
		this.getSqlMapClientTemplate().insert("Dept.insertDept", dept);
		return true;
	}

	public List getDeptList() {
		List list = this.getSqlMapClientTemplate().queryForList("Dept.getDeptList", null);
		return list;
	}
	public List getDeptList(Dept dept,HttpServletRequest request){
		Page page = new Page();
		
		
		//获取当前页
		int currentPage = page.getCurrentPage(request);
		//读取总记录数
		Integer count = (Integer)this.getSqlMapClientTemplate().queryForObject("Dept.getDeptListCount",dept);
		page.setRscount(count.intValue());
		//计算总页数
		int pagecout = page.getPageCount();
		
		
		
		int pagesize = page.getPagesize();
		
		//生成显示tool 
		String pagetool = page.pagetool(request.getRequestURI()+page.getParams(request));
		request.setAttribute("pagetool",pagetool);

		List list =  this.getSqlMapClientTemplate().queryForList("Dept.getDeptList",dept,(currentPage-1)*pagesize,pagesize);
//	System.out.println("list.size="+list.size());
		return list;
		//
	}
	public boolean updateDept(Dept dept) {
		this.getSqlMapClientTemplate().update("Dept.updateDept", dept);
		return true;
	}
	public Dept getDeptDetail(Integer id){
		return (Dept) this.getSqlMapClientTemplate().queryForObject("Dept.getDeptDetail", id);
	}

}