futian.liu
2023-12-01 b3dc06734af35528496c192368586d5d8a61b42a
consum-base/src/main/java/com/consum/base/service/LWhFormOutputService.java
@@ -1,12 +1,17 @@
package com.consum.base.service;
import com.consum.model.po.WhFormOutput;
import com.walker.infrastructure.utils.CollectionUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import java.util.HashMap;
import java.util.List;
/**
 * @ClassName WhFormOutputService
 * @Author cy
 * @Date 2023/10/26
 * @Description
 * @Version 1.0
@@ -15,4 +20,21 @@
@Service
public class LWhFormOutputService extends BaseServiceImpl {
    /**
     * 通过调拨单查询出库单id
     *
     * @param transBusinessId
     * @return
     */
    private static String QUEYR_ID_BY_TRANSFERID = "select id from L_WH_FORM_OUTPUT where TRANS_BUSINESS_ID =:transBusinessId limit 1";
    public Long queyrIdByTransferId(Long transBusinessId) {
        HashMap<String, Object> map = new HashMap<>();
        map.put("transBusinessId", transBusinessId);
        List<WhFormOutput> whFormOutputs = select(QUEYR_ID_BY_TRANSFERID, map, new WhFormOutput());
        if (CollectionUtils.isEmpty(whFormOutputs)) {
            return null;
        }
        return whFormOutputs.get(0).getId();
    }
}