update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
package com.fgkj.mapper.impl;
 
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 {
 
    //页面定制下添加导航或者子页面
    @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);
 
    //页面定制可以看到的子菜单和子模块
    @Update("update web_site.tb_custompage set subflag=#{subflag} where num=#{num} ")
    public int update(Custompage 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);
    
    //查询所有的菜单(页面定制可以看到的子菜单和子模块)
    @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() ;
 
    //根据页面查询子模块
    @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) ;
    //根据主导航的名字查询所有的子页面
    @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);
 
}