/// <summary>
/// 获取产品的单条信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ProductEditAdd EditProduct(int pid)
{
using (IDbConnection conn = new SqlConnection(connStr))
{
ProductEditAdd info = new ProductEditAdd();
string sql = $"SELECT * FROM v_Product WHERE ProductId=@id";
info = conn.QueryFirstOrDefault <ProductEditAdd>(sql, new { id = pid });
return(info);
}
}
/// <summary>
/// 添加产品信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int AddProduct(ProductEditAdd info)
{
using (IDbConnection conn = new SqlConnection(connStr))
{
string sql = @"EXEC dbo.p_Products @productName,
@userId,
@productDetail,
@tradeId,
@typeId,
@addressId,
@stageId";
var res = conn.Execute(sql, new { productName = info.ProductName, userId = info.UserId, productDetail = info.ProductDetail, tradeId = info.TradeId, typeId = info.TypeId, addressId = info.AddressId, stageId = info.StageId });
return(res);
}
}
