列表中，按照上级可看下级，下级可看上级文件，公开可见的要求编写SQL方式：
select * from CCII_DOC where 1=1 $SQL[ and typeid= $RS{typeid,doc.list.typeid}] and ((orgid='$U{orgid}' or orgid in (select lowerid as orgid from AORGLEVEL where upperid='$U{orgid}' ) or orgid in (select upperid as orgid from AORGLEVEL where lowerid='$U{orgid}') ) or ispublic = 1)
阅读(1052) | 评论(0) | 转发(0) |
