| | |
| | | namespace NewPdaSqlServer.service.Warehouse; |
| | | |
| | | /// <summary> |
| | | /// MES物料表管理类 |
| | | /// MES物料表管理类 |
| | | /// </summary> |
| | | public class MesItemTblManager : Repository<MesItemTbl> |
| | | { |
| | | /// <summary> |
| | | /// 获取生产退料单号列表 |
| | | /// 获取生产退料单号列表 |
| | | /// </summary> |
| | | /// <returns>退料单号列表</returns> |
| | | public List<string> GetSCTLBillNo(WarehouseQuery query) |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据单号获取MES物料表明细 |
| | | /// 根据单号获取MES物料表明细 |
| | | /// </summary> |
| | | /// <param name="query">仓库查询参数</param> |
| | | /// <returns>物料明细列表</returns> |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 生产退料扫描库位 |
| | | /// 生产退料扫描库位 |
| | | /// </summary> |
| | | /// <param name="query">仓库查询参数</param> |
| | | /// <returns>库位信息</returns> |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 生产退料扫描条码 |
| | | /// 生产退料扫描条码 |
| | | /// </summary> |
| | | /// <param name="query">仓库查询参数</param> |
| | | /// <returns>处理结果</returns> |
| | |
| | | |
| | | // 检查必要的插入操作是否都成功执行 |
| | | var minimumExpectedOperations = 3; // 至少需要执行的插入操作数 |
| | | if (totalResult < minimumExpectedOperations) |
| | | throw new Exception($"关键数据插入失败,预期至少{minimumExpectedOperations}个操作,实际执行{totalResult}个操作"); |
| | | if (totalResult < minimumExpectedOperations) |
| | | throw new Exception( |
| | | $"关键数据插入失败,预期至少{minimumExpectedOperations}个操作,实际执行{totalResult}个操作"); |
| | | |
| | | return totalResult; |
| | | }); |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 委外退料扫描条码(生产退料的逻辑,只是调整了几个字段) |
| | | /// 委外退料扫描条码(生产退料的逻辑,只是调整了几个字段) |
| | | /// </summary> |
| | | /// <param name="query">仓库查询参数</param> |
| | | /// <returns>处理结果</returns> |
| | |
| | | var C_MES_ITEM_TBL = Db.Queryable<MesItemTbl>() |
| | | .Where(a => a.BillNo == c_mes_inv_item_barcodes.BillNo |
| | | && (a.Tbl013 ?? 0) == 1).First(); |
| | | |
| | | |
| | | if (C_MES_ITEM_TBL == null) throw new Exception("申请单已撤回,无法扫码!"); |
| | | |
| | | if (C_MES_ITEM_TBL.Tbl020 == 1) throw new Exception("扫码完成,申请单已完结!"); |
| | |
| | | |
| | | // 检查必要的插入操作是否都成功执行 |
| | | var minimumExpectedOperations = 3; // 至少需要执行的插入操作数 |
| | | if (totalResult < minimumExpectedOperations) |
| | | throw new Exception($"关键数据插入失败,预期至少{minimumExpectedOperations}个操作,实际执行{totalResult}个操作"); |
| | | if (totalResult < minimumExpectedOperations) |
| | | throw new Exception( |
| | | $"关键数据插入失败,预期至少{minimumExpectedOperations}个操作,实际执行{totalResult}个操作"); |
| | | |
| | | return totalResult; |
| | | }); |