SQL CASE WHEN用法
CASE WHEN fy_Contract.IsForeignCurrencyEnabled=1 THEN '是' ELSE '否' end IsForeignCurrencyEnabled,--as 是否外币
CASE x_fy_Income.x_ApproveMode WHEN 1 THEN '线下审批' WHEN 0 THEN '线上审批' ELSE '' END AS 'x_ApproveMode' ,--审批模式 0=线上审批；1=线下审批
CASE WHEN fy_Contract.IsForeignCurrencyEnabled=1 THEN '是' ELSE '否' end IsForeignCurrencyEnabled,--as 是否外币
CASE x_fy_Income.x_ApproveMode WHEN 1 THEN '线下审批' WHEN 0 THEN '线上审批' ELSE '' END AS 'x_ApproveMode' ,--审批模式 0=线上审批；1=线下审批
