| | |
| | | { |
| | | // 获取或创建出库单 |
| | | var outId = Guid.NewGuid(); |
| | | var outNo = BillNo.GetBillNo("SCBL"); |
| | | var outNo = BillNo.GetBillNo("BL(工单补料)"); |
| | | |
| | | var existingOut = db.Queryable<MesInvItemOuts>() |
| | | .Where(a => a.BbillNo == query.blNo |
| | |
| | | .Count(); |
| | | |
| | | if (itemCount > 0) |
| | | { |
| | | // 更新已存在的物料明细数量 |
| | | db.Updateable<MesInvItemOutItems>() |
| | | .SetColumns(i => |
| | |
| | | .Where(i => |
| | | i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId) |
| | | .ExecuteCommand(); |
| | | } |
| | | else |
| | | { |
| | | // 插入新的物料明细记录 |
| | | db.Insertable(new MesInvItemOutItems |
| | | { |
| | |
| | | // Unit = blDetail.Bld009, |
| | | // DepotId = (int)stockBarcode.DepotsId |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | | } |
| | | |
| | | |
| | | // 插入出库单条码明细 |
| | | db.Insertable(new MesInvItemOutCDetails |
| | | { |
| | |
| | | { |
| | | // 创建新的出库单 |
| | | var outId = Guid.NewGuid(); |
| | | var outNo = BillNo.GetBillNo("SCBL"); |
| | | var outNo = BillNo.GetBillNo("BL(工单补料)"); |
| | | |
| | | // 插入出库单主表 |
| | | executeCommand += db.Insertable(new MesInvItemOuts |
| | |
| | | /// </summary> |
| | | /// <param name="query">查询参数</param> |
| | | /// <returns>生产超领单明细列表</returns> |
| | | public (string bl001,List<MesItemBlDetail> item) GetMesItemBlDetailBySccBillNo( |
| | | WarehouseQuery query) |
| | | public (string bl001, List<MesItemBlDetail> item) |
| | | GetMesItemBlDetailBySccBillNo( |
| | | WarehouseQuery query) |
| | | { |
| | | if (string.IsNullOrEmpty(query.billNo)) |
| | | throw new Exception("请选单据号!"); |
| | |
| | | }) |
| | | .ToList(); |
| | | |
| | | return (mesItemBl.Bl001,pendingDetails); |
| | | return (mesItemBl.Bl001, pendingDetails); |
| | | } |
| | | |
| | | /// <summary> |
| | |
| | | if (outRecord == null) |
| | | { |
| | | outId = Guid.NewGuid(); |
| | | outNo = BillNo.GetBillNo("SCBL"); // 需要实现生成单号的方法 |
| | | outNo = BillNo.GetBillNo("BL(工单补料)"); // 需要实现生成单号的方法 |
| | | |
| | | // 插入出库单主表 |
| | | db.Insertable(new MesInvItemOuts |
| | |
| | | itemOut = new MesInvItemOuts |
| | | { |
| | | Guid = Guid.NewGuid(), |
| | | ItemOutNo = BillNo.GetBillNo("SCBL"), // 需要实现生成单号的方法 |
| | | ItemOutNo = BillNo.GetBillNo("BL(工单补料)"), // 需要实现生成单号的方法 |
| | | TaskNo = query.blNo, |
| | | CreateBy = query.userName, |
| | | CreateDate = DateTime.Now, |