private void BindingOutScnByDay(string LINE_CD)
{
try
{
DatabaseTMS db = new DatabaseTMS();
DataTable dt = dtChartTemp = db.GetOutScnByDay("VJ", ComVar.Var._strValue3, ComVar.Var._strValue4, DateTime.Now.ToString("yyyyMMdd"), LINE_CD);
lblO_SCN_OVER.Text = "";
lblO_SCN_D2.Text = "";
lblO_SCN_D1.Text = "";
lblO_SCN_DD.Text = "";
lblTotalDelivery_ByDay.Text = "";
lblO_SCN_OVER.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[0]["O_QTY"])) + " Prs";
lblO_SCN_D2.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[1]["O_QTY"])) + " Prs";
lblO_SCN_D1.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[2]["O_QTY"])) + " Prs";
lblO_SCN_DD.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[3]["O_QTY"])) + " Prs";
lblTotalDelivery_ByDay.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[4]["O_QTY"])) + " Prs";
}
catch (Exception ex)
{ }
}
private void GetDataOutgoing_Chart()
{
DatabaseTMS db = new DatabaseTMS();
DataTable dtTemp = new DataTable();
DataTable dt = db.GetOutScnByDay("VJ", "OS", DateTime.Now.ToString("yyyyMMdd"), ComVar.Var._strValue1);
lblOS_Outgoing.Text = "0 Prs";
if (dt.Rows.Count > 0)
{
lblOS_Outgoing.Text = string.Format("{0:n0}", dt.Rows[dt.Rows.Count - 1]["O_QTY"]) + " Prs";
}
if (dt.Select("DAYDAY IS NOT NULL").Count() > 0)
{
dtTemp = dt.Select("DAYDAY IS NOT NULL", "DD").CopyToDataTable();
}
chartControl1.DataSource = dtTemp;
chartControl1.Series[0].ArgumentDataMember = "DAYDAY";
chartControl1.Series[0].ValueDataMembers.AddRange(new string[] { "O_QTY" });
}
