private JigyouKatsudouUchiwakeRow CreateUchiwakeRow(int daikubunId, int kamokuKubunIndex, int startKaikeiKubun, int endKaikeiKubun) { int kubunId = db.MTKamokuKubun.GetParentOf(daikubunId).GetId(); int kamokuKubunId = jigyouKatsudouList[0].ChildRowsOf[daikubunId][kamokuKubunIndex].Id; var uchiwakeRow = new JigyouKatsudouUchiwakeRow(kubunId, daikubunId, kamokuKubunId); long sum = 0; long naibuTorihikiSyoukyoGaku = 0; for (int kaikeiKubun = 0; kaikeiKubun < jigyouKatsudouList.Count; kaikeiKubun++) { long val = jigyouKatsudouList[kaikeiKubun].ChildRowsOf[daikubunId][kamokuKubunIndex].CurrentYearSum; sum += val; naibuTorihikiSyoukyoGaku -= jigyouKatsudouList[kaikeiKubun].ChildRowsOf[daikubunId][kamokuKubunIndex].NaibuTorihikiSyoukyoGaku; if (kaikeiKubun >= startKaikeiKubun) { uchiwakeRow.SetCol(kaikeiKubun - startKaikeiKubun + (int)StaticCols.NumStaticCols, val); } } uchiwakeRow.SetCol((int)StaticCols.Summary, sum); uchiwakeRow.SetCol((int)StaticCols.NaibuTorihikiSyoukyoGaku, naibuTorihikiSyoukyoGaku); uchiwakeRow.SetCol((int)StaticCols.HoujinSummary, sum + naibuTorihikiSyoukyoGaku); return(uchiwakeRow); }
public JigyouKatsudouUchiwakeRow GetSummaryRow(models.query.JigyouKatsudou.SummaryItem item, int startKaikeiKubun, int endKaikeiKubun) { var uchiwakeRow = new JigyouKatsudouUchiwakeRow(-1, -1, (int)item); long sum = 0; long naibuTorihikiSyoukyoGaku = 0; for (int kaikeiKubun = 0; kaikeiKubun < jigyouKatsudouList.Count; kaikeiKubun++) { long val = jigyouKatsudouList[kaikeiKubun].SummaryRows[(int)item].CurrentYearSum; naibuTorihikiSyoukyoGaku -= jigyouKatsudouList[kaikeiKubun].SummaryRows[(int)item].NaibuTorihikiSyoukyoGaku; sum += val; if (kaikeiKubun >= startKaikeiKubun) { uchiwakeRow.SetCol(kaikeiKubun - startKaikeiKubun + (int)StaticCols.NumStaticCols, val); } } uchiwakeRow.SetCol((int)StaticCols.Summary, sum); uchiwakeRow.SetCol((int)StaticCols.NaibuTorihikiSyoukyoGaku, naibuTorihikiSyoukyoGaku); uchiwakeRow.SetCol((int)StaticCols.HoujinSummary, sum + naibuTorihikiSyoukyoGaku); return(uchiwakeRow); }