The sample code below shows how to retrieve the DataSet of Outstanding Delivery Order.
This sample does not filter the result.
public System.Data.DataSet OutstandingDeliveryOrderData(BCE.Data.DBSetting dbSetting)
{
//Create the object of DeliveryOrdersOutstandingReportCommand
BCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutstandingReportCommand rptCmd =
BCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutstandingReportCommand.Create(dbSetting);
//Prepare the DataSet of Master table and Detail table
System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
System.Data.DataTable dtDetail= new System.Data.DataTable("Detail");
System.Data.DataSet dsOutstandingDO = new System.Data.DataSet();
dsOutstandingDO.Tables.Add(dtMaster);
dsOutstandingDO.Tables.Add(dtDetail);
//Add the criterias that require to retrieve the data
//Such as add filter to result
BCE.AutoCount.Invoicing.Sales.DeliveryOrder.DeliveryOrderOutStandingReportingCriteria crit =
new BCE.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 dsOutstandingDO
dsOutstandingDO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
return dsOutstandingDO;
}