如何在 WebAPI 的控制器中传递输出参数

Question

这里我从存储过程中检索输出参数Entity Framework(EDMX)（输出参数是TransactionId）这里我想将TransactionId值传输到Scdid（在下一篇文章方法中）如何获取TransactionId = Scdid in the controller

我的API代码是

 public class StockcountheaderController : ApiController

{

    private adminv2Entities enqentities = new adminv2Entities();

    [HttpPost]

    private  void Stock([FromBody] List<spGetNewStockCountHeader_Result> jsonvalues)

    {

        foreach (spGetNewStockCountHeader_Result Datastock in jsonvalues)

        {

            ObjectParameter TransactionId = new 

ObjectParameter("TransactionId", typeof(Int32));

            spGetNewStockCountHeader_Result Stockobject = new 

 spGetNewStockCountHeader_Result();

            Stockobject.UserID = Datastock.UserID;

            Stockobject.created = Datastock.created;

            Stockobject.CompanyID = Datastock.CompanyID;

            Stockobject.modified = Datastock.modified;

            Stockobject.modifieduserid = Datastock.modifieduserid;

            Stockobject.confirm = Datastock.confirm;

            Stockobject.ShopId = Datastock.ShopId;

            enqentities.spGetNewStockCountHeader(Datastock.UserID, 

 Datastock.created, 

                Datastock.CompanyID, Datastock.modified, 

 Datastock.modifieduserid, Datastock.confirm,

                Datastock.ShopId, TransactionId);

        }

    }

    }

Answer 1

对问题进行详细讨论后，发现存储过程未正确返回 OUTPUT 参数。上述问题的最终解决方案需要修改代码：[HttpPost]private&nbsp; IActionResult Stock([FromBody] List<spGetNewStockCountHeader_Result> jsonvalues)&nbsp; &nbsp;&nbsp;{&nbsp; ObjectParameter TransactionId = new ObjectParameter("TransactionId", typeof(Int32));&nbsp; foreach (spGetNewStockCountHeader_Result Datastock in jsonvalues)&nbsp; {&nbsp; &nbsp; spGetNewStockCountHeader_Result Stockobject = new spGetNewStockCountHeader_Result();&nbsp; &nbsp; Stockobject.UserID = Datastock.UserID;&nbsp; &nbsp; Stockobject.created = Datastock.created;&nbsp; &nbsp; Stockobject.CompanyID = Datastock.CompanyID;&nbsp; &nbsp; Stockobject.modified = Datastock.modified;&nbsp; &nbsp; Stockobject.modifieduserid = Datastock.modifieduserid;&nbsp; &nbsp; Stockobject.confirm = Datastock.confirm;&nbsp; &nbsp; Stockobject.ShopId = Datastock.ShopId;&nbsp; &nbsp; enqentities.spGetNewStockCountHeader(Datastock.UserID, Datastock.created, Datastock.CompanyID, Datastock.modified, Datastock.modifieduserid, Datastock.confirm,Datastock.ShopId, TransactionId);&nbsp; }return Ok(new { data = TransactionId.Value});&nbsp; &nbsp;&nbsp;}在 Angular 应用程序中获取该TransactionId值后，您可以使用该值将其作为查询字符串或 POST 正文中的参数发送到下一个方法。