| | |
| | | { |
| | | var rohInErpRohIn = rohIn.ErpRohIn; |
| | | var mesRohIn = GetMesRohIn(rohInErpRohIn); |
| | | var mesRohInDatas = |
| | | GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type); |
| | | var mesRohInDatas = GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | |
| | | return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | case "5": |
| | | case "B": |
| | | return SaveOrUpdateData(db, mesRohIn, mesRohInDatas) |
| | | ? 1 |
| | | : 0; |
| | |
| | | mesRohIn.DocumentStatus = rohIn.FDocumentStatus; |
| | | mesRohIn.DocumentType = rohIn.FBillTypeID; |
| | | mesRohIn.BusinessType = rohIn.FBusinessType; |
| | | |
| | | if (rohIn.FDate != null) |
| | | mesRohIn.PurchaseDate = DateTime.ParseExact(rohIn.FDate, |
| | | "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | mesRohIn.PurchaseDate = DateTime.ParseExact(rohIn.FDate,"yyyy-MM-dd HH:mm:ss", null); |
| | | mesRohIn.Supplier = rohIn.FSupplierId; |
| | | mesRohIn.CloseStatus = rohIn.FCloseStatus; |
| | | mesRohIn.PurchaseOrg = rohIn.FPurchaseOrgId; |
| | | mesRohIn.PurchaseDept = rohIn.FPurchaseDeptId; |
| | | mesRohIn.PurchaseGroup = rohIn.FPurchaserGroupId; |
| | | mesRohIn.QtyAcceptance = rohIn.Facctype; |
| | | mesRohIn.Purchaser = rohIn.FPurchaserId; |
| | | mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq; |
| | | mesRohIn.SettlementParty = rohIn.FSettleId; |
| | | mesRohIn.PaymentParty = rohIn.FChargeId; |
| | | mesRohIn.Email = rohIn.FProviderEMail; |
| | | mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs; |
| | | mesRohIn.Remarks = rohIn.F_UNW_BZ; |
| | | mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj; |
| | | mesRohIn.CancellationStatus = rohIn.FCancelStatus; |
| | | mesRohIn.CancellationPerson = rohIn.FCancellerId; |
| | | |
| | |
| | | "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | mesRohIn.CreateBy = rohIn.FCreatorId; |
| | | |
| | | if (rohIn.FCreateDate != null) |
| | | mesRohIn.CreateDate = DateTime.ParseExact(rohIn.FCreateDate, |
| | | "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | mesRohIn.LastupdateBy = rohIn.FModifierId; |
| | | |
| | | if (rohIn.FModifyDate != null) |
| | |
| | | |
| | | mesRohIn.ErpCheckBy = rohIn.FApproverId; |
| | | mesRohIn.ErpCheckDate = rohIn.FApproveDate; |
| | | mesRohIn.Changereason = rohIn.FCHANGEREASON; |
| | | mesRohIn.Changereason = rohIn.FChangeReason; |
| | | mesRohIn.CreateDate = DateTime.Now; |
| | | mesRohIn.ReceiveOrg = Convert.ToDecimal(rohIn.FReceiveOrgId); |
| | | |
| | | return mesRohIn; |
| | | } |
| | |
| | | EbelnK3id = Convert.ToDecimal(s.id), |
| | | ErpId = Convert.ToDecimal(s.Eid), |
| | | BillNo = s.FBillNo, |
| | | SalesOrderId = s.F_UNW_Text_xsddh, |
| | | OrderLineId=s.FSeq, |
| | | PurchaseOrderLineNumber = s.FSeq, |
| | | SalesOrderId = s.FXSHTH, |
| | | ItemId = s.FMaterialId, |
| | | PurchaseUnit = s.FUnitId, |
| | | PurchaseQty = Convert.ToDecimal(s.FQty), |
| | |
| | | "yyyy-MM-dd HH:mm:ss", null) |
| | | : null, |
| | | IsGift = s.FGiveAway, |
| | | Remarks = s.FEntryNote, |
| | | Remarks = s.FNote, |
| | | SupplierItemCode = s.FSupMatId, |
| | | SupplierItemName = s.FSupMatName, |
| | | OutsourcingOrderId = s.FSUBREQBILLNO, |
| | | OutsourcingOrderId = s.FSubreqBillNo, |
| | | BatchNumber = s.FLot, |
| | | BusinessClose = s.FMRPCloseStatus, |
| | | BusinessFreeze = s.FMRPFreezeStatus, |
| | |
| | | ? DateTime.ParseExact(s.FTerminateDate, |
| | | "yyyy-MM-dd HH:mm:ss", null) |
| | | : null, |
| | | TotalReceivedQty = Convert.ToDecimal(s.FReceiveQty), |
| | | RemainingReceivedQty = |
| | | Convert.ToDecimal(s.FRemainReceiveQty), |
| | | TotalStoredQty = Convert.ToDecimal(s.FStockInQty), |
| | | TotalReceivedQty = Convert.ToDecimal(s.FQty)-Convert.ToDecimal(s.FRemainReceiveQty), |
| | | RemainingReceivedQty = Convert.ToDecimal(s.FRemainReceiveQty), |
| | | TotalStoredQty = Convert.ToDecimal(s.FQty) - Convert.ToDecimal(s.FRemainStockINQty), |
| | | RemainingStoredQty = Convert.ToDecimal(s.FRemainStockINQty), |
| | | TotalReturnedQty = Convert.ToDecimal(s.FMrbQty), |
| | | ReturnableReceivedQty = Convert.ToDecimal(s.FCHECKRETQTY), |
| | | ReturnableStoredQty = Convert.ToDecimal(s.FSTOCKRETQTY), |
| | | ReturnableReceivedQty = Convert.ToDecimal(s.FBaseCheckRetQty), |
| | | ReturnableStoredQty = Convert.ToDecimal(s.FBaseStockRetQty), |
| | | SourceDocumentType = s.FSrcBillTypeId, |
| | | SourceDocumentId = s.FSrcBillNo, |
| | | DemandTrackingId = s.FReqTraceNo, |
| | | PlanTrackingId = s.FMtoNo, |
| | | ChangeFlag = s.FChangeFlag, |
| | | DemandSource = s.FDEMANDTYPE, |
| | | DemandDocumentId = s.FDEMANDBILLNO, |
| | | DemandDocumentLineId = s.FDEMANDBILLENTRYSEQ, |
| | | PurchaseOrderLineNumber = s.PurchaseOrderLineNumber, |
| | | Demand = s.Demand, |
| | | Receiving = s.Receiving, |
| | | Settlement = s.Settlement |
| | | DemandSource = s.FDemandType, |
| | | DemandDocumentId = s.FDemandBillNo, |
| | | DemandDocumentLineId = s.FDemandBillEntrySeq, |
| | | Demand = s.FRequireOrgId, |
| | | DemandOrg = s.FRequireOrgId, |
| | | Receiving = s.FReceiveOrgId, |
| | | ReceivingOrg = s.FReceiveOrgId, |
| | | Settlement = s.FEntrySettleOrgId, |
| | | SettlementOrg = s.FEntrySettleOrgId, |
| | | DemandDept = s.FRequireDeptId, |
| | | ReceivingDept = s.FReceiveDeptId |
| | | }; |
| | | |
| | | var single = rohInDataManager.GetSingle(it => |