private void CommitFeatures(MSI.Database db, string root) { int display = 0; using (MSI.View view = Application.ExecView(db, "SELECT `Display` FROM `Feature` ORDER BY `Display`")) { for (MSI.Record rec = view.Fetch(); rec != null; rec = view.Fetch()) { if (!rec.IsNull(1)) { display = Math.Max(rec.GetInteger(1) / 2, display); } rec.Dispose(); } view.Close(); } display = (0 == display) ? 100 : display + 1; using (MSI.View view = db.OpenView("INSERT INTO `Feature`(" + "`Feature`,`Feature_Parent`,`Title`,`Description`," + "`Display`,`Level`,`Directory_`,`Attributes`) " + "VALUES (?,?,?,?,?,?,?,0)")) { for (int i = 0; i < m_components.Count; i++) { Component component = m_components[i] as Component; using (MSI.Record rec = new MSI.Record(7)) { rec.SetString(1, component.Name); rec.SetString(2, root); rec.SetString(3, component.Name); rec.SetString(4, component.Name); rec.SetInteger(5, 2 * (i + display)); rec.SetInteger(6, 1); rec.SetString(7, ""); view.Execute(rec); } } view.Close(); } }
private void CommitFiles(IzFree.Project project) { MSI.Database db = project.Database; int fileCounter = FileCounter(project); using (MSI.View view = db.OpenView("INSERT INTO `File`(" + "`File`,`Component_`,`FileName`,`FileSize`,`Version`," + "`Language`,`Attributes`,`Sequence`) " + "VALUES (?,?,?,?,?,?,0,1)")) { for (int i = 0; i < m_files.Count; i++) { File file = m_files[i] as File; using (MSI.Record rec = new MSI.Record(6)) { rec.SetString(1, DatabaseKey(file.Name) + "_f" + (fileCounter + i).ToString()); rec.SetString(2, file.Component.Name); rec.SetString(3, (file.ShortName.Length > 0) ? file.ShortName + "|" + file.Name : file.Name); rec.SetInteger(4, (int)file.Size); rec.SetString(5, file.Version); if (file.Version != "") { rec.SetInteger(6, 0); } else { rec.SetString(6, ""); } view.Execute(rec); } } view.Close(); } project.SetIzProperty("FileCounter", (fileCounter + m_files.Count).ToString()); }