| | |
| | | |
| | | //æ´æ°å¼ |
| | | bz30Config.Value = ""; |
| | | var gahter = wmsDB.mes_package_gather.Where(x => x.PackageCode == packageCode).FirstOrDefault(); |
| | | if (gahter != null) |
| | | var package = wmsDB.mes_package_gather.Where(x => x.PackageCode == packageCode).FirstOrDefault(); |
| | | if (package != null) |
| | | { |
| | | gahter.UpiStatus = (int)UpiStatusEnum.å·²ä¸çº¿; |
| | | gahter.AreaCode = (int)AreaCodeEnum.ä¸çº¿åºå; |
| | | package.UpiStatus = (int)UpiStatusEnum.å·²ä¸çº¿; |
| | | package.AreaCode = (int)AreaCodeEnum.ä¸çº¿åºå; |
| | | } |
| | | var upiList = wmsDB.mes_batchOrderUPI_new.Where(x => x.PackageCode == packageCode).ToList(); |
| | | foreach (var item in upiList) |
| | |
| | | } |
| | | //æ°å¢ä¸çº¿è®°å½ |
| | | mes_package_unline_record record = new mes_package_unline_record(); |
| | | record = ClassHelper.RotationMapping<mes_package_unline_record, mes_package_gather>(gahter); |
| | | record = ClassHelper.RotationMapping<mes_package_unline_record, mes_package_gather>(package); |
| | | record.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | record.CreateTime = DateTime.Now; |
| | | record.UpdateTime = DateTime.Now; |
| | | record.OpRemark = "ä¸çº¿"; |
| | | wmsDB.mes_package_unline_record.Add(record); |
| | | |
| | | //å¤ç表 mes_order_gather |
| | | var isAddOrder = false; |
| | | var packageList = wmsDB.mes_package_gather.Where(x => x.Info5 == package.Info5).ToList(); |
| | | if (packageList == null || packageList?.Count == 0) |
| | | { |
| | | SystemWarningMsg._lbl_Alert_DataProcess_ValidateQiTao = $"æ²¡ææ¾å°ç产åå·{package.Info5}çæ±æ»æ°æ®"; |
| | | continue; |
| | | } |
| | | var order = wmsDB.mes_order_gather.Where(x => x.Info5 == package.Info5).FirstOrDefault(); |
| | | if (order != null) |
| | | { |
| | | |
| | | } |
| | | else |
| | | { |
| | | order = new mes_order_gather() |
| | | { |
| | | Id = Yitter.IdGenerator.YitIdHelper.NextId(), |
| | | Info5 = package.Info5, |
| | | OrderId = package.OrderId, |
| | | PlanNo = package.PlanNo, |
| | | }; |
| | | isAddOrder = true; |
| | | } |
| | | order.PackageNum = packageList.Count(); |
| | | order.UnLinePackageNum = packageList.Where(x => x.UpiStatus == (int)UpiStatusEnum.å·²ä¸çº¿).Count(); |
| | | order.NoUnLinePackageNum = order.PackageNum - order.UnLinePackageNum; |
| | | |
| | | order.AllPackageArea = packageList.Sum(x => Convert.ToDecimal(x.Info13)); |
| | | order.ScanPackageArea = packageList.Where(x => x.UpiStatus == (int)UpiStatusEnum.å·²ä¸çº¿).Sum(x => Convert.ToDecimal(x.Info13)); |
| | | order.NoScanPackageArea = order.AllPackageArea - order.ScanPackageArea; |
| | | order.IsKitting = qitaoValue == "é½å¥" ? true : false; |
| | | |
| | | if (isAddOrder) |
| | | { |
| | | wmsDB.mes_order_gather.Add(order); |
| | | } |
| | | |
| | | |
| | | wmsDB.SaveChanges(); |
| | | } |