internal int AddProduit(NonAddresseS2 nonAddresseS) { List <NonAddresseS2> roles = conn.Table <NonAddresseS2>().Where(x => x.Ean == nonAddresseS.Ean).ToList(); if (roles.Count == 0) { conn.Insert(nonAddresseS); Console.WriteLine("ajouter" + nonAddresseS.Lib); return(1); } else if (!roles[0].Equals(nonAddresseS)) { if (!p.TGs.Appartient(nonAddresseS)) { Console.WriteLine("Modifié" + nonAddresseS.Lib); conn.Update(nonAddresseS); return(2); } else { Console.WriteLine("TG" + nonAddresseS.Lib); return(3); } } else { Console.WriteLine("ignoré" + nonAddresseS.Lib); return(0); } }
public bool Appartient(NonAddresseS2 na) { foreach (Doubleint doubleint in emplacement) { if (doubleint.Equal(new Doubleint(na.Alle, na.Trave))) { return(true); } } return(false); }
//undone ? /// <summary> /// /// </summary> /// <param name="fileName"></param> public void GetExcelFile(string fileName) { var bdd = Bdd.Instance(); // _list = new List<NonAddresseS2>(); Excel.Application xlApp = new Excel.Application(); Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@fileName); Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1]; Excel.Range xlRange = xlWorksheet.UsedRange; xlApp.Visible = true; xlApp.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityByUI; int rowCount = xlRange.Rows.Count; int colCount = xlRange.Columns.Count; for (int i = 2; i <= rowCount; i++) { NonAddresseS2 art = new NonAddresseS2(); for (int j = 1; j <= colCount; j++) { switch (j) { case 3: art.Ean = xlRange.Cells[i, j].Value2.ToString(); break; case 4: art.Lib = xlRange.Cells[i, j].Value2.ToString(); break; case 9: art.Alle = xlRange.Cells[i, j].Value2.ToString(); break; case 10: art.Trave = xlRange.Cells[i, j].Value2.ToString(); break; } } bdd.AddProduit(art); } GC.Collect(); GC.WaitForPendingFinalizers(); Marshal.ReleaseComObject(xlRange); Marshal.ReleaseComObject(xlWorksheet); xlWorkbook.Close(); Marshal.ReleaseComObject(xlWorkbook); Marshal.ReleaseComObject(xlApp); /* foreach (NonAddresseS2 nonAddresseS in _list) * { * bdd.AddProduit(nonAddresseS); * } */ }
//undone that /* * /// <summary> * /// * /// </summary> * private List<NonAddresseS2> _list; */ //TODO TEST /// <summary> /// /!\ Sur les produits /!\ /// Permet de lire une string pour la decouper et demande de rajouter le produit addressé dans la base /// (voir la classe bdd) /// </summary> /// <param name="text"></param> public void ReadCp(string text) { var bdd = Bdd.Instance(); // _list = new List<NonAddresseS2>(); string str = text; str = str.Replace('\r', ' '); string[] vs = str.Split('\n'); Parameters p = Parameters.Instance(); for (int i = 1; i < vs.Length; i++) { try { string line = vs[i]; string[] item = line.Split('\t'); NonAddresseS2 art = new NonAddresseS2 { Lib = item[p.prod.LIB - 1], //3]; Ean = long.Parse(item[p.prod.EAN - 1]), //4]); Alle = int.Parse(item[p.prod.Alle - 1]), //9]); Trave = int.Parse(item[p.prod.Trave - 1]) //10]); }; // _list.Add(art); bdd.AddProduit(art); } catch (Exception e) { Console.WriteLine(e.Message); } } /* * foreach (NonAddresseS2 nonAddresseS in _list) * { * bdd.AddProduit(nonAddresseS); * * Console.WriteLine("ok"); * }*/ }
public void blal(string text) { //var tlna = new ToutLesNonA(); //tlna.ReadCp(""); var bdd = Bdd.Instance(); // _list = new List<NonAddresseS2>(); string str = text; str = str.Replace('\r', ' '); string[] vs = str.Split('\n'); this._nbaTraiter = vs.Length; this.progressb.Maximum = vs.Length; Parameters p = Parameters.Instance(); for (int i = 1; i < vs.Length; i++) { try { string line = vs[i]; string[] item = line.Split('\t'); NonAddresseS2 art = new NonAddresseS2 { Lib = item[p.prod.LIB - 1], //3]; Ean = long.Parse(item[p.prod.EAN - 1]), //4]); Alle = int.Parse(item[p.prod.Alle - 1]), //9]); Trave = int.Parse(item[p.prod.Trave - 1]) //10]); }; // _list.Add(art); Maj(bdd.AddProduit(art)); } catch (Exception e) { Console.WriteLine(e.Message); } } }