SELECT
PrUser.*
FROM
PrUser
WHERE
(PrUser. STATUS != '4')
AND (
PrUser. STATUS = '1'
OR PrUser. STATUS = '2'
)
AND PrUser.uid NOT LIKE '%admin%'
AND CASE
WHEN (
PrUser.jlunit IS NOT NULL
AND PrUser.jlunit <> ''
) THEN
(PrUser.jlunit = ?)
WHEN (
PrUser.partUnitId IS NOT NULL
AND PrUser.partUnitId <> ''
) THEN
(PrUser.partUnitId = ?)
WHEN (
PrUser.orgId IS NOT NULL
AND PrUser.orgId <> ''
) THEN
(PrUser.orgId = ?)
END
AND PrUser.eid = 'esc'
ORDER BY
PrUser.wechat ASC
主要是case when then 第一次用这玩意,然后同时判断不为空和不为null