userdao.java

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

package com.crm.user;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.crm.common.Page;
import com.crm.dao.CommonDAO;
import com.crm.user.po.UserInfo;

public class UserDAO extends CommonDAO implements IUserDAO{


	public List getUserList(UserInfo userinfo){
		List list =  this.getSqlMapClientTemplate().queryForList("User.selectuserlist",userinfo);
//		System.out.println("list.size="+list.size());
			return list;
		
	}
	public List getUserList(UserInfo userinfo,HttpServletRequest request){
		Page page = new Page();
		
		
		//获取当前页
		int currentPage = page.getCurrentPage(request);
		//读取总记录数
		Integer count = (Integer)this.getSqlMapClientTemplate().queryForObject("User.selectusercount",userinfo);
		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("User.selectuserlist",userinfo,(currentPage-1)*pagesize,pagesize);
//	System.out.println("list.size="+list.size());
		return list;
		//
	}
/**
 * 
 */	
	public boolean addUser(UserInfo userinfo){
		this.getSqlMapClientTemplate().insert("User.insertuser", userinfo);
		return true;
	}
	public boolean deleteUser(String userid){
		this.getSqlMapClientTemplate().delete("User.deleteuser", userid);
		return true;
	}	
	public boolean updateUser(UserInfo userinfo){
		this.getSqlMapClientTemplate().update("User.updateuser", userinfo);
		return true;
	}
	public boolean updatePasswd(UserInfo userinfo){
		this.getSqlMapClientTemplate().update("User.updatepasswd", userinfo);
		return true;
	}		
	public List getSubItemList(String id){
		return this.getSqlMapClientTemplate().queryForList("User.getsubitem",id);
	}
	public UserInfo getUserInfo(String sId){
		return (UserInfo)this.getSqlMapClientTemplate().queryForObject("User.selectuser", sId); 
	}	
	public boolean modifypost(String sId,String spost, String sOtherId){
		this.getJdbcTemplate().update("update employee set post='"+spost+"' where id="+sId);
		if(!"".equals(sOtherId)){
			this.getJdbcTemplate().update("update cust_info set employee_id="+sOtherId+" where employee_id="+sId);
		}
		return true;
	}
}