Ict.Petra.Server.MFinance.queries.QueryFinanceReport Class Reference

contains a method that calculates the gifts for a HOSA More...

Static Public Member Functions
static DataTable	TotalGiftsThroughFieldMonth (TParameterList AParameters, TResultList AResults)
	Find all the gifts for a specific month, returning "worker", "field" and "total" results. More...
static DataTable	TotalGiftsThroughFieldYear (TParameterList AParameters, TResultList AResults)
	Find all the gifts for a year, returning "worker", "field" and "total" results. More...
static DataTable	SelectGiftRecipients (TParameterList AParameters, TResultList AResults)
	Find recipient Partner Key and name for all partners who received gifts in the timeframe. NOTE - the user can select the PartnerType of the recipient. More...
static DataTable	SelectGiftDonors (TParameterList AParameters, TResultList AResults)
	Find all the gifts for a worker, presenting the results in four year columns. NOTE - the user can select the field of the donor. More...

Detailed Description

contains a method that calculates the gifts for a HOSA

Member Function Documentation

SelectGiftDonors()

static DataTable Ict.Petra.Server.MFinance.queries.QueryFinanceReport.SelectGiftDonors ( TParameterList  AParameters, TResultList  AResults  )

inlinestatic

Find all the gifts for a worker, presenting the results in four year columns. NOTE - the user can select the field of the donor.

All the DB work was previously done by the Select Gift Recipients function above. I only need to filter the table by recipientKey.

Returns

SelectGiftRecipients()

static DataTable Ict.Petra.Server.MFinance.queries.QueryFinanceReport.SelectGiftRecipients ( TParameterList  AParameters, TResultList  AResults  )

inlinestatic

Find recipient Partner Key and name for all partners who received gifts in the timeframe. NOTE - the user can select the PartnerType of the recipient.

With only a little more load on the DB, I can get all the data that the report will need, and store it in a DataTable local to this class, so that when more detailed data is requested below, I don't need another DB query.

Returns

RecipientKey, RecipientName

TotalGiftsThroughFieldMonth()

static DataTable Ict.Petra.Server.MFinance.queries.QueryFinanceReport.TotalGiftsThroughFieldMonth ( TParameterList  AParameters, TResultList  AResults  )

inlinestatic

Find all the gifts for a specific month, returning "worker", "field" and "total" results.

TotalGiftsThroughFieldYear()

static DataTable Ict.Petra.Server.MFinance.queries.QueryFinanceReport.TotalGiftsThroughFieldYear ( TParameterList  AParameters, TResultList  AResults  )

inlinestatic

Find all the gifts for a year, returning "worker", "field" and "total" results.

---

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

• csharp/ICT/Petra/Server/lib/MFinance/queries/ReportFinance.cs