class ARStatements
{
private UserSession myUserSession;
public ARStatements(UserSession userSession)
{
myUserSession = userSession;
}
public System.Data.DataSet GetDebtorStatement()
{
AutoCount.ARAP.DebtorStatement.DebtorStatement statement =
AutoCount.ARAP.DebtorStatement.DebtorStatement.Create(myUserSession);
AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria crit = new
AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria();
//Set filter by date range
crit.FromDate = new DateTime(2023, 10, 1);
crit.ToDate = new DateTime(2023, 10, 31);
//Load statement data
statement.Inquire(crit);
return statement.ResultDataSet;
}
//debtorCode = "300-C001";
//filepath = @"C:\Temp\MyExportName.pdf"
public void ExportToPdfByDebtor(string debtorCode, string filepath)
{
AutoCount.ARAP.DebtorStatement.DebtorStatement statement =
AutoCount.ARAP.DebtorStatement.DebtorStatement.Create(myUserSession);
AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria crit = new
AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria();
AutoCount.SearchFilter.ReportFilter filterDebtor = new
AutoCount.SearchFilter.ReportFilter();
//Set filter by date range
crit.FromDate = new DateTime(2023, 10, 1);
crit.ToDate = new DateTime(2023, 10, 31);
//Only one debtor in one document.
filterDebtor.ByOne(debtorCode);
crit.DebtorFilter = filterDebtor;
//Load statement data
statement.Inquire(crit);
//Export to PDF
//"Debtor Statement - 6 Months" is the name of the Report Template
AutoCount.Report.ReportTool.ExportReportByName("Debtor Statement - 6 Months",
statement.GetReportDataSource(), myUserSession,
new AutoCount.Report.BasicReportOption(),
new AutoCount.Report.ReportInfo("", "", "", ""),
filepath,
AutoCount.Report.ExportFormat.Pdf);
}
}