| | |
| | | List<Map<String, Object>> selectFlowCardMerge(String processId); |
| | | |
| | | Boolean updateFlowCardMerge(String processId); |
| | | |
| | | Boolean deleteflowCardSort(String orderId, String processId); |
| | | } |
| | |
| | | flowCardMapper.deleteReportingWork(processId); |
| | | //删除分架明细 |
| | | flowCardMapper.deleteFlowCardMp(orderId, processId); |
| | | //删除排序表数据 |
| | | flowCardMapper.deleteflowCardSort(orderId, processId); |
| | | //判断该订单流程卡是否全部删除 |
| | | Integer flowNumber = flowCardMapper.selectFlowCardCount(orderId); |
| | | if (flowNumber == 0) { |
| | |
| | | od.processing_note as processingNote, |
| | | width, |
| | | height, |
| | | od.quantity, |
| | | fc.quantity, |
| | | od.order_number as orderNumber, |
| | | fc.technology_number as technologyNumber, |
| | | od.building_number as buildingNumber, |
| | |
| | | ogd.technology_number = fc.technology_number |
| | | where fc.process_id = #{processId} |
| | | and fc.order_number = #{orderNumber} |
| | | group by fc.process_id, od.order_number, width, height |
| | | group by od.order_number, width, height |
| | | order by fc.process_id |
| | | </select> |
| | | |
| | |
| | | where fc.process_id = #{processId} |
| | | </update> |
| | | |
| | | <delete id="deleteflowCardSort"> |
| | | delete from flow_card_sort where process_id = #{processId} |
| | | </delete> |
| | | |
| | | </mapper> |