From 58652618b0776f3ebe271c6a0f585e4a0dc60877 Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期四, 25 九月 2025 16:43:16 +0800
Subject: [PATCH] 初始化
---
src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java | 5
src/main/java/com/zy/asrs/service/MatBarcodeService.java | 10 +
src/main/resources/mapper/LocMastMapper.xml | 4
src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java | 15 ++
src/main/java/com/zy/asrs/controller/MobileController.java | 68 +++++++++++
src/main/java/com/zy/common/web/WcsController.java | 11 -
src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java | 13 ++
src/main/java/com/zy/common/model/LocTypeDto.java | 6
src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 2
src/main/resources/mapper/MatBarcodeMapper.xml | 55 +++++++++
src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java | 32 +++++
src/main/java/com/zy/asrs/service/LocMastService.java | 2
src/main/java/com/zy/common/service/CommonService.java | 54 ---------
src/main/java/com/zy/asrs/entity/MatBarcode.java | 26 ++++
14 files changed, 237 insertions(+), 66 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/MobileController.java b/src/main/java/com/zy/asrs/controller/MobileController.java
index 1081145..254b39c 100644
--- a/src/main/java/com/zy/asrs/controller/MobileController.java
+++ b/src/main/java/com/zy/asrs/controller/MobileController.java
@@ -14,6 +14,7 @@
import com.zy.asrs.mapper.ManLocDetlMapper;
import com.zy.asrs.service.*;
import com.zy.common.model.WrkDto;
+import com.zy.common.service.CommonService;
import com.zy.common.web.BaseController;
import com.zy.system.entity.license.AbstractServerInfos;
import org.apache.logging.log4j.LogManager;
@@ -57,6 +58,12 @@
private ManLocDetlMapper manLocDetlMapper;
@Autowired
private WrkDetlLogService wrkDetlLogService;
+ @Autowired
+ private MatService matService;
+ @Autowired
+ private MatBarcodeService matBarcodeService;
+ @Autowired
+ private CommonService commonService;
private static Logger logger = LogManager.getLogger(MobileController.class);
@@ -485,5 +492,64 @@
return R.ok().add(vos);
}
-
+ @RequestMapping("/callBarcode")
+ @ManagerAuth(memo = "PDA鍛煎彨鎵樼洏鍑哄簱")
+ public R callBarcode(@RequestBody CombParam combParam) {
+ logger.info("PDA鍛煎彨鎵樼洏鍑哄簱");
+ if (combParam == null){
+ return R.parse(BaseRes.PARAM);
+ }
+ combParam.getCombMats().forEach(combMat -> {
+ Mat mat = matService.selectByMatnr(combMat.getMatnr());
+ if (mat == null){
+ throw new CoolException("鍟嗗搧妗ｆ涓嶅瓨鍦�");
+ }
+ MatBarcode matBarcode = matBarcodeService.selectbyMatnr(combMat.getMatnr());
+ if (matBarcode == null){
+ throw new CoolException("璇ョ墿鏂欐湭涓庢墭鐩樼粦瀹�");
+ }
+ LocMast locMast=locMastService.selectByBarcode(matBarcode.getZpallet());
+ if (locMast == null){
+ throw new CoolException("鏈壘鍒颁笌璇ョ墿鏂欑粦瀹氱殑鎵樼洏");
+ }
+ int wrkNo=commonService.getWorkNo(0);
+ Date now = new Date();
+ //鐢熸垚宸ヤ綔妗�
+ WrkMast wrkMast=new WrkMast();
+ wrkMast.setWrkNo(wrkNo);
+ wrkMast.setIoTime(new Date());
+ wrkMast.setWrkSts(11L);//宸ヤ綔鐘舵�侊細鐢熸垚鍑哄簱ID
+ wrkMast.setIoType(101);//鍏ュ嚭搴撶姸鎬侊細骞舵澘鍑哄簱
+ wrkMast.setIoPri(13D);//浼樺厛绾�
+ wrkMast.setCrnNo(locMast.getCrnNo());
+// wrkMast.setSourceStaNo(dto.getSourceStaNo());//婧愮珯
+ wrkMast.setStaNo(101);// 鐩爣绔�
+ wrkMast.setSourceLocNo(locMast.getLocNo());// 婧愬簱浣�
+ wrkMast.setBarcode(matBarcode.getZpallet()); // 鎵樼洏鐮�
+ wrkMast.setFullPlt("Y"); // 婊℃澘锛歒
+ wrkMast.setPicking("N"); // 鎷ｆ枡
+ wrkMast.setExitMk("N"); // 閫�鍑�
+ wrkMast.setEmptyMk("N"); // 绌烘澘
+ wrkMast.setLinkMis("Y");
+// wrkMast.setScWeight(weight);
+ wrkMast.setCtnType(0); // 瀹瑰櫒绫诲瀷
+ // 鎿嶄綔浜哄憳鏁版嵁
+ wrkMast.setAppeTime(now);
+ wrkMast.setModiTime(now);
+ boolean res = wrkMastService.insert(wrkMast);
+ if (!res) {
+ throw new CoolException("淇濆瓨宸ヤ綔妗ｅけ璐�");
+ }
+ if (locMast.getLocSts().equals("F")) {
+ locMast.setLocSts("R"); // R.鍑哄簱棰勭害
+ locMast.setModiTime(now);
+ if (!locMastService.updateById(locMast)) {
+ throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
+ }
+ } else {
+ throw new CoolException(locMast.getLocNo() + "鐩爣搴撲綅鐘舵�佷笉涓篎");
+ }
+ });
+ return R.ok();
+ }
}
diff --git a/src/main/java/com/zy/asrs/entity/MatBarcode.java b/src/main/java/com/zy/asrs/entity/MatBarcode.java
new file mode 100644
index 0000000..88a6dd1
--- /dev/null
+++ b/src/main/java/com/zy/asrs/entity/MatBarcode.java
@@ -0,0 +1,26 @@
+package com.zy.asrs.entity;
+
+import com.baomidou.mybatisplus.annotations.TableName;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.io.Serializable;
+
+@Data
+@TableName("cust_matnr_barcode")
+public class MatBarcode implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @ApiModelProperty(value= "鎵樼洏鏉＄爜")
+ private String zpallet;
+ @ApiModelProperty(value= "鍟嗗搧缂栧彿")
+ private String matnr;
+
+ @ApiModelProperty(value= "鍟嗗搧鍚嶇О")
+ private String maktx;
+ @ApiModelProperty(value= "瑙勬牸")
+ private String specs;
+
+ @ApiModelProperty(value= "鍨嬪彿")
+ private String model;
+}
diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
index d0d5663..147075a 100644
--- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
@@ -45,4 +45,6 @@
* 鑾峰彇鐩爣搴撲綅鎵�鍦ㄥ贩閬撴渶娣辩┖搴撲綅 娣�<娴�
* */
LocMast selectLocByLocStsPakInO2(@Param("locNos") List<String> locNos);
+
+ LocMast selectByBarcode(@Param("zpallet")String zpallet);
}
diff --git a/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
new file mode 100644
index 0000000..358f782
--- /dev/null
+++ b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
@@ -0,0 +1,13 @@
+package com.zy.asrs.mapper;
+
+import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.zy.asrs.entity.MatBarcode;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.stereotype.Repository;
+
+@Mapper
+@Repository
+public interface MatBarcodeMapper extends BaseMapper<MatBarcode> {
+ MatBarcode selectByMatnr(@Param("matnr")String matnr);
+}
diff --git a/src/main/java/com/zy/asrs/service/LocMastService.java b/src/main/java/com/zy/asrs/service/LocMastService.java
index d7781a9..170263e 100644
--- a/src/main/java/com/zy/asrs/service/LocMastService.java
+++ b/src/main/java/com/zy/asrs/service/LocMastService.java
@@ -50,4 +50,6 @@
* 鑾峰彇鐩爣搴撲綅鎵�鍦ㄥ贩閬撴渶娣辩┖搴撲綅
* */
LocMast selectLocByLocStsPakInO(Integer curRow,Integer nearRow,List<String> locNos);
+
+ LocMast selectByBarcode(String zpallet);
}
diff --git a/src/main/java/com/zy/asrs/service/MatBarcodeService.java b/src/main/java/com/zy/asrs/service/MatBarcodeService.java
new file mode 100644
index 0000000..5569ece
--- /dev/null
+++ b/src/main/java/com/zy/asrs/service/MatBarcodeService.java
@@ -0,0 +1,10 @@
+package com.zy.asrs.service;
+
+import com.baomidou.mybatisplus.service.IService;
+import com.zy.asrs.entity.MatBarcode;
+import org.springframework.stereotype.Service;
+
+@Service
+public interface MatBarcodeService extends IService<MatBarcode> {
+ MatBarcode selectbyMatnr(String matnr);
+}
diff --git a/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java
index 8077398..da0787a 100644
--- a/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java
@@ -66,6 +66,11 @@
}
@Override
+ public LocMast selectByBarcode(String zpallet) {
+ return this.baseMapper.selectByBarcode(zpallet);
+ }
+
+ @Override
public Boolean checkWhole(List<LocDetl> locDetls) {
return null;
}
diff --git a/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java
new file mode 100644
index 0000000..e81aacc
--- /dev/null
+++ b/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java
@@ -0,0 +1,15 @@
+package com.zy.asrs.service.impl;
+
+import com.baomidou.mybatisplus.service.impl.ServiceImpl;
+import com.zy.asrs.entity.MatBarcode;
+import com.zy.asrs.mapper.MatBarcodeMapper;
+import com.zy.asrs.service.MatBarcodeService;
+import org.springframework.stereotype.Service;
+
+@Service("MatBarcodeService")
+public class MatBarcodeServiceImpl extends ServiceImpl<MatBarcodeMapper, MatBarcode> implements MatBarcodeService {
+ @Override
+ public MatBarcode selectbyMatnr(String matnr) {
+ return this.baseMapper.selectByMatnr(matnr);
+ }
+}
diff --git a/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java
index febbe53..581552b 100644
--- a/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java
@@ -71,6 +71,8 @@
private ManLocDetlService manLocDetlService;
@Autowired
private ManLocDetlMapper manLocDetlMapper;
+ @Autowired
+ private MatBarcodeService matBarcodeService;
@Override
@@ -126,6 +128,18 @@
if (Cools.isEmpty(mat)) {
throw new CoolException(detlDto.getMatnr() + "鍟嗗搧妗ｆ涓嶅瓨鍦�");
}
+ //鏍￠獙褰撳墠鐗╂枡涓庢墭鐩樼粦瀹氫俊鎭槸鍚︽纭�
+ MatBarcode matBarcode = new MatBarcode();
+ MatBarcode mb=matBarcodeService.selectbyMatnr(detlDto.getMatnr());
+ if (mb != null && !mb.getZpallet().equals(param.getBarcode())){
+ throw new CoolException(detlDto.getMatnr()+"璇ョ墿鏂欎笌鍏朵粬鎵樼洏缁戝畾锛岃鍏堣В缁�");
+ }else{
+ matBarcode.setZpallet(param.getBarcode());//鎵樼洏鐮�
+ matBarcode.setMatnr(mat.getMatnr());//鐗╂枡鍙�
+ matBarcode.setMaktx(mat.getMaktx());//鐗╂枡鍚嶇О
+ matBarcode.setSpecs(mat.getSpecs());//瑙勬牸
+ matBarcode.setModel(mat.getModel());//鍨嬪彿
+ }
WaitPakin waitPakin = new WaitPakin();
waitPakin.sync(mat);
waitPakin.setProType(detlDto.getProType());
@@ -142,6 +156,9 @@
waitPakin.setModiTime(now);
if (!waitPakinService.insert(waitPakin)) {
throw new CoolException("淇濆瓨鍏ュ簱閫氱煡妗ｅけ璐�");
+ }
+ if (!matBarcodeService.insert(matBarcode)){
+ throw new CoolException("鐗╂枡涓庢墭鐩樼粦瀹氬け璐�");
}
}
// 鍏宠仈缁勬墭
@@ -170,6 +187,18 @@
if (Cools.isEmpty(mat)) {
throw new CoolException(orderDetl.getMatnr() + "鍟嗗搧妗ｆ涓嶅瓨鍦�");
}
+ //鏍￠獙褰撳墠鐗╂枡涓庢墭鐩樼粦瀹氫俊鎭槸鍚︽纭�
+ MatBarcode matBarcode = new MatBarcode();
+ MatBarcode mb=matBarcodeService.selectbyMatnr(orderDetl.getMatnr());
+ if (mb != null && !mb.getZpallet().equals(param.getBarcode())){
+ throw new CoolException(orderDetl.getMatnr()+"璇ョ墿鏂欎笌鍏朵粬鎵樼洏缁戝畾锛岃鍏堣В缁�");
+ }else{
+ matBarcode.setZpallet(param.getBarcode());//鎵樼洏鐮�
+ matBarcode.setMatnr(mat.getMatnr());//鐗╂枡鍙�
+ matBarcode.setMaktx(mat.getMaktx());//鐗╂枡鍚嶇О
+ matBarcode.setSpecs(mat.getSpecs());//瑙勬牸
+ matBarcode.setModel(mat.getModel());//鍨嬪彿
+ }
WaitPakin waitPakin = new WaitPakin();
waitPakin.sync(mat);
waitPakin.setOrderNo(order.getOrderNo()); // 鍗曟嵁缂栧彿
@@ -192,6 +221,9 @@
if (!waitPakinService.insert(waitPakin)) {
throw new CoolException("淇濆瓨鍏ュ簱閫氱煡妗ｅけ璐�");
}
+ if (!matBarcodeService.insert(matBarcode)){
+ throw new CoolException("鐗╂枡涓庢墭鐩樼粦瀹氬け璐�");
+ }
});
orderService.updateSettle(order.getId(), 2L, userId);
diff --git a/src/main/java/com/zy/common/model/LocTypeDto.java b/src/main/java/com/zy/common/model/LocTypeDto.java
index c6630aa..d68e24f 100644
--- a/src/main/java/com/zy/common/model/LocTypeDto.java
+++ b/src/main/java/com/zy/common/model/LocTypeDto.java
@@ -13,7 +13,7 @@
@Data
public class LocTypeDto {
- // 楂樹綆绫诲瀷{0:鏈煡,1:浣庡簱浣�,2:楂樺簱浣峿
+ // 楂樹綆绫诲瀷{0:鏈煡,1:浣庡簱浣�,2:楂樺簱浣�,3:涓簱浣峿
private Short locType1;
// 瀹界獎绫诲瀷{0:鏈煡,1:绐勫簱浣�,2:瀹藉簱浣峿
@@ -31,8 +31,10 @@
}
if (basDevp.getLocType1() == 1) {
this.locType1 = 1; // 浣庡簱浣�
- } else {
+ } else if (basDevp.getLocType1() ==2){
this.locType1 = 2; // 楂樺簱浣�
+ } else {
+ this.locType1 = 3; // 涓簱浣�
}
log.info(JSON.toJSONString(this));
}
diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 9c1a0d7..319a188 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -126,12 +126,6 @@
return getLocNo(whsType,staDescId,sourceStaNo,matnr,batch,grade,0,locTypeDto,0);
}
- @Transactional
- public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, LocTypeDto locTypeDto,String barcode) {
- whsType = Utils.GetWhsType(sourceStaNo);
- return getLocNo1(whsType,staDescId,sourceStaNo,matnr,batch,grade,0,locTypeDto,0,barcode);
- }
-
/**
* 妫�绱㈠簱浣嶅彿
*
@@ -369,54 +363,6 @@
startupDto.setCrnNo(crnNo);
startupDto.setSourceStaNo(sourceStaNo);
startupDto.setLocNo(locNo);
- return startupDto;
- }
-
- /*
- * 妫�绱㈠簱浣嶅彿
- * */
- @Transactional
- public StartupDto getLocNo1(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, Integer moveCrnNo, LocTypeDto locTypeDto, int times,String barcode){
- StartupDto startupDto = new StartupDto();
- Wrapper<StaDesc> wrapper = null;
- StaDesc staDesc = null;
- BasDevp staNo = null;
- int crnNo = 1; //鍫嗗灈鏈哄彿
- if (Utils.BooleanWhsTypeSta(whsType, staDescId)) {
- // 鑾峰彇鐩爣绔�
- wrapper = new EntityWrapper<StaDesc>()
- .eq("type_no", staDescId)
- .eq("stn_no", sourceStaNo)
- .eq("crn_no", crnNo);
- staDesc = staDescService.selectOne(wrapper);
- if (Cools.isEmpty(staDesc)) {
- log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo);
- throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
-// crnNo = 0;
- }
- staNo = basDevpService.selectById(staDesc.getCrnStn());
- if (!staNo.getAutoing().equals("Y")) {
- throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
-// crnNo = 0;
- }
- startupDto.setStaNo(staNo.getDevNo());
- }
- int workNo = getWorkNo(0);
- startupDto.setWorkNo(workNo);
- startupDto.setSourceStaNo(sourceStaNo);
- startupDto.setCrnNo(1);
- //绗竴娆″叆搴�
- //鍚庣画鍏ュ簱锛堟墭鐩樺拰搴撲綅宸茬粡缁戝畾锛�
- LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("barcode", barcode));
- if (locMast != null){
- if (!locMast.getLocSts().equals("O")){
- log.error("涓庤鎵樼洏缁戝畾鐨勫簱浣嶅凡琚崰鐢紝鎵樼洏鐮侊細{}锛屽簱浣嶅彿锛歿}",barcode,locMast.getLocNo());
- } else {
- startupDto.setLocNo(locMast.getLocNo());
- }
- } else {
- //鎵樼洏涓庡簱浣嶆湭缁戝畾 璧扮涓�娆″叆搴撻�昏緫
- }
return startupDto;
}
}
diff --git a/src/main/java/com/zy/common/web/WcsController.java b/src/main/java/com/zy/common/web/WcsController.java
index 6d8de64..197356e 100644
--- a/src/main/java/com/zy/common/web/WcsController.java
+++ b/src/main/java/com/zy/common/web/WcsController.java
@@ -333,8 +333,7 @@
// 妫�绱㈠簱浣�
List<String> matnrs = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList());
List<String> batchs = waitPakins.stream().map(WaitPakin::getBatch).distinct().collect(Collectors.toList());
-// StartupDto dto = commonService.getLocNo(1, 1, devpNo, matnrs.get(0), batchs.get(0), null, locTypeDto);
- StartupDto dto = commonService.getLocNo(1, 1, devpNo, matnrs.get(0), batchs.get(0), null, locTypeDto,barcode);
+ StartupDto dto = commonService.getLocNo(1, 1, devpNo, matnrs.get(0), batchs.get(0), null, locTypeDto);
int workNo = dto.getWorkNo();
Date now = new Date();
// 鐢熸垚宸ヤ綔妗�
@@ -418,9 +417,6 @@
if (locMast.getLocSts().equals("O")) {
locMast.setLocSts("S"); // S.鍏ュ簱棰勭害
locMast.setModiTime(now);
- if (locMast.getBarcode()==null){
- locMast.setBarcode(barcode);//鎵樼洏涓庡簱浣嶇粦瀹�
- }
if (!locMastService.updateById(locMast)) {
throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
}
@@ -435,7 +431,7 @@
// 婧愮珯鐐圭姸鎬佹娴�
BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true);
// 妫�绱㈠簱浣�
- StartupDto dto = commonService.getLocNo(1, 10, devpNo, null, null, null, locTypeDto,barcode);
+ StartupDto dto = commonService.getLocNo(1, 10, devpNo, null, null, null, locTypeDto);
int workNo = dto.getWorkNo();
// 鐢熸垚宸ヤ綔妗�
WrkMast wrkMast = new WrkMast();
@@ -473,9 +469,6 @@
if (locMast.getLocSts().equals("O")) {
locMast.setLocSts("S"); // S.鍏ュ簱棰勭害
locMast.setModiTime(new Date());
- if (locMast.getBarcode()==null){
- locMast.setBarcode(barcode);//鎵樼洏涓庡簱浣嶇粦瀹�
- }
if (!locMastService.updateById(locMast)) {
throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
}
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index a9c6062..9a68082 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -116,4 +116,8 @@
AND loc_sts in ('O') order by row1
</select>
+ <select id="selectByBarcode" resultMap="BaseResultMap">
+ SELECT top 1 * FROM [dbo].[asr_loc_mast] WHERE barcode = #{zpallet}
+ </select>
+
</mapper>
diff --git a/src/main/resources/mapper/MatBarcodeMapper.xml b/src/main/resources/mapper/MatBarcodeMapper.xml
new file mode 100644
index 0000000..05b2e05
--- /dev/null
+++ b/src/main/resources/mapper/MatBarcodeMapper.xml
@@ -0,0 +1,55 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.zy.asrs.mapper.MatBarcodeMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.zy.asrs.entity.MatBarcode">
+ <result column="zpallet" property="zpallet" />
+<!-- <result column="loc_no" property="locNo" />-->
+<!-- <result column="anfme" property="anfme" />-->
+ <result column="matnr" property="matnr" />
+ <result column="maktx" property="maktx" />
+<!-- <result column="batch" property="batch" />-->
+<!-- <result column="order_no" property="orderNo" />-->
+
+ <result column="specs" property="specs" />
+ <result column="model" property="model" />
+<!-- <result column="color" property="color" />-->
+<!-- <result column="brand" property="brand" />-->
+<!-- <result column="unit" property="unit" />-->
+<!-- <result column="price" property="price" />-->
+<!-- <result column="sku" property="sku" />-->
+<!-- <result column="units" property="units" />-->
+<!-- <result column="barcode" property="barcode" />-->
+<!-- <result column="origin" property="origin" />-->
+<!-- <result column="manu" property="manu" />-->
+<!-- <result column="manu_date" property="manuDate" />-->
+<!-- <result column="item_num" property="itemNum" />-->
+<!-- <result column="safe_qty" property="safeQty" />-->
+<!-- <result column="weight" property="weight" />-->
+<!-- <result column="length" property="length" />-->
+<!-- <result column="volume" property="volume" />-->
+<!-- <result column="three_code" property="threeCode" />-->
+<!-- <result column="supp" property="supp" />-->
+<!-- <result column="supp_code" property="suppCode" />-->
+<!-- <result column="be_batch" property="beBatch" />-->
+<!-- <result column="dead_time" property="deadTime" />-->
+<!-- <result column="dead_warn" property="deadWarn" />-->
+<!-- <result column="source" property="source" />-->
+<!-- <result column="inspect" property="inspect" />-->
+<!-- <result column="danger" property="danger" />-->
+
+<!-- <result column="status" property="status" />-->
+<!-- <result column="io_status" property="ioStatus" />-->
+
+<!-- <result column="modi_time" property="modiTime" />-->
+<!-- <result column="modi_user" property="modiUser" />-->
+<!-- <result column="appe_time" property="appeTime" />-->
+<!-- <result column="appe_user" property="appeUser" />-->
+<!-- <result column="memo" property="memo" />-->
+ </resultMap>
+
+ <select id="selectByMatnr" resultMap="BaseResultMap">
+ select top 1 * from cust_matnr_barcode where 1=1 and matnr = #{matnr}
+ </select>
+</mapper>
--
Gitblit v1.9.1