package com.cloud.user.dao;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Options;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import com.cloud.model.sys.SysMenu;
|
|
@Mapper
|
public interface SysMenuDao {
|
|
@Options(useGeneratedKeys = true, keyProperty = "id")
|
@Insert("insert into sys_menu(orgId, parentId, parentIds, orgIdsShow, orgIdsHide, name, sort, url, icon, type, isSystem, permission, remarks, enabled, delFlag, createTime, updateTime) " +
|
"values " +
|
"(#{orgId}, #{parentId}, #{parentIds}, #{orgIdsShow}, #{orgIdsHide}, #{name}, #{sort}, #{url}, #{icon}, #{type}, #{isSystem}, #{permission}, #{remarks}, #{enabled}, #{delFlag}, #{createTime}, #{updateTime})")
|
int save(SysMenu SysMenu);
|
|
@Update("update sys_menu t set t.name = #{name}, t.permission = #{permission}, t.updateTime = #{updateTime} where t.id = #{id}")
|
int update(SysMenu SysMenu);
|
|
@Delete("delete from sys_permission where id = #{id}")
|
int delete(Long id);
|
|
@Select("select * from sys_menu t where t.id = #{id}")
|
SysMenu findById(Long id);
|
|
@Select("select * from sys_menu t where t.permission = #{permission}")
|
SysMenu findByPermission(String permission);
|
|
int count(Map<String, Object> params);
|
|
List<SysMenu> findData(Map<String, Object> params);
|
|
}
|
