1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| package com.zy.asrs.mapper;
|
| import com.baomidou.mybatisplus.mapper.BaseMapper;
| import com.zy.asrs.entity.WaitPakinLog;
| import org.apache.ibatis.annotations.Insert;
| import org.apache.ibatis.annotations.Mapper;
| import org.apache.ibatis.annotations.Param;
| import org.springframework.stereotype.Repository;
|
| @Mapper
| @Repository
| public interface WaitPakinLogMapper extends BaseMapper<WaitPakinLog> {
|
| @Insert("insert into cust_wait_pakin_log (zpallet, anfme, loc_no, matnr, maktx, batch, order_no, origin, freq_type, manu, specs, model, color, brand, unit, price, sku, units, barcode, manu_date, item_num, safe_qty, weight, man_length, volume, three_code, supp, supp_code, be_batch, dead_time, dead_warn, source, inspect, danger, status, io_status, modi_time, modi_user, appe_time, appe_user, memo, standby1, standby2, standby3, box_type1, box_type2, box_type3) " +
| "select zpallet, anfme, loc_no, matnr, maktx, batch, order_no, origin, freq_type, manu, specs, model, color, brand, unit, price, sku, units, barcode, manu_date, item_num, safe_qty, weight, man_length, volume, three_code, supp, supp_code, be_batch, dead_time, dead_warn, source, inspect, danger, status, io_status, modi_time, modi_user, appe_time, appe_user, memo, standby1, standby2, standby3, box_type1, box_type2, box_type3 from cust_wait_pakin where zpallet=#{zpallet}")
| int save(@Param("zpallet") String zpallet);
|
| }
|
|