From 62b6a7fac3f2acde70b578431147c4a01f19c182 Mon Sep 17 00:00:00 2001 From: 黎星凯 <13949086503@163.com> Date: 星期一, 15 四月 2024 09:07:05 +0800 Subject: [PATCH] bug修改 --- consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java | 68 ++++++++++++++++++--------------- 1 files changed, 37 insertions(+), 31 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java b/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java index 1c475e8..d277ec3 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java @@ -1,42 +1,48 @@ package com.consum.base.service; -import com.consum.base.core.WhBusinessEnum; -import com.consum.model.po.LWhProcureModel; -import com.walker.jdbc.service.BaseServiceImpl; -import org.springframework.stereotype.Service; - -import java.util.HashMap; import java.util.List; +import java.util.Map; -/** - * @ClassName LWhProcureModelService +import com.consum.base.core.WhBusinessEnum; +import com.consum.base.pojo.dto.GoodModelInfoDTO; +import com.consum.base.pojo.response.GoodsTemplateCountVO; +import com.consum.model.po.LWhProcureModel; +import com.walker.jdbc.service.BaseService; - * @Date 2023/10/24 - * @Description - * @Version 1.0 - **/ -@Service -public class LWhProcureModelService extends BaseServiceImpl { +public interface LWhProcureModelService extends BaseService { - private static String GET_MODEL_BY_FORM = "SELECT * FROM L_WH_PROCURE_MODEL WHERE 1=1 "; + List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId); + + List<Map<String, Object>> getFfOrderByGoodsIdAndDept(Long goodsTemplateId, Long departmentId); + + List<Map<String, Object>> getGoodsUseInfoByFfOrderAndGoodId(Long goodsTemplateId, Long transBusinessId); /** - * 閫氳繃鍗曟嵁绫诲瀷 鍗曟嵁ID鏌ヨ璇ヨ鍗曞叧鑱旂殑璁惧鍨嬪彿浠ュ強鏁伴噺 - * + * 缁熻鍟嗗搧鍨嬪彿鏁伴噺 + * + * @param businessId * @return */ - public List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId) { - StringBuilder sql = new StringBuilder(GET_MODEL_BY_FORM); - HashMap<String, Object> paramts = new HashMap<>(); - //椤圭洰闃舵id - if (businessType != null) { - sql.append(" and BUSINESS_TYPE=:businessType "); - paramts.put("businessType", businessType.getValue()); - } - if (businessType != null) { - sql.append(" and BUSINESS_ID=:businessId "); - paramts.put("businessId", businessId); - } - return this.select(sql.toString(), paramts, new LWhProcureModel()); - } + List<GoodsTemplateCountVO> getGoodsTemplateCountByBusinessId(Long businessId); + + /** + * 缁熻閲囪喘鍗曠墿鍝佸瀷鍙锋暟閲� + * + * @param businessId + * @return + */ + List<GoodsTemplateCountVO> getProcureCountByBusinessId(Long businessId); + + /** + * 鏍规嵁涓氬姟id鏌ヨ鍨嬪彿淇℃伅鍒楄〃 + * + * @param businessId + * @param procureGoodId + * @return + */ + List<GoodModelInfoDTO> getGoodsModelListByBusinessId(Long businessId, Long procureGoodId); + + List<LWhProcureModel> getModelByForm1(WhBusinessEnum whBusinessEnum, Long whFormProcureId); + + } -- Gitblit v1.9.1