private void SummarizeMeisaiTable() { string orderStr = "order by display_order"; foreach (models.db.Row kubunRow in db.MTKamokuKubun.SelectChildren((int)models.constants.MTKamokuKubun.TaisyakuRoot, order: orderStr)) { foreach (models.db.Row daikubunRow in db.MTKamokuKubun.SelectChildren(kubunRow.GetId(), order: orderStr)) { if (daikubunRow.GetId() == (int)models.constants.MTKamokuKubun.JikiKurikoshikatsudouZougenSagakuDaikubun) { continue; } foreach (models.db.Row kamokuRow in db.MTKamokuKubun.SelectChildren(daikubunRow.GetId(), order: orderStr)) { if (HideInnerKaikeiKubunKamoku && db.MTKamokuKubun.IsInnerKaikeiKubunKamoku(KaikeiKubunHierarchy, kamokuRow)) { continue; } BalanceSheetRow balanceSheetRow = new BalanceSheetRow(kamokuRow.GetId(), daikubunRow.GetId(), kubunRow.GetId()); balanceSheetRow.CurrentSumAmount = kamokuKubunSummary.SummaryItem(kamokuRow.GetId()).GetTaisyaku(db); balanceSheetRow.LastSumAmount = 0; kamokuKubunId2BalanceSheetRow.Add(kamokuRow.GetId(), balanceSheetRow); } } } }
public void Calc(DateTime startDate, DateTime endDate, int kaikeiKubun, bool hideInnerKaikeiKubunKamoku) { StartDate = helper.Converter.DateTimeToNenndoKisannbi(startDate); StartNenndo = startDate.Year; EndDate = endDate; KaikeiKubun = kaikeiKubun == -1 ? db.MTKaikeiKubun.RootNodeId : kaikeiKubun; KaikeiKubunHierarchy = (int)db.MTKaikeiKubun.GetHierarchyOf(kaikeiKubun); HideInnerKaikeiKubunKamoku = hideInnerKaikeiKubunKamoku; // init summary items summaryItems.Clear(); foreach (SummaryItem item in Enum.GetValues(typeof(SummaryItem))) { summaryItems[item] = new BalanceSheetRow(0, 0, 0); } kamokuKubunId2BalanceSheetRow.Clear(); kamokuKubunSummary = new KamokuKubunSummary(db); kamokuKubunSummary.Calc(startDate, endDate, kaikeiKubun, addKurikoshi: false, addPairedShikinDenpyou: true); SummarizeMeisaiTable(); SummarizeKurikoshi(); CalcSummary(); }
public void DainyuuAMinusB(BalanceSheetRow a, BalanceSheetRow b) { this.Add(a); this.Substract(b); }
public void Substract(BalanceSheetRow row) { CurrentSumAmount -= row.CurrentSumAmount; LastSumAmount -= row.LastSumAmount; }
public void Add(BalanceSheetRow row) { CurrentSumAmount += row.CurrentSumAmount; LastSumAmount += row.LastSumAmount; }