/// <summary>
/// 通过产品编码获取产品编码的行数
/// </summary>
/// <param name="productCode">产品编码</param>
/// <returns>返回产品编码的行数</returns>
public static int GetProductCodeCountByProductCode(string productCode)
{
return(ProductQuantityDAL.GetProductCodeCountByProductCode(productCode));
}
/// <summary>
/// Get the productId count by productId then judge the productId whether exist
/// </summary>
/// <param name="productId">ProductId</param>
/// <returns>Return the productId count by productId</returns>
public static int ProductIdIsExist_ProductQuantity(int productId)
{
return(ProductQuantityDAL.ProductIdIsExist_ProductQuantity(productId));
}
public static string GetWarehouseName(string warehouseId)
{
return(ProductQuantityDAL.GetWarehouseName(warehouseId));
}
/// <summary>
/// 删除产品库存表中指定的记录
/// </summary>
/// <param name="tran">要处理的事务</param>
/// <param name="productID">产品ID</param>
/// <returns>返回删除产品库存表中指定的记录所影响的行数</returns>
public static int DelProductQuantityByProductID(SqlTransaction tran, int productID)
{
return(ProductQuantityDAL.DelProductQuantityByProductID(tran, productID));
}
public static DataTable getStorage(string sql)
{
return(ProductQuantityDAL.getStorage(sql));
}
