package com.fengdu.gas.repository.mapper;
|
|
import com.fengdu.gas.repository.BasicMapper;
|
import com.fengdu.gas.repository.po.WaterFacilityParameterPO;
|
import com.fengdu.gas.repository.vo.WaterFacilityParameterVO;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 设备设定参数 mapper
|
* @author zr
|
*/
|
public interface WaterFacilityParameterMapper extends BasicMapper<WaterFacilityParameterPO> {
|
|
@Select({
|
"<script>",
|
"SELECT a.*,b.facility_state,b.facility_name,b.point_id,b.point_name FROM water_facility_parameter a ",
|
"left join water_facility b ON a.facility_id=b.id WHERE a.is_delete=0",
|
"<if test= \"pointId!=null and pointId>0 \">",
|
"and b.point_id=#{pointId}",
|
"</if>",
|
"<if test= \"facilityState!=null\">",
|
"and b.facility_state=#{facilityState}",
|
"</if>",
|
"</script>"
|
})
|
List<WaterFacilityParameterVO> getListData(Long pointId, Integer facilityState);
|
}
|
