DevExpress gridView GridView分层

下面的代码来自GridTutorials   v10.1

RunTimeUsing

 

 

 

DataSet ds =  new DataSet();
         private  void GridRunTimeUsing_Load( object sender, System.EventArgs e) {
            InitNWindData();
            GridAdjustment();
            GridEditorsAdjustment();
            GridAppearance();
        }
         ///   <summary>
         ///  DataSet 数据源，表之间的关系
         ///   </summary>
         ///   <param name="connectionString"></param>
         protected  override  void InitMDBData( string connectionString) {
            OleDbDataAdapter oleDBAdapter1 =  new OleDbDataAdapter( " SELECT * FROM Customers ", connectionString);
            OleDbDataAdapter oleDBAdapter2 =  new OleDbDataAdapter( " SELECT * FROM Orders ", connectionString);
            OleDbDataAdapter oleDBAdapter3 =  new OleDbDataAdapter( " SELECT * FROM [Order Details] ", connectionString);
            OleDbDataAdapter oleDBAdapter4 =  new OleDbDataAdapter( " SELECT * FROM Employees ", connectionString);
            OleDbDataAdapter oleDBAdapter5 =  new OleDbDataAdapter( " SELECT * FROM Products ", connectionString);

            oleDBAdapter1.Fill(ds,  " Customers ");
            oleDBAdapter2.Fill(ds,  " Orders ");
            oleDBAdapter3.Fill(ds,  " Order Details ");
            oleDBAdapter4.Fill(ds,  " Employees ");
            oleDBAdapter5.Fill(ds,  " Products ");

            ds.Relations.Add( " Orders ",
                ds.Tables[ " Customers "].Columns[ " CustomerID "],
                ds.Tables[ " Orders "].Columns[ " CustomerID "]);

            ds.Relations.Add( " OrderDetails ",
                ds.Tables[ " Orders "].Columns[ " OrderID "],
                ds.Tables[ " Order Details "].Columns[ " OrderID "]);

            ds.Relations.Add( " Employees ",
                ds.Tables[ " Orders "].Columns[ " EmployeeID "],
                ds.Tables[ " Employees "].Columns[ " EmployeeID "],  false);

            gridControl1.DataSource = ds.Tables[ " Customers "];
            gridControl1.MainView.PopulateColumns();
        }
         protected  override  void InitXMLData( string dataFileName) {
        }
         ///   <summary>
         ///  多个GridView，分层的主要是通过2个GridView之间的关系 gridControl1.LevelTree.Nodes.Add("RelationName", gvs[i]);。
         ///   </summary>
         private  void GridAdjustment()
        {
            gridControl1.MainView.KeyDown +=  new KeyEventHandler(gridView_KeyDown);
            GridView[] gvs =  new GridView[ 4];
            ColorMaker[] colorMakers =  new ColorMaker[ 4];
             string[] options =  new String[] {
                                                 " EvenRow ",
                                                 " OddRow ",
                                                 " FocusedRow ",
                                                 " FocusedCell ",
                                                 " GroupRow ",
                                                 " HeaderPanel ",
                                                 " GroupPanel ",
                                                 " HorzLine ",
                                                 " VertLine "};
            gvs[ 0] = gridView1;

            colorMakers[ 0] =  new ColorMaker(Color.DimGray, Color.WhiteSmoke);
            colorMakers[ 1] =  new ColorMaker(Color.DarkCyan, Color.LightCyan);
            colorMakers[ 2] =  new ColorMaker(Color.DarkGoldenrod, Color.LightGoldenrodYellow);
            colorMakers[ 3] =  new ColorMaker(Color.Navy, Color.Lavender);

             for ( int i =  0; i <  4; i++)
            {
                 string prefix =  "";
                 int basefontsize =  8, backColor =  100, foreColor =  0, font =  0;
                FontStyle fstyle = FontStyle.Regular;

                 if (i ==  0) basefontsize =  9;

                 if (i >  0)
                {
                    gvs[i] =  new GridView(gridControl1);
                    gvs[i].KeyDown +=  new KeyEventHandler(gridView_KeyDown);
                    gvs[i].OptionsDetail.ShowDetailTabs =  true;
                    gvs[i].OptionsDetail.EnableDetailToolTip =  true;
                    prefix = ds.Relations[i -  1].RelationName;
                }

                 if (i <  2)
                    gvs[i].OptionsView.ColumnAutoWidth =  false;

                 foreach ( string option  in options)
                {
                     switch (option)
                    {
                         case  " EvenRow ":
                            backColor =  100;
                            foreColor =  0;
                             break;
                         case  " OddRow ":
                            backColor =  90;
                            foreColor =  0;
                             break;
                         case  " FocusedRow ":
                            backColor =  10;
                            foreColor =  90;
                            fstyle = FontStyle.Bold;
                             break;
                         case  " FocusedCell ":
                            backColor =  200;
                            foreColor =  0;
                             break;
                         case  " GroupRow ":
                            backColor =  60;
                            foreColor =  100;
                            fstyle = FontStyle.Italic;
                             break;
                         case  " HeaderPanel ":
                            backColor =  30;
                            foreColor =  100;
                            font =  1;
                            fstyle = FontStyle.Bold;
                             break;
                         case  " GroupPanel ":
                            backColor =  0;
                            foreColor =  100;
                            font =  2;
                            fstyle = FontStyle.Bold;
                             break;
                         case  " HorzLine ":
                         case  " VertLine ":
                            backColor =  0;
                            foreColor =  0;
                            font =  0;
                             break;
                    }
                    gvs[i].Appearance.GetAppearance(option).BackColor = colorMakers[i].ProduceColor(backColor);
                    gvs[i].Appearance.GetAppearance(option).BorderColor = colorMakers[i].ProduceColor(backColor);
                    gvs[i].Appearance.GetAppearance(option).ForeColor = colorMakers[i].ProduceColor(foreColor);
                    gvs[i].Appearance.GetAppearance(option).Font =  new Font(DevExpress.Utils.AppearanceObject.DefaultFont.FontFamily, basefontsize + font, fstyle);
                }

                 if (gvs[i].OptionsView.ShowGroupPanel)
                    gvs[i].OptionsView.ShowGroupPanel =  false;

                gvs[i].DetailHeight =  500;
                gvs[i].PaintStyleName =  " MixedXP ";
// 关键   Gridview 添加关系
                 if (prefix ==  " Orders ")
                    gridControl1.LevelTree.Nodes.Add(prefix, gvs[i]);
                 else  if (prefix !=  "")
                    gridControl1.LevelTree.Nodes[ " Orders "].Nodes.Add(prefix, gvs[i]);
            }
        }

效果:

 

想起做这个效果的表，是因为Bom层次显示的时候需要这样。

如果加一列CheckBox，可以在计算物理需求时选择参加计算的物料。

 

 

转载于:https://www.cnblogs.com/chirs888888/archive/2012/03/28/2421925.html