treeviewmgr.java

基于Sturts+Spring+Hibernate的一个高级销售管理系统。内容丰富

	
	/**
	 * 
	 * @param treeview
	 * @param tempPath
	 * @return
	 * @throws SystemException
	 */
	public String getParentByChild(Treeview treeview, StringBuffer tempPath)
			throws SystemException {
		// StringBuffer tempPath = new StringBuffer(nodePath);
		try {
			Treeview parentNode = treeviewDao.getParentByChild(treeview
					.getParentId());
			// System.out.println("��ǰ�ڵ㸸ID" + parentNode.getParentId());
			if (parentNode != null && parentNode.getParentId().equals(30)) {// ���Ǹ�ڵ�
				tempPath.insert(0, parentNode.getName() + "/");
				System.out.println("����·����" + tempPath);
			} else if (parentNode != null
					&& !parentNode.getParentId().equals(30)) {// ���Ǹ�ڵ�
				tempPath.insert(0, parentNode.getName() + "/");
				System.out.println("������·����" + tempPath);
				getParentByChild(parentNode, tempPath);// �ݹ����
			} else {
				return tempPath.toString();
			}
			System.out.println("����·��1...��" + tempPath.toString());
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("����·��2...��" + tempPath.toString());
		return tempPath.toString();
	}

	/*
	 * public List<TreeviewVo> getTreeviewVo(String deptName, String deptId,
	 * String positionName, String familyName)throws SystemException{ Treeview
	 * treeview = null;
	 * 
	 * //如果只选择部门 // if(StringTool.isNotBlank(deptId)){ // //��ݲ���ID�͸�λ��Ʋ��ҽڵ� //
	 * treeview = findTreeviewByDeptIdAndPosition(deptId); //
	 * logger.debug("这个值是aaaaaa："+treeview); // } //如果选择了部门和岗位
	 * if(StringTool.isNotBlank(deptId) && StringTool.isNotBlank(positionName)){
	 * treeview = findTreeviewByDeptIdAndPosition(deptId, positionName);
	 * logger.debug("选择了部门和岗位："+treeview); } List userList = null; if(treeview ==
	 * null){//��ڵ�Ϊ�� userList = treeviewDao.getUserByFamilyName(familyName);
	 * logger.debug("bbbbbbbbbbbbbbbbbbbb:"+userList.get(0)); }else{
	 * if(StringTool.isNotBlank(familyName)){ userList =
	 * treeviewDao.getUserByTreeviewAndName(treeview, familyName);
	 * logger.debug("ccccccccc"); logger.debug("�������"+userList); }else{
	 * userList = treeviewDao.getUserByTreeview(treeview);
	 * logger.debug("dddddddd"); }
	 *  } User user = null; List<TreeviewVo> treeviews = new ArrayList<TreeviewVo>();
	 * for(Object o : userList){ user = (User)o; treeviews.add(new
	 * TreeviewVo(user.getId(), user.getUserName(), user.getPassword(),
	 * user.getFamilyName(), user.getPosition(), user.getEmail(),
	 * user.getPhone(), user.getType(), user.getTreeview().getId(),
	 * user.getIsDeptLead(), deptName)); } logger.debug("eeeeeeeeeee"); return
	 * treeviews; }
	 */
    
	
	
	public List<TreeviewVo> getTreeviewVo(String deptName, String deptId,
			String positionName, String familyName) throws SystemException {

		Treeview treeview = null;
		List<TreeviewVo> treeviews = new ArrayList<TreeviewVo>();
		List userList = null;
		User user = null;
		
//		int position = Integer.valueOf(positionName).intValue();

		// 如果什么条件都没输入     这个步骤不存在了  因为页面上已经过滤掉“查询条件不能什么都没输入”
//		if (!StringTool.isNotBlank(deptId) && positionName.equals("0")
//				&& !StringTool.isNotBlank(familyName)) {
//			treeviews = treeviewDao.findAllUser();
//		}

		// 如果条件只有一个部门
		if (StringTool.isNotBlank(deptId) && positionName.equals("0")
				&& !StringTool.isNotBlank(familyName)) {
			List<Treeview> tvList = null;
			List<User> uList = null;
			tvList = treeviewDao.findTreeViewByDeptID(Integer.parseInt(deptId));
			logger.debug("--tvList这个值是多少？？--:" + tvList.size());
			for (int i = 0; i < tvList.size(); i++) {

				logger.debug("开始执行。。。。。。");
				int treeViewID = tvList.get(i).getId();
				uList = userDao.findByTreeviewId(treeViewID);
				for (int m = 0; m < uList.size(); m++) {
					TreeviewVo tvVO = null;
					tvVO = new TreeviewVo();
					tvVO.setUserId(uList.get(m).getId());
					tvVO.setUserName(uList.get(m).getUserName());
					tvVO.setPassword(uList.get(m).getPassword());
					tvVO.setFamilyName(uList.get(m).getFamilyName());
					tvVO.setPosition(uList.get(m).getPosition());
					tvVO.setEmail(uList.get(m).getEmail());
					tvVO.setPhone(uList.get(m).getPhone());
					tvVO.setType(uList.get(m).getType());
					tvVO.setTreeviewId(uList.get(m).getTreeview().getId());
					tvVO.setIsDeptLead(uList.get(m).getIsDeptLead());
					String department = userDao.getDepartmentName(uList.get(m).getId());
					tvVO.setDepartment(department);
					treeviews.add(tvVO);
				}
				logger.debug("1234");
			}

		}
		
		//如果条件为部门和岗位
		if (StringTool.isNotBlank(deptId) && !positionName.equals("0")
				&& !StringTool.isNotBlank(familyName)) {
			List<Treeview> tvList = null;
			List<User> uList = null;
			tvList = treeviewDao.findByDeptIDAndPositionName(Integer.parseInt(deptId),positionName);
			for (int i = 0; i < tvList.size(); i++) {

				logger.debug("开始执行。。。。。。");
				int treeViewID = tvList.get(i).getId();
				uList = userDao.findByTreeviewId(treeViewID);
				for (int m = 0; m < uList.size(); m++) {
					TreeviewVo tvVO = null;
					tvVO = new TreeviewVo();
					tvVO.setUserId(uList.get(m).getId());
					tvVO.setUserName(uList.get(m).getUserName());
					tvVO.setPassword(uList.get(m).getPassword());
					tvVO.setFamilyName(uList.get(m).getFamilyName());
					tvVO.setPosition(uList.get(m).getPosition());
					tvVO.setEmail(uList.get(m).getEmail());
					tvVO.setPhone(uList.get(m).getPhone());
					tvVO.setType(uList.get(m).getType());
					tvVO.setTreeviewId(uList.get(m).getTreeview().getId());
					tvVO.setIsDeptLead(uList.get(m).getIsDeptLead());
					String department = userDao.getDepartmentName(uList.get(m).getId());
					tvVO.setDepartment(department);
					treeviews.add(tvVO);
				}
			}
		}
		
		//如果条件为部门和岗位和姓名
		if (StringTool.isNotBlank(deptId) && !positionName.equals("0")
				&& StringTool.isNotBlank(familyName)) {
			List<Treeview> tvList = null;
			List<User> uList = null;
			tvList = treeviewDao.findByAllPara(Integer.parseInt(deptId),positionName,familyName);
			for (int i = 0; i < tvList.size(); i++) {
				logger.debug("开始执行。。。。。。");
				int treeViewID = tvList.get(i).getId();
				logger.debug("--googogogog--:"+treeViewID);
				uList = userDao.findByTreeviewIdAndFamilyName(treeViewID,familyName);
				logger.debug("----叽叽歪歪---："+uList.size());
				for (int m = 0; m < uList.size(); m++) {
					TreeviewVo tvVO = null;
					tvVO = new TreeviewVo();
					tvVO.setUserId(uList.get(m).getId());
					tvVO.setUserName(uList.get(m).getUserName());
					tvVO.setPassword(uList.get(m).getPassword());
					tvVO.setFamilyName(uList.get(m).getFamilyName());
					tvVO.setPosition(uList.get(m).getPosition());
					tvVO.setEmail(uList.get(m).getEmail());
					tvVO.setPhone(uList.get(m).getPhone());
					tvVO.setType(uList.get(m).getType());
					tvVO.setTreeviewId(uList.get(m).getTreeview().getId());
					tvVO.setIsDeptLead(uList.get(m).getIsDeptLead());
					String department = userDao.getDepartmentName(uList.get(m).getId());
					tvVO.setDepartment(department);
					treeviews.add(tvVO);
				}
			}
		}
		
		//如果条件只有部门和姓名
		
		if (StringTool.isNotBlank(deptId) && positionName.equals("0")
				&& StringTool.isNotBlank(familyName)) {
			List<Treeview> tvList = null;
			List<User> uList = null;
			tvList = treeviewDao.findByDeptIDAndFamilyName(Integer.parseInt(deptId),familyName);
			for (int i = 0; i < tvList.size(); i++) {
				logger.debug("开始执行。。。。。。");
				int treeViewID = tvList.get(i).getId();
				logger.debug("--googogogog--:"+treeViewID);
				uList = userDao.findByTreeviewIdAndFamilyName(treeViewID,familyName);
				logger.debug("----叽叽歪歪---："+uList.size());
				for (int m = 0; m < uList.size(); m++) {
					TreeviewVo tvVO = null;
					tvVO = new TreeviewVo();
					tvVO.setUserId(uList.get(m).getId());
					tvVO.setUserName(uList.get(m).getUserName());
					tvVO.setPassword(uList.get(m).getPassword());
					tvVO.setFamilyName(uList.get(m).getFamilyName());
					tvVO.setPosition(uList.get(m).getPosition());
					tvVO.setEmail(uList.get(m).getEmail());
					tvVO.setPhone(uList.get(m).getPhone());
					tvVO.setType(uList.get(m).getType());
					tvVO.setTreeviewId(uList.get(m).getTreeview().getId());
					tvVO.setIsDeptLead(uList.get(m).getIsDeptLead());
					String department = userDao.getDepartmentName(uList.get(m).getId());
					tvVO.setDepartment(department);
					treeviews.add(tvVO);
				}
			}
		}

		// for(Object o : userList){
		// user = (User)o;
		// treeviews.add(new TreeviewVo(user.getId(), user.getUserName(),
		// user.getPassword(), user.getFamilyName(), user.getPosition(),
		// user.getEmail(), user.getPhone(), user.getType(),
		// user.getTreeview().getId(),
		// user.getIsDeptLead(), deptName));
		// }

		return treeviews;
	}

	// �
	public Treeview findTreeviewByDeptIdAndPosition(String deptId,
			String positionName) {
		logger.debug("--deptId--:"+deptId);
		logger.debug("--positionName--:"+positionName);
		Treeview tv =  null;
		try {
			//如果deptId和positionName不为空
			if(deptId != null && !"".equals(deptId) && positionName != null && !"0".equals(positionName)){
				tv = treeviewDao.findTreeviewByDeptIdAndPositionName(Integer
					.parseInt(deptId), positionName);
			}
			if(positionName == null || positionName.equals("0")){
				tv = treeviewDao.findById(Integer.parseInt(deptId));
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
		return tv;
	}

	// 删除用户
	public void deleteUser(String userId) throws SystemException {
		try {
			User user = treeviewDao.getUserById(Integer.parseInt(userId));
			treeviewDao.deleteUser(user);
		} catch (Exception e) {
			e.printStackTrace();
			logger.error(Constants.DELETEUSEREXCEPTION);
			throw new SystemException(Constants.DELETEUSEREXCEPTION);
		}
	}

	/**
	 * 根据ID查找记录
	 * 
	 * @param Integer
	 *            treeviewId
	 * @return Treeview treeview
	 * @throws SystemException
	 */
	public static Treeview findById(Integer treeviewId) throws SystemException {
		//
		Treeview treeview = new Treeview();
		try {

			treeview = treeviewDao.findById(treeviewId);

		} catch (RuntimeException re) {
			re.printStackTrace();
			throw new SystemException("数据库异常!");
		}
		return treeview;
	}

	/**
	 * 根据父节点ID查找所有子节点ID
	 * 
	 * @param parentId
	 * @return
	 * @throws SystemException
	 */
	public static List<Treeview> findChildIdsByParentId(
			List<Treeview> treeViewIds, int parentId) throws SystemException {
		//
		List<Treeview> ids = treeViewIds;

		try {

			List<Treeview> treeViews = treeviewDao
					.findChildIdsByParentId(parentId);
			for (int i = 0; i < treeViews.size(); i++) {
				Treeview t = treeViews.get(i);
				// treeview数据表里 isLeader为标志,值为0代表部门,值为1和2代表岗位
				if (t.getIsLeader() == 1 || t.getIsLeader() == 2) {
					ids.add(t);
				} else {
					findChildIdsByParentId(ids, t.getId());
				}
			}
		} catch (RuntimeException re) {
			re.printStackTrace();
			throw new SystemException("数据库异常!");
		}
		return ids;
	}

	/**
	 * 根据部门id查找其子下的岗位 author：张明强 time：2008-01-19
	 * 
	 * @param deptID
	 * @return
	 * @throws SystemException
	 */
	public static List<Treeview> findTreeviewByDeptID(int deptID)
			throws SystemException {

		List<Treeview> tv = null;

		try {
			tv = treeviewDao.findChildIdsByParentId(deptID);
		} catch (RuntimeException re) {
			re.printStackTrace();
			throw new SystemException("数据库异常!");
		}
		return tv;
	}

	public List<PositionVo> getPositionsByDept(int deptId, int isLeader)
			throws SystemException {
		try {
			List<PositionVo> positionVos = new ArrayList<PositionVo>();
			// 根据部门查找岗位
			List positions = treeviewDao.getPositionByDeptId(deptId, isLeader);
			if (positions != null) {
				// 遍历所有的部门
				for (Object o : positions) {
					Treeview treeview = (Treeview) o;
					positionVos.add(new PositionVo(treeview.getId(), treeview
							.getName()));
				}
			}
			return positionVos;
		} catch (Exception e) {
			e.printStackTrace();
			throw new SystemException("");
		}
	}

}