1111

tjx

3 天以前 8ec9fab52eea2b110ad4e1a0b2300fead0018cd1

 StandardPda/MESApplication/Controllers/Warehouse/MesInvItemStocksController.cs

@@ -12,31 +12,7 @@
public class MesInvItemStocksController : ControllerBase
{
    private readonly MesInvItemStocksManager m = new();

    /// <summary>
    ///     获取可退货物料库存(旧版本,保留兼容)
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetReturnableStocks")]
    public ResponseResult GetReturnableStocks()
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetReturnableStocks();
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    
    /// <summary>
    ///     获取可退货物料库存(带分页和搜索)
    /// </summary>
@@ -96,4 +72,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
            });
        }
    }
}