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) { }
}
