Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/dwr/table/GoodPurchaseTableManager.java =================================================================== diff -u -r19154 -r20828 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/dwr/table/GoodPurchaseTableManager.java (.../GoodPurchaseTableManager.java) (revision 19154) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/dwr/table/GoodPurchaseTableManager.java (.../GoodPurchaseTableManager.java) (revision 20828) @@ -75,6 +75,8 @@ sql.append("and (po.orgUnit.orgUnitCoding = '").append(AcegiHelper.getCurrentOrgUnitCode()).append("'"); //根据关键字和时间来过滤 goodPurchaseTableFilterManagerImpl.filterPara(sqlWhereParamMap,sql); + //过滤高值耗材的采购计划单 + sql.append(" and po.id in(select gi.goodPurchasePlan.id from GoodPurchaseItem gi where expensiveGoodsId is null)"); sql.append(")"); return gridManager.renderGrid(parameterMap, GoodPurchasePlan.class.getSimpleName(), sql.toString(), new String[] { "itemsList","orgUnit" }); }