feat: 根据调拨单生成出库单，根据出库单id进行出库

cy

2023-10-26 5d7ab4ea0ef70f7930cc7b3a4209ded1b1c83115

 consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java

@@ -4,6 +4,7 @@
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -115,10 +116,26 @@
     * @param toWarehouseName
     * @return
     */
    private static String MOD_GOODS_TRANSFERING = "";
    private static String MOD_GOODS_TRANSFERING_PREFIX = "update L_WH_GOODS set";

    public int modGoodsTransfering(List<Long> whGoods, Long toWarehouseId, String toWarehouseName) {
//upda
        return 0;
    public int modGoodsTransfering(List<Long> whGoods, Long toWarehouseId, String toWarehouseName, Short states) {
        StringBuilder sql = new StringBuilder(MOD_GOODS_TRANSFERING_PREFIX);
        ArrayList<Object> params = new ArrayList<>();
        if (toWarehouseId != null) {
            sql.append(", WAREHOUSE_ID=?");
            params.add(toWarehouseId);
        }
        if (toWarehouseName != null) {
            sql.append(", WAREHOUSE_NAME=?");
            params.add(toWarehouseName);
        }
        if (states != null) {
            sql.append(", STATES=?");
            params.add(states);
        }
        sql.deleteCharAt(22);
        sql.append(" where id in(?)");
        params.add(whGoods);
        return update(sql.toString(), params.toArray());
    }
}