Interface IStdBSCategorias
Assembly: StdPlatBS100.dll
Syntax
[ComVisible(true)]
[Guid("AB223289-A369-45EC-8D0D-2347453C0372")]
public interface IStdBSCategorias
Properties
Categorias
Declaration
StdBESqlCategorias Categorias { get; }
Property Value
Type |
Description |
StdBESql100.StdBESqlCategorias |
|
ProgressoCategorias
Declaration
bool ProgressoCategorias { set; }
Property Value
Type |
Description |
System.Boolean |
|
Tabelas
Declaration
StdBESqlTabelas Tabelas { get; }
Property Value
Type |
Description |
StdBESql100.StdBESqlTabelas |
|
Methods
AbreListaCategoria(String)
Declaration
void AbreListaCategoria(string strCategoria)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
AbreListaCategoriaParametros(String, StdBEValoresStr)
Declaration
void AbreListaCategoriaParametros(string strCategoria, StdBEValoresStr objParametros)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
StdBEValoresStr |
objParametros |
|
AbreListaCategoriaWhere(String, String, Boolean, String)
Declaration
void AbreListaCategoriaWhere(string strCategoria, string strClausulaWhere, bool blnModal, string strQueryGuid = "")
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String |
strClausulaWhere |
|
System.Boolean |
blnModal |
|
System.String |
strQueryGuid |
|
AbreListaSQL(String, String, StdBEF4, Boolean)
Declaration
void AbreListaSQL(string strQuerySQL, string strTitulo, StdBEF4 objF4Ctrl = null, bool blnJanelaModal = false)
Parameters
Type |
Name |
Description |
System.String |
strQuerySQL |
|
System.String |
strTitulo |
|
StdBEF4 |
objF4Ctrl |
|
System.Boolean |
blnJanelaModal |
|
ActualizaQuery(StdBESqlQuery)
Declaration
void ActualizaQuery(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
carregaFiltroCategorias(StdBESqlQuery)
Declaration
void carregaFiltroCategorias(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
CategoriasExpressoes(String, String)
Declaration
StdBESqlExpressao CategoriasExpressoes(string strCategoria, string GUID = "")
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String |
GUID |
|
Returns
Type |
Description |
StdBESql100.StdBESqlExpressao |
|
CriaNovaLista(String)
Declaration
StdBESqlQuery CriaNovaLista(string Categoria)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
Returns
Type |
Description |
StdBESql100.StdBESqlQuery |
|
DaCategoriasAuditBW()
Declaration
clsCategorias DaCategoriasAuditBW()
Returns
Type |
Description |
StdClasses100.clsCategorias |
|
DaIdQueryPorDefeito(String)
Declaration
string DaIdQueryPorDefeito(string Categoria)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
Returns
Type |
Description |
System.String |
|
DaQuery(String)
Declaration
StdBESqlQuery DaQuery(string GuidQuery)
Parameters
Type |
Name |
Description |
System.String |
GuidQuery |
|
Returns
Type |
Description |
StdBESql100.StdBESqlQuery |
|
DaQueryPorDefeito(String, StdBESqlQueries)
Declaration
StdBESqlQuery DaQueryPorDefeito(string Categoria, StdBESqlQueries Queries)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
StdBESql100.StdBESqlQueries |
Queries |
|
Returns
Type |
Description |
StdBESql100.StdBESqlQuery |
|
DaTabelaPrimaria(String)
Declaration
StdBESqlTabela DaTabelaPrimaria(string Categoria)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
Returns
Type |
Description |
StdBESql100.StdBESqlTabela |
|
EditaLista(StdBESqlQuery, Boolean)
Declaration
bool EditaLista(StdBESqlQuery objQuery, bool blnGravaAlteracoes = true)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
System.Boolean |
blnGravaAlteracoes |
|
Returns
Type |
Description |
System.Boolean |
|
EditaQuery(String)
Declaration
StdBESqlQuery EditaQuery(string strIdQuery)
Parameters
Type |
Name |
Description |
System.String |
strIdQuery |
|
Returns
Type |
Description |
StdBESql100.StdBESqlQuery |
|
ExisteQuery(String)
Declaration
bool ExisteQuery(string strIdQuery)
Parameters
Type |
Name |
Description |
System.String |
strIdQuery |
|
Returns
Type |
Description |
System.Boolean |
|
FiltroCategoria(String)
Declaration
string FiltroCategoria(string Categoria)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
Returns
Type |
Description |
System.String |
|
FiltroPersonalizado(String, Boolean)
Declaration
string FiltroPersonalizado(string strCategoria, bool blnFormatacaoMapas = false)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.Boolean |
blnFormatacaoMapas |
|
Returns
Type |
Description |
System.String |
|
GeraSql(StdBESqlQuery, Boolean, List<String>)
Declaration
string GeraSql(StdBESqlQuery objQuery, bool blnPreencheParametros = true, List<string> listParameters = null)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
System.Boolean |
blnPreencheParametros |
|
System.Collections.Generic.List<System.String> |
listParameters |
|
Returns
Type |
Description |
System.String |
|
GeraSqlAdHoc(StdBESqlQuery, Boolean, List<String>)
Declaration
string GeraSqlAdHoc(StdBESqlQuery objQuery, bool blnPreencheParametros = true, List<string> listParameters = null)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
System.Boolean |
blnPreencheParametros |
|
System.Collections.Generic.List<System.String> |
listParameters |
|
Returns
Type |
Description |
System.String |
|
GeraSqlFrom(StdBESqlQuery)
Declaration
string GeraSqlFrom(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
Returns
Type |
Description |
System.String |
|
GeraSqlFromCategoria(String)
Declaration
string GeraSqlFromCategoria(string strCategoria)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
Returns
Type |
Description |
System.String |
|
GeraSqlFromCategoriaExpressao(String, StdBESqlExpressao)
Declaration
string GeraSqlFromCategoriaExpressao(string strCategoria, StdBESqlExpressao objExpressao)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
StdBESql100.StdBESqlExpressao |
objExpressao |
|
Returns
Type |
Description |
System.String |
|
GeraSqlGroupBy(StdBESqlQuery)
Declaration
string GeraSqlGroupBy(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
Returns
Type |
Description |
System.String |
|
GeraSqlHaving(StdBESqlQuery)
Declaration
string GeraSqlHaving(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
Returns
Type |
Description |
System.String |
|
GeraSqlOrder(StdBESqlQuery)
Declaration
string GeraSqlOrder(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
Returns
Type |
Description |
System.String |
|
GeraSqlSelect(StdBESqlQuery)
Declaration
string GeraSqlSelect(StdBESqlQuery objQuery)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
Returns
Type |
Description |
System.String |
|
GeraSqlWhere(StdBESqlQuery, Boolean, List<String>)
Declaration
string GeraSqlWhere(StdBESqlQuery objQuery, bool blnPreencheParametros = true, List<string> listParameters = null)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
System.Boolean |
blnPreencheParametros |
|
System.Collections.Generic.List<System.String> |
listParameters |
|
Returns
Type |
Description |
System.String |
|
GeraSqlWhereCategoria(String, String, Boolean)
Declaration
string GeraSqlWhereCategoria(string strCategoria, string strUtilizador, bool blnFormatacaoMapas = false)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String |
strUtilizador |
|
System.Boolean |
blnFormatacaoMapas |
|
Returns
Type |
Description |
System.String |
|
GeraSqlWhereCategoriaFiltro(String, String, String, String, String, StdBESqlFiltroPersonalizado, Boolean)
Declaration
string GeraSqlWhereCategoriaFiltro(string strTabelaPrincipal, string strCampoPrincipal, string strTabelaFiltro, string strCampoFiltro, string strCategoria, StdBESqlFiltroPersonalizado objFiltro, bool blnMapeamentos = true)
Parameters
Type |
Name |
Description |
System.String |
strTabelaPrincipal |
|
System.String |
strCampoPrincipal |
|
System.String |
strTabelaFiltro |
|
System.String |
strCampoFiltro |
|
System.String |
strCategoria |
|
StdBESql100.StdBESqlFiltroPersonalizado |
objFiltro |
|
System.Boolean |
blnMapeamentos |
|
Returns
Type |
Description |
System.String |
|
GeraSqlWhereCategoriaSubQuery(String, String, String, String, String, String)
Declaration
string GeraSqlWhereCategoriaSubQuery(string strTabelaPrincipal, string strCampoPrincipal, string strTabelaFiltro, string strCampoFiltro, string strCategoria, string strUtilizador = "")
Parameters
Type |
Name |
Description |
System.String |
strTabelaPrincipal |
|
System.String |
strCampoPrincipal |
|
System.String |
strTabelaFiltro |
|
System.String |
strCampoFiltro |
|
System.String |
strCategoria |
|
System.String |
strUtilizador |
|
Returns
Type |
Description |
System.String |
|
GeraSqlWhereEx(StdBESqlQuery, Boolean)
Declaration
string GeraSqlWhereEx(StdBESqlQuery objQuery, bool blnPreencheParametros = true)
Parameters
Type |
Name |
Description |
StdBESql100.StdBESqlQuery |
objQuery |
|
System.Boolean |
blnPreencheParametros |
|
Returns
Type |
Description |
System.String |
|
ListaQueriesAdHocPublicas(ref String[,], Object, String)
Declaration
bool ListaQueriesAdHocPublicas(ref string[, ] strQueries, object objControlo = null, string strSelectQueryGuid = "")
Parameters
Type |
Name |
Description |
System.String[,] |
strQueries |
|
System.Object |
objControlo |
|
System.String |
strSelectQueryGuid |
|
Returns
Type |
Description |
System.Boolean |
|
ListaQueriesComFiltroPorCategoria(String, ref String[,], Object, String)
Declaration
bool ListaQueriesComFiltroPorCategoria(string Categoria, ref string[, ] Queries, object Controlo = null, string SelectQueryGuid = "")
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
System.String[,] |
Queries |
|
System.Object |
Controlo |
|
System.String |
SelectQueryGuid |
|
Returns
Type |
Description |
System.Boolean |
|
ListaQueriesPorCategoria(String, ref String[,], Object, String)
Declaration
bool ListaQueriesPorCategoria(string Categoria, ref string[, ] Queries, object Controlo = null, string SelectQueryGuid = "")
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
System.String[,] |
Queries |
|
System.Object |
Controlo |
|
System.String |
SelectQueryGuid |
|
Returns
Type |
Description |
System.Boolean |
|
ListaQueriesPorCategoriaEx(String, ref String[,], Object, String)
Declaration
bool ListaQueriesPorCategoriaEx(string Categoria, ref string[, ] Queries, object Controlo = null, string SelectQueryGuid = "")
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
System.String[,] |
Queries |
|
System.Object |
Controlo |
|
System.String |
SelectQueryGuid |
|
Returns
Type |
Description |
System.Boolean |
|
ListaQueriesPublicasPorCategoria(String, ref String[,], Object, String)
Declaration
bool ListaQueriesPublicasPorCategoria(string strCategoria, ref string[, ] strQueries, object objControlo = null, string strSelectQueryGuid = "")
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String[,] |
strQueries |
|
System.Object |
objControlo |
|
System.String |
strSelectQueryGuid |
|
Returns
Type |
Description |
System.Boolean |
|
ListasCarregaCategorias(Boolean, Boolean)
Declaration
StdBEValoresStr ListasCarregaCategorias(bool blnTodas, bool blnSQL)
Parameters
Type |
Name |
Description |
System.Boolean |
blnTodas |
|
System.Boolean |
blnSQL |
|
Returns
ParseCamposAutomaticos(ref String)
Declaration
string ParseCamposAutomaticos(ref string strValue)
Parameters
Type |
Name |
Description |
System.String |
strValue |
|
Returns
Type |
Description |
System.String |
|
ParseCamposAutomaticosEx2(ref String)
Declaration
string ParseCamposAutomaticosEx2(ref string strValue)
Parameters
Type |
Name |
Description |
System.String |
strValue |
|
Returns
Type |
Description |
System.String |
|
TestaPermissaoLista(String, String, String, Boolean, StdBETipos.TipoPermissaoListas, Boolean)
Declaration
bool TestaPermissaoLista(string strCategoria, string strIdLista, string strCriadorLista, bool blnListaSistema, StdBETipos.TipoPermissaoListas enuTipoPermissao, bool blnSilencioso = false)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String |
strIdLista |
|
System.String |
strCriadorLista |
|
System.Boolean |
blnListaSistema |
|
StdBETipos.TipoPermissaoListas |
enuTipoPermissao |
|
System.Boolean |
blnSilencioso |
|
Returns
Type |
Description |
System.Boolean |
|
ValidaEdicao(String, String, String, String)
Declaration
bool ValidaEdicao(string strCategoria, string strTabela, string strCampo, string strChave)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String |
strTabela |
|
System.String |
strCampo |
|
System.String |
strChave |
|
Returns
Type |
Description |
System.Boolean |
|
ValidaEdicaoRegisto(String, String, String, Object[])
Declaration
bool ValidaEdicaoRegisto(string Categoria, string Tabela, string Campo, params object[] Chaves)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
System.String |
Tabela |
|
System.String |
Campo |
|
System.Object[] |
Chaves |
|
Returns
Type |
Description |
System.Boolean |
|
ValidaOperacao(String, String, String, String)
Declaration
bool ValidaOperacao(string strCategoria, string strTabela, string strCampo, string strChave)
Parameters
Type |
Name |
Description |
System.String |
strCategoria |
|
System.String |
strTabela |
|
System.String |
strCampo |
|
System.String |
strChave |
|
Returns
Type |
Description |
System.Boolean |
|
ValidaOperacaoRegisto(String, String, String, Object[])
Declaration
bool ValidaOperacaoRegisto(string Categoria, string Tabela, string Campo, params object[] Chaves)
Parameters
Type |
Name |
Description |
System.String |
Categoria |
|
System.String |
Tabela |
|
System.String |
Campo |
|
System.Object[] |
Chaves |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
bool VerificaExisteCollection(string strKey, PrimaveraOrderedDictionary Collection)
Parameters
Type |
Name |
Description |
System.String |
strKey |
|
Primavera.Platform.Collections.PrimaveraOrderedDictionary |
Collection |
|
Returns
Type |
Description |
System.Boolean |
|