YiWuProject.git

			@@ -3,6 +3,7 @@
			import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
			import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
			import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
			import com.mes.downglassinfo.entity.DownGlassTask;
			import com.mes.downworkstation.entity.DownWorkstation;
			import com.mes.downworkstation.entity.DownWorkstationTask;
			import com.mes.downworkstation.mapper.DownWorkstationMapper;
			@@ -13,6 +14,7 @@
			import org.springframework.transaction.annotation.Transactional;

			import java.util.List;
			import java.util.Map;

			@Service
			public class DownWorkstationServiceImpl extends ServiceImpl<DownWorkstationMapper, DownWorkstation> implements DownWorkstationService {
			@@ -22,7 +24,8 @@
			private DownWorkstationTaskMapper downWorkstationTaskMapper;


			// @Override

			// @Override
			// public List<DownWorkstation> gettwoDownWorkstations() {
			// return downWorkstationMapper.getDownWorkstationsInRange(6,10);
			// }
			@@ -43,7 +46,7 @@
			// return totalQuantity != null ? totalQuantity : 0;
			// }

			// @Override
			// @Override
			// public int getRacksNumber(int workstationId) {
			// Integer racksNumber = downWorkstationMapper.getRacksNumber(workstationId);
			// return racksNumber != null ? racksNumber : 0;
			@@ -58,8 +61,7 @@
			DownWorkstation result = baseMapper.selectOne(queryWrapper);
			return result != null ? result.getRacksnumber() : 0;
			}

			//根据条件获取工位玻璃信息
			//根据条件获取工位玻璃信息
			@Override
			public List<DownWorkstation> getoneDownWorkstations(int startId, int endId) {
			QueryWrapper<DownWorkstation> queryWrapper = new QueryWrapper<>();
			@@ -75,9 +77,10 @@
			@Override
			public void updateracksnumber(String flowCardId, int racksNumber) {
			UpdateWrapper<DownWorkstation> updateWrapper = new UpdateWrapper<>();
			updateWrapper.set("racks_number", racksNumber).eq("flow_card_id", flowCardId);
			updateWrapper.set("racks_number",racksNumber).eq("flow_card_id", flowCardId);
			baseMapper.update(null, updateWrapper);
			}



			@Override
			@@ -102,6 +105,13 @@
			}









			@Transactional
			public void crossDatabaseQuery() {
			// 从 MySQL 数据库中查询数据，只返回一条符合条件的数据
			@@ -110,7 +120,10 @@
			// 从 SQL Server 数据库中查询数据
			List<DownWorkstationTask> downWorkstationTasks = downWorkstationTaskMapper.selectList();


			}





			}