/// <summary>
/// 获取指定的产品单位行数
/// </summary>
/// <param name="productUnitName">产品单位名称</param>
/// <returns>返回获取指定的产品单位行数</returns>
public static int GetProductUnitCountByName(string productUnitName)
{
return(ProductUnitDAL.GetProductUnitCountByName(productUnitName));
}
/// <summary>
/// 获取指定的产品单位行数
/// </summary>
/// <param name="productUnitID">产品单位ID</param>
/// <param name="productUnitName">产品单位名称</param>
/// <returns>返回获取指定的产品单位行数</returns>
public static int GetProductUnitCountByIDName(int productUnitID, string productUnitName)
{
return(ProductUnitDAL.GetProductUnitCountByIDName(productUnitID, productUnitName));
}
/// <summary>
/// 获取产品单位信息
/// </summary>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductUnitInfo()
{
return(ProductUnitDAL.GetProductUnitInfo());
}
/// <summary>
/// 获取指定产品单位信息
/// </summary>
/// <param name="productUnitID">产品单位名称</param>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductUnitInfoByID(int productUnitID)
{
return(ProductUnitDAL.GetProductUnitInfoByID(productUnitID));
}
/// <summary>
/// Delete the productUint information by productUnitId
/// </summary>
/// <param name="tran">Transaction</param>
/// <param name="productUnitID">ProductUnitId</param>
/// <returns>Return affected couts which delete the productUint information by productUnitId</returns>
public static int DelProductUnitByID(SqlTransaction tran, int productUnitId)
{
return(ProductUnitDAL.DelProductUnitByID(tran, productUnitId));
}
/// <summary>
/// 更新指定产品单位信息
/// </summary>
/// <param name="productUnit">产品单位模型</param>
/// <returns>返回更新指定产品单位信息所影响的行数</returns>
public static int UpdProductUnitByID(ProductUnitModel productUnit)
{
return(ProductUnitDAL.UpdProductUnitByID(productUnit));
}
/// <summary>
/// 向产品状态单位表中插入记录
/// </summary>
/// <param name="tran">Transaction</param>
/// <param name="productUnit">产品单位模型</param>
/// <param name="id">Id</param>
/// <returns>返回向产品状态单位表中插入记录所影响的行数</returns>
public static int AddProductUnit(SqlTransaction tran, ProductUnitModel productUnit, out int id)
{
return(ProductUnitDAL.AddProductUnit(tran, productUnit, out id));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static List <ProductUnit> GetAllPage(int PageIndex, int PageSize)
{
return(ProductUnitDAL.GetAllPage(PageIndex, PageSize));
}
/// <summary>
/// 通过联合查询获取信息
/// </summary>
/// <param name="productCode">产品编码</param>
/// <returns>返回DataTable对象</returns>
public static DataTable GetMoreProductInfoByProductCode(string productCode)
{
return(ProductUnitDAL.GetMoreProductInfoByProductCode(productCode));
}
/// <summary>
/// 获取产品单位ID和单位名称
/// </summary>
/// <returns>返回DataTable对象</returns>
public static DataTable GetProductUnitIDNameOrderByUnitID()
{
return(ProductUnitDAL.GetProductUnitIDNameOrderByUnitID());
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(int id)
{
return(ProductUnitDAL.Delete(id));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Edit(ProductUnit pro)
{
return(ProductUnitDAL.Edit(pro));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Add(ProductUnit pro)
{
return(ProductUnitDAL.Add(pro));
}
/// <summary>
/// Judge the ProductUnitId whether exist by Id before delete or update
/// </summary>
/// <param name="Id">ID</param>
/// <returns>Return the counts of the ProductUnitId by Id</returns>
public static int ProductUnitIdIsExist(int Id)
{
return(ProductUnitDAL.ProductUnitIdIsExist(Id));
}
/// <summary>
/// Out to excel the all data of ProductUnit
/// </summary>
/// <returns>Return DataTable Object</returns>
public static DataTable OutToExcel_ProductUnit()
{
return(ProductUnitDAL.OutToExcel_ProductUnit());
}
/// <summary>
/// Judge the ProductUnitId whether has operation by Id before delete
/// </summary>
/// <param name="Id">ID</param>
/// <returns>Return the counts of the ProductUnitId by Id</returns>
public static int ProductUnitIdWhetherHasOperation(int Id)
{
return(ProductUnitDAL.ProductUnitIdWhetherHasOperation(Id));
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public static List <ProductUnit> GetAll()
{
return(ProductUnitDAL.GetAll());
}
