// Rowデータの設定 override protected void SetRowDataSub(models.db.Row row_data) { int torihikiKubunId = (int)row_data.GetLong("torihiki_kubun", -1); lblId.Text = row_data.GetStr("id", "(新規)"); { DateTime?createdAt = row_data.GetDate("created_at"); lblCreateDate.Text = createdAt != null?helper.Converter.DateTimeToWarekiStr(createdAt.Value) : ""; } { DateTime?updatedAt = row_data.GetDate("updated_at"); lblUpdateDate.Text = updatedAt != null?helper.Converter.DateTimeToWarekiStr(updatedAt.Value) : ""; } txtDenpyouBangou.Text = row_data.GetStr("denpyou_bangou_cache", ""); txtKihyoubiGengou.Text = row_data.GetStr("kihyoubi_gengou", ""); txtKihyoubiYear.Text = row_data.GetStr("kihyoubi_year", ""); txtKihyoubiMonth.Text = row_data.GetStr("kihyoubi_month", ""); txtKihyoubiDay.Text = row_data.GetStr("kihyoubi_day", ""); txtKarikataKamokuCode.Text = row_data.GetStr("karikata_kamoku_code", ""); lblKarikataKamoku.Text = db.MTKanjouKamoku.GetKamokuStr((int)row_data.GetLong("karikata_kamoku_id", -1), torihikiKubunId); txtKashikataKamokuCode.Text = row_data.GetStr("kashikata_kamoku_code", ""); lblKashikataKamoku.Text = db.MTKanjouKamoku.GetKamokuStr((int)row_data.GetLong("kashikata_kamoku_id", -1), torihikiKubunId); txtKingaku.AmountStr = row_data.GetStr("karikata_kingaku", ""); txtTekiyou.Text = row_data.GetStr("tekiyou_id", ""); txtComment.Text = row_data.GetStr("comment", ""); chkKessanSyuuryou.Checked = row_data.GetBool("kessan_syuuryou", false); chkDenpyouKakunin.Checked = row_data.GetBool("denpyou_kakunin", false); cmbKaikeiKubun.SelectRowByKeyValue(row_data.GetLong("kaikei_kubun", -1)); cmbTorihikiKubun.SelectRowByKeyValue(torihikiKubunId); txtKarikataHojoSeiri.Text = row_data.GetStr("karikata_hojo_seiri", ""); lblKarikataHojo.Text = db.MTKanjouKamoku.GetKamokuStr((int)row_data.GetLong("karikata_hojo_id", -1), torihikiKubunId); txtKashikataHojoSeiri.Text = row_data.GetStr("kashikata_hojo_seiri", ""); lblKashikataHojo.Text = db.MTKanjouKamoku.GetKamokuStr((int)row_data.GetLong("kashikata_hojo_id", -1), torihikiKubunId); bool isBindedShikinDenpyou = db.KaikeiDenpyouMeisai.IsAutoInsertedShikinDenpyouRow(row_data); txtKihyoubiGengou.ReadOnly = isBindedShikinDenpyou; txtKihyoubiYear.ReadOnly = isBindedShikinDenpyou; txtKihyoubiMonth.ReadOnly = isBindedShikinDenpyou; txtKihyoubiDay.ReadOnly = isBindedShikinDenpyou; cmbKaikeiKubun.Enabled = !isBindedShikinDenpyou; cmbTorihikiKubun.Enabled = !isBindedShikinDenpyou; txtKarikataKamokuCode.ReadOnly = isBindedShikinDenpyou; txtKarikataHojoSeiri.ReadOnly = isBindedShikinDenpyou; txtKashikataKamokuCode.ReadOnly = isBindedShikinDenpyou; txtKashikataHojoSeiri.ReadOnly = isBindedShikinDenpyou; txtKingaku.ReadOnly = isBindedShikinDenpyou; txtTekiyou.ReadOnly = isBindedShikinDenpyou; txtComment.ReadOnly = isBindedShikinDenpyou; btnRemoveRow.Enabled = !isBindedShikinDenpyou; chkKessanSyuuryou.Enabled = !isBindedShikinDenpyou; }
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); }
public static bool CheckKihyoubiIsInLisenceDate(models.db.KaikeiDatabase db, models.db.Row row) { DateTime?expireDate = db.MTResist.GetExpireDate(); DateTime?kihyoubi = row.GetDate("kihyoubi"); if (expireDate == null) { return(false); } if (kihyoubi != null && kihyoubi > expireDate) { return(false); } return(true); }
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 OnChangeSyutokuNenngappi(models.db.Row row) { DateTime?date = row.GetDate("syutoku_nenngappi"); DateTime gensyoubi; if (date == null) { gensyoubi = DateTime.Now; } else if (date.Value.Month > 3) { gensyoubi = new DateTime(date.Value.Year + 1, 3, 31); } else { gensyoubi = new DateTime(date.Value.Year, 3, 31); } row.Table.SetColumnValue(row, "gensyoubi", gensyoubi); OnChangeTaiyouNennsuu(row); }
// 年度起算日に入っているかチェック public static bool CheckKihyoubiIsInNendoKisanbi(models.db.KaikeiDatabase db, models.db.Row row) { if (!row.IsNull("kihyoubi")) { string kisanbiStr = db.MTSetting.GetStr("nenndo_kisanbi", ""); if (helper.Converter.IsDateStr(kisanbiStr)) { DateTime dateStart = helper.Converter.DateStrToDateTime(kisanbiStr); DateTime dateEnd = dateStart.AddYears(1).AddDays(-1); DateTime kihyoubi = row.GetDate("kihyoubi").Value; if (dateStart <= kihyoubi && kihyoubi <= dateEnd) { return(true); } else { return(false); } } } return(false); }
// Rowデータの設定 override protected void SetRowDataSub(models.db.Row rowData) { amountYobihi.AmountStr = rowData.GetStr("yobihi"); amountZenkiZandaka.AmountStr = rowData.GetStr("zenkimatsu_shiharai_shikin_zandaka"); dateCreated.Date = rowData.GetDate("create_date"); }
protected void SetRowDataToDateTimePicker(controls.NullableDateTimePicker control, models.db.Row rowData) { (control as controls.NullableDateTimePicker).Value = rowData.GetDate(control.Tag as string); }
protected void SetRowDataToDateInputPanel(views.controls.DateInputPanel control, models.db.Row rowData) { control.Date = rowData.GetDate(control.Tag as string); }
// 償却 public static bool CreateGenkaSyoukyakuMeisai(models.Context context, int koteiShisanId) { models.db.Row koteiShisanRow = context.KaikeiDatabase.MTKoteiShisan.GetRowById(koteiShisanId); if (koteiShisanRow == null) { return(false); } DateTime?syutokubi = koteiShisanRow.GetDate("syutoku_nenngappi"); long syutokuKakaku = koteiShisanRow.GetLong("syutoku_kakaku", -1); long taiyouNensuu = koteiShisanRow.GetLong("taiyou_nennsuu", -1); double syoukyakuritsu = koteiShisanRow.GetDouble("syoukyaku_ritsu", -1); double zanzonWariai = koteiShisanRow.GetDouble("zanzon_wariai", -1); if (syutokubi == null || syutokuKakaku < 0 || taiyouNensuu < 0 || syoukyakuritsu < 0 || zanzonWariai < 0) { return(false); } long zanzonKagaku = (long)Math.Round(syutokuKakaku * zanzonWariai / 100); DateTime gensyoubi = helper.Converter.DateTimeToNenndoKimatsubi(syutokubi.Value); long ruikeiSyoukyakuhi = 0; long ruikeiShiyouTsukisuu = 0; long kaisuu = 1; while (ruikeiShiyouTsukisuu < taiyouNensuu * 12) { long shiyouTsukisuu; if (ruikeiShiyouTsukisuu == 0) { shiyouTsukisuu = syutokubi.Value.Month >= 4 ? 15 - syutokubi.Value.Month : 3 - syutokubi.Value.Month; if (context.Setting.GetInt("kounyuutsuki_syoukyaku", 0) != 0) { shiyouTsukisuu++; } if (shiyouTsukisuu == 0) { gensyoubi = gensyoubi.AddYears(1); shiyouTsukisuu = 12; } } else if (taiyouNensuu * 12 - ruikeiShiyouTsukisuu < 12) { shiyouTsukisuu = taiyouNensuu * 12 - ruikeiShiyouTsukisuu; } else { shiyouTsukisuu = 12; } long syoukyakuhi = TeigakuhouGenkaSyoukyakuhi(syutokuKakaku, zanzonWariai, shiyouTsukisuu, syoukyakuritsu); long kisyuTyouboKagaku = syutokuKakaku - ruikeiSyoukyakuhi; ruikeiShiyouTsukisuu += shiyouTsukisuu; if (kisyuTyouboKagaku - syoukyakuhi < zanzonKagaku) // 償却残額が残存価額を下回る { syoukyakuhi = kisyuTyouboKagaku - zanzonKagaku; ruikeiSyoukyakuhi += syoukyakuhi; insertMeisaiRow(context, koteiShisanId, kaisuu, shiyouTsukisuu, syoukyakuhi, gensyoubi, kisyuTyouboKagaku, ruikeiSyoukyakuhi); break; } if (ruikeiShiyouTsukisuu == taiyouNensuu * 12 && // 最終年 kisyuTyouboKagaku - syoukyakuhi != zanzonKagaku) // 残存価額の調整が必要 { if (shiyouTsukisuu == 12) // 年跨ぎ { ruikeiSyoukyakuhi += syoukyakuhi; insertMeisaiRow(context, koteiShisanId, kaisuu, shiyouTsukisuu, syoukyakuhi, gensyoubi, kisyuTyouboKagaku, ruikeiSyoukyakuhi); shiyouTsukisuu = 1; kaisuu++; gensyoubi = gensyoubi.AddYears(1); kisyuTyouboKagaku = kisyuTyouboKagaku - syoukyakuhi; syoukyakuhi = kisyuTyouboKagaku - zanzonKagaku; ruikeiSyoukyakuhi += syoukyakuhi; insertMeisaiRow(context, koteiShisanId, kaisuu, shiyouTsukisuu, syoukyakuhi, gensyoubi, kisyuTyouboKagaku, ruikeiSyoukyakuhi); } else { shiyouTsukisuu += 1; syoukyakuhi = kisyuTyouboKagaku - zanzonKagaku; ruikeiSyoukyakuhi += syoukyakuhi; insertMeisaiRow(context, koteiShisanId, kaisuu, shiyouTsukisuu, syoukyakuhi, gensyoubi, kisyuTyouboKagaku, ruikeiSyoukyakuhi); } } else { ruikeiSyoukyakuhi += syoukyakuhi; insertMeisaiRow(context, koteiShisanId, kaisuu, shiyouTsukisuu, syoukyakuhi, gensyoubi, kisyuTyouboKagaku, ruikeiSyoukyakuhi); } kaisuu++; gensyoubi = gensyoubi.AddYears(1); } return(true); }