设置参数框联动,对于复选框组控件的数据字典那里取数据查询,数据集,取ds里的ParaName。。ds里的sql语句这样写的: SELECT b.ParaName FROM dbo.Para_erecord AS a INNER JOIN dbo.Para_type AS b ON a.fkiParaID = b.ID INNER JOIN dbo.workstation_type AS c ON b.fkiWorkstationID = c.ID INNER JOIN dbo.zone_type AS d ON c.sZoneName = d.sZoneName where a.tDate between '${starttime}' and '${endtime} ${if(len(zone) == 0,"","and d.sZoneNameDes in ('" + zone + "')")} ${if(len(workstation) == 0,"","and c.sWorkstationName in ('" + workstation + "')")} 问题在于如果sql 语句加上红色的时间限制,复选框组控件并不显示内容,去掉红色的时间限制就会有值显示,这是为什么,每次写完sql在ds预览都会有值,不存在查询不出的情况 |
0
|
|