private void BindingDataGrid() { gridControl1.DataSource = GetData(6); // ritem.ProgressViewStyle = DevExpress.XtraEditors.Controls.ProgressViewStyle.Solid; // ritem.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Flat; // ritem.LookAndFeel.UseDefaultLookAndFeel = false; //ritem.ShowTitle =true; //ritem.PercentView = false; //ritem.DisplayFormat.FormatType = FormatType.Numeric ; //ritem.DisplayFormat.FormatString = "n1" ; //ritem.Appearance.ForeColor = Color.Yellow; //ritem.Appearance.ForeColor2 = Color.Yellow; //ritem.Appearance.Options.UseForeColor = true; //ritem.Appearance.Options.UseForeColor2 = true; // ritem.Minimum = 0; //ritem.Maximum = 100; //ritem.StartColor = Color.Red; //ritem.EndColor = Color.Red; //bandedGridView1.Columns["BTS"].ColumnEdit = ritem; DifferentRepositoriesProgressBar drHelper = new DifferentRepositoriesProgressBar(bandedGridView1.Columns["BTS"]); }
private void BindingChart1_nOuSE(DataSet dt, int isToday) //1 today , 2 yesterday, 3 all { try { dsToday = dt; inTavgRatioToday = 0; inTavgRatioYes = 0; if (isToday == 1) { if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "TODAY").Count() > 0) { gridControl1.DataSource = dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "TODAY").CopyToDataTable(); inTavgRatioToday = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='TODAY'")); if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "YESTERDAY").Count() > 0) { inTavgRatioYes = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='YESTERDAY'")); } } else { gridControl1.DataSource = null; } } else if (isToday == 2) { if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "YESTERDAY").Count() > 0) { gridControl1.DataSource = dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "YESTERDAY").CopyToDataTable(); inTavgRatioYes = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='YESTERDAY'")); if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "TODAY").Count() > 0) { inTavgRatioToday = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='TODAY'")); } } else { gridControl1.DataSource = null; } } else { if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "YESTERDAY").Count() > 0) { gridControl1.DataSource = dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "YESTERDAY").CopyToDataTable(); inTavgRatioYes = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='YESTERDAY'")); if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "TODAY").Count() > 0) { inTavgRatioToday = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='TODAY'")); } lblToday_Label.BackColor = Color.Transparent; btnYesterday.Appearance.BackColor = Color.Orange; btnYesterday.Appearance.BackColor2 = Color.Orange; btnToday.Appearance.BackColor = Color.LightSteelBlue; btnToday.Appearance.BackColor2 = Color.LightSteelBlue; } if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "TODAY").Count() > 0) { gridControl1.DataSource = dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "TODAY").CopyToDataTable(); inTavgRatioToday = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='TODAY'")); if (dt.Tables[0].AsEnumerable().Where(r => r.Field <string>("YT") == "YESTERDAY").Count() > 0) { inTavgRatioYes = Convert.ToInt32(dt.Tables[0].Compute("AVG(RATIO)", "YT='YESTERDAY'")); } lblYesterday_Label.BackColor = Color.Transparent; btnToday.Appearance.BackColor = Color.Orange; btnToday.Appearance.BackColor2 = Color.Orange; btnYesterday.Appearance.BackColor = Color.LightSteelBlue; btnYesterday.Appearance.BackColor2 = Color.LightSteelBlue; } } DifferentRepositoriesProgressBar drHelper = new DifferentRepositoriesProgressBar(bandedGridView1.Columns["RATIO"]); for (int i = 0; i < bandedGridView1.Columns.Count; i++) { bandedGridView1.Columns[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; bandedGridView1.Columns[i].AppearanceCell.Options.UseTextOptions = true; bandedGridView1.Columns[i].OptionsColumn.ReadOnly = true; bandedGridView1.Columns[i].OptionsColumn.AllowEdit = false; bandedGridView1.Columns[i].OptionsFilter.AllowFilter = false; bandedGridView1.Columns[i].OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False; bandedGridView1.Columns[i].AppearanceCell.Font = new System.Drawing.Font("Calibri", 12f, FontStyle.Regular); bandedGridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (i <= 1) { bandedGridView1.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; } else if (i == 3 || i == 4) { bandedGridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; bandedGridView1.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; bandedGridView1.Columns[i].DisplayFormat.FormatString = "#,#.#"; bandedGridView1.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; } else { bandedGridView1.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; } } //Reset Number NRatioYes = 0; NRatioToDay = 0; flag1 = false; flag2 = false; tmrNumber.Enabled = true; tmrNumber.Start(); //================= // if (inTavgRatioToday != 0) // lblRatioToday.Text = "Ratio: " + inTavgRatioToday.ToString(); //else // lblRatioToday.Text = "Ratio: 0%"; // if (inTavgRatioYes != 0) // lblRatioYes.Text = "Ratio: " + inTavgRatioYes.ToString(); //else // lblRatioYes.Text = "Ratio: 0%"; //chartControl1.Series[0].ArgumentDataMember = "TRIP"; //chartControl1.Series[0].ValueDataMembers.AddRange(new string[] { "UP_QTY" }); //chartControl1.SeriesDataMember = "CMP_CD"; //chartControl1.SeriesTemplate.ArgumentDataMember = "TRIP"; //chartControl1.SeriesTemplate.ValueDataMembers.AddRange(new string[] { "QTY" }); //chartControl1.SeriesTemplate.Label.TextPattern = "{V:#,#}"; //chartControl1.CrosshairOptions.CrosshairLabelMode = CrosshairLabelMode.ShowForNearestSeries; //chartControl1.SeriesTemplate.CrosshairLabelPattern = "{S}: {V}"; // chartControl1.SeriesTemplate.ChangeView(DevExpress.XtraCharts.ViewType.Spline); // SplineSeriesView view = (SplineSeriesView)chartControl1.SeriesTemplate.View; // view.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True; } catch (Exception ex) { } }