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