Пример #1
0
        public static bool UpdateLedLeftovers(LedLeftovers ledLeft)
        {
            bool release = true;

            #if DEBUG
            release = false;
            #endif

            bool result = true;

            if (release)
            {
                try
                {
                    List <Tuple <string, string, string> > flatList = new List <Tuple <string, string, string> >();
                    foreach (var led in ledLeft.RankA)
                    {
                        flatList.Add(new Tuple <string, string, string>(led.Nc12, led.ID, led.QtyLeft.ToString()));
                    }
                    foreach (var led in ledLeft.RankB)
                    {
                        flatList.Add(new Tuple <string, string, string>(led.Nc12, led.ID, led.QtyLeft.ToString()));
                    }
                    string lotNo = ledLeft.LotNo;

                    using (SqlConnection conn = new SqlConnection(@"Data Source=MSTMS010;Initial Catalog=MES;User Id=mes;Password=mes;"))
                    {
                        conn.Open();
                        foreach (var led in flatList)
                        {
                            SqlCommand cmd = new SqlCommand("sp_Spg_DaneBierzaceKompAktualneFULL_UPD_ilosc", conn);
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Parameters.Add(new SqlParameter("@NC12", led.Item1));
                            cmd.Parameters.Add(new SqlParameter("@ID", led.Item2));
                            cmd.Parameters.Add(new SqlParameter("@Ilosc", led.Item3));
                            //cmd.Parameters.Add(new SqlParameter("@ZlecenieString", lotNo);
                            cmd.ExecuteNonQuery();
                        }
                    }
                }

                catch (SqlException ex)
                {
                    MessageBox.Show(ex.Message);
                    result = false;
                }
            }
            return(result);
        }
Пример #2
0
        public Add_LED_leftovers(DataGridView grid, DataGridViewCell cell, List <LedLeftovers> ledLeftSaveBuffer)
        {
            InitializeComponent();
            this.grid = grid;
            this.cell = cell;
            this.ledLeftSaveBuffer = ledLeftSaveBuffer;
            ledsLeft = (LedLeftovers)cell.Tag;

            foreach (var reel in ledsLeft.RankA)
            {
                string qty = "";
                if (reel.QtyLeft < 0)
                {
                    qty = "";
                }
                else
                {
                    qty = reel.QtyLeft.ToString();
                }
                dataGridViewRankA.Rows.Add(reel.Nc12, reel.Rank, reel.ID, qty);
            }
            foreach (var reel in ledsLeft.RankB)
            {
                string qty = "";
                if (reel.QtyLeft < 0)
                {
                    qty = "";
                }
                else
                {
                    qty = reel.QtyLeft.ToString();
                }
                dataGridViewRankB.Rows.Add(reel.Nc12, reel.Rank, reel.ID, qty);
            }

            Tools.AutoSizeColumnsWidth(dataGridViewRankA);
            Tools.AutoSizeColumnsWidth(dataGridViewRankB);

            this.ActiveControl = textBoxQr;
        }
Пример #3
0
        private void UpdateCurrentModelEffNorm()
        {
            if (dataGridViewLg.Rows.Count > 0)
            {
                LedLeftovers ledLeftovers = (LedLeftovers)dataGridViewLg.Rows[0].Cells["ColumnButtonLed"].Tag;
                int          headsUsed    = 2;
                if (ledLeftovers.RankA.Count() > 0)
                {
                    headsUsed = ledLeftovers.RankA.Count * 2;
                }

                string model      = dataGridViewLg.Rows[0].Cells["ColumnModel"].Value.ToString();
                double orderedQty = double.Parse(dataGridViewLg.Rows[0].Cells["ColumnQty"].Value.ToString());
                var    norm       = EfficiencyCalculation.CalculateModelNormPerHour(model, smtLine, headsUsed);

                labelLgModelName.Text     = $"Czas cyklu: {norm.lineCT}sek";
                labelLgNormPerH.Text      = $"Norma szt/h: {norm.outputPerHour}";
                labelLgLotNorm.Text       = $"Norma na LOT: {Math.Round(orderedQty * 60 / norm.outputPerHour,0)}min";
                labelLgHeadCount.Text     = $"Używane głowice: {headsUsed}";
                labelLgNormModelName.Text = $"Norma modelu: {norm.modelSpec.model12Nc}";
            }
        }
Пример #4
0
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex > 0 & e.RowIndex >= 0)
            {
                DataGridViewCell cell = dataGridViewLg.Rows[e.RowIndex].Cells[e.ColumnIndex];
                if (dataGridViewLg.Columns[e.ColumnIndex].CellType.ToString() == "System.Windows.Forms.DataGridViewButtonCell")
                {
                    if (dataGridViewLg.Columns[e.ColumnIndex].Name == "ColumnButtonLed")
                    {
                        LedLeftovers      clickedLeftovers = (LedLeftovers)cell.Tag;
                        Add_LED_leftovers editLeftovers    = new Add_LED_leftovers(dataGridViewLg, cell, ledLeftSaveBuffer);
                        editLeftovers.ShowInTaskbar = false;
                        editLeftovers.ShowDialog();
                    }

                    if (dataGridViewLg.Columns[e.ColumnIndex].Name == "ColumnQualityCheck")
                    {
                        //DataGridViewCell cell = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
                        ChangeOverConfirmationCard changeOverForm = new ChangeOverConfirmationCard(cell);
                        changeOverForm.ShowDialog();
                    }
                }
            }
        }
Пример #5
0
        private void LoadLgRecordsFromDb()
        {
            suspendCellVelueChangedEvent = true;
            //DataCzasStart,DataCzasKoniec,LiniaSMT,OperatorSMT,NrZlecenia,Model,IloscWykonana,NGIlosc,ScrapIlosc,Kontrola1szt,KoncowkiLED
            DataTable     sqlTable = SqlOperations.GetLgSmtRecordsFromDb(22, smtLine);
            List <string> lotsList = new List <string>();

            foreach (DataRow row in sqlTable.Rows)
            {
                lotsList.Add(row["NrZlecenia"].ToString().Trim());
            }

            Dictionary <string, string[]> lotToRankABQty = SqlOperations.lotToRankABQty(lotsList.ToArray());

            //dataGridView1.SuspendLayout();
            foreach (DataRow row in sqlTable.Rows)
            {
                string model = row["Model"].ToString();
                if (model[2] == '-')
                {
                    if (lotToRankABQty.ContainsKey(row["NrZlecenia"].ToString()))
                    {
                        dataGridViewLg.Rows.Insert(0);

                        string lotNo   = row["NrZlecenia"].ToString().Trim();
                        string stencil = row["StencilQR"].ToString();

                        LedLeftovers ledLeft = CreateLedLeftovers(row["KoncowkiLED"].ToString(), lotNo, lotToRankABQty);

                        DataGridViewCheckBoxCell chbCell = (DataGridViewCheckBoxCell)dataGridViewLg.Rows[0].Cells[0];
                        chbCell.Value = true;

                        dataGridViewLg.Rows[0].Cells[1].Value = lotNo;
                        string connQty = Tools.GetNumberOfConnectors(row["Model"].ToString().Trim());
                        dataGridViewLg.Rows[0].Cells[3].Value = connQty;
                        if (connQty == "4")
                        {
                            dataGridViewLg.Rows[0].Cells[3].Style.ForeColor = Color.White;
                            dataGridViewLg.Rows[0].Cells[3].Style.BackColor = Color.DarkCyan;
                        }
                        dataGridViewLg.Rows[0].Cells[2].Value = row["Model"].ToString().Trim();
                        //dataGridView1.Rows[0].Cells[4].Value = kontrola pierwszej
                        dataGridViewLg.Rows[0].Cells[5].Value  = lotToRankABQty[lotNo][2];
                        dataGridViewLg.Rows[0].Cells[6].Value  = ledLeft.RankA[0].Nc12;
                        dataGridViewLg.Rows[0].Cells[7].Value  = lotToRankABQty[lotNo][0];
                        dataGridViewLg.Rows[0].Cells[8].Value  = lotToRankABQty[lotNo][1];
                        dataGridViewLg.Rows[0].Cells[9].Value  = row["IloscWykonana"].ToString().Trim();
                        dataGridViewLg.Rows[0].Cells[10].Value = row["NGIlosc"].ToString().Trim();
                        dataGridViewLg.Rows[0].Cells[11].Value = row["ScrapIlosc"].ToString().Trim();
                        dataGridViewLg.Rows[0].Cells[12].Tag   = ledLeft;
                        dataGridViewLg.Rows[0].Cells[12].Value = "OK";

                        dataGridViewLg.Rows[0].Cells[13].Value = DateTime.Parse(row["DataCzasStart"].ToString().Trim());
                        dataGridViewLg.Rows[0].Cells[14].Value = DateTime.Parse(row["DataCzasKoniec"].ToString().Trim());
                        Color cellColor = Tools.GetShiftColor((DateTime)row["DataCzasKoniec"]);
                        dataGridViewLg.Rows[0].Cells[13].Style.BackColor = cellColor;
                        dataGridViewLg.Rows[0].Cells[14].Style.BackColor = cellColor;
                        dataGridViewLg.Rows[0].Cells[15].Style.BackColor = cellColor;

                        dataGridViewLg.Rows[0].Cells[15].Value = row["OperatorSMT"].ToString().Trim();
                        dataGridViewLg.Rows[0].Cells[16].Value = stencil;
                    }
                }
            }
            Tools.AutoSizeColumnsWidth(dataGridViewLg);
            //dataGridView1.ResumeLayout();
            if (dataGridViewLg.Rows.Count > 0)
            {
                dataGridViewLg.CurrentCell = dataGridViewLg.Rows[0].Cells[0];
            }


            suspendCellVelueChangedEvent = false;
        }
Пример #6
0
        private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (!suspendCellVelueChangedEvent)
            {
                int ngIndex    = dataGridViewLg.Columns.IndexOf(dataGridViewLg.Columns["Ng"]);
                int scrapIndex = dataGridViewLg.Columns.IndexOf(dataGridViewLg.Columns["Scrap"]);
                // Debug.WriteLine("Cell value changed: " + e.RowIndex + " " + e.ColumnIndex);
                //calculate good qty
                if (dataGridViewLg.Rows.Count > 0 & (e.ColumnIndex == ngIndex || e.ColumnIndex == scrapIndex))
                {
                    int rowIndex = e.RowIndex;

                    DataGridViewCell ngCell    = dataGridViewLg.Rows[rowIndex].Cells["Ng"];
                    DataGridViewCell scrapCell = dataGridViewLg.Rows[rowIndex].Cells["Scrap"];

                    double ngValue    = -9999;
                    double scrapValue = -9999;

                    if (ngCell.Value != null)
                    {
                        if (!(double.TryParse(ngCell.Value.ToString(), out ngValue)))
                        {
                            dataGridViewLg.Rows[e.RowIndex].Cells[ngIndex].Value = null;
                            ngValue = -9999;
                        }
                        else
                        {
                            //ng ,0 will be 0
                            dataGridViewLg.Rows[e.RowIndex].Cells[ngIndex].Value = ngValue;
                        }
                    }

                    if (dataGridViewLg.Columns["Scrap"].Visible)
                    {
                        if (scrapCell.Value != null)
                        {
                            if (!(double.TryParse(scrapCell.Value.ToString(), out scrapValue)))
                            {
                                dataGridViewLg.Rows[e.RowIndex].Cells[scrapIndex].Value = null;
                                scrapValue = -9999;
                            }
                        }
                    }
                    else
                    {
                        scrapValue = 0;
                    }

                    if (ngValue > -9999 & scrapValue > -9999 & dataGridViewLg.Rows[e.RowIndex].Cells["ColumnQty"].Value != null)
                    {
                        double orderedQty = double.Parse(dataGridViewLg.Rows[e.RowIndex].Cells["ColumnQty"].Value.ToString());
                        double goodQty    = orderedQty - ngValue - scrapValue;
                        dataGridViewLg.Rows[e.RowIndex].Cells["goodQty"].Value = goodQty;
                    }
                    else
                    {
                        dataGridViewLg.Rows[e.RowIndex].Cells["goodQty"].Value = "";
                    }
                }

                //saving finished LOT
                foreach (DataGridViewRow row in dataGridViewLg.Rows)
                {
                    //Debug.WriteLine("Checking chkBox row:" + row.Index + " " + Convert.ToBoolean(row.Cells["ColumnSaved"].Value));
                    if (!Convert.ToBoolean(row.Cells["ColumnSaved"].Value))
                    {
                        if (IsRowReadyToBeSaved(row))
                        {
                            //Debug.WriteLine("Saving row:" + row.Index);
                            DataGridViewCheckBoxCell ch = (DataGridViewCheckBoxCell)row.Cells["ColumnSaved"];
                            suspendCellVelueChangedEvent = true;
                            lotFinished(ch, row.Index);
                            suspendCellVelueChangedEvent = false;

                            DateTime startDate       = (DateTime)row.Cells["StartDate"].Value;
                            DateTime endDate         = (DateTime)row.Cells["EndDate"].Value;
                            string   firstPieceCheck = "";

                            string stencil = Tools.getCellValue(row.Cells["Stencil"]);

                            LedLeftovers ledLeftovers  = (LedLeftovers)row.Cells["ColumnButtonLed"].Tag;
                            double       totalLedsUsed = 0;
                            string       leftovers     = ledLeftovers.RankA[0].ID + ":" + ledLeftovers.RankA[0].Nc12 + ":" + ledLeftovers.RankA[0].QtyLeft + "|" + ledLeftovers.RankB[0].ID + ":" + ledLeftovers.RankB[0].Nc12 + ":" + ledLeftovers.RankB[0].QtyLeft;
                            for (int i = 0; i < ledLeftovers.RankA.Count; i++)
                            {
                                totalLedsUsed += ledLeftovers.RankA[i].StartQty - ledLeftovers.RankA[i].QtyLeft;
                                totalLedsUsed += ledLeftovers.RankB[i].StartQty - ledLeftovers.RankB[i].QtyLeft;
                                if (i > 0)
                                {
                                    leftovers += "#" + ledLeftovers.RankA[i].ID + ":" + ledLeftovers.RankA[i].Nc12 + ":" + ledLeftovers.RankA[i].QtyLeft + "|" + ledLeftovers.RankB[i].ID + ":" + ledLeftovers.RankB[i].Nc12 + ":" + ledLeftovers.RankB[i].QtyLeft;
                                }
                            }

                            if (row.Cells["ColumnQualityCheck"].Tag != null)
                            {
                                firstPieceCheck = row.Cells["ColumnQualityCheck"].Tag.ToString();
                            }

                            string scrap = "0";
                            if (dataGridViewLg.Columns["Scrap"].Visible)
                            {
                                scrap = row.Cells["Scrap"].Value.ToString();
                            }

                            SqlOperations.SaveRecordToDb(
                                startDate,
                                endDate,
                                smtLine,
                                row.Cells["Operator"].Value.ToString(),
                                row.Cells["ColumnLot"].Value.ToString(),
                                row.Cells["ColumnModel"].Value.ToString(),
                                row.Cells["goodQty"].Value.ToString(),
                                row.Cells["Ng"].Value.ToString(),
                                scrap,
                                firstPieceCheck,
                                leftovers,
                                stencil,
                                "LG",
                                totalLedsUsed);
                            // Debug.WriteLine("Saved");
                            DgvTools.CleanUpLgiDgv(dataGridViewLg);
                        }
                    }
                }
                dataGridViewLg.HorizontalScrollingOffset = 0;
            }
        }
Пример #7
0
        private void buttonOK_Click(object sender, EventArgs e)
        {
            string stencil = "";

            if (radioButtonNewStencil.Checked)
            {
                using (var dial = new ScanStencilQr(currentLotData.Model))
                {
                    dial.ShowDialog();
                    if (dial.DialogResult == DialogResult.OK)
                    {
                        stencil = dial.stencil;
                    }
                }
                //Stencil QR reading
                //    ScanStencilQr fm = new ScanStencilQr(ref stencil, currentLotData.Model);
                //fm.ShowDialog();
            }
            else
            {
                stencil = (string)radioButtonCurrentStencil.Tag;
            }



            if (buttonOK.Text == "OK" & stencil.Trim() != "")
            {
                grid.SuspendLayout();

                string       lotNo    = textBoxLotNo.Text;
                LedLeftovers ledsLeft = new LedLeftovers(new List <RankStruc>(), new List <RankStruc>(), lotNo);

                foreach (DataGridViewRow rowA in dataGridViewRankA.Rows)
                {
                    string rankA        = labelRankA.Text.Split(new string[] { System.Environment.NewLine }, StringSplitOptions.None)[1];
                    string rankAId      = rowA.Cells["RankAId"].Value.ToString();
                    string rankA12NC    = rowA.Cells["RankANc12"].Value.ToString();
                    string iloscAString = rowA.Cells["RankAIlosc"].Value.ToString();
                    double rankAIlosc   = double.Parse(iloscAString);
                    ledsLeft.RankA.Add(new RankStruc(rankA, rankAId, rankA12NC, -1, rankAIlosc));
                }

                foreach (DataGridViewRow rowB in dataGridViewRankB.Rows)
                {
                    string rankB        = labelRankB.Text.Split(new string[] { System.Environment.NewLine }, StringSplitOptions.None)[1];
                    string rankBId      = rowB.Cells["rankBId"].Value.ToString();
                    string rankB12NC    = rowB.Cells["RankBNc12"].Value.ToString();
                    string iloscBString = rowB.Cells["rankBIlosc"].Value.ToString();
                    double rankBIlosc   = double.Parse(iloscBString);
                    ledsLeft.RankB.Add(new RankStruc(rankB, rankBId, rankB12NC, -1, rankBIlosc));
                }

                grid.Rows.Insert(0, 1);
                int lastRow = 0;
                grid.Rows[lastRow].Cells["ColumnSaved"].Style.BackColor = Color.Red;
                grid.Rows[lastRow].Cells["ColumnLot"].Value             = textBoxLotNo.Text;
                grid.Rows[lastRow].Cells["ColumnModel"].Value           = currentLotData.Model;
                grid.Rows[lastRow].Cells["ColumnQty"].Value             = currentLotData.OrderedQty;
                grid.Rows[lastRow].Cells["ColumnRankA"].Value           = currentLotData.RankA;
                grid.Rows[lastRow].Cells["ColumnRankB"].Value           = currentLotData.RankB;
                grid.Rows[lastRow].Cells["Rank12NC"].Value                  = ledsLeft.RankA[0].Nc12;
                grid.Rows[lastRow].Cells["ColumnButtonLed"].Value           = "BRAK";
                grid.Rows[lastRow].Cells["ColumnButtonLed"].Style.BackColor = Color.Red;
                grid.Rows[lastRow].Cells["ColumnQualityCheck"].Value        = "";
                grid.Rows[lastRow].Cells["StartDate"].Value                 = DateTime.Now;
                grid.Rows[lastRow].Cells["ColumnButtonLed"].Tag             = ledsLeft;
                grid.Rows[lastRow].Cells["Operator"].Value                  = comboBoxOperator.Text;
                grid.Rows[lastRow].Cells["Stencil"].Value = stencil;
                grid.Rows[lastRow].Cells["connQty"].Value = Tools.GetNumberOfConnectors(currentLotData.Model);

                if (grid.Rows[lastRow].Cells["connQty"].Value.ToString() == "4")
                {
                    //grid.Rows[lastRow].Cells["connQty"].Style.ForeColor = System.Drawing.Color.Red;
                    grid.Rows[lastRow].Cells["connQty"].Style.ForeColor = Color.White;
                    grid.Rows[lastRow].Cells["connQty"].Style.BackColor = Color.DarkCyan;
                }

                if (grid.Rows.Count == 1)
                {
                    foreach (DataGridViewColumn col in grid.Columns)
                    {
                        col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
                    }
                    grid.Rows[lastRow].Cells["ColumnQualityCheck"].Style.BackColor = Color.Red;
                    grid.Rows[lastRow].Cells["ColumnQualityCheck"].Value           = "BRAK";
                }
                else
                {
                    if (Tools.getCellValue(grid.Rows[lastRow + 1].Cells["ColumnModel"]) != "")
                    {
                        if (grid.Rows[lastRow].Cells["ColumnModel"].Value.ToString() != grid.Rows[lastRow + 1].Cells["ColumnModel"].Value.ToString())
                        {
                            grid.Rows[lastRow].Cells["ColumnQualityCheck"].Style.BackColor = Color.Red;
                            grid.Rows[lastRow].Cells["ColumnQualityCheck"].Value           = "BRAK";
                        }
                    }
                }



                DgvTools.CleanUpLgiDgv(grid);
                grid.FirstDisplayedScrollingRowIndex = 0;
                this.Close();
                grid.ResumeLayout();
            }
            else
            {
            #if DEBUG
                grid.Columns["Stencil"].Visible = true;
                grid.Rows.Insert(0, 1);
                grid.Rows[0].Cells["StartDate"].Value             = System.DateTime.Now;
                grid.Rows[0].Cells["ColumnSaved"].Style.BackColor = Color.Red;
                ScanStencilQr fm = new ScanStencilQr(currentLotData.Model);
                fm.ShowDialog();
            #endif
            }
        }
Пример #8
0
        ///<summary>
        ///<para>double[diodeWaste, moduleWaste]</para>
        ///</summary>
        public static double[] CalculateLedDiodeWasteLevel(DataGridView grid, Dictionary <string, EfficiencyNormsPerModel> modelNorm)
        {
            List <double> percentageLotWaste = new List <double>();
            List <string> lotsList           = new List <string>();
            double        moduleWasteSum     = 0;
            double        goodModuleSum      = 0;


            foreach (DataGridViewRow row in grid.Rows)
            {
                if (row.Cells["ColumnLot"].Value == null)
                {
                    continue;
                }
                lotsList.Add(row.Cells["ColumnLot"].Value.ToString().Trim());
            }
            //Dictionary<string, string[]> lotToRankABQty = SqlOperations.lotToRankABQty(lotsList.ToArray());
            Dictionary <string, string[]> lotToRankABQty = new Dictionary <string, string[]>();

            foreach (DataGridViewRow row in grid.Rows)
            {
                if (row.Cells["Ng"].Value == null)
                {
                    continue;
                }
                string lotNo = row.Cells["ColumnLot"].Value.ToString().Trim();
                //string ledLeftRaw = row.Cells["ColumnButtonLed"].Value.ToString().Trim();
                string model = row.Cells["ColumnModel"].Value.ToString().Trim();
                if (!modelNorm.ContainsKey(model))
                {
                    continue;
                }

                LedLeftovers ledLeft = (LedLeftovers)row.Cells["ColumnButtonLed"].Tag;


                double goodQty = Int32.Parse(row.Cells["GoodQty"].Value.ToString().Trim());
                double ngQty   = Int32.Parse(row.Cells["Ng"].Value.ToString().Trim());
                double allQty  = goodQty + ngQty;

                moduleWasteSum += ngQty;
                goodModuleSum  += goodQty;

                //if (row.Cells["ColumnLot"].Value.ToString() == "1327848")
                //    Debug.WriteLine("tada");

                model = model.Substring(0, 6) + "XXX" + model.Substring(9, 1);
                double rankAQty      = modelNorm[model].QtyRankA;
                double rankBQty      = modelNorm[model].QtyRankB;
                double ledQty        = rankAQty + rankBQty;
                double ledPerLotNorm = allQty * ledQty;

                double ledPerReel = 3000;
                if (row.Cells["Rank12NC"].Value.ToString().Length < 11)
                {
                    ledPerReel = 3500;
                }
                double ledPerLot       = ledLeft.RankA.Count * 2 * ledPerReel;
                double expectedLedLeft = ledPerLot - ledPerLotNorm;
                if (expectedLedLeft < 0)
                {
                    continue;
                }

                double realLedLeft = 0;
                foreach (var led in ledLeft.RankA)
                {
                    realLedLeft += led.QtyLeft;
                }
                foreach (var led in ledLeft.RankB)
                {
                    realLedLeft += led.QtyLeft;
                }
                double wasteDifference = expectedLedLeft - realLedLeft;

                percentageLotWaste.Add(((expectedLedLeft - realLedLeft) / ledPerLot) * 100);
            }

            if (goodModuleSum > 0)
            {
                return(new double[] { Math.Round(percentageLotWaste.Average(), 2), Math.Round(moduleWasteSum / goodModuleSum, 4) * 100 });
            }
            else
            {
                return(new double[] { 0, 0 });
            }
        }