| | |
|---|
| | | List<FullStoreParam.MatCodeStore> erpMatList = param.getList(); |
|---|
| | | for (FullStoreParam.MatCodeStore es : erpMatList) { |
|---|
| | | if (Cools.isEmpty(es.getStr6())) { |
|---|
| | | String maxKeySql = "select max(FInterID) as num from CPICMO"; |
|---|
| | | String maxKeySql = "select min(FInterID) as num from CPICMO"; |
|---|
| | | List<ERPselectParam> maxKeyList = erpSqlServer.select(maxKeySql, ERPselectParam.class); |
|---|
| | | Integer maxKey = maxKeyList.get(0).getNum(); |
|---|
| | | String ErpSql = "insert into CPICMO(FBrNo, FSourceBillNo, FBillNo, FTranType, FStatus, FMRP, FItemID, FQty, FCommitQty, FSourceEntryID, FClosed, FUnitID, FAuxCommitQty, FCancellation, FQtyFinish, FQtyScrap, FQtyLost, FAuxQtyFinish, FAuxQtyScrap, FAuxQtyLost, FMrpClosed, FBomInterID, FQtyPass, FAuxQtyPass, FQtyBack, FAuxQtyBack, FFinishTime, FReadyTIme, FPowerCutTime, FFixTime, FWaitItemTime, FWaitToolTime, FTaskID, FWorkTypeID, FCostObjID, FStockQty, FAuxStockQty, FSuspend, FReleasedQty, FReleasedAuxQty, FUnScheduledQty, FUnScheduledAuxQty, FSubEntryID, FScheduleID, FPlanOrderInterID, FProcessPrice, FProcessFee, FGMPBatchNo, FGMPCollectRate, FGMPItemBalance, FGMPBulkQty, FCustID, FMRPLockFlag, FHandworkClose, FInHighLimit, FInHighLimitQty, FInLowLimit, FInLowLimitQty, FChangeTimes, FCheckCommitQty, FAuxCheckCommitQty, FPlanConfirmed, FPlanMode, FMTONo, FPrintCount, FFinClosed, FStockFlag, FStartFlag, FVchBillNo, FVchInterID, FCardClosed, FHRReadyTime, FSourceTranType, FSourceInterId, FInterID, FAuxQty, FAuxInHighLimitQty, FAuxInLowLimitQty, Fnumber, FWorkShop) values (0, ''{6}'', '0', 85, 0, 1052, 0, 0, 0, 0, 0, 250, {5,number,#}, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14036, '0', 0, 0, 14215, 0, '0', 0, 1059, 0, 0, 0, 0, {0,number,#}, {1,number,#}, {2,number,#}, {3,number,#}, ''{4}'', 11378)"; |
|---|
| | | ErpSql = MessageFormat.format(ErpSql, maxKey + 1, es.getCount(), es.getCount(), es.getCount(), es.getMatNo(), es.getCount(), es.getStr5()); |
|---|
| | | ErpSql = MessageFormat.format(ErpSql, maxKey - 1, es.getCount(), es.getCount(), es.getCount(), es.getMatNo(), es.getCount(), es.getStr5()); |
|---|
| | | erpSqlServer.update(ErpSql); |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | } |
|---|
| | | // 生成工作档明细 |
|---|
| | | for (LocDetlDto detlDto : dto.getLocDetlDtos()) { |
|---|
| | | // 如果为捡料出库需要判断托盘码是否为空 |
|---|
| | | if (ioType == 103) { |
|---|
| | | String zpallet = detlDto.getLocDetl().getZpallet(); |
|---|
| | | if (Cools.isEmpty(zpallet)) { |
|---|
| | | throw new CoolException("拣料出库必须含有托盘码"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // 出库时，数量为0的直接忽略 |
|---|
| | | if (detlDto.getCount() == null || detlDto.getCount() <= 0.0D) { |
|---|
| | | continue; |
|---|
