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