private void PhanTich_Load(object sender, EventArgs e) { LoadThongTinChiTiet(); LayoutControlGroup newGroup = dataLayoutControl1.Root.AddGroup(); LayoutControlItem item1 = newGroup.AddItem(); gridControl = new GridControl(); gridControl.Dock = DockStyle.Fill; gridControl.DataSource = getMarkDataWithID(MaHocVien); item1.Control = gridControl; GridView gridView1 = gridControl.MainView as GridView; GridColumn colHocKy = gridView1.Columns["HocKy"]; GridColumn colNam = gridView1.Columns["Nam"]; GridColumn colDiem = gridView1.Columns["Diem"]; colNam.GroupIndex = 0; colHocKy.GroupIndex = 1; gridView1.ExpandAllGroups(); //Change Format Rule GridFormatRule gridFormatRule = new GridFormatRule(); FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet(); FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet(); FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon4 = new FormatConditionIconSetIcon(); //Choose predefined icons. icon1.PredefinedName = "Rating4_1.png"; icon2.PredefinedName = "Rating4_2.png"; icon3.PredefinedName = "Rating4_3.png"; icon4.PredefinedName = "Rating4_4.png"; //Specify the type of threshold values. iconSet.ValueType = FormatConditionValueType.Number; //Define ranges to which icons are applied by setting threshold values. icon1.Value = 8; // target range: 8 <= value icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon2.Value = 7; // target range: 7 <= value < 8 icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon3.Value = 5; // target range: 5 <= value < 7 icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon4.Value = 0; // target range: 0 <= value < 5 icon4.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; //Add icons to the icon set. iconSet.Icons.Add(icon1); iconSet.Icons.Add(icon2); iconSet.Icons.Add(icon3); iconSet.Icons.Add(icon4); //Specify the rule type. gridFormatRule.Rule = formatConditionRuleIconSet; //Specify the column to which formatting is applied. gridFormatRule.Column = colDiem; //Add the formatting rule to the GridView. gridView1.FormatRules.Add(gridFormatRule); }
FormatConditionRuleIconSet createThreeTrianglesIconSetRule() { FormatConditionRuleIconSet ruleIconSet = new FormatConditionRuleIconSet(); FormatConditionIconSet iconSet = ruleIconSet.IconSet = new FormatConditionIconSet(); FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon(); //Choose predefined icons. icon1.PredefinedName = "Triangles3_3.png"; icon2.PredefinedName = "Triangles3_2.png"; icon3.PredefinedName = "Triangles3_1.png"; //Specify the type of threshold values. iconSet.ValueType = FormatConditionValueType.Number; //Define ranges to which icons are applied by setting threshold values. icon1.Value = Decimal.MinValue; icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon2.Value = 0; icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon3.Value = 0; icon3.ValueComparison = FormatConditionComparisonType.Greater; //Add icons to the icon set. iconSet.Icons.Add(icon1); iconSet.Icons.Add(icon2); iconSet.Icons.Add(icon3); return(ruleIconSet); }
void InitGridControlCadet(string maLop) { string query = ""; if (maLop == null) { query = "EXEC dbo.LayThongTinDiemCacKiCuaHocVien"; } else { query = string.Format("EXECUTE dbo.LayThongTinDiemCacKiCuaHocVienTheoLop {0}", maLop); } using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(query, connection); using (SqlDataAdapter adapter = new SqlDataAdapter(cmd)) { DataTable table = new DataTable(); adapter.Fill(table); gridControlCadet.DataSource = table; GridColumn colID = gridViewCadet.Columns["HocVienID"]; GridColumn colName = gridViewCadet.Columns["TenHocVien"]; GridColumn colQue = gridViewCadet.Columns["QueQuan"]; GridColumn colNgaySinh = gridViewCadet.Columns["NgaySinh"]; GridColumn colTenLop = gridViewCadet.Columns["TenLop"]; GridColumn colHocKy = gridViewCadet.Columns["HocKy"]; GridColumn colHocKyId = gridViewCadet.Columns["HocKyID"]; GridColumn colNamHocId = gridViewCadet.Columns["NamHocID"]; GridColumn colTongKet = gridViewCadet.Columns["TongKet"]; GridColumn colNam = gridViewCadet.Columns["Nam"]; GridColumn colDuongDanAnh = gridViewCadet.Columns["DuongDanAnh"]; GridColumn colTangTruong = gridViewCadet.Columns["TangTruong"]; colID.Visible = false; colHocKyId.Visible = false; colNamHocId.Visible = false; colDuongDanAnh.Visible = false; colName.Caption = "Tên Học Viên"; colQue.Caption = "Quê Quán"; colNgaySinh.Caption = "Ngày Sinh"; colTenLop.Caption = "Lớp"; colHocKy.Caption = "Học Kì"; colTongKet.Caption = "Điểm Tổng Kết Kì"; colNam.Caption = "Năm Học"; colNam.GroupIndex = 0; colHocKy.GroupIndex = 1; colNgaySinh.Summary.Clear(); colNgaySinh.Summary.Add(SummaryItemType.Count, colNgaySinh.FieldName, "Tổng Số : {0}"); colNgaySinh.Summary.Add(SummaryItemType.Max, colNgaySinh.FieldName, "Độ Tuổi : <= {0:d}"); gridViewCadet.OptionsView.ShowFooter = true; gridViewCadet.FindPanelVisible = true; gridViewCadet.OptionsFind.HighlightFindResults = true; //Change Format Rule GridFormatRule gridFormatRule = new GridFormatRule(); FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet(); FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet(); FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon(); //Choose predefined icons. icon1.PredefinedName = "Arrows3_1.png"; icon2.PredefinedName = "Arrows3_2.png"; icon3.PredefinedName = "Arrows3_3.png"; //Specify the type of threshold values. iconSet.ValueType = FormatConditionValueType.Number; //Define ranges to which icons are applied by setting threshold values. icon1.Value = 30; // target range: 30% <= value icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon2.Value = 10; // target range: 10% <= value < 30% icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon3.Value = -100; // target range: -100% <= value < 10% icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; //Add icons to the icon set. iconSet.Icons.Add(icon1); iconSet.Icons.Add(icon2); iconSet.Icons.Add(icon3); //Specify the rule type. gridFormatRule.Rule = formatConditionRuleIconSet; //Specify the column to which formatting is applied. gridFormatRule.Column = colTangTruong; //Add the formatting rule to the GridView. gridViewCadet.FormatRules.Add(gridFormatRule); gridViewCadet.ExpandAllGroups(); } } }
private void BindingData(string ARG_PROCESS, string ARG_LINE, string ARG_MLINE) { DataTable dt = SEL_MULTI_SKILL_V2("Q", ARG_PROCESS, ARG_LINE, ARG_MLINE); gridView1.Columns.Clear(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Columns.Count; i++) { dt.Columns[i].ColumnName = dt.Columns[i].ColumnName.Replace("'", "").Replace("_", " "); } gridControl1.DataSource = dt; //format Condition for (int i = 2; i < gridView1.Columns.Count; i++) { GridFormatRule gridFormatRule = new GridFormatRule(); FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet(); FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet(); FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon4 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon5 = new FormatConditionIconSetIcon(); //Choose predefined icons. icon1.PredefinedName = "Quarters5_1.png"; icon2.PredefinedName = "Quarters5_2.png"; icon3.PredefinedName = "Quarters5_3.png"; icon4.PredefinedName = "Quarters5_4.png"; icon5.PredefinedName = "Quarters5_5.png"; //Specify the type of threshold values. iconSet.ValueType = FormatConditionValueType.Automatic; //Define ranges to which icons are applied by setting threshold values. icon1.Value = 100; // target range: 100% <= value icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon2.Value = 75; // target range: 50% <= value < 75% icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon3.Value = 50; // target range: 25% <= value < 50% icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon4.Value = 25; // target range: 0% <= value < 25% icon4.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon5.Value = 0; // target range: 0% <= value < 33% icon5.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; //Add icons to the icon set. iconSet.Icons.Add(icon1); iconSet.Icons.Add(icon2); iconSet.Icons.Add(icon3); iconSet.Icons.Add(icon4); iconSet.Icons.Add(icon5); //Specify the rule type. gridFormatRule.Rule = formatConditionRuleIconSet; //Specify the column to which formatting is applied. gridFormatRule.Column = gridView1.Columns[i]; //Add the formatting rule to the GridView. gridView1.FormatRules.Add(gridFormatRule); gridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Columns[i].AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center; gridView1.Columns[i].OptionsColumn.AllowEdit = false; } gridView1.BestFitColumns(); gridView1.OptionsView.ColumnAutoWidth = false; } else { gridControl1.Hide(); } // gridControl1.EndUpdate(); }
private void dtfill(DataTable dt) { gridControl1.Refresh(); gridControl1.DataSource = datos; gridView1.Columns[4].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[4].DisplayFormat.FormatString = "c2"; gridView1.Columns[5].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[5].DisplayFormat.FormatString = "c2"; gridView1.Columns[6].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[6].DisplayFormat.FormatString = "c2"; gridView1.Columns[7].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[7].DisplayFormat.FormatString = "c2"; gridView1.Columns[8].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[8].DisplayFormat.FormatString = "c2"; gridView1.Columns[9].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[9].DisplayFormat.FormatString = "c2"; gridView1.Columns[10].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[10].DisplayFormat.FormatString = "c2"; gridView1.Columns[11].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[11].DisplayFormat.FormatString = "c2"; gridView1.Columns[12].DisplayFormat.FormatType = FormatType.Numeric; gridView1.Columns[12].DisplayFormat.FormatString = "c2"; gridView1.Columns[13].DisplayFormat.FormatType = FormatType.Numeric; // gridView1.Columns[13].DisplayFormat.FormatString = "P"; GridFormatRule gridFormatRule = new GridFormatRule(); FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet(); FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet(); FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon4 = new FormatConditionIconSetIcon(); FormatConditionIconSetIcon icon5 = new FormatConditionIconSetIcon(); //Choose predefined icons. icon1.PredefinedName = "Arrows5_1.png"; icon2.PredefinedName = "Arrows5_2.png"; icon3.PredefinedName = "Arrows5_3.png"; icon4.PredefinedName = "Arrows5_4.png"; icon5.PredefinedName = "Arrows5_5.png"; //Specify the type of threshold values. iconSet.ValueType = FormatConditionValueType.Number; //Define ranges to which icons are applied by setting threshold values. icon1.Value = 90; // target range: 67% <= value icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon2.Value = 70; // target range: 33% <= value < 67% icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon3.Value = 50; // target range: 0% <= value < 33% icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon4.Value = 25; // target range: 0% <= value < 33% icon4.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; icon5.Value = 0; // target range: 0% <= value < 33% icon5.ValueComparison = FormatConditionComparisonType.GreaterOrEqual; //Add icons to the icon set. iconSet.Icons.Add(icon1); iconSet.Icons.Add(icon2); iconSet.Icons.Add(icon3); iconSet.Icons.Add(icon4); iconSet.Icons.Add(icon5); //Specify the rule type. gridFormatRule.Rule = formatConditionRuleIconSet; //Specify the column to which formatting is applied. gridFormatRule.Column = gridView1.Columns["ALCANCE"]; //Add the formatting rule to the GridView. gridView1.FormatRules.Add(gridFormatRule); groupBox3.Hide(); button2.Enabled = true; }