private void LoadDataERPMQCToShow() { //Load data from m_ERPMQC LoadDataMQC dataMQC = new LoadDataMQC(); dept = "B01"; process = "MQC"; ListMQCshow = dataMQC.listMQCItemsOfDept(dateTimeFrom, dateTimeTo, dept, process); int topCount = CountColumn * CountRow; ListMQCTake = ListMQCshow.Take(topCount).ToList(); layoutMain.Controls.Clear(); if (ListMQCTake.Count <= topCount) { int countList = 0; for (int i = 0; i < CountRow; i++) { for (int j = 0; j < CountColumn; j++) { if (countList < ListMQCTake.Count) { // line.Dispose(); if (this.WindowState == FormWindowState.Normal) { line = new LineUI(ListMQCTake[countList], cb_Department.Text, 20); } else if (this.WindowState == FormWindowState.Maximized) { line = new LineUI(ListMQCTake[countList], cb_Department.Text, 25); } line.Name = ListMQCTake[countList].product; line.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); layoutMain.Controls.Add(line, j, i); countList++; } } } } lb_Clock.Text = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); }
//private void ScaleFont(Label lab) //{ // SizeF extent = TextRenderer.MeasureText(lab.Text, lab.Font); // float hRatio = lab.Height / extent.Height; // float wRatio = lab.Width / extent.Width; // float ratio = (hRatio < wRatio) ? hRatio : wRatio; // float newSize = lab.Font.Size * ratio; // lab.Font = new Font(lab.Font.FontFamily, newSize, lab.Font.Style); //} private void LoadDataERPMQCToShow() { //Load data from m_ERPMQC LoadDataMQC dataMQC = new LoadDataMQC(); dept = "B01"; process = "MQC"; ListMQCshow = dataMQC.listMQCItemsOfDept(dateTimeFrom, dateTimeTo, dept, process); var listshowline = ListMQCshow .OrderBy(u => u.line) .GroupBy(u => u.line) .Select(grp => grp.ToList()) .ToList(); List <MQCItem1> ListShowbyLine = new List <MQCItem1>(); foreach (var LineData in listshowline) { MQCItem1 mQC = new MQCItem1(); DateTime maxDate = LineData.Select(d => d.DateRun).Max(); mQC = LineData.Where(d => d.DateRun == maxDate).ToList()[0]; ListShowbyLine.Add(mQC); } int topCount = CountColumn * CountRow; //ListMQCTake = ListMQCshow.Take(topCount).ToList(); layoutMain.Controls.Clear(); if (ListShowbyLine.Count <= topCount) { int countList = 0; for (int i = 0; i < CountRow; i++) { for (int j = 0; j < CountColumn; j++) { if (countList < ListShowbyLine.Count) { // line.Dispose(); if (this.WindowState == FormWindowState.Normal) { line = new LineUI(ListShowbyLine[countList], cb_Department.Text, 20); } else if (this.WindowState == FormWindowState.Maximized) { line = new LineUI(ListShowbyLine[countList], cb_Department.Text, 25); } line.Name = ListShowbyLine[countList].line; line.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); layoutMain.Controls.Add(line, j, i); countList++; } } } } lb_Clock.Text = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); }