C# Class hoTools.Query.QueryGui

ファイルを表示 Open project: Helmut-Ortmann/EnterpriseArchitect_hoTools

Public Methods

Method	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

Protected Methods

Method	Description
Dispose ( bool disposing ) : void	Clean up any resources being used.

Private Methods

Method	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 method

Close Addin: - Close not stored files

public Close ( ) : void
return	void

Dispose() protected method

Clean up any resources being used.

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

FileNewTabToolStripMenuItem_Click() public method

public FileNewTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

GetName() public method

public GetName ( ) : string
return	string

InitScriptDataGrid() public method

Init Script Data for Grid

public InitScriptDataGrid ( ) : void
return	void

InitScriptDataTable() public method

Init the Data Grid Table.

public InitScriptDataTable ( ) : void
return	void

QueryGUI_Resize() public method

public QueryGUI_Resize ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

QueryGui() public method

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

public QueryGui ( ) : System
return	System

RunScriptWithAskGui() public method

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
return	void

ShowScriptErrorToolStripMenuItem_Click() public method

Show error of the selected Script

public ShowScriptErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

UpdateTableFunctions() public method

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
return	void

_newTabWithFileDialogToolStripMenuItem_Click() public method

New Tab via File Dialog

public _newTabWithFileDialogToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

aboutToolStripMenuItem_Click() public method

About Window

public aboutToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnLoadScripts_Click() public method

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

public btnLoadScripts_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnRedo_Click() public method

public btnRedo_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnRunScriptForSqlWithAsk_Click() public method

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
return	void

btnRunScriptForSql_Click() public method

Run SQL and execute Script

public btnRunScriptForSql_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnSaveAll_Click() public method

Save all sql Tabs

public btnSaveAll_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnSaveAs_Click() public method

Save sql Tab As

public btnSaveAs_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnSave_Click() public method

Save sql Tab

public btnSave_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

btnUndo_Click() public method

public btnUndo_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

dataGridViewScripts_MouseClick() public method

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

public dataGridViewScripts_MouseClick ( object sender, MouseEventArgs e ) : void
sender	object
e	MouseEventArgs
return	void

helpToolStripMenuItem1_Click() public method

ShowHelp

public helpToolStripMenuItem1_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

lastSqlStringSentToEAToolStripMenuItem_Click() public method

Output the last from hoTools Query sent sql string to EA

public lastSqlStringSentToEAToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

loadStandardScriptsToolStripMenuItem_Click() public method

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

public loadStandardScriptsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

loadTabCtrlLToolStripMenuItem_Click() public method

CTRL+L Load TabPage from File

public loadTabCtrlLToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

reloadTabToolStripMenuItem_Click() public method

public reloadTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

runSqlTabToolStripMenuItem_Click() public method

public runSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

saveAllToolStripMenuItem_Click() public method

public saveAllToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

saveSqlTabAsToolStripMenuItem_Click() public method

public saveSqlTabAsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

saveSqlTabToolStripMenuItem_Click() public method

public saveSqlTabToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

settingsToolStripMenuItem_Click() public method

public settingsToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

showScriptToolStripMenuItem_Click() public method

Output the script code of the selected row

public showScriptToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

showSqlErrorToolStripMenuItem_Click() public method

Output the last EA SQL error

public showSqlErrorToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

tabControlSql_DrawItem() public method

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
return	void

tabControlSql_MouseDown() public method

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
return	void

templatesAndMacrosToolStripMenuItem_Click() public method

Output Help of macros and templates in a text editor

public templatesAndMacrosToolStripMenuItem_Click ( object sender, EventArgs e ) : void
sender	object
e	EventArgs
return	void

txtSearchTerm_KeyDown() public method

public txtSearchTerm_KeyDown ( object sender, KeyEventArgs e ) : void
sender	object
e	KeyEventArgs
return	void

txtSearchTerm_MouseDoubleClick() public method

public txtSearchTerm_MouseDoubleClick ( object sender, MouseEventArgs e ) : void
sender	object
e	MouseEventArgs
return	void