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