private void AddKessanBalanceSheetReport(DataDynamics.ActiveReports.ActiveReport parentReport)
{
models.query.BalanceSheet balance = new models.query.BalanceSheet(Context.KaikeiDatabase);
balance.Calc(form.StartDate.Value, form.EndDate.Value, form.KaikeiKubun, hideInnerKaikeiKubunKamoku: true);
models.query.BalanceSheetTyuuki tyuuki = new models.query.BalanceSheetTyuuki(Context.KaikeiDatabase);
tyuuki.Calc(helper.Converter.GetNenndo(form.StartDate.Value), form.KaikeiKubun);
var report = new views.reports.BalanceSheet();
report.SetDB(Context.KaikeiDatabase);
string houjinMei = Context.KaikeiDatabase.MTKaikeiKubun.RootName;
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(
houjinMei,
kaikeiKubunName,
form.EndDate.Value, title, youshiki);
report.SetSummaryRow(
balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.ShisanSummary),
balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.HusaiSummary),
balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.JunshisanSummary),
balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.HusaiPlusJunshisanSummary),
balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.JikiKurikoshiSagaku),
balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.ToukiSagaku));
report.SetDataSource(
balance.GetChildrenList((int)models.constants.MTKamokuKubun.Shisan),
balance.GetChildrenList((int)models.constants.MTKamokuKubun.Husai),
balance.GetChildrenList((int)models.constants.MTKamokuKubun.Junshisan),
tyuuki.Tyuuki1Rows,
tyuuki.Tyuuki3Rows,
tyuuki.Tyuuki4Rows,
tyuuki.Tyuuki5Rows);
report.SetTyuukiData(
tyuuki.GenkaSyoukyakuRuikeiGaku,
tyuuki.TyousyuuHunouKin,
tyuuki.Tyuuki2,
tyuuki.Tyuuki6);
report.Run();
parentReport.Document.Pages.AddRange(report.Document.Pages.GetRange(0, report.Document.Pages.Count));
}
private void Execute()
{
if (form.NextYear == null)
{
helper.MsgBox.Err(KaikeiSystemBody.Properties.Resources.MsgInvalidYear);
return;
}
int nextYear = form.NextYear.Value.Year;
DateTime lastNenndoKisanbi = helper.Helper.GetNenndoKisanbi(nextYear - 1);
DateTime lastNenndoKimatsubi = helper.Helper.GetNenndoKimatsubi(lastNenndoKisanbi);
misc.WaitCursorController.Begin();
// DBバックアップ作成
{
helper.DBBackup.MakeDBBackup(
Context.KaikeiDatabase.DBFilePath,
"kurikoshi_" +
helper.Converter.DateTimeToWarekiGengou(lastNenndoKisanbi) +
helper.Converter.DateTimeToWarekiYear(lastNenndoKisanbi));
}
// 繰越処理
foreach (var kaikeiKubunRow in Context.KaikeiDatabase.MTKaikeiKubun.Select(""))
{
int kaikeiKubunId = kaikeiKubunRow.GetId();
if (Context.KaikeiDatabase.MTKaikeiKubun.SelectChildren(kaikeiKubunId).Count() > 0)
{
continue;
}
Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.ConstructZenkiKurikoshi(kaikeiKubunId, nextYear);
models.query.BalanceSheet balance = new models.query.BalanceSheet(Context.KaikeiDatabase);
balance.Calc(lastNenndoKisanbi, lastNenndoKimatsubi, kaikeiKubunId, hideInnerKaikeiKubunKamoku: false);
models.query.ShikinSyuushi shikinSyuushi = new models.query.ShikinSyuushi(Context.KaikeiDatabase);
shikinSyuushi.Calc(lastNenndoKisanbi, lastNenndoKimatsubi, kaikeiKubunId, 0, hideInnerKaikeiKubunKamoku: true, targetKamokuKubunHierarchy: models.constants.MTKamokuKubunHierarchy.ChuuKubun, omitZeroRow: false);
models.query.KamokuKubunSummary summary = new models.query.KamokuKubunSummary(Context.KaikeiDatabase);
summary.Calc(lastNenndoKisanbi, lastNenndoKimatsubi, kaikeiKubunId, addKurikoshi: true, addPairedShikinDenpyou: false);
string sql = string.Format("where kaikei_kubun_id={0} and nenndo={1}", kaikeiKubunId, nextYear);
foreach (var kurikoshiRow in Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.Select(sql))
{
kurikoshiRow.Set("zenki_kurikoshi_gaku", 0);
Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.Update(kurikoshiRow);
long taisyaku = 0;
int kamokuKubunId = (int)kurikoshiRow.GetLong("kamoku_kubun_id", -1);
if (kamokuKubunId == (int)models.constants.MTKamokuKubun.JikiKurikoshikatsudouZougenSagakuChukubun)
{
taisyaku = balance.GetSummaryItem(models.query.BalanceSheet.SummaryItem.JikiKurikoshiSagaku).CurrentSumAmount;
}
else if (kamokuKubunId == (int)models.constants.MTKamokuKubun.ZenkimatsuShiharaiShikinZandaka)
{
taisyaku = shikinSyuushi.SummaryRows[(int)models.query.ShikinSyuushi.SummaryItem.ToukiZandaka].Taisyaku;
}
else
{
var row = summary.SummaryItem(kamokuKubunId);
if (row != null)
{
taisyaku = row.GetTaisyaku(Context.KaikeiDatabase);
}
}
if (taisyaku == 0)
{
continue;
}
kurikoshiRow.Set("zenki_kurikoshi_gaku", taisyaku);
Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.Update(kurikoshiRow);
var kamokuKubunRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(kamokuKubunId);
if ((int)kamokuKubunRow.GetLong("hierarchy", -1) == (int)models.constants.MTKamokuKubunHierarchy.ChuuKubun)
{
var daikubunRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById((int)kamokuKubunRow.GetLong("parent_id", -1));
if (daikubunRow != null)
{
string sql2 = string.Format("{0} and kamoku_kubun_id={1}", sql, daikubunRow.GetId());
var daikubunKurikoshiRow = Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.GetFirstRow(sql2);
daikubunKurikoshiRow.Set("zenki_kurikoshi_gaku", taisyaku + daikubunKurikoshiRow.GetLong("zenki_kurikoshi_gaku", 0));
Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.Update(daikubunKurikoshiRow);
}
}
}
}
//過去のデータの削除
{
string sql = string.Format(
"delete from {0} where kihyoubi < {1} ",
Context.KaikeiDatabase.KaikeiDenpyouMeisai.TableName,
helper.Converter.DateTimeToInt(lastNenndoKisanbi));
Context.KaikeiDatabase.ExecuteNonQuery(sql);
sql = string.Format(
"delete from {0} where nenndo < {1}",
Context.KaikeiDatabase.ZenkiKurikoshiKamokuKubun.TableName,
lastNenndoKisanbi.Year - 1);
Context.KaikeiDatabase.ExecuteNonQuery(sql);
}
//起算日を変更
{
DateTime nextKisanbi = helper.Helper.GetNenndoKisanbi(nextYear);
Context.Setting.SetDateTime("nenndo_kisanbi", nextKisanbi);
Context.Setting.SetStr("before_gengou", helper.Converter.DateTimeToWarekiGengou(nextKisanbi));
Context.Setting.SetStr("before_year", helper.Converter.DateTimeToWarekiYear(nextKisanbi).ToString());
Context.Setting.SetStr("before_month", nextKisanbi.Month.ToString());
Context.Setting.SetStr("before_day", nextKisanbi.Day.ToString());
}
misc.WaitCursorController.EndWithSuccessMsg();
}
private void CalcButtonClicked()
{
if (form.StartDate == null || form.EndDate == null)
{
helper.MsgBox.Err(KaikeiSystemBody.Properties.Resources.MsgInvalidDate);
return;
}
form.ClearGrid();
balanceSheet.Calc(form.StartDate.Value, form.EndDate.Value, form.KaikeiKubun, hideInnerKaikeiKubunKamoku: true);
int year = helper.Converter.GetNenndo(form.StartDate.Value);
foreach (var row in balanceSheet.AllKamokuSummary())
{
int kamokuId = row.Id;
models.db.Row kamokuKubunRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowFromCache(kamokuId);
models.db.Row daikubunRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowFromCache((int)kamokuKubunRow.GetLong("parent_id", -1));
string daikubunStr = daikubunRow != null?daikubunRow.GetStr("name", "") : "";
if (row.TaisyakuKamokuKubunId == (int)models.constants.MTKamokuKubun.Shisan)
{
form.AddShisanGridRow(
daikubunStr,
kamokuKubunRow.GetStr("name", ""),
row.CurrentSumAmount,
row.LastSumAmount,
row.Sai
);
}
if (row.TaisyakuKamokuKubunId == (int)models.constants.MTKamokuKubun.Husai)
{
form.AddHusaiGridRow(
daikubunStr,
kamokuKubunRow.GetStr("name", ""),
row.CurrentSumAmount,
row.LastSumAmount,
row.Sai
);
}
if (row.TaisyakuKamokuKubunId == (int)models.constants.MTKamokuKubun.Junshisan)
{
form.AddJunshisanGridRow(
daikubunStr,
kamokuKubunRow.GetStr("name", ""),
row.CurrentSumAmount,
row.LastSumAmount,
row.Sai
);
}
}
foreach (models.query.BalanceSheet.SummaryItem item in Enum.GetValues(typeof(models.query.BalanceSheet.SummaryItem)))
{
models.query.BalanceSheet.BalanceSheetRow row = balanceSheet.GetSummaryItem(item);
form.SetSummaryItem(item, row.CurrentSumAmount, row.LastSumAmount, row.Sai);
}
helper.MsgBox.Info(KaikeiSystemBody.Properties.Resources.MsgSucceeded);
}