private void button10_Click(object sender, EventArgs e) {///creation devis //Clipper_Dll.Test_quote testquote = new Clipper_Dll.Test_quote(); //testquote.createnewquote(_Context); IEntity mpart = null; IEntityList mparts = _Context.EntityManager.GetEntityList("_MACHINABLE_PART"); mparts.Fill(false); mpart = mparts.FirstOrDefault(); Topologie topo = new Topologie(); topo.GetTopologie(ref mpart, ref _Context); }
//méthodes sut la table Topologie /// <summary> /// Créé une topologie /// </summary> /// <param name="topo">Topologie</param> public void SetTopologie(Topologie topo) { using (IDbConnection connexion = new SQLiteConnection(sqliteInfo)) { if (connexion.State == ConnectionState.Closed) { connexion.Open(); } try { string msg = "INSERT INTO Topologie (idMachine,fk_Date) VALUES ('" + topo.idMachine + "','" + topo.fk_Date.ToString("yyyy-MM-dd HH:mm:ss.fff") + "')"; connexion.Execute(msg); } catch (Exception e) { Console.WriteLine(e.Message); } } }
/// <summary> /// Fonction qui va initialiser une machine dans <c>BDDInterface</c> /// </summary> /// <param name="idMachine">Numéro d'ID de la machine</param> /// <param name="fk_Date">date de création/modifiction</param> public void SetTopologie(string idMachine, DateTime fk_Date) { Topologie topo = new Topologie(idMachine, fk_Date); bd.SetTopologie(topo); }
/// <summary> /// Fonction privée qui seed une topologie /// </summary> /// <param name="numSerie">ID de machine</param> /// <param name="dateSynchro">La date de la synchronisation</param> private void setTopo(string numSerie, DateTime dateSynchro) { Topologie topo = new Topologie(numSerie, dateSynchro); bd.SetTopologie(topo); }