| | |
| | | .First(); |
| | | |
| | | if (mesItemBl == null) |
| | | throw new Exception($"申请单 {query.blNo} 已撤回!"); |
| | | throw new Exception($"申请单 {query.blNo} 不存在!"); |
| | | |
| | | if (mesItemBl.Bl018 != true) |
| | | throw new Exception($"申请单 {query.blNo} 未审核!"); |
| | |
| | | // 检查并更新出库单物料明细 |
| | | var itemCount = db.Queryable<MesInvItemOutItems>() |
| | | .Where(i => |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId && i.DepotId == stockBarcode.DepotsId.ToString()) |
| | | i.ItemOutId == outId && i.ItemDabid == blDetail.Id && i.ItemId == stockBarcode.ItemId && i.DepotId == stockBarcode.DepotId.ToString()) |
| | | .Count(); |
| | | |
| | | if (itemCount > 0) |
| | |
| | | .SetColumns(i => |
| | | i.TlQty == i.TlQty + stockBarcode.Quantity) |
| | | .Where(i => |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId && i.DepotId == stockBarcode.DepotsId.ToString()) |
| | | i.ItemOutId == outId && i.ItemDabid == blDetail.Id && i.ItemId == stockBarcode.ItemId && i.DepotId == stockBarcode.DepotId.ToString()) |
| | | .ExecuteCommand(); |
| | | else |
| | | // 插入新的物料明细记录 |
| | |
| | | Guid = Guid.NewGuid(), |
| | | ItemOutId = outId, |
| | | ItemNo = blDetail.Bld002, |
| | | Quantity = stockBarcode.Quantity, |
| | | Quantity = blDetail.Bld007, |
| | | TlQty = stockBarcode.Quantity, |
| | | CreateBy = query.userName, |
| | | CreateDate = DateTime.Now, |
| | |
| | | PbillNo = query.billNo, |
| | | ItemId = blDetail.Bld012, |
| | | Unit = blDetail.Bld009, |
| | | DepotId = (int)stockBarcode.DepotsId, |
| | | DepotId = (int)stockBarcode.DepotId, |
| | | Dabid = womdab.Guid, |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | | |
| | |
| | | EpFlag = stockBarcode.EpFlag, |
| | | CustomerNo = stockBarcode.CustomerNo, |
| | | DepotsCode = stockBarcode.DepotsCode, |
| | | DepotsId = stockBarcode.DepotsId, |
| | | DepotsId = stockBarcode.DepotId, |
| | | DepotSectionsCode = stockBarcode.DepotSectionsCode, |
| | | CheckDate = stockBarcode.CheckDate, |
| | | ItemType = stockBarcode.ItemType, |
| | |
| | | PbillNo = query.billNo, |
| | | ItemId = blDetail.Bld012, |
| | | Unit = blDetail.Bld009, |
| | | DepotId = (int)stockBarcode.DepotsId, |
| | | DepotId = (int)stockBarcode.DepotId, |
| | | LineK3id = workOrderDetail.Erpid, |
| | | EbelnK3id = workOrderDetail.Eid |
| | | }).IgnoreColumns(true).ExecuteCommand(); |