// 科目区分 (親区分は表示しない)
public void InitRowsWithMTKamokuKubunWithoutParent(models.db.mtables.MTKamokuKubun table, int hierarchy, string orderBy = "display_order")
{
this.ClearRows();
this.InitColumns(2, 0, 1);
this.SetColumnVisibility(0, false);
foreach (var parentRow in table.Select("where hierarchy = " + (hierarchy - 1) + " order by " + orderBy))
{
foreach (var row in table.Select("where parent_id = " + parentRow.GetLong("id", -1) + " order by " + orderBy))
{
this.AddRow(row.GetLong("id", -1), row.GetStr("name", ""));
}
}
this.AdjustDropDownWidth();
bindedTable = table;
}
public void InitRowsWithTaisyakuKanjouKamoku(models.db.mtables.MTKanjouKamoku table, models.db.mtables.MTKamokuKubun kamokuKubun, string orderBy = "kamoku_code")
{
this.ClearRows();
this.InitColumns(4, 3, 0);
this.SetColumnVisibility(3, false);
string sql = string.Format(
"where hierarchy = {0} and taisyaku_kamoku_kubun_id <> -1 order by {1}",
(int)models.constants.MTKanjouKamokuHierarchy.ChuuKubun,
orderBy
);
foreach (var row in table.Select(sql))
{
string daikubunStr = "";
models.db.Row kubunRow = kamokuKubun.GetFirstRow("where id = " + row.GetLong("taisyaku_kamoku_kubun_id", -1));
if (kubunRow == null)
{
continue;
}
models.db.Row daikubunRow = kamokuKubun.GetFirstRow("where id = " + kubunRow.GetLong("parent_id", -1));
if (daikubunRow != null)
{
if ((int)daikubunRow.GetLong("id", -1) == (int)models.constants.MTKamokuKubun.JikiKurikoshikatsudouZougenSagakuDaikubun)
{
continue;
}
daikubunStr = daikubunRow.GetStr("name", "");
}
this.AddRow(row.GetStr("kamoku_code", "00000"), daikubunStr, row.GetStr("kamoku", ""), row.GetLong("id", 0));
}
this.AdjustDropDownWidth();
bindedTable = table;
}
public void InitRowsWithMTKanjouKamokuFilterByDaikubun(models.db.mtables.MTKanjouKamoku table, models.db.mtables.MTKamokuKubun kubunTable, int daikubunId, string kubunColName, string orderBy = "kamoku_code")
{
this.ClearRows();
this.InitColumns(4, 3, 0);
this.SetColumnVisibility(3, false);
string daikubunStr = "";
string sql = string.Format(
" as a left join {0} as kubun1 on a.{3} = kubun1.id" +
" left join {0} as kubun2 on kubun1.parent_id = kubun2.id where kubun2.id = {1} order by {2}",
kubunTable.TableName,
daikubunId,
orderBy,
kubunColName
);
daikubunStr = kubunTable.GetFirst("name", "where id = " + daikubunId) as string;
if (daikubunStr == null)
{
daikubunStr = "";
}
foreach (var row in table.Select(sql))
{
this.AddRow(row.GetStr("kamoku_code", "00000"), daikubunStr, row.GetStr("kamoku", ""), row.GetLong("id", 0));
}
this.AdjustDropDownWidth();
bindedTable = table;
}