| | |
| | | |
| | | // 查询报工记录,获取最后一条报工记录 |
| | | var lastReport = Db.Queryable<MesReporting>() |
| | | .Where(r => r.BillNo.Trim().ToUpper() == query.orderNo.Trim().ToUpper()) |
| | | .AS("MES_REPORTING") // 强制表名 |
| | | .Where(r => r.BillNo == "MSD01-2507140001-g1-1") |
| | | .OrderBy(r => r.BgDate, OrderByType.Desc) |
| | | .First(); |
| | | |
| | |
| | | |
| | | Console.WriteLine($"orderNo: [{query.orderNo}]"); |
| | | |
| | | // 查询最后一条报工记录 |
| | | // 查询报工记录,获取最后一条报工记录 |
| | | var lastReport = Db.Queryable<MesReporting>() |
| | | .Where(r => r.BillNo.Trim().ToUpper() == query.orderNo.Trim().ToUpper()) |
| | | .OrderBy(r => r.BgDate, OrderByType.Desc) |