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 出错
|
-----------------------------------------------------------
|
