| | |
| | | //import com.jcdm.main.bs.orderScheduling.domain.BsOrderScheduling; |
| | | //import com.jcdm.main.bs.orderScheduling.mapper.BsOrderSchedulingMapper; |
| | | //import com.jcdm.main.bs.orderScheduling.service.IBsOrderSchedulingService; |
| | | import com.jcdm.main.da.paramCollection.mapper.DaParamCollectionMapper; |
| | | import com.jcdm.main.da.passingStationCollection.domain.DaPassingStationCollection; |
| | | import com.jcdm.main.da.passingStationCollection.mapper.DaPassingStationCollectionMapper; |
| | | import com.jcdm.main.da.passingStationCollection.service.IDaPassingStationCollectionService; |
| | | import com.jcdm.main.rm.repairRecord.domain.RmRepairRecord; |
| | | import com.jcdm.main.rm.repairRecord.mapper.RmRepairRecordMapper; |
| | | import org.apache.ibatis.session.ExecutorType; |
| | | import org.apache.ibatis.session.SqlSession; |
| | | import org.apache.ibatis.session.SqlSessionFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.time.format.DateTimeFormatter; |
| | |
| | | |
| | | @Autowired |
| | | private RmRepairRecordMapper rmRepairRecordMapper; |
| | | |
| | | @Resource |
| | | private SqlSessionFactory sqlSessionFactory; |
| | | |
| | | // @Autowired |
| | | // private BsOrderSchedulingMapper bsOrderSchedulingMapper; |
| | |
| | | return daPassingStationCollectionMapper.updateDaPassingStationCollection(daPassingStationCollection); |
| | | } |
| | | |
| | | @Override |
| | | public int updateDaPassingStationCollectionBySfcCodeAndLocationCode(DaPassingStationCollection daPassingStationCollection) { |
| | | return daPassingStationCollectionMapper.updateDaPassingStationCollectionBySfcCodeAndLocationCode(daPassingStationCollection); |
| | | } |
| | | |
| | | /** |
| | | * 批量删除产品过站采集 |
| | | * |
| | |
| | | public int jrmAddPassingStationCollection(DaPassingStationCollection daPassingStationCollection) { |
| | | for (String model : daPassingStationCollection.getSfcCode().split(",")) { |
| | | daPassingStationCollection.setSfcCode(model); |
| | | boolean save = daPassingStationCollectionService.save(daPassingStationCollection); |
| | | daPassingStationCollectionService.save(daPassingStationCollection); |
| | | } |
| | | return 1; |
| | | } |
| | | |
| | | @Override |
| | | public void saveBeachDaPassingStationCollection(List<DaPassingStationCollection> list) { |
| | | // ExecutorType.SIMPLE: 这个执行器类型不做特殊的事情。它为每个语句的执行创建一个新的预处理语句。 |
| | | // ExecutorType.REUSE: 这个执行器类型会复用预处理语句。 |
| | | // ExecutorType.BATCH: 这个执行器会批量执行所有更新语句,如果 SELECT 在它们中间执行还会标定它们是 必须的,来保证一个简单并易于理解的行为。 |
| | | |
| | | // 关闭session的自动提交 |
| | | SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false); |
| | | try { |
| | | DaPassingStationCollectionMapper userMapper = sqlSession.getMapper(DaPassingStationCollectionMapper.class); |
| | | list.stream().forEach(item -> userMapper.insertDaPassingStationCollection(item)); |
| | | // 提交数据 |
| | | sqlSession.commit(); |
| | | sqlSession.rollback(); |
| | | } catch (Exception e) { |
| | | sqlSession.rollback(); |
| | | } finally { |
| | | sqlSession.close(); |
| | | } |
| | | } |
| | | } |