public int AddProductProc(ProcProductStyleEntity entity)
{
string sql = @"EXEC Proc_ProductEdit @AdTitle,@Title,@BrandId,@Price,@MarketPrice,@PicUrl,@DefaultProductId,@ClassId,@HasHtml,@Cost,@TradePrice,@SellerId,@Num,
@ContentCms,@StyleId,@StylePics,@StylePropertys,@BrandCars
" ;
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@AdTitle", DbType.String, entity.AdTitle);
db.AddInParameter(cmd, "@Title", DbType.String, entity.Title);
db.AddInParameter(cmd, "@BrandId", DbType.Int32, entity.BrandId);
db.AddInParameter(cmd, "@Price", DbType.Decimal, entity.Price);
db.AddInParameter(cmd, "@MarketPrice", DbType.Decimal, entity.MarketPrice);
db.AddInParameter(cmd, "@PicUrl", DbType.String, entity.PicUrl);
db.AddInParameter(cmd, "@DefaultProductId", DbType.Int32, entity.DefaultProductId);
db.AddInParameter(cmd, "@ClassId", DbType.Int32, entity.ClassId);
db.AddInParameter(cmd, "@HasHtml", DbType.Int32, entity.HasHtml);
db.AddInParameter(cmd, "@Cost", DbType.Decimal, entity.Cost);
db.AddInParameter(cmd, "@TradePrice", DbType.Decimal, entity.TradePrice);
db.AddInParameter(cmd, "@SellerId", DbType.Int32, entity.SellerId);
db.AddInParameter(cmd, "@Num", DbType.Int32, entity.Num);
db.AddInParameter(cmd, "@ContentCms", DbType.String, entity.ContentCms);
db.AddInParameter(cmd, "@StyleId", DbType.Int32, entity.StyleId);
db.AddInParameter(cmd, "@BrandCars", DbType.String, entity.BrandCars);
db.AddInParameter(cmd, "@StylePics", DbType.String, entity.StylePics);
db.AddInParameter(cmd, "@StylePropertys", DbType.String, entity.StylePropertys);
object identity = db.ExecuteScalar(cmd);
if (identity == null || identity == DBNull.Value)
{
return(0);
}
return(Convert.ToInt32(identity));
}
public int AddProductProc(ProcProductStyleEntity _entity)
{
return(ProductStyleDA.Instance.AddProductProc(_entity));
}
