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(); } }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { cmbKaikeiKubun.SelectRowByKeyValue(rowData.GetLong("kaikei_kubun", -1)); cmbKamoku.SelectRowByKeyValue(rowData.GetLong("kamoku_id", -1)); txtTekiyou.Text = rowData.GetStr("tekiyou"); txtAmount.AmountStr = rowData.GetStr("amount"); SetKamokuLabel(); }
public KanjouKamokuListRow(models.db.Row daikubunRow, models.db.Row kamokuRow, models.db.KaikeiDatabase db) { models.db.Row kanjouRow = db.MTKanjouKamoku.GetFirstRow("where id=" + kamokuRow.GetStr("kanjou_kamoku_id")); DaikubunCode = daikubunRow.GetStr("name"); DaikubunName = daikubunRow.GetStr("display_order"); KamokuCode = kanjouRow.GetStr("kamoku"); KamokuName = kanjouRow.GetStr("kamoku_code"); Hierarchy = (int)kanjouRow.GetLong("hierarchy", -1); }
// 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"); }
protected void SetRowDataToLabelAsAmount(Label control, models.db.Row rowData) { int amount; if (int.TryParse(rowData.GetStr(control.Tag as string, ""), out amount) == true) { control.Text = helper.Converter.LongToAmount(amount); } else { control.Text = rowData.GetStr(control.Tag as string, ""); } }
private void AddKessanHoukokusyoHyoushi(DataDynamics.ActiveReports.ActiveReport parentReport) { int rootKaikeiKubunId = Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId; models.db.Row rootRow = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(rootKaikeiKubunId); string houjinMei = rootRow.GetStr("name"); string yuubinBangou = rootRow.GetStr("yuubin_bangou"); string juusyo = Context.KaikeiDatabase.MTKaikeiKubun.GetJuusyoStr(rootRow); var report = new views.reports.KessanHoukokusyoHyoushi(); report.SetHeader(form.StartDate.Value, form.EndDate.Value, houjinMei, yuubinBangou, juusyo); report.Run(); parentReport.Document.Pages.AddRange(report.Document.Pages.GetRange(0, report.Document.Pages.Count)); }
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); } }
public void detail_Format(object sender, EventArgs e) { int kamokuKubunId = helper.Converter.ObjToInt(txtKamokuId.Text, -1); models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById(kamokuKubunId); if (kamokuKubunRow == null) { return; } int kanjouKamokuId = (int)kamokuKubunRow.GetLong("kanjou_kamoku_id", -1); models.db.Row kanjouKamokuRow = db.MTKanjouKamoku.GetRowById(kanjouKamokuId); txtKamokuCode.Text = kanjouKamokuRow.GetStr("kamoku_code"); txtKamoku.Text = kanjouKamokuRow.GetStr("kamoku"); }
private void ValidateKihyoubi(models.db.KaikeiDatabase db, models.db.Row row) { form_.HeaderKihyoubiGengouText = row.GetStr("kihyoubi_gengou", ""); form_.HeaderKihyoubiYearText = row.GetStr("kihyoubi_year", ""); form_.HeaderKihyoubiMonthText = row.GetStr("kihyoubi_month", ""); form_.HeaderKihyoubiDayText = row.GetStr("kihyoubi_day", ""); if (!models.Validator.CheckKihyoubiFormatIsValid(db, row)) { gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgInvalidDate, "warn", null); } else if (!models.Validator.CheckKihyoubiIsInNendoKisanbi(db, row)) { gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgKihyoubiOutOfRange, "warn", null); } }
private void AddHikiatekinMeisaiReport(DataDynamics.ActiveReports.ActiveReport parentReport) { DateTime startDate = helper.Helper.GetNenndoKisanbi(form.StartDate.Value); DateTime endDate = helper.Helper.GetNenndoKimatsubi(form.EndDate.Value); models.query.HikiatekinMeisai meisai = new models.query.HikiatekinMeisai(Context.KaikeiDatabase); meisai.Calc(startDate, endDate, form.KaikeiKubun); var report = new views.reports.HikiatekinMeisaiReport(); report.SetDB(Context.KaikeiDatabase); int rootKaikeiKubunId = Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId; models.db.Row rootRow = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(rootKaikeiKubunId); string houjinMei = rootRow.GetStr("name"); string kaikeiKubunName = ""; if (form.KaikeiKubun != rootKaikeiKubunId) { kaikeiKubunName = Context.KaikeiDatabase.MTKaikeiKubun.GetFirst("name", "where id=" + form.KaikeiKubun) as string; } report.SetHeader(startDate, endDate, houjinMei, kaikeiKubunName); report.SetFooter(meisai.SumRow); report.DataSource = meisai.GetMeisaiList(); report.Run(); parentReport.Document.Pages.AddRange(report.Document.Pages.GetRange(0, report.Document.Pages.Count)); }
private void AddKessanShikinUchiwakeReportSub(DataDynamics.ActiveReports.ActiveReport report, views.reports.ShikinSyuushiKessanUchiwakeEngine engine, models.query.ShikinSyuushiUchiwake uchiwake, int startCol, int endCol) { engine.SetDB(Context.KaikeiDatabase); int rootKaikeiKubunId = Context.KaikeiDatabase.MTKaikeiKubun.RootNodeId; models.db.Row rootRow = Context.KaikeiDatabase.MTKaikeiKubun.GetRowFromCache(rootKaikeiKubunId); string houjinMei = rootRow.GetStr("name"); string title = "【拠点区分資金収支明細書】"; string youshiki = "別紙3(⑩)"; if (form.KaikeiKubun == 1) { title = "【資金収支内訳表】"; youshiki = "第一号第二様式"; } else if (form.KaikeiKubun == 2) { title = "【事業区分資金収支内訳表】"; youshiki = "第一号第三様式"; } engine.SetHeader(form.StartDate.Value, form.EndDate.Value, houjinMei, uchiwake.GetColCaptions(startCol, endCol), title, youshiki); engine.SetFooter( uchiwake.GetSummaryRow(models.query.ShikinSyuushi.SummaryItem.ToukiShikin, startCol, endCol), uchiwake.GetSummaryRow(models.query.ShikinSyuushi.SummaryItem.ZenkiZandaka, startCol, endCol), uchiwake.GetSummaryRow(models.query.ShikinSyuushi.SummaryItem.ToukiZandaka, startCol, endCol)); var source = uchiwake.GetRows(startCol, endCol); report.DataSource = source; report.Run(); }
private void DaikubunGridRowSelected(int daikubunId) { form.ClearKamokuGrid(); if (shikinSyuushi.ChildRowsOf.ContainsKey(daikubunId) == false) { return; } foreach (var row in shikinSyuushi.ChildRowsOf[daikubunId]) { int kamokuId = row.Id; models.db.Row kamokuRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById(kamokuId); if (kamokuRow == null) { continue; } form.AddKamokuGridRow( kamokuRow.GetStr("name"), row.Taisyaku ); } }
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 SetGroupHeader(DataDynamics.ActiveReports.TextBox txtId, DataDynamics.ActiveReports.TextBox txtName, DataDynamics.ActiveReports.TextBox txtYosan, DataDynamics.ActiveReports.TextBox txtJisseki, DataDynamics.ActiveReports.TextBox txtSagaku, DataDynamics.ActiveReports.TextBox txtHiritsu, string namePrefix, string nameSuffix) { int kamokuKubunId = helper.Converter.ObjToInt(txtId.Text, -1); long yosan = helper.Converter.AmountToLongObj(txtYosan.Text).Value; long jisseki = helper.Converter.AmountToLongObj(txtJisseki.Text).Value; if (yosan == 0) { txtHiritsu.Text = "0.0"; } else { txtHiritsu.Text = string.Format("{0:0.0}", ((double)jisseki) / ((double)yosan) * 100); } models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById(kamokuKubunId); txtName.Text = namePrefix + kamokuKubunRow.GetStr("name") + nameSuffix; }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { cmbKeiriKubun.SelectRowByKeyValue(rowData.GetLong("keiri_kubun", -1)); cmbKamoku.SelectRowByKeyValue(rowData.GetLong("kamoku_id", 0)); SetKamokuCodeText(); amountYosan.AmountStr = rowData.GetStr("yosan"); }
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; }
/* public YosanJissekiRow(int kamokuId, string kamokuCode, string name, long yosan, long jisseki) { * KamokuId = kamokuId; * KamokuCode = kamokuCode; * Name = name; * YosanDisplay = yosan; * JissekiDisplay = jisseki; * } */ public YosanJissekiRow(int kamokuId, string name, long yosan, long jisseki, models.db.KaikeiDatabase db) { KamokuId = kamokuId; Yosan = yosan; Jisseki = jisseki; Name = name; YosanDaikubun = 0; JissekiDaikubun = 0; YosanKubun = 0; JissekiKubun = 0; models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById(kamokuId); if (kamokuKubunRow != null) { if (name == null) { Name = kamokuKubunRow.GetStr("name"); } models.db.Row kanjouKamokuRow = db.MTKanjouKamoku.GetRowById((int)kamokuKubunRow.GetLong("kanjou_kamoku_id", -1)); if (kanjouKamokuRow != null) { KamokuCode = kanjouKamokuRow.GetStr("kamoku_code"); } else { KamokuCode = ""; } } }
public void SetRowData(models.db.Row row) { inSetRowDataFunction = true; int torihikiKubunId = (int)row.GetLong("torihiki_kubun", -1); txtDenpyouBangou.Text = row.GetStr("denpyou_bangou_cache", ""); txtKihyoubiGengou.Text = row.GetStr("kihyoubi_gengou"); txtKihyoubiYear.Text = row.GetStr("kihyoubi_year"); txtKihyoubiMonth.Text = row.GetStr("kihyoubi_month"); txtKihyoubiDay.Text = row.GetStr("kihyoubi_day"); cmbKarikataKamoku.SelectRowByKeyValue(row.GetStr("karikata_kamoku_code", "")); lblKarikataKamoku.Text = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_kamoku_id", -1), torihikiKubunId); cmbKashikataKamoku.SelectRowByKeyValue(row.GetStr("kashikata_kamoku_code", "")); lblKashikataKamoku.Text = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_kamoku_id", -1), torihikiKubunId); txtKingaku.AmountStr = row.GetStr("karikata_kingaku", ""); txtTekiyouId.Text = row.GetStr("tekiyou_id", ""); txtComment.Text = row.GetStr("comment", ""); checkDenpyouKakunin.Checked = row.GetBool("denpyou_kakunin", false); cmbKaikeiKubun.SelectRowByKeyValue(row.GetLong("kaikei_kubun", -1)); cmbTorihikiKubun.SelectRowByKeyValue(row.GetLong("torihiki_kubun", -1)); cmbKarikataHojo.SelectRowByKeyValue(row.GetLong("karikata_hojo_seiri", 0)); lblKarikataHojo.Text = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_hojo_id", -1), torihikiKubunId); cmbKashikataHojo.SelectRowByKeyValue(row.GetLong("kashikata_hojo_seiri", 0)); lblKashikataHojo.Text = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_hojo_id", -1), torihikiKubunId); bool isBindedShikinDenpyou = db.KaikeiDenpyouMeisai.IsAutoInsertedShikinDenpyouRow(row); txtDenpyouBangou.ReadOnly = isBindedShikinDenpyou; txtKihyoubiGengou.ReadOnly = isBindedShikinDenpyou; txtKihyoubiYear.ReadOnly = isBindedShikinDenpyou; txtKihyoubiMonth.ReadOnly = isBindedShikinDenpyou; txtKihyoubiDay.ReadOnly = isBindedShikinDenpyou; cmbKarikataKamoku.Enabled = !isBindedShikinDenpyou; cmbKashikataKamoku.Enabled = !isBindedShikinDenpyou; txtKingaku.ReadOnly = isBindedShikinDenpyou; txtTekiyouId.ReadOnly = isBindedShikinDenpyou; txtComment.ReadOnly = isBindedShikinDenpyou; checkDenpyouKakunin.Enabled = !isBindedShikinDenpyou; cmbKaikeiKubun.Enabled = !isBindedShikinDenpyou; cmbTorihikiKubun.Enabled = !isBindedShikinDenpyou; cmbKarikataHojo.Enabled = !isBindedShikinDenpyou; cmbKashikataHojo.Enabled = !isBindedShikinDenpyou; btnDelete.Enabled = !isBindedShikinDenpyou; inSetRowDataFunction = false; }
private void shikinSyuushiGroupHeader_Format(object sender, EventArgs e) { models.db.Row row = db.MTKamokuKubun.GetRowFromCache(helper.Converter.ObjToInt(txtShikinSyuushiId.Text, -1)); if (row != null) { txtShikinSyuushi.Text = row.GetStr("name", ""); } }
private void daikubunGroupHeader_Format(object sender, EventArgs e) { models.db.Row row = db.MTKamokuKubun.GetRowFromCache(helper.Converter.ObjToInt(txtDaikubunId.Text, -1)); if (row != null) { txtDaikubun.Text = "【" + row.GetStr("name", "") + "】"; } }
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 SetNenndoResult SetNenndo(int year) { bool inserted = false; var rows = Context.KaikeiDatabase.TaisyakuTaisyouhyouTyuuki.Select("where nenndo=" + year); if (rows.Count() == 0) { SetInitialData(year); rows = Context.KaikeiDatabase.TaisyakuTaisyouhyouTyuuki.Select("where nenndo=" + year); if (rows.Count() == 0) { System.Diagnostics.Debug.Print("貸借対照表注記 登録失敗"); return(SetNenndoResult.Failed); } inserted = true; } models.db.Row row = rows.First(); tyuukiRow = row; tyuukiId = (int)row.GetLong("id", 0); form.JuuyouKaikeiHoushinHenkou = row.GetStr("juuyou_henkou"); form.JuuyouKouhatsuJisyou = row.GetStr("juuyou_kouhatsu"); string sql = "where tyuuki_id=" + tyuukiId; genkaGridController.SetQuery(sql); kaikeiHoushinGridController.SetQuery(sql); zaisanGridController.SetQuery(sql); torikuzushiGridController.SetQuery(sql); tanpoGridController.SetQuery(sql); form.SetCurrentYear(year); if (inserted) { return(SetNenndoResult.Inserted); } else { return(SetNenndoResult.Searched); } }
private void SetTextBoxValue(TextBox txtBox, models.db.Row tyuukiRow) { if (tyuukiRow == null) { txtBox.Text = ""; } else { txtBox.Text = tyuukiRow.GetStr(txtBox.Tag as string); } }
public void groupHeaderKubun_Format(object sender, EventArgs e) { models.db.Row row = db.MTKamokuKubun.GetRowById(helper.Converter.ObjToInt(txtKubunId.Text, -1)); if (row != null) { txtKubunName.Text = row.GetStr("name"); } else { txtKubunName.Text = ""; } }
public string GetKamokuStr(int kanjouKamokuId, int torihikiKubun) { models.db.Row kamokuRow = this.GetRowFromCache(kanjouKamokuId); if (kamokuRow == null) { return(""); } int kubunId = this.GetKamokuKubunId(kamokuRow, (models.constants.MTTorihikiKubun)torihikiKubun); models.db.Row kubunRow = (OwnerDB as KaikeiDatabase).MTKamokuKubun.GetRowFromCache(kubunId); return(kubunRow.GetStr("name")); }
/// <summary> /// 使用区分のチェック ( 使用区分がONの科目は使用できない) /// </summary> public static bool IsUseableKamokuCode(models.db.KaikeiDatabase db, models.db.Row row, constants.Taisyaku taisyaku) { var kamoku = db.MTKanjouKamoku.GetRowFromCodeCache(-1, row.GetStr(GetTaisyakuStr(taisyaku, "_kamoku_code"))); if (kamoku != null) { if (kamoku.GetBool("usable", true) == false) { return(false); } } return(true); }
private void AddMeisaiRow(int kamokuKubunId) { models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById(kamokuKubunId); if (kamokuKubunRow == null) { return; } MeisaiRow row = new MeisaiRow(kamokuKubunId, kamokuKubunRow.GetStr("name", ""), 0, 0, 0, 0, 0, 0, 0); meisaiList.Add(row); }
private void AddRow(models.db.Row daikubunRow, models.db.Row kamokuRow, bool usableOnly) { models.db.Row kanjouRow = db.MTKanjouKamoku.GetFirstRow("where id=" + kamokuRow.GetStr("kanjou_kamoku_id")); if (usableOnly == true && kanjouRow.GetBool("usable", false) == false) { return; } if (kamokuRow.GetBool("deleted", false) == true) { return; } KanjouKamokuListRow row = new KanjouKamokuListRow( daikubunRow.GetStr("display_order"), daikubunRow.GetStr("name"), kanjouRow.GetStr("kamoku_code"), kanjouRow.GetStr("kamoku"), (int)kanjouRow.GetLong("hierarchy", -1)); row.Index = Rows.Count; Rows.Add(row); }
protected void SetRowDataToTextBoxAsFloat(TextBox control, models.db.Row rowData, string format) { string strValue = rowData.GetStr(control.Tag as string); double?value = helper.Converter.ObjToDoubleObj(strValue); if (value == null) { control.Text = strValue; } else { control.Text = value.Value.ToString(format); } }
private void DenpyouHakkouButtonClicked(object sender) { models.db.Row syoukyakuRow = (sender as views.grid.AbstractDBGridRow).RowData; if (syoukyakuRow == null) { return; } if (SelectedRowId == -1) { return; } syoukyakuRow.Table.SetColumnValue(syoukyakuRow, "denpyou_hakkou", true); (sender as views.grid.AbstractDBGridRow).SetRowData(syoukyakuRow, true); models.db.Row newRow = Context.KaikeiDatabase.KaikeiDenpyouMeisai.NewRow(); //newRow.Table.SetColumnValue(newRow, "kaikei_tanni", (int)models.constants.MTKaikeiTanni.Hukushi); newRow.Table.SetColumnValue(newRow, "kaikei_kubun", selectedRow.GetLong("kaikei_kubun", -1)); newRow.Table.SetColumnValue(newRow, "torihiki_kubun", (int)models.constants.MTTorihikiKubun.Jigyou); if (syoukyakuRow.GetDate("gensyoubi") != null) { DateTime?date = syoukyakuRow.GetDate("gensyoubi"); Context.KaikeiDatabase.KaikeiDenpyouMeisai.SetKihyoubiAndDenpyouBangouCache(newRow, date.Value); } models.db.Row karikataKamokuRow = Context.KaikeiDatabase.MTKanjouKamoku.GetRowById((int)models.constants.MTKanjouKamoku.GenkaSyoukyakuhi); if (karikataKamokuRow != null) { newRow.Table.SetColumnValue(newRow, "karikata_kamoku_code", karikataKamokuRow.GetStr("kamoku_code")); } models.db.Row kashikataKamokuKubunRow = Context.KaikeiDatabase.MTKamokuKubun.GetRowById((int)selectedRow.GetLong("kamoku_kubun_id", -1)); models.db.Row kashikataKamokuRow = Context.KaikeiDatabase.MTKanjouKamoku.GetRowById((int)kashikataKamokuKubunRow.GetLong("kanjou_kamoku_id", -1)); if (kashikataKamokuRow != null) { newRow.Table.SetColumnValue(newRow, "kashikata_kamoku_code", kashikataKamokuRow.GetStr("kamoku_code")); } newRow.Table.SetColumnValue(newRow, "karikata_kingaku", syoukyakuRow.GetLong("touki_genka_syoukyaku_kagaku", 0)); newRow.Table.SetColumnValue(newRow, "comment", selectedRow.GetStr("shisan_meisyou")); newRow.Table.Insert(newRow); models.db.Row insertedRow = newRow.Table.LastInsertedRow(); helper.MsgBox.Info(KaikeiSystemBody.Properties.Resources.MsgConfirmSyoukyakuMeisaiDenpyouHakkou); var denpyouPopupController = new popup.DenpyouInfoPopupController(); denpyouPopupController.ShowPopupModal(popup, insertedRow, Context); }