コード例 #1
0
        public EditionContrainte(Contrainte c,  Relation relationS,  Relation relationD)
        {
            InitializeComponent();
            contrainte = c;
            relationSource = relationS;
            relationDestination = relationD;
            foreach (Champ ch in relationSource.Champs)
                cléRelation1.Items.Add(ch.ToString());

            foreach (Champ ch in relationDestination.Champs)
                cléRelation2.Items.Add(ch.ToString());

            if (contrainte.Nom != null)
            {
                cléRelation1.Text = contrainte.ChampSource.Nom;
                cléRelation2.Text = contrainte.ChampDestination.Nom;
                NomRelation.Text = contrainte.Nom;
            }
        }
コード例 #2
0
        public EditionContrainte(Contrainte c, Relation relationS, Relation relationD)
        {
            InitializeComponent();
            contrainte          = c;
            relationSource      = relationS;
            relationDestination = relationD;
            foreach (Champ ch in relationSource.Champs)
            {
                cléRelation1.Items.Add(ch.ToString());
            }

            foreach (Champ ch in relationDestination.Champs)
            {
                cléRelation2.Items.Add(ch.ToString());
            }

            if (contrainte.Nom != null)
            {
                cléRelation1.Text = contrainte.ChampSource.Nom;
                cléRelation2.Text = contrainte.ChampDestination.Nom;
                NomRelation.Text  = contrainte.Nom;
            }
        }
コード例 #3
0
ファイル: Graphe.cs プロジェクト: kevmarzin/ProjetBD
        private void ReverseEngineer(string baseSQL)
        {
            base_données = baseSQL;
            this.Text = baseSQL;

            AccèsSQL AccSQL = new AccèsSQL(baseSQL);

            Point point = new Point(10, 23);
            foreach (DataTable d in AccSQL.Tables)
            {
                if (d.TableName != "sysdiagrams")
                {
                    Relation r = new Relation(point, option.Taille_Noeud, option.Couleur_Noeud, option.Épaisseur_Noeud, d);
                    noeuds.Add(r);
                }
            }
            //foreach (DataTable d in AccSQL.ForeignKeys)
            //{
            //    Contrainte c = new
            //}
            Relation r1 = null, r2 = null;
            Champ chSource = null, chDest = null;
            for (int i = 0; i < AccSQL.ForeignKeys.Rows.Count; i++)
            {
               foreach(Relation r in noeuds)
               {
                   if(r.Texte == AccSQL.ForeignKeys.Rows[i].ItemArray[2].ToString())
                       r1 = r;
                   if(r.Texte == AccSQL.ForeignKeys.Rows[i].ItemArray[8].ToString())
                       r2 = r;
               }
                foreach(Champ ch in r1.Champs)
                {
                    if(ch.Nom == AccSQL.ForeignKeys.Rows[i].ItemArray[3].ToString())
                        chSource = ch;
                }
                foreach(Champ ch in r2.Champs)
                {
                    if(ch.Nom == AccSQL.ForeignKeys.Rows[i].ItemArray[9].ToString())
                        chDest = ch;
                }
                Contrainte c = new Contrainte(r1, r2, Color.Black, 2,chSource,chDest);
                traits.Add(c);
            }
        }
コード例 #4
0
ファイル: Graphe.cs プロジェクト: kevmarzin/ProjetBD
        private void DessinObjets_MouseUp(object sender, MouseEventArgs e)
        {
            if (this.Bounds.Contains((e.Location)))
            {
                if (dessinTrait)
                {
                    if (noeudCourant != null)
                    {
                        #region Création d'une arête
                        Point pointInModel = ScreenToModel(e.Location);
                        Noeud fin = TrouveNoeudCourant(pointInModel);
                        Action subAction = null;
                        if (fin == null)
                        {
                            fin = NoeudParDéfaut(pointInModel, Option.Type_schéma);
                            subAction = new Action(Type_Action.Créer, new List<object>() { fin });
                        }
                        Trait trait = null;
                        Trait trait_1 = null;
                        if (fin != null)
                        {
                            switch (Option.Type_schéma)
                            {
                                case TypeSchéma.Graphe:
                                    trait = new Trait(noeudCourant, fin, option.Couleur_Lien, option.Épaisseur_Lien);
                                    break;
                                case TypeSchéma.Relationnel:
                                    trait = new Contrainte(noeudCourant, fin, option.Couleur_Lien, option.Épaisseur_Lien);                  
                                    EditionContrainte pa = new EditionContrainte((Contrainte)trait, (Relation)noeudCourant, (Relation)fin);
                                    pa.ShowDialog();
                                    break;
                                case TypeSchéma.EntitéAssociation:
                                    
                                    if (noeudCourant.GetType() != typeof(Association) && fin.GetType() != typeof(Association))
                                    {
                                        Point pos = new Point(Math.Abs(noeudCourant.Position.X + fin.Position.X)/2, Math.Abs(noeudCourant.Position.Y + fin.Position.Y)/2);
                                        Association asso = new Association(pos, new Size(8, 8), option.Couleur_Lien, option.Épaisseur_Lien, (Entité)noeudCourant, (Entité)fin);

                                        trait = new Lien(noeudCourant, asso, option.Couleur_Lien, option.Épaisseur_Lien);
                                        trait_1 = new Lien(asso, fin, option.Couleur_Lien, option.Épaisseur_Lien);

                                        asso.LienSource = (Lien)trait;
                                        asso.LienDestination = (Lien)trait_1;

                                        EditionAssociation eA = new EditionAssociation(asso);

                                        if (eA.ShowDialog() == DialogResult.OK)
                                        {
                                            noeuds.Add(asso);
                                        }
                                        else
                                        {
                                            trait = null; //si on clique sur annuler, on ne veut plus ajouter le lien
                                            trait_1 = null;
                                        }
                                    }
                                    break;
                            }
                        }
                        if (trait_1 != null)
                        {
                            traits.Add(trait_1);
                            Action action = new Action(Type_Action.Créer, new List<object>() { trait_1 });
                            PushUndo(action);
                            if (subAction != null)
                                action.AddSubAction(subAction);
                        }
                        if (trait != null)
                        {
                            traits.Add(trait);
                            Action action = new Action(Type_Action.Créer, new List<object>() { trait });
                            PushUndo(action);
                            if (subAction != null)
                                action.AddSubAction(subAction);
                        }
                        pointCourant = Point.Empty;
                        Refresh();
                        dessinTrait = false;
                        #endregion
                    }
                }
                else
                {
                    #region Déplacement
                    Point pointInModel = ScreenToModel(e.Location);
                    if (Déplacement_Simple)
                    {
                        #region Mode modification
                        if (noeudCourant != null)
                        {
                            noeudCourant.Déplace(pointInModel);
                            PushUndo(new Action(Type_Action.Déplacer, new List<object>() { noeudCourant, origineDéplacement, pointInModel }));
                        }
                        #endregion
                    }
                    else
                    {
                        if (sélection != Rectangle.Empty)
                        {
                            if (DéplacementMultipleEncours)
                            {
                                #region Déplacement_Bloc
                                Action act = new Action(Type_Action.EnBloc, new List<object>());
                                foreach (Noeud n in noeuds)
                                {
                                    if (n.IsSelected)
                                    {
                                        Point offset = new Point(e.Location.X - StartBlockMovement.X, e.Location.Y - StartBlockMovement.Y);
                                        n.DéplaceVers(offset);
                                        Point offsetGlobal = new Point(e.Location.X - origineDéplacement.X, e.Location.Y - origineDéplacement.Y);
                                        Action ac = new Action(Type_Action.EnBloc, new List<object>() { n, offsetGlobal });
                                        act.AddSubAction(ac);
                                    }
                                }
                                PushUndo(act);
                                annulerToolStripMenuItem.Enabled = true;
                                sélection = new Rectangle(sélection.X + e.Location.X - StartBlockMovement.X, sélection.Y + e.Location.Y - StartBlockMovement.Y, sélection.Width, sélection.Height);
                                StartBlockMovement = e.Location;
                                #endregion
                            }
                            else
                            {
                            }
                        }
                    }
                    #endregion
                }
                Déplacement_Simple = false;
            }
            else
            {
                pointCourant = Point.Empty;
                Refresh();
            }
        }