SELECT TO_NUMBER(SUBSTR(MONTH_WID,5,2)) AS MONTH, CASE WHEN OM_CLASS_NAME='浆类' THEN SUM(CVT_ONHAND/10000) WHEN OM_CLASS_NAME='产品类' 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='枣类'","OM_CLASS_NAME = '"+ty1+"'")} 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大佬们就是我这个case when 中这个WHEN OM_CLASS_NAME='产品类'这里,ty传参过来的是产品,不是产品类,但是这个地方又需要用产品类做判断,就是这个地方要怎么改呀