Programmer:Search Sales Invoice (19): Difference between revisions

Programmer:Search Sales Invoice (19) (view source)

7 bytes removed , 5 years ago

no edit summary

2,754

edits

Revision as of 06:22, 11 February 2019 (view source) DanielY (talk \| contribs) (→‎Get Full Invoice Details in a Date Range of Last Modified document) ← Older edit		Latest revision as of 06:30, 11 February 2019 (view source) DanielY (talk \| contribs) No edit summary
(One intermediate revision by the same user not shown)
Line 23: </syntaxhighlight> <br/> ==Extract Master Table of Sales Invoice with filtering== ===Get Sales Invoice by Last Modified Date Time=== Line 110 ⟶ 111: <br/> ==Extract Master and Detail Tables of Sales Invoice with ~~selected document list~~filtering== ===Get Full Invoice Details by List of DocNo=== <syntaxhighlight lang="csharp"> Line 172 ⟶ 173: ===Get Full Invoice Details in a Date Range of Last Modified document=== <syntaxhighlight lang="csharp"> public DataSet ~~GetFullInvoiceListOfDateRange~~GetFullInvoiceListByDateRange(DateTime fromDate, DateTime toDate, BCE.Data.DBSetting dbSetting) { BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceListingReport ivReport = BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceListingReport.Create(dbSetting); Line 216 ⟶ 217: DateTime fromDate = new DateTime(2018, 8, 1); DateTime toDate = DateTime.Today.Date; DataSet dsFullInvoiceList = ~~GetFullInvoiceListOfDateRange~~GetFullInvoiceListByDateRange(fromDate, toDate, dbSetting); </syntaxhighlight> *The result of above '''DataSet''' contains many tables. These tables' names are: