private void PrintYosanJissekiTaihi3Column(models.db.KaikeiDatabase db, int currentYear, int lastYear, int hoseiKaisuu, int kaikeiKubun, DateTime?printDate)
{
string houjinMei = "";
houjinMei = db.MTKaikeiKubun.GetRowFromCache(db.MTKaikeiKubun.RootNodeId).GetStr("name") as string;
var yosanUchiwake = new models.query.YosanUchiwake();
yosanUchiwake.Calc(db, currentYear, lastYear, hoseiKaisuu, kaikeiKubun, withJisseki: true, withSyoukubun: false, withHojoKamoku: false);
var report = new views.reports.SyuushiYosanJissekiReport();
report.OmitZeroRow = form.OmitZeroRow;
report.SetDB(db);
report.SetHeader(houjinMei, new DateTime(currentYear, 4, 1), new DateTime(currentYear + 1, 3, 31));
for (int i = 0; i < yosanUchiwake.ChildKaikeiKubunNameList.Count; i++)
{
report.SetKaikeiKubunCaption(i, yosanUchiwake.ChildKaikeiKubunNameList[i]);
}
var popup = new views.popup.ReportPreviewPopup();
report.DataSource = yosanUchiwake.YosanUchiwakeRowList;
report.Run();
popup.Document = report.Document;
popup.ShowDialog();
}
private void PrintYosanUchiwake(int currentYear, int lastYear, int hoseiKaisuu, int kaikeiKubun, DateTime?printDate)
{
string houjinMei = "";
houjinMei = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId).GetStr("name") as string;
var yosanUchiwake = new models.query.YosanUchiwake();
yosanUchiwake.Calc(Context.KaikeiDatabase, currentYear, lastYear, hoseiKaisuu, kaikeiKubun, withJisseki: false, withSyoukubun: true, withHojoKamoku: false);
var report = new views.reports.SyuushiYosanUchiwakeReport();
report.SetDB(Context.KaikeiDatabase);
report.SetHeader(houjinMei, new DateTime(currentYear, 4, 1), new DateTime(currentYear + 1, 3, 31));
for (int i = 0; i < yosanUchiwake.ChildKaikeiKubunNameList.Count; i++)
{
report.SetKaikeiKubunCaption(i, yosanUchiwake.ChildKaikeiKubunNameList[i]);
}
for (int colCt = 0; colCt < yosanUchiwake.KaikeiKubunList.Count; colCt++)
{
report.SetYobihi(colCt, yosanUchiwake.YosanTable.GetYobihiRow(yosanUchiwake.KaikeiKubunList[colCt]).YosanHonnenDisplay);
report.SetZandaka(colCt, yosanUchiwake.YosanTable.GetZenkimatsuZandakaRow(yosanUchiwake.KaikeiKubunList[colCt]).YosanHonnenDisplay);
}
var popup = new views.popup.ReportPreviewPopup();
report.DataSource = yosanUchiwake.YosanUchiwakeRowList;
report.Run();
popup.Document = report.Document;
popup.ShowDialog();
}
private void PrintHoseiYosan(int currentYear, int lastYear, int hoseiKaisuu, int kaikeiKubun, DateTime?printDate)
{
string shisetsuMei = "";
string houjinMei = "";
if (kaikeiKubun != -1 && kaikeiKubun != Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId)
{
shisetsuMei = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(kaikeiKubun).GetStr("name") as string;
}
houjinMei = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId).GetStr("name") as string;
var hoseiYosanTable = new models.query.HoseiYosan(Context.KaikeiDatabase, currentYear, lastYear, hoseiKaisuu);
hoseiYosanTable.Calc(withSyoukubun: true, withHojokamoku: false);
var yobihiRow = hoseiYosanTable.GetYobihiRow(kaikeiKubun);
var zandakaRow = hoseiYosanTable.GetZenkimatsuZandakaRow(kaikeiKubun);
var popup = new views.popup.ReportPreviewPopup();
var report = new views.reports.SyuushiYosanReport();
report.OmitZeroRow = form.OmitZeroRow;
report.SetDB(Context.KaikeiDatabase);
report.SetHeader(currentYear, houjinMei, shisetsuMei, printDate, true, hoseiKaisuu);
report.SetFooter(yobihiRow.YosanHonnenDisplay, yobihiRow.YosanZennenDisplay, zandakaRow.YosanHonnenDisplay, zandakaRow.YosanZennenDisplay);
report.DataSource = hoseiYosanTable.GetHoseiYosanList(kaikeiKubun);
report.Run();
popup.Document = report.Document;
popup.ShowDialog();
}
private void PrintButtonClicked()
{
if (!CheckParameters())
{
return;
}
yosanJisseki.Calc(form.Year, form.HoseiKaisuu, form.KaikeiKubun);
string houjinMeisyou = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId).GetStr("name");
string kaikeiKubunName = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(form.KaikeiKubun).GetStr("name");
var report = new views.reports.YosanJissekiReport();
report.SetDB(Context.KaikeiDatabase);
report.SetHeader(form.YearWarekiGengou, form.YearWareki, form.HoseiKaisuu, houjinMeisyou, kaikeiKubunName);
report.SetReportFooter(
yosanJisseki.SyuunyuuGoukeiRow.Yosan, yosanJisseki.SyuunyuuGoukeiRow.Jisseki,
yosanJisseki.ShisyutsuGoukeiRow.Yosan, yosanJisseki.ShisyutsuGoukeiRow.Jisseki,
yosanJisseki.SyuushiGoukeiRow.Yosan, yosanJisseki.SyuushiGoukeiRow.Jisseki);
report.DataSource = yosanJisseki.GetYosanJissekiRowList();
report.Run();
var popup = new views.popup.ReportPreviewPopup();
popup.Document = report.Document;
popup.ShowDialog();
}
private void PrintButtonClicked()
{
if (!CheckParameter())
{
return;
}
// 伝票番号を振りなおす
if (popup.DenpyouSeiriChecked)
{
context.KaikeiDatabase.KaikeiDenpyouMeisai.RenumberDenpyouBangouRange(popup.StartDate.Value, popup.EndDate.Value);
}
DataDynamics.ActiveReports.ActiveReport report = new DataDynamics.ActiveReports.ActiveReport();
if (popup.TargetKamokuType == views.popup.KanjouMototyouPrinntPopup.TargetKamokuTypeEnum.Selected)
{
int kanjouKamokuId = kamokuCode2KanjouKamokuId(popup.TargetKamokuCode);
if (popup.DontPrintKanjouMototyouChecked == false)
{
AddMototyouReport(report, kanjouKamokuId, -1, isHojoKamoku: false);
}
if (popup.PrintHojoMototyouChecked)
{
int hojoKamokuId = hojoSeiri2KanjouKamokuId(popup.TargetHojoKamokuSeiri, kanjouKamokuId);
AddMototyouReport(report, hojoKamokuId, kanjouKamokuId, isHojoKamoku: true);
}
}
else
{
string sql = "where usable <> 0 and hierarchy=" + (int)models.constants.MTKanjouKamokuHierarchy.ChuuKubun;
if (popup.TargetKamokuType == views.popup.KanjouMototyouPrinntPopup.TargetKamokuTypeEnum.Range)
{
sql += " and kamoku_code >= '" + popup.KamokuTopCode + "'" +
"and kamoku_code <= '" + popup.KamokuBottomCode + "'";
}
sql += " order by kamoku_code";
foreach (var kanjouKamokuRow in context.KaikeiDatabase.MTKanjouKamoku.Select(sql))
{
AddMototyouReport(report, kanjouKamokuRow.GetId(), -1, isHojoKamoku: false);
}
}
var reportPopup = new views.popup.ReportPreviewPopup();
reportPopup.Document = report.Document;
reportPopup.ShowDialog();
}
private void PrintButtonClicked()
{
// パラメータチェック
var masterBits = views.PrintMainForm.PrintTarget.MTKanjouKamoku | views.PrintMainForm.PrintTarget.MTTekiyou;
if ((form.SelectedPrintTarget | masterBits) == masterBits)
{
// マスターのみ印刷時はパラメータチェックしない
}
else if (form.StartDate == null || form.EndDate == null)
{
helper.MsgBox.Err(KaikeiSystemBody.Properties.Resources.MsgInvalidDate);
return;
}
DataDynamics.ActiveReports.ActiveReport report = new DataDynamics.ActiveReports.ActiveReport();
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.ShiwakeDenpyou) != 0)
{
PrintShiwakeDenpyou(report, views.PrintMainForm.PrintTarget.ShiwakeDenpyou);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.ShiwakeNikki) != 0)
{
PrintShiwakeDenpyou(report, views.PrintMainForm.PrintTarget.ShiwakeNikki);
}
// マスタ
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.MTKanjouKamoku) != 0)
{
AddMasterKanjouKamoku(report);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.MTTekiyou) != 0)
{
AddMasterTekiyou(report);
}
// 決算書類
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanHyoushi) != 0)
{
AddKessanHoukokusyoHyoushi(report);
}
//資金収支計算書
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanShikinKeisan) != 0)
{
AddKessanShikinKeisanReport(report);
}
//資金収支内訳表
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanShikinUchiwake) != 0)
{
AddKessanShikinUchiwakeRepoert(report);
}
//事業活動計算書
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanJigyouKeisan) != 0)
{
AddKessanJigyouKatsudouReport(report);
}
//事業活動内訳表
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanJigyouUchiwake) != 0)
{
AddKessanJigyouUchiwakeReport(report);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanGoukeiZandakaChukubunOnly) != 0)
{
AddKessanGoukeiZandakaReport(report, chukubunOnly: true);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanGoukeiZandakaWithHojokamoku) != 0)
{
AddKessanGoukeiZandakaReport(report, chukubunOnly: false);
}
//貸借対象表
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KessanBalanceSheet) != 0)
{
AddKessanBalanceSheetReport(report);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.KoteiShisanMeisai) != 0)
{
AddKoteiShisanMeisaiReport(report);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.HikiatekinMeisai) != 0)
{
AddHikiatekinMeisaiReport(report);
}
if ((form.SelectedPrintTarget & views.PrintMainForm.PrintTarget.Tyuuki) != 0)
{
AddTyuukiReport(report);
}
if (report.Document.Pages.Count > 0)
{
var reportPopup = new views.popup.ReportPreviewPopup();
reportPopup.Document = report.Document;
reportPopup.ShowDialog();
}
}
