| | |
|---|
| | | BfQty = query.bf,//不良数量 |
|---|
| | | OkQty = query.currentCjNum - query.initCjNum - query.bf,//良品数量 |
|---|
| | | CsQty = query.initCjNum,//初始采集数 |
|---|
| | | JtQty = query.currentCjNum,//报工时采集数 |
|---|
| | | CjQty = query.currentCjNum,//报工时采集数 |
|---|
| | | ItemNo = womdaa.Daa002, |
|---|
| | | BillNo = womdaa.Daa001, |
|---|
| | | BgPerson = query.staffNo // 新增：报工人编号 |
|---|
| | |
|---|
| | | |
|---|
| | | // 更新报工记录 |
|---|
| | | Db.Updateable<MesReporting>() |
|---|
| | | .SetColumns(a => a.BlQty == BlQty.ToString()) |
|---|
| | | .SetColumns(a => a.BlQty == BlQty) |
|---|
| | | .SetColumns(a => a.CsQty == (anchors.InitialValue ?? 0)) |
|---|
| | | .SetColumns(a => a.JtQty == jt) |
|---|
| | | // .SetColumns(a => a.BfQty == bfQty) |
|---|
| | | .SetColumns(a => a.CjQty == ljcj.ToString()) |
|---|
| | | .SetColumns(a => a.DyQty == DyQty.ToString()) |
|---|
| | | .SetColumns(a => a.CjQty == ljcj) |
|---|
| | | .SetColumns(a => a.DyQty == DyQty) |
|---|
| | | .Where(a => a.ItemNoCade == mesReporting.ItemNoCade) |
|---|
| | | .ExecuteCommand(); |
|---|
| | | } |
|---|
