基本grid的用法

来源:互联网 发布:时钟 知乎 编辑:程序博客网 时间:2024/03/29 19:06

1.基本grid的用法

数据绑定:

 #region 数据绑定
        /// <summary>
        /// 数据绑定
        /// </summary>
        /// <param name="TableA">数据库中要查询的数据表</param>
        /// <param name="TableB">虚拟的数据表供程序中调用</param>
        private void MyDataBound(string TableA,string TableB)
        {
                    SqlConnection myConn = new SqlConnection("Data Source=JIAHE-04FF98FBA;Initial Catalog=test;Integrated Security=True");
                    DataSet ds = new DataSet();
                    SqlDataAdapter oleDbDataAdapter = new SqlDataAdapter("SELECT * FROM " + TableA, myConn);
                    oleDbDataAdapter.Fill(ds, TableB);
                    gridControl1.DataSource = ds.Tables[TableB];
        }
        #endregion

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


     }

原创粉丝点击