OpenPetra
Free Administration Software for Non-Profits
Ict.Petra.Server.MReporting.HTMLTemplateProcessor Class Reference

parse and replace HTML templates for reports More...

Public Types

enum  ReplaceOptions { NoQuotes , QuotesForStrings , SqlParameters }
 how to replace values More...
 

Public Member Functions

 HTMLTemplateProcessor (string AHTMLTemplate, TParameterList AParameters)
 constructor More...
 
void AddParametersFromRow (DataRow row)
 Adds the parameters from row. More...
 
void SetParameter (string name, TVariant value)
 Sets the parameter. More...
 
string GetSQLQuery (string queryname)
 Gets the SQL query. More...
 
HtmlDocument GetHTML ()
 the processed HTML More...
 
string InsertParameters (string searchOpen, string searchClose, string template, ReplaceOptions options)
 Inserts the parameters into a template More...
 

Static Public Member Functions

static HtmlNodeCollection SelectNodes (HtmlNode node, string xpath)
 Selects the nodes. More...
 
static HtmlNode SelectSingleNode (HtmlNode node, string xpath)
 Selects the first matching node. More...
 
static HtmlDocument Table2Html (DataTable ATable, string ATemplateFilename, string AReportLanguage)
 print simple reports, from one table using an HTML template file More...
 
static XSSFWorkbook HTMLToCalc (HtmlDocument html)
 Create an Excel file from the HTML More...
 

Detailed Description

parse and replace HTML templates for reports

Member Enumeration Documentation

◆ ReplaceOptions

how to replace values

Enumerator
NoQuotes 

no quotes

QuotesForStrings 

use quotes for strings

SqlParameters 

use sql parameters

Constructor & Destructor Documentation

◆ HTMLTemplateProcessor()

Ict.Petra.Server.MReporting.HTMLTemplateProcessor.HTMLTemplateProcessor ( string  AHTMLTemplate,
TParameterList  AParameters 
)
inline

constructor

Member Function Documentation

◆ AddParametersFromRow()

void Ict.Petra.Server.MReporting.HTMLTemplateProcessor.AddParametersFromRow ( DataRow  row)
inline

Adds the parameters from row.

◆ GetHTML()

HtmlDocument Ict.Petra.Server.MReporting.HTMLTemplateProcessor.GetHTML ( )
inline

the processed HTML

◆ GetSQLQuery()

string Ict.Petra.Server.MReporting.HTMLTemplateProcessor.GetSQLQuery ( string  queryname)
inline

Gets the SQL query.

◆ HTMLToCalc()

static XSSFWorkbook Ict.Petra.Server.MReporting.HTMLTemplateProcessor.HTMLToCalc ( HtmlDocument  html)
inlinestatic

Create an Excel file from the HTML

◆ InsertParameters()

string Ict.Petra.Server.MReporting.HTMLTemplateProcessor.InsertParameters ( string  searchOpen,
string  searchClose,
string  template,
ReplaceOptions  options 
)
inline

Inserts the parameters into a template

◆ SelectNodes()

static HtmlNodeCollection Ict.Petra.Server.MReporting.HTMLTemplateProcessor.SelectNodes ( HtmlNode  node,
string  xpath 
)
inlinestatic

Selects the nodes.

◆ SelectSingleNode()

static HtmlNode Ict.Petra.Server.MReporting.HTMLTemplateProcessor.SelectSingleNode ( HtmlNode  node,
string  xpath 
)
inlinestatic

Selects the first matching node.

◆ SetParameter()

void Ict.Petra.Server.MReporting.HTMLTemplateProcessor.SetParameter ( string  name,
TVariant  value 
)
inline

Sets the parameter.

◆ Table2Html()

static HtmlDocument Ict.Petra.Server.MReporting.HTMLTemplateProcessor.Table2Html ( DataTable  ATable,
string  ATemplateFilename,
string  AReportLanguage 
)
inlinestatic

print simple reports, from one table using an HTML template file


The documentation for this class was generated from the following file: