Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/dwr/table/RecyclingApplicationTableManager.java
===================================================================
diff -u -r15128 -r15133
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/dwr/table/RecyclingApplicationTableManager.java	(.../RecyclingApplicationTableManager.java)	(revision 15128)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/dwr/table/RecyclingApplicationTableManager.java	(.../RecyclingApplicationTableManager.java)	(revision 15133)
@@ -172,7 +172,10 @@
 		}
 		
 		StringBuilder sqlBuilder = new StringBuilder();
-		sqlBuilder.append(" WHERE "
+		// sqlBuilder.append(" WHERE "
+		// 		+ SqlBuilder.build_IN_Statement("po.type", SqlBuilder.NOT_IN,
+		// 				excludeTypelist));
+		sqlBuilder.append(" WHERE ("
 				+ SqlBuilder.build_IN_Statement("po.type", SqlBuilder.NOT_IN,
 						excludeTypelist));
 		
@@ -231,6 +234,8 @@
 				this.createApplyFilterSql(sqlBuilder, deliverStatusSql);
 			}
 		}
+		//对应最上面的where
+		sqlBuilder.append(")");
 
 		//根据开始时间和结束时间来查询
 		String startTime = sqlWhereParamMap.get("startTime");