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