/// <summary>
/// Get BOM Lines for Product. Default to Current Active, Master BOM
/// BOM Lines are Ordered By Ascending Order of Product Names.
/// </summary>
/// <param name="product">product</param>
/// <param name="bomType">bomtype</param>
/// <param name="bomUse">bomuse</param>
/// <param name="isAscending">true if ascending, false if descending</param>
/// <returns>array of BOMs</returns>
/// <writer>raghu</writer>
/// <date>08-march-2011</date>
public static MBOMProduct[] GetBOMLinesOrderByProductName(MProduct product, String bomType, String bomUse, Boolean isAscending)
{
// return lines for Current Active, Master BOM
String sql = "SELECT M_BOM_ID FROM M_BOM WHERE M_Product_ID= " + product.GetM_Product_ID() +
"AND BOMType ='" + bomType + "' AND BOMUse ='" + bomUse + "' AND IsActive = 'Y'";
Trx trx = product.Get_Trx();
int bomID = 0;
IDataReader idr = null;
try
{
idr = DB.ExecuteReader(sql, null, trx);
if (idr.Read())
{
bomID = Util.GetValueOfInt(idr[0]);
}
idr.Close();
}
catch (Exception e)
{
_log.Log(Level.SEVERE, sql, e);
}
finally
{
if (idr != null)
{
idr.Close();
idr = null;
}
}
return(GetBOMLinesOrderByProductName(MBOM.Get(product.GetCtx(), bomID), isAscending));
}
