private void button3_Click(object sender, EventArgs e) { IGestionConfigurationDAO IGCDAO = new GestionConfigurationDAO(); ICollection <Buse> P = IGCDAO.ConfigBuse(comboBox1.Text); textBox1.Text = P.ElementAt(0).Quantite.ToString(); textBox2.Text = P.ElementAt(1).Quantite.ToString(); textBox3.Text = P.ElementAt(2).Quantite.ToString(); textBox4.Text = P.ElementAt(3).Quantite.ToString(); textBox5.Text = P.ElementAt(4).Quantite.ToString(); textBox6.Text = P.ElementAt(5).Quantite.ToString(); textBox7.Text = P.ElementAt(6).Quantite.ToString(); textBox8.Text = P.ElementAt(7).Quantite.ToString(); textBox9.Text = P.ElementAt(8).Quantite.ToString(); textBox10.Text = P.ElementAt(9).Quantite.ToString(); textBox11.Text = P.ElementAt(10).Quantite.ToString(); textBox12.Text = P.ElementAt(11).Quantite.ToString(); textBox13.Text = P.ElementAt(12).Quantite.ToString(); textBox14.Text = P.ElementAt(13).Quantite.ToString(); textBox15.Text = P.ElementAt(14).Quantite.ToString(); textBox16.Text = P.ElementAt(15).Quantite.ToString(); textBox17.Text = P.ElementAt(16).Quantite.ToString(); textBox18.Text = P.ElementAt(17).Quantite.ToString(); textBox19.Text = P.ElementAt(18).Quantite.ToString(); textBox20.Text = P.ElementAt(19).Quantite.ToString(); textBox21.Text = P.ElementAt(20).Quantite.ToString(); textBox22.Text = P.ElementAt(21).Quantite.ToString(); textBox23.Text = P.ElementAt(22).Quantite.ToString(); textBox24.Text = P.ElementAt(23).Quantite.ToString(); textBox25.Text = P.ElementAt(24).Quantite.ToString(); textBox26.Text = P.ElementAt(25).Quantite.ToString(); textBox27.Text = P.ElementAt(26).Quantite.ToString(); textBox28.Text = P.ElementAt(27).Quantite.ToString(); textBox29.Text = P.ElementAt(28).Quantite.ToString(); textBox30.Text = P.ElementAt(29).Quantite.ToString(); textBox31.Text = P.ElementAt(30).Quantite.ToString(); textBox32.Text = P.ElementAt(31).Quantite.ToString(); textBox33.Text = P.ElementAt(32).Quantite.ToString(); }
private void button2_Click_1(object sender, EventArgs e) { IGestionProduitDAO IGPDAO = new GestionProduitDAO(); IGestionEtatDAO IGEDAO = new GestionEtatDAO(); // Etat a = new Etat(); // a = IGEDAO.RechercherDernierEtat("STB2"); // Buses=IGPDAO.ListerTotaleBuseAccueil(); ICollection <Buse> Buses = new List <Buse>(); ICollection <Feeder> Feeders = new List <Feeder>(); /* for (int i = 0; i < 33; i++) * { * Buses.Add(new Buse { Quantite = i+10 }); * } * for (int i = 0; i < 6; i++) * { * Feeders.Add(new Feeder { Quantite = i }); * } * Etat b = new Etat { Buses=Buses,Feeders=Feeders,UF="aa",NumEquipe=1}; * b.DateCS=@"10/06/2012"; * Technicien T = new Technicien { Nom = "ali" }; * b.Technicien = T; * IGEDAO.AjouterPrevision(b); * * * Produit P = new Produit(); * P = IGPDAO.GetProduitByNom("E1 X29 MCU 252"); */ IGestionConfigurationDAO IGCDAO = new GestionConfigurationDAO(); Buses = IGCDAO.ConfigBuse("ATR"); MessageBox.Show(""); }
private void verif_Click(object sender, EventArgs e) { if (this.verou2) { MessageBox.Show("vous devez appuiyer sur le boutton calcul"); } else { IGestionEtatDAO IGEDAO = new GestionEtatDAO(); IGestionConfigurationDAO IGCDAO = new GestionConfigurationDAO(); IGestionProduitDAO IGPDAO = new GestionProduitDAO(); ICollection <Buse> TotaleBuseDansUF = new List <Buse>(); ICollection <Buse> TotaleBuseInLocale = new List <Buse>(); ICollection <Buse> BusesConfig = new List <Buse>(); string UF = Etat.UF; Etat etat = null; if (variable == 0) { etat = IGEDAO.RechercherDernierEtat(UF, "b"); variable++; } else { etat = IGEDAO.EtatPrevision(); } etat.DateCS = this.Etat.DateCS; etat.NumEquipe = this.Etat.NumEquipe; etat.UF = Etat.UF; BusesConfig = IGCDAO.ConfigBuse(Etat.UF); int[] ConfigB = new int[33]; string[] ConfigBuseID = new string[33]; int[] DernierEtatB = new int[33]; int i = 0; foreach (var item in BusesConfig) { ConfigB[i] = item.Quantite; ConfigBuseID[i] = item.coordonnee; i++; } i = 0; foreach (var item in etat.Buses) { DernierEtatB[i] = item.Quantite; i++; } ICollection <TextBox> TextBoxes = this.AddTextBoxes(this); int[] T = new int[33]; int k = 0; for (int a = 32; a >= 0; a--) { T[k] = DernierEtatB[k] + Convert.ToInt32(TextBoxes.ElementAt(a).Text); k++; } TotaleBuseDansUF = IGPDAO.ListerTotaleBuseAccueil(); TotaleBuseInLocale = IGPDAO.ListerTotaleBusesUsine(); int[] TotaleBuseDansUF1 = new int[33]; int[] TotaleBuseInLocale1 = new int[33]; int[] BuseDisponible = new int[33]; string [] CoordonneBuses = new string[33]; CoordonneBuses[0] = "110S"; CoordonneBuses[1] = "115S"; CoordonneBuses[2] = "120S"; CoordonneBuses[3] = "130S"; CoordonneBuses[4] = "235S"; CoordonneBuses[5] = "110"; CoordonneBuses[6] = "115"; CoordonneBuses[7] = "120"; CoordonneBuses[8] = "130"; CoordonneBuses[9] = "140"; CoordonneBuses[10] = "185"; CoordonneBuses[11] = "235"; CoordonneBuses[12] = "1002"; CoordonneBuses[13] = "1003"; CoordonneBuses[14] = "1004"; CoordonneBuses[15] = "1005"; CoordonneBuses[16] = "1006"; CoordonneBuses[17] = "1159"; CoordonneBuses[18] = "1647"; CoordonneBuses[19] = "5700"; CoordonneBuses[20] = "1403"; CoordonneBuses[21] = "5490"; CoordonneBuses[22] = "1001"; CoordonneBuses[23] = "4498"; CoordonneBuses[24] = "5150"; CoordonneBuses[25] = "240S"; CoordonneBuses[26] = "5739"; CoordonneBuses[27] = "1497"; CoordonneBuses[28] = "2013"; CoordonneBuses[29] = "111"; CoordonneBuses[30] = "112"; CoordonneBuses[31] = "113"; CoordonneBuses[32] = "161"; // var test1 = true; for (int j = 0; j < 33; j++) { if (T[j] > ConfigB[j]) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\Users\Meher_\Documents\Visual Studio 2013\Projects\feeder_meher\feeder\bin\Debug\Rapport_Prevision_Buse.txt", true)) { file.WriteLine("Vous avez depassé la configuration maximale" + CoordonneBuses[j] + " de " + (T[j] - ConfigB[j]) + " Buses pour le " + this.Etat.DateCS + " poste N°" + this.Etat.NumEquipe); } MessageBox.Show("Vous avez depassé la configuration maximale" + CoordonneBuses[j] + " de " + (T[j] - ConfigB[j]) + " Buses pour le " + this.Etat.DateCS + " poste N°" + this.Etat.NumEquipe); } } ICollection <Buse> Buses1 = new List <Buse>(); for (int w = 0; w < 33; w++) { Buses1.Add(new Buse { Quantite = T[w] }); } etat.Buses = Buses1; IGEDAO.AjouterPrevision(etat); if (Etats.Count - 1 > 0) { Etats.Remove(this.Etat); Close(); Buse_Prevision_ suivant = new Buse_Prevision_(Etats.ElementAt(0), Etats, this.cmp); suivant.Show(); } } }
private void button3_Click(object sender, EventArgs e) { if (this.verou1) { MessageBox.Show("Vous devez appuiyer sur le boutton calcul d'abord"); } else { IGestionEtatDAO IGEDAO = new GestionEtatDAO(); IGestionConfigurationDAO IGCDAO = new GestionConfigurationDAO(); IGestionProduitDAO IGPDAO = new GestionProduitDAO(); ICollection <Buse> TotaleBusesDansUF = new List <Buse>(); ICollection <Buse> TotaleBusesInLocale = new List <Buse>(); ICollection <Buse> BusesConfig = new List <Buse>(); Etat etat = IGEDAO.RechercherDernierEtat(UF_Combo_Box.Text, "b"); BusesConfig = IGCDAO.ConfigBuse(UF_Combo_Box.Text); int[] ConfigB = new int[33]; string[] ConfigBusesID = new string[33]; int[] DernierEtatB = new int[33]; int i = 0; foreach (var item in BusesConfig) { ConfigB[i] = item.Quantite; ConfigBusesID[i] = item.coordonnee; i++; } i = 0; foreach (var item in etat.Buses) { DernierEtatB[i] = item.Quantite; i++; } string[] CoordonneBuses = new string[33]; CoordonneBuses[0] = "110S"; CoordonneBuses[1] = "115S"; CoordonneBuses[2] = "120S"; CoordonneBuses[3] = "130S"; CoordonneBuses[4] = "235S"; CoordonneBuses[5] = "110"; CoordonneBuses[6] = "115"; CoordonneBuses[7] = "120"; CoordonneBuses[8] = "130"; CoordonneBuses[9] = "140"; CoordonneBuses[10] = "185"; CoordonneBuses[11] = "235"; CoordonneBuses[12] = "1002"; CoordonneBuses[13] = "1003"; CoordonneBuses[14] = "1004"; CoordonneBuses[15] = "1005"; CoordonneBuses[16] = "1006"; CoordonneBuses[17] = "1159"; CoordonneBuses[18] = "1647"; CoordonneBuses[19] = "5700"; CoordonneBuses[20] = "1403"; CoordonneBuses[21] = "5490"; CoordonneBuses[22] = "1001"; CoordonneBuses[23] = "4498"; CoordonneBuses[24] = "5150"; CoordonneBuses[25] = "240S"; CoordonneBuses[26] = "5739"; CoordonneBuses[27] = "1497"; CoordonneBuses[28] = "2013"; CoordonneBuses[29] = "111"; CoordonneBuses[30] = "112"; CoordonneBuses[31] = "113"; CoordonneBuses[32] = "161"; int[] T = new int[33]; ICollection <TextBox> TextBoxs = new List <TextBox>(); TextBoxs = AddLAbel(this); int w = 0; for (int j = 33; j > 0; j--) { T[w] = DernierEtatB[w] + Convert.ToInt32(TextBoxs.ElementAt(j - 1).Text); w++; } TotaleBusesDansUF = IGPDAO.ListerTotaleBuseAccueil(); TotaleBusesInLocale = IGPDAO.ListerTotaleBusesUsine(); int[] TotaleBusesDansUF1 = new int[33]; int[] TotaleBusesInLocale1 = new int[33]; int[] BusesDisponible = new int[33]; var k = 0; foreach (var item in TotaleBusesDansUF) { TotaleBusesDansUF1[k] = item.Quantite; k++; } k = 0; foreach (var item in TotaleBusesInLocale) { TotaleBusesInLocale1[k] = item.Quantite; k++; } for (int u = 0; u < 33; u++) { BusesDisponible[u] = TotaleBusesInLocale1[u] - TotaleBusesDansUF1[u]; } int tmp = 0; for (int m = 32; m >= 0; m--) { if (Convert.ToInt32(TextBoxs.ElementAt(m).Text) > BusesDisponible[tmp]) { MessageBox.Show(" stock insuffisant du Buses " + CoordonneBuses[tmp] + " vous avez besoin de " + (Convert.ToInt32(TextBoxs.ElementAt(m).Text) - BusesDisponible[tmp])); } tmp++; } ////////////////2eme test //////////// for (int j = 0; j < 6; j++) { if (T[j] > ConfigB[j]) { MessageBox.Show("Vous avez depassé la configuration maximale " + CoordonneBuses[j] + " de " + (T[j] - ConfigB[j])); } } Etat e1 = new Etat(); e1.UF = UF_Combo_Box.Text.ToString(); e1.Technicien = (Technicien)Personne; e1.NumEquipe = Convert.ToInt32(equipe); ICollection <Buse> Buses = new List <Buse>(); for (int j = 0; j < 33; j++) { Buses.Add(new Buse { Quantite = T[j] }); } ////////////////////Date////////////////////////// IGestionEtat IGE = new GestionEtat(); string D = DateTime.Text; int i1 = D.IndexOf(" "); var jour = D.Substring(0, i1); var mot1 = D.Substring(i1 + 1); int i2 = mot1.IndexOf(" "); var jour_nbr = mot1.Substring(0, i2); var mot2 = mot1.Substring(i2 + 1); int i3 = mot2.IndexOf(" "); var mois = mot2.Substring(0, i3); var mois_nbr = IGE.GetDate(mois); var anne = mot2.Substring(i3 + 1); var date = jour_nbr + "-" + mois_nbr + "-" + anne; e1.DateCS = date; ///////////////////////////////////// e1.Buses = Buses; this.etat = e1; this.verou = false; //;/////////////////////// Foued : est se que je fais une separation entre l'ajout d'etat d'un changement de serie de feeeder et de buses wala lé ? //// } }