protected virtual void OnLoaded() { if (PivotGridControl != null && object.Equals(PivotGridControl.RowTotalsLocation, FieldRowTotalsLocation.Tree)) { PivotGridControl.BestFit(FieldArea.RowArea, true, false); } }
private void SetPivotGridData(IEnumerable <ResultItem> dt, PivotGridControl pivotGrid) { this.BindBegin(pivotGrid); this.BindDo(dt, pivotGrid); this.BindEnd(pivotGrid); pivotGrid.BestFit(); }
private void SetPivotGridFields(PivotGridControl pivotGrid) { pivotGrid.Fields.Clear(); var r1 = pivotGrid.AddFieldRowArea <ResultItem>((c) => c.LineID); r1.Caption = "LINE_ID"; var r2 = pivotGrid.AddFieldRowArea <ResultItem>((c) => c.DesignID); r2.Caption = "DESIGN_ID"; var r3 = pivotGrid.AddFieldRowArea <ResultItem>((c) => c.ProductID); r3.Caption = "PRODUCT_ID"; var r4 = pivotGrid.AddFieldRowArea <ResultItem>((c) => c.ProcessID); r4.Caption = "PROCESS_ID"; var r5 = pivotGrid.AddFieldRowArea <ResultItem>((c) => c.StepID); r5.Caption = "STEP_ID"; var r6 = pivotGrid.AddFieldRowArea <ResultItem>((c) => c.Sequence); r6.Caption = "SEQUENCE"; var c1 = pivotGrid.AddFieldColumnArea <ResultItem>((c) => c.Date); c1.Caption = "DATE"; var d1 = pivotGrid.AddFieldDataArea <ResultItem>((c) => c.PlanQty); d1.Caption = "MOVE"; var d2 = pivotGrid.AddFieldDataArea <ResultItem>((c) => c.TargetQty); d2.Caption = "TARGET"; var f1 = pivotGrid.AddFieldFilterArea <ResultItem>((c) => c.MaterialGroup); f1.Caption = "MATERIAL_GROUP"; var f2 = pivotGrid.AddFieldFilterArea <ResultItem>((c) => c.PkgFamily); f2.Caption = "PKG_FAMILY"; var f3 = pivotGrid.AddFieldFilterArea <ResultItem>((c) => c.PkgType); f3.Caption = "PKG_TYPE"; pivotGrid.BestFit(); }
private void SetPivotGridData(DataTable dt, PivotGridControl pivotGrid) { XtraPivotGridHelper.DataViewTable dataTable = new XtraPivotGridHelper.DataViewTable(); foreach (DataColumn info in dt.Columns) { dataTable.AddColumn(info.ColumnName, info.ColumnName, info.DataType, PivotArea.RowArea, null, null); } pivotGrid.BeginUpdate(); pivotGrid.ClearPivotGridFields(); pivotGrid.CreatePivotGridFields(dataTable); pivotGrid.DataSource = dt; pivotGrid.EndUpdate(); if (dt.Rows.Count < 10000) { pivotGrid.BestFit(); } }
void BestFitAction() { PivotGridControl pivotGrid = FindElement <PivotGridControl>(DemoBaseTesting.CurrentDemoModule); pivotGrid.BestFit(); }
/// <summary> /// Hiển thị các cột đã được chọn /// </summary> /// <param name="gridView"></param> /// <param name="cotHienThi"></param> public static void DisplayTheoTuyBienCot(PivotGridControl pivot, RepositoryItemCheckedComboBoxEdit cotHienThi) { //gridView.ClearGrouping(); List<string> chekedItem = new List<string>(); List<string> allItem = new List<string>(); foreach (CheckedListBoxItem item in cotHienThi.Items) { allItem.Add(item.Value.ToString()); if (item.CheckState == CheckState.Checked) chekedItem.Add(item.Value.ToString()); } foreach (PivotGridField field in pivot.Fields) { if (allItem.Contains(field.Name) == false) continue; field.Visible = false; if (chekedItem.Contains(field.Name)) { field.Visible = true; // field.vi = i++; } // else field.Visible = false; } pivot.BestFit(); }