| | |
| | | using System.Globalization; |
| | | using AngleSharp.Dom; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using MES.Service.util; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.service.BasicData; |
| | |
| | | var baOrUpdate = db.Insertable(mesWomcabss).PageSize(1) |
| | | .IgnoreColumnsNull() |
| | | .ExecuteCommand() > 0; |
| | | |
| | | |
| | | if (orUpdate && baOrUpdate) return true; |
| | | |
| | | throw new NotImplementedException("插入或更新失败"); |
| | |
| | | { |
| | | Caa001 = erpDto.FBillNo, |
| | | DepotCode = erpDto.FStockID, |
| | | CreateDate = erpDto.FDate,// ParseDateTime(erpDto.FDate) ?? null, |
| | | CreateDate = erpDto.FDate, // ParseDateTime(erpDto.FDate) ?? null, |
| | | Caa004 = erpDto.FBillType, |
| | | Caa023 = erpDto.FStatus, |
| | | Caa006 = erpDto.FMaterialId, |
| | |
| | | WorkGroupId = erpDto.FWorkGroupId, |
| | | PlanId = erpDto.FPlannerID, |
| | | Caa010 = erpDto.FPlanStartDate, |
| | | //ParseDateTime(erpDto.FPlanStartDate) ?? null, |
| | | //ParseDateTime(erpDto.FPlanStartDate) ?? null, |
| | | Caa011 = erpDto.FPlanFinishDate, |
| | | //ParseDateTime(erpDto.FPlanFinishDate) ?? null, |
| | | |
| | | PLANCONFIRMATION = erpDto.PlanConfirmation, |
| | | StockInlimith = erpDto.FStockInLimitH,//Convert.ToDecimal(erpDto.FStockInLimitH), |
| | | StockInlimitl = erpDto.FStockInLimitL,//Convert.ToDecimal(erpDto.FStockInLimitL), |
| | | StockInlimith = |
| | | erpDto |
| | | .FStockInLimitH, //Convert.ToDecimal(erpDto.FStockInLimitH), |
| | | StockInlimitl = |
| | | erpDto |
| | | .FStockInLimitL, //Convert.ToDecimal(erpDto.FStockInLimitL), |
| | | Mtono = erpDto.FMTONO, |
| | | Lot = erpDto.FLot, |
| | | Caa013 = erpDto.FBomId, |
| | |
| | | Erpid = Convert.ToDecimal(erpDto.FID), |
| | | FSUBENTRYID = erpDto.FSUBENTRYID, |
| | | FPURORDERNO = erpDto.FPurOrderNo, |
| | | FPURORDERENTRYSEQ = erpDto.FPurOrderEntrySeq,//Convert.ToInt32(erpDto.FPurOrderEntrySeq), |
| | | FPURORDERENTRYSEQ = |
| | | erpDto |
| | | .FPurOrderEntrySeq, //Convert.ToInt32(erpDto.FPurOrderEntrySeq), |
| | | FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty), |
| | | FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty), |
| | | FINSTOCKOWNERID = erpDto.FInStockOwnerId, |
| | |
| | | var productionOrderSub = new Womcab |
| | | { |
| | | Cab001 = erpDto.FBillNo, |
| | | Cab002 = erpDto.FSEQ,//Convert.ToInt32(erpDto.FSEQ), |
| | | Cab002 = erpDto.FSEQ, //Convert.ToInt32(erpDto.FSEQ), |
| | | Cab003 = erpDto.FMaterialID2, |
| | | MustQty = Convert.ToDecimal(erpDto.FMustQty), |
| | | Cab006 = Convert.ToDecimal(erpDto.FMustQty), |
| | |
| | | ErpProductionEntryCode = erpDto.FSUBENTRYID |
| | | }; |
| | | |
| | | var single = base.GetSingle(it => it.Erpid == productionOrderSub.Erpid); |
| | | var single = |
| | | base.GetSingle(it => it.Erpid == productionOrderSub.Erpid); |
| | | if (single != null) productionOrderSub.Id = single.Id; |
| | | |
| | | productionOrderSubList.Add(productionOrderSub); |