| | |
| | | mesDepost = Db.Queryable<MesDepots>() |
| | | .Where(s => s.DepotId.ToString() == depotCode2).First(); |
| | | |
| | | if (depotCode != mesDepost.Guid) |
| | | throw new Exception("扫描库位与采购入库库位不一致!"); |
| | | // if (depotCode != mesDepost.Guid) |
| | | // throw new Exception("扫描库位与采购入库库位不一致!"); |
| | | } |
| | | else |
| | | { |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 生产工单退料扫码 |
| | | /// 扫描条码 prc_rf_pda_scan_zout_barcode3 |
| | | /// </summary> |
| | | /// <param name="query">查询参数</param> |
| | |
| | | |
| | | // 检查补料单状态 |
| | | var mesItemBl = Db.Queryable<MesItemBl>() |
| | | .Where(a => a.BlNo == query.blNo && (a.Bl018 ?? false) == false) |
| | | .Where(a => a.BlNo == query.blNo) |
| | | .First(); |
| | | |
| | | if (mesItemBl == null) |
| | |
| | | .Where((a, i) => a.Daa001 == query.daa001) |
| | | .Select((a, i) => new |
| | | { |
| | | a.Daa001, a.Eid |
| | | a.Daa001, a.RwdGuid |
| | | }).First(); |
| | | |
| | | if (womdaa?.Daa001 == null) throw new Exception("工单号不存在"); |
| | | |
| | | var womdabs = Db.Queryable<WwGd, WwGdDetail, MesItems, Womcab>( |
| | | var womdabs = Db.Queryable<WwGd, WwGdDetail, MesItems, ProductionOrderSub>( |
| | | (a, b, c, d) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, |
| | |
| | | JoinType.Inner, |
| | | c.Id == |
| | | b.Dab003, |
| | | JoinType.Inner, b.Erpid == d.Erpid |
| | | JoinType.Inner, b.Erpid.ToString() == d.ErpId |
| | | )) |
| | | .Where((a, b, c, d) => |
| | | a.Daa001 == query.daa001 && d.IssueType == "1") |
| | | a.Daa001 == query.daa001 && d.IssuingMethod == "1") |
| | | .Select((a, b, c, d) => new WwGdDetail |
| | | { |
| | | Pid = b.Pid, |
| | |
| | | .ToList(); |
| | | |
| | | var womcaa = Db.Queryable<ProductionOrder>() |
| | | .Where(s => s.ErpId == womdaa.Eid.ToString()) |
| | | .Where(s => s.Guid == womdaa.RwdGuid) |
| | | .First(); |
| | | |
| | | var dto = new ProductionPickDto |