| | |
| | | var list = Db.Queryable<MesItemBl>() |
| | | .Where(s => (s.Bl018 ?? false) == true |
| | | && (s.Bl019 ?? false) == false |
| | | && s.Bl008 == query.type) |
| | | && s.Bl008 == query.Type) |
| | | .Select(s => s.BlNo) |
| | | .ToList(); |
| | | return list; |
| | |
| | | |
| | | // 检查补料单是否存在且为生产补料类型 |
| | | var mesItemBl = Db.Queryable<MesItemBl>() |
| | | .Where(a => a.BlNo == query.billNo && a.Bl008 == "生产补料") |
| | | .Where(a => a.BlNo == query.billNo && a.Bl008 == query.Type) |
| | | .First(); |
| | | |
| | | if (mesItemBl == null) |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 生产工单补料扫码 |
| | | /// 扫描条码 prc_rf_pda_scan_zout_barcode3 |
| | | /// </summary> |
| | | /// <param name="query">查询参数</param> |
| | |
| | | /// - blNo: 补料单号(必填) |
| | | /// </remarks> |
| | | public (WarehouseQuery item, List<MesItemBlDetail> pendingList) |
| | | SctlScanBarcode( |
| | | ScblScanBarcode( |
| | | WarehouseQuery query) |
| | | { |
| | | if (string.IsNullOrEmpty(query.billNo)) |
| | |
| | | |
| | | // 检查补料单状态 |
| | | 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) |
| | |
| | | var list = Db.Queryable<MesItemBl>() |
| | | .Where(s => (s.Bl018 ?? false) == true |
| | | && (s.Bl019 ?? false) == false |
| | | && s.Bl008 == query.type) |
| | | && s.Bl008 == query.Type) |
| | | .Select(s => s.BlNo) |
| | | .ToList(); |
| | | return list; |
| | |
| | | if (string.IsNullOrEmpty(query.billNo)) |
| | | throw new Exception("请选单据号!"); |
| | | |
| | | // 检查超领单是否存在且为生产超领类型 |
| | | // 检查超领单是否存在且为生产超领/委外超领类型 |
| | | var mesItemBl = Db.Queryable<MesItemBl>() |
| | | .Where(a => a.BlNo == query.billNo && a.Bl008 == "生产超领") |
| | | .Where(a => a.BlNo == query.billNo && a.Bl008 == query.Type) |
| | | .First(); |
| | | |
| | | if (mesItemBl == null) |