/// <summary>
/// 获取指定产品状态的行数
/// </summary>
/// <param name="productStatusID">产品状态ID</param>
/// <param name="productStatusName">产品状态名称</param>
/// <returns>返回获取指定产品状态的行数</returns>
public static int GetProductStatusCountByIDName(int productStatusID, string productStatusName)
{
return(ProductStatusDAL.GetProductStatusCountByIDName(productStatusID, productStatusName));
}
/// <summary>
/// 获取指定产品状态的行数
/// </summary>
/// <param name="productStatusName">产品状态名称</param>
/// <returns>返回获取指定产品状态的行数</returns>
public static int GetProductStatusCountByName(string productStatusName)
{
return(ProductStatusDAL.GetProductStatusCountByName(productStatusName));
}
/// <summary>
/// 向产品状态表中插入记录
/// </summary>
/// <param name="productStatus">产品状态模型</param>
/// <returns>返回向产品状态表中插入记录所影响的行数</returns>
public static int AddProductStatus(SqlTransaction tran, ProductStatusModel productStatus, out int id)
{
return(ProductStatusDAL.AddProductStatus(tran, productStatus, out id));
}
/// <summary>
/// 获取产品状态信息
/// </summary>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductStatusInfo()
{
return(ProductStatusDAL.GetProductStatusInfo());
}
/// <summary>
/// 获取指定产品状态信息
/// </summary>
/// <param name="productStatusID">产品你状态ID</param>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductStatusInfoByID(int productStatusID)
{
return(ProductStatusDAL.GetProductStatusInfoByID(productStatusID));
}
/// <summary>
/// 更新指定产品状态信息
/// </summary>
/// <param name="productStatus">产品状态模型</param>
/// <returns>返回更新指定产品状态信息所影响的行数</returns>
public static int UpdProductStatusByID(ProductStatusModel productStatus)
{
return(ProductStatusDAL.UpdProductStatusByID(productStatus));
}
/// <summary>
/// Delete the ProductStatus information by productStatusId
/// </summary>
/// <param name="tran">Transaction</param>
/// <param name="productStatusID">ProductStatusId</param>
/// <returns>Return affeted counts which delete the ProductStatus information by productStatusId</returns>
public static int DelProductStatusByID(SqlTransaction tran, int productStatusID)
{
return(ProductStatusDAL.DelProductStatusByID(tran, productStatusID));
}
/// <summary>
/// Out to excel the all data of ProductStatus
/// </summary>
/// <returns>Return DataTable Object</returns>
public static DataTable OutToExcel_ProductStatus()
{
return(ProductStatusDAL.OutToExcel_ProductStatus());
}
/// <summary>
/// Judge the ProductStatusId whether exist by Id before delete or update
/// </summary>
/// <param name="Id">Id</param>
/// <returns>Return the counts of the ProductStatus by Id</returns>
public static int ProductStatusIdIsExist(int Id)
{
return(ProductStatusDAL.ProductStatusIdIsExist(Id));
}
/// <summary>
/// Judge the ProductStatusId whether has operation before delete by Id
/// </summary>
/// <param name="Id">Id</param>
/// <returns>Return the counts of the ProductStatus by Id</returns>
public static int ProductStatusIdWhetherHasOperation(int Id)
{
return(ProductStatusDAL.ProductStatusIdWhetherHasOperation(Id));
}
