| | |
| | | var data3 = db2.Find(_ => true).Where(x => x.stationCode.Contains("A") || x.stationCode.Contains("B") || x.stationCode.Contains("C") || x.stationCode.Contains("D01")).ToList(); |
| | | |
| | | //åºåºå¾å·æ°é,å¤å ç©ºææ°é |
| | | var Number_wheels = data3.Where(_ => true) |
| | | var Number_wheels1 = data3.Where(_ => true) |
| | | .GroupBy(s => new |
| | | { |
| | | stationType = string.IsNullOrEmpty(s.stationType) ? s.tray_type : s.stationType, |
| | |
| | | tray_type = g.Key.tray_type |
| | | }).ToList(); |
| | | |
| | | var Number_wheels = Number_wheels1.Where(x => x.stationType != "LargeTray" && x.stationType != "SmallTray").ToList(); |
| | | #endregion |
| | | |
| | | |
| | |
| | | x.Key.stationType, |
| | | combined_heatNumber = string.Join(", ", x.Select(y => y.heatNumber).Distinct()) |
| | | }) |
| | | .Where(x => !string.IsNullOrEmpty(x.stationType) && !string.IsNullOrEmpty(x.combined_heatNumber)) |
| | | .OrderBy(x => x.Area) |
| | | .ThenBy(x => x.line) |
| | | .GroupBy(x => x.line) // ä½¿ç¨ GroupBy æ Line åæ®µåç» |
| | | .Select(group => |
| | | { |
| | | // æ¾å°æ¯ä¸ªåç»ä¸ç¬¬ä¸ä¸ª stationType ä¸ä¸ºç©ºçå
ç´ |
| | | var firstWithStationType = group.FirstOrDefault(x => !string.IsNullOrEmpty(x.stationType)); |
| | | if (firstWithStationType != null) |
| | | { |
| | | return firstWithStationType; |
| | | } |
| | | else |
| | | { |
| | | // 妿åç»ä¸é½æ¯ stationType 为空ï¼åè¿å第ä¸ä¸ªå
ç´ ï¼æ¤æ¶å³ä¸º stationType 为空çï¼ |
| | | return group.First(); |
| | | } |
| | | }) |
| | | .ToList(); |
| | | |
| | | dataList = dataList.Concat(data).ToList(); |
| | |
| | | Idt_agvtaskRepository db = new dt_agvtaskRepository(volContext); |
| | | var dataList = db.Find(_ => true).OrderByDescending(x => x.agv_createtime).ToList(); |
| | | |
| | | var data = dataList.Where(x => x.agv_tasktype != "Queue").Take(15).ToList(); |
| | | var data = dataList.Where(x => x.agv_taskstate != "éå" && x.agv_taskstate != "Queue" && x.agv_taskstate != "æå" && x.agv_taskstate != "Pause").ToList(); |
| | | if (data.Count <= 15) |
| | | { |
| | | data = dataList.Take(15).ToList(); |