/// <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>
/// Set Movement Line
/// </summary>
/// <param name="line">line</param>
public void SetMovementLine(MMovementLine line)
{
SetM_MovementLine_ID(line.GetM_MovementLine_ID());
SetTargetQty(line.GetMovementQty());
//Amit 25-nov-2014
// SetConfirmedQty(GetTargetQty()); // suggestion
SetConfirmedQty(0);
//amit
_line = line;
}
/// <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);
}
public Decimal SetMovementLine(VAdvantage.Model.MMovementLine line)
{
int _CountDTD001 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='DTD001_' AND IsActive='Y'"));
if (_CountDTD001 > 0)
{
SetM_MovementLine_ID(line.GetM_MovementLine_ID());
SetDTD001_TotalQty(line.GetMovementQty());
SetM_Product_ID(line.GetM_Product_ID());
SetM_AttributeSetInstance_ID(line.GetM_AttributeSetInstance_ID());
decimal totalPackQty = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT SUM(Qty) FROM M_PackageLine WHERE M_MovementLine_ID=" + line.GetM_MovementLine_ID()));
SetQty(line.GetMovementQty() - totalPackQty);
_count = Util.GetValueOfDecimal(line.GetMovementQty()) - totalPackQty;
SetDTD001_AlreadyPackQty(totalPackQty);
SetConfirmedQty(line.GetMovementQty() - totalPackQty);
SetDTD001_ConfirmDate(System.DateTime.Now);
}
return(_count);
}
