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

Line 183:
private long[] GetDocKeyArrayByDateRange(DateTime fromDate, DateTime toDate, BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceCommandSQLInvoiceCommand cmdSqlcmd = BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceCommand.Create(dbSetting);
BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceCommand.Create(dbSetting) as BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceCommandSQL;
BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceCriteria criteria = new BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceCriteria();
DataTable tblInvoice = new DataTable("Invoice");
Line 204 ⟶ 203:
//System.Exception: 'Unknown Sql Exception (Number=102, Message=Incorrect syntax near ','.)'
//is prompted at run-time.
cmdSqlcmd.BasicSearch(criteria, "DocDate", tblInvoice, "");
 
return tblInvoice.AsEnumerable()