20240511修改: 分发单优化， 分类，物品，分发单明细，采购单明细数据导入

黎星凯

2024-05-13 58a518f8bc23ed382f4da2a86b09024b063a620c

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

@@ -1,11 +1,11 @@
package com.consum.base.service;

import com.walker.jdbc.service.BaseServiceImpl;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @ClassName LGoodsUserRecordServiceImpl
@@ -26,28 +26,5 @@
    public int updSetNotLast(List<Long> outGoodsIds) {
        return this.update(updSetNotLast + StringUtils.join(outGoodsIds, ",") + ")", new String[]{});
    }

    /**
     * 通过 调拨单ID 或者 分发记录表id 删除
     */
    private static String DEL_BY_TRANDS_AND_RECORDID = "delete from L_GOODS_USER_RECORD where 1=1";

    public int delByTrandsAndRecordId(Long transBusinessId, Long procureModelUserRecordId) {
        if (transBusinessId == null && procureModelUserRecordId == null) {
            return 0;
        }
        ArrayList<Object> params = new ArrayList<>();
        StringBuilder sql = new StringBuilder(DEL_BY_TRANDS_AND_RECORDID);
        if (transBusinessId != null) {
            sql.append(" and TRANS_BUSINESS_ID =?");
            params.add(transBusinessId);
        }
        if (procureModelUserRecordId != null) {
            sql.append(" and PROCURE_MODEL_USER_RECORD_ID =?");
            params.add(procureModelUserRecordId);
        }
        return update(sql.toString(), params.toArray());
    }


}