| | |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using WIDESEA_Comm; |
| | | using WIDESEA_Comm.PLCDBItem; |
| | | using WIDESEA_Core.EFDbContext; |
| | | using WIDESEA_Core.Extensions; |
| | | using WIDESEA_Core.Utilities; |
| | | using WIDESEA_Entity.DomainModels; |
| | | using WIDESEA_WCS.IRepositories; |
| | | using WIDESEA_WCS.Repositories; |
| | | using WIDESEA_WMS.IRepositories; |
| | |
| | | { |
| | | var DBIems = WheelDBItem.VK4WheelDBItem; //è·åè¾éï¼è¾éçº¿ä¿¡æ¯ |
| | | var DBIems2 = VKDBItem.VK4DBItem; //VK4ç¶æä¿¡æ¯å¯¹è±¡éå |
| | | // VK4æ¡æ¶æºæ¢°æå¯¹è±¡éå |
| | | |
| | | var DBIems3 = Oiling_machine.Oiling_machineDBItem; |
| | | |
| | | if (DBIems.Count == 0) |
| | | { |
| | |
| | | return Ok(dataList); |
| | | } |
| | | #endregion |
| | | |
| | | #region pcså¹³é¢å¾åºä½ä¿¡æ¯ |
| | | [HttpPost("dt_stationinfolist")] |
| | | public IActionResult dt_stationinfolist() |
| | | { |
| | | VOLContext volContext = new VOLContext(); |
| | | Idt_stationinfoRepository dsta = new dt_stationinfoRepository(volContext); |
| | | string[] stationCodes = { "W", "A", "B", "C", "D01" }; |
| | | List<Tuple<List<dt_stationinfo>, int>> responseData = new List<Tuple<List<dt_stationinfo>, int>>(); |
| | | foreach (string code in stationCodes) |
| | | { |
| | | var data = dsta.Find(_ => true).Where(a => a.stationCode.Contains(code)).OrderBy(a => a.stationCode).ToList(); |
| | | int inst = dsta.Find(_ => true).Where(a => a.stationCode.Contains(code)).GroupBy(a => a.line).Count(); |
| | | responseData.Add(Tuple.Create(data, inst)); |
| | | } |
| | | return Ok(responseData); |
| | | } |
| | | [HttpPost("pcs_dt_stationinfolist")] |
| | | public IActionResult pcs_dt_stationinfolist() |
| | | { |
| | | VOLContext volContext = new VOLContext(); |
| | | Idt_stationinfoRepository dsta = new dt_stationinfoRepository(volContext); |
| | | string[] stationCodes = { "X01", "X02", "X03", "S", "DD001" }; |
| | | List<Tuple<List<dt_stationinfo>>> responseData = new List<Tuple<List<dt_stationinfo>>>(); |
| | | foreach (string code in stationCodes) |
| | | { |
| | | var data = dsta.Find(_ => true).Where(a => a.stationCode.Contains(code)).OrderBy(a => a.stationCode).ToList(); |
| | | responseData.Add(Tuple.Create(data)); |
| | | } |
| | | return Ok(responseData); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | } |
| | | } |