private string FormMapDB() { StringBuilder myHTML = new StringBuilder(); const string sqlSelect = "so.id, so.name as dbtable,(select count(syscolumns.id) from syscolumns where syscolumns.id=so.id) as nbfields"; ds = EvoDB.GetData(EvoDB.BuildSQL(sqlSelect, "sysobjects as so", whereMapDB, "dbtable", 500), _SqlConnection, ref ErrorMsg); DataTable t0 = ds.Tables[0]; int ml = t0.Rows.Count; if (ml > 0) { myHTML.Append("<p>Please select the database tables to build UI for:</p><p>"); for (int i = 0; i < ml; i++) { DataRow ri = t0.Rows[i]; string cId = ri["ID"].ToString(); myHTML.Append(EvoUI.HTMLInputCheckBox("table2map", cId, String.Format("{0} ({1} columns)", ri["dbtable"], ri["nbfields"]), false, cId)); myHTML.Append("</br>"); } myHTML.Append("</p>"); } else { return(EvoUI.HTMLMessage("No database objects available.", EvoUI.MsgType.Error)); } return(myHTML.ToString()); }
private string FormInstall() { StringBuilder myHTML = new StringBuilder(); bool xmlOK = false; XmlDocument myDOM2 = new XmlDocument(); try { myDOM2.Load(FileNameWithMask(_PathXML + "Wizard_Install.xml")); xmlOK = true; } catch //(Exception ex) { myHTML.Append(EvoUI.HTMLMessage("XML not found or invalid.", EvoUI.MsgType.Error)); //.Append(ex.Message); } if (xmlOK) { XmlNode nApps = myDOM2.SelectSingleNode("wizard_install"); if (nApps != null) { foreach (XmlNode nGroup in nApps.ChildNodes) { if (nGroup.NodeType == XmlNodeType.Element && nGroup.Name == "appgroup") { myHTML.AppendFormat("<p>{0}:</p>", nGroup.Attributes[xAttribute.label].Value); foreach (XmlNode nApp in nGroup.ChildNodes) { string icon = String.Empty; if (nApp.Attributes[xAttribute.icon] != null) { icon = nApp.Attributes[xAttribute.icon].Value; } if (!String.IsNullOrEmpty(icon)) { icon = EvoUI.HTMLIcon(_PathPix, icon); } string label = icon + nApp.Attributes[xAttribute.label].Value; string id = nApp.Attributes["file"].Value; if (id.Length > 0) { id = id.Substring(0, id.Length - 4); myHTML.Append(EvoUI.HTMLInputCheckBox("frmID", id, label, false, id)); myHTML.Append(EvoUI.tag_BR); } } } } } else { myHTML.Append(EvoUI.HTMLMessage("XML is invalid.", EvoUI.MsgType.Error)); } } myDOM = null; myHTML.Append(EvoUI.tag_BR); return(myHTML.ToString()); }