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