| | |
| | | using System.Linq; |
| | | using Newtonsoft.Json; |
| | | using Tiger.IBusiness; |
| | | using static Tiger.Business.Biz; |
| | | using Microsoft.AspNetCore.Http; |
| | | using System.Collections; |
| | | using System.Data; |
| | |
| | | List<SMT_WO_TABLE> sList = new List<SMT_WO_TABLE>(); |
| | | try |
| | | { |
| | | sList = Db.Queryable<SMT_WO_TABLE, SMT_LOADING>((t, l) => |
| | | sList = Biz.Db.Queryable<SMT_WO_TABLE, SMT_LOADING>((t, l) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, |
| | | t.WORK_ORDER == l.WORK_ORDER |
| | |
| | | item.原因 += $"站位号为空!"; |
| | | } |
| | | currentList.Add(item); |
| | | if (await Db.Queryable<SMT_WO_TABLE>().AnyAsync(x => x.WORK_ORDER == item.关联工单号 && x.ITEM_CODE == item.物料编码 && x.SLOT_NO == item.站位号 && x.SMT_CODE == item.贴片机编码)) |
| | | if (await Biz.Db.Queryable<SMT_WO_TABLE>().AnyAsync(x => x.WORK_ORDER == item.关联工单号 && x.ITEM_CODE == item.物料编码 && x.SLOT_NO == item.站位号 && x.SMT_CODE == item.贴片机编码)) |
| | | { |
| | | item.处理方式 = "修改"; |
| | | item.原因 += $"工单{item.关联工单号},物料编码{item.物料编码},站位号{item.站位号},贴片机编码{item.贴片机编码}与数据库重复!"; |