package com.example.erp.mapper.pp; import com.example.erp.entity.sd.OrderGlassDetail; import com.example.erp.entity.sd.OrderDetail; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; @Mapper public interface WorkOrderMapper { //工单管理查询未转工单数据 List selectWordOrder(String selectTime1, String selectTime2, OrderGlassDetail orderGlassDetail); //查询已转工单数据 List selectWordOrderNo(String selectTime1, String selectTime2, OrderGlassDetail orderGlassDetail); //查询需要转工单明细 List addWordOrder(String orderId, OrderDetail orderDetail); //转工单 Boolean addOrderWorkMp(String productIdVl, @Param("orderId") String orderId, @Param("productId") Integer productId, @Param("productName") String productName, String userName,String process); //查询对应订单号订序 Integer selectOrderNumber(String productIdVl); //删除工单,将对应产品生产订单号改为null Boolean deleteOrderWorkMp(String orderId, String productionId); Integer selectWorkCount(String orderId); Boolean updateWorkType(String orderId, Integer state); Integer selectYesWorkCount(String orderId); Integer selectProcessCard(String orderId); Boolean updateWorkIdMp(String orderId, String userName); }