/// <summary>
/// Parent Constructor
/// </summary>
/// <param name="parent"></param>
public MUOMConversion(MUOM parent)
: this(parent.GetCtx(), 0, parent.Get_TrxName())
{
SetClientOrg(parent);
SetC_UOM_ID(parent.GetC_UOM_ID());
SetM_Product_ID(0);
SetC_UOM_To_ID(parent.GetC_UOM_ID());
SetMultiplyRate(Env.ONE);
SetDivideRate(Env.ONE);
}
/// <summary>
/// Get Minute C_UOM_ID
/// </summary>
/// <param name="ctx"></param>
/// <returns>C_UOM_ID for Minute</returns>
public static int GetMinute_UOM_ID(Ctx ctx)
{
if (Ini.IsClient())
{
//Iterator it = s_cache.values().iterator();
IEnumerator it = s_cache.Values.GetEnumerator();
while (it.MoveNext())
{
MUOM uom = (MUOM)it.Current;
if (uom.IsMinute())
{
return(uom.GetC_UOM_ID());
}
}
}
// Server
int C_UOM_ID = 0;
String sql = "SELECT C_UOM_ID FROM C_UOM WHERE IsActive='Y' AND X12DE355='MJ'"; // HardCoded
//DataTable dt = null;
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, null);
while (idr.Read())
{
C_UOM_ID = Utility.Util.GetValueOfInt(idr[0]);
}
idr.Close();
idr = null;
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
idr = null;
}
_log.Log(Level.SEVERE, sql, e);
}
return(C_UOM_ID);
}
/// <summary>
/// Load All UOMs
/// </summary>
/// <param name="ctx"></param>
private static void LoadUOMs(Ctx ctx)
{
String sql = MRole.GetDefault(ctx, false).AddAccessSQL(
"SELECT * FROM C_UOM "
+ "WHERE IsActive='Y'",
"C_UOM", MRole.SQL_NOTQUALIFIED, MRole.SQL_RO);
try
{
DataSet ds = ExecuteQuery.ExecuteDataset(sql, null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
MUOM uom = new MUOM(ctx, dr, null);
s_cache.Add(uom.GetC_UOM_ID(), uom);
}
ds = null;
}
catch (Exception e)
{
_log.Log(Level.SEVERE, sql, e);
}
}
