Index: ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceOptimizeManagerImpl.java
===================================================================
diff -u -r28039 -r28085
--- ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceOptimizeManagerImpl.java	(.../InvoiceOptimizeManagerImpl.java)	(revision 28039)
+++ ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceOptimizeManagerImpl.java	(.../InvoiceOptimizeManagerImpl.java)	(revision 28085)
@@ -6584,7 +6584,7 @@
 				UrgentLevel.class.getSimpleName(),TousseItem.class.getSimpleName(),UrgentLevel.class.getSimpleName(),
 				SqlUtils.getNonStringFieldInLargeCollectionsPredicate("id", invoicePlanIdList)));*/
 		objectDao.excuteSQL(String.format("update %s set urgent=(case when (select sum(urgentAmount) from %s ti where ti.recyclingApplication_ID=%s.id) > 0 then '"+ Constants.STR_YES +"' else '"+ Constants.STR_NO +"' end),"
-				+ "urgentLevel_id=(select (select id from %s where grade = max(ul.grade)) from %s ti join %s ul on ul.id=ti.urgentLevel_id where ti.recyclingApplication_ID=invoicePlan.id) where %s", 
+				+ "urgentLevel_id=(select id from %s where grade = (select max(ul.grade) from %s ti join %s ul on ul.id=ti.urgentLevel_id where ti.recyclingApplication_ID=invoicePlan.id)) where %s", 
 				InvoicePlan.class.getSimpleName(),TousseItem.class.getSimpleName(),InvoicePlan.class.getSimpleName(),
 				UrgentLevel.class.getSimpleName(),TousseItem.class.getSimpleName(),UrgentLevel.class.getSimpleName(),
 				SqlUtils.getNonStringFieldInLargeCollectionsPredicate("id", invoicePlanIdList)));