~admin/HangZhouMes.git

			@@ -1,20 +1,127 @@
			package com.mes.downworkstation.service.impl;

			import com.mes.downworkstation.entity.DownWorkstation;
			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;
			import com.mes.downworkstation.mapper.DownWorkstationTaskMapper;
			import com.mes.downworkstation.service.DownWorkstationService;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.stereotype.Service;
			import org.springframework.transaction.annotation.Transactional;

			/**
			* <p>
			* 服务实现类
			* </p>
			*
			* @author zhoush
			* @since 2024-03-27
			*/
			import java.util.List;
			import java.util.Map;

			@Service
			public class DownWorkstationServiceImpl extends ServiceImpl<DownWorkstationMapper, DownWorkstation> implements DownWorkstationService {

			@Autowired
			private DownWorkstationMapper downWorkstationMapper;
			private DownWorkstationTaskMapper downWorkstationTaskMapper;



			// @Override
			// public List<DownWorkstation> gettwoDownWorkstations() {
			// return downWorkstationMapper.getDownWorkstationsInRange(6,10);
			// }
			//获取总数量
			@Override
			public int getTotalQuantity(int workstationId) {
			QueryWrapper<DownWorkstation> queryWrapper = new QueryWrapper<>();
			queryWrapper.select("total_quantity")
			.eq("workstation_id", workstationId);

			DownWorkstation result = baseMapper.selectOne(queryWrapper);
			return result != null ? result.getTotal_quantity() : 0;
			}

			// @Override
			// public int getTotalQuantity(int workstationId) {
			// Integer totalQuantity = downWorkstationMapper.getTotalQuantity(workstationId);
			// return totalQuantity != null ? totalQuantity : 0;
			// }

			// @Override
			// public int getRacksNumber(int workstationId) {
			// Integer racksNumber = downWorkstationMapper.getRacksNumber(workstationId);
			// return racksNumber != null ? racksNumber : 0;
			// }
			//根据条件获取落架数量
			@Override
			public int getRacksNumber(int workstationId) {
			QueryWrapper<DownWorkstation> queryWrapper = new QueryWrapper<>();
			queryWrapper.select("racks_number")
			.eq("workstation_id", workstationId);

			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<>();
			queryWrapper.between("workstation_id", startId, endId);

			return baseMapper.selectList(queryWrapper);
			}


			//


			@Override
			public void updateracksnumber(String flowCardId, int racksNumber) {
			UpdateWrapper<DownWorkstation> updateWrapper = new UpdateWrapper<>();
			updateWrapper.set("racks_number",racksNumber).eq("flow_card_id", flowCardId);
			baseMapper.update(null, updateWrapper);
			}



			@Override
			public int updateFlowCardIdAndCount(String flowCardId, int glassInfoCount, int workstationId) {
			UpdateWrapper<DownWorkstation> updateWrapper = new UpdateWrapper<>();
			updateWrapper.set("total_quantity", glassInfoCount)
			.set("flow_card_id", flowCardId)
			.eq("workstation_id", workstationId);

			return baseMapper.update(null, updateWrapper);
			}

			@Override
			public void clearFlowCardId(int workstationId) {
			UpdateWrapper<DownWorkstation> updateWrapper = new UpdateWrapper<>();
			updateWrapper.set("flow_card_id", null)
			.set("total_quantity", 0)
			.set("racks_number", 0)
			.eq("workstation_id", workstationId);

			baseMapper.update(null, updateWrapper);
			}









			@Transactional
			public void crossDatabaseQuery() {
			// 从 MySQL 数据库中查询数据，只返回一条符合条件的数据
			DownWorkstation downWorkstation = downWorkstationTaskMapper.selectdownWorkstationstate();

			// 从 SQL Server 数据库中查询数据
			List<DownWorkstationTask> downWorkstationTasks = downWorkstationTaskMapper.selectList();



			}

			}