| | |
| | | |
| | | if (womdaa == null) throw new Exception("工单单号不存在"); |
| | | |
| | | var okQty = query.currentCjNum - query.initCjNum - query.bf;//良品数量 |
| | | |
| | | // 创建报工记录 |
| | | var mesReporting = new MesReporting |
| | | { |
| | |
| | | AddressCode = womdaa.AddressCode, |
| | | MachineNo = womdaa.MachineNo, |
| | | BfQty = query.bf,//不良数量 |
| | | OkQty = query.currentCjNum - query.initCjNum - query.bf,//良品数量 |
| | | OkQty = okQty,//良品数量 |
| | | CsQty = query.initCjNum,//初始采集数 |
| | | CjQty = query.currentCjNum,//报工时采集数 |
| | | ItemNo = womdaa.Daa002, |
| | |
| | | BgPerson = query.staffNo // 新增:报工人编号 |
| | | }; |
| | | |
| | | // 更新工单Daa011为原值加上本次良品数量 |
| | | Db.Updateable<Womdaa>() |
| | | .SetColumns(x => x.Daa011 == (womdaa.Daa011 ?? 0) + (okQty ?? 0)) |
| | | .Where(x => x.Daa001 == womdaa.Daa001) |
| | | .ExecuteCommand(); |
| | | |
| | | |
| | | // 插入报工记录和条码记录 |
| | | return Db.Insertable(mesReporting) |
| | | .IgnoreColumns(true).ExecuteCommand() > 0; |