Programmer:Outstanding Sales Order (20): Difference between revisions

no edit summary
No edit summary
No edit summary
 
Line 13:
System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
dsOutStandingPOdsOutStandingSO.Tables.Add(dtMaster);
dsOutStandingPOdsOutStandingSO.Tables.Add(dtDetail);
AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(userSession);
 
Line 20:
 
 
cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutStandingPOdsOutStandingSO, "");
 
//Create a new DataRelation to Master and Detail tables in dsOutstandingDOdsOutstandingSO
dsOutStandingPOdsOutStandingSO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
 
return dsOutStandingSO;