static internal FixedList <TrialBalanceEntry> GetTrialBalanceEntries(TrialBalanceCommandData commandData)
{
var operation = DataOperation.Parse("@qryTrialBalance",
CommonMethods.FormatSqlDate(commandData.StoredInitialBalanceSet.BalancesDate),
CommonMethods.FormatSqlDate(commandData.FromDate),
CommonMethods.FormatSqlDate(commandData.ToDate),
commandData.StoredInitialBalanceSet.Id,
commandData.Fields,
commandData.Filters,
commandData.AccountFilters,
commandData.Having.Length > 0 ? commandData.Grouping : "",
commandData.Having,
commandData.Ordering,
commandData.InitialFields,
commandData.InitialGrouping,
commandData.AccountsChart.Id
);
return(DataReader.GetPlainObjectFixedList <TrialBalanceEntry>(operation));
}
internal TrialBalanceCommandData GetTrialBalanceCommandData(TrialBalanceCommandPeriod commandPeriod)
{
var commandData = new TrialBalanceCommandData();
var accountsChart = AccountsChart.Parse(_command.AccountsChartUID);
StoredBalanceSet balanceSet = StoredBalanceSet.GetBestBalanceSet(
accountsChart, commandPeriod.FromDate);
commandData.StoredInitialBalanceSet = balanceSet;
commandData.FromDate = commandPeriod.FromDate;
commandData.ToDate = commandPeriod.ToDate;
commandData.InitialFields = GetInitialFields();
commandData.Fields = GetOutputFields();
commandData.Filters = GetFilterString();
commandData.AccountFilters = GetAccountFilterString();
commandData.InitialGrouping = GetInitialGroupingClause();
commandData.Grouping = GetGroupingClause();
commandData.Having = GetHavingClause();
commandData.Ordering = GetOrderClause();
commandData.AccountsChart = accountsChart;
return(commandData);
}
