| | |
| | | /** |
| | | * 查询钣金计划临时表列表 |
| | | */ |
| | | @RequiresPermissions("ApsPlatePlan:ApsPlatePlanTemp:list") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ApsPlatePlanTemp apsPlatePlanTemp) |
| | | { |
| | | startPage(); |
| | | List<ApsPlatePlanTemp> list = apsPlatePlanTempService.selectApsPlatePlanTempList(apsPlatePlanTemp); |
| | | return getDataTable(list); |
| | | } |
| | |
| | | * @return 结果 |
| | | */ |
| | | public int deleteApsPlatePlanByIds(String[] ids); |
| | | |
| | | public int insertPlatePlanFromTempByBatchNumber(String batchNumber); |
| | | } |
| | |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | |
| | | <insert id="insertPlatePlanFromTempByBatchNumber" parameterType="String"> |
| | | insert into aps_plate_plan( |
| | | id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk) |
| | | SELECT |
| | | id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk |
| | | from aps_plate_plan_temp |
| | | where batch_number = #{batch_number} |
| | | </insert> |
| | | |
| | | |
| | | </mapper> |
| | |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | |
| | | <delete id="deleteApsPlatePlanTempById" parameterType="String"> |
| | | delete from aps_plate_plan_temp where id = #{id} |
| | | </delete> |
| | | |
| | | </mapper> |