private void ValidateKamokuCode(models.db.KaikeiDatabase db, models.db.Row row, models.constants.Taisyaku taisyaku) { if (models.Validator.IsHurikaeTaisyouKamokuCode(db, row, taisyaku)) { gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgHurikaeTaisyouKamoku, "warn", null); } }
private void PrintYosanJissekiTaihi3Column(models.db.KaikeiDatabase db, int currentYear, int lastYear, int hoseiKaisuu, int kaikeiKubun, DateTime?printDate) { string houjinMei = ""; houjinMei = db.MTKaikeiKubun.GetRowFromCache(db.MTKaikeiKubun.RootNodeId).GetStr("name") as string; var yosanUchiwake = new models.query.YosanUchiwake(); yosanUchiwake.Calc(db, currentYear, lastYear, hoseiKaisuu, kaikeiKubun, withJisseki: true, withSyoukubun: false, withHojoKamoku: false); var report = new views.reports.SyuushiYosanJissekiReport(); report.OmitZeroRow = form.OmitZeroRow; report.SetDB(db); report.SetHeader(houjinMei, new DateTime(currentYear, 4, 1), new DateTime(currentYear + 1, 3, 31)); for (int i = 0; i < yosanUchiwake.ChildKaikeiKubunNameList.Count; i++) { report.SetKaikeiKubunCaption(i, yosanUchiwake.ChildKaikeiKubunNameList[i]); } var popup = new views.popup.ReportPreviewPopup(); report.DataSource = yosanUchiwake.YosanUchiwakeRowList; report.Run(); popup.Document = report.Document; popup.ShowDialog(); }
public GoukeiZandakaShisanhyou(models.db.KaikeiDatabase aDB) { RowList = new List <ShisanRow>(); kanjouKamokuHash = new Dictionary <int, bool>(); db = aDB; }
/// <summary> /// 経理区分に対応した補助整理かどうか /// 補助整理がNullなら0を設定 /// 経理区分に対応した補助整理でなければ補助IDをnullに設定 /// </summary> public static bool CheckHojoSeiriIsFitInKaikeiKubun(models.db.KaikeiDatabase db, models.db.Row row, constants.Taisyaku taisyaku) { int kamokuId = (int)row.GetLong(GetTaisyakuStr(taisyaku, "_kamoku_id"), -1); int hojoSeiri = (int)row.GetLong(GetTaisyakuStr(taisyaku, "_hojo_seiri"), 0); if (hojoSeiri == 0) { row.Table.SetColumnValue(row, GetTaisyakuStr(taisyaku, "_hojo_seiri"), 0); return(true); } var seiriRow = db.MTKanjouKamoku.GetRowFromCodeCacheByTopParent(kamokuId, hojoSeiri.ToString()); if (seiriRow == null) { row.Table.SetColumnValue(row, GetTaisyakuStr(taisyaku, "_hojo_id"), null); return(false); } int kamokuKaikeiKubunId = (int)seiriRow.GetLong("kaikei_kubun_id", -1); int denpyouKaikeiKubunId = (int)row.GetLong("kaikei_kubun", -1); if (kamokuKaikeiKubunId == -1 || denpyouKaikeiKubunId == -1) { return(true); } if (!db.MTKaikeiKubun.IsChildOf(childId: denpyouKaikeiKubunId, parentId: kamokuKaikeiKubunId)) { return(false); } return(true); }
public void SetDatabase(KaikeiSystemBody.models.db.KaikeiDatabase aDB) { if (db != aDB) { db = aDB; cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, false); cmbKaikeiKubun.SelectedIndex = -1; } }
// マスタ情報の設定 override public void SetMasterTables(models.db.AbstractDatabase aDB) { db = aDB as models.db.KaikeiDatabase; cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true); cmbTorihikiKubun.InitRowsWithMTTorihikiKubun(db.MTTorihikiKubun); }
private void ValidateKamokuCode(models.db.KaikeiDatabase db, models.db.Row row, models.constants.Taisyaku taisyaku) { if (models.Validator.IsHurikaeTaisyouKamokuCode(db, row, taisyaku)) { ShowMsgDelay(KaikeiSystemBody.Properties.Resources.MsgHurikaeTaisyouKamoku, "warn"); } }
override public void CopyMasterTableContoller(AbstractDBGridRow originalRow) { db = (originalRow as IkkatsuSyoriMasterRow).db; cmbKaikeiKubun.CopyRows((originalRow as IkkatsuSyoriMasterRow).cmbKaikeiKubun); cmbTorihikiKubun.CopyRows((originalRow as IkkatsuSyoriMasterRow).cmbTorihikiKubun); }
public ShiwakeDenpyou(models.db.KaikeiDatabase aDB) { db = aDB; RowList = new List <ShiwakeDenpyouRow>(); denpyouIdHash = new Dictionary <int, bool>(); }
public void SetDB(models.db.KaikeiDatabase db_) { db = db_; cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, false); cmbKaikeiKubun.SelectedIndex = 0; }
public void SetDatabase(models.db.KaikeiDatabase aDB) { db = aDB; rowDetailMain.SetMasterTables(db); rowDetailSub.SetMasterTables(db); }
// マスタ情報の設定 override public void SetMasterTables(models.db.AbstractDatabase aDB) { db = aDB as models.db.KaikeiDatabase; cmbKeiriKubun.InitRowsWithMTHoujinShisetsu(db.MTHoujinShisetsu, false); cmbHojoKamoku.InitRowsWithMTHojoKamokuWhereKeyIsId(db.MTHojoKamoku, ParentKamokuId); }
public long GetTaisyaku(models.db.KaikeiDatabase db) { models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetFirstRow("where id=" + KamokuKubunId); if (kamokuKubunRow == null) { return(0); } int kanjouKamokuId = (int)kamokuKubunRow.GetLong("kanjou_kamoku_id", -1); models.db.Row kanjouKamokuRow = db.MTKanjouKamoku.GetFirstRow("where id=" + kanjouKamokuId); if (kanjouKamokuRow == null) { return(0); } int taisyakuKubunId = (int)kanjouKamokuRow.GetLong("taisyaku_kubun_id", -1); if (taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KariPlus || taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KariMinus) { return(KarikataAmount - KashikataAmount); } else { return(KashikataAmount - KarikataAmount); } }
public void SetDatabase(models.db.KaikeiDatabase aDB) { db = aDB; cmbKaikeiKubunForKamoku.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true); cmbYosanKubunForKamoku.InitRowsWithMTYosanKubun(db.MTYosanKubun); cmbKaikeiKubunForHojo.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true); cmbYosanKubunForHojo.InitRowsWithMTYosanKubun(db.MTYosanKubun); }
public void SetAddedShiwake(models.db.KaikeiDatabase db, models.db.Row row) { int torihikiKubunId = (int)row.GetLong("torihiki_kubun", -1); KarikataKamoku2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_kamoku_id", -1), torihikiKubunId); KashikataKamoku2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_kamoku_id", -1), torihikiKubunId); KarikataHojo2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_hojo_id", -1), torihikiKubunId); KashikataHojo2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_hojo_id", -1), torihikiKubunId); }
public YosanListRow() { InitializeComponent(); btnShow.Click += (s, e) => ShowButtonClicked(this); SetDefaultIndicator(); db = null; }
public YosanDaikubunRow() { InitializeComponent(); SetDefaultHandlersToControls(); SetDefaultIndicator(); db = null; }
public void SetDatabase(models.db.KaikeiDatabase aDB) { if (db != aDB) { db = aDB; cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true); cmbKaikeiKubun.SelectedIndex = 0; } }
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())); }
public ZenkiKurikoshiKamokuKubunRow() { InitializeComponent(); SetDefaultHandlersToControls(); SetDefaultIndicator(); db = null; }
public SyuushiKakuninRow() { InitializeComponent(); db = null; SetDefaultHandlersToControls(); SetDefaultIndicator(); }
public KaikeiDenpyouRow() { InitializeComponent(); db = null; btnRemoveRow.Click += base.DefaultHandlerRemoveRowButtonClicked; SetDefaultHandlersToControls(); SetDefaultIndicator(); }
public KanjouMototyou(models.db.KaikeiDatabase aDB) { db = aDB; calced = false; rowList = new List <MototyouRow>(); MeisaiTable = db.KaikeiDenpyouMeisai; KurikoshiKamokuTable = db.ZenkiKurikoshiKamokuKubun; }
public IkkatsuSyoriMasterRow() { InitializeComponent(); db = null; btnDelete.Click += base.DefaultHandlerRemoveRowButtonClicked; SetDefaultHandlersToControls(); SetDefaultIndicator(); }
private void ValidateKashikataHojoSeiri(models.db.KaikeiDatabase db, models.db.Row row) { if (!models.Validator.CheckHojoSeiriIsFitInKaikeiKubun(db, row, models.constants.Taisyaku.Kashikata)) { delayTimerController.SetDelayedProc(delegate() { helper.MsgBox.ShowMsg(KaikeiSystemBody.Properties.Resources.MsgInvaidHojoSeiri, "warn"); popup.FocusKashikataHojoCmbBox(); }); } }
// マスタ情報の設定 public void SetMasterTables(models.db.KaikeiDatabase db) { cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true); if (cmbKaikeiKubun.Items.Count > 0) { cmbKaikeiKubun.SelectedIndex = 0; } cmbTorihikiKubun.InitRowsWithMTTorihikiKubun(db.MTTorihikiKubun); cmbKamoku.InitRowsWithMTKanjouKamoku(db.MTKanjouKamoku, -1); }
public KoteiShisanRow() { InitializeComponent(); SetDefaultHandlersToControls(); SetDefaultIndicator(); btnDetail.Click += DetailButtonClickedHandler; db = null; }
public YosanYobihiKakuninRow() { InitializeComponent(); btnDelete.Click += base.DefaultHandlerRemoveRowButtonClicked; SetDefaultHandlersToControls(); SetDefaultIndicator(); db = null; }
private void ValidateKashikataHojoSeiri(models.db.KaikeiDatabase db, models.db.Row row, bool kamokuCheck = true) { if (kamokuCheck && !models.Validator.CheckHojoSeiriIsFitInKamokuCode(db, row, models.constants.Taisyaku.Kashikata)) { gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgHojoSeiriNotFound, "warn", "kashikata_hojo_seiri"); } else if (!models.Validator.CheckHojoSeiriIsFitInKaikeiKubun(db, row, models.constants.Taisyaku.Kashikata)) { gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgInvaidHojoSeiri, "warn", "kashikata_hojo_seiri"); } }
public void SetDatabase(models.db.KaikeiDatabase aDB) { db = aDB; cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, onlyLeafNode: true); cmbTorihikiKubun.InitRowsWithMTTorihikiKubun(db.MTTorihikiKubun); cmbKarikataKamoku.InitRowsWithMTKanjouKamokuWithKamokuCodeCaption(db.MTKanjouKamoku, -1); cmbKarikataHojo.BindToMTKanjouKamkouComboBoxWithKamokuCodeCaption(cmbKarikataKamoku, -1); cmbKashikataKamoku.InitRowsWithMTKanjouKamokuWithKamokuCodeCaption(db.MTKanjouKamoku, -1); cmbKashikataHojo.BindToMTKanjouKamkouComboBoxWithKamokuCodeCaption(cmbKashikataKamoku, -1); }