/// <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); }