| | |
| | | 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), |
| | | //PLANCONFIRMATION = erpDto.PlanConfirmation, |
| | | StockInlimith = |
| | | erpDto |
| | | .FStockInLimitH, //Convert.ToDecimal(erpDto.FStockInLimitH), |
| | | StockInlimitl = |
| | | erpDto |
| | | .FStockInLimitL, //Convert.ToDecimal(erpDto.FStockInLimitL), |
| | | Mtono = erpDto.FMTONO, |
| | | Lot = erpDto.FLot, |
| | | Caa013 = erpDto.FBomId, |
| | | //SalesOrderNo = erpDto.F_UNW_XSDDH, |
| | | CreateType = erpDto.FCreateType, |
| | | FSUBID = erpDto.FSUBID, |
| | | FSUBBILLNOSEQ = erpDto.FSUBBILLNOSEQ, |
| | | FSUBBILLNO = erpDto.FSUBBILLNO, |
| | | //FSUBID = erpDto.FSUBID, |
| | | //FSUBBILLNOSEQ = erpDto.FSUBBILLNOSEQ, |
| | | //FSUBBILLNO = erpDto.FSUBBILLNO, |
| | | SrcBillType = erpDto.FSrcBillType, |
| | | SrcBillNo = erpDto.FSrcBillNo, |
| | | SrcBillentryseq = erpDto.FSrcBillEntrySeq, |
| | | FREQSRC = erpDto.FReqSrc, |
| | | //FREQSRC = erpDto.FReqSrc, |
| | | SaleOrderNo = erpDto.FSALEORDERNO, |
| | | SaleOrderEntryseq = erpDto.FSaleOrderEntrySeq, |
| | | ForceCloserid = erpDto.FFORCECLOSERID, |
| | | CloseType = erpDto.FCloseType, |
| | | SrcSplitBillno = erpDto.FDescription, |
| | | SRCSPLITSEQ = erpDto.SrcSplitSeq, |
| | | Erpid = Convert.ToDecimal(erpDto.FID), |
| | | FSUBENTRYID = erpDto.FSUBENTRYID, |
| | | FPURORDERNO = erpDto.FPurOrderNo, |
| | | FPURORDERENTRYSEQ = erpDto.FPurOrderEntrySeq,//Convert.ToInt32(erpDto.FPurOrderEntrySeq), |
| | | FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty), |
| | | FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty), |
| | | FINSTOCKOWNERID = erpDto.FInStockOwnerId, |
| | | //SRCSPLITSEQ = erpDto.SrcSplitSeq, |
| | | Erpid = Convert.ToDecimal(erpDto.FID) |
| | | //FSUBENTRYID = erpDto.FSUBENTRYID, |
| | | //FPURORDERNO = erpDto.FPurOrderNo, |
| | | //FPURORDERENTRYSEQ = |
| | | //erpDto |
| | | // .FPurOrderEntrySeq, //Convert.ToInt32(erpDto.FPurOrderEntrySeq), |
| | | //FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty), |
| | | //FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty), |
| | | //FINSTOCKOWNERID = erpDto.FInStockOwnerId, |
| | | //PlanConfirmation = erpDto.PlanConfirmation != null |
| | | // ? DateTime.ParseExact(erpDto.PlanConfirmation, |
| | | // "yyyy-MM-dd HH:mm:ss", null) |
| | | // : null, |
| | | Typea = erpDto.TypeA, |
| | | F_WWDD_SCTZD = erpDto.F_WWDD_SCTZD, |
| | | F_WWDD_XH = erpDto.F_WWDD_XH, |
| | | F_XIFG_TEXT_TZK = erpDto.F_XIFG_Text_tzk |
| | | // Typea = erpDto.TypeA, |
| | | // F_WWDD_SCTZD = erpDto.F_WWDD_SCTZD, |
| | | // F_WWDD_XH = erpDto.F_WWDD_XH, |
| | | // F_XIFG_TEXT_TZK = erpDto.F_XIFG_Text_tzk |
| | | }; |
| | | |
| | | var single = base.GetSingle(it => it.Erpid == entity.Erpid); |
| | |
| | | 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), |
| | | // MustQty = Convert.ToDecimal(erpDto.FMustQty), |
| | | Cab006 = Convert.ToDecimal(erpDto.FMustQty), |
| | | Cab007 = Convert.ToDecimal(erpDto.FPickedQty), |
| | | PositionNo = erpDto.FPositionNO, |
| | |
| | | Numerator = Convert.ToDecimal(erpDto.FNumerator), |
| | | Denominator = Convert.ToDecimal(erpDto.FDenominator), |
| | | Erpid = Convert.ToDecimal(erpDto.FPPOMENTRYID), |
| | | Eid = Convert.ToDecimal(erpDto.FPPOMID), |
| | | SCRAPQTY = Convert.ToDecimal(erpDto.FFixScrapQty), |
| | | SCRAPRATE = Convert.ToDecimal(erpDto.FScrapRate), |
| | | MaterialType = erpDto.FMaterialType, |
| | | //Unit2 = erpDto.FUnitID3, |
| | | Freplacegroup = Convert.ToInt32(erpDto.FReplaceGroup), |
| | | Eid = Convert.ToDecimal(erpDto.FPPOMID) |
| | | // SCRAPQTY = Convert.ToDecimal(erpDto.FFixScrapQty), |
| | | // SCRAPRATE = Convert.ToDecimal(erpDto.FScrapRate), |
| | | // MaterialType = erpDto.FMaterialType, |
| | | // //Unit2 = erpDto.FUnitID3, |
| | | // Freplacegroup = Convert.ToInt32(erpDto.FReplaceGroup), |
| | | //OwnerType = erpDto.FOwnerTypeId, |
| | | //Owner = erpDto.FOwnerID2, |
| | | |
| | | Fisgetscrap = erpDto.FISGETSCRAP, |
| | | Fiskeycomponent = erpDto.FISKEYCOMPONENT, |
| | | Fsrctransorgid = erpDto.FSRCTRANSORGID, |
| | | Fsrctransstockid = erpDto.FSRCTRANSSTOCKID, |
| | | Fstockstatusid = erpDto.FSTOCKSTATUSID, |
| | | Fneeddate = erpDto.FNEEDDATE != null |
| | | ? DateTime.ParseExact(erpDto.FNEEDDATE, |
| | | "yyyy-MM-dd HH:mm:ss", null) |
| | | : null, |
| | | Freservetype = erpDto.FRESERVETYPE, |
| | | Fmemo = erpDto.FMEMO, |
| | | Typeb = erpDto.TypeB, |
| | | ErpProductionEntryCode = erpDto.FSUBENTRYID |
| | | // Fisgetscrap = erpDto.FISGETSCRAP, |
| | | // Fiskeycomponent = erpDto.FISKEYCOMPONENT, |
| | | // Fsrctransorgid = erpDto.FSRCTRANSORGID, |
| | | // Fsrctransstockid = erpDto.FSRCTRANSSTOCKID, |
| | | // Fstockstatusid = erpDto.FSTOCKSTATUSID, |
| | | // Fneeddate = erpDto.FNEEDDATE != null |
| | | // ? DateTime.ParseExact(erpDto.FNEEDDATE, |
| | | // "yyyy-MM-dd HH:mm:ss", null) |
| | | // : null, |
| | | // Freservetype = erpDto.FRESERVETYPE, |
| | | // Fmemo = erpDto.FMEMO, |
| | | // Typeb = erpDto.TypeB, |
| | | // 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); |