treeviewdao.java

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

package com.yuanchung.organize.treeview;

import java.util.List;

import com.yuanchung.sales.exception.SystemException;
import com.yuanchung.sales.model.Position;
import com.yuanchung.sales.model.Treeview;
import com.yuanchung.sales.model.admin.position.UserPosition;
import com.yuanchung.sales.model.user.User;

public interface TreeviewDAO {
	//根据主键查找
	public Treeview findByParentId(int parentID) throws SystemException;
	//根据父结点取得树
	public List getAllTreeByParentId(int parentId) throws SystemException;
	//根据主键查找结点
	public Treeview findById(int id) throws SystemException;
	//根据树结点查找用户
	public List getUserByTreeview(Treeview treeview) throws SystemException;
	//根据用户查找岗位
	public UserPosition getUserPositionByUser(User user) throws SystemException;
	//保存岗位
	public void addPosition(Position position)throws SystemException;
	//根据岗位名称模糊查找
	public List findPositionLike(int treeviewId, String positionName)throws SystemException;
	//根据部门查找岗位
	public List getPositionByDeptId(int deptId, int isLeader)throws SystemException;
	//根据岗位ID查找岗位
	public Position getPositionById(int positionId)throws SystemException;
	//更新用户---岗位
	public void updateUserPosition(UserPosition userPosition)throws SystemException;
	//根据用户和岗位查找用户---岗位
	public UserPosition getUserPositionByUserAndPosition(User user)throws SystemException;
	//根据ID查找用户
	public User getUserById(int userId)throws SystemException;
	//更新用户
	public void updateUser(User user)throws SystemException;
	//根据岗位查找用户
	public User getUserByPosition(Position position)throws SystemException;
	
	//更新节点
	public void updateTreeview(Treeview treeview)throws SystemException;
	//新增组织
	public void saveTreeview(Treeview treeview) throws SystemException;
	//删除节点
	public void deleteTreeview(Treeview treeview)throws SystemException;
	//查找所有的部门
	public List<Treeview> getTreeViewToDept() throws SystemException;
	//根据子节点ID查找父节点
	public Treeview getParentByChild(int childNodeId)throws SystemException ;
	//根据部门ID和岗位ID查找节点
	public Treeview findTreeviewByDeptIdAndPositionName(int deptId, String positionName) throws SystemException ;
	//根据姓名查找用户
	public List getUserByFamilyName(String familyName) throws SystemException;
	//根据节点和姓名查找用户
	public List getUserByTreeviewAndName(Treeview treeview, String familyName) throws SystemException ;
	//根据部门ID和岗位名称查找唯一岗位
	public Position findPositionByNameAndDeptId(String positionName, int deptId)throws SystemException ;
	//删除岗位
	public void deleteUser(User user) throws SystemException ;
	//更新岗位名称
	public void updatePosition(Position position) throws SystemException ;
	//根据父部门节点ID查找所有子部门节点
	public List<Treeview> getSubDeptByParentId(int parentId) throws SystemException ;
	
	public List<Treeview> findChildIdsByParentId(int parentId);
	
	//搜索出所有有效的用户
	public List<TreeviewVo> findAllUser() throws SystemException;
	
	public List<Treeview> findTreeViewByDeptID(int deptID) throws SystemException;
	
	public List<Treeview> findByDeptIDAndPositionName(int deptID,String positionName) throws SystemException;
	
	public List<Treeview> findByAllPara(int deptID,String positionName,String familyName) throws SystemException;
	
	public List<Treeview> findByDeptIDAndFamilyName(int deptID,String familyName) throws SystemException;
	
	
	
}