private void btnDetailSet_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
DatabaseTMS db = new DatabaseTMS();
DataTable dt = db.GetDeliveryDetail("VJ", "20190927", ComVar.Var._strValue1);
FRM_POPUP_SQM_TRACKING_BT POPUP = new FRM_POPUP_SQM_TRACKING_BT(((DevExpress.XtraEditors.SimpleButton)sender), dt, true);
POPUP.ShowBeakForm();
this.Cursor = Cursors.Default;
}
private void GetDataGridSetBalanceChart()
{
DatabaseTMS db = new DatabaseTMS();
try
{
lblOS_SetAVG.Text = "0%";
DataTable dt = db.GetDeliveryDetail("VJ", "NoNeed", ComVar.Var._strValue1);
if (dt != null && dt.Rows.Count > 0)
{
lblOS_SetAVG.Text = Math.Round(Convert.ToDouble(dt.Compute("AVG(RATIO)", "")), 1).ToString() + "%";
}
gridControl4.DataSource = dt;
for (int i = 0; i < gridView1.Columns.Count; i++)
{
gridView4.Columns[i].OptionsColumn.ReadOnly = true;
gridView4.Columns[i].OptionsColumn.AllowEdit = false;
if (gridView4.Columns[i].FieldName == "STYLE_CD")
{
gridView4.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
}
else
{
gridView4.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
}
if (i > 1)
{
gridView4.Columns[i].DisplayFormat.FormatType = FormatType.Numeric;
gridView4.Columns[i].DisplayFormat.FormatString = "#,#";
}
gridView4.Columns[i].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
}
gridView4.Columns["COMP_NM"].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Near;
gridView4.Columns["STYLE_CD"].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
//BindingChart
chartControl3.DataSource = dt;
chartControl3.SeriesDataMember = "COMP_NM";
chartControl3.SeriesTemplate.ArgumentDataMember = "STYLE_CD";
chartControl3.SeriesTemplate.ValueDataMembers.AddRange(new string[] { "RATIO" });
chartControl3.SeriesTemplate.Label.TextPattern = "{S}: {V:#,#}";
chartControl3.SeriesTemplate.Label.Font = new System.Drawing.Font("Calibri", 11, FontStyle.Bold);
chartControl3.CrosshairOptions.CrosshairLabelMode = CrosshairLabelMode.ShowCommonForAllSeries;
chartControl3.SeriesTemplate.CrosshairLabelPattern = "{S}: {V:#,#}";
// chartControl3.SeriesTemplate.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
// chartControl3.SeriesTemplate.Label.TextOrientation = TextOrientation.Horizontal;
chartControl3.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
((XYDiagram)chartControl3.Diagram).AxisY.Title.Visibility = DefaultBoolean.True;
((XYDiagram)chartControl3.Diagram).AxisY.Title.Text = "Percentage";
}
catch (Exception ex) { }
}