SELECT 

TO_NUMBER(SUBSTR(MONTH_WID,5,2)) AS MONTH, 

CASE WHEN OM_CLASS_NAME='浆类' THEN SUM(CVT_ONHAND/10000) WHEN ${ty}='产品' THEN SUM(CVT_ONHAND/80000) ELSE SUM(CVT_ONHAND/1000) END AS CVT_ONHAND--库存

FROM DW_F_UNION_SCM_INV

WHERE ${IF(ty='枣类',"OM_CLASS_NAME='枣类'",IF(ty='产品',"OM_CLASS_NAME='产品类'","OM_CLASS_NAME = '"+ty+"'"))}

AND SUBSTR(MONTH_WID,1,4)=SUBSTR('${P_S_DATE}',1,4)

AND TO_NUMBER(SUBSTR(MONTH_WID,5,2))<=SUBSTR('${P_S_DATE}',6,2)

GROUP BY MONTH_WID,OM_CLASS_NAME

你要有陈品和产品类的字典表

然后根据产品查询出产品类

WHERE ${IF(ty='枣类',"OM_CLASS_NAME='枣类'","OM_CLASS_NAME = '"+ty1+"'")}

改成

WHERE ${IF(ty='枣类',"OM_CLASS_NAME='枣类'","OM_CLASS_NAME = '"+sql("数据库连接名","select 产品类 from 表 where 产品='"+ty1+"'",1,1)+"'")}