C# Class hoTools.Query.QueryGui

Afficher le fichier Open project: Helmut-Ortmann/EnterpriseArchitect_hoTools

Méthodes publiques

Méthode	Description
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

Méthodes protégées

Méthode	Description
Dispose ( bool disposing ) : void	Clean up any resources being used.

Private Methods

Méthode	Description
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

Method Details

Close() public méthode

Close Addin: - Close not stored files

public Close ( ) : void
Résultat	void

Dispose() protected méthode

Clean up any resources being used.

protected Dispose ( bool disposing ) : void
disposing	bool	true if managed resources should be disposed; otherwise, false.
Résultat	void

FileNewTabToolStripMenuItem_Click() public méthode

public FileNewTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

GetName() public méthode

public GetName ( ) : string
Résultat	string

InitScriptDataGrid() public méthode

Init Script Data for Grid

public InitScriptDataGrid ( ) : void
Résultat	void

InitScriptDataTable() public méthode

Init the Data Grid Table.

public InitScriptDataTable ( ) : void
Résultat	void

QueryGUI_Resize() public méthode

public QueryGUI_Resize ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

QueryGui() public méthode

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

public QueryGui ( ) : System
Résultat	System

RunScriptWithAskGui() public méthode

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
Résultat	void

ShowScriptErrorToolStripMenuItem_Click() public méthode

Show error of the selected Script

public ShowScriptErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

UpdateTableFunctions() public méthode

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
Résultat	void

_newTabWithFileDialogToolStripMenuItem_Click() public méthode

New Tab via File Dialog

public _newTabWithFileDialogToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

aboutToolStripMenuItem_Click() public méthode

About Window

public aboutToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnLoadScripts_Click() public méthode

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

public btnLoadScripts_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnRedo_Click() public méthode

public btnRedo_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnRunScriptForSqlWithAsk_Click() public méthode

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
Résultat	void

btnRunScriptForSql_Click() public méthode

Run SQL and execute Script

public btnRunScriptForSql_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnSaveAll_Click() public méthode

Save all sql Tabs

public btnSaveAll_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnSaveAs_Click() public méthode

Save sql Tab As

public btnSaveAs_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnSave_Click() public méthode

Save sql Tab

public btnSave_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

btnUndo_Click() public méthode

public btnUndo_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

dataGridViewScripts_MouseClick() public méthode

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

public dataGridViewScripts_MouseClick ( object sender, MouseEventArgs e ) : void
sender	object
e	MouseEventArgs
Résultat	void

helpToolStripMenuItem1_Click() public méthode

ShowHelp

public helpToolStripMenuItem1_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

lastSqlStringSentToEAToolStripMenuItem_Click() public méthode

Output the last from hoTools Query sent sql string to EA

public lastSqlStringSentToEAToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

loadStandardScriptsToolStripMenuItem_Click() public méthode

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

public loadStandardScriptsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

loadTabCtrlLToolStripMenuItem_Click() public méthode

CTRL+L Load TabPage from File

public loadTabCtrlLToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

reloadTabToolStripMenuItem_Click() public méthode

public reloadTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

runSqlTabToolStripMenuItem_Click() public méthode

public runSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

saveAllToolStripMenuItem_Click() public méthode

public saveAllToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

saveSqlTabAsToolStripMenuItem_Click() public méthode

public saveSqlTabAsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

saveSqlTabToolStripMenuItem_Click() public méthode

public saveSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

settingsToolStripMenuItem_Click() public méthode

public settingsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

showScriptToolStripMenuItem_Click() public méthode

Output the script code of the selected row

public showScriptToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

showSqlErrorToolStripMenuItem_Click() public méthode

Output the last EA SQL error

public showSqlErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

tabControlSql_DrawItem() public méthode

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
Résultat	void

tabControlSql_MouseDown() public méthode

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
Résultat	void

templatesAndMacrosToolStripMenuItem_Click() public méthode

Output Help of macros and templates in a text editor

public templatesAndMacrosToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
Résultat	void

txtSearchTerm_KeyDown() public méthode

public txtSearchTerm_KeyDown ( object sender, KeyEventArgs e ) : void
sender	object
e	KeyEventArgs
Résultat	void

txtSearchTerm_MouseDoubleClick() public méthode

public txtSearchTerm_MouseDoubleClick ( object sender, MouseEventArgs e ) : void
sender	object
e	MouseEventArgs
Résultat	void