package com.whyc.mapper;
|
|
import com.whyc.dto.DfxtDeviceDTO;
|
import com.whyc.pojo.DfxtDeviceList;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
public interface DfxtDeviceListMapper extends CustomMapper<DfxtDeviceList>{
|
|
@Select("SELECT DISTINCT d.objectid as deviceId, d.fullname as deviceName, EXISTS(SELECT 1 FROM db_battinf.tb_battinf b WHERE d.objectid = b.DeviceId) AS isUsed\n" +
|
"FROM db_ram_db.tb_dfxt_devicelist d;")
|
List<DfxtDeviceDTO> getDeviceList();
|
}
|
