public static string SELECT_BUILDER(SelectCaller local_caller, Common.QueryConditions conditions) { string query = string.Empty; string union = " UNION "; string copy = string.Empty; foreach (KeyValuePair <ETipoEntidad, TEntidadRegistroBase> entity in ModuleController.Instance.ActiveEntidades) { if (!entity.Value.Active) { continue; } copy = query; conditions.TipoEntidad = entity.Key; query += union + local_caller(conditions); if (query == (copy + union)) { query = copy; } } query = query.Substring(union.Length); return(query); }
public static string SELECT_BUILDER(SelectCaller local_caller, ETipoEntidad[] list, Common.QueryConditions conditions) { string query = string.Empty; string union = @" UNION " ; string copy = string.Empty; /*foreach (KeyValuePair<ETipoEntidad, TEntidadRegistroBase> entity in ModuleController.Instance.ActiveEntidades) * if (entity.Value.Active) * { * foreach (ETipoEntidad item in list) * if (item == entity.Value.ETipoEntidad) * { * copy = query; * conditions.TipoEntidad = item; * query += union + local_caller(conditions); * * if (query == (copy + union)) query = copy; * } * }*/ TEntidadRegistroBase entity; foreach (ETipoEntidad item in list) { if (!ModuleController.Instance.ActiveEntidades.ContainsKey(item)) { continue; } entity = ModuleController.Instance.ActiveEntidades[item]; if (!entity.Active) { continue; } copy = query; conditions.TipoEntidad = item; query += union + local_caller(conditions); if (query == (copy + union)) { query = copy; } } query = query.Substring(union.Length); return(query); }