先上一段 代码
select c.containername,pb.productname || '('||p.productrevision||')' as product ,pt.producttypename, ms.sw_location2,ms.sw_lot,ms.sw_materialstockname,ms.sw_stockqty, ms.sw_loadedqty,ms.sw_totalqty,u.uomname, r.resourcename || r.description as 设备,rt.resourcetypename,ms.sw_carriername, case ms.sw_instocktype when '0' then '半成品' when '1' then '原材料' when '2' then '在制品' when '3' then '成品' end as sw_instocktype, s.shiftname,ms.sw_instockdate from sw_materialstock ms left join container c on c.containerid = ms.sw_containerid left join product p on p.productid = ms.sw_productid left join productbase pb on pb.productbaseid = p.productbaseid left join producttype pt on pt.producttypeid = p.producttypeid left join resourcedef r on r.resourceid = ms.sw_resourceid left join shift s on s.shiftid = ms.sw_shiftid left join uom u on u.uomid = ms.sw_uomid left join resourcetype rt on rt.resourcetypeid = r.resourcetypeid where 1 = 1比方说，上图中sw_instockType 存的是枚举类型，在业务中0代表半成品，那么then的后面就跟你想要在展示的内容，最后以end结束，当然建议另起名 as XXX ，比如上图中的 as sw_nstockType
