EWA

Listframe 创建时新增回收站功能

2016-12-01

创建 Listframe 新增回收站功能

  1. 参数为 EWA_RECYCLE
  2. 当EWA_RECYCLE = 1时,会筛选状态字段='DEL'的数据
  3. 当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))
    )