83222
SQL语句：
select XDJLNUM as 单号,
DESCRIPTION as 描述,
DA_XDJL.WAY as 方式,
FLPERSON as 下令人,
(select DISPLAYNAME from PERSON where personid = DA_XDJL.JLPERSON) as 记录人,
STATUS as 状态,
(select description from site where siteid=DA_XDJL.siteid) as 场站,
(select DISPLAYNAME from PERSON where personid = DA_XDJL.cjperson) as 创建人,
CJDATE as 创建时间,
STOPDATE as 限电开始时间,
STADATE as 限电结束时间,
KEEPDATE as 累计停机小时数,
LOST as 限电电量,
ORDLOAD as 下令限电负荷,
FCLOAD as 风场负荷,
INFLOAD as 实际负荷,
SSXM as 所属项目
--AVGSPEED as 平均风速（m/s）/平均光照强度（W/㎡）
from DA_XDJL
where (select description from site where siteid=DA_XDJL.siteid) in ${场站}
and to_char(STOPDATE,'yyyy-MM-dd') >='${开始日期}'
and to_char(STOPDATE,'yyyy-MM-dd') <='${结束日期}'
order by (select description from site where siteid=DA_XDJL.siteid),STOPDATE
