// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { int year = (int)rowData.GetLong("nenndo", 0); DateTime date = new DateTime(year, 4, 1); lblYear.Text = helper.Converter.DateTimeToWarekiGengouKanji(date) + helper.Converter.DateTimeToWarekiYear(date).ToString() + "年"; lblKeiriKubun.Text = rowData.GetMasterStr("kaikei_kubun", "name", "", db.MTKaikeiKubun); lblYosanKubun.Text = rowData.GetMasterStr("yosan_kubun", "yosan_kubun", "", db.MTYosanKubun); lblHoseiKaisuu.Text = rowData.GetLong("hosei_kaisuu", -1).ToString(); }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { int year = (int)rowData.GetLong("nenndo", 0); DateTime date = new DateTime(year, 4, 1); lblYear.Text = helper.Converter.DateTimeToWarekiGengouKanji(date) + helper.Converter.DateTimeToWarekiYear(date).ToString(); lblKeiriKubun.Text = rowData.GetMasterStr("kaikei_kubun", "name", "", db.MTKaikeiKubun); lblYosanKubun.Text = rowData.GetMasterStr("yosan_kubun", "yosan_kubun", "", db.MTYosanKubun); lblHoseiKaisuu.Text = rowData.GetLong("hosei_kaisuu", -1).ToString(); amountYosan.AmountStr = rowData.GetStr("yobihi"); amountZenkiZandaka.AmountStr = rowData.GetStr("zenkimatsu_shiharai_shikin_zandaka"); }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { models.db.Row kamokuRow = db.MTKanjouKamoku.GetRowFromKamokuKubun(rowData.GetLong("kamoku_kubun_id", -1)); if (kamokuRow != null) { txtKamokuCode.Text = kamokuRow.GetStr("kamoku_code"); } else { txtKamokuCode.Text = ""; } txtKaikeiKubun.Text = rowData.GetMasterStr("kaikei_kubun", "name", "", db.MTKaikeiKubun); txtKamokuKubun.Text = rowData.GetMasterStr("kamoku_kubun_id", "name", "", db.MTKamokuKubun); amountYosan.AmountStr = rowData.GetStr("yosan"); }
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 = ""; }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { int year = (int)rowData.GetLong("nenndo", 0); DateTime date = new DateTime(year, 4, 1); lblYear.Text = helper.Converter.DateTimeToWarekiGengou(date) + helper.Converter.DateTimeToWarekiYear(date).ToString() + "年"; lblKeiriKubun.Text = rowData.GetMasterStr("kaikei_kubun", "name", "", db.MTKaikeiKubun); lblYosanKubun.Text = rowData.GetMasterStr("yosan_kubun", "yosan_kubun", "", db.MTYosanKubun); lblHoseiKaisuu.Text = rowData.GetLong("hosei_kaisuu", -1).ToString(); lblHojoKamoku.Text = rowData.GetMasterStr("kamoku_kubun_id", "name", "", db.MTKamokuKubun); lblYosan.Text = helper.Converter.LongToAmount(rowData.GetLong("yosan", 0)); { models.db.Row kamokuRow = db.MTKamokuKubun.GetRowFromCache((int)rowData.GetLong("kamoku_kubun_id", -1)); if (kamokuRow != null) { lblKamoku.Text = kamokuRow.GetMasterStr("parent_id", "name", "", db.MTKamokuKubun); } } }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { int torihikiKubunId = (int)rowData.GetLong("torihiki_kubun", -1); this.BackColor = Color.White; base.SetRowDataToLabel(lblTsuikaKubun, rowData); lblKaikeiKubun.Text = rowData.GetMasterStr(lblKaikeiKubun.Tag as string, "name", "", db.MTKaikeiKubun); lblTorihikiKubun.Text = rowData.GetMasterStr(lblTorihikiKubun.Tag as string, "name", "", db.MTTorihikiKubun); base.SetRowDataToLabel(lblKashikataKamokuCode, rowData); base.SetRowDataToLabel(lblKashikataHojoSeiri, rowData); base.SetRowDataToLabel(lblKarikataKamokuCode, rowData); base.SetRowDataToLabel(lblKarikataHojoSeiri, rowData); base.SetRowDataToLabelAsAmount(lblKingaku, rowData); base.SetRowDataToLabel(lblTekiyouId, rowData); base.SetRowDataToLabel(lblComment, rowData); base.SetRowDataToCheckBox(chkTouroku, rowData); lblKarikataKamoku.Text = db.MTKanjouKamoku.GetKamokuStr((int)rowData.GetLong("karikata_kamoku_id", -1), torihikiKubunId); lblKashikataKamoku.Text = db.MTKanjouKamoku.GetKamokuStr((int)rowData.GetLong("kashikata_kamoku_id", -1), torihikiKubunId); lblKarikataHojo.Text = db.MTKanjouKamoku.GetKamokuStr((int)rowData.GetLong("karikata_hojo_id", -1), torihikiKubunId); lblKashikataHojo.Text = db.MTKanjouKamoku.GetKamokuStr((int)rowData.GetLong("kashikata_hojo_id", -1), torihikiKubunId); }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { base.SetRowDataToTextBox(txtKamokuCode, rowData); base.SetRowDataToTextBox(txtKamoku, rowData); base.SetRowDataToCheckBox(chkUsable, rowData); base.SetRowDataToCheckBox(chkPrintTarget, rowData); { // parent int kubunId = 0; kubunId = (int)rowData.GetLong("jigyou_kamoku_kubun_id", -1); if (kubunId == -1) { kubunId = (int)rowData.GetLong("shikin_kamoku_kubun_id", -1); } if (kubunId == -1) { kubunId = (int)rowData.GetLong("taisyaku_kamoku_kubun_id", -1); } if (kubunId != -1) { models.db.Row parentKubunRow = db.MTKamokuKubun.GetParentOf(db.MTKamokuKubun.GetRowFromCache(kubunId)); if (parentKubunRow != null) { txtParent.Text = parentKubunRow.GetStr("name"); } else { txtParent.Text = ""; } } else { txtParent.Text = ""; } } txtTaisyakuKubun.Text = rowData.GetMasterStr("taisyaku_kubun_id", "caption", "", db.MTTaisyakuKubun); SetKamokuKubunParentText(txtShikinKamokuKubun, rowData, "shikin_kamoku_kubun_id", (int)models.constants.MTKamokuKubunHierarchy.Kubun); SetKamokuKubunParentText(txtJigyouKamokuKubun, rowData, "jigyou_kamoku_kubun_id", (int)models.constants.MTKamokuKubunHierarchy.Kubun); SetKamokuKubunParentText(txtTaisyakuKamokuKubun, rowData, "taisyaku_kamoku_kubun_id", (int)models.constants.MTKamokuKubunHierarchy.Kubun); }
// 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"); }
// row = nullのときは新規作成 private models.db.Row CreateKanjouKamokuDetailRow(System.Windows.Forms.Form owner, models.db.Row row) { if (row == null) { views.controls.SelectKanjouKamokuDialog dlg = new views.controls.SelectKanjouKamokuDialog(); if (dlg.ShowDialog(owner, Context) != System.Windows.Forms.DialogResult.OK) { return(null); } row = bufferedKanjouKamokuTable.NewRow(); row.Set("parent_id", -1); row.Set("has_child", false); row.Set("parent_shikin_kamoku_kubun_id", dlg.ShikinKamokuKubunId); row.Set("parent_jigyou_kamoku_kubun_id", dlg.JigyouKamokuKubunId); row.Set("parent_taisyaku_kamoku_kubun_id", dlg.TaisyakuKamokuKubunId); row.Set("taisyaku_kubun_id", (int)models.constants.MTTaisyakuKubun.KariMinus); row.Set("usable", true); row.Set("editable", true); row.Set("denpyou_print_target", true); row.Set("hierarchy", (int)models.constants.MTKanjouKamokuHierarchy.ChuuKubun); int kamokuCode = 0; var maxKamokuRows = Context.KaikeiDatabase.MTKanjouKamoku.Select("where parent_id = -1 order by kamoku_code desc limit 1"); if (maxKamokuRows.Count() == 1) { string maxKamokuCodeStr = maxKamokuRows.First().GetStr("kamoku_code"); kamokuCode = helper.Converter.ObjToInt(maxKamokuCodeStr, 0) + 1; } else { kamokuCode = 1; } string kamokuCodeStr = string.Format("{0:D5}", kamokuCode); row.Set("kamoku_code", kamokuCodeStr); bufferedKanjouKamokuTable.Insert(row); row = bufferedKanjouKamokuTable.LastInsertedRow(); } int jigyouKubunId = (int)row.GetLong("jigyou_kamoku_kubun_id", -1); int taisyakuKubunId = (int)row.GetLong("taisyaku_kamoku_kubun_id", -1); int shikinKubunId = (int)row.GetLong("shikin_kamoku_kubun_id", -1); models.db.Row jigyouRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(jigyouKubunId); models.db.Row taisyakuRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(taisyakuKubunId); models.db.Row shikinRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(shikinKubunId); if (jigyouRow != null) { row.Set("parent_jigyou_kamoku_kubun_id", jigyouRow.GetLong("parent_id", -1)); row.Set("parent_jigyou_kamoku_kubun", jigyouRow.GetMasterStr("parent_id", "name", "", Context.KaikeiDatabase.MTKamokuKubun)); } if (taisyakuRow != null) { row.Set("parent_taisyaku_kamoku_kubun_id", taisyakuRow.GetLong("parent_id", -1)); row.Set("parent_taisyaku_kamoku_kubun", taisyakuRow.GetMasterStr("parent_id", "name", "", Context.KaikeiDatabase.MTKamokuKubun)); } if (shikinRow != null) { row.Set("parent_shikin_kamoku_kubun_id", shikinRow.GetLong("parent_id", -1)); row.Set("parent_shikin_kamoku_kubun", shikinRow.GetMasterStr("parent_id", "name", "", Context.KaikeiDatabase.MTKamokuKubun)); } return(row); }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { txtKaikeiKubun.Text = rowData.GetMasterStr("kaikei_kubun", "name", "", db.MTKaikeiKubun); txtKamokuKubun.Text = rowData.GetMasterStr("kamoku_kubun_id", "name", "", db.MTKaikeiKubun); }