创建 Listframe 新增回收站功能
- 参数为
EWA_RECYCLE
;
- 当EWA_RECYCLE = 1时,会筛选
状态字段
='DEL'的数据
- 当EWA_RECYCLE != 1时,会筛选
状态字段
!='DEL'的数据
例如:
- USE_STATE 是状态字段
- USE_STATE='DEL' 为删除状态
- USE_STATE='USED' 为使用状态
SELECT * FROM crm_com WHERE CODE = 1
AND (
(@EWA_RECYCLE='1' AND USE_STATE='DEL')
OR
(@EWA_RECYCLE IS NULL AND (USE_STATE!='DEL' OR USE_STATE IS NULL))
)