private void AddKessanJigyouKatsudouReport(DataDynamics.ActiveReports.ActiveReport parentReport)
{
models.query.JigyouKatsudou jigyou = new models.query.JigyouKatsudou(Context.KaikeiDatabase);
jigyou.Calc(form.StartDate.Value, form.EndDate.Value, form.KaikeiKubun, hideInnerKaikeiKubunKamoku: true, targetKamokuKubunHierarchy: form.KamokuKubunHierarchy, omitZeroRow: form.OmitZeroRow);
var report = new views.reports.JigyouKatsudouSyuushiKeisansyo();
report.SetDB(Context.KaikeiDatabase);
int rootKaikeiKubunId = Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId;
models.db.Row rootRow = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(rootKaikeiKubunId);
string houjinMei = rootRow.GetStr("name");
string kaikeiKubunName = Context.KaikeiDatabase.MTKaikeiKubun.GetFirst("name", "where id=" + form.KaikeiKubun) as string;
string title = "拠点区分事業活動計算書";
string youshiki = "第二号第四様式";
if (form.KaikeiKubun == 1)
{
title = "法人単位事業活動計算書";
youshiki = "第二号第一様式";
}
else if (form.KaikeiKubun == 2)
{
title = "事業区分事業活動計算書";
youshiki = "";
}
report.SetHeader(form.StartDate.Value, form.EndDate.Value, houjinMei, kaikeiKubunName, title, youshiki);
report.SetFooter(
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ToukiKatsudouZougenSagaku],
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ZenkiKurikoshiZougenSagaku],
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ToukimatsuKurikoshiKatsudouZougenSagaku],
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.KihonkinTorikuzushiGaku],
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.SonotaTsumitateTorikuzushiGaku],
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.SonotaTsumitateGaku],
jigyou.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.JikiKurikoshiKatsudouZougenSagaku]);
var source = jigyou.GetRowsForJigyouKatsudouKeisansyoReport();
report.DataSource = source;
report.Run();
parentReport.Document.Pages.AddRange(report.Document.Pages.GetRange(0, report.Document.Pages.Count));
}
private void CalcButtonClicked()
{
if (form.StartDate == null || form.EndDate == null)
{
helper.MsgBox.Err(KaikeiSystemBody.Properties.Resources.MsgInvalidDate);
return;
}
form.ClearDaikubunGrid();
form.ClearKamokuGrid();
jigyouSyuushi = new models.query.JigyouKatsudou(Context.KaikeiDatabase);
jigyouSyuushi.Calc(form.StartDate.Value, form.EndDate.Value, form.KaikeiKubun, hideInnerKaikeiKubunKamoku: true, targetKamokuKubunHierarchy: models.constants.MTKamokuKubunHierarchy.ChuuKubun, omitZeroRow: false);
foreach (var row in jigyouSyuushi.DaikubunRows)
{
int daikubunId = row.Id;
models.db.Row daikubunRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(daikubunId);
if (daikubunRow == null)
{
continue;
}
int shikinSyuushiId = (int)daikubunRow.GetLong("parent_id", 0);
models.db.Row shikinRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(shikinSyuushiId);
if (shikinRow == null)
{
continue;
}
form.AddDaikubunGridRow(
daikubunId,
shikinRow.GetStr("name"),
daikubunRow.GetStr("name"),
row.CurrentYearSum,
row.LastYearSum,
row.Sai
);
}
form.SetSummaryGrid(jigyouSyuushi);
form.FireDaikubunGridSelectionChanged();
helper.MsgBox.Info(KaikeiSystemBody.Properties.Resources.MsgSucceeded);
}
public void SetSummaryGrid(models.query.JigyouKatsudou jigyouSyuushi)
{
summaryGrid.Rows.Clear();
summaryGrid.Rows.Add("サービス活動増減の部", "", "", "", "");
BoldLastRow(summaryGrid);
AddRowToSummaryGrid(" サービス活動収益計", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ServiceKatsudouSyuunyuu]);
AddRowToSummaryGrid(" サービス活動費用計", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ServiceKatsudouShisyutsu]);
AddRowToSummaryGrid(" サービス活動増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ServiceKatsudouSagaku]);
summaryGrid.Rows.Add("サービス活動外増減の部", "", "", "", "");
BoldLastRow(summaryGrid);
AddRowToSummaryGrid(" サービス活動外収益計", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ServiceKatsudouGaiSyuunyuu]);
AddRowToSummaryGrid(" サービス活動外費用計", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ServiceKatsudouGaiShisyutsu]);
AddRowToSummaryGrid(" サービス活動外増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ServiceKatsudouGaiSagaku]);
AddRowToSummaryGrid("経常増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.KeijouZougenSagaku]);
BoldLastRow(summaryGrid);
summaryGrid.Rows.Add("特別増減の部", "", "", "", "");
BoldLastRow(summaryGrid);
AddRowToSummaryGrid(" 特別収益計", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.TokubetsuSyuunyuu]);
AddRowToSummaryGrid(" 特別費用計", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.TokubetsuShisyutsu]);
AddRowToSummaryGrid(" 特別増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.TokubetsuSagaku]);
AddRowToSummaryGrid("当期活動増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ToukiKatsudouZougenSagaku]);
BoldLastRow(summaryGrid);
summaryGrid.Rows.Add("繰越活動増減差額の部", "", "", "", "");
BoldLastRow(summaryGrid);
AddRowToSummaryGrid(" 前期繰越活動増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ZenkiKurikoshiZougenSagaku]);
AddRowToSummaryGrid(" 当期末繰越活動増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.ToukimatsuKurikoshiKatsudouZougenSagaku]);
AddRowToSummaryGrid(" 基本金取崩額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.KihonkinTorikuzushiGaku]);
AddRowToSummaryGrid(" その他の積立金取崩額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.SonotaTsumitateTorikuzushiGaku]);
AddRowToSummaryGrid(" その他の積立金積立額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.SonotaTsumitateGaku]);
AddRowToSummaryGrid(" 次期繰越活動増減差額", jigyouSyuushi.SummaryRows[(int)models.query.JigyouKatsudou.SummaryItem.JikiKurikoshiKatsudouZougenSagaku]);
}
