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