4 using System.Collections.Generic;
14 public static partial class FunctionsAddons
20 public static DataTable _ConsultarAddonsInstalados(
string tcCondicion =
"")
22 string lcSql =
string.Empty;
23 DataTable ldtAddonsInstal =
new DataTable();
26 lcSql = $
"SELECT nombre as bd, nombre2 as nombre, activo, libreria, clase, id, CAST(CASE WHEN visible = 1 THEN '1' ELSE '0' END AS char(1)) as visible, " +
27 $
"instalado, tipo, descrip, url, {DB.SQLFalse()} as desactivar, observa, 1 as disponible, '' as mensaje, '' as ftp, checkupdat as checksumupdate " +
28 $
"FROM {DB.SQLDatabase("COMUNES
", "MODULOS
")} where visible = {DB.SQLTrue()} and instalado = {DB.SQLTrue()} ";
30 if (!
string.IsNullOrWhiteSpace(tcCondicion))
34 DB.SQLExec(lcSql, ref ldtAddonsInstal);
37 _RevisarAddonsTipo4(ldtAddonsInstal);
39 List<IAddonVirtual> loList = (from loAddon in AddonsController.Instance.AddonsManager.GetAddonsVirtuales()
41 select loAddon).ToList();
45 DataRow loRow = ldtAddonsInstal.NewRow();
47 loRow[
"id"] = loAddon.
Id;
48 loRow[
"bd"] = loAddon.
Nombre;
49 loRow[
"nombre"] = loAddon.
Nombre2;
50 loRow[
"activo"] =
true;
51 loRow[
"instalado"] =
true;
52 loRow[
"visible"] =
"1";
53 loRow[
"desactivar"] =
false;
55 loRow[
"disponible"] = 1;
56 loRow[
"mensaje"] =
"";
60 ldtAddonsInstal.Rows.Add(loRow);
64 ldtAddonsInstal.AcceptChanges();
66 return ldtAddonsInstal;
74 public static DataTable _ConsultarAddonsDeshabilitados(
string tcCondicion =
"")
77 DataTable ldtAddonsDisabled =
new DataTable();
80 lcSql = $
"SELECT nombre as bd, nombre2 as nombre, activo, libreria, clase, id, CAST(CASE WHEN visible = 1 THEN '1' ELSE '0' END AS char(1)) as visible, " +
81 $
"instalado, tipo, descrip, url, {DB.SQLFalse()} as desactivar, observa " +
82 $
"FROM {DB.SQLDatabase("COMUNES
", "MODULOS
")} where visible = {DB.SQLFalse()} and instalado = {DB.SQLFalse()}";
84 if (!
string.IsNullOrWhiteSpace(tcCondicion))
87 DB.SQLExec(lcSql, ref ldtAddonsDisabled);
90 return ldtAddonsDisabled;
97 public static void _RevisarAddonsTipo4(DataTable dtRevisar)
103 DataRow[] ldRows = dtRevisar.Select(
"tipo=4");
105 foreach (DataRow loRow
in ldRows)
string Descripcion
Descripción
string Observaciones
Observaciones
Interficies IAddonVirtual