学习XtraGrid

1.基本grid的用法

1.1 gridControl-->view-->gridView

 绑定到grid上的字段可以拖动删除，在任意字段上右键点column chooser 可以将删除的字段添加进来

字段上右键选择实现选定需要的信息和排序

字段上右键选择分组(group by  column)，也可以直接将字段拖到上面实现分组

字段上右键选择group by box后可以取消分组栏，（不能实现拖动分组，但可以选择分组）

字段上右键选择best fit可以实现该字段最佳宽度（便于查看）

 1.2 gridControl-->view-->cardView

以卡片形式存放数据

可以自己设定过滤选项

1.3 gridControl-->view-->banderGridView

将字段分段显示，前提是给gridControl先绑定一个dataset

动态绑定的时候不能分段，也不能分行

1.3 gridControl-->view-->advBanderGridView

高级分段显示，动态绑定的字段可以在前台向下拖动后分段，但效果不好，相当于分行显示的样子

1.4 else

可以通过create ner view增加一个view ，但程序只显示你选定的view

zoom的使用  快速上升，也就是选择子项后单独显示（上到最高显示）

1.5 feature browser

-->priview  可以指定在每行中预览的字段

-->filtering 可以自动过滤（optingview.showAutoFiterRow）

1.7 Master-Detail 绑定的问题
首先在gridControl1中指定dataSource 的绑定是主表
然后在level设计器中添加层（retrieve details）
最后用代码绑定：
using (SqlConnection con = new SqlConnection(SqlHepler.CONN_STRING))
            {
                //SqlDataAdapter sda1 = new SqlDataAdapter("select * from Orders",con);
                //sda1.Fill(this.northwindDataSet.Orders);

                SqlDataAdapter sda2 = new SqlDataAdapter("select * from [Order Details]",con);
                sda2.Fill(this.northwindDataSet.Order_Details);
            }

1.8 summary的用法

            //If the GridOptionsView.ShowFooter option is set,
            //the summary(of course some else can ) can be displayed within the footer cell.
            gridView1.OptionsView.ShowFooter = true;

            //初始化，也可以不用指定
            colOrderID.SummaryItem.FieldName = "OrderID";
            colOrderID.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;

2.XtraGrid的打印

借用别人写的一个类

class DevPrint
    {

        //*********************字段*********************
        private string pageHeaderName="";
        private string pageFooterName="";
        private bool isPrintPage=true;
        private bool isPrintDate=true;
        private int headerLocation=1;
        private int footerLocation=1;
        private int pageLocation=3;
        private int dateLocation=5;
        private bool enableEditPage = true;
        private System.Drawing.Font pageHeaderFont = null;
        private System.Drawing.Font pageFooterFont = null;
        private System.Drawing.Printing.Margins devMargins = null;
        private System.Drawing.Printing.PaperKind devPaperKind = System.Drawing.Printing.PaperKind.A4;//可以自定义修改纸张
        private DevExpress.XtraPrinting.PageHeaderArea PHA = new DevExpress.XtraPrinting.PageHeaderArea();
        private DevExpress.XtraPrinting.PageFooterArea PFA = new DevExpress.XtraPrinting.PageFooterArea();
        //*********************字段*********************

        //*********************属性*********************
        //标题
        public string PageHeaderName
        {
           get
           {
               return pageHeaderName;
           }
           set
           {
               pageHeaderName=value;
           }
        }
       
        //页脚
        public string PageFooterName
        {
           get
           {
               return pageFooterName;
           }
           set
           {
               pageFooterName = value;
           }
        }

        //是否打印页数
        public bool IsPrintPage
        {
           get
           {
               return isPrintPage;
           }
           set
           {
               isPrintPage = value;
           }
        }

        //是否打印时间
        public bool IsPrintDate
        {
           get
           {
               return isPrintDate;
           }
           set
           {
               isPrintDate = value;
           }
        }

        //header的位置（左，中，右）
        public int HeaderLocation
        {
           get
           {
               return headerLocation;
           }
           set
           {
               headerLocation=value;
           }
        }

        //footer的位置（左，中，右）
        public int FooterLocation
        {
           get
           {
               return footerLocation;
           }
           set
           {
               footerLocation=value;
           }
        }

        //页数的位置
        public int PageLocation
        {
           get
           {
               return pageLocation;
           }
           set
           {
               pageLocation=value;
           }
        }

        //时间的位置
        public int DateLocation
        {
           get
           {
               return dateLocation;
           }
           set
           {
               dateLocation=value;
           }
        }
          
        //是否允许编辑页面
        public bool EnableEditPage
        {
           get
           {
               return enableEditPage;
           }
           set
           {
               enableEditPage = value;
           }
        }

        //标题字体
        public System.Drawing.Font PageHeaderFont
        {
           get
           {
               return pageHeaderFont;
           }
           set
           {
               pageHeaderFont = value;
           }
        }

        //页脚字体
        public System.Drawing.Font PageFooterFont
        {
           get
           {
               return pageFooterFont;
           }
           set
           {
               pageFooterFont = value;
           }
        }

        //页边距
        public System.Drawing.Printing.Margins DevMargins
        {
           get
           {
               return devMargins;
           }
           set
           {
               devMargins = value;
           }
        }

        //纸张类型
        public System.Drawing.Printing.PaperKind DevPaperKind
        {
           get
           {
               return devPaperKind;
           }
           set
           {
               devPaperKind = value;
           }
        }
        //*********************字段*********************

        private void PageHeaderFooterSettings()
        {
            PHA.Content.Clear();
            PFA.Content.Clear();
            string[] stringsPHA = new string[] {"","",""};
            string[] stringsPFA = new string[] {"","",""};
            switch(headerLocation)
            {
                case 0:stringsPHA[0]=pageHeaderName;
                 break;
                case 1:stringsPHA[1]=pageHeaderName;
                 break;
                case 2:stringsPHA[2]=pageHeaderName;
                 break;
                default:stringsPHA[1]=pageHeaderName;
                 break;
            };
            switch(footerLocation)
            {
                case 0:stringsPFA[0]=pageFooterName;
                 break;
                case 1:stringsPFA[1]=pageFooterName;
                 break;
                case 2:stringsPFA[2]=pageFooterName;
                 break;
                default:stringsPFA[1]=pageFooterName;
                 break;
            };
            if (isPrintPage)
            {
                switch(pageLocation)
                {
                     case 0:stringsPHA[0]=stringsPHA[0]+"[Page # of Pages #]";
                      break;
                     case 1:stringsPHA[1]=stringsPHA[1]+"[Page # of Pages #]";
                      break;
                     case 2:stringsPHA[2]=stringsPHA[2]+"[Page # of Pages #]";
                      break;
                     case 3:stringsPFA[2]=stringsPFA[2]+"[Page # of Pages #]";
                      break;
                     case 4:stringsPFA[1]=stringsPFA[1]+"[Page # of Pages #]";
                      break;
                     case 5:stringsPFA[0]=stringsPFA[0]+"[Page # of Pages #]";
                      break;
                     default:stringsPFA[2]=stringsPFA[2]+"[Page # of Pages #]";
                      break;
                };
            }
            if (isPrintDate)
            {
                switch(dateLocation)
                {
                     case 0:stringsPHA[0]=stringsPHA[0]+"[Date Printed]";
                      break;
                     case 1:stringsPHA[1]=stringsPHA[1]+"[Date Printed]";
                      break;
                     case 2:stringsPHA[2]=stringsPHA[0]+"[Date Printed]";
                      break;
                     case 3:stringsPFA[2]=stringsPFA[2]+"[Date Printed]";
                      break;
                     case 4:stringsPFA[1]=stringsPFA[1]+"[Date Printed]";
                      break;
                     case 5:stringsPFA[0]=stringsPFA[0]+"[Date Printed]";
                      break;
                     default:stringsPFA[0]=stringsPFA[0]+"[Date Printed]";
                      break;
                };
            }
            PHA.Content.AddRange(stringsPHA);
            PFA.Content.AddRange(stringsPFA);
            if (pageHeaderFont != null)
            {
                try
                {
                    PHA.Font = pageHeaderFont;
                }
                catch
                {
                    PHA.Font = new Font(new System.Drawing.FontFamily("楷体_GB2312"),20,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point);
                }
            }
            else
            {
                PHA.Font = new Font(new System.Drawing.FontFamily("楷体_GB2312"),20,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point);
            }
            if (pageFooterFont != null)
            {
                try
                {
                    PFA.Font = pageFooterFont;
                }
                catch
                {
                    PFA.Font = new Font(new System.Drawing.FontFamily("楷体_GB2312"),9,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point);
                }
            }
        }

        public void ShowDevPreview(DevExpress.XtraPrinting.IPrintable printComponent)
        {
            PageHeaderFooterSettings();
            DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem();
            DevExpress.XtraPrinting.PrintableComponentLink pc =new   DevExpress.XtraPrinting.PrintableComponentLink();
            pc.Component = printComponent;
            pc.Landscape = true;
            //是否指定页边距尺寸
            if (devMargins != null)
                        pc.Margins = devMargins;
            //是否定义纸张
            if (devPaperKind != System.Drawing.Printing.PaperKind.A4)
               pc.PaperKind = devPaperKind;
            //标题和页脚的显示
            pc.PageHeaderFooter =  new DevExpress.XtraPrinting.PageHeaderFooter(PHA,PFA);
            pc.CreateDocument(ps);
            pc.EnablePageDialog = enableEditPage;
            pc.ShowPreview();
         } 

    }