//添加购物车
public CarinforModel AddShop(int CUId, int CSId, int Ccount)
{
//定义输出参数
var pCode = new SqlParameter("Code1", SqlDbType.Int);
var pMsg = new SqlParameter("Msg1", SqlDbType.VarChar);
pMsg.Size = 50;
//定义输出参数方向
pCode.Direction = ParameterDirection.Output;
pMsg.Direction = ParameterDirection.Output;
//执行存储过程
string sql = string.Format("exec sp_AddCart {0},'{1}','{2}',@Code1 out,@Msg1 out", CUId, CSId, Ccount);
var resault = DBHelper.ExecuteNonQuery(sql, new[] { pCode, pMsg });
//定义实体类
CarinforModel s = new CarinforModel();
s.Code = Convert.ToInt32(pCode.Value);
s.Msg = (pMsg.Value).ToString();
return(s);
}
//添加购物车
//POST: api/CarInfors
public CarinforModel Post([FromBody] CarinforModel m)
{
return(dal.AddShop(m.CUId, m.CSId, m.Ccount));
}