public YosanList(KaikeiDatabase db)
: base(db)
{
ownerDB = db;
base.AddColumn("nenndo", ColumnType.TypeInt, "");
base.AddColumn("keiri_kubun", ColumnType.TypeInt, "");
base.AddColumn("yosan_kubun", ColumnType.TypeInt, "");
base.AddColumn("hosei_kaisuu", ColumnType.TypeInt, "");
}
public UsableYosanDaikubun(KaikeiDatabase db) : base(db)
{
ownerDB = db;
// 予算大区分テーブルのカラムをコピー
for (int i = 0; i < db.YosanKamokuKubun.ColumnList.Count; i++)
{
var col = db.YosanKamokuKubun.ColumnList[i];
if (col.Name == "id")
{
continue;
}
base.AddColumn(col.Name, col.Type, col.Option);
}
base.AddColumn("parent_kamoku_kubun_id", ColumnType.TypeInt, "");
}
public UsableYosanKamoku(KaikeiDatabase db) : base(db)
{
ownerDB = db;
// 予算科目テーブルのカラムをコピー
for (int i = 0; i < db.YosanKamoku.ColumnList.Count; i++)
{
var col = db.YosanKamoku.ColumnList[i];
if (col.Name == "id")
{
continue;
}
base.AddColumn(col.Name, col.Type, col.Option);
}
base.AddColumn("kamoku_code", ColumnType.TypeString, "");
}
public BufferedYosanKamokuKubun(KaikeiDatabase db)
: base(db)
{
ownerDB = db;
// 予算科目区分テーブルのカラムをコピー
for (int i = 0; i < db.YosanKamokuKubun.ColumnList.Count; i++)
{
var col = db.YosanKamokuKubun.ColumnList[i];
if (col.Name == "id")
{
continue;
}
base.AddColumn(col.Name, col.Type, col.Option);
ParentId = -1;
}
}
private void AddNewKurikoshiRow(int kaikeiKubun, int nenndo, int kamokuKubunId)
{
KaikeiDatabase db = OwnerDB as KaikeiDatabase;
string sql = string.Format(
"where nenndo={0} and kaikei_kubun_id={1} and kamoku_kubun_id={2}",
nenndo, kaikeiKubun, kamokuKubunId
);
var row = db.ZenkiKurikoshiKamokuKubun.GetFirstRow(sql);
if (row == null)
{
var newRow = db.ZenkiKurikoshiKamokuKubun.NewRow();
newRow.Set("kaikei_kubun_id", kaikeiKubun);
newRow.Set("kamoku_kubun_id", kamokuKubunId);
newRow.Set("nenndo", nenndo);
newRow.Set("zenki_kurikoshi_gaku", 0);
newRow.Set("taisyaku_kubun_id", -1); // 表示時にmt_kanjou_kamokuからデータを取り出すように変更（貸借区分は変更される可能性があるため）
db.ZenkiKurikoshiKamokuKubun.Insert(newRow);
}
}
public BufferedZenkiKurikoshiKamokuKubun(KaikeiDatabase db)
: base(db)
{
ownerDB = db;
// 前期繰越科目区分テーブルのカラムをコピー
for (int i = 0; i < db.ZenkiKurikoshiKamokuKubun.ColumnList.Count; i++)
{
var col = db.ZenkiKurikoshiKamokuKubun.ColumnList[i];
if (col.Name == "id")
{
continue;
}
base.AddColumn(col.Name, col.Type, col.Option);
KamokuKubunParentId = -1;
}
WithoutJikiKurikoshi = false;
}
public BufferedMTKanjouKamoku(KaikeiDatabase db)
: base(db)
{
ownerDB = db;
// 勘定科目テーブルのカラムをコピー
for (int i = 0; i < db.MTKanjouKamoku.ColumnList.Count; i++)
{
var col = db.MTKanjouKamoku.ColumnList[i];
if (col.Name == "id")
{
continue;
}
base.AddColumn(col.Name, col.Type, col.Option);
RootId = -1;
}
base.AddColumn("jigyou_kamoku_kubun", ColumnType.TypeString, "");
base.AddColumn("taisyaku_kamoku_kubun", ColumnType.TypeString, "");
base.AddColumn("shikin_kamoku_kubun", ColumnType.TypeString, "");
}
public void ConstructZenkiKurikoshi(int kaikeiKubunId, int year)
{
KaikeiDatabase db = OwnerDB as KaikeiDatabase;
db.BeginTransaction();
int rootId = (int)models.constants.MTKamokuKubun.TaisyakuRoot;
foreach (var kubunRow in db.MTKamokuKubun.Select("where parent_id = " + rootId + " order by display_order"))
{
int kubunId = (int)kubunRow.GetId();
foreach (var daikubunRow in db.MTKamokuKubun.Select("where parent_id = " + kubunId + " order by display_order"))
{
int daikubunId = (int)daikubunRow.GetId();
AddNewKurikoshiRow(kaikeiKubunId, year, daikubunId);
foreach (var chukubunRow in db.MTKamokuKubun.Select("where parent_id = " + daikubunId + " order by display_order"))
{
int chukubunId = (int)chukubunRow.GetId();
AddNewKurikoshiRow(kaikeiKubunId, year, chukubunId);
foreach (var syoukubunRow in db.MTKamokuKubun.Select("where parent_id = " + chukubunId + " order by display_order"))
{
int syoukubunId = (int)syoukubunRow.GetId();
AddNewKurikoshiRow(kaikeiKubunId, year, syoukubunId);
foreach (var hojoRow in db.MTKamokuKubun.Select("where parent_id = " + syoukubunId + " order by display_order"))
{
int hojoId = (int)hojoRow.GetId();
AddNewKurikoshiRow(kaikeiKubunId, year, hojoId);
}
}
}
}
}
// 前期末支払資金残高
AddNewZenkimatsuShiharaiShikinZandaka(kaikeiKubunId, year);
db.CommitTransaction();
}
