/// <summary>
/// Judge the ProductColorID whether exist by ProductColorID before delete or update
/// </summary>
/// <param name="productColorID">ProductColorID</param>
/// <returns>Return counts</returns>
public static int ProductColorIDIsExist(int productColorID)
{
return(ProductColorDAL.ProductColorIDIsExist(productColorID));
}
/// <summary>
/// 获取指定产品名称的行数
/// </summary>
/// <param name="productColorID">产品颜色ID</param>
/// <param name="productColorName">产品颜色名称</param>
/// <returns>返回指定产品名称的行数</returns>
public static int GetProductColorCountByIDName(int productColorID, string productColorName)
{
return(ProductColorDAL.GetProductColorCountByIDName(productColorID, productColorName));
}
/// <summary>
/// Juage the ProductColorID whether has operation before delete
/// </summary>
/// <param name="productColorID">ProductColorID</param>
/// <returns>Return counts</returns>
public static int ProductColorIDWhetherHasOperation(int productColorID)
{
return(ProductColorDAL.ProductColorIDWhetherHasOperation(productColorID));
}
/// <summary>
/// 获取指定的产品颜色信息
/// </summary>
/// <param name="productColorID">产品颜色ID</param>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductColorInfoByID(int productColorID)
{
return(ProductColorDAL.GetProductColorInfoByID(productColorID));
}
/// <summary>
/// 获取指定产品名称的行数
/// </summary>
/// <param name="productColorName">产品颜色名称</param>
/// <returns>返回指定产品名称的行数</returns>
public static int GetProductColorCountByName(string productColorName)
{
return(ProductColorDAL.GetProductColorCountByName(productColorName));
}
/// <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>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductColorInfo()
{
return(ProductColorDAL.GetProductColorInfo());
}
/// <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));
}
/// <summary>
/// 修改指定产品颜色信息
/// </summary>
/// <param name="productColor">产品颜色模型</param>
/// <returns>返回修改指定产品颜色信息所影响的行数</returns>
public static int UpdProductColorByID(SqlTransaction tran, ProductColorModel productColor)
{
return(ProductColorDAL.UpdProductColorByID(tran, productColor));
}
/// <summary>
/// Out to excel the all data of ProductColor
/// </summary>
/// <returns>Return DataTable Object</returns>
public static DataTable OutToExcel_ProductColor()
{
return(ProductColorDAL.OutToExcel_ProductColor());
}
/// <summary>
/// Delete the ProductColor information by productColorId
/// </summary>
/// <param name="tran">Transaction</param>
/// <param name="productColorID">ProductColorId</param>
/// <returns>Return affected row counts which delete the ProductColor information by productColorId</returns>
public static int DelProductColorByID(SqlTransaction tran, int productColorID)
{
return(ProductColorDAL.DelProductColorByID(tran, productColorID));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(int id)
{
return(ProductColorDAL.Delete(id));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Edit(ProductColor pro)
{
return(ProductColorDAL.Edit(pro));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Add(ProductColor pro)
{
return(ProductColorDAL.Add(pro));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static List <ProductColor> GetAllPage(int PageIndex, int PageSize)
{
return(ProductColorDAL.GetAllPage(PageIndex, PageSize));
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public static List <ProductColor> GetAll()
{
return(ProductColorDAL.GetAll());
}
