public void InitRowsWithTaisyakuKamoku(models.db.mtables.MTKamoku table, models.db.mtables.MTDaikubun daikubun, string orderBy = "kamoku_code") { this.ClearRows(); this.InitColumns(4, 3, 0); this.SetColumnVisibility(3, false); foreach (var row in table.Select("order by " + orderBy)) { string daikubunStr = ""; var daikubunRow = daikubun.Select("where id = " + row.GetLong("daikubun_id", -1)); if (daikubunRow.Count() > 0) { daikubunStr = daikubunRow.First().GetStr("daikubun"); string daikubunCode = daikubunRow.First().GetStr("daikubun_code"); if (int.Parse(daikubunCode) == (int)models.constants.MTDaikubunCode.JikiKurikoshikatsudouSyuushiSagaku) { continue; } if (daikubunRow.First().GetLong("taisyaku_taisyou_id", 0) <= 0) { continue; } } this.AddRow(row.GetStr("kamoku_code", "00000"), daikubunStr, row.GetStr("kamoku", ""), row.GetLong("id", 0)); } this.AdjustDropDownWidth(); bindedTable = table; }
public void InitRowsWithShisanKamoku(models.db.mtables.MTKamoku table, models.db.mtables.MTDaikubun daikubun) { this.ClearRows(); this.InitColumns(3, 2, 0); this.SetColumnVisibility(2, false); foreach (var row in table.Select("where shiyou_kubun = 0 order by daikubun_id, kamoku_yomi")) { models.db.Row daikubunRow = daikubun.GetRowFromCache((int)row.GetLong("daikubun_id", -1)); if (daikubunRow == null) { continue; } int taisyakuId = (int)daikubunRow.GetLong("taisyaku_taisyou_id", -1); if (taisyakuId != 1) { continue; } if (table.IsRyuudouShisanKamoku((int)row.GetLong("id", -1))) { continue; } this.AddRow(row.GetStr("kamoku", ""), daikubunRow.GetStr("daikubun"), row.GetLong("id", 0)); } this.AdjustDropDownWidth(); bindedTable = table; }
// 科目 (ID, 名称) public void InitRowsWithMTKamokuReverse(models.db.mtables.MTKamoku table, string orderBy = "kamoku_code") { this.ClearRows(); this.InitColumns(2, 0, 0); foreach (var row in table.Select("order by " + orderBy)) { this.AddRow(row.GetStr("kamoku_code", "00000"), row.GetStr("kamoku", "")); } this.AdjustDropDownWidth(); bindedTable = table; }
public void InitRowsWithMTKamokuUsableOnly(models.db.mtables.MTKamoku table, string orderBy = "kamoku_code") { this.ClearRows(); this.InitColumns(2, 1, 0); this.SetColumnVisibility(1, false); foreach (var row in table.Select("where shiyou_kubun = 0 order by " + orderBy)) { this.AddRow(row.GetStr("kamoku", ""), row.GetLong("id", 0)); } this.AdjustDropDownWidth(); bindedTable = table; }
public void InitRowsWithMTKamokuFilterByMTDaikubun2(models.db.mtables.MTKamoku table, models.db.mtables.MTDaikubun daikubun, int daikubunId, string orderBy = "kamoku_code") { this.ClearRows(); this.InitColumns(3, 2, 1); this.SetColumnVisibility(0, false); this.SetColumnVisibility(2, false); foreach (var row in table.Select("where daikubun_id = " + daikubunId + " order by " + orderBy)) { this.AddRow(row.GetStr("kamoku_code", "00000"), row.GetStr("kamoku", ""), row.GetLong("id", 0)); } this.AdjustDropDownWidth(); bindedTable = table; }
public void InitRowsWithMTKamokuFilterByMTDaikubun(models.db.mtables.MTKamoku table, models.db.mtables.MTDaikubun daikubun, int daikubunCode, string orderBy = "kamoku_code") { this.ClearRows(); this.InitColumns(4, 3, 0); this.SetColumnVisibility(3, false); string daikubunStr = ""; int daikubunId = 0; var daikubunRow = daikubun.Select("where daikubun_code = '" + daikubunCode + "'"); if (daikubunRow.Count() > 0) { daikubunStr = daikubunRow.First().GetStr("daikubun"); daikubunId = (int)daikubunRow.First().GetLong("id", 0); } foreach (var row in table.Select("where daikubun_id = " + daikubunId + " order by " + orderBy)) { this.AddRow(row.GetStr("kamoku_code", "00000"), daikubunStr, row.GetStr("kamoku", ""), row.GetLong("id", 0)); } this.AdjustDropDownWidth(); bindedTable = table; }