OnDetailColumnChanged
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.
