| | |
|---|
| | | default List<MesQcIpqcDO> selectListByImportKey(Long workOrderId, Integer type, Long workstationId, |
|---|
| | | LocalDateTime inspectDate) { |
|---|
| | | return selectList(new LambdaQueryWrapperX<MesQcIpqcDO>() |
|---|
| | | .eq(MesQcIpqcDO::getWorkOrderId, workOrderId) |
|---|
| | | // 生产工单、工位为选填：留空时比对其它同样留空的检验单 |
|---|
| | | .eq(workOrderId != null, MesQcIpqcDO::getWorkOrderId, workOrderId) |
|---|
| | | .isNull(workOrderId == null, MesQcIpqcDO::getWorkOrderId) |
|---|
| | | .eq(MesQcIpqcDO::getType, type) |
|---|
| | | .eq(MesQcIpqcDO::getWorkstationId, workstationId) |
|---|
| | | .eq(workstationId != null, MesQcIpqcDO::getWorkstationId, workstationId) |
|---|
| | | .isNull(workstationId == null, MesQcIpqcDO::getWorkstationId) |
|---|
| | | .eq(inspectDate != null, MesQcIpqcDO::getInspectDate, inspectDate) |
|---|
| | | .isNull(inspectDate == null, MesQcIpqcDO::getInspectDate) |
|---|
| | | .orderByAsc(MesQcIpqcDO::getId)); |
|---|
