/// <summary>
/// 获取指定产品规格的行数
/// </summary>
/// <param name="productSpecID">产品规格ID</param>
/// <param name="productSpecName">产品规格名称</param>
/// <returns>返回获取指定产品规格的行数</returns>
public static int GetProductSpecCountByIDName(int productSpecID, string productSpecName)
{
return(ProductSpecDAL.GetProductSpecCountByIDName(productSpecID, productSpecName));
}
/// <summary>
/// 向产品规格表中插入记录
/// </summary>
/// <param name="productSpec">产品规格ID</param>
/// <returns>返回向产品规格表中插入记录所影响的行数</returns>
public static int AddProductSpec(ProductSpecModel productSpec)
{
return(ProductSpecDAL.AddProductSpec(productSpec));
}
/// <summary>
/// 获取指定产品规格的行数
/// </summary>
/// <param name="productSpecName">产品规格名称</param>
/// <returns>返回获取指定产品规格的行数</returns>
public static int GetProductSpecCountByName(string productSpecName)
{
return(ProductSpecDAL.GetProductSpecCountByName(productSpecName));
}
/// <summary>
/// 获取产品规格信息
/// </summary>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductSpecInfo()
{
return(ProductSpecDAL.GetProductSpecInfo());
}
/// <summary>
/// 获取指定产品规格信息
/// </summary>
/// <param name="productSpecID">产品规格ID</param>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductSpecInfoByID(int productSpecID)
{
return(ProductSpecDAL.GetProductSpecInfoByID(productSpecID));
}
/// <summary>
/// 删除指定产品规格记录
/// </summary>
/// <param name="productSpecID">产品规格ID</param>
/// <returns>返回删除指定产品规格记录所影响的行数</returns>
public static int DelProductSpecByID(int productSpecID)
{
return(ProductSpecDAL.DelProductSpecByID(productSpecID));
}
/// <summary>
/// 更新指定产品规格信息
/// </summary>
/// <param name="productSpec">产品规格模型</param>
/// <returns>返回更新指定产品规格信息所影响的行数</returns>
public static int UpdProductSpecByID(ProductSpecModel productSpec)
{
return(ProductSpecDAL.UpdProductSpecByID(productSpec));
}
/// <summary>
/// Judge the ProductSpecId whether exist by Id before delete or update
/// </summary>
/// <param name="Id">Id</param>
/// <returns>Return the counts of the ProductSpec by Id</returns>
public static int ProductSpecIdIsExist(int Id)
{
return(ProductSpecDAL.ProductSpecIdIsExist(Id));
}
/// <summary>
/// Out to excel to the all data of ProductSpec
/// </summary>
/// <returns>Return DataTable Object</returns>
public static DataTable OutToExcel_ProductSpec()
{
return(ProductSpecDAL.OutToExcel_ProductSpec());
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(int id)
{
return(ProductSpecDAL.Delete(id));
}
/// <summary>
/// Judge the ProductSpecId whether has operation before delete by Id
/// </summary>
/// <param name="Id">Id</param>
/// <returns>Return the counts of the ProductSpec by Id</returns>
public static int ProductSpecIdWhetherHasOperation(int Id)
{
return(ProductSpecDAL.ProductSpecIdWhetherHasOperation(Id));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Edit(ProductSpec pro)
{
return(ProductSpecDAL.Edit(pro));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Add(ProductSpec pro)
{
return(ProductSpecDAL.Add(pro));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static List <ProductSpec> GetAllPage(int PageIndex, int PageSize)
{
return(ProductSpecDAL.GetAllPage(PageIndex, PageSize));
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public static List <ProductSpec> GetAll()
{
return(ProductSpecDAL.GetAll());
}
/// <summary>
/// 获取产品规格名称
/// </summary>
/// <param name="productSpecID">产品规格ID</param>
/// <returns>返回产品规格名称</returns>
public static string GetProductSpecNameByID(int productSpecID)
{
return(ProductSpecDAL.GetProductSpecNameByID(productSpecID));
}