select count(*) from DP_EQUIPMENT where EQUIPMENT_TYPE_ID = 3;
select id, equ_name from DP_EQUIPMENT where EQUIPMENT_TYPE_ID = 3;

select a.*,b.HARBOR_NAME as whName ,b.pkId as whId,c.NAME as beName,c.pkId as beId,
        d.ID as equipmentTypeId,d.TYPE_NAME as equtype,d.DESCRIPTION as description,d.FILE_PATH as filepath,d.ICON as icon,
        b.HARBOR_NAME as whName, c.NAME as beName from DP_EQUIPMENT a
        left join DM_BERTH c on c.pkId = a.BE_ID
        left join dm_harbor b on c.HARBOR_ID = b.pkId
        left join DP_EQUIPMENT_TYPE d on d.ID = a.EQUIPMENT_TYPE_ID
        where d.TYPE_NAME='智能电表'
        order by a.id

select id, equ_name from DP_EQUIPMENT where EQUIPMENT_TYPE_ID = 3 limit 1;

select * from DP_EQUIPMENT where id in (394, 395, 105);
select * from SYSDBA.RECEIVE_MODULE_INFO order by id desc;
select * from SYSDBA.RECEIVE_OIL_INFO where DEVICE_NAME in ('394','105');

电压告警
ryTask.dbGaoJing(370,450,211,250)
* 0/15 * * * ?
-----------------------------------------------------------
code=500，id=101 不存在
getYdkfm：status=true 开启，    status=false 关闭，status=null && error!=null 出错

code=500，id=101 不存在
ctrlYdkfm：status=true 操作成功，status=null && error!=null 出错
-----------------------------------------------------------