| | |
| | | using NewPdaSqlServer.DB; |
| | | using NewPdaSqlServer.Dto.service; |
| | | using NewPdaSqlServer.entity; |
| | | using NewPdaSqlServer.entity.Base; |
| | | using SqlSugar; |
| | | |
| | | namespace NewPdaSqlServer.service.Warehouse; |
| | |
| | | /// </summary> |
| | | /// <param name="query">查询参数,包含单据号</param> |
| | | /// <returns>待处理的调拨出库明细列表</returns> |
| | | public List<TransferOutDetailModel> GetTransferOutDetailListByBillNo( |
| | | public List<ItemDetailModel> GetTransferOutDetailListByBillNo( |
| | | WarehouseQuery query) |
| | | { |
| | | var p_bill_no = query.billNo; |
| | |
| | | && a.FBillNo == p_bill_no // 匹配单据号 |
| | | && a.FApproveStatus == 1) // 单据已审核 |
| | | .OrderBy((b, a, s) => s.ItemNo) |
| | | .Select((b, a, s) => new TransferOutDetailModel |
| | | .Select((b, a, s) => new ItemDetailModel |
| | | { |
| | | ItemNo = s.ItemNo, |
| | | ItemName = s.ItemName, |
| | |
| | | return result; |
| | | } |
| | | |
| | | public List<TransferOutDetailModel> GetDBCKDetal( |
| | | public List<ItemDetailModel> GetDBCKDetal( |
| | | WarehouseQuery query) |
| | | { |
| | | var p_bill_no = query.billNo; |
| | |
| | | && a.FBillNo == p_bill_no // 匹配单据号 |
| | | && a.FApproveStatus == 1) // 单据已审核 |
| | | .OrderBy((b, a, s) => s.ItemNo) |
| | | .Select((b, a, s) => new TransferOutDetailModel |
| | | .Select((b, a, s) => new ItemDetailModel |
| | | { |
| | | ItemNo = s.ItemNo, |
| | | ItemName = s.ItemName, |
| | | ItemModel = s.ItemModel, |
| | | FQty = b.FQty, // 申请数量 |
| | | SQty = b.SQty, // 已扫数量 |
| | | RQty = b.RQty, |
| | | // 保留其他必要字段... |
| | | Pid = b.Pid.ToString(), |
| | | FMaterialId = b.FMaterialId, |
| | |
| | | /// </summary> |
| | | /// <param name="query">包含单据号、用户名和条码信息的查询参数</param> |
| | | /// <returns>处理后的表单和待处理明细列表</returns> |
| | | public (WarehouseQuery form, List<TransferOutDetailModel> items) |
| | | public (WarehouseQuery form, List<ItemDetailModel> items) |
| | | ScanMoveBarcode(WarehouseQuery query) |
| | | { |
| | | var p_bill_no = query.billNo; |
| | |
| | | /// </summary> |
| | | /// <param name="query">包含单据号、用户名和条码信息的查询参数</param> |
| | | /// <returns>处理后的表单和待处理明细列表</returns> |
| | | public (WarehouseQuery form, List<TransferOutDetailModel> items) |
| | | public (WarehouseQuery form, List<ItemDetailModel> items) |
| | | ScanReceiveBarcode(WarehouseQuery query) |
| | | { |
| | | var p_bill_no = query.billNo; |