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();
}
