The sample code below shows how to retrieve the DataSet of Outstanding Purchase Order.
This sample does not filter the result.
public System.Data.DataSet OutstandingPurchaseOrderData(BCE.Data.DBSetting dbSetting)
{
//Create the object of PurchaseOrdersOutstandingReportCommand
BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand rptCmd =
BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand.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 dsOutstandingPO = new System.Data.DataSet();
dsOutstandingPO.Tables.Add(dtMaster);
dsOutstandingPO.Tables.Add(dtDetail);
//Add the criterias that require to retrieve the data
//Such as add filter to result
BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria crit =
new BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria();
//Define addition fields of DocNo, DocDate, CreditorCode, CreditorName.
//Programmer may add more fieldname to the DataTable of Master Table.
rptCmd.BasicSearch(crit, "DocNo,DocDate,CreditorCode,CreditorName", dsOutstandingPO, "");
//Create a new DataRelation to Master and Detail tables in dsOutstandingPO
dsOutstandingPO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
return dsOutstandingPO;
}