| | |
| | | // 检查是否已存在出库物料记录 |
| | | var existingOutItem = Db.Queryable<MesInvItemOutItems>() |
| | | .Where(it => |
| | | it.ItemOutId == outId && it.ItemId == barcode.ItemId && it.AboutGuid == qtDetail.Guid) |
| | | it.ItemOutId == outId && it.ItemId == barcode.ItemId && it.ItemDabid == qtDetail.Guid) |
| | | .First(); |
| | | |
| | | if (existingOutItem == null) |
| | |
| | | ? long.Parse(qtDetail.ItemId) |
| | | : null, |
| | | FType = 0, |
| | | AboutGuid = qtDetail.Guid |
| | | AboutGuid = qtDetail.Guid, |
| | | ItemDabid = qtDetail.Guid |
| | | // Unit = qtDetail.Qd009 |
| | | }; |
| | | |
| | |
| | | commit += db.Updateable<MesInvItemOutItems>() |
| | | .SetColumns(it => |
| | | it.TlQty == (it.TlQty ?? 0) + stock.Quantity) |
| | | .Where(it => it.ItemOutId == outId && |
| | | it.ItemId == barcode.ItemId && |
| | | it.QtOutId == qtDetail.Guid) |
| | | .Where(it => it.ItemOutId == outId && it.ItemId == barcode.ItemId && it.ItemDabid == qtDetail.Guid) |
| | | .ExecuteCommand(); |
| | | } |
| | | |