public Essenishial(ErDiagram diagram, ErEssence essence, string Name) { InitializeComponent(); dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].HeaderText = "Key Value"; dataGridView1.Columns[1].HeaderText = "Field Name"; dataGridView1.Columns[2].HeaderText = "Field Type"; targetEssence = essence; targetDiagram = diagram; EssenishialName = Name; targetEssence.Name = Name; }
public static void Export(ErDiagram diagram, string server, string user, string port, string pass) { string connStr = "server="+server+";user="******";port="+port+";password="******";"; MySqlConnection conn = new MySqlConnection(connStr); conn.Open(); string s0 = "CREATE DATABASE IF NOT EXISTS `" + diagram.Name + "`;"; MySqlCommand cmd = new MySqlCommand(s0, conn); cmd.ExecuteNonQuery(); conn.Close(); string connStrDat = connStr + "database=" + diagram.Name + ";"; conn = new MySqlConnection(connStrDat); conn.Open(); MessageBox.Show(conn.Database); for (int i = 0; i < diagram.Essences.Count; i++) { ErEssence essence = diagram.Essences[i]; string createTableString = "CREATE TABLE "+essence.Name.Replace(" ","")+" ("; for (int j = 0; j < essence.Fields.Count - 1; j++) { createTableString += essence.Fields[j].Name + " " + essence.Fields[j].Type + ", "; } if(essence.Fields.Count-1>-1) createTableString += essence.Fields[essence.Fields.Count - 1].Name + " " + essence.Fields[essence.Fields.Count - 1].Type; createTableString += ");"; if (essence.Keys.Count > 0) { string Keys = "primary key ("; for (int j = 0; j < essence.Keys.Count; j++) { Keys += essence.Fields[essence.Keys[j]].Name + ", "; } Keys = Keys.Remove(Keys.Length - 2); Keys += ") "; int insertIndex = createTableString.IndexOf(")"); createTableString = createTableString.Insert(insertIndex, ", "+Keys); } cmd = new MySqlCommand(createTableString,conn); cmd.ExecuteNonQuery(); } conn.Close(); }
public RelationshipView(Control.ControlCollection collection, Essenishial one, Essenishial two, ErRelationshipConnectType firsType, ErRelationshipConnectType secType, ErDiagram Diagram ) { targetDiagram = Diagram; ErConnectEssencePair firstPair = new ErConnectEssencePair(one.Essence, firsType); ErConnectEssencePair secondPair = new ErConnectEssencePair(two.Essence, secType); targetRelationship = new ErRelationship(firstPair, secondPair); targetDiagram.AddRelationship(targetRelationship); oneEssenishial = one; twoEssenishial = two; one.OneOrTwoList.Add(1); two.OneOrTwoList.Add(2); OnePoint = one.GetCentralPoint(); TwoPoint = two.GetCentralPoint(); one.RelationshipViewList.Add(this); two.RelationshipViewList.Add(this); MiddlePoint = new Point((OnePoint.X + TwoPoint.X) / 2, (OnePoint.Y + TwoPoint.Y) / 2); containerOne = new ShapeContainer(); OneToMiddleLine = new LineShape(OnePoint.X, OnePoint.Y, MiddlePoint.X, MiddlePoint.Y); OneToMiddleLine.DoubleClick += OpenRelationshipEditorWindow; OneToMiddleLine.BorderWidth = 3; OneToMiddleLine.BorderStyle = GetLineStyle(firsType.ModalType); MiddelToTwoLine = new LineShape(MiddlePoint.X, MiddlePoint.Y, TwoPoint.X, TwoPoint.Y); MiddelToTwoLine.BorderWidth = 3; MiddelToTwoLine.DoubleClick += OpenRelationshipEditorWindow; MiddelToTwoLine.BorderStyle = GetLineStyle(secType.ModalType); containerOne.Shapes.Add(OneToMiddleLine); containerOne.Shapes.Add(MiddelToTwoLine); //shape. collection.Add(containerOne); }