package com.panzhihua.service_grid.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.common.model.vos.grid.EventLcGridAdminVO;
import com.panzhihua.service_grid.model.dos.LcCompareCodeDO;

/**
 * program 攀枝花智慧社区项目 description 本地网格和浪潮的对码表管理API
 *
 * @author manailin Date 2021-01-22 15:30
 **/
@Mapper
public interface LcCompareCodeMapper extends BaseMapper<LcCompareCodeDO> {

    @Update("update lc_compare_code set local_grid_id = null,grid_name = null where local_grid_id = #{gridId}")
    void updateLcCompareCode(@Param("gridId") Long gridId);

    @Select("select id,lc_grid_name from lc_compare_code")
    List<EventLcGridAdminVO> getLcGridLists();

}