| | |
| | | |
| | | if (womdaa == null) throw new Exception("工单单号不存在"); |
| | | |
| | | if (womdaa.Daa018 != "开工") throw new Exception("工单未开工"); |
| | | |
| | | var okQty = query.currentCjNum - query.initCjNum - query.bf;//良品数量 |
| | | |
| | | // 创建报工记录 |
| | |
| | | BgPerson = query.staffNo // 新增:报工人编号 |
| | | }; |
| | | |
| | | // 更新工单Daa011为原值加上本次良品数量 |
| | | // 更新工单Daa011为原值加上本次良品数量,Daa012为原值加上本次不良品数量 |
| | | Db.Updateable<Womdaa>() |
| | | .SetColumns(x => x.Daa011 == (womdaa.Daa011 ?? 0) + (okQty ?? 0)) |
| | | .SetColumns(x => x.Daa012 == (womdaa.Daa012 ?? 0) + (query.bf ?? 0)) |
| | | .Where(x => x.Daa001 == womdaa.Daa001) |
| | | .ExecuteCommand(); |
| | | |