I want to edit the dashboard as show: sheet 1 (ECOTracker) one ECOTracker
sheet 2(Submited Info) contains 3 grids (Part Cost, Required Operation Information, Required Material/Components)
I can hide 3 tabs (Part Cost, Required Operation Information, Required Material/Components) and then add 1 sheet to drag into 3 gridviews to map data
One solution would be to create a dashboard with just the first sheet. Then create a second dashboard with the other 3 sheets. You can then use a customization. Using the sheet wizard, you can then add the dashboard with 3 onto the first.
thank you, I also thought of this solution, creating 1 sheet after the first sheet and then placing 3 gridviews but the map data is quite complicated. I want a simpler solution
Have a nice day!
this is how i redesigned because i originally wanted to ask to use dashboar and gridview dashboar’s publish and Filter feature but have to do 3 different tabs?
private void LoadDataSubmithInfo()
{
//đặt @ đằng trước là để ghi nhận luôn trường hợp có ký tự đặc biệt thay cho dấu \ khi dùng ký tự đặc biệt
//FormatGridepi_UltraGridC_PartCost();
tblUD15 = GetDataTableByDAQID(@"DMS-GetpartCostByECO");
//Format Gridepi_UltraGridC_PartCost
//chú ý các cột sẽ được name colunm theo câu BAQ DMS-GetpartCostByECO không nếu sửa câu BAQ phải chỉnh code lại
epiUltraGridC_PartCost.DataSource = tblUD15;
epiUltraGridC_PartCost.DisplayLayout.Bands[0].Columns[0].Hidden = true;
epiUltraGridC_PartCost.Dock=System.Windows.Forms.DockStyle.Top;
//
tblUD12 = GetDataTableByDAQID(@"DMS-GetRequireOperationByECO");
//chú ý các cột sẽ được name colunm theo câu BAQ DMS-GetRequireOperationByECO không nếu sửa câu BAQ phải chỉnh code lại
epiUltraGridC_RequiredOperationInformation.DataSource = tblUD12;
epiUltraGridC_RequiredOperationInformation.DisplayLayout.Bands[0].Columns[0].Hidden = true;
epiUltraGridC_RequiredOperationInformation.Dock=System.Windows.Forms.DockStyle.Fill;
//
tblUD13 = GetDataTableByDAQID(@"DMS-GetRequiredMaterialByECO");
//chú ý các cột sẽ được name colunm theo câu BAQ DMS-GetRequiredMaterialByECO không nếu sửa câu BAQ phải chỉnh code lại
epiUltraGridC_RequiredMaterial.DataSource = tblUD13;
epiUltraGridC_RequiredMaterial.DisplayLayout.Bands[0].Columns[0].Hidden = true;
epiUltraGridC_RequiredMaterial.Dock=System.Windows.Forms.DockStyle.Bottom;
Filter("");
}
private DataTable GetDataTableByDAQID(string BAQID)
{
DynamicQueryAdapter qda = new DynamicQueryAdapter(oTrans);
qda.BOConnect();
QueryExecutionDataSet qds = qda.GetQueryExecutionParametersByID(BAQID);
qds.ExecutionParameter.Clear();
qda.ExecuteByID(BAQID,qds);
return qda.QueryResults.Tables["Results"];
}
private void baseToolbarsManager_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)
{
if(args.Tool.Key == "RefreshTool" || args.Tool.Key == "RefreshAllTool")
{
LoadDataSubmithInfo();
}
}
private void Filter(string ECOGroup) {
Infragistics.Win.UltraWinGrid.FilterCondition fcPartCost = new Infragistics.Win.UltraWinGrid.FilterCondition();
fcPartCost.CompareValue = ECOGroup;
fcPartCost.ComparisionOperator = Infragistics.Win.UltraWinGrid.FilterComparisionOperator.Equals;
epiUltraGridC_PartCost.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
epiUltraGridC_PartCost.DisplayLayout.Bands[0].ColumnFilters["UD15_Key1"].FilterConditions.Add(fcPartCost);
Infragistics.Win.UltraWinGrid.FilterCondition fcOperationInformation = new Infragistics.Win.UltraWinGrid.FilterCondition();
fcOperationInformation.CompareValue = ECOGroup;
fcOperationInformation.ComparisionOperator = Infragistics.Win.UltraWinGrid.FilterComparisionOperator.Equals;
epiUltraGridC_RequiredOperationInformation.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
epiUltraGridC_RequiredOperationInformation.DisplayLayout.Bands[0].ColumnFilters["UD12_Key1"].FilterConditions.Add(fcOperationInformation);
Infragistics.Win.UltraWinGrid.FilterCondition fcRequiredMaterial = new Infragistics.Win.UltraWinGrid.FilterCondition();
fcRequiredMaterial.CompareValue = ECOGroup;
fcRequiredMaterial.ComparisionOperator = Infragistics.Win.UltraWinGrid.FilterComparisionOperator.Equals;
epiUltraGridC_RequiredMaterial.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
epiUltraGridC_RequiredMaterial.DisplayLayout.Bands[0].ColumnFilters["UD13_Key1"].FilterConditions.Add(fcRequiredMaterial);
}
private void V_ECOTracker_1View_AfterRowChange(EpiRowChangedArgs args)
{
// ** Argument Properties and Uses **
// args.CurrentView.dataView[args.CurrentRow]["FieldName"]
// args.LastRow, args.CurrentRow, args.CurrentView
// Add Event Handler Code
string ECOGroup = args.CurrentView.dataView[args.CurrentRow]["ECORev_GroupID"].ToString();
Filter(ECOGroup);
}
Have a nice day! Thank you!