| | |
| | | /// 累计采集数 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CJ_QTY")] |
| | | public string? CjQty { get; set; } |
| | | public decimal? CjQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计打印数 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DY_QTY")] |
| | | public string? DyQty { get; set; } |
| | | public decimal? DyQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计不良数 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BL_QTY")] |
| | | public string? BlQty { get; set; } |
| | | public decimal? BlQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 机台面板数 |
| | |
| | | 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(); |
| | | } |
| | |
| | | OrderId = womdaa.Id, |
| | | OrderNo = womdaa.Daa001, |
| | | EditDate = editDate, |
| | | Qty = mesReporting == null ? 0 : Int64.Parse(mesReporting.DyQty), |
| | | Qty = mesReporting == null ? 0 : (long?)(mesReporting.DyQty ?? 0), |
| | | InitialValue = mesNumerical == null ? 0 : mesNumerical.CjNum |
| | | }; |
| | | Db.Insertable<MesAnchors>(eAnchors) |
| | |
| | | MachineNo = womdaa.MachineNo, |
| | | // BfQty = reportingOkQty, |
| | | BfQty = 0, |
| | | BlQty = reportingOkQty.ToString(), |
| | | BlQty = reportingOkQty, |
| | | OkQty = 0, |
| | | ItemNo = womdaa.Daa002, |
| | | BillNo = womdaa.Daa001, |
| | | CjQty = CjQty.ToString(), |
| | | DyQty = reporting.OkQty.ToString() |
| | | CjQty = CjQty, |
| | | DyQty = reporting.OkQty |
| | | }; |
| | | |
| | | // 插入报工记录 |