OnDetailColumnChanged

From AutoCount Resource Center
Revision as of 10:21, 1 November 2017 by DanielY (talk | contribs)
Jump to navigation Jump to search

Go to menu

IconAC81.png Go to top
ProgrammerGo.jpg Resources For AutoCount Software Developers


OnDetailColumnChanged

OnDetailColumnChanged is triggered when user changes the value at detail area.
Learn about Master and Detail in Document.

OnDetailColumnChanged event in Sales Invoice

public void OnDetailColumnChanged(BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceDetailColumnChangedEventArgs e)

Example

public void OnDetailColumnChanged(BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceDetailColumnChangedEventArgs e)
{
    if (e.ChangedColumnName == "Qty" || e.ChangedColumnName == "UOM")
    {
        e.CurrentDetailRecord.FOCQty = GetFOCQty(e.CurrentDetailRecord.SmallestQty);
    }
}

private BCE.Data.DBDecimal GetFOCQty(decimal qty)
{
    if (qty >= 10)
    {
        return Math.Floor(qty / 10);
    }
    else
    {
        return DBNull.Value;
    }
}

When Qty value is changed, it will refresh the value of FOCQty. The value of FOCQty is based on the qty of every 10 unit.
In this example, you will also see the example using of DBDecimal and DBNull.Value.