| | |
| | | { |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | return db.Queryable<MesLine>() |
| | | .Where(t => |
| | | t.LineStyle == "包装" || |
| | | SqlFunc.ContainsArray(new[] { "V1", "V3", "V5", "V6" }, |
| | | t.LineNo)) |
| | | .OrderBy(t => t.LineNo) |
| | | .Select(t => new MesLine |
| | | { |
| | | LineNo = t.LineNo, |
| | | LineName = t.LineName |
| | | }).OrderBy("LINE_NO") |
| | | }) |
| | | .ToList(); |
| | | } |
| | | |
| | | |
| | | //获取工单号 |
| | | public List<RkDaa002> GetDaa001s(string lineNo) |
| | | public List<RKJDaa001> GetDaa001s(string lineNo) |
| | | { |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | // return db.Queryable<RKJDaa001>() |
| | | // .Where(t => t.LineNo == lineNo) |
| | | // .OrderBy(t => t.BillNo, OrderByType.Desc) |
| | | // .ToList(); |
| | | return null; |
| | | return db.Queryable<RKJDaa001>() |
| | | .Where(t => t.Daa020 == lineNo) |
| | | .OrderBy(t => t.ItemInId, OrderByType.Desc) |
| | | .ToList(); |
| | | //return null; |
| | | } |
| | | |
| | | //根据检验标准来计算检验个数 |