AR Debtor: Difference between revisions

AR Debtor (view source)

256 bytes added , 4 years ago

no edit summary

2,743

edits

Revision as of 08:31, 24 July 2018 (view source) DanielY (talk \| contribs) mNo edit summary ← Older edit		Latest revision as of 04:05, 15 July 2019 (view source) DanielY (talk \| contribs) No edit summary
(4 intermediate revisions by the same user not shown)
Line 30: ===Multiple Records with Filter=== Load more than one debtor.<br/> Programmer can specify which columns to load, while defining the filter of which debtor to be loaded.<br/> This example shows how to load debtor that was modified since a specific date.<br/> <syntaxhighlight lang="csharp"> public System.Data.DataTable GetModifiedDebtorData(DateTime filterFromDate, BCE.Data.DBSetting dbset) Line 49 ⟶ 52: //When .To is not define, the filter is from the lastModifiedDate onwards filterLastModified.From = filterFromDate; //When a range of date that ~~has~~requires ~~until~~"to date", ~~then~~assign ~~only~~.To ~~define~~to implement from...to.To //filterLastModified.To = new DateTime(2018, 12, 31); Line 58 ⟶ 61: //fields to be loaded into DataTable string[] columns = { "AccNo", "CompanyName", "Address1", "Address2", "DeliverAddr1", "DeliverAddr2", "Attention", "Phone1", "AreaCode", "SalesAgent", "EmailAddress", "CreditLimit", "LastModified"}; return cmd.LoadDebtorData(columns, loadDebtorCriteria);