Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java
===================================================================
diff -u -r27817 -r27818
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 27817)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 27818)
@@ -992,7 +992,7 @@
 					+ tousseItemTableAlias +".diposable,ul.grade,"
 					+ invoicePlanTableAlias +".applicationTime,"
 					+ tousseItemWaitSendAmountSumSql +" amount,"
-					+ "(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".urgentAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
+					+ "(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".sendoutAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
 					+ "from %s "+ tousseItemTableAlias +" "
 					+ "join %s "+ invoicePlanTableAlias +" on "+ tousseItemTableAlias +".recyclingApplication_ID="+ invoicePlanTableAlias +".id "
 					+ "left join %s ul on "+ tousseItemTableAlias +".urgentLevel_id=ul.id "
@@ -1049,7 +1049,7 @@
 					+ tousseItemTableAlias +".diposable,ul.grade,"
 					+ invoicePlanTableAlias +".applicationTime,"
 					+ shouldSendAmountCaseSql +" amount,"
-					+ "(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".urgentAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
+					+ "(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".sendoutAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
 					+ "from %s "+ tousseItemTableAlias +" "
 					+ "join %s "+ invoicePlanTableAlias +" on "+ tousseItemTableAlias +".recyclingApplication_ID="+ invoicePlanTableAlias +".id "
 					+ "left join %s ul on "+ tousseItemTableAlias +".urgentLevel_id=ul.id "
@@ -1101,7 +1101,7 @@
 			String queryNotDisinfectTousseItemSql = String.format("select tousseName,tousseType,diposable,"
 					+ "max(ul.grade) grade,min("+ invoicePlanTableAlias +".applicationTime) applicationTime,"
 					+ "dg.ttsName ,sum"+ tousseItemWaitSendAmountSumSql +" amount,"
-					+ "sum(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".urgentAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
+					+ "sum(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".sendoutAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
 					+ "from %s "+ tousseItemTableAlias +" "
 					+ "join %s "+ invoicePlanTableAlias +" on "+ tousseItemTableAlias +".recyclingApplication_ID="+ invoicePlanTableAlias +".id "
 					+ "left join %s ul on "+ tousseItemTableAlias +".urgentLevel_id=ul.id "
@@ -1131,7 +1131,7 @@
 					+ "td.id tdId,td.materialsMD5,td.materialAmount,td.isApplyEntireTousse,"
 					+ "min("+invoicePlanTableAlias +".applicationTime) applicationTime,"
 					+ "sum"+ tousseItemWaitSendAmountSumSql +" amount,"
-					+ "sum(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".urgentAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
+					+ "sum(case when ("+ tousseItemTableAlias +".urgentAmount is null or "+ tousseItemTableAlias +".urgentAmount <= "+ tousseItemTableAlias +".sendoutAmount) then 0 else ("+ tousseItemTableAlias +".urgentAmount - "+ tousseItemTableAlias +".sendoutAmount) end) urgentAmount "
 					+ "from %s "+ tousseItemTableAlias +" "
 					+ "join %s "+ invoicePlanTableAlias +" on "+ tousseItemTableAlias +".recyclingApplication_ID="+ invoicePlanTableAlias +".id "
 					+ "left join %s ul on "+ tousseItemTableAlias +".urgentLevel_id=ul.id "