private void dgvSession_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { DataTable dt = DALDataAccess.GetSessionHashValue(this.dgvSession.GetRowCellStrValue(e.RowIndex, "SID")); if (dt.Rows.Count > 0) { DataTable dtSql = DALDataAccess.GetSessionSql(dt.Rows[0]["HASH"].ToString()); if (dtSql.Rows.Count > 0) { string sql = string.Empty; foreach (DataRow dr in dtSql.Rows) { sql += dr["SQL_TEXT"].ToString().Replace("\n", "\r\n"); } this.txtSessionQuery.Text = sql; } else { this.txtSessionQuery.Text = string.Empty; } } else { this.txtSessionQuery.Text = string.Empty; } this.txtSessionQuery.SelectAll(); }
private void SetOracleVersionLabel() { DataTable dt = DALDataAccess.GetOracleVersion(); if (dt.Rows.Count > 0) { this.tsslOracleVersion.Text = string.Format("[{0}]", dt.Rows[0][0].ToString()); } }
private void SearchSessionInfo() { this.Cursor = Cursors.WaitCursor; DataTable dt = DALDataAccess.GetSessionInfo(); this.dgvSession.DataSource = dt; this.Cursor = Cursors.Default; }
private void SearchLockList() { this.Cursor = Cursors.WaitCursor; DataTable dt = DALDataAccess.GetLockList(); this.dgvLock.DataSource = dt; this.Cursor = Cursors.Default; }
private void tsmiDeleteLock_Click(object sender, EventArgs e) { string msg = string.Format("{0},{1} Lock을 삭제하시겠습니까?", this.dgvLock.GetRowCellStrValue(this.dgvLock.CurrentRow.Index, "SID"), this.dgvLock.GetRowCellStrValue(this.dgvLock.CurrentRow.Index, "serial#")); if (DialogResult.Yes.Equals(MessageBox.Show(this, msg, ConstValue.MSGBOX_TITLE, MessageBoxButtons.YesNo, MessageBoxIcon.Information))) { DALDataAccess.DeleteLock(this.dgvLock.GetRowCellStrValue(this.dgvLock.CurrentRow.Index, "SID") + "," + this.dgvLock.GetRowCellStrValue(this.dgvLock.CurrentRow.Index, "serial#")); } this.SearchLockList(); }
private void lbxTableSpace_SelectedIndexChanged(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; this.lblTableSpaceName.Text = this.lbxTableSpace.Text; DataTable dtTableSpaceInfo = DALDataAccess.GetTableSpaceInfo(this.lbxTableSpace.Text); this.dgvTableSpace.DataSource = dtTableSpaceInfo; this.Cursor = Cursors.Default; }
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e) { if (this.tabControl1.TabPages.Count > 0) { if (this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.COLUMN)) { DataTable dt = DALDataAccess.GetTableColumns(this.mHt["USER"].ToString(), this.mHt["OBJECT_NAME"].ToString()); ucDataGridView dgv = this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Controls[0] as ucDataGridView; dgv.DataSource = dt; } else if (this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.DATA)) { string query = string.Format(@" SELECT * FROM {0}.{1} ", this.mHt["USER"].ToString(), this.mHt["OBJECT_NAME"].ToString()); ucDgvQuery dgvQuery = this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Controls[0] as ucDgvQuery; dgvQuery.Query = query; dgvQuery.ExecuteQuery(false, 0, false); } else if (this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.INDEX)) { DataTable dt = DALDataAccess.GetTableIndexInfo(this.mHt["USER"].ToString(), this.mHt["OBJECT_NAME"].ToString()); ucDataGridView dgv = this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Controls[0] as ucDataGridView; dgv.DataSource = dt; } else if (this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT)) { DataTable dtScript = DALDataAccess.GetObjectScript(this.mHt["USER"].ToString(), this.mHt["OBJECT_NAME"].ToString()); TextBox tbx = this.tabControl1.TabPages[this.tabControl1.SelectedIndex].Controls[0] as TextBox; tbx.Text = string.Format("{0};", dtScript.Rows[0]["SCRIPT"].ToString().Trim()).Replace("\n", "\r\n"); if (this.tabControl1.Tag.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TABLE)) { DataTable dtIndex = DALDataAccess.GetIndexByTableName(this.mHt["USER"].ToString(), this.mHt["OBJECT_NAME"].ToString()); if (dtIndex.Rows.Count > 0) { foreach (DataRow dr in dtIndex.Rows) { dtScript = DALDataAccess.GetObjectScript(this.mHt["USER"].ToString(), dr["INDEX_NAME"].ToString()); tbx.Text += "\r\n\r\n\r\n"; tbx.Text += string.Format("{0};", dtScript.Rows[0]["SCRIPT"].ToString().Trim()).Replace("\n", "\r\n"); } } } } } }
private void InitCombo() { this.Cursor = Cursors.WaitCursor; DataTable dtUserList = DALDataAccess.GetUserList(); if (dtUserList.Rows.Count > 0) { this.cboUserList.DataSource = dtUserList; } this.cboUserList.SelectedValue = Common.Comm.DBWorker.GetUserID().ToUpper(); this.User = this.cboUserList.Text; this.Cursor = Cursors.Default; }
public DataTable GetObjectListByObjectName(string aUser, string aObjectName) { this.Cursor = Cursors.WaitCursor; DataTable dt = new DataTable(); if (this.cboObjectList.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.TABLE)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TABLE, aObjectName); } else if (this.cboObjectList.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.VIEW)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.VIEW, aObjectName); } this.Cursor = Cursors.Default; return(dt); }
private void GetTableSpaceList() { this.lbxTableSpace.Items.Clear(); DataTable dt = DALDataAccess.GetTableSpaceList(); foreach (DataRow dr in dt.Rows) { this.lbxTableSpace.Items.Add(dr["TABLESPACE_NAME"].ToString()); } if (dt.Rows.Count > 0) { this.lbxTableSpace.SelectedIndex = 0; } else { this.dgvTableSpace.DataSource = null; } }
private void SetColumnInfo() { DataTable dt = DALDataAccess.GetTableColumns(Common.Comm.DBWorker.GetUserID().ToUpper(), this.lbxObject.Text); this.dgvColumnInfo.DataSource = dt; }
public void Search(Hashtable aHt) { this.Cursor = Cursors.WaitCursor; this.tabControl1.TabPages.Clear(); this.mHt = aHt; DataTable dt = DALDataAccess.GetObjectListByObjectName(this.mHt["USER"].ToString(), this.mHt["OBJECT_NAME"].ToString()); if (dt.Rows.Count < 1) { this.Cursor = Cursors.Default; this.Clear(); return; } this.lblInfo.Text = string.Format("[{0}] Created:{1} Last DDL:{2}", this.mHt["OBJECT_NAME"].ToString(), dt.Rows[0]["CREATED"].ToString(), dt.Rows[0]["LAST_DDL_TIME"].ToString()); this.tabControl1.Tag = dt.Rows[0]["OBJECT_TYPE"].ToString(); if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TABLE)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.COLUMN); this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.DATA); this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.INDEX); this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.VIEW)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.COLUMN); this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.DATA); this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.FUNCTION)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.PROCEDURE)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TRIGGER)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.INDEX)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.SEQUENCE)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } else if (dt.Rows[0]["OBJECT_TYPE"].ToString().Equals(Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.PACKAGE)) { this.tabControl1.TabPages.Add(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT); } foreach (TabPage tp in this.tabControl1.TabPages) { if (tp.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.COLUMN) || tp.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.INDEX)) { ucDataGridView dgv = new ucDataGridView(); dgv.Dock = DockStyle.Fill; dgv.AllowUserToAddRows = false; dgv.AllowUserToDeleteRows = false; dgv.AllowUserToResizeRows = false; dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; dgv.ReadOnly = true; dgv.DataSourceChanged += dgv_DataSourceChanged; tp.Controls.Add(dgv); } else if (tp.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.DATA)) { ucDgvQuery dgvQuery = new ucDgvQuery(); dgvQuery.Dock = DockStyle.Fill; dgvQuery.AllowUserToAddRows = false; dgvQuery.AllowUserToDeleteRows = false; dgvQuery.AllowUserToResizeRows = false; dgvQuery.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; dgvQuery.ReadOnly = true; tp.Controls.Add(dgvQuery); } else if (tp.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectInfo_DISPLAY.SCRIPT)) { TextBox tbx = new TextBox(); tbx.ReadOnly = true; tbx.Multiline = true; tbx.Dock = DockStyle.Fill; tp.Controls.Add(tbx); } } this.tabControl1_SelectedIndexChanged(this.tabControl1, null); this.Cursor = Cursors.Default; }
private void GetObjectList(string aUser = "") { this.Cursor = Cursors.WaitCursor; DataTable dt = new DataTable(); ListBox lbx = this.tabControl1.SelectedTab.Controls[0] as ListBox; lbx.Items.Clear(); if (string.IsNullOrEmpty(aUser)) { aUser = this.ucUserList1.User; } if (string.IsNullOrEmpty(this.txtSearch.Text)) { if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.TABLE)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TABLE); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.VIEW)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.VIEW); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.FUNCTION)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.FUNCTION); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.PROCEDURE)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.PROCEDURE); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.TRIGGER)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TRIGGER); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.INDEX)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.INDEX); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.SEQUENCE)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.SEQUENCE); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.PACKAGE)) { dt = DALDataAccess.GetObjectList(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.PACKAGE); } } else { if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.TABLE)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TABLE, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.VIEW)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.VIEW, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.FUNCTION)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.FUNCTION, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.PROCEDURE)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.PROCEDURE, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.TRIGGER)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.TRIGGER, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.INDEX)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.INDEX, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.SEQUENCE)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.SEQUENCE, this.txtSearch.Text); } else if (this.tabControl1.SelectedTab.Text.Equals(Common.Definition.ConstValue.DBViewer_ObjectList_DISPLAY.PACKAGE)) { dt = DALDataAccess.GetObjectListByObjectName(aUser, Common.Definition.ConstValue.DBViewer_ObjectList_VALUE.PACKAGE, this.txtSearch.Text); } } foreach (DataRow dr in dt.Rows) { lbx.Items.Add(dr["OBJECT_NAME"].ToString()); } this.Cursor = Cursors.Default; }