package com.nanjing.water.repository.mapper;
|
|
import com.nanjing.water.repository.BasicMapper;
|
import com.nanjing.water.repository.po.WaterFacilityParameterPO;
|
import com.nanjing.water.repository.vo.FacilityParameterDataVO;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 设备设定参数 mapper
|
*
|
* @author lin.liu
|
*/
|
public interface WaterFacilityParameterMapper extends BasicMapper<WaterFacilityParameterPO> {
|
|
@Select("SELECT wf.id,wf.facility_code,wf.facility_name,wfp.columns_code,wfp.columns_show,wfp.column_value,wfp.last_time FROM water_facility wf right JOIN water_facility_parameter wfp ON wf.id=wfp.facility_id WHERE wf.is_delete=0\n" +
|
"AND (wfp.columns_code='B001StartNumber' OR wfp.columns_code='B002StartNumber')")
|
List<FacilityParameterDataVO> getListNewPump();
|
}
|
