case的用法

(case cpd.cpd_type when 0 then (case when(cpd.cpd_point>0) then '消费'  when (cpd.cpd_point<=0) then '冲正' end) when 1 then '礼品兑换' when 2 then '自动清零'end)