Ejemplo n.º 1
0
            /// <summary>
            /// Handles user clicks of the button
            /// </summary>
            /// <param name="sender"></param>
            /// <param name="e"></param>
            public void MyGridButtonXEditControlClick(object sender, EventArgs e)
            {
                Konektorovanie f = (Konektorovanie)Application.OpenForms[1];
                // GridPanel panel = f.gridMaterialBom.ActiveRow.GridPanel;

                // GridRow row = panel.ActiveRow as GridRow;
                //string id_vymazat = Convert.ToString(row.Cells[1].Value);
            }
Ejemplo n.º 2
0
        private void btnSaveClose_Click_1(object sender, EventArgs e)
        {
            try
            {
                ComboBoxEx       Objednavka    = Parent.Parent.Controls.Find("comboObjednavka", true).FirstOrDefault() as ComboBoxEx;
                MaskedTextBoxAdv PoradoveCislo = Parent.Parent.Controls.Find("PoradoveCislo", true).FirstOrDefault() as MaskedTextBoxAdv;
                TextBoxX         Rework        = Parent.Parent.Controls.Find("txtRework", true).FirstOrDefault() as TextBoxX;
                Form             currentForm   = Form.ActiveForm;
                string           form          = currentForm.Name;
                if (form == "Konektorovanie")
                {
                    #region konektorovanie
                    Konektorovanie f = (Konektorovanie)Application.OpenForms[1];
                    {
                        if (Properties.Settings.Default.formulare_otvorenie == true)
                        {
                            string        connectionString = Class1.dbs_nastavenia("DBS_connection_string");
                            SqlConnection sqlConn          = new SqlConnection(connectionString);
                            SqlCommand    sqlComm          = new SqlCommand();
                            sqlComm = sqlConn.CreateCommand();
                            SqlCommand sqlCommKonektorovanie = new SqlCommand();
                            sqlCommKonektorovanie             = sqlConn.CreateCommand();
                            sqlCommKonektorovanie.CommandText = @"UPDATE tblObjednavky SET SylexObjednavka=@SylexObjednavka,Zakazka=@Zakazka,Snimac=@Snimac,PnVlakna=@PnVlakna,LotVlakna=@LotVlakna,ObjVytvoril=@ObjVytvoril,ObjVytvorilDatum=@ObjVytvorilDatum,PopisVlakna=@PopisVlakna,Rework=@Rework,StavObjednavky=@StavObjednavky,FBGSSN=@FBGSSN,spektrum_label=@spektrum_label,vl_label=@vl_label,snapshot_label=@snapshot_label,spektrum_nolabel=@spektrum_nolabel,vl_nolabel=@vl_nolabel,snapshot_nolabel=@snapshot_nolabel,vlhkost=@vlhkost,teplota=@teplota,tlak=@tlak,product=@product,zakaznicka_objednavka=@zakaznicka_objednavka,zakaznik=@zakaznik,PopisChyby=@PopisChyby,ChybaKto1=@ChybaKto1,ChybaKto2=@ChybaKto2,CasChybySpolu=@CasChybySpolu,ChybuZapisal=@ChybuZapisal,ChybuZapisalKedy=@ChybuZapisalKedy, Formular=@Formular WHERE SylexObjednavka=@SylexObjednavka AND Rework=@Rework";
                            sqlCommKonektorovanie.Parameters.AddWithValue("@SylexObjednavka", Objednavka.Text + "/" + PoradoveCislo.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@Zakazka", f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@Formular", comboBoxItem4.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@Snimac", textBoxItem2.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@PnVlakna", f.ovladaciPanelObjednavkyNEW1.txtPNvlakna.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@LotVlakna", f.ovladaciPanelObjednavkyNEW1.txtLotVlakna.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@ObjVytvoril", f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@ObjVytvorilDatum", Convert.ToDateTime(f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text));
                            sqlCommKonektorovanie.Parameters.AddWithValue("@PopisVlakna", f.ovladaciPanelObjednavkyNEW1.txtPopisVlakna.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@Rework", f.ovladaciPanelObjednavkyNEW1.txtRework.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@StavObjednavky", comboBoxItem3.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@FBGSSN", f.ovladaciPanelObjednavkyNEW1.txtFBGSSN.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@spektrum_label", f.vystupnaKontrolaScr1.txtScrSpektrumVystupStitok.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@vl_label", f.vystupnaKontrolaScr1.txtScrVlVystupStitok.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@snapshot_label", f.vystupnaKontrolaScr1.txtScrSnapshotVystupStitok.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@spektrum_nolabel", f.vystupnaKontrolaScr1.txtScrSpektrumVystupBezStitok.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@vl_nolabel", f.vystupnaKontrolaScr1.txtScrVlVystupBezStitok.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@snapshot_nolabel", f.vystupnaKontrolaScr1.txtScrSnapshotVystupBezStitok.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@vlhkost", f.vystupnaKontrolaScr1.txtVlhkostVzduchuVystup.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@teplota", f.vystupnaKontrolaScr1.txtTeplotaPracoviskaVystup.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@tlak", f.vystupnaKontrolaScr1.txtTlakVystup.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@product", f.ovladaciPanelObjednavkyNEW1.Produkt.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@zakaznicka_objednavka", f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@zakaznik", f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@PopisChyby", f.zaznamChyb.txtPopisChyby.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@ChybaKto1", f.zaznamChyb.comboTree1.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@ChybaKto2", f.zaznamChyb.comboTree2.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@CasChybySpolu", f.zaznamChyb.textBoxX2.Text);
                            sqlCommKonektorovanie.Parameters.AddWithValue("@ChybuZapisal", f.zaznamChyb.txtZapisal.Text);

                            if (string.IsNullOrWhiteSpace(f.zaznamChyb.txtZapisalDna.Text))
                            {
                                sqlCommKonektorovanie.Parameters.AddWithValue("@ChybuZapisalKedy", DBNull.Value);
                            }
                            else
                            {
                                sqlCommKonektorovanie.Parameters.AddWithValue("@ChybuZapisalKedy", Convert.ToDateTime(f.zaznamChyb.txtZapisalDna.Text));
                            }


                            sqlConn.Open();
                            sqlCommKonektorovanie.ExecuteNonQuery();

                            sqlComm.CommandText = @"UPDATE tblZakazky SET CisloZakazky=@CisloZakazky,ZakazkaVytvoril=@ZakazkaVytvoril,ZakazkaVytvorilKedy=@ZakazkaVytvorilKedy,StavZakazky=@StavZakazky,Zakaznik=@Zakaznik,ZakaznickaObjednavka=@ZakaznickaObjednavka WHERE CisloZakazky=@CisloZakazky";
                            sqlComm.Parameters.AddWithValue("@CisloZakazky", f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text);
                            sqlComm.Parameters.AddWithValue("@ZakazkaVytvoril", f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text);
                            sqlComm.Parameters.AddWithValue("@ZakazkaVytvorilKedy", Convert.ToDateTime(f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text));
                            sqlComm.Parameters.AddWithValue("@StavZakazky", "Rozpracované");
                            sqlComm.Parameters.AddWithValue("@Zakaznik", f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text);
                            sqlComm.Parameters.AddWithValue("@ZakaznickaObjednavka", f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text);
                            sqlComm.ExecuteNonQuery();
                            sqlConn.Close();
                        }

                        else
                        {
                            string        connectionString = Class1.dbs_nastavenia("DBS_connection_string");
                            SqlConnection sqlConn          = new SqlConnection(connectionString);
                            SqlCommand    sqlComm          = new SqlCommand();
                            sqlComm             = sqlConn.CreateCommand();
                            sqlComm.CommandText = @"INSERT INTO tblObjednavky (SylexObjednavka,Zakazka,Snimac,PnVlakna,LotVlakna,ObjVytvoril,ObjVytvorilDatum,PopisVlakna,Rework,StavObjednavky,FBGSSN,spektrum_label,vl_label,snapshot_label,spektrum_nolabel,vl_nolabel,snapshot_nolabel,vlhkost,teplota,tlak,product,Zakaznik,zakaznicka_objednavka,PopisChyby,ChybaKto1,ChybaKto2,CasChybySpolu,ChybuZapisal,ChybuZapisalKedy,Formular) VALUES (@SylexObjednavka,@Zakazka,@Snimac,@PnVlakna,@LotVlakna,@ObjVytvoril,@ObjVytvorilDatum,@PopisVlakna,@Rework,@StavObjednavky,@FBGSSN,@spektrum_label,@vl_label,@snapshot_label,@spektrum_nolabel,@vl_nolabel,@snapshot_nolabel,@vlhkost,@teplota,@tlak,@product,@Zakaznik,@zakaznicka_objednavka,@PopisChyby,@ChybaKto1,@ChybaKto2,@CasChybySpolu,@ChybuZapisal,@ChybuZapisalKedy,@Formular)";
                            sqlComm.Parameters.Add(new SqlParameter("@SylexObjednavka", SqlDbType.VarChar, 255)).Value       = f.ovladaciPanelObjednavkyNEW1.comboObjednavka.Text + "/" + f.ovladaciPanelObjednavkyNEW1.PoradoveCislo.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Zakazka", SqlDbType.NChar, 10)).Value                  = f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Formular", SqlDbType.NVarChar, 255)).Value             = comboBoxItem4.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Snimac", SqlDbType.NVarChar, 255)).Value               = textBoxItem2.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@PnVlakna", SqlDbType.VarChar, 255)).Value              = f.ovladaciPanelObjednavkyNEW1.txtPNvlakna.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@LotVlakna", SqlDbType.VarChar, 255)).Value             = f.ovladaciPanelObjednavkyNEW1.txtLotVlakna.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ObjVytvoril", SqlDbType.VarChar, 255)).Value           = f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ObjVytvorilDatum", SqlDbType.DateTime, 0)).Value       = f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@PopisVlakna", SqlDbType.VarChar, 255)).Value           = f.ovladaciPanelObjednavkyNEW1.txtPopisVlakna.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Rework", SqlDbType.VarChar, 255)).Value                = f.ovladaciPanelObjednavkyNEW1.txtRework.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@StavObjednavky", SqlDbType.VarChar, 255)).Value        = comboBoxItem3.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@FBGSSN", SqlDbType.VarChar, 255)).Value                = f.ovladaciPanelObjednavkyNEW1.txtFBGSSN.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@spektrum_label", SqlDbType.NVarChar, 255)).Value       = f.vystupnaKontrolaScr1.txtScrSpektrumVystupStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@vl_label", SqlDbType.NVarChar, 255)).Value             = f.vystupnaKontrolaScr1.txtScrVlVystupStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@snapshot_label", SqlDbType.NVarChar, 255)).Value       = f.vystupnaKontrolaScr1.txtScrSnapshotVystupStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@spektrum_nolabel", SqlDbType.NVarChar, 255)).Value     = f.vystupnaKontrolaScr1.txtScrSpektrumVystupBezStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@vl_nolabel", SqlDbType.NVarChar, 255)).Value           = f.vystupnaKontrolaScr1.txtScrVlVystupBezStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@snapshot_nolabel", SqlDbType.NVarChar, 255)).Value     = f.vystupnaKontrolaScr1.txtScrSnapshotVystupBezStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@vlhkost", SqlDbType.VarChar, 255)).Value               = f.vystupnaKontrolaScr1.txtVlhkostVzduchuVystup.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@teplota", SqlDbType.VarChar, 255)).Value               = f.vystupnaKontrolaScr1.txtTeplotaPracoviskaVystup.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@tlak", SqlDbType.VarChar, 255)).Value                  = f.vystupnaKontrolaScr1.txtTlakVystup.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@product", SqlDbType.VarChar, 255)).Value               = f.ovladaciPanelObjednavkyNEW1.Produkt.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Zakaznik", SqlDbType.VarChar, 255)).Value              = f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@zakaznicka_objednavka", SqlDbType.VarChar, 255)).Value = f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@PopisChyby", SqlDbType.VarChar, 255)).Value            = f.zaznamChyb.txtPopisChyby.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ChybaKto1", SqlDbType.VarChar, 50)).Value              = f.zaznamChyb.comboTree1.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ChybaKto2", SqlDbType.VarChar, 50)).Value              = f.zaznamChyb.comboTree2.Text;
                            string time   = f.zaznamChyb.textBoxX2.Text;
                            var    result = Convert.ToDateTime(time);
                            string test   = result.ToString("hh:mm:ss", CultureInfo.CurrentCulture);
                            sqlComm.Parameters.Add(new SqlParameter("@CasChybySpolu", SqlDbType.Time, 7)).Value    = f.zaznamChyb.textBoxX2.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ChybuZapisal", SqlDbType.VarChar, 50)).Value = f.zaznamChyb.txtZapisal.Text;

                            if (string.IsNullOrWhiteSpace(f.zaznamChyb.txtZapisalDna.Text))
                            {
                                sqlComm.Parameters.Add(new SqlParameter("@ChybuZapisalKedy", SqlDbType.DateTime, 0)).Value = DBNull.Value;
                            }
                            else
                            {
                                sqlComm.Parameters.Add(new SqlParameter("@ChybuZapisalKedy", SqlDbType.DateTime, 0)).Value = f.zaznamChyb.txtZapisalDna.Text;
                            }

                            sqlConn.Open();
                            sqlComm.ExecuteNonQuery();
                            sqlComm             = sqlConn.CreateCommand();
                            sqlComm.CommandText = @"SELECT COUNT (CisloZakazky) FROM tblZakazky WHERE CisloZakazky = '" + f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text + "' ";

                            int temp = Convert.ToInt32(sqlComm.ExecuteScalar().ToString());
                            if (temp > 0)
                            {
                                sqlComm.CommandText = @"UPDATE tblZakazky SET CisloZakazky=@CisloZakazky,ZakazkaVytvoril=@ZakazkaVytvoril,ZakazkaVytvorilKedy=@ZakazkaVytvorilKedy,StavZakazky=@StavZakazky,Zakaznik=@Zakaznik,ZakaznickaObjednavka=@ZakaznickaObjednavka WHERE CisloZakazky=@CisloZakazky";
                                sqlComm.Parameters.AddWithValue("@CisloZakazky", f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text);
                                sqlComm.Parameters.AddWithValue("@ZakazkaVytvoril", f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text);
                                sqlComm.Parameters.AddWithValue("@ZakazkaVytvorilKedy", Convert.ToDateTime(f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text));
                                sqlComm.Parameters.AddWithValue("@StavZakazky", "Rozpracované");
                                sqlComm.Parameters.AddWithValue("@Zakaznik", f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text);
                                sqlComm.Parameters.AddWithValue("@ZakaznickaObjednavka", f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text);
                                sqlComm.ExecuteNonQuery();
                                sqlConn.Close();
                            }
                            else
                            {
                                sqlComm             = sqlConn.CreateCommand();
                                sqlComm.CommandText = @"INSERT INTO tblZakazky (CisloZakazky,ZakazkaVytvoril,ZakazkaVytvorilKedy,StavZakazky,Zakaznik,ZakaznickaObjednavka) VALUES (@CisloZakazky,@ZakazkaVytvoril,@ZakazkaVytvorilKedy,@StavZakazky,@Zakaznik,@ZakaznickaObjednavka)";
                                sqlComm.Parameters.Add(new SqlParameter("@CisloZakazky", SqlDbType.VarChar, 255)).Value         = f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text;
                                sqlComm.Parameters.Add(new SqlParameter("@ZakazkaVytvoril", SqlDbType.VarChar, 255)).Value      = f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text;
                                sqlComm.Parameters.Add(new SqlParameter("@ZakazkaVytvorilKedy", SqlDbType.DateTime, 0)).Value   = f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text;
                                sqlComm.Parameters.Add(new SqlParameter("@StavZakazky", SqlDbType.NChar, 25)).Value             = "Rozpracované";
                                sqlComm.Parameters.Add(new SqlParameter("@Zakaznik", SqlDbType.VarChar, 255)).Value             = f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text;
                                sqlComm.Parameters.Add(new SqlParameter("@ZakaznickaObjednavka", SqlDbType.VarChar, 255)).Value = f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text;
                                sqlComm.ExecuteNonQuery();
                                sqlConn.Close();
                            }
                        }

                        Class1.update_grid_konektorovanie(ParentForm, false);
                        Class1.update_grid_zniceny_material(ParentForm, false);

                        Class1.set_sort_main_form(); //nastavi zobrazenie v hlavnom formulari
                        if (close_save_status == 0)  // 0 = zavrie formular, 1= ulozi ale nezavrie formular
                        {
                            f.Close();
                        }
                    }
                }
                #endregion konektorovanie

                else if (form == "Konektorovanie2")
                {
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Ejemplo n.º 3
0
        private void btnPrevious_Click(object sender, EventArgs e)
        {
            ComboBoxEx       Objednavka    = Parent.Parent.Controls.Find("comboObjednavka", true).FirstOrDefault() as ComboBoxEx;
            MaskedTextBoxAdv PoradoveCislo = Parent.Parent.Controls.Find("PoradoveCislo", true).FirstOrDefault() as MaskedTextBoxAdv;
            SuperGridControl grid_kon      = Parent.Parent.Controls.Find("superGridControl1", true).FirstOrDefault() as SuperGridControl;

            close_save_status = 1;
            btnSaveClose_Click_1(sender, e);
            close_save_status = 0;

            int pocet_objednavok       = Class1.count_orders(Objednavka.Text);
            int por_cislo              = Convert.ToInt32(PoradoveCislo.Text);
            int aktualna_objednavka_pc = Convert.ToInt32(por_cislo.ToString("D4"));
            int nasledujuca_objednavka = Convert.ToInt32((por_cislo - 1).ToString("D4"));

            if (nasledujuca_objednavka == 0)
            {
                nasledujuca_objednavka = Convert.ToInt32((pocet_objednavok).ToString("D4"));
            }

            string objednavka_final = Objednavka.Text + "/" + Convert.ToString(nasledujuca_objednavka.ToString("D4"));

            Form   currentForm = Form.ActiveForm;
            string form        = currentForm.Name;

            if (form == "Konektorovanie")
            {
                #region konektorovanie
                Konektorovanie f = (Konektorovanie)Application.OpenForms[1];
                {
                    string zakazka = Convert.ToString(Properties.Settings.Default.CisloZakazky);
                    grid_kon.PrimaryGrid.Columns[1].FilterExpr = "[Objednavka] = '" + objednavka_final + "' & [Rework] = " + 0;                             //tabulka konektorovanie
                    f.zaznamChybMaterial.gridMaterialBom.PrimaryGrid.Columns[1].FilterExpr = "[objednavka] = '" + objednavka_final + "' & [Rework] = " + 0; //tabulka bom
                    using (SqlConnection connection = new SqlConnection(Class1.dbs_nastavenia("DBS_connection_string")))
                    {
                        SqlCommand command =
                            new SqlCommand("select * FROM tblObjednavky WHERE SylexObjednavka='" + objednavka_final + "' AND Rework=" + 0, connection);
                        connection.Open();

                        SqlDataReader read = command.ExecuteReader();

                        while (read.Read())
                        {
                            f.ovladaciPanelObjednavkyNEW1.comboObjednavka.Text        = Class1.left((read["SylexObjednavka"].ToString()), 6);
                            f.ovladaciPanelObjednavkyNEW1.PoradoveCislo.Text          = Class1.right((read["SylexObjednavka"].ToString()), 4);
                            f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text            = (read["Zakazka"].ToString());
                            f.ovladaciPanelFormulare1.comboBoxItem4.Text              = (read["Formular"].ToString());
                            f.ovladaciPanelFormulare1.textBoxItem2.Text               = (read["Snimac"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtPNvlakna.Text            = (read["PnVlakna"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtLotVlakna.Text           = (read["LotVlakna"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text         = (read["ObjVytvoril"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text     = (read["ObjVytvorilDatum"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtPopisVlakna.Text         = (read["PopisVlakna"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtRework.Text              = (read["Rework"].ToString());
                            f.ovladaciPanelFormulare1.comboBoxItem3.Text              = (read["StavObjednavky"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.txtFBGSSN.Text              = (read["FBGSSN"].ToString());
                            f.vystupnaKontrolaScr1.txtScrSpektrumVystupStitok.Text    = (read["spektrum_label"].ToString());
                            f.vystupnaKontrolaScr1.txtScrVlVystupStitok.Text          = (read["vl_label"].ToString());
                            f.vystupnaKontrolaScr1.txtScrSnapshotVystupStitok.Text    = (read["snapshot_label"].ToString());
                            f.vystupnaKontrolaScr1.txtScrSpektrumVystupBezStitok.Text = (read["spektrum_nolabel"].ToString());
                            f.vystupnaKontrolaScr1.txtScrVlVystupBezStitok.Text       = (read["vl_nolabel"].ToString());
                            f.vystupnaKontrolaScr1.txtScrSnapshotVystupBezStitok.Text = (read["snapshot_nolabel"].ToString());
                            f.vystupnaKontrolaScr1.txtVlhkostVzduchuVystup.Text       = (read["vlhkost"].ToString());
                            f.vystupnaKontrolaScr1.txtTeplotaPracoviskaVystup.Text    = (read["teplota"].ToString());
                            f.vystupnaKontrolaScr1.txtTlakVystup.Text        = (read["tlak"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.Produkt.Text       = (read["Product"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text      = (read["Zakaznik"].ToString());
                            f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text = (read["zakaznicka_objednavka"].ToString());
                            f.zaznamChyb.txtPopisChyby.Text = (read["PopisChyby"].ToString());
                            f.zaznamChyb.comboTree1.Text    = (read["ChybaKto1"].ToString());
                            f.zaznamChyb.comboTree2.Text    = (read["ChybaKto2"].ToString());
                            f.zaznamChyb.textBoxX2.Text     = (read["CasChybySpolu"].ToString());
                            f.zaznamChyb.txtZapisal.Text    = (read["ChybuZapisal"].ToString());
                            f.zaznamChyb.txtZapisalDna.Text = (read["ChybuZapisalKedy"].ToString());
                        }
                        read.Close();
                    }
                }


                #endregion konektorovanie
            }
        }
Ejemplo n.º 4
0
        private void btnDuplikovat_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Naozaj chcete duplikovať túto objednávku ?", "Duplikácia",
                                MessageBoxButtons.YesNo, MessageBoxIcon.Question)
                == DialogResult.Yes)
            {
                MaskedTextBoxAdv PoradoveCislo = Parent.Parent.Controls.Find("PoradoveCislo", true).FirstOrDefault() as MaskedTextBoxAdv;
                ComboBoxEx       Objednavka    = Parent.Parent.Controls.Find("comboObjednavka", true).FirstOrDefault() as ComboBoxEx;
                string           obj           = Objednavka.Text;
                int pocet_zaznamov             = Convert.ToInt32(txtPocetDuplikatov.Text);
                int poradove_cislo             = Convert.ToInt32(PoradoveCislo.Text);

                if (string.IsNullOrWhiteSpace(txtPocetDuplikatov.Text))
                {
                    MessageBox.Show("Musíš vyplniť počet duplikátov");
                    return;
                }
                Form   currentForm = Form.ActiveForm;
                string form        = Convert.ToString(currentForm.Name);

                try
                {
                    Konektorovanie f = (Konektorovanie)Application.OpenForms[1];
                    for (int i = 0; i <= pocet_zaznamov; i++)
                    {
                        if (form == "Konektorovanie")
                        {
                            #region konektorovanie

                            string        connectionString = Class1.dbs_nastavenia("DBS_connection_string");
                            SqlConnection sqlConn          = new SqlConnection(connectionString);
                            SqlCommand    sqlComm          = new SqlCommand();
                            sqlComm = sqlConn.CreateCommand();
                            int poradove_cislo_final = i + poradove_cislo;
                            sqlComm.CommandText = @"INSERT INTO tblObjednavky (SylexObjednavka,Zakazka,Snimac,PnVlakna,LotVlakna,ObjVytvoril,ObjVytvorilDatum,PopisVlakna,Rework,StavObjednavky,FBGSSN,spektrum_label,vl_label,snapshot_label,spektrum_nolabel,vl_nolabel,snapshot_nolabel,vlhkost,teplota,tlak,product,Zakaznik,zakaznicka_objednavka,PopisChyby,ChybaKto1,ChybaKto2,CasChybySpolu,ChybuZapisal,ChybuZapisalKedy,Formular) VALUES (@SylexObjednavka,@Zakazka,@Snimac,@PnVlakna,@LotVlakna,@ObjVytvoril,@ObjVytvorilDatum,@PopisVlakna,@Rework,@StavObjednavky,@FBGSSN,@spektrum_label,@vl_label,@snapshot_label,@spektrum_nolabel,@vl_nolabel,@snapshot_nolabel,@vlhkost,@teplota,@tlak,@product,@Zakaznik,@zakaznicka_objednavka,@PopisChyby,@ChybaKto1,@ChybaKto2,@CasChybySpolu,@ChybuZapisal,@ChybuZapisalKedy,@Formular)";
                            sqlComm.Parameters.Add(new SqlParameter("@SylexObjednavka", SqlDbType.VarChar, 255)).Value       = f.ovladaciPanelObjednavkyNEW1.comboObjednavka.Text + "/" + poradove_cislo_final.ToString("D4");
                            sqlComm.Parameters.Add(new SqlParameter("@Zakazka", SqlDbType.NChar, 10)).Value                  = f.ovladaciPanelObjednavkyNEW1.comboBoxEx1.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Formular", SqlDbType.NVarChar, 255)).Value             = comboBoxItem4.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Snimac", SqlDbType.NVarChar, 255)).Value               = textBoxItem2.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@PnVlakna", SqlDbType.VarChar, 255)).Value              = f.ovladaciPanelObjednavkyNEW1.txtPNvlakna.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@LotVlakna", SqlDbType.VarChar, 255)).Value             = f.ovladaciPanelObjednavkyNEW1.txtLotVlakna.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ObjVytvoril", SqlDbType.VarChar, 255)).Value           = f.ovladaciPanelObjednavkyNEW1.txtObjVytvoril.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ObjVytvorilDatum", SqlDbType.DateTime, 0)).Value       = f.ovladaciPanelObjednavkyNEW1.txtObjVytvorilKedy.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@PopisVlakna", SqlDbType.VarChar, 255)).Value           = f.ovladaciPanelObjednavkyNEW1.txtPopisVlakna.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Rework", SqlDbType.VarChar, 255)).Value                = f.ovladaciPanelObjednavkyNEW1.txtRework.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@StavObjednavky", SqlDbType.VarChar, 255)).Value        = comboBoxItem3.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@FBGSSN", SqlDbType.VarChar, 255)).Value                = f.ovladaciPanelObjednavkyNEW1.txtFBGSSN.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@spektrum_label", SqlDbType.NVarChar, 255)).Value       = f.vystupnaKontrolaScr1.txtScrSpektrumVystupStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@vl_label", SqlDbType.NVarChar, 255)).Value             = f.vystupnaKontrolaScr1.txtScrVlVystupStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@snapshot_label", SqlDbType.NVarChar, 255)).Value       = f.vystupnaKontrolaScr1.txtScrSnapshotVystupStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@spektrum_nolabel", SqlDbType.NVarChar, 255)).Value     = f.vystupnaKontrolaScr1.txtScrSpektrumVystupBezStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@vl_nolabel", SqlDbType.NVarChar, 255)).Value           = f.vystupnaKontrolaScr1.txtScrVlVystupBezStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@snapshot_nolabel", SqlDbType.NVarChar, 255)).Value     = f.vystupnaKontrolaScr1.txtScrSnapshotVystupBezStitok.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@vlhkost", SqlDbType.VarChar, 255)).Value               = f.vystupnaKontrolaScr1.txtVlhkostVzduchuVystup.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@teplota", SqlDbType.VarChar, 255)).Value               = f.vystupnaKontrolaScr1.txtTeplotaPracoviskaVystup.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@tlak", SqlDbType.VarChar, 255)).Value                  = f.vystupnaKontrolaScr1.txtTlakVystup.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@product", SqlDbType.VarChar, 255)).Value               = f.ovladaciPanelObjednavkyNEW1.Produkt.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@Zakaznik", SqlDbType.VarChar, 255)).Value              = f.ovladaciPanelObjednavkyNEW1.Zakaznik.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@zakaznicka_objednavka", SqlDbType.VarChar, 255)).Value = f.ovladaciPanelObjednavkyNEW1.ZakObjednavka.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@PopisChyby", SqlDbType.VarChar, 255)).Value            = f.zaznamChyb.txtPopisChyby.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ChybaKto1", SqlDbType.VarChar, 50)).Value              = f.zaznamChyb.comboTree1.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ChybaKto2", SqlDbType.VarChar, 50)).Value              = f.zaznamChyb.comboTree2.Text;
                            string time   = f.zaznamChyb.textBoxX2.Text;
                            var    result = Convert.ToDateTime(time);
                            string test   = result.ToString("hh:mm:ss", CultureInfo.CurrentCulture);
                            sqlComm.Parameters.Add(new SqlParameter("@CasChybySpolu", SqlDbType.Time, 7)).Value    = f.zaznamChyb.textBoxX2.Text;
                            sqlComm.Parameters.Add(new SqlParameter("@ChybuZapisal", SqlDbType.VarChar, 50)).Value = f.zaznamChyb.txtZapisal.Text;

                            if (string.IsNullOrWhiteSpace(f.zaznamChyb.txtZapisalDna.Text))
                            {
                                sqlComm.Parameters.Add(new SqlParameter("@ChybuZapisalKedy", SqlDbType.DateTime, 0)).Value = DBNull.Value;
                            }
                            else
                            {
                                sqlComm.Parameters.Add(new SqlParameter("@ChybuZapisalKedy", SqlDbType.DateTime, 0)).Value = f.zaznamChyb.txtZapisalDna.Text;
                            }

                            sqlConn.Open();
                            sqlComm.ExecuteNonQuery();


                            ComboBoxEx       Zakazka       = Parent.Parent.Controls.Find("comboBoxEx1", true).FirstOrDefault() as ComboBoxEx;
                            TextBoxX         Rework        = Parent.Parent.Controls.Find("txtRework", true).FirstOrDefault() as TextBoxX;
                            TextBoxX         pocet_mriezok = Parent.Parent.Controls.Find("textBoxX1", true).FirstOrDefault() as TextBoxX;
                            ComboBoxEx       chyba_kto1    = Parent.Parent.Controls.Find("comboTree1", true).FirstOrDefault() as ComboBoxEx;
                            ComboBoxEx       chyba_kto2    = Parent.Parent.Controls.Find("comboTree2", true).FirstOrDefault() as ComboBoxEx;
                            TextBoxX         cas           = Parent.Parent.Controls.Find("textBoxX2", true).FirstOrDefault() as TextBoxX;
                            RichTextBoxEx    popis_chyby   = Parent.Parent.Controls.Find("txtPopisChyby", true).FirstOrDefault() as RichTextBoxEx;
                            TextBoxX         zakaznik      = Parent.Parent.Controls.Find("zakaznik", true).FirstOrDefault() as TextBoxX;
                            SuperGridControl grid_kon      = Parent.Parent.Controls.Find("superGridControl1", true).FirstOrDefault() as SuperGridControl;


                            if (string.IsNullOrWhiteSpace(Objednavka.Text))
                            {
                                MessageBox.Show("Najprv zadaj Objednávku");
                                return;
                            }
                            if (string.IsNullOrWhiteSpace(Zakazka.Text))
                            {
                                MessageBox.Show("Najprv zadaj Zákazku");
                                return;
                            }
                            if (string.IsNullOrWhiteSpace(pocet_mriezok.Text))
                            {
                                MessageBox.Show("Nenapísala si počet mriežok, nemôžem vytvoriť tabuľku");
                                return;
                            }



                            if (poradove_cislo_final > 1)
                            {
                                for (int i2 = 1; i2 <= Convert.ToInt32(pocet_mriezok.Text); i2++)
                                {
                                    SqlCommand sqlCommKonektorovanie = new SqlCommand();
                                    sqlCommKonektorovanie             = sqlConn.CreateCommand();
                                    sqlCommKonektorovanie.CommandText = @"INSERT INTO tblKonektorovanie (CisloZakazky,Objednavka,FBGnr,rework) VALUES (@CisloZakazky,@Objednavka,@FBGnr,@rework)";
                                    sqlCommKonektorovanie.Parameters.Add(new SqlParameter("@CisloZakazky", SqlDbType.Int)).Value        = Zakazka.Text;
                                    sqlCommKonektorovanie.Parameters.Add(new SqlParameter("@Objednavka", SqlDbType.NVarChar, 50)).Value = Objednavka.Text + "/" + poradove_cislo_final.ToString("D4");
                                    sqlCommKonektorovanie.Parameters.Add(new SqlParameter("@FBGnr", SqlDbType.NChar, 10)).Value         = i2;
                                    sqlCommKonektorovanie.Parameters.Add(new SqlParameter("@rework", SqlDbType.NChar, 10)).Value        = Rework.Text;
                                    sqlCommKonektorovanie.ExecuteNonQuery();
                                }
                                sqlConn.Close();
                            }
                        }
                        #endregion konektorovanie
                    }
                    Class1.set_sort_main_form(); //nastavi zobrazenie v hlavnom formulari
                    f.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }