private void ucDgvQuery_DataSourceChanged(object sender, EventArgs e)
{
ucDgvQuery dgv = sender as ucDgvQuery;
if (dgv != null)
{
dgv.AutoResizeColumn();
}
}
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");
}
}
}
}
}
}
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;
}