工单管理模块修改

chenlu

2024-02-22 c6b112564e0a97fc20db23e67dae0adee03f941c

 north-glass-erp/src/main/java/com/example/erp/mapper/pp/WorkOrderMapper.java

@@ -11,20 +11,30 @@

@Mapper
public interface WorkOrderMapper {
    //工单管理查询未转工单数据
    List<OrderGlassDetail> selectWordOrder(Date selectTime1, Date selectTime2, OrderGlassDetail orderGlassDetail);

    //查询已转工单数据
    List<OrderGlassDetail> selectWordOrderNo(Date selectTime1, Date selectTime2, OrderGlassDetail orderGlassDetail);

    //查询需要转工单明细
    List<OrderDetail> addWordOrder(String orderId, OrderDetail orderDetail);


    //转工单
    Boolean AddOrderWorkMp(String productIdVl,
                           @Param("orderId") String orderId,
                           @Param("productId") Integer productId,
                           @Param("productName") String productName,
                           String userName);

    //查询对应订单号订序
    Integer SelectOrderNumber(String productIdVl);


    //删除工单,将对应产品生产订单号改为null
    Boolean DeleteOrderWorkMp(String orderId, String productName);

    Integer SelectWorkCount(String orderId);

    Boolean UpdateWorkType(String orderId, Integer state);

    Integer SelectYesWorkCount(String orderId);
}