/// <summary>
/// 根据PriceParaID,修改Prop属性
/// </summary>
internal bool ProductParameterPrice_Update(ProductParameterPriceInfo info)
{
var sql = "ProductParameterPrice_Update";
var cmd = dbw.GetStoredProcCommand(sql);
dbw.AddInParameter(cmd, "PriceParaID", DbType.Int32, info.PriceParaID);
dbw.AddInParameter(cmd, "Prop1", DbType.String, info.Prop1);
dbw.AddInParameter(cmd, "Prop2", DbType.String, info.Prop2);
dbw.AddInParameter(cmd, "Prop3", DbType.String, info.Prop3);
var result = dbw.ExecuteNonQuery(cmd);
return(result > 0);
}
/// <summary>
/// 添加一组属性,0 失败, -1 已经存在 其他正常返回 autoid
/// </summary>
/// <param name="info"></param>
internal int ProductParameterPrice_Insert(ProductParameterPriceInfo info)
{
var sql = "ProductParameterPrice_Insert";
var cmd = dbw.GetStoredProcCommand(sql);
dbw.AddInParameter(cmd, "MainProductID", DbType.Int32, info.MainProductID);
dbw.AddInParameter(cmd, "ChildProductID", DbType.Int32, info.ChildProductID);
dbw.AddInParameter(cmd, "Prop1", DbType.String, info.Prop1);
dbw.AddInParameter(cmd, "Prop2", DbType.String, info.Prop2);
dbw.AddInParameter(cmd, "Prop3", DbType.String, info.Prop3);
var result = int.Parse(dbw.ExecuteScalar(cmd).ToString());
return(result);
}
