Index: ssts-web/src/main/resources/config/zsyy/mybatis/InvoicePlanFromHERP_Mapper.xml
===================================================================
diff -u -r21613 -r21659
--- ssts-web/src/main/resources/config/zsyy/mybatis/InvoicePlanFromHERP_Mapper.xml	(.../InvoicePlanFromHERP_Mapper.xml)	(revision 21613)
+++ ssts-web/src/main/resources/config/zsyy/mybatis/InvoicePlanFromHERP_Mapper.xml	(.../InvoicePlanFromHERP_Mapper.xml)	(revision 21659)
@@ -75,9 +75,8 @@
 	WHERE 1=1
 	]]>
 	<if test="serialNumbers != null and serialNumbers.size>0">
-			and 
-		    <foreach collection="serialNumbers"  item="serialNumbers" open="(" separator="or" close=")">
-	             ip.serialNumber not in   #{serialNumbers}       
+		    <foreach collection="serialNumbers"  item="serialNumber" open="" separator="" close="">
+	            and ip.serialNumber <> #{serialNumber}       
 	       </foreach>     
 	 </if>
 	<![CDATA[
@@ -138,9 +137,8 @@
 			]]>
 		</if>
 		<if test="serialNumbers != null and serialNumbers.size>0">
-			and 
-		    <foreach collection="serialNumbers"  item="serialNumbers" open="(" separator="and" close=")">
-	       serialNumber not in #{serialNumbers}
+		    <foreach collection="serialNumbers"  item="serialNumber" open="" separator=" " close="">
+	      	and  serialNumber <> #{serialNumber}
 	       </foreach>     
 	    </if>
 	</sql>