SELECT
OID,
TRT_NAME,
TRT_Activity = case when TRT_Activity='Export' then '出库' when TRT_Activity='Import' then '入库' when TRT_Activity='Move' then '移库' when TRT_Activity= 'Dispatch' then '调拨' else '' end,
TRT_ISUSE = case when TRT_ISUSE='True'then '是' else '否' end ,
TRT_DESC
FROM TBLTRANSACTIONTYPE