private void gridControlUserTable_DoubleClick(object sender, EventArgs e)
{
try
{
//gridView datatable GridLevelNode都用同一個名字
//ViewCaption中放類別, 1, 用戶相關表. 0, 用戶無關表
GridView curView = (DevExpress.XtraGrid.Views.Grid.GridView)gridControlUserTable.FocusedView; //當前的GridView
curView.MasterRowExpanding += new MasterRowCanExpandEventHandler(curView_MasterRowExpanding);
curView.MasterRowExpanded += new CustomMasterRowEventHandler(curView_MasterRowExpanded);
string viewName = curView.Name;
string id = "view" + icount.ToString();
int ihandle = curView.FocusedRowHandle; //當前的行號
DataRow dr = curView.GetDataRow(ihandle); //當前的行
GridView newGridView = null;
DataTable newDataTable = null;
DevExpress.XtraGrid.GridLevelNode gridLevel = null;
icount++;
#region 頂層的gridView
if (curView.Name == "gridViewParent")//頂層的gridView
{
string tableEName = dr["tableEName"].ToString();
string supplierRelated = dr["supplierRelated"].ToString();
#region 頂層
newGridView = new GridView();
newGridView.Name = id;
newGridView.OptionsView.ShowGroupPanel = false;
newGridView.OptionsBehavior.Editable = false;
newGridView.OptionsDetail.ShowDetailTabs = false;
newGridView.OptionsCustomization.AllowColumnMoving = false;
newGridView.OptionsBehavior.AutoExpandAllGroups = true;
this.gridControlUserTable.ViewCollection.Add(newGridView);
RelatedTableRecord[] relatedTableInfoArray = null;
UnrelatedTableRecord[] unRelatedTableInfoArray = null;
if (supplierRelated == "1")//廠商相關
{
relatedTableInfoArray = PublicFunction.GetRelatedTableInfos(tableEName, btime, etime);
if (relatedTableInfoArray == null || relatedTableInfoArray.Length == 0)
{
return;
}
CollectCommon.SetGridViewColumn(newGridView, "Config\\CollectMonitor\\supplierRelatedColumn.xml", "/Head");
newGridView.ViewCaption = "1";
}
else if (supplierRelated == "0")//廠商無關
{
unRelatedTableInfoArray = PublicFunction.GetUnRelatedTableInfos(tableEName, "", btime, etime);
if (unRelatedTableInfoArray == null || unRelatedTableInfoArray.Length == 0)
{
return;
}
CollectCommon.SetGridViewColumn(newGridView, "Config\\CollectMonitor\\supplierUnRelatedColumn.xml", "/Head");
newGridView.ViewCaption = "0";
}
newDataTable = new DataTable(id);
CollectCommon.SetDataTableColumn(newGridView, newDataTable);
if (supplierRelated == "1")//廠商相關
{
CollectCommon.FillTableData(newDataTable, relatedTableInfoArray);
}
else//廠商無關
{
CollectCommon.FillTableData(newDataTable, unRelatedTableInfoArray);
}
ds.Tables.Add(newDataTable);
gridLevel = new DevExpress.XtraGrid.GridLevelNode();
gridLevel.LevelTemplate = newGridView;
gridLevel.RelationName = id;
gridControlUserTable.LevelTree.Nodes.Add(gridLevel);
DataRelation dataRelation = new DataRelation(id, ds.Tables["parent"].Columns["tableEName"], ds.Tables[id].Columns["tableEName"], false);
ds.Relations.Add(dataRelation);
newGridView.RefreshData();
gridViewParent.RefreshData();
#endregion
}
#endregion
#region 非頂層表
else//非頂層表
{
if (curView.ViewCaption == "1")//廠商相關表,再鉆取最后一層,廠商無關的信息表,就鉆取到頭了.
{
#region
string tableEName = dr["tableEName"].ToString();
string supplier = dr["supplier"].ToString();
UnrelatedTableRecord[] unRelatedTableInfoArray = null;
unRelatedTableInfoArray = PublicFunction.GetUnRelatedTableInfos(tableEName, supplier, btime, etime);
if (unRelatedTableInfoArray == null || unRelatedTableInfoArray.Length == 0)
{
return;
}
newGridView = new GridView();
newGridView.Name = id;
newGridView.OptionsView.ShowGroupPanel = false;
newGridView.OptionsBehavior.Editable = false;
newGridView.OptionsDetail.ShowDetailTabs = false;
newGridView.OptionsCustomization.AllowColumnMoving = false;
newGridView.OptionsBehavior.AutoExpandAllGroups = true;
newGridView.ViewCaption = "0";
this.gridControlUserTable.ViewCollection.Add(newGridView);
CollectCommon.SetGridViewColumn(newGridView, "Config\\CollectMonitor\\supplierUnRelatedColumn.xml", "/Head");
newDataTable = new DataTable(id);
CollectCommon.SetDataTableColumn(newGridView, newDataTable);
CollectCommon.FillTableData(newDataTable, unRelatedTableInfoArray);
ds.Tables.Add(newDataTable);
gridLevel = new DevExpress.XtraGrid.GridLevelNode();
gridLevel.LevelTemplate = newGridView;
gridLevel.RelationName = id;
string parentTableName = curView.Name;
string parentLevelName = curView.Name;
//AddGridLevelNode(gridControlUserTable, parentLevelName, gridLevel);
gridControlUserTable.LevelTree.Nodes[0].Nodes.Add(gridLevel);
DataColumn[] parentColumns = new DataColumn[2];
DataColumn[] childColumns = new DataColumn[2];
parentColumns[0] = ds.Tables[parentTableName].Columns["tableEName"];
parentColumns[1] = ds.Tables[parentTableName].Columns["supplier"];
childColumns[0] = ds.Tables[id].Columns["tableEName"];
childColumns[1] = ds.Tables[id].Columns["supplier"];
DataRelation dataRelation = new DataRelation(id, parentColumns, childColumns, false);
//DataRelation dataRelation = new DataRelation(id, parentColumns[0], childColumns[0], false);
ds.Relations.Add(dataRelation);
curView.RefreshData();
#endregion
}
else if (curView.ViewCaption == "0")//廠商無關表
{
}
}
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}