public void savePhysicalToXML(String fpath, MetaDataPhysical obj) { serializer = new XmlSerializer(typeof(MetaDataPhysical)); FileStream fs = new FileStream(fpath, FileMode.Create); serializer.Serialize(fs, obj); fs.Close(); }
public MetaDataPhysical loadPhysicalFromXML(String fpath) { serializer = new XmlSerializer(typeof(MetaDataPhysical)); FileStream fs = new FileStream(fpath, FileMode.Open); MetaDataPhysical obj = (MetaDataPhysical)serializer.Deserialize(fs); fs.Close(); return(obj); }
private void LoadDDLForm() { LoadPhyicalForm(); if (ActiveMdiChild != null && ActiveMdiChild.GetType().Name == "frmPhysicalDrawBoard") { MetaDataPhysical mdp = ((frmPhysicalDrawBoard)ActiveMdiChild).pnlPhysical.getMetaDataPhysical(); string formName = ActiveMdiChild.Text.Substring(0, ActiveMdiChild.Text.IndexOf("Physical")) + " Generate DDL"; Form f = findForm(formName); if (f != null) { f.Close(); } GenerateScriptSQL gpm = new GenerateScriptSQL(this, mdp); gpm.Text = formName; gpm.MdiParent = this; gpm.Show(); } }
public void drawMetaDataPhysical(MetaDataPhysical mdp) { //Vẽ MetaDataPhysical lên this Panel foreach (Table t in mdp.Tables) { TableShape ts = new TableShape(t); ts.Location = new Point(t.x, t.y); this.Controls.Add(ts); } foreach (ForeignKey fk in mdp.ForeignKeys) { TableShape shapePrimary = searchShapeInPannel(fk.ParentTable); TableShape shapeReference = searchShapeInPannel(fk.ChildTable); FKShape fkShape = new FKShape(); fkShape.fkName = fk.Name; fkShape.tableReference = shapeReference; fkShape.childColumn = fk.ChildColumn; fkShape.parentColumn = fk.ParentColumn; shapePrimary.listFK.Add(fkShape); } this.Invalidate(); }
//My Method public MetaDataPhysical getMetaDataPhysical() { //Convert tất cả shape qua MetaDataPhysical MetaDataPhysical mdp = new MetaDataPhysical(); //Duyệt tất cả controls trên Panel foreach (Control ctr in this.Controls) { TableShape tShape = (TableShape)ctr; mdp.Tables.Add(tShape.table); foreach (FKShape fkShape in tShape.listFK) { ForeignKey fk = new ForeignKey(); fk.Name = fkShape.fkName; fk.ParentTable = tShape.table.name; fk.ParentColumn = fkShape.parentColumn; fk.ChildTable = fkShape.tableReference.table.name; fk.ChildColumn = fkShape.childColumn; mdp.ForeignKeys.Add(fk); } } return(mdp); }
public ScriptMySql(MetaDataPhysical mdp, string dbName) { this.mdp = mdp; this.dbName = dbName; }
//Constructor public GenerateScriptSQL(MainForm f, MetaDataPhysical mdPhysical) { InitializeComponent(); frmMain = f; mdp = mdPhysical; }
/// <summary> /// Phương thức khởi tạo GenerateDDL /// </summary> /// <param name="mdp">Meta data physical</param> /// <param name="nameDBMS">Loại Database Manage System</param> /// <param name="dbName">Tên Database</param> public GenerateDDL(MetaDataPhysical mdp, DBMS nameDBMS, string dbName) { this.mdp = mdp; this.nameDBMS = nameDBMS; this.dbName = dbName; }