//关系数据库导航栏双击事件
private void ucNaviRDB_TreeList_DoubleClick(object sender, EventArgs e)
{
try
{
TreeList tree = sender as TreeList;
TreeListHitInfo hi = tree.CalcHitInfo(tree.PointToClient(Control.MousePosition));
if (hi.Node != null)
{
string nodeName = (string)hi.Node["TABLE_NAME"];
//如果已经有这个tabPage
XtraTabPage ifTabPage = ComponentOperator.IfHasTabPage(nodeName, this.xtraTabControl_Main);
if (ifTabPage != null)
{
this.xtraTabControl_Main.SelectedTabPage = ifTabPage;
return;
}
//如果不包含该TabPage，则新建
DataTable dt = SQLServerConnection.GetDataByTableName(nodeName);
if (dt == null)
{
MessageBox.Show("获取数据失败。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//表格控件
SpreadsheetControl ssc = new SpreadsheetControl();
IWorkbook workbook = ssc.Document;
workbook.BeginUpdate();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Name = nodeName;
worksheet.Import(dt, true, 0, 0); //import方法需要添加DevExpress.Docs命名空间
workbook.EndUpdate();
//TabPage
XtraTabPage xtp = new XtraTabPage();
xtp.Text = nodeName;
xtp.Controls.Add(ssc);
ssc.Dock = DockStyle.Fill;
this.xtraTabControl_Main.TabPages.Add(xtp);
this.xtraTabControl_Main.SelectedTabPage = xtp;
ssc.Refresh();
xtp.Refresh();
this.xtraTabControl_Main.Refresh();
this.Refresh();
}
}
catch
{
}
}
