DevXpress控件:第一篇:将Master_Details关系进行到底XtraPivotGridControl控件

一. 控件说明: XtraPivotGridControl&＃xff1b;数据控件

二. 控件特点:

1. 支持行, 列字段拖动, 对调

   支持行, 列字段的添加, 移除

   支持数据字段的添加, 移除, 对调

2. 支持以行, 列字段排序

  支持以过滤字段排序

3. 支持行, 列字段过滤                                          

4. 支持行, 列字段的归类, 即形成父子层

横向和竖向同时形成树结构, 可收缩展开

三.测试数据: 1.数据库: sqlserver2000; Norwind

     2.关联表: Customers; Orders; Order_Details; Products;

     3.DevExpress 版本: V8.1

四. 运行截图:

1.       行字段: 客户名称&＃xff1b;订单号

列字段: 产品名称

数据字段: 商品单价&＃xff1b;购买数量

过滤字段: 客户公司名称&＃xff1b;所签合同名&＃xff1b;订购日期&＃xff1b;截止日期&＃xff1b;提货日期

 2. 以客户名称进行过滤

3.   拖动行字段和列字段(此处演示对调)

产品名称作为行, 客户名称作为列显示

同时将过滤区的字段 订购日期作加入列中

这样重构树: 客户名称à订购日期

数据字段移除商品单价, 只保留购买数量

五. 程序代码

1. 此处全部以 RunTime 进行设计

2. 绑定数据源:

(1):selectSql:

 this.sqlstr &＃61; "select a.*, b.*, c.*, d.* from Orders a inner join Order_Details b on a.OrderID&＃61;b.OrderID "

&＃43; " inner join Customers c on a.CustomerID&＃61;c.CustomerID inner join Products d on b.ProductID&＃61;d.ProductID;";

(2): DataSource ; DataMember;

this.pivotGridControl1.DataSource &＃61; this.database.RunReturnDataSet(this.sqlstr);

this.pivotGridControl1.DataMember &＃61; this.database.dataSet.Tables[0].TableName;

3.      运行时添加字段

子逸制作--动态添加字段
///

/// 给消费链添加添加字段
///

private void AddOrdersColumns()
{
//Customers表
PivotGridField customerID &＃61; new PivotGridField();
customerID.FieldName &＃61; "CustomerID";
customerID.Caption &＃61; "客户名称";
customerID.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.RowArea;

PivotGridField companyName &＃61; new PivotGridField();
companyName.FieldName &＃61; "CompanyName";
companyName.Caption &＃61; "客户公司名称";
companyName.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.FilterArea;
companyName.Width &＃61; 150;

PivotGridField contactTitle &＃61; new PivotGridField();
contactTitle.FieldName &＃61; "ContactTitle";
contactTitle.Caption &＃61; "所签合同名";
contactTitle.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.FilterArea;


//Orders表
PivotGridField orderID &＃61; new PivotGridField();
orderID.FieldName &＃61; "OrderID";
orderID.Caption &＃61; "订单号";
orderID.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.RowArea;

PivotGridField orderDate &＃61; new PivotGridField();
orderDate.FieldName &＃61; "OrderDate";
orderDate.Caption &＃61; "订购日期";
orderDate.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.FilterArea;

PivotGridField requiredDate &＃61; new PivotGridField();
requiredDate.FieldName &＃61; "RequiredDate";
requiredDate.Caption &＃61; "截止日期";
requiredDate.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.FilterArea;

PivotGridField shippedDate &＃61; new PivotGridField();
shippedDate.FieldName &＃61; "ShippedDate";
shippedDate.Caption &＃61; "提货日期";
shippedDate.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.FilterArea;

//OrderDetails
PivotGridField unitPrice &＃61; new PivotGridField();
unitPrice.FieldName &＃61; "UnitPrice";
unitPrice.Caption &＃61; "商品单价";
unitPrice.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.DataArea;


PivotGridField Quantity &＃61; new PivotGridField();
Quantity.FieldName &＃61; "Quantity";
Quantity.Caption &＃61; "购买数量";
Quantity.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.DataArea;


//Product表
PivotGridField productName &＃61; new PivotGridField();
productName.FieldName &＃61; "ProductName";
productName.Caption &＃61; "产品名称";
productName.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.ColumnArea;

//添加到控制中
this.pivotGridControl1.Fields.Add(customerID);
this.pivotGridControl1.Fields.Add(companyName);
this.pivotGridControl1.Fields.Add(contactTitle);

this.pivotGridControl1.Fields.Add(orderID);

this.pivotGridControl1.Fields.Add(orderDate);
this.pivotGridControl1.Fields.Add(requiredDate);
this.pivotGridControl1.Fields.Add(shippedDate);

this.pivotGridControl1.Fields.Add(unitPrice);
this.pivotGridControl1.Fields.Add(Quantity);

this.pivotGridControl1.Fields.Add(productName);


}

2.      运行时改变字段的显示区域

 customerID.Area &＃61; DevExpress.XtraPivotGrid.PivotArea.RowArea;

五. 属性

1. 允许拖动

this.pivotGridControl1.OptionsCustomization.AllowDrag &＃61; true;

2. 允许排序

this.pivotGridControl1.OptionsCustomization.AllowSort &＃61; true;

3. 允许过滤

 this.pivotGridControl1.OptionsCustomization.AllowFilter &＃61; true;

六: 总结后记

1.      此控件较为灵活&＃xff1b;对于 Master_Details 关系表处理的相当好&＃xff1b;

2.      此控件数据区只能显示数字类型字段, 类似于统计分析&＃xff1b;

3.      后面会有更多的 DevExpress 控件介绍给大家

4.      这里只介绍控件的简单使用&＃xff1b;如需更复杂的技术支持或交流请与作者联系&＃xff1b;

QQ: 915571300   子逸

5.       版权所有: 子逸(博客园)&＃xff1b;转载请注明出处&＃xff1b;