override protected void OnActivated(object option) { table = new models.db.BufferedTable(Context.KaikeiDatabase.MTKoteiShisan); gridController.SetTable(table); ShowAllRows(); form.SetDatabase(Context.KaikeiDatabase); popupController.Context = Context; }
// events override protected void OnActivated(object option) { tekiyouTable = new models.db.BufferedTable(Context.KaikeiDatabase.MTTekiyou); tekiyouTable.SqlCondition = "order by tekiyou_code"; tekiyouTable.SyncRowList(); gridController.SetTable(tekiyouTable); gridController.SetQuery(""); }
// events override protected void OnActivated(object option) { kaikeiTanniTable = new models.db.BufferedTable(Context.KaikeiDatabase.MTKaikeiTanni); kaikeiTanniTable.SqlCondition = "order by id"; kaikeiTanniTable.SyncRowList(); gridController.SetTable(kaikeiTanniTable); gridController.SetQuery(""); }
// events override protected void OnActivated(object option) { torihikiKubunTable = new models.db.BufferedTable(Context.KaikeiDatabase.MTTorihikiKubun); torihikiKubunTable.SqlCondition = "order by id"; torihikiKubunTable.SyncRowList(); gridController.SetTable(torihikiKubunTable); gridController.SetQuery(""); }
// events override protected void OnActivated(object option) { bufferedKaikeiKubunTable = new models.db.BufferedTable(Context.KaikeiDatabase.MTKaikeiKubun); bufferedKaikeiKubunTable.SqlCondition = "where parent_id <> -1 order by kubun_code"; bufferedKaikeiKubunTable.SyncRowList(); gridController.SetTable(bufferedKaikeiKubunTable); gridController.SetQuery(""); SetHoujinShisetsuRowData(); }
// events override protected void OnActivated(object option) { daikubunTable = new models.db.BufferedTable(Context.KaikeiDatabase.MTKamokuKubun); daikubunTable.SyncRowListFunc += delegate(List <models.db.Row> rowList) { foreach (var kubunRow in Context.KaikeiDatabase.MTKamokuKubun.Select("where hierarchy=" + ((int)models.constants.MTKamokuKubunHierarchy.Kubun) + " order by display_order")) { foreach (var row in Context.KaikeiDatabase.MTKamokuKubun.Select("where parent_id=" + kubunRow.GetLong("id", -1) + " order by display_order")) { models.db.Row newRow = daikubunTable.NewRow(); row.CopyColumns(newRow); rowList.Add(newRow); } } }; daikubunTable.SyncRowList(); gridController.SetTable(daikubunTable); gridController.SetQuery(""); }
public void ShowPopupModal(Form parent, int rowId) { popup = new views.popup.KoteiShisanDetailPopup(); popup.PopupClosed += delegate() { }; popup.CloseButtonClicked += () => popup.Close(); popup.ColumnValueChanged += ColumnValueChanged; popup.FirstButtonClickekd += () => SelectRow(0); popup.EndButtonClicked += () => SelectRow(RowCount - 1); popup.PrevButtonClicked += () => SelectRow(Math.Max(selectedRowNo - 1, 0)); popup.NextButtonClicked += () => SelectRow(Math.Min(selectedRowNo + 1, RowCount)); popup.NewButtonClicked += () => SelectRow(RowCount); popup.DeleteButtonClicked += delegate() { if (SelectedRowId != -1) { selectedRow.Table.Delete(selectedRow); SelectRow(selectedRowNo); } }; popup.IkkatsuSyoukyakuButtonClicked += delegate() { foreach (var row in Context.KaikeiDatabase.MTKoteiShisan.Select("")) { int id = (int)row.GetLong("id", -1); if (id != -1) { models.KoteiShisanFunc.CreateGenkaSyoukyakuMeisai(Context, id); } } meisaiTable.SyncRowList(); meisaiGridController.SetQuery(""); helper.MsgBox.Info(KaikeiSystemBody.Properties.Resources.MsgSucceeded); }; popup.SyoukyakuButtonClicked += delegate() { if (SelectedRowId != -1) { if (models.KoteiShisanFunc.CreateGenkaSyoukyakuMeisai(Context, SelectedRowId)) { meisaiTable.SyncRowList(); meisaiGridController.SetQuery(""); helper.MsgBox.Info(KaikeiSystemBody.Properties.Resources.MsgSucceeded); } else { helper.MsgBox.Err(KaikeiSystemBody.Properties.Resources.MsgInputDataIncomplete); } } }; popup.DeleteMeisaiButtonClicked += delegate() { if (SelectedRowId != -1) { 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) { string sql = "delete from " + models.db.tables.GenkaSyoukyakuMeisai.TABLE_NAME + " where kotei_shisan_bangou = " + SelectedRowId; Context.KaikeiDatabase.ExecuteNonQuery(sql); meisaiTable.SyncRowList(); meisaiGridController.SetQuery(""); } } }; popup.SetDatabase(Context.KaikeiDatabase); popup.StartPosition = System.Windows.Forms.FormStartPosition.Manual; popup.Location = new System.Drawing.Point( Math.Max(parent.Left + (parent.Width - popup.Width) / 2, 0), Math.Max(parent.Top + (parent.Height - popup.Height) / 2, 0)); meisaiTable = new models.db.BufferedTable(Context.KaikeiDatabase.GenkaSyoukyakuMeisai); meisaiGridController = new grid.DBPanelGridController <views.grid.SyoukyakuMeisaiRow>(popup.SyoukyakuMeisaiGrid, true); meisaiGridController.SetTable(meisaiTable); meisaiGridController.InitInsertedRow += delegate(models.db.Row row) { if (SelectedRowId != -1) { row.Table.SetColumnValue(row, "kotei_shisan_bangou", SelectedRowId); } }; foreach (var row in popup.SyoukyakuMeisaiGrid.AllRowControls()) { (row as views.grid.SyoukyakuMeisaiRow).DenpyouHakkouButtonClicked += DenpyouHakkouButtonClicked; } SelectRow(RowId2RowNo(rowId)); focusController = new misc.FocusController(popup); popup.ShowDialog(); }