|
//Make
collection of employee object |
|
Collection
employees = new Collection("NetSales.Employees.Employee"); |
|
string
sql = "Select * From Employees Where DatePart(month,Birth)
= ? and DatePart(day,Birth) = ?"; |
|
employees.Deserialize(sql,DataTime.Now.Month,DateTime.Now.Day); |
|
|
|
'//Load
report template |
|
Report
report = new Report(); |
|
report.Logger.FileName
= "c:\\report.log"; |
|
report.Logger.ErrorFileName
= "c:\\reporterror.log"; |
|
report.Load("Employees.xml"); |
|
//report.Load("Employees.html"); |
|
|
|
//Write
report header |
|
IReportWriter
writer = (IReportWriter)report; |
|
writer["Now"]
= DateTime.Now; |
|
writer
= writer.Writer("Employee"); |
|
|
|
//Print
report detail |
|
foreach(Employee
employee in employees) |
|
{ |
|
writer["Name"]
= employee.Name; |
|
writer["Phone"]
= employee.Phone; |
|
writer["BirthDate"]
= employee.BirthDate; |
|
writer["Salary"]
= employee.Salary; |
|
writer.WriteLine(); |
|
} |
|
|
|
//Print
object |
|
foreach(Employee
employee in employees)
writer.WriteLine(employee); |
|
|
|
//Print
collection |
|
writer.WriteAll(employees); |
|
|
|
//Print
"Reader" object |
|
DataBase
db = new DataBase(); |
|
string
emp = "Select * From Employees Where DatePart(month,Birth)
= ? and DatePart(day,Birth) = ?"; |
|
Writer.WriteAll(db.Lookup(emp,DataTime.Now.Month,DateTime.Now.Day)); |
|
|
|
//Save
report to file |
|
//report.Save("Report_Employees.htm"); |
|
report.Save("Report_Employees.xml"); |
|
|
|
//Send
report to email postbox |
|
Mailer
mailer = new Mailer(); |
|
mailer.Logger.FileName
= "c:\\maillog.log"; |
|
mailer.Logger.ErrorFileName
= "c:\\mailerror.log"; |
|
mailer.Host
= "MainHost"; |
|
mailer.FromAddress
= "root@webudp.com"; |
|
mailer.SendTo(report); |