The sample code below shows how to retrieve the DataSet of Outstanding Sales Order.
This sample does not filter the result.
public System.Data.DataSet OutstandingSalesOrderData(BCE.Data.DBSetting dbSetting)
{
//Create the object of SalesOrdersOutstandingReportCommand
BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand rptCmd =
BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.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 dsOutstandingSO = new System.Data.DataSet();
dsOutstandingSO.Tables.Add(dtMaster);
dsOutstandingSO.Tables.Add(dtDetail);
//Add the criterias that require to retrieve the data
//Such as add filter to result
BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria crit =
new BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria();
//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 dsOutstandingSO
dsOutstandingSO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
return dsOutstandingSO;
}