| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | //取样出库拣货(标签) |
| | | public async Task SampleSoSetPick(string soType, string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3, string pickQty1, string asnNo, int userId) |
| | | public async Task SampleSoSetPick(string soType, string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3, |
| | | string pickQty1, string asnNo, int userId) |
| | | { |
| | | Db.BeginTran(); |
| | | try |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | /// <summary> |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | var samplingQty = await Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).SumAsync(m => m.CompleteQty); |
| | | |
| | | data.QcNo = qcNo; |
| | | data.Sku = inspectionRequest.SkuNo; |
| | | data.Sku = inspectionRequest.SkuNo + "-" + inspectionRequest.SkuName; |
| | | data.LotNo = inspectionRequest.LotNo; |
| | | data.Qty = inspectionRequest.SamplingQty.ToString(); |
| | | data.SamplingQty = samplingQty == null ? "0" : samplingQty.ToString(); |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | |
| | |
| | | throw Oops.Bah("请验单状态错误,请核实"); |
| | | } |
| | | //库存明细信息 |
| | | var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo); |
| | | var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo |
| | | && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo); |
| | | if (stockDetail == null) |
| | | { |
| | | throw Oops.Bah("未在库存中查询出当前托盘信息"); |
| | | } |
| | | // 判断托盘是否在库内 |
| | | if (!string.IsNullOrWhiteSpace(stockDetail.LocatNo)) |
| | | { |
| | | var wareHouseData = await Db.Queryable<SysWareHouse>().FirstAsync(m => m.IsDel == "0" && m.WareHouseNo == stockDetail.WareHouseNo); |
| | | if (wareHouseData.Type != "2") |
| | | { |
| | | throw Oops.Bah("当前托盘不是库外托盘,请核实"); |
| | | } |
| | | } |
| | | //库存总表 |
| | | var stock = await Db.Queryable<DataStock>().FirstAsync(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo); |
| | |
| | | await Db.Updateable(inspecd).ExecuteCommandAsync(); |
| | | #endregion |
| | | |
| | | |
| | | |
| | | //添加操作日志记录 |
| | | var k = new OperationSOServer().AddLogOperationSo("PDA模块", "取样拣货", qcNo, "拣货", $"在PDA上对请验单号为:{qcNo}的托盘码为:{palletNo}的拣货操作", userId); |
| | | Db.CommitTran(); |
| | |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw e; |
| | | } |
| | | } |
| | | |