| | |
| | | Remark = mesItemBl.Bl007, |
| | | DepotCode = womdab.Dab017, |
| | | OutPart = womdaa.Daa013, |
| | | OutType = "生产补料", |
| | | FType = 0, |
| | | Factory = stockBarcode.Factory, |
| | | Company = stockBarcode.Company, |
| | |
| | | PbillNo = womdaa.Daa001, |
| | | OutDate = DateTime.Now, |
| | | Status = 0, |
| | | BbillNo = query.blNo |
| | | BbillNo = query.billNo |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | | } |
| | | |
| | | // 检查并更新出库单物料明细 |
| | | var itemCount = db.Queryable<MesInvItemOutItems>() |
| | | .Where(i => |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId) |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId) |
| | | .Count(); |
| | | |
| | | if (itemCount > 0) |
| | | // 更新已存在的物料明细数量 |
| | | db.Updateable<MesInvItemOutItems>() |
| | | .SetColumns(i => |
| | | i.Quantity == i.Quantity + stockBarcode.Quantity) |
| | | i.TlQty == i.TlQty + stockBarcode.Quantity) |
| | | .Where(i => |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId) |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId) |
| | | .ExecuteCommand(); |
| | | else |
| | | // 插入新的物料明细记录 |
| | |
| | | ItemOutId = outId, |
| | | ItemNo = blDetail.Bld002, |
| | | Quantity = stockBarcode.Quantity, |
| | | TlQty = stockBarcode.Quantity, |
| | | CreateBy = query.userName, |
| | | CreateDate = DateTime.Now, |
| | | LastupdateBy = query.userName, |