Index: ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceManagerImpl.java =================================================================== diff -u -r15351 -r15355 --- ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceManagerImpl.java (.../InvoiceManagerImpl.java) (revision 15351) +++ ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceManagerImpl.java (.../InvoiceManagerImpl.java) (revision 15355) @@ -5924,7 +5924,7 @@ + "WHERE t.id=bd.id " + "AND t.tousseDefinition_id=td.id " + "AND t.sterilizationRecord_id=sr.id " - + "AND (td.tousseType = '外来器械包' or td.tousseType = '外来器械拆分小包') " + + "AND (td.tousseType = '" + TousseDefinition.PACKAGE_TYPE_FOREIGN + "' or td.tousseType = '" + TousseDefinition.PACKAGE_TYPE_SPLIT + "') " + sqlFilter ; ResultSet result = objectDao.executeSql(sql);