예제 #1
0
        private static void Zapytania(WYNIK_DIODA myNewForm, int pion, int ilosc_powercon, double pc, int rj45, double etercon)
        {
            string zapytanie4 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('3','Pion','" + pion + "');";

            NowyElement(myNewForm, zapytanie4);

            string zapytanie5 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('4','powercon 230V','" + ilosc_powercon + "');";

            NowyElement(myNewForm, zapytanie5);

            string zapytanie6 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('5','powercon','" + pc + "');";

            NowyElement(myNewForm, zapytanie6);

            string zapytanie7 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('6','etercon','" + etercon + "');";

            NowyElement(myNewForm, zapytanie7);

            string zapytanie8 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('7','rozdzielnia','" + pion + "');";

            NowyElement(myNewForm, zapytanie8);

            string zapytanie9 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('8','rj45','" + rj45 + "');";

            NowyElement(myNewForm, zapytanie9);
        }
예제 #2
0
        private static void NowyElement(WYNIK_DIODA myNewForm, string zapytanie)
        {
            string myConnectionString = "server=localhost;user=root;database=sport_media";


            var polocznie = new MySqlConnection(myConnectionString);


            polocznie.Open();


            MySqlCommand komenda = new MySqlCommand(zapytanie, polocznie);

            komenda.Prepare();
            komenda.ExecuteNonQuery();

            polocznie.Close();
        }
예제 #3
0
        private static double Pobor(WYNIK_DIODA myNewForm, double pole, double pobor, double maxpobor)
        {
            pobor = pole * pobor;


            maxpobor = pole * maxpobor;



            myNewForm.pobor.Text += Environment.NewLine;

            myNewForm.pobor.Text += "SREDNI POBOR TO: " + pobor.ToString() + "V";

            myNewForm.pobor.Text += Environment.NewLine;

            myNewForm.pobor.Text += "MAX POBOR TO: " + maxpobor.ToString() + "V";

            myNewForm.pobor.Text += Environment.NewLine;

            myNewForm.pobor.Text += Environment.NewLine;

            return(maxpobor);
        }
예제 #4
0
//<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  PANEL NOWY EVENT Z WYNIK.DIODA >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
        public void button6_Click(object sender, EventArgs e)
        {
            WYNIK_DIODA myNewForm = new WYNIK_DIODA();

            myNewForm.Visible = true;

            NOWY_EVENT.Visible = false;


            dioda_led.dioda = NazwaEvent.Text;



            myNewForm.nazwaevent.Text = dioda_led.dioda;



            Diody.dioda[] smd = DaneDiody();

            dioda_led.szerokosc = double.Parse(szerokosc.Text.ToString());


            dioda_led.wysokosc = double.Parse(wysokosc.Text.ToString());

            string rodzaj_diody = "1";

            int potrzeba = 0;

            double pole = 0;

            double maxpobor = 0;

            double smallpole = 0;

            string myConnectionString = "server=localhost;user=root;database=sport_media";


            var pol = new MySqlConnection(myConnectionString);


            pol.Open();


            string       zapytanieSQL1 = "CREATE TABLE " + dioda_led.dioda + "(id int(100) NOT NULL,nazwa varchar(100),ilosc int(100),PRIMARY KEY(id))";
            MySqlCommand komenda       = new MySqlCommand(zapytanieSQL1, pol);

            komenda.Prepare();
            komenda.ExecuteNonQuery();

            pol.Close();

            double kabinet = 0;


            myNewForm.SMDilosc.Text = "";
            myNewForm.pobor.Text    = "";
            myNewForm.pobor.Text   += Environment.NewLine;

            if (SMD1.Checked)
            {
                pole = dioda_led.szerokosc * dioda_led.wysokosc;



                rodzaj_diody = SMD1.Text;



                dioda_led.szerokosc = dioda_led.szerokosc / smd[1].szerokosc;
                dioda_led.wysokosc  = dioda_led.wysokosc / smd[1].wysokosc;


                dioda_led.ilosckabinetow = dioda_led.szerokosc * dioda_led.wysokosc;


                kabinet = dioda_led.ilosckabinetow;


                myNewForm.SMDilosc.Text += "KABINET SMD 1" + Environment.NewLine + "ILOSC: " + dioda_led.ilosckabinetow.ToString();

                //POBÓR DIODY SMD 1

                myNewForm.pobor.Text += "POBOR DIODY SMD 1";

                maxpobor = Pobor(myNewForm, pole, smd[1].pobor, smd[1].maxpobor);
            }
            else if (SMD2.Checked)
            {
                pole = dioda_led.szerokosc * dioda_led.wysokosc;

                //POBÓR DIODY SMD 2
                myNewForm.pobor.Text += "POBOR DIODY SMD 2";

                maxpobor = Pobor(myNewForm, pole, smd[2].pobor, smd[2].maxpobor);

                rodzaj_diody = SMD2.Text;

                dioda_led.szerokosc = dioda_led.szerokosc / smd[2].szerokosc;
                dioda_led.wysokosc  = dioda_led.wysokosc / smd[2].wysokosc;


                dioda_led.ilosckabinetow = dioda_led.szerokosc * dioda_led.wysokosc;

                kabinet = dioda_led.ilosckabinetow;

                myNewForm.SMDilosc.Text += "KABINET SMD 2" + Environment.NewLine + "ILOSC: " + dioda_led.ilosckabinetow.ToString();
            }
            else if (SMD3.Checked)
            {
                potrzeba = WymiarDiody(dioda_led.wysokosc, smd[4].wysokosc);

                dioda_led.szerokosc = dioda_led.szerokosc / smd[3].szerokosc;

                pole = dioda_led.szerokosc * dioda_led.wysokosc;



                if (potrzeba == 1)
                {
                    kabinet += dioda_led.szerokosc;


                    //POBÓR DIODY SMD 3

                    smallpole = dioda_led.szerokosc * 0.5;

                    //POBÓR DIODY SMD 3

                    myNewForm.pobor.Text += "POBOR DIODY SMD 3";

                    maxpobor = Pobor(myNewForm, smallpole, smd[3].pobor, smd[3].maxpobor);



                    dioda_led.wysokosc = dioda_led.wysokosc - smd[3].wysokosc;

                    dioda_led.wysokosc = dioda_led.wysokosc / smd[4].wysokosc;

                    myNewForm.SMDilosc.Text += "KABINET SMD 3" + Environment.NewLine + "ILOSC: " + dioda_led.szerokosc.ToString() + Environment.NewLine;



                    string zapytanie3 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('2','SMD 3','" + dioda_led.szerokosc.ToString() + "');";

                    NowyElement(myNewForm, zapytanie3);
                }

                rodzaj_diody = "SMD 4";



                pole = pole - smallpole;

                myNewForm.pobor.Text += "POBOR DIODY SMD 4";

                maxpobor = Pobor(myNewForm, smallpole, smd[4].pobor, smd[4].maxpobor);



                dioda_led.ilosckabinetow = dioda_led.szerokosc * dioda_led.wysokosc;


                kabinet += dioda_led.ilosckabinetow;

                myNewForm.SMDilosc.Text += "KABINET SMD 4" + Environment.NewLine + "ILOSC: " + dioda_led.ilosckabinetow.ToString();
            }


            string zapytanie2 = "INSERT INTO " + dioda_led.dioda + " (id,nazwa,ilosc) VALUES ('1','" + rodzaj_diody + "','" + dioda_led.ilosckabinetow.ToString() + "');";

            NowyElement(myNewForm, zapytanie2);

            pol.Close();



            int    pion    = 0;
            double kwpobor = maxpobor / 1000;

            do
            {
                pion++;
                kwpobor = kwpobor - 21;
            } while (kwpobor > 21);


            myNewForm.pobor.Text += Environment.NewLine;


            myNewForm.pobor.Text += Environment.NewLine;



            int    ilosc_powercon = 0;
            double powercon       = maxpobor / 3680;

            do
            {
                ilosc_powercon++;
                powercon--;
            } while (powercon > 1);



            double pc = ((kabinet * 2) - ilosc_powercon) - 1;

            int rj45 = 0;



            //jedna rj45 moze byc na 15 kabinetow

            for (int t = 0; t < kabinet; t = t + 15)
            {
                rj45++;
            }

            double etercon;

            etercon = ((kabinet * 2) - rj45) - 1;

            Zapytania(myNewForm, pion, ilosc_powercon, pc, rj45, etercon);


            int kabinet_rys = 0;



            if (SMD1.Checked || SMD2.Checked)
            {
                int columnCount = Convert.ToInt32(dioda_led.szerokosc);
                int rowCount    = Convert.ToInt32(dioda_led.wysokosc);

                //Clear out the existing controls, we are generating a new table layout
                myNewForm.tableLayoutPanel1.Controls.Clear();

                //Clear out the existing row and column styles
                myNewForm.tableLayoutPanel1.ColumnStyles.Clear();
                myNewForm.tableLayoutPanel1.RowStyles.Clear();

                //Now we will generate the table, setting up the row and column counts first
                myNewForm.tableLayoutPanel1.ColumnCount = columnCount;
                myNewForm.tableLayoutPanel1.RowCount    = rowCount;

                myNewForm.tableLayoutPanel1.AutoScroll = true;

                for (int x = 0; x < columnCount; x++)
                {
                    //First add a column
                    myNewForm.tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));

                    for (int y = 0; y < rowCount; y++)
                    {
                        kabinet_rys++;
                        //Next, add a row.  Only do this when once, when creating the first column


                        myNewForm.tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.AutoSize));



                        //Create the control, in this case we will add a button
                        Label cmd = new Label();
                        cmd.Size      = new System.Drawing.Size(100, 100);
                        cmd.Font      = new Font("Arial", 20, FontStyle.Bold);
                        cmd.Margin    = new Padding(10, 10, 10, 10);
                        cmd.BackColor = Color.Blue;
                        cmd.Text      = kabinet_rys.ToString();    //Finally, add the control to the correct location in the table
                        myNewForm.tableLayoutPanel1.Controls.Add(cmd);
                    }
                }
            }
            else
            {
                kabinet_rys = 0;

                int rowCount1 = Convert.ToInt32(dioda_led.wysokosc);



                int columnCount1 = Convert.ToInt32(dioda_led.szerokosc);
                //Clear out the existing controls, we are generating a new table layout
                myNewForm.tableLayoutPanel1.Controls.Clear();

                //Clear out the existing row and column styles
                myNewForm.tableLayoutPanel1.ColumnStyles.Clear();
                myNewForm.tableLayoutPanel1.RowStyles.Clear();

                //Now we will generate the table, setting up the row and column counts first
                myNewForm.tableLayoutPanel1.ColumnCount = columnCount1;
                myNewForm.tableLayoutPanel1.RowCount    = rowCount1;
                myNewForm.tableLayoutPanel1.AutoScroll  = true;

                if (potrzeba == 1)
                {
                    //First add a column
                    myNewForm.tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));

                    for (int y = 0; y < columnCount1; y++)
                    {
                        kabinet_rys++;
                        //Next, add a row.  Only do this when once, when creating the first column


                        myNewForm.tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.AutoSize));



                        //Create the control, in this case we will add a button
                        Label small = new Label();
                        small.Size      = new System.Drawing.Size(100, 100);
                        small.Font      = new Font("Arial", 20, FontStyle.Bold);
                        small.Margin    = new Padding(10, 10, 10, 10);
                        small.BackColor = Color.Red;
                        small.Text      = kabinet_rys.ToString();        //Finally, add the control to the correct location in the table
                        myNewForm.tableLayoutPanel1.Controls.Add(small);
                    }
                }



                for (int x = 0; x < columnCount1; x++)
                {
                    //First add a column
                    myNewForm.tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));

                    for (int y = 0; y < rowCount1; y++)
                    {
                        kabinet_rys++;
                        //Next, add a row.  Only do this when once, when creating the first column


                        myNewForm.tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.AutoSize));



                        //Create the control, in this case we will add a button
                        Label cmd = new Label();
                        cmd.Size      = new System.Drawing.Size(100, 200);
                        cmd.Font      = new Font("Arial", 20, FontStyle.Bold);
                        cmd.Margin    = new Padding(10, 10, 10, 10);
                        cmd.BackColor = Color.Blue;
                        cmd.Text      = kabinet_rys.ToString();    //Finally, add the control to the correct location in the table
                        myNewForm.tableLayoutPanel1.Controls.Add(cmd);
                    }
                }



                NazwaEvent.Text = "";
                szerokosc.Text  = "";
                wysokosc.Text   = "";

                SMD1.Checked = false;
                SMD2.Checked = false;
                SMD3.Checked = false;
            }
        }