private XtraPivotGridHelper.DataViewTable CreateDataViewTable()
{
XtraPivotGridHelper.DataViewTable dt = new XtraPivotGridHelper.DataViewTable();
dt.AddColumn(DataConst.SHOP_ID, DataConst.SHOP_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(DataConst.EQP_GROUP, DataConst.EQP_GROUP, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(DataConst.BALANCE_STEP, DataConst.BALANCE_STEP, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(DataConst.BALANCE_WIP_QTY, DataConst.BALANCE_WIP_QTY, typeof(float), PivotArea.RowArea, null, null);
dt.AddColumn(DataConst.TARGET_DATE, DataConst.TARGET_DATE, typeof(string), PivotArea.ColumnArea, null, null);
dt.AddColumn(DataConst.WIP_QTY, DataConst.WIP_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.Columns[DataConst.WIP_QTY].DefaultValue = 0.0f;
dt.AddColumn(DataConst.GAP_QTY, DataConst.GAP_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.Columns[DataConst.GAP_QTY].DefaultValue = 0.0f;
dt.AddDataTablePrimaryKey(
new DataColumn[]
{
dt.Columns[DataConst.SHOP_ID],
dt.Columns[DataConst.BALANCE_STEP],
dt.Columns[DataConst.TARGET_DATE]
}
);
return dt;
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
pivotGridControl1.BeginUpdate();
XtraPivotGridHelper.ClearPivotGridFields(pivotGridControl1);
XtraPivotGridHelper.CreatePivotGridFields(pivotGridControl1, dt);
pivotGridControl1.DataSource = dt.DataTable;
formatCells(pivotGridControl1);
pivotGridControl1.EndUpdate();
pivotGridControl1.OptionsView.HideAllTotals();
foreach (PivotGridField field in pivotGridControl1.Fields)
{
if (field.FieldName == ColName.TOTAL)
{
field.Appearance.Value.Options.UseTextOptions = true;
field.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
}
}
pivotGridControl1.BestFit();
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
ShowTotal(this.pivotGridControl1);
this.pivotGridControl1.Fields[SmcvData.Schema.STEP_ID].SortMode = PivotSortMode.Custom;
//for (int i = 0; i < this.pivotGridControl1.Fields.Count; i++)
//{
// if (this.pivotGridControl1.Fields[i].FieldName == "IN_QTY")
// this.pivotGridControl1.Fields[i].Area = PivotArea.FilterArea;
//}
//pivotGridControl1.CustomCellDisplayText += pivotGridControl1_CellDisplayText;
this.pivotGridControl1.EndUpdate();
this.pivotGridControl1.BestFitColumnArea();
pivotGridControl1.Fields[SmcvData.Schema.ACT_MOVE_QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[SmcvData.Schema.ACT_MOVE_QTY].CellFormat.FormatString = "#,##0";
pivotGridControl1.Fields[SmcvData.Schema.SIM_MOVE_QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[SmcvData.Schema.SIM_MOVE_QTY].CellFormat.FormatString = "#,##0";
pivotGridControl1.Fields[SmcvData.Schema.WIP_CUR].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[SmcvData.Schema.WIP_CUR].CellFormat.FormatString = "#,##0";
pivotGridControl1.Fields[SmcvData.Schema.WIP_MAIN].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[SmcvData.Schema.WIP_MAIN].CellFormat.FormatString = "#,##0";
}
private XtraPivotGridHelper.DataViewTable CreateDataViewTable()
{
XtraPivotGridHelper.DataViewTable dt = new XtraPivotGridHelper.DataViewTable();
dt.AddColumn(EuData.AREA, EuData.AREA, typeof(string), PivotArea.RowArea,
DevExpress.Data.PivotGrid.PivotSummaryType.Average, null);
dt.AddColumn(EuData.SHOP_ID, EuData.SHOP_ID, typeof(string), PivotArea.RowArea,
DevExpress.Data.PivotGrid.PivotSummaryType.Average, null);
dt.AddColumn(EuData.EQP_GROUP_ID, EuData.EQP_GROUP_ID, typeof(string), PivotArea.FilterArea,
DevExpress.Data.PivotGrid.PivotSummaryType.Average, null);
dt.AddColumn(EuData.DATE, EuData.DATE, typeof(string), PivotArea.ColumnArea,
DevExpress.Data.PivotGrid.PivotSummaryType.Average, null);
dt.AddColumn(EuData.UTILIZATION, EuData.UTILIZATION, typeof(float), PivotArea.DataArea,
DevExpress.Data.PivotGrid.PivotSummaryType.Average, null);
dt.AddDataTablePrimaryKey(
new DataColumn[]
{
dt.Columns[EuData.AREA],
dt.Columns[EuData.SHOP_ID],
dt.Columns[EuData.EQP_GROUP_ID],
dt.Columns[EuData.DATE]
}
);
return(dt);
}
private XtraPivotGridHelper.DataViewTable CreateDataViewTable()
{
XtraPivotGridHelper.DataViewTable dt = new XtraPivotGridHelper.DataViewTable();
dt.AddColumn(StepWipData.SHOP_ID, StepWipData.SHOP_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepWipData.STD_STEP, StepWipData.STD_STEP, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepWipData.PRODUCT_ID, StepWipData.PRODUCT_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepWipData.PRODUCT_VERSION, StepWipData.PRODUCT_VERSION, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepWipData.OWNER_TYPE, StepWipData.OWNER_TYPE, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepWipData.TARGET_DATE, StepWipData.TARGET_DATE, typeof(string), PivotArea.ColumnArea, null, null);
dt.AddColumn(StepWipData.WAIT_QTY, StepWipData.WAIT_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.AddColumn(StepWipData.RUN_QTY, StepWipData.RUN_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.AddColumn(StepWipData.TOTAL_QTY, StepWipData.TOTAL_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.Columns[StepWipData.TOTAL_QTY].DefaultValue = 0.0f;
dt.AddDataTablePrimaryKey(
new DataColumn[]
{
dt.Columns[StepWipData.SHOP_ID],
dt.Columns[StepWipData.STD_STEP],
dt.Columns[StepWipData.PRODUCT_ID],
dt.Columns[StepWipData.PRODUCT_VERSION],
dt.Columns[StepWipData.OWNER_TYPE],
dt.Columns[StepWipData.TARGET_DATE]
}
);
return(dt);
}
private XtraPivotGridHelper.DataViewTable CreateDataViewTable()
{
XtraPivotGridHelper.DataViewTable dt = new XtraPivotGridHelper.DataViewTable();
dt.AddColumn(IocvData.Schema.SHOP_ID, IocvData.Schema.SHOP_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(IocvData.Schema.IN_OUT_FLAG, IocvData.Schema.IN_OUT_FLAG, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(IocvData.Schema.DEPT, IocvData.Schema.DEPT, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(IocvData.Schema.PROD_ID, IocvData.Schema.PROD_ID, typeof(string), PivotArea.FilterArea, null, null);
dt.AddColumn(IocvData.Schema.PROD_VER, IocvData.Schema.PROD_VER, typeof(string), PivotArea.FilterArea, null, null);
dt.AddColumn(IocvData.Schema.TARGET_DATE, IocvData.Schema.TARGET_DATE, typeof(string), PivotArea.ColumnArea, null, null);
dt.AddColumn(IocvData.Schema.QTY, IocvData.Schema.QTY, typeof(double), PivotArea.DataArea, null, null);
dt.AddDataTablePrimaryKey(
new DataColumn[]
{
dt.Columns[IocvData.Schema.SHOP_ID],
dt.Columns[IocvData.Schema.IN_OUT_FLAG],
dt.Columns[IocvData.Schema.DEPT],
dt.Columns[IocvData.Schema.PROD_ID],
dt.Columns[IocvData.Schema.PROD_VER],
dt.Columns[IocvData.Schema.TARGET_DATE]
}
);
return(dt);
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
this.pivotGridControl1.OptionsView.ShowFilterHeaders = true;
for (int i = 0; i < this.pivotGridControl1.Fields.Count; i++)
{
if (this.pivotGridControl1.Fields[i].FieldName == "WAIT_QTY" || this.pivotGridControl1.Fields[i].FieldName == "RUN_QTY")
{
this.pivotGridControl1.Fields[i].Area = PivotArea.FilterArea;
}
}
pivotGridControl1.CustomCellDisplayText += pivotGridControl1_CellDisplayText;
pivotGridControl1.Fields[StepWipData.TOTAL_QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[StepWipData.TOTAL_QTY].CellFormat.FormatString = "#,##0";
pivotGridControl1.Fields[StepWipData.RUN_QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[StepWipData.RUN_QTY].CellFormat.FormatString = "#,##0";
pivotGridControl1.Fields[StepWipData.WAIT_QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[StepWipData.WAIT_QTY].CellFormat.FormatString = "#,##0";
this.pivotGridControl1.Fields[StepWipData.STD_STEP].SortMode = PivotSortMode.Custom;
this.pivotGridControl1.EndUpdate();
pivotGridControl1.BestFitColumnArea();
}
private XtraPivotGridHelper.DataViewTable BindData()
{
XtraPivotGridHelper.DataViewTable dataViewTable = new XtraPivotGridHelper.DataViewTable(viewName);
dataViewTable.AddColumn(TargetPlanCompareData.SHOP_ID, TargetPlanCompareData.SHOP_ID, typeof(string), PivotArea.RowArea, null, null);
dataViewTable.AddColumn(TargetPlanCompareData.STEP_ID, TargetPlanCompareData.STEP_ID, typeof(string), PivotArea.RowArea, null, null);
dataViewTable.AddColumn(TargetPlanCompareData.PRODUCT_ID, TargetPlanCompareData.PRODUCT_ID, typeof(string), PivotArea.RowArea, null, null);
dataViewTable.AddColumn(TargetPlanCompareData.OWNER_TYPE, TargetPlanCompareData.OWNER_TYPE, typeof(string), PivotArea.RowArea, null, null);
dataViewTable.AddColumn(TargetPlanCompareData.CATEGORY, TargetPlanCompareData.CATEGORY, typeof(string), PivotArea.RowArea, null, null);
dataViewTable.AddColumn(TargetPlanCompareData.TOTAL, TargetPlanCompareData.TOTAL, typeof(string), PivotArea.RowArea, null, null);
dataViewTable.AddColumn(TargetPlanCompareData.TARGET_DATE, TargetPlanCompareData.TARGET_DATE, typeof(string), PivotArea.ColumnArea, null, null);
dataViewTable.AddColumn(ColName.QTY, ColName.QTY, typeof(float), PivotArea.DataArea, null, null);
dataViewTable.AddDataTablePrimaryKey(
new DataColumn[]
{
dataViewTable.Columns[TargetPlanCompareData.SHOP_ID],
dataViewTable.Columns[TargetPlanCompareData.STEP_ID],
dataViewTable.Columns[TargetPlanCompareData.PRODUCT_ID],
dataViewTable.Columns[TargetPlanCompareData.CATEGORY],
dataViewTable.Columns[TargetPlanCompareData.TARGET_DATE]
});
return(dataViewTable);
}
private XtraPivotGridHelper.DataViewTable CreateDataViewTable()
{
XtraPivotGridHelper.DataViewTable dt = new XtraPivotGridHelper.DataViewTable();
dt.AddColumn(StepMoveData.SHOP_ID, StepMoveData.SHOP_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepMoveData.STD_STEP, StepMoveData.STD_STEP, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepMoveData.PRODUCT_ID, StepMoveData.PRODUCT_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepMoveData.PRODUCT_VERSION, StepMoveData.PRODUCT_VERSION, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepMoveData.OWNER_TYPE, StepMoveData.OWNER_TYPE, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(StepMoveData.EQP_ID, StepMoveData.EQP_ID, typeof(string), PivotArea.FilterArea, null, null);
dt.AddColumn(StepMoveData.EQP_GROUP_ID, StepMoveData.EQP_GROUP_ID, typeof(string), PivotArea.FilterArea, null, null);
dt.AddColumn(StepMoveData.TARGET_DATE, StepMoveData.TARGET_DATE, typeof(string), PivotArea.ColumnArea, null, null);
dt.AddColumn(StepMoveData.IN_QTY, StepMoveData.IN_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.AddColumn(StepMoveData.OUT_QTY, StepMoveData.OUT_QTY, typeof(float), PivotArea.DataArea, null, null);
dt.AddDataTablePrimaryKey(
new DataColumn[]
{
dt.Columns[StepMoveData.SHOP_ID],
dt.Columns[StepMoveData.STD_STEP],
dt.Columns[StepMoveData.PRODUCT_ID],
dt.Columns[StepMoveData.PRODUCT_VERSION],
dt.Columns[StepMoveData.OWNER_TYPE],
dt.Columns[StepMoveData.EQP_ID],
dt.Columns[StepMoveData.EQP_GROUP_ID],
dt.Columns[StepMoveData.TARGET_DATE]
}
);
return(dt);
}
private void BindData()
{
XtraPivotGridHelper.DataViewTable dt = CreateDataViewTable();
FillData(dt);
DrawGrid(dt);
}
private void FillData(XtraPivotGridHelper.DataViewTable dt)
{
string targetAreaID = this.TargetAreaID;
bool isOnlyMainStep = this.ShowSubStep == false;
var modelContext = _result.GetCtx <ModelDataContext>();
var stdStepList = _stdStepList;
if (isOnlyMainStep)
{
stdStepList = stdStepList.FindAll(t => StringHelper.Equals(t.STEP_TYPE, "MAIN"));
}
var stepWip = _dict.Values;
var query = from ps in stdStepList
join p in stepWip
on ps.SHOP_ID + ps.STEP_ID equals p.LINE_ID + p.STD_STEP into temp
from tp in temp.DefaultIfEmpty()
select new
{
SHOP_ID = tp != null ? tp.LINE_ID : ps.SHOP_ID,
STD_STEP_ID = tp != null ? tp.STD_STEP : ps.STEP_ID,
PROD_ID = tp != null ? tp.PROD_ID : null,
PROD_VER = tp != null ? tp.PROD_VER : null,
OWNER_TYPE = tp != null ? tp.OWNER_TYPE : null,
DATE_INFO = tp != null ? tp.DATE_INFO : null,
WAIT_QTY = tp != null ? tp.WAIT_QTY : 0,
RUN_QTY = tp != null ? tp.RUN_QTY : 0,
STD_STEP_SEQ = tp != null ? tp.STEP_SEQ : ps.STEP_SEQ,
};
_stepIndexs = new Dictionary <string, int>();
var table = dt.DataTable;
foreach (var item in query)
{
if (item.PROD_ID == null)
{
continue;
}
table.Rows.Add(item.SHOP_ID,
item.STD_STEP_ID,
item.PROD_ID,
item.PROD_VER,
item.OWNER_TYPE,
item.DATE_INFO,
item.WAIT_QTY,
item.RUN_QTY,
item.WAIT_QTY + item.RUN_QTY);
string stepKey = item.STD_STEP_ID;
_stepIndexs[stepKey] = item.STD_STEP_SEQ;
}
}
private void FillPivotGrid()
{
_dtChart = CreateChartTable();
XtraPivotGridHelper.DataViewTable rsltTable = CreateDataViewTable();
FillData(rsltTable);
DrawPivotGrid(rsltTable);
}
private void Query()
{
DataProcessing();
XtraPivotGridHelper.DataViewTable dt = CreateDataViewTable();
FillPivotGrid(dt);
DrawGrid(dt);
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
this.pivotGridControl1.EndUpdate();
}
private void FillData(XtraPivotGridHelper.DataViewTable dt)
{
foreach (ResultItem item in _dict.Values)
{
dt.DataTable.Rows.Add(
item.LINE_ID,
item.PRODUCT_ID,
item.PROCESS_ID,
item.STEP_ID,
item.IN_QTY,
item.OUT_QTY
);
}
}
private void FillPivotGrid(XtraPivotGridHelper.DataViewTable dt)
{
foreach (EqpArrProductAnalViewData.EqpArrAnalResult resultInfo in _resultDic.Values)
{
DataRow dRow = dt.DataTable.NewRow();
dRow[EqpArrProductAnalViewData.SHOP_ID] = resultInfo.SHOP_ID;
dRow[EqpArrProductAnalViewData.EQP_ID] = resultInfo.EQP_ID;
dRow[EqpArrProductAnalViewData.STEP_ID] = resultInfo.STEP_ID;
dRow[EqpArrProductAnalViewData.STEP_DESC] = resultInfo.STEP_DESC;
dRow[EqpArrProductAnalViewData.PROD_QTY] = resultInfo.PROD_QTY;
dt.DataTable.Rows.Add(dRow);
}
}
private void Query()
{
SetDateRange();
LoadData();
XtraPivotGridHelper.DataViewTable dataViewTable = BindData();
FillData(dataViewTable);
DrawGrid(dataViewTable);
LoadDefaultLayOutFromXml();
this.expandablePanel1.Text = "StepTarget VS EqpPlan : ";
}
private void Query()
{
ProcessData();
XtraPivotGridHelper.DataViewTable dt = CreateDataViewTable();
FillPivotData(dt);
DrawPivotGrid(dt);
DataTable dtChart = GetChartSchema();
dtChart = FillChartData(dtChart);
DrawChart(dtChart);
}
private void SetPivotGrid(DataTable dt, DevExpress.XtraPivotGrid.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();
pivotGrid.BestFit();
}
private void FillData(XtraPivotGridHelper.DataViewTable dt)
{
foreach (DetailInfo info in _detailDict.Values)
{
foreach (KeyValuePair <DateTime, float> pair in info.QtyDict)
{
dt.DataTable.Rows.Add(
info.Layer,
info.StepID,
info.StepDesc,
info.Span.ToString("0.0"),
Convert.ToInt32(info.Total),
pair.Key.ToString("yyyyMMdd HH"),
Convert.ToInt32(pair.Value)
);
}
}
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
//this.pivotGridControl1.OptionsView.ShowRowTotals = false;
//this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
//this.pivotGridControl1.OptionsView.ShowColumnTotals = false;
//this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
this.pivotGridControl1.EndUpdate();
this.pivotGridControl1.BestFitColumnArea();
}
private void Query()
{
_colorGenerator = new ColorGenerator();
SetData();
LoadData();
ProcessData();
XtraPivotGridHelper.DataViewTable dt = CreateDataViewTable();
//_dtChart = CreateChartTable();
FillData(dt);
// 4. Draw Grid
DrawGrid(dt);
}
private void FillData(XtraPivotGridHelper.DataViewTable dataViewTable, CompareItem item, string targetDate, CompareItem total, QtyType qtyType)
{
string category = qtyType.ToString();
float qty = 0.0f;
if (ShowAccumulativeQty)
{
qty = item.GetAccQty(targetDate, qtyType);
}
else
{
qty = item.GetQty(targetDate, qtyType);
}
dataViewTable.DataTable.Rows.Add(
item.SHOP_ID,
item.STEP_ID,
item.PRODUCT_ID,
item.OWNER_TYPE,
category,
string.Format("{0:#,##0}", item.GetTotalQty(qtyType)),
targetDate,
qty);
//Total
var infos = qtyType == QtyType.TARGET ? total.Targets : total.Plans;
if (qtyType == QtyType.DIFF)
{
infos = total.Diffs;
}
float prevQty = 0;
if (infos.TryGetValue(targetDate, out prevQty))
{
infos[targetDate] += qty;
}
else
{
infos.Add(targetDate, 0);
}
}
private void DrawPivotGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
this.pivotGridControl1.OptionsView.ShowRowTotals = true;
this.pivotGridControl1.OptionsView.ShowRowGrandTotals = true;
this.pivotGridControl1.OptionsView.ShowColumnTotals = true;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = true;
this.pivotGridControl1.Fields[EuData.UTILIZATION].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.pivotGridControl1.Fields[EuData.UTILIZATION].CellFormat.FormatString = "###,##0.0";
this.pivotGridControl1.EndUpdate();
}
private void DrawPivotGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
ShowTotal(this.pivotGridControl1);
//this.pivotGridControl1.Fields[SmcvData.Schema.STEP_ID].SortMode = PivotSortMode.Custom;
pivotGridControl1.Fields[IocvData.Schema.QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[IocvData.Schema.QTY].CellFormat.FormatString = "#,##0";
//this.pivotGridControl1.BestFitColumnArea();
this.pivotGridControl1.EndUpdate();
this.pivotGridControl1.Refresh();
}
private void FillPivotData(XtraPivotGridHelper.DataViewTable dt)
{
foreach (IocvData.ResultPivot item in _rsltPivotDic.Values)
{
string prodVer = "-";
if (item.PROD_VER != null)
{
prodVer = item.PROD_VER;
}
dt.DataTable.Rows.Add(
item.SHOP_ID,
item.IN_OUT_FLAG,
item.DEPT,
item.PROD_ID,
prodVer,
item.TARGET_DATE,
item.QTY
);
}
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
pivotGridControl1.CustomDrawCell += this.pivotGridControl1_CustomDrawCell;
ShowTotal(this.pivotGridControl1, false);
pivotGridControl1.CustomFieldSort += this.pivotGridControl1_CustomFieldSort;
this.pivotGridControl1.Fields[JobChangePlanData.LAYER].SortMode = PivotSortMode.Custom;
//pivotGridControl1.CustomCellDisplayText += pivotGridControl1_CellDisplayText;
this.pivotGridControl1.EndUpdate();
this.pivotGridControl1.BestFitColumnArea();
}
private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
this.pivotGridControl1.BeginUpdate();
this.pivotGridControl1.ClearPivotGridFields();
this.pivotGridControl1.CreatePivotGridFields(dt);
this.pivotGridControl1.DataSource = dt.DataTable;
formatGrid();
ShowTotal(this.pivotGridControl1, false);
this.pivotGridControl1.Fields[BalanceTableViewData.CATEGORY].SortMode = PivotSortMode.Custom;
this.pivotGridControl1.Fields[BalanceTableViewData.TARGET_DATE].SortMode = PivotSortMode.Custom;
this.pivotGridControl1.EndUpdate();
this.pivotGridControl1.BestFit();
pivotGridControl1.Fields[BalanceTableViewData.QTY].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
pivotGridControl1.Fields[BalanceTableViewData.QTY].CellFormat.FormatString = "#,##0";
}
private void FillData(XtraPivotGridHelper.DataViewTable dt)
{
foreach (CellInfo cinfo in _resultDict.Values)
{
foreach (string category in cinfo.QtyDict.Keys)
{
Dictionary <string, float> dict = cinfo.QtyDict[category];
foreach (KeyValuePair <string, float> pair in dict)
{
if (this.ShowOutBalance == false && category.Contains("Out-"))
{
continue;
}
string cellOutID = "-";
if (_bomDict.ContainsKey(cinfo.CellID))
{
cellOutID = _bomDict[cinfo.CellID];
}
if (_demandList.Contains(cellOutID) == false)
{
continue;
}
dt.DataTable.Rows.Add(
cellOutID,
cinfo.CellID,
cinfo.TFProductID + "/\n" + cinfo.CFProductID,
category,
pair.Key,
pair.Value
);
}
}
}
}
private XtraPivotGridHelper.DataViewTable CreateDataViewTable()
{
XtraPivotGridHelper.DataViewTable dt = new XtraPivotGridHelper.DataViewTable();
dt.AddColumn(EqpArrProductAnalViewData.SHOP_ID, EqpArrProductAnalViewData.SHOP_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(EqpArrProductAnalViewData.EQP_ID, EqpArrProductAnalViewData.EQP_ID, typeof(string), PivotArea.RowArea, null, null);
dt.AddColumn(EqpArrProductAnalViewData.STEP_ID, EqpArrProductAnalViewData.STEP_ID, typeof(string), PivotArea.ColumnArea, null, null);
dt.AddColumn(EqpArrProductAnalViewData.STEP_DESC, EqpArrProductAnalViewData.STEP_DESC, typeof(string), PivotArea.ColumnArea, null, null);
dt.AddColumn(EqpArrProductAnalViewData.PROD_QTY, EqpArrProductAnalViewData.PROD_QTY, typeof(int), PivotArea.DataArea, null, null);
dt.AddDataTablePrimaryKey(
new DataColumn[]
{
dt.Columns[EqpArrProductAnalViewData.SHOP_ID],
dt.Columns[EqpArrProductAnalViewData.EQP_ID],
dt.Columns[EqpArrProductAnalViewData.STEP_ID],
dt.Columns[EqpArrProductAnalViewData.STEP_DESC],
dt.Columns[EqpArrProductAnalViewData.PROD_QTY]
}
);
return(dt);
}
