package com.hxzk.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzk.deo.TbDaohangs;
|
import com.hxzk.pojo.TbDaohang;
|
import com.hxzk.pojo.TbDaohangEnglish;
|
import com.hxzk.pojo.TbDaohangEnglishUser;
|
import com.hxzk.pojo.TbDaohangUser;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
|
public interface DaoHangDao extends BaseMapper<TbDaohang> {
|
@Update("update tb_daohang set ishow = '0' where parents = #{parents}")
|
public void upDaoHangIshow(Integer parents);
|
|
@Select("SELECT * FROM tb_daohang WHERE parent > 0 ORDER BY parent ASC")
|
public List<TbDaohang> findTest1();
|
|
@Select("select * from tb_daohang where parents = #{parents}")
|
public List<TbDaohang> findTest2(String parents);
|
|
|
@Select("select * from tb_daohang_user where parents = #{parents} and username = #{username}")
|
public List<TbDaohangUser> findTest3(@Param("parents") String parents, @Param("username")String username);
|
|
|
|
@Select("select * from tb_daohang_english where parent > 0")
|
public List<TbDaohangEnglish> findTestEnglish1();
|
|
@Select("select * from tb_daohang_english where parents = #{parents}")
|
public List<TbDaohangEnglish> findTestEnglish2(String parents);
|
|
|
@Select("select * from tb_daohang_english_user where parents = #{parents} and username = #{username}")
|
public List<TbDaohangEnglishUser> findTestEnglish3(@Param("parents") String parents, @Param("username")String username);
|
|
|
|
@Select("select * from tb_daohang_user where username = #{username}")
|
public List<TbDaohang> find1(String username);
|
|
@Select("select * from tb_daohang_user where level = '1' and ishow = '1' and username = #{username}")
|
public List<TbDaohang> find2(String username);
|
|
@Select("select * from tb_daohang_english_user where username = #{username}")
|
public List<TbDaohangEnglish> findEnglish1(String username);
|
|
@Select("select * from tb_daohang_english_user where level = '1' and ishow = '1' and username = #{username}")
|
public List<TbDaohangEnglish> findEnglish2(String username);
|
|
@Select("select * from tb_daohang_user where parents = #{parents} and ishow = '1' and username = #{username}")
|
public List<TbDaohang> find3(@Param("parents")String parents,@Param("username")String username);
|
|
@Select("select * from tb_daohang_english_user where parents = #{parents} and ishow = '1' and username = #{username}")
|
public List<TbDaohang> findEnglish3(@Param("parents")String parents,@Param("username")String username);
|
|
@Update("update tb_daohang_user set icon = #{icon} where name = #{name} ")
|
void upDaoHangUser(TbDaohangUser daohangUser);
|
|
@Update("update tb_daohang set icon = #{icon},name = #{name},ishow = #{ishow} where id = #{id} ")
|
void upDaoHang(TbDaohangs daohangs);
|
}
|
