private void LoadLayoutWS()
{
try
{
tblMain.Visible = false;
int iTable = 1;
int iDx = 0;
UC = new UC.UC_WS_INFO[24];
//Khởi tạo
for (int k = 0; k < tblMain.RowCount; k++)
{
for (int i = 0; i < tblMain.ColumnCount; i++)
{
if (k == tblMain.RowCount - 1 && i == tblMain.ColumnCount - 1)
{
UC[iDx] = null;
}
else
{
UC.UC_WS_INFO Card = new UC.UC_WS_INFO();
//Card.OnButtonClick += OnbuttonUCClick;
//Card.OnLabelPlantClick += OnLabelPlantClick;
tblMain.Controls.Add(Card, i, k);
UC[iDx] = Card;
iDx++;
}
}
}
tblMain.Visible = true;
}
catch (Exception ex)
{ }
}
private void LoadLayoutWS()
{
try
{
tblMain.Visible = false;
int iTable = 1;
DatabaseTMS db = new DatabaseTMS();
DataTable dt = db.GetPlant("VJ", ComVar.Var._strValue3, ComVar.Var._strValue4, DateTime.Now.ToString("yyyyMMdd")); //GetPlant khi load lên xem cần khởi tạo bao nhiêu User Controls.
for (int i = 0; i < 3; i++) //loop dòng
{
for (int j = 0; j < 8; j++) //loop cột
{
if (iTable <= dt.Rows.Count) //21 cell được load layout
{
UC.UC_WS_INFO UC_WS = new UC.UC_WS_INFO();
UC_WS.OnButtonClick += OnbuttonUCClick;
UC_WS.OnLabelPlantClick += OnLabelPlantClick;
tblMain.Controls.Add(UC_WS, j, i);
}
iTable++;
}
}
tblMain.Visible = true;
}
catch (Exception ex)
{
}
}
private void BindingDataUC()
{
int iTable = 1;
lblPlanTot.Text = "";
lblInvTot.Text = "";
lblLeadTimeTot.Text = "";
PlanQty = 0;
InvQty = 0;
DatabaseTMS db = new DatabaseTMS();
DataTable dt = dtUCTemp = db.GetPlant("VJ", ComVar.Var._strValue3, ComVar.Var._strValue4, DateTime.Now.ToString("yyyyMMdd"));
layOutCount = dt.Rows.Count;
for (int i = 0; i < 3; i++)
{
for (int j = 0; j < 8; j++)
{
if (iTable <= dt.Rows.Count) //21 cell được load layout
{
UC.UC_WS_INFO UC_WS = (UC.UC_WS_INFO)tblMain.GetControlFromPosition(j, i);
if (!string.IsNullOrEmpty(dt.Rows[iTable - 1]["LT"].ToString()))
{
UC_WS.BindingData(dt.Rows[iTable - 1]["LINE_CD"].ToString(), dt.Rows[iTable - 1]["LINE_NAME"].ToString(), dt.Rows[iTable - 1]["PLAN_QTY"].ToString(), dt.Rows[iTable - 1]["WIP_QTY"].ToString(), dt.Rows[iTable - 1]["RATE"].ToString(), Convert.ToDouble(dt.Rows[iTable - 1]["LT"]), Convert.ToDouble(dt.Rows[iTable - 1]["SET_RATIO"]));
}
else
{
UC_WS.BindingData(dt.Rows[iTable - 1]["LINE_CD"].ToString(), dt.Rows[iTable - 1]["LINE_NAME"].ToString(), dt.Rows[iTable - 1]["PLAN_QTY"].ToString(), dt.Rows[iTable - 1]["WIP_QTY"].ToString(), dt.Rows[iTable - 1]["RATE"].ToString(), 0, 0);
}
PlanQty += string.IsNullOrEmpty(dt.Rows[iTable - 1]["PLAN_QTY"].ToString()) ? 0 : Convert.ToInt32(dt.Rows[iTable - 1]["PLAN_QTY"]);
InvQty += string.IsNullOrEmpty(dt.Rows[iTable - 1]["WIP_QTY"].ToString()) ? 0 : Convert.ToInt32(dt.Rows[iTable - 1]["WIP_QTY"]);
}
iTable++;
}
}
lblPlanTot.Text = "Plan: " + string.Format("{0:n0}", PlanQty) + " Prs";
lblInvTot.Text = "Inv: " + string.Format("{0:n0}", InvQty) + " Prs";
double LeadTime = Math.Round(Convert.ToDouble(InvQty) / Convert.ToDouble(PlanQty), 1);
lblLeadTimeTot.Text = LeadTime.ToString() + " Day(s)";
}
void OnLabelPlantClick(Label label, string LINE_CD, string LINE_NM, int PLANT_QTY)
{
try
{
int iTable = 1;
if (!LINE_CD.Equals(LineCD_TEMP))
{
for (int i = 0; i < 3; i++)
{
for (int j = 0; j < 8; j++)
{
if (iTable <= layOutCount)
{
UC.UC_WS_INFO UC_WS = (UC.UC_WS_INFO)tblMain.GetControlFromPosition(j, i);
UC_WS.ChangeColor(true);
}
iTable++;
}
}
LineCD_TEMP = LINE_CD;
}
lbl_O_TRIP1.Text = "0 Prs";
lbl_O_TRIP2.Text = "0 Prs";
lbl_O_TRIP3.Text = "0 Prs";
lbl_O_TRIP4.Text = "0 Prs";
lblTotalTodayDeli.Text = "0 Prs";
if (label.BackColor == Color.Yellow)
{
label.BackColor = Color.FromArgb(0, 102, 204);
label.ForeColor = Color.White;
lblDeliveryWS.Text = string.Concat(ComVar.Var._strValue5, " Delivery");
//Data Trip
DataTable dt = null; //GetOutScnByTrip(DateTime.Now.ToString("yyyyMMdd"), ComVar.Var._strValue3, ComVar.Var._strValue4, "ALL");
lbl_O_TRIP1.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[0]["O_QTY"])) + " Prs";
lbl_O_TRIP2.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[1]["O_QTY"])) + " Prs";
lbl_O_TRIP3.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[2]["O_QTY"])) + " Prs";
lbl_O_TRIP4.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[3]["O_QTY"])) + " Prs";
lblTotalTodayDeli.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[4]["O_QTY"])) + " Prs";
double RateDelivery = Math.Round(Convert.ToDouble(lblTotalTodayDeli.Text.Replace("Prs", "").Replace(",", "").Trim()) / Convert.ToDouble(lblPlanTot.Text.Replace("Prs", "").Replace(",", "").Replace("Plan: ", "").Trim()) * 100, 1);
lblRatioDelivery.Text = RateDelivery.ToString() + "%";
//LINE = "ALL";
}
else
{
label.BackColor = Color.Yellow;
label.ForeColor = Color.Black;
lblDeliveryWS.Text = string.Concat(LINE_NM, " Delivery");
//Data Trip
DataTable dt = null;//GetOutScnByTrip("20190918", ComVar.Var._strValue3, ComVar.Var._strValue4, LINE_CD);
lbl_O_TRIP1.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[0]["O_QTY"])) + " Prs";
lbl_O_TRIP2.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[1]["O_QTY"])) + " Prs";
lbl_O_TRIP3.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[2]["O_QTY"])) + " Prs";
lbl_O_TRIP4.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[3]["O_QTY"])) + " Prs";
lblTotalTodayDeli.Text = string.Format("{0:n0}", Convert.ToInt32(dt.Rows[4]["O_QTY"])) + " Prs";
// double RateDelivery = Math.Round(Convert.ToDouble(lblTotalTodayDeli.Text.Replace("Prs", "").Replace(",", "").Trim()) / Convert.ToDouble(lblPlanTot.Text.Replace("Prs", "").Replace(",", "").Replace("Plan: ", "").Trim()) * 100, 1);
double RateDelivery = Math.Round(Convert.ToDouble(lblTotalTodayDeli.Text.Replace("Prs", "").Replace(",", "").Trim()) / Convert.ToDouble(PLANT_QTY) * 100, 1);
lblRatioDelivery.Text = RateDelivery.ToString() + "%";
//LINE = LINE_CD;
}
}
catch (Exception ex)
{ }
}
