userbiz.java

实现用户关系管理系统

package org.jb.y2t308.team3.biz;

import java.util.List;

import org.jb.common.biz.BaseBiz;
import org.jb.common.util.PageResult;
import org.jb.y2t308.team3.entity.SysRole;
import org.jb.y2t308.team3.entity.SysUser;

/**
 * 用户管理业务逻辑类
 * 
 * @author hailong.liu
 */
public class UserBiz extends BaseBiz {

	@SuppressWarnings("unchecked")
	public boolean add(SysUser item) {
		List list = this.getCommonDAO().list(
				"from SysUser where usrName='" + item.getUsrName() + "'");
		if (list.size() > 0) {
			return false;
		}
		item.setUsrRole(null);
		this.getCommonDAO().add(item);
		return true;
	}

	/**
	 * 修改用户
	 */
	public boolean update(SysUser item) {
		// 先检查新用户名是否已经被使用
		List list = this.getCommonDAO().list(
				"select o from SysUser o where " + "o.usrId<> "
						+ item.getUsrId() + " and o.usrName = '"
						+ item.getUsrName() + "'");
		if (list.size() > 0) {
			return false;
		}
		if (item.getUsrRole().getRoleId() == null) {
			item.setUsrRole(null);
		}
		this.getCommonDAO().update(item);
		return true;
	}

	/**
	 * 分配角色
	 */
	@SuppressWarnings("unchecked")
	public boolean assignRole(SysUser item) {
		if (item.getUsrRole() == null || item.getUsrRole().getRoleId() == null) {
			return false;
		} else {

			Long usrId = item.getUsrId();
			Long roleId = item.getUsrRole().getRoleId();

			SysUser user = (SysUser) this.getCommonDAO().get(SysUser.class,
					usrId);

			SysRole role = (SysRole) this.getCommonDAO().get(SysRole.class,
					roleId);

			user.setUsrRole(role);
			//role.getUsers().add(user);

			this.getCommonDAO().update(user);
			return true;
		}
	}

	@SuppressWarnings("unchecked")
	public SysUser validateUser(SysUser item) {
		String hql = "from SysUser where usrName='" + item.getUsrName()
				+ "' and usrPassword='" + item.getUsrPassword() + "'";
		List listUser = this.getCommonDAO().list(hql);
		if (null != listUser && listUser.size() == 1) {
			return (SysUser) listUser.get(0);
		} else {
			return null;
		}
	}

	public SysUser getUserById(Long usrId) {
		return (SysUser) this.getCommonDAO().get(SysUser.class, usrId);
	}

	/**
	 * 查询用户列表
	 */
	@SuppressWarnings("unchecked")
	public void getList(SysUser item, PageResult pageResult) {
		String hql = "select o from SysUser o where 1=1 ";
		if (null != item) {
			if (isNotNullOrEmpty(item.getUsrName())) {
				hql += "and o.usrName like '%" + item.getUsrName() + "%' ";
			}
			if (item.getUsrFlag() != null && item.getUsrFlag() != -1) {
				hql += "and o.usrFlag = " + item.getUsrFlag() + " ";
			}
		}
		if (isNotNullOrEmpty(pageResult.getOrderBy())) {
			String sort = pageResult.getSort();
			hql += "order by " + pageResult.getOrderBy() + " " + sort;
			if ("asc".equals(sort)) {
				pageResult.setSort("desc");
			} else {
				pageResult.setSort("asc");
			}
		} else {
			hql += "order by o.usrId desc,o.usrName asc";
		}
		this.getCommonDAO().listByPage(hql, pageResult);
	}

	public void del(Long id) {
		SysUser item = (SysUser) this.getCommonDAO().get(SysUser.class, id);
		item.setUsrFlag(0);
		this.getCommonDAO().update(item);
	}
}