package com.example.erp.mapper.pp;
|
|
import com.example.erp.entity.sd.Product;
|
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.sql.Date;
|
import java.util.List;
|
|
@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 productionId);
|
|
Integer selectWorkCount(String orderId);
|
|
Boolean updateWorkType(String orderId, Integer state);
|
|
Integer selectYesWorkCount(String orderId);
|
}
|
