111

tjx

6 天以前 ccb1ebbf88c1fb456ca30f121c6ef108246689cc

 StandardPda/MESApplication/Controllers/Warehouse/MesInvItemStocksController.cs

@@ -14,7 +14,7 @@
    private readonly MesInvItemStocksManager m = new();

    /// <summary>
    ///     获取可退货物料库存
    ///     获取可退货物料库存(旧版本,保留兼容)
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetReturnableStocks")]
@@ -29,6 +29,30 @@
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     获取可退货物料库存(带分页和搜索)
    /// </summary>
    /// <param name="searchDto">搜索请求参数</param>
    /// <returns></returns>
    [HttpPost("GetReturnableStocksWithPaging")]
    public ResponseResult GetReturnableStocksWithPaging([FromBody] ReturnableStockSearchDto searchDto)
    {
        try
        {
            var result = m.GetReturnableStocks(searchDto);
            return new ResponseResult
            {
                status = 0,
                message = "查询成功",
                data = result
            };
        }
        catch (Exception ex)
@@ -72,4 +96,32 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     导出可退货物料库存为Excel
    /// </summary>
    /// <param name="searchDto">搜索请求参数</param>
    /// <returns>Excel文件</returns>
    [HttpPost("ExportReturnableStocks")]
    public IActionResult ExportReturnableStocks([FromBody] ReturnableStockSearchDto searchDto)
    {
        try
        {
            var fileBytes = m.ExportReturnableStocksToExcel(searchDto);
            var fileName = $"可退货物料库存_{DateTime.Now:yyyyMMddHHmmss}.xlsx";
            
            return File(fileBytes, 
                "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", 
                fileName);
        }
        catch (Exception ex)
        {
            return BadRequest(new ResponseResult
            {
                status = 1,
                message = $"导出失败: {ex.Message}",
                data = null
            });
        }
    }
}