private void ReadTyuukiTanpo(int tyuukiId)
{
foreach (var row in db.Tyuuki8.Select("where tyuuki_id=" + tyuukiId))
{
string name = "";
models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById((int)row.GetLong("kamoku_kubun_id", -1));
if (kamokuKubunRow != null)
{
name += kamokuKubunRow.GetStr("name");
models.db.Row parent = db.MTKamokuKubun.GetParentOf(kamokuKubunRow);
if (parent != null)
{
if (parent.GetId() == (int)models.constants.MTKamokuKubun.KoteiShisanKihonZaisan)
{
name += "（基本財産）";
}
if (parent.GetId() == (int)models.constants.MTKamokuKubun.KoteiShisanSonota)
{
name += "（その他の固定資産）";
}
}
}
TanpoRow tanpoRow = new TanpoRow((int)row.GetLong("tanpo_kubun_id", -1), name, row.GetLong("amount", 0));
tanpoKubunRows.Add(tanpoRow);
}
}
private void InitTableAddRow(models.db.Row kamokuKubunRow)
{
int kamokuKubunId = kamokuKubunRow.GetId();
int parentId = (int)kamokuKubunRow.GetLong("parent_id", -1);
string parentName;
KoteiShisanType type;
if (parentId == (int)models.constants.MTKamokuKubun.KoteiShisanKihonZaisan)
{
parentName = KaikeiSystemBody.Properties.Resources.CaptionKihonZaisanYuukei;
type = KoteiShisanType.KihonZaisan;
}
else if (models.KoteiShisanFunc.IsSonotaYuukeiKoteiShisan(kamokuKubunId))
{
parentName = Properties.Resources.CaptionSonotaKoteishisanYuukei;
type = KoteiShisanType.SonotaYuukei;
}
else
{
parentName = Properties.Resources.CaptionSonotaKoteishisanMukei;
type = KoteiShisanType.SonotaMukei;
}
MeisaiRow row = new MeisaiRow(kamokuKubunRow.GetStr("name"), parentName, type);
meisaiTable.Add(kamokuKubunRow.GetId(), row);
meisaiList.Add(row);
}
private void AddKamokuRow(models.db.Row daikubunRow, models.db.Row kamokuKubunRow, int groupId)
{
int kamokuKubunId = (int)kamokuKubunRow.GetId();
models.db.Row kanjouKamokuRow = db.MTKanjouKamoku.GetFirstRow("where id=" + kamokuKubunRow.GetLong("kanjou_kamoku_id", -1));
if (kanjouKamokuRow == null)
{
return;
}
if (kanjouKamokuRow.GetBool("usable", false) == false)
{
return;
}
int taisyakuKubunId = (int)kanjouKamokuRow.GetLong("taisyaku_kubun_id", -1);
if ((taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KariPlus || taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KariMinus) &&
groupId == GroupIdSyuunyuu)
{
return;
}
if ((taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KashiPlus || taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KashiMinus) &&
groupId == GroupIdShisyutsu)
{
return;
}
if (kanjouKamokuHash.ContainsKey(kanjouKamokuRow.GetId()))
{
return;
}
kanjouKamokuHash.Add(kanjouKamokuRow.GetId(), true);
ShisanRow shisanRow = new ShisanRow();
shisanRow.GroupId = groupId;
shisanRow.KanjouKamokuId = kanjouKamokuRow.GetId();
//shisanRow.KamokuKubunId = kamokuRow.GetId();
shisanRow.DaikubunId = daikubunRow.GetId();
shisanRow.TaisyakuKubun = taisyakuKubunId;
shisanRow.IsShikinKamoku = (kanjouKamokuRow.GetLong("shikin_kamoku_kubun_id", -1) != -1) || (kanjouKamokuRow.GetLong("taisyaku_kamoku_kubun_id", -1) != -1);
shisanRow.IsJigyouKamoku = kanjouKamokuRow.GetLong("jigyou_kamoku_kubun_id", -1) != -1 || (kanjouKamokuRow.GetLong("taisyaku_kamoku_kubun_id", -1) != -1);
shisanRow.KanjouKamokuHierarchy = (int)kanjouKamokuRow.GetLong("hierarchy", -1);
RowList.Add(shisanRow);
if (kamokuKubunId == (int)models.constants.MTKamokuKubun.JikiKurikoshikatsudouZougenSagakuChukubun)
{
jikiKurikoshiIndex = RowList.Count - 1;
}
}
private void DetailRowDeleteButtonClicked()
{
if (bufferedHojoKamokuTable.RowCount("") > 0)
{
helper.MsgBox.Err(KaikeiSystemBody.Properties.Resources.MsgDeleteHojoKamoku);
return;
}
var res = System.Windows.Forms.MessageBox.Show(KaikeiSystemBody.Properties.Resources.MsgConfirmToDeleteRow,
KaikeiSystemBody.Properties.Resources.CaptionConfirm,
System.Windows.Forms.MessageBoxButtons.OKCancel,
System.Windows.Forms.MessageBoxIcon.Warning);
if (res == System.Windows.Forms.DialogResult.OK)
{
if (Context.KaikeiDatabase.KaikeiDenpyouMeisai.IsUsedKanjouKamoku(kanjouKamokuRow.GetId()))
{
helper.MsgBox.Err(Properties.Resources.MsgUsedKamokuCanNotDelete);
}
else if (bufferedKanjouKamokuTable.Delete(kanjouKamokuRow))
{
}
else
{
helper.MsgBox.ShowMsg("DB error", "err");
}
popup.Close();
}
}
public void Calc(int nenndo, int kaikeiKubun)
{
KaikeiKubun = kaikeiKubun == -1 ? db.MTKaikeiKubun.RootNodeId : kaikeiKubun;
Nenndo = nenndo;
GenkaSyoukyakuRuikeiGaku = 0;
TyousyuuHunouKin = 0;
Tyuuki2 = "";
Tyuuki6 = "";
Tyuuki1Rows = new List <BalanceSheetTyuuki1Row>();
Tyuuki3Rows = new List <BalanceSheetTyuuki3Row>();
Tyuuki4Rows = new List <BalanceSheetTyuuki4Row>();
Tyuuki5Rows = new List <BalanceSheetTyuuki5Row>();
models.db.Row row = db.TaisyakuTaisyouhyouTyuuki.GetFirstRow("where nenndo=" + Nenndo);
if (row != null)
{
tyuukiId = row.GetId();
Tyuuki2 = row.GetStr("juuyou_henkou");
Tyuuki6 = row.GetStr("juuyou_kouhatsu");
CalcKyakutyuu();
CalcTyuuki1();
CalcTyuuki3();
CalcTyuuki4();
CalcTyuuki5();
}
}
public void SetQuery(string query, int targetKaikeiKubunId, bool margeDenpyouGroup)
{
foreach (var row in db.KaikeiDenpyouMeisai.Select(query + " order by denpyou_bangou"))
{
int kaikeiKubunId = (int)row.GetLong("kaikei_kubun", -1);
if (!db.MTKaikeiKubun.IsChildOf(kaikeiKubunId, targetKaikeiKubunId))
{
continue;
}
if (denpyouIdHash.ContainsKey(row.GetId()))
{
continue;
}
if (row.GetLong("parent_meisai_id", -1) != -1)
{
continue;
}
ShiwakeDenpyouRow denpyouRow = new ShiwakeDenpyouRow(db, row);
RowList.Add(denpyouRow);
denpyouIdHash[row.GetId()] = true;
models.db.Row nextRow = row.Table.GetFirstRow("where id = " + row.GetLong("meisai_group_next_id", -1));
if (nextRow == null)
{
continue;
}
if (denpyouIdHash.ContainsKey(nextRow.GetId()))
{
continue;
}
if (margeDenpyouGroup)
{
denpyouRow.SetAddedShiwake(db, nextRow);
denpyouIdHash[nextRow.GetId()] = true;
}
else
{
RowList.Add(new ShiwakeDenpyouRow(db, nextRow));
denpyouIdHash[nextRow.GetId()] = true;
}
}
}
public static bool IsKoteiShisanKanjouKamoku(models.db.KaikeiDatabase db, int kanjouKamokuId)
{
models.db.Row kamokuKubunRow = db.MTKanjouKamoku.GetKamokuKubunRow(kanjouKamokuId, models.constants.MTTorihikiKubun.Shikin);
if (kamokuKubunRow == null)
{
return(false);
}
return(IsKoteiShisanKamokuKubun(db, kamokuKubunRow.GetId()));
}
private SetNenndoResult SearchData(int year, int kaikeiKubun)
{
bool inserted = false;
tyuukiRow = null;
tyuukiId = -1;
form.SetTyuukiRow(tyuukiRow);
if (Context.KaikeiDatabase.MTKaikeiKubun.GetRowById(kaikeiKubun) == null)
{
return(SetNenndoResult.Failed);
}
string sql = "where nenndo=" + year + " and kaikei_kubun_id=" + kaikeiKubun;
var rows = Context.KaikeiDatabase.Tyuuki.Select(sql);
if (rows.Count() == 0)
{
SetInitialData(year, kaikeiKubun);
rows = Context.KaikeiDatabase.Tyuuki.Select(sql);
if (rows.Count() == 0)
{
return(SetNenndoResult.Failed);
}
inserted = true;
}
tyuukiRow = rows.First();
tyuukiId = tyuukiRow.GetId();
form.SetTyuukiRow(tyuukiRow);
string gridSql = "where tyuuki_id=" + tyuukiId;
tyuuki8GridController.SetQuery(gridSql);
tyuuki10GridController.SetQuery(gridSql);
tyuuki11GridController.SetQuery(gridSql);
if (inserted)
{
return(SetNenndoResult.Inserted);
}
else
{
return(SetNenndoResult.Searched);
}
}
public ShiwakeDenpyouRow(models.db.KaikeiDatabase db, models.db.Row row)
{
Id = row.GetId();
DenpyouBangou = row.GetStr("denpyou_bangou", "");
KaikeiKubun = row.GetMasterStr("kaikei_kubun", "name", "", db.MTKaikeiKubun);
TorihikiKubun = row.GetMasterStr("torihiki_kubun", "torihiki_kubun", "", db.MTTorihikiKubun);
Kihyoubi = row.GetDate("kihyoubi");
int torihikiKubunId = (int)row.GetLong("torihiki_kubun", -1);
KarikataKamoku = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_kamoku_id", -1), torihikiKubunId);
KashikataKamoku = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_kamoku_id", -1), torihikiKubunId);
KarikataHojo = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_hojo_id", -1), torihikiKubunId);
KashikataHojo = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_hojo_id", -1), torihikiKubunId);
Tekiyou = row.GetStr("comment");
//Kingaku = helper.Converter.LongToAmount(row.GetLong("karikata_kingaku", 0));
Kingaku = row.GetLong("karikata_kingaku", 0);
KarikataKamokuCode = row.GetStr("karikata_kamoku_code");
int karikataHojoSeiriLong = (int)row.GetLong("karikata_hojo_seiri", 0);
KarikataHojoSeiri = (karikataHojoSeiriLong > 0) ? karikataHojoSeiriLong.ToString() : "";
KashikataKamokuCode = row.GetStr("kashikata_kamoku_code");
int kashikataHojoSeiriLong = (int)row.GetLong("kashikata_hojo_seiri", 0);
KashikataHojoSeiri = (kashikataHojoSeiriLong > 0) ? kashikataHojoSeiriLong.ToString() : "";
KarikataKamoku2 = "";
KashikataKamoku2 = "";
KarikataHojo2 = "";
KashikataHojo2 = "";
KarikataKamoku3 = "";
KashikataKamoku3 = "";
KarikataHojo3 = "";
KashikataHojo3 = "";
KarikataKamoku4 = "";
KashikataKamoku4 = "";
KarikataHojo4 = "";
KashikataHojo4 = "";
}
private void CheckParentKubunYosan(models.db.Row row)
{
int nenndo = Context.Setting.GetDateTime("nenndo_kisanbi").Value.Year;
int parentKaikeiKubun = (int)row.GetLong("parent_id", -1);
int kaikeiKubun = (int)row.GetId();
string sql = "where kaikei_kubun = " + parentKaikeiKubun + " and nenndo = " + nenndo;
int yosanCt = Context.KaikeiDatabase.YosanKamokuKubun.RowCount(sql);
if (yosanCt == 0)
{
return;
}
helper.MsgBox.Warn(KaikeiSystemBody.Properties.Resources.MsgCheckParentKubunYosan);
Context.KaikeiDatabase.BeginTransaction();
foreach (var yosanRow in Context.KaikeiDatabase.YosanKamokuKubun.Select(sql))
{
yosanRow.Set("kaikei_kubun", kaikeiKubun);
Context.KaikeiDatabase.YosanKamokuKubun.Update(yosanRow);
}
Context.KaikeiDatabase.CommitTransaction();
}
// Rowデータの設定
override protected void SetRowDataSub(models.db.Row rowData)
{
models.db.Row kanjouKamokuRow = db.MTKanjouKamoku.GetRowFromKamokuKubun(rowData.GetLong("kamoku_kubun_id", -1));
if (kanjouKamokuRow != null)
{
txtTaisyakuKubun.Text = kanjouKamokuRow.GetMasterStr("taisyaku_kubun_id", "caption", "", db.MTTaisyakuKubun);
}
else
{
txtTaisyakuKubun.Text = "";
models.db.Row childKamokuKubunRow = db.MTKamokuKubun.GetFirstRow("where parent_id=" + rowData.GetLong("kamoku_kubun_id", -1));
if (childKamokuKubunRow != null)
{
models.db.Row childKanjouKamokuRow = db.MTKanjouKamoku.GetRowFromKamokuKubun(childKamokuKubunRow.GetId());
if (childKanjouKamokuRow != null)
{
txtTaisyakuKubun.Text = childKanjouKamokuRow.GetMasterStr("taisyaku_kubun_id", "caption", "", db.MTTaisyakuKubun);
}
}
}
txtKamokuKubun.Text = rowData.GetMasterStr("kamoku_kubun_id", "name", "", db.MTKamokuKubun);
amountKurikoshi.AmountStr = rowData.GetStr("zenki_kurikoshi_gaku");
}