/// <summary> /// Parent Constructor /// </summary> /// <param name="parent">parent</param> /// <param name="M_AttributeSetInstance_ID">asi</param> /// <param name="movementQty">qty</param> public MMovementLineMA(MMovementLine parent, int M_AttributeSetInstance_ID, Decimal movementQty) : this(parent.GetCtx(), 0, parent.Get_TrxName()) { SetClientOrg(parent); SetM_MovementLine_ID(parent.GetM_MovementLine_ID()); // SetM_AttributeSetInstance_ID(M_AttributeSetInstance_ID); SetMovementQty(movementQty); }
/// <summary> /// Is Used to Get or Create Instance of MMovementLineMA (Attribute) /// </summary> /// <param name="line"></param> /// <param name="M_AttributeSetInstance_ID"></param> /// <param name="MovementQty"></param> /// <param name="DateMaterialPolicy"></param> /// <returns></returns> public static MMovementLineMA GetOrCreate(MMovementLine line, int M_AttributeSetInstance_ID, Decimal MovementQty, DateTime?DateMaterialPolicy) { MMovementLineMA retValue = null; String sql = "SELECT * FROM M_MovementLineMA " + @" WHERE M_MovementLine_ID = " + line.GetM_MovementLine_ID() + @" AND MMPolicyDate = " + GlobalVariable.TO_DATE(DateMaterialPolicy, true) + @" AND "; if (M_AttributeSetInstance_ID == 0) { sql += "(M_AttributeSetInstance_ID=" + M_AttributeSetInstance_ID + " OR M_AttributeSetInstance_ID IS NULL)"; } else { sql += "M_AttributeSetInstance_ID=" + M_AttributeSetInstance_ID; } DataTable dt = null; IDataReader idr = null; try { idr = DB.ExecuteReader(sql, null, line.Get_Trx()); dt = new DataTable(); dt.Load(idr); idr.Close(); foreach (DataRow dr in dt.Rows) { retValue = new MMovementLineMA(line.GetCtx(), dr, line.Get_Trx()); } } catch (Exception ex) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, ex); } finally { if (idr != null) { idr.Close(); } dt = null; } if (retValue == null) { retValue = new MMovementLineMA(line, M_AttributeSetInstance_ID, MovementQty, DateMaterialPolicy); } else { retValue.SetMovementQty(Decimal.Add(retValue.GetMovementQty(), MovementQty)); } return(retValue); }
/// <summary> /// Parent Constructor /// </summary> /// <param name="parent"></param> /// <param name="M_AttributeSetInstance_ID"></param> /// <param name="movementQty"></param> /// <param name="MMPloicyDate"></param> public MMovementLineMA(MMovementLine parent, int M_AttributeSetInstance_ID, Decimal movementQty, DateTime?MMPloicyDate) : this(parent.GetCtx(), 0, parent.Get_TrxName()) { SetClientOrg(parent); SetM_MovementLine_ID(parent.GetM_MovementLine_ID()); // SetM_AttributeSetInstance_ID(M_AttributeSetInstance_ID); SetMovementQty(movementQty); if (MMPloicyDate == null) { MMPloicyDate = parent.GetParent().GetMovementDate(); } SetMMPolicyDate(MMPloicyDate); }