| | |
| | | using WIDESEA_Entity.DomainModels; |
| | | using WIDESEA_WMS.IRepositories; |
| | | using WIDESEA_WMS.Repositories; |
| | | using static FreeSql.Internal.GlobalFilter; |
| | | |
| | | namespace WIDESEA_WMS.Common |
| | | { |
| | |
| | | /// <param name="task"></param> |
| | | public static void Updateinventory(dt_agvtask task) |
| | | { |
| | | //string[] bindSNs = task.bindSN.Split(","); |
| | | //int count = 0; |
| | | //if (bindSNs.Length > 0) |
| | | //{ |
| | | if (task.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString() || task.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()) |
| | | { |
| | | string[] bindSNs = task.bindSN.Split(","); |
| | |
| | | if (count < 1) |
| | | throw new Exception("åºåæ¸
é¤å¤±è´¥ï¼SNå·:" + bindSN); |
| | | } |
| | | |
| | | } |
| | | else if (task.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()) |
| | | { |
| | |
| | | List<dt_inventory> inventorys = new List<dt_inventory>(); |
| | | foreach (string bindSN in bindSNs) |
| | | { |
| | | var mes_detail = freeDB.Select<dt_mes_detail>().Where(x => x.SN == bindSN).First(); |
| | | if (mes_detail == null) |
| | | throw new Exception("æªæ¾å°å·¥åä¿¡æ¯ï¼"); |
| | | var mes_head = freeDB.Select<dt_mes_head>().Where(x => x.jobID == mes_detail.jobID).First(); |
| | | if (mes_head == null) |
| | | var mes_Work = freeDB.Select<VV_Mes_Workinfo>().Where(x => x.SN == bindSN && x.processCode == "17").First(); |
| | | if (mes_Work == null) |
| | | throw new Exception("æªæ¾å°å·¥åä¿¡æ¯ï¼"); |
| | | var station = freeDB.Select<dt_stationinfo>().Where(x => x.stationCode == task.agv_toaddress).First(); |
| | | dt_inventory inventory = new dt_inventory() |
| | | { |
| | | SN = bindSN, |
| | | Name = mes_head.productName, |
| | | FigureNumber = mes_head.drawingNo, |
| | | Name = mes_Work.productName, |
| | | FigureNumber = mes_Work.drawingNo, |
| | | materialCode = task.agv_materbarcode, |
| | | HeatNumber = mes_detail.heatID, |
| | | BilletNumber = mes_detail.billetID, |
| | | HeatNumber = mes_Work.heatID, |
| | | drawingNoVer = mes_Work.drawingNoVer, |
| | | BilletNumber = mes_Work.billetID, |
| | | OnlineTime = task.agv_finishedtime, |
| | | Operator = "admin", |
| | | stationCode = task.agv_toaddress, |
| | | area = station.area, |
| | | jobID = mes_detail.jobID, |
| | | jobID = mes_Work.workOrder, |
| | | ID = Guid.NewGuid() |
| | | }; |
| | | inventorys.Add(inventory); |
| | |
| | | station1.stationType = string.Empty; |
| | | station1.tray_status = string.Empty; |
| | | station1.remark = string.Empty; |
| | | if (!station1.stationCode.Contains("X") && !station1.stationCode.Contains("S") && !station1.stationCode.Contains("W01001004") && !station1.stationCode.Contains("W01001005")) |
| | | station1.tray_type = string.Empty; |
| | | //if (!station1.stationCode.Contains("X") && !station1.stationCode.Contains("S") && !station1.stationCode.Contains("W01001004") && !station1.stationCode.Contains("W01001005")) |
| | | // station1.tray_type = string.Empty; |
| | | } |
| | | stationinfoRepository.Update(station1, true); |
| | | } |