package com.hxzk.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzk.deo.HangJingPerSon;
|
import com.hxzk.pojo.TbHjperson;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
public interface HjPersonDao extends BaseMapper<TbHjperson> {
|
@Select("select id,chejianname as treeName, fenchangid as pid from tb_hjchejian where fenchangid = #{id} order by id desc")
|
public List<HangJingPerSon> findAllCheJian(Integer id);
|
|
@Select("select id,fenchangname as treeName from tb_hjfenchang")
|
public List<HangJingPerSon> findAllFenChang();
|
|
@Select("select id,bumenname as treeName,chejianid as pid from tb_hjbumen where chejianid = #{id}")
|
public List<HangJingPerSon> findAllBuMen(Integer id);
|
|
@Select("select id,name as treeName,phone,zhiwu,caozuo,xuanze from tb_hjperson where chejianname = #{chejianid} and fenchangname = #{fenchangid}")
|
public List<HangJingPerSon> findHangJinPerSon(@Param("chejianid") Integer chejianid, @Param("fenchangid")Integer fenchangid);
|
|
@Select("select id,chejianname as treeName from tb_hjchejian where fenchangid = #{fenchangid}")
|
public List<HangJingPerSon> findchejian(int fenchangid);
|
|
@Select("select id,fenchangname as treeName from tb_hjfenchang")
|
public List<HangJingPerSon> findfenchang();
|
|
@Select("select id,bumenname as treeName from tb_hjbumen where chejianid = #{chejianid}")
|
public List<HangJingPerSon> findbumen(int chejianid);
|
}
|
