update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

 src/main/java/com/fgkj/mapper/impl/CustompageMapper.java

@@ -2,25 +2,40 @@

import java.util.List;

import com.fgkj.dto.Custompage;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

public interface CustompageMapper {

    //页面定制下添加导航或者子页面
   public boolean add(Object obj);
   @Insert("insert into web_site.tb_custompage(navigate,navigate_order,submenu,subflag,sublink,subenable,subname,subjudge,page_order) " +
         "values(#{navigate},#{navigate_order},#{submenu},#{subflag},#{sublink},#{subenable},#{subname},#{subjudge},#{page_order})")
   public int add(Custompage obj);

    //页面定制可以看到的子菜单和子模块
   public boolean update(Object obj);
   @Update("update web_site.tb_custompage set subflag=#{subflag} where num=#{num} ")
   public int update(Custompage obj);

   //页面定制修改主导航下子页面的顺序
   public boolean updateOrder(Object obj);
   @Update("update web_site.tb_custompage set page_order=#{page_order} where num=#{num} ")
   public int updateOrder(Custompage obj);
    
   public boolean del(Object obj);
   
    //查询所有的菜单(页面定制可以看到的子菜单和子模块)
   public List searchAll() ;
   @Select("select num,navigate,navigate_order,submenu,subflag,sublink,page_order, subenable,subname,subjudge from web_site.tb_custompage order by navigate_order,page_order ")
   public List<Custompage> searchAll() ;

   //根据页面查询子模块
   public List serchByCondition(Object obj) ;
   @Select(" select  num,navigate,navigate_order,submenu,subflag,sublink,page_order, subenable,subname,subjudge " +
         "from web_site.tb_custompage where navigate=#{navigate} and subjudge=#{subjudge} order by page_order ")
   public List<Custompage> serchByCondition(Custompage obj) ;
    //根据主导航的名字查询所有的子页面
   public List serchByInfo(Object obj);
   @Select("select num,navigate,navigate_order,submenu,subflag,sublink,page_order," +
         "subenable,subname,subjudge from web_site.tb_custompage where navigate=#{navigate}  order by navigate_order,page_order ")
   public List<Custompage> serchByInfo(Custompage obj);

}