| | |
| | | PbillNo = query.billNo, |
| | | ItemId = blDetail.Bld012, |
| | | DepotId = stockBarcode.DepotsId.ToString(), |
| | | ItemDabid = womdab.Guid, |
| | | ItemDabid = blDetail.Id, |
| | | // Unit = blDetail.Bld009, |
| | | // DepotId = (int)stockBarcode.DepotsId |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | |
| | | Dab020 = (it.Dab020 ?? 0) + stockBarcode.Quantity, |
| | | Dab021 = (it.Dab021 ?? 0) + stockBarcode.Quantity |
| | | }) |
| | | .Where(it => it.Id == womdab.Id && it.Dab003 == womdab.Dab003) |
| | | .Where(it => it.Guid == womdab.DaaGuid && it.Dab003 == womdab.Dab003) |
| | | .ExecuteCommand(); |
| | | |
| | | // 更新补料单明细已补数量 |
| | |
| | | Dab020 = (it.Dab020 ?? 0) + query.Num, // 已发料数量 |
| | | Dab021 = (it.Dab021 ?? 0) + query.Num // 已发料数量 |
| | | }) |
| | | .Where(it => it.Id == womdab.Id && it.Dab003 == womdab.Dab003) |
| | | .Where(it => it.Guid == womdab.DaaGuid && it.Dab003 == womdab.Dab003) |
| | | .ExecuteCommand(); |
| | | |
| | | // 更新补料单明细已补数量 |
| | |
| | | .ExecuteCommand(); |
| | | |
| | | if (executeCommand <= 1) throw new Exception("更新失败"); |
| | | |
| | | |
| | | // 创建 插入日志 |
| | | var logService = new LogService(); |
| | | var LogMsg = "[PDA]" + query.Type + "。条码【" + query.barcode + "】 出库单号【" + outNo + "】"; |
| | | logService.CreateLog(db, query.userName, womdaa.Guid.ToString(), "WOMDAA", LogMsg, womdaa.Daa001); |
| | | |
| | | |
| | | return executeCommand; |
| | | }) > 0; |
| | |
| | | Dab020 = (it.Dab020 ?? 0) + stockBarcode.Quantity, |
| | | Dab023 = (it.Dab023 ?? 0) + stockBarcode.Quantity |
| | | }) |
| | | .Where(it => it.Id == womdab.Id) |
| | | .Where(it => it.Guid == womdab.Guid) |
| | | .ExecuteCommand(); |
| | | |
| | | // 更新超领单明细 |
| | |
| | | Dab020 = (it.Dab020 ?? 0) + stockBarcode.Quantity, |
| | | Dab023 = (it.Dab023 ?? 0) + stockBarcode.Quantity |
| | | }) |
| | | .Where(it => it.Id == workOrderDetail.Id) |
| | | .Where(it => it.Guid == workOrderDetail.Guid) |
| | | .ExecuteCommand(); |
| | | |
| | | // 更新补料单明细已补数量 |