/// <summary>
/// 修改指定产品颜色信息
/// </summary>
/// <param name="productColor">产品颜色模型</param>
/// <returns>返回修改指定产品颜色信息所影响的行数</returns>
public static int UpdProductColorByID(SqlTransaction tran, ProductColorModel productColor)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@productColorID", SqlDbType.Int),
new SqlParameter("@productColorName", SqlDbType.VarChar, 50),
new SqlParameter("@productColorDescr", SqlDbType.VarChar, 50)
};
sparams[0].Value = productColor.ProductColorID;
sparams[1].Value = productColor.ProductColorName;
sparams[2].Value = productColor.ProductColorDescr;
return(DBHelper.ExecuteNonQuery(tran, "UpdProductColorByID", sparams, CommandType.StoredProcedure));
}
/// <summary>
/// 添加产品颜色
/// </summary>
/// <param name="productColor">产品颜色模型</param>
/// <returns>返回添加产品颜色所影响的行数</returns>
public static int AddProductColor(ProductColorModel productColor, out int id)
{
int addCount = 0;
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@productColorName", SqlDbType.VarChar, 50),
new SqlParameter("@productColorDescr", SqlDbType.VarChar, 50),
new SqlParameter("@identityID", SqlDbType.Int)
};
sparams[0].Value = productColor.ProductColorName;
sparams[1].Value = productColor.ProductColorDescr;
sparams[2].Direction = ParameterDirection.Output;
addCount = DBHelper.ExecuteNonQuery("AddProductColor", sparams, CommandType.StoredProcedure);
id = Convert.ToInt32(sparams[2].Value);
return(addCount);
}
/// <summary>
/// 添加产品颜色
/// </summary>
/// <param name="productColor">产品颜色模型</param>
/// <returns>返回添加产品颜色所影响的行数</returns>
public static int AddProductColor(ProductColorModel productColor, out int id)
{
return(ProductColorDAL.AddProductColor(productColor, out id));
}
/// <summary>
/// 修改指定产品颜色信息
/// </summary>
/// <param name="productColor">产品颜色模型</param>
/// <returns>返回修改指定产品颜色信息所影响的行数</returns>
public static int UpdProductColorByID(SqlTransaction tran, ProductColorModel productColor)
{
return(ProductColorDAL.UpdProductColorByID(tran, productColor));
}
/// <summary>
/// 添加产品颜色
/// </summary>
/// <param name="productColor">产品颜色模型</param>
/// <returns>返回添加产品颜色所影响的行数</returns>
public static int AddProductColor(SqlTransaction tran, ProductColorModel productColor, out int id)
{
return(ProductColorDAL.AddProductColor(tran, productColor, out id));
}
