package com.fgkj.mapper.impl;
|
|
import java.util.List;
|
|
import com.fgkj.dto.User_inf;
|
import com.fgkj.dto.User_permitgroup;
|
import com.fgkj.dto.User_permitgroup_data;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
public interface User_permitgroup_dataMapper{
|
|
//5.2添加(给权限组添加用户)
|
public boolean add(Object obj) ;
|
//5.2添加(给权限组添加用户)(多用户)
|
@Insert("insert into db_user.tb_user_permitgroup_data(permit_group_id,uId) values(#{permit_group_id},#{uId})")
|
public int addPro(User_permitgroup_data obj) ;
|
|
public boolean update(Object obj) ;
|
//5.2删除(给权限组删除用户)
|
@Delete("delete from db_user.tb_user_permitgroup_data where num=#{num}")
|
public int del(User_permitgroup_data obj) ;
|
//5.2删除(删除权限组时将在tb_user_permitgroup_data表中所有permit_group_id删除)
|
@Delete("delete from db_user.tb_user_permitgroup_data where permit_group_id=#{permit_group_id}")
|
public int delPermitId(User_permitgroup obj) ;
|
|
public List searchAll() ;
|
|
public List serchByCondition(Object obj) ;
|
|
//5.2查询不存在权限组中的用户
|
@Select("select distinct(tb_user_inf.uid),tb_user_inf.uname from db_user.tb_user_inf,db_user.tb_user_permitgroup_data " +
|
"where tb_user_inf.uid not in(select distinct(db_user.tb_user_permitgroup_data.uid) from db_user.tb_user_permitgroup_data where tb_user_permitgroup_data.permit_group_id=#{permit_group_id}) " +
|
"and tb_user_inf.uid!=1002 ")
|
public List<User_inf> serchByInfo(User_permitgroup_data obj) ;
|
|
}
|
