C# Класс hoTools.Query.QueryGui

Показать файл Открыть проект

Открытые методы

Метод Описание
Close ( ) : void

Close Addin: - Close not stored files

FileNewTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
GetName ( ) : string
InitScriptDataGrid ( ) : void

Init Script Data for Grid

InitScriptDataTable ( ) : void

Init the Data Grid Table.

QueryGUI_Resize ( object sender, EventArgs e ) : void
QueryGui ( ) : System

Constructor QueryGUI. Constructor make the basic initialization. The real initialization is done after Setting the Repository in setter of property: 'Repository'

RunScriptWithAskGui ( bool isWithAsk = false ) : void

Run sql query and execute Script for found rows. This function is intended to use from Dialog.

ShowScriptErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Show error of the selected Script

UpdateTableFunctions ( bool isWithAll = false ) : void

Compile, load scripts with may run on SQL Query result rows, Global Keys or Toolbar Button. The conditions: - Contains string 'EA-Matic' - With 2 or 3 parameters From Repository, MDG Technology folder, Registry (Tools, MDG, Advanced,..)

_newTabWithFileDialogToolStripMenuItem_Click ( object sender, EventArgs e ) : void

New Tab via File Dialog

aboutToolStripMenuItem_Click ( object sender, EventArgs e ) : void

About Window

btnLoadScripts_Click ( object sender, EventArgs e ) : void

Load all usable script. They shall contain 'EA-Matic'

btnRedo_Click ( object sender, EventArgs e ) : void
btnRunScriptForSqlWithAsk_Click ( object sender, EventArgs e ) : void

Run sql query and execute Script for found rows. Ask if script is to execute.

btnRunScriptForSql_Click ( object sender, EventArgs e ) : void

Run SQL and execute Script

btnSaveAll_Click ( object sender, EventArgs e ) : void

Save all sql Tabs

btnSaveAs_Click ( object sender, EventArgs e ) : void

Save sql Tab As

btnSave_Click ( object sender, EventArgs e ) : void

Save sql Tab

btnUndo_Click ( object sender, EventArgs e ) : void
dataGridViewScripts_MouseClick ( object sender, MouseEventArgs e ) : void

MouseClick in dataGridViewScripts - Estimate mate the clicked row - store the current row

helpToolStripMenuItem1_Click ( object sender, EventArgs e ) : void

ShowHelp

lastSqlStringSentToEAToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Output the last from hoTools Query sent sql string to EA

loadStandardScriptsToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Load Standard Scripts into EA: ScriptGroup:hoTools, Script: hoDemo2Par, hoDemo3Par

loadTabCtrlLToolStripMenuItem_Click ( object sender, EventArgs e ) : void

CTRL+L Load TabPage from File

reloadTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
runSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
saveAllToolStripMenuItem_Click ( object sender, EventArgs e ) : void
saveSqlTabAsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
saveSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
settingsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
showScriptToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Output the script code of the selected row

showSqlErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Output the last EA SQL error

tabControlSql_DrawItem ( object sender, DrawItemEventArgs e ) : void

Draw all the Tab after change of TAB (focus, text,.. changed) If active than change TAB properties for easier seeing the active tab Draw an 'x' in the tabPage at the end of the caption (Close Tab) Set property DrawMode to 'OwnerDrawFixed' Note: Extend the 'Text' Property by 3 blanks to get space for the extra 'x' Use a non proportional font like courier new

tabControlSql_MouseDown ( object sender, MouseEventArgs e ) : void

Close TabPage if 'x' for close is selected Note: Use a non proportional font like 'courier new'

templatesAndMacrosToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Output Help of macros and templates in a text editor

txtSearchTerm_KeyDown ( object sender, KeyEventArgs e ) : void
txtSearchTerm_MouseDoubleClick ( object sender, MouseEventArgs e ) : void

Защищенные методы

Метод Описание
Dispose ( bool disposing ) : void

Clean up any resources being used.

Приватные методы

Метод Описание
InitializeComponent ( ) : void

Required method for Designer support - do not modify the contents of this method with the code editor.

InitializeSettings ( ) : bool

Initialize setting. Only call after - Tag ( - Model - Settings updated

ReloadScripts ( ) : void

Reload the Scripts and update the Script View. Pay attention: After Loading the script EA needs update of Scripting window (third button from right)

btnRun_Click ( object sender, EventArgs e ) : void

Run sql

contextMenuStripDataGrid_Opening ( object sender, System e ) : void
gitHubRepositoryToolStripMenuItem_Click ( object sender, EventArgs e ) : void
gitHubWiKiSQLToolStripMenuItem_Click ( object sender, EventArgs e ) : void
gitHubWiKiScriptToolStripMenuItem_Click ( object sender, EventArgs e ) : void
gitHubWiKiToolStripMenuItem_Click ( object sender, EventArgs e ) : void
runScriptSelectedItemToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Run Script for Context Item. Element, Attribute, Operation, Package, Diagram, Diagram Objects, Diagram Connector

runTreeSelectedToolStripMenuItem_Click ( object sender, EventArgs e ) : void

Run Script for Tree selected Elements

Описание методов

Close() публичный Метод

Close Addin: - Close not stored files
public Close ( ) : void
Результат void

Dispose() защищенный Метод

Clean up any resources being used.
protected Dispose ( bool disposing ) : void
disposing bool true if managed resources should be disposed; otherwise, false.
Результат void

FileNewTabToolStripMenuItem_Click() публичный Метод

public FileNewTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

GetName() публичный Метод

public GetName ( ) : string
Результат string

InitScriptDataGrid() публичный Метод

Init Script Data for Grid
public InitScriptDataGrid ( ) : void
Результат void

InitScriptDataTable() публичный Метод

Init the Data Grid Table.
public InitScriptDataTable ( ) : void
Результат void

QueryGUI_Resize() публичный Метод

public QueryGUI_Resize ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

QueryGui() публичный Метод

Constructor QueryGUI. Constructor make the basic initialization. The real initialization is done after Setting the Repository in setter of property: 'Repository'
public QueryGui ( ) : System
Результат System

RunScriptWithAskGui() публичный Метод

Run sql query and execute Script for found rows. This function is intended to use from Dialog.
public RunScriptWithAskGui ( bool isWithAsk = false ) : void
isWithAsk bool True: Ask for each found rows if to execute
Результат void

ShowScriptErrorToolStripMenuItem_Click() публичный Метод

Show error of the selected Script
public ShowScriptErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

UpdateTableFunctions() публичный Метод

Compile, load scripts with may run on SQL Query result rows, Global Keys or Toolbar Button. The conditions: - Contains string 'EA-Matic' - With 2 or 3 parameters From Repository, MDG Technology folder, Registry (Tools, MDG, Advanced,..)
public UpdateTableFunctions ( bool isWithAll = false ) : void
isWithAll bool
Результат void

_newTabWithFileDialogToolStripMenuItem_Click() публичный Метод

New Tab via File Dialog
public _newTabWithFileDialogToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

aboutToolStripMenuItem_Click() публичный Метод

About Window
public aboutToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnLoadScripts_Click() публичный Метод

Load all usable script. They shall contain 'EA-Matic'
public btnLoadScripts_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnRedo_Click() публичный Метод

public btnRedo_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnRunScriptForSqlWithAsk_Click() публичный Метод

Run sql query and execute Script for found rows. Ask if script is to execute.
public btnRunScriptForSqlWithAsk_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnRunScriptForSql_Click() публичный Метод

Run SQL and execute Script
public btnRunScriptForSql_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnSaveAll_Click() публичный Метод

Save all sql Tabs
public btnSaveAll_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnSaveAs_Click() публичный Метод

Save sql Tab As
public btnSaveAs_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnSave_Click() публичный Метод

Save sql Tab
public btnSave_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

btnUndo_Click() публичный Метод

public btnUndo_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

dataGridViewScripts_MouseClick() публичный Метод

MouseClick in dataGridViewScripts - Estimate mate the clicked row - store the current row
public dataGridViewScripts_MouseClick ( object sender, MouseEventArgs e ) : void
sender object
e MouseEventArgs
Результат void

helpToolStripMenuItem1_Click() публичный Метод

ShowHelp
public helpToolStripMenuItem1_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

lastSqlStringSentToEAToolStripMenuItem_Click() публичный Метод

Output the last from hoTools Query sent sql string to EA
public lastSqlStringSentToEAToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

loadStandardScriptsToolStripMenuItem_Click() публичный Метод

Load Standard Scripts into EA: ScriptGroup:hoTools, Script: hoDemo2Par, hoDemo3Par
public loadStandardScriptsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

loadTabCtrlLToolStripMenuItem_Click() публичный Метод

CTRL+L Load TabPage from File
public loadTabCtrlLToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

reloadTabToolStripMenuItem_Click() публичный Метод

public reloadTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

runSqlTabToolStripMenuItem_Click() публичный Метод

public runSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

saveAllToolStripMenuItem_Click() публичный Метод

public saveAllToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

saveSqlTabAsToolStripMenuItem_Click() публичный Метод

public saveSqlTabAsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

saveSqlTabToolStripMenuItem_Click() публичный Метод

public saveSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

settingsToolStripMenuItem_Click() публичный Метод

public settingsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

showScriptToolStripMenuItem_Click() публичный Метод

Output the script code of the selected row
public showScriptToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

showSqlErrorToolStripMenuItem_Click() публичный Метод

Output the last EA SQL error
public showSqlErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

tabControlSql_DrawItem() публичный Метод

Draw all the Tab after change of TAB (focus, text,.. changed) If active than change TAB properties for easier seeing the active tab Draw an 'x' in the tabPage at the end of the caption (Close Tab) Set property DrawMode to 'OwnerDrawFixed' Note: Extend the 'Text' Property by 3 blanks to get space for the extra 'x' Use a non proportional font like courier new
public tabControlSql_DrawItem ( object sender, DrawItemEventArgs e ) : void
sender object
e DrawItemEventArgs
Результат void

tabControlSql_MouseDown() публичный Метод

Close TabPage if 'x' for close is selected Note: Use a non proportional font like 'courier new'
public tabControlSql_MouseDown ( object sender, MouseEventArgs e ) : void
sender object
e MouseEventArgs
Результат void

templatesAndMacrosToolStripMenuItem_Click() публичный Метод

Output Help of macros and templates in a text editor
public templatesAndMacrosToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender object
e EventArgs
Результат void

txtSearchTerm_KeyDown() публичный Метод

public txtSearchTerm_KeyDown ( object sender, KeyEventArgs e ) : void
sender object
e KeyEventArgs
Результат void

txtSearchTerm_MouseDoubleClick() публичный Метод

public txtSearchTerm_MouseDoubleClick ( object sender, MouseEventArgs e ) : void
sender object
e MouseEventArgs
Результат void