| | |
| | | var mesRohIn = GetMesRohIn(rohInErpRohIn); |
| | | var mesRohInDatas = |
| | | GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type); |
| | | var erpLineDetailsDB = GetErpLineDetailsDB(rohIn.ErpLineDetails, rohInErpRohIn.Type); |
| | | |
| | | var erpLineDetailsDB = GetErpLineDetailsDB(rohIn.ErpLineDetails, rohInErpRohIn.Type); |
| | | |
| | | |
| | | |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | |
| | | var ba1OrUpdate = db.Insertable(erpLineDetails).PageSize(1) |
| | | .IgnoreColumnsNull() |
| | | .ExecuteCommand() > 0; |
| | | if (erpLineDetails.Count==0) |
| | | if (erpLineDetails==null ||erpLineDetails.Count==0) |
| | | { |
| | | ba1OrUpdate = true; |
| | | } |
| | |
| | | var mesRohIn = new MesRohIn(); |
| | | |
| | | var single = base.GetSingle(it => it.EbelnK3id == eid); |
| | | if (single != null) mesRohIn.Id = single.Id; |
| | | if (single != null) |
| | | { |
| | | mesRohIn.Id = single.Id; |
| | | |
| | | if (single.CheckDate != null) |
| | | { |
| | | mesRohIn.CheckDate = single.CheckDate; |
| | | } |
| | | else |
| | | { |
| | | mesRohIn.CheckDate = DateTime.Now; |
| | | } |
| | | } |
| | | |
| | | var mesLinkU9 = Db.Queryable<MesLinkU9>() |
| | | .Where(s => s.U9Id == rohIn.FSupplierId |
| | |
| | | private List<ErpLineDetailsDB> GetErpLineDetailsDB( |
| | | List<ErpLineDetails> erpLineDetails, string type) |
| | | { |
| | | if (erpLineDetails ==null) |
| | | { |
| | | return null; |
| | | } |
| | | return erpLineDetails.Select(s => |
| | | { |
| | | var entity = new ErpLineDetailsDB |
| | |
| | | PlannedQty = s.PlannedQty, |
| | | SupplierConfirmsQty = s.SupplierConfirmsQty, |
| | | RequestDeliveryDate = s.RequestDeliveryDate, |
| | | ActualArrivalQty = s.ActualArrivalQty |
| | | ActualArrivalQty = s.ActualArrivalQty, |
| | | FReceiveQty=s.FReceiveQty |
| | | |
| | | |
| | | }; |