Extract data of Outstanding Delivery Order with API
The sample code below shows how to retrieve the DataSet of Outstanding Delivery Order.
This sample does not filter the result.
publicSystem.Data.DataSetOutstandingDeliveryOrderData(BCE.Data.DBSettingdbSetting){//Create the object of DeliveryOrdersOutstandingReportCommandBCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutstandingReportCommandrptCmd=BCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutstandingReportCommand.Create(dbSetting);//Prepare the DataSet of Master table and Detail tableSystem.Data.DataTabledtMaster=newSystem.Data.DataTable("Master");System.Data.DataTabledtDetail=newSystem.Data.DataTable("Detail");System.Data.DataSetdsOutstandingDO=newSystem.Data.DataSet();dsOutstandingDO.Tables.Add(dtMaster);dsOutstandingDO.Tables.Add(dtDetail);//Add the criterias that require to retrieve the data//Such as add filter to resultBCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutStandingReportingCriteriacrit=newBCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutStandingReportingCriteria();//Define addition fields of DocNo, DocDate, DebtorCode, DebtorName.//Programmer may add more fieldname to the DataTable of Master Table. rptCmd.BasicSearch(crit,"DocNo,DocDate,DebtorCode,DebtorName",dsOutstandingDO,"");//Create a new DataRelation to Master and Detail tables in dsOutstandingDOdsOutstandingDO.Relations.Add("MasterDetailRelation",dtMaster.Columns["DocKey"],dtDetail.Columns["DocKey"],false);returndsOutstandingDO;}