Index: ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/XinHuaDataManagerImpl.java =================================================================== diff -u -r30339 -r30340 --- ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/XinHuaDataManagerImpl.java (.../XinHuaDataManagerImpl.java) (revision 30339) +++ ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/XinHuaDataManagerImpl.java (.../XinHuaDataManagerImpl.java) (revision 30340) @@ -1091,8 +1091,7 @@ if(StringUtils.equals(DeviceInterface.XINHUA_PC_L, deviceModel)){ List valueSql = new ArrayList(); for (WashData washData : washDateList) { - StringBuffer tempSb = new StringBuffer("(").append(++maxId) - .append(",'").append(washData.getCycleCounter()) + StringBuffer tempSb = new StringBuffer("(").append(washData.getCycleCounter()) .append(",'").append(washData.getMachineNo()).append("'") .append(",'").append(washData.getDeviceInterfaceID()).append("'") .append(",'").append(washData.getTime()).append("'") @@ -1102,23 +1101,22 @@ .append(")"); valueSql.add(tempSb.toString()); if(valueSql.size() == 1000){ - StringBuffer batchInsertSql = new StringBuffer("insert into WashData (id, cycleCounter, machineNo, deviceInterfaceID, Time, p1Mbar,t1Temp,a0) values"); + StringBuffer batchInsertSql = new StringBuffer("insert into WashData (cycleCounter, machineNo, deviceInterfaceID, Time, p1Mbar,t1Temp,a0) values"); batchInsertSql.append(StringTools.join(valueSql, ",")); objectDao.excuteSQL(batchInsertSql.toString()); valueSql = new ArrayList(); } } if(CollectionUtils.isNotEmpty(valueSql)){ - StringBuffer batchInsertSql = new StringBuffer("insert into WashData (id, cycleCounter, machineNo, deviceInterfaceID, Time, p1Mbar,t1Temp,a0) values"); + StringBuffer batchInsertSql = new StringBuffer("insert into WashData (cycleCounter, machineNo, deviceInterfaceID, Time, p1Mbar,t1Temp,a0) values"); batchInsertSql.append(StringTools.join(valueSql, ",")); objectDao.excuteSQL(batchInsertSql.toString()); } }else{ List valueSql = new ArrayList(); for (int i=0;i(); } } if(CollectionUtils.isNotEmpty(valueSql)){ - StringBuffer batchInsertSql = new StringBuffer("insert into WashData (id, cycleCounter, machineNo, deviceInterfaceID, time, t1Temp, t2Temp, t3Temp, t4Temp,a0) values"); + StringBuffer batchInsertSql = new StringBuffer("insert into WashData (cycleCounter, machineNo, deviceInterfaceID, time, t1Temp, t2Temp, t3Temp, t4Temp,a0) values"); batchInsertSql.append(StringTools.join(valueSql, ",")); objectDao.excuteSQL(batchInsertSql.toString()); }