把where条件改写了
改用case when
-
(
- (
- (
- (select aco.iauthcontrol
- from BG_AUTHCONTROLOBJ aco
- where aco.cobjcode = \'105\' and
- aco.corgnid = {CORGNID:\'\'}) = 0
-
)
-
or
- (select count(cguid)
- from BG_AUTHCONTROLOBJ aco
- where aco.cobjcode = \'105\' and
- aco.corgnid = {CORGNID:\'\'}) = 0
- )
-
or
- (
- (select aco.iauthcontrol
- from BG_AUTHCONTROLOBJ aco
- where aco.cobjcode = \'105\' and
-
aco.corgnid = {CORGNID:\'\'}) = 1 and
- (
- (
- (select akj.iauthcontrol
- from BG_AUTHASSIGNKJ akj
- where akj.carchiveguid ={cBGCaliberKey3GUID:\'\'} and
-
akj.corganguid = {CORGNID:\'\'}) = 0
-
or
- (select count(cguid)
- from BG_AUTHASSIGNKJ akj
- where akj.carchiveguid ={cBGCaliberKey3GUID:\'\'} and
- akj.corganguid = {CORGNID:\'\'}) = 0
-
)
-
or
- (
- (select akj.iauthcontrol
- from BG_AUTHASSIGNKJ akj
- where akj.carchiveguid ={cBGCaliberKey3GUID:\'\'} and
- akj.corganguid = {CORGNID:\'\'}) = 1 and
- b1.cguid in ( select distinct babg.cbillcguid
- from BG_AUTHASSIGNBG babg
- where babg.cuserguid = {cCreatorGUID} and
- babg.corganguid = {CORGNID:\'\'} and
- babg.icontrol = 1 and
- babg.cobjguid = (select baco.cguid
-
from BG_AUTHCONTROLOBJ baco
- where baco.cobjcode = \'105\' and
-
baco.corgnid = {CORGNID:\'\'})
-
)
- )
-
)
-
)
- )
- (case (select aco.iauthcontrol
- from BG_AUTHCONTROLOBJ aco
- where aco.cobjcode = \'105\' and
-
aco.corgnid = {CORGNID:\'\'})
- when 1 then (case (select akj.iauthcontrol
- from BG_AUTHASSIGNKJ akj
- where akj.carchiveguid ={eleType:\'\'} and
-
akj.corganguid = {CORGNID:\'\'})
- when 1 then (case when c.cguid in (select distinct babg.cbillcguid
- from BG_AUTHASSIGNBG babg
- where babg.cuserguid = {cCreatorGUID} and
- babg.corganguid = {CORGNID:\'\'} and
- babg.icontrol = 1 and
-
babg.cobjguid = (select baco.cguid
-
from BG_AUTHCONTROLOBJ baco
- where baco.cobjcode = \'105\' and
- baco.corgnid = {CORGNID:\'\'}) ) then 1
-
else 0 end
-
)
-
else 1 end
-
)
-
else 1 end
- )=1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29437301/viewspace-1365754/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
