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