/**
* Set default PriceList
*/
public void SetM_PriceList_ID()
{
try
{
MPriceList defaultPL = MPriceList.GetDefault(GetCtx(), false);
if (defaultPL == null)
{
defaultPL = MPriceList.GetDefault(GetCtx(), true);
}
if (defaultPL != null)
{
SetM_PriceList_ID(defaultPL.GetM_PriceList_ID());
}
}
catch (Exception ex)
{
// MessageBox.Show("MRequisition--SetM_PriceList_ID");
log.Severe(ex.ToString());
}
}
/// <summary>
/// Get Default Price List for Client (cached)
/// </summary>
/// <param name="ctx">context</param>
/// <param name="IsSOPriceList">SO or PO</param>
/// <returns>PriceList or null</returns>
public static MPriceList GetDefault(Ctx ctx, bool IsSOPriceList)
{
int AD_Client_ID = ctx.GetAD_Client_ID();
MPriceList retValue = null;
// Search for it in cache
//Iterator<MPriceList> it = _cache.values().iterator();
IEnumerator <MPriceList> it = _cache.Values.GetEnumerator();
while (it.MoveNext())
{
retValue = (MPriceList)it.Current;
if (retValue.IsDefault() && retValue.GetAD_Client_ID() == AD_Client_ID)
{
return(retValue);
}
}
//Get from DB
retValue = null;
StringBuilder sql = new StringBuilder();
sql.Append("SELECT * FROM M_PriceList "
+ "WHERE AD_Client_ID=" + AD_Client_ID + " AND IsDefault='Y'");
if (IsSOPriceList)
{
//pstmt.setString(2, "Y");
sql.Append(" AND IsSOPriceList='Y'"); // YS: Changed from hard code to Parameter
}
else
{
//pstmt.setString(2, "N");
sql.Append(" AND IsSOPriceList='N'"); // YS: Changed from hard code to Parameter
}
sql.Append("ORDER BY M_PriceList_ID");
//String sql = "SELECT * FROM M_PriceList "
// + "WHERE AD_Client_ID=" + AD_Client_ID
// + " AND IsDefault='Y'"
// + " AND IsSOPriceList=?" // YS: Changed from hard code to Parameter
// + "ORDER BY M_PriceList_ID";
DataSet ds = null;
try
{
ds = ExecuteQuery.ExecuteDataset(sql.ToString(), null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
retValue = new MPriceList(ctx, dr, null);
}
}
catch (Exception e)
{
ds = null;
_log.Log(Level.SEVERE, sql.ToString(), e);
}
// Return value
if (retValue != null)
{
int key = retValue.GetM_PriceList_ID();
_cache.Add(key, retValue);
}
return(retValue);
}
/// <summary>
/// Parent Constructor
/// </summary>
/// <param name="pl">parent</param>
public MPriceListVersion(MPriceList pl)
: this(pl.GetCtx(), 0, pl.Get_TrxName())
{
SetClientOrg(pl);
SetM_PriceList_ID(pl.GetM_PriceList_ID());
}
