MVC c# 调用 MS sql的存储过程

luoyanqing119

于 2023-06-13 13:04:55 发布

阅读量256

点赞数

CC 4.0 BY-SA版权

文章标签： java 算法 sqlserver ASP.NET MVC

本文链接：https://blog.youkuaiyun.com/luoyanqing119/article/details/131186086

代码示例展示了如何创建SqlParameter对象来传递输入参数和输出参数给存储过程OptStock。执行后，将输出参数Result的值赋给model.Status。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

var hid = new SqlParameter { ParameterName = "HistoryId", Value = history.Id, Direction = ParameterDirection.Input };

var sid = new SqlParameter { ParameterName = "StoreId", Value = StoreId, Direction = ParameterDirection.Input };

var qrcode = new SqlParameter { ParameterName = "QRCode", Value = strQRCode, Direction = ParameterDirection.Input };

var guidcode = new SqlParameter { ParameterName = "GUIDCode", Value = strGUIDCode, Direction = ParameterDirection.Input };

var result = new SqlParameter { ParameterName = "Result", Value = 0, Direction = ParameterDirection.Output };

db.Database.ExecuteSqlCommand("exec @Result = OptStock @HistoryId,@StoreId,@QRCode,@GUIDCode", hid, sid, qrcode, guidcode, result);

model.Status = (int)result.Value;

存储过程为OptStock，带参数输入，输出