/// <summary>
/// Get Product Price
/// </summary>
/// <param name="ctx">context</param>
/// <param name="M_PriceList_Version_ID">id</param>
/// <param name="M_Product_ID">id</param>
/// <param name="trxName">transction</param>
/// <returns>product price or null</returns>
public static MProductPrice Get(Ctx ctx, int M_PriceList_Version_ID, int M_Product_ID, Trx trxName)
{
MProductPrice retValue = null;
String sql = "SELECT * FROM M_ProductPrice WHERE M_PriceList_Version_ID=" + M_PriceList_Version_ID + " AND M_Product_ID=" + M_Product_ID;
DataSet ds = new DataSet();
try
{
//ds = DataBase.DB.ExecuteQuery (sql, trxName);
ds = DataBase.DB.ExecuteDataset(sql, null, trxName);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
retValue = new MProductPrice(ctx, dr, trxName);
}
ds = null;
}
catch (Exception e)
{
_log.Log(Level.SEVERE, sql, e);
}
return(retValue);
}
