public static DataTable GetAllEscalaMesAtuacao(
ConnectionInfo pInfo,
String pESC_DIA,
decimal pATUA_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = EscalaQD.qEscalaAtividadeList;
lQuery += " WHERE ESC_STATUS NOT IN ('I','E') ";
lQuery += " AND A.ATDEF_ID = B.ATDEF_ID ";
lQuery += string.Format(" AND A.{0} = >>{0} ", EscalaQD._ATUA_ID.Name);
lQuery += string.Format(" AND to_char(A.{0}, 'mm') = to_char(>>{0}, 'mm')", EscalaQD._ESC_DIA.Name);
lQuery += string.Format(" AND to_char(A.{0}, 'yyyy') = to_char(>>{0}, 'yyyy')", EscalaQD._ESC_DIA.Name);
lQuery += "Order By ESC_DIA ";
SelectCommand lSelect = new SelectCommand(lQuery);
lSelect.Fields.Add(EscalaQD._ATUA_ID.Name, pATUA_ID, (ItemType)EscalaQD._ATUA_ID.DBType);
lSelect.Fields.Add(EscalaQD._ESC_DIA.Name, pESC_DIA, (ItemType)EscalaQD._ESC_DIA.DBType);
lSelect.Fields.Add(EscalaQD._ESC_DIA.Name, pESC_DIA, (ItemType)EscalaQD._ESC_DIA.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllBibliotecapendenciasdevolucao3(
ConnectionInfo pInfo,
decimal ept_pesf_id,
string PES_NOME,
string item
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery += Biblioteca_EmprestimoQD.GetAllBibliotecapendenciasdevolucao3;
lQuery += @" where e.ept_id=b.ept_id
and e.ept_pesf_id=" + ept_pesf_id + @"
and e.ept_status='A'
AND B.IEPT_STATUS='A'
and ti.ttab_id=b.ttab_id
and l.lvr_id = v.lvr_id
and v.il_id = b.cod_item
and UPPER(p.pes_nome) LIKE UPPER('%{0}%')
and ti.ttab_id='{1}' ";
lQuery = string.Format(lQuery, PES_NOME, item);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static OperationResult Insert(DataFieldCollection pValues, ConnectionInfo pInfo)
{
Transaction lTransaction;
lTransaction = new Transaction(Instance.CreateDatabase(pInfo));
bool lLocalTransaction = (lTransaction != null);
InsertCommand lInsert;
OperationResult lReturn = new OperationResult(PORT_BANNERQD.TableName, PORT_BANNERQD.TableName);
if (!lReturn.HasError){
try{
if (lLocalTransaction){
lReturn.Trace("Transação local, instanciando banco...");
}
lInsert = new InsertCommand(PORT_BANNERQD.TableName);
lReturn.Trace("Adicionando campos ao objeto de insert");
foreach (DataField lField in pValues.Keys){
lInsert.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType);
}
decimal lSequence;
lSequence = DataBaseSequenceControl.GetNext(pInfo, "BAN_ID");
lInsert.Fields.Add(PORT_BANNERQD._BAN_ID.Name, lSequence, (ItemType)PORT_BANNERQD._BAN_ID.DBType);
lReturn.Trace("Executando o Insert");
lInsert.Execute(lTransaction, false);
if (!lReturn.HasError){
if (lLocalTransaction){
if (!lReturn.HasError){
lReturn.Trace("Insert finalizado, executando commit");
lTransaction.Commit();
}
else{
lTransaction.Rollback();
}
}
}
else{
if (lLocalTransaction)
lTransaction.Rollback();
}
}
catch (Exception ex){
lReturn.OperationException = new SerializableException(ex);
if (lLocalTransaction)
lTransaction.Rollback();
}
}
return lReturn;
}
public static int Delete(
ConnectionInfo pInfo,
string pTRA_ID
)
{
string lQuery = "";
int lResult;
DataTable lTable = new DataTable();
lQuery = " DELETE FROM " + TRAMITACAOQD.TableName;
lQuery += " WHERE " + TRAMITACAOQD._TRA_ID.Name + " = " + pTRA_ID;
SelectCommand lSelect = new SelectCommand(lQuery);
try
{
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
lResult = 1;
}
catch (Exception Err)
{
lResult = 0;
}
return lResult;
}
public static DataTable getCargoSetorNucleo(
ConnectionInfo pInfo,
string pPesf_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = SETORQD.qSetorNucleoCargo;
lQuery += @" WHERE PF.PES_ID = P.PES_ID
AND PF.FUNC_ID = F.FUNC_ID
AND C.PES_ID = P.PES_ID
AND C.AGE_ID = A.AGE_ID
AND A.BAN_ID = B.BAN_ID
AND P.PES_CPF IS NOT NULL
AND PF.SET_ID=S.SET_ID
AND S.NUC_ID = N.NUC_ID
AND PF.PESF_STATUS = 'A'
AND P.PES_STATUS = 'A'
AND C.CONT_STATUS = 'A'
AND A.AGE_STATUS = 'A'
AND B.BAN_STATUS = 'A'
AND PF.PESF_ID = " + pPesf_ID;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllMEIADIARIABUSCAID(
ConnectionInfo pInfo, string pCID_DESC
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = MEIADIARIAQD.qMeiaDiariaListCompleteBuscaID;
lQuery += @" WHERE M.DIACID_ID_ORIGEM = C1.CID_ID
AND M.DIACID_ID_DESTINO = C2.CID_ID
AND M.TVD_ID = T.TVD_ID
AND C1.UF_ID = U1.UF_ID
AND C2.UF_ID = U2.UF_ID
AND C1.CID_DESC LIKE '%{0}%'
AND C1.CID_STATUS='A'
AND T.TVD_STATUS='A'
AND C2.CID_STATUS='A'
AND M.MEIA_STATUS='A'
AND U1.UF_STATUS='A'
AND U2.UF_STATUS='A' ";
lQuery = string.Format(lQuery, pCID_DESC);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static int Delete(
ConnectionInfo pInfo,
decimal pMATERIAL_ID
)
{
string lQuery = "";
int lResult;
DataTable lTable = new DataTable();
lQuery = " DELETE FROM " + MATDETXFORNECEDORQD.TableName;
lQuery += " WHERE MATERIAL_ID = " + pMATERIAL_ID;
SelectCommand lSelect = new SelectCommand(lQuery);
try
{
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
lResult = 1;
}
catch (Exception Err)
{
lResult = 0;
}
return lResult;
}
public static DataTable GetAllRelatorioPendente(
ConnectionInfo pInfo, string pPESF_proposto, string pDATA
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RELATORIOVIAGEMQD.qRELATORIOVIAGEMPendente;
lQuery += @" WHERE D.DIA_STATUS='A'
AND P.PES_STATUS='A'
AND PC.PRES_STATUS='A'
AND PF.PESF_STATUS='A'
AND DP.DIAPRO_STATUS='A'
AND DOC.DDOC_STATUS='A'
and D.PRES_ID = PC.PRES_ID
AND D.DOC_ID = DOC.DOC_ID
AND D.DIA_ID = DP.DIA_ID
AND D.PESF_PROPONENTE = PF.PESF_ID
AND P.PES_ID = PF.PES_ID
AND (SELECT COUNT(*) FROM RELATORIOVIAGEM WHERE DIAPRO_ID = DP.DIAPRO_ID) = 0
AND DP.PESF_PROPOSTO = {0}
AND PC.PRES_DATAPRESTACAO <= '{1}'
ORDER BY PC.PRES_DATAPRESTACAO";
lQuery = string.Format(lQuery, pPESF_proposto, pDATA);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataSet From(ConnectionInfo pInfo, string pSelectQuery, DataFieldCollection pConditionalParameters)
{
DataBase lDB;
Transaction lTransaction = null;
DataSet lReturn = new DataSet();
try
{
lDB = Instance.CreateDatabase(pInfo);
lTransaction = new Transaction(lDB);
lReturn = From(lTransaction, pSelectQuery, pConditionalParameters);
lTransaction.Commit();
}
catch (Exception lException)
{
if (lTransaction != null)
lTransaction.Rollback();
throw lException;
}
return lReturn;
}
public static DataTable GetTRAMITACAOByDIARIA(
ConnectionInfo pInfo, string pDIA_ID, string pSET_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
//lQuery = TRAMITACAOQD.qtraMITACAOList;
lQuery += @" SELECT T.TRA_ID, D.DIA_ID, DD.DOC_ID, t.sped_id
FROM TRAMITACAO T, DIARIA D, DEFDOCUMENTO DD, SEQUENCIAORGANOGRAMA S1, SEQUENCIAORGANOGRAMA S2
WHERE T.TRA_STATUS='A'
AND D.DIA_STATUS='A'
AND DD.DDOC_STATUS='A'
AND T.SORG_ID = S1.SORG_ID
AND S1.SORG_IDCORRESPONDENTE=S2.SORG_ID
AND T.DOC_ID=DD.DOC_ID
AND DD.DOC_ID=D.DOC_ID
AND D.DIA_ID={0}
AND S2.SET_ID={1}";
lQuery = string.Format(lQuery, pDIA_ID, pSET_ID);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetPORT_BANNERByID(string pNOT_ID,ConnectionInfo pInfo){
DataTable lReturn = new DataTable();
lReturn = PORT_BANNERDo.GetPORT_BANNERByID(pNOT_ID, pInfo);
return lReturn;
}
public static DataTable GetALLDESTINACAOXSUPRIMENTOFUNDOALLbyID2(
ConnectionInfo pInfo, string pSUPFUN_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DESTINACAOXSUPRIMENTOFUNDOQD.qDESTINACAOXSUPRIMENTOFUNDOALL2;
lQuery += @" where ds.destfundo_status='A'
and g.gpp_status='A'
and fp.funcpro_status='A'
and df.detfont_status='A'
and nd.natdes_status='A'
and pl.plani_status='A'
and d.dest_status='A'
and ds.dest_id = d.dest_id
AND PF.PES_ID = P.PES_ID
AND PF.SET_ID = SE.SET_ID
AND S.pesf_proposto = PF.PESF_ID
AND PF.FUNC_ID = F.FUNC_ID
and pl.plani_id = ds.plani_id
and ds.gpp_id = g.gpp_id
and g.funcpro_id = fp.funcpro_id
and ds.detfont_id = df.detfont_id
and df.natdes_id = nd.natdes_id
and ds.supfun_id = " + pSUPFUN_ID;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetPEDIDOCOMPRAITEM_MATERIALFORNECEDOR(
ConnectionInfo pInfo,
string pPEDCOMP_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PEDIDOCOMPRAITEMQD.qPEDIDOCOMPRAITEM_MaterialFornecedor;
lQuery += @" WHERE MF.MATFORN_STATUS='A'
AND M.MATERIAL_STATUS='A'
AND PI.PEDITEM_STATUS='A'
AND F.FORN_STATUS='A'
AND PI.MATFORN_ID=MF.MATFORN_ID
AND MF.MATERIAL_ID=M.MATERIAL_ID
AND PI.PEDCOMP_ID={0}
AND MF.FORN_ID=F.FORN_ID ";
lQuery = string.Format(lQuery, pPEDCOMP_ID);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetExtratoPortaria(
ConnectionInfo pInfo, string pPORT_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery += @" SELECT DIAP.DIA_ID,PORT.PORT_NUMERO PORTARIA, TO_CHAR(PORT.PORT_REGDATE, 'DD/MM/YYYY')PORT_REGDATE
,DIAQ.DIAQT_DIARIATOTAL TOTAL,TO_CHAR(DIAQ.DIAQT_DATADEINICIO, 'DD/MM/YYYY') INI, TO_CHAR(DIAQ.DIAQT_DATADETERMINO, 'DD/MM/YYYY') FIM
,(SELECT UPPER(CID.CID_DESC) FROM CIDADE CID WHERE CID.CID_ID = DIAQ.CID_ID_LOCALDEPARTIDA) ORIGEM
,(SELECT UPPER(CID.CID_DESC) FROM CIDADE CID WHERE CID.CID_ID = DIAQ.CID_ID_LOCALDEDESTINO) DESTINO
FROM PORTARIA PORT LEFT JOIN DIARIAXPORTARIA DIAP
ON PORT.PORT_ID = DIAP.PORT_ID
LEFT JOIN DIARIAQUANTIDADE DIAQ
ON DIAP.DIA_ID = DIAQ.DIA_ID
WHERE PORT.PORT_ID = {0}
ORDER BY INI ";
lQuery = string.Format(lQuery, pPORT_ID);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllPERIODOXSETORNOME(
ConnectionInfo pInfo, Decimal pSET_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
// lQuery = PERIODOXSETORQD.qPERIODOXSETORList;
// lQuery += @" WHERE PERQ_STATUS='A'
// AND S.SET_ID = P.SET_ID
// AND S.SET_STATUS='A'
// AND P.PERQ_DIAINICIO <= SYSDATE
// AND P.PERQ_DATAFIM >= SYSDATE
// AND S.SET_ID = " + pSET_ID;
lQuery += @" SELECT S.*,P.*
from PERIODOXSETOR P , SETOR S WHERE PERQ_STATUS='A'
AND S.SET_ID = P.SET_ID
AND S.SET_STATUS='A'
AND S.SET_ID = " + pSET_ID;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetDIARIAXTIPODESLOCAMENTObyID(
ConnectionInfo pInfo, string pDIA_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery += " SELECT DISTINCT DT.DIA_ID, TD.DESLOC_ID, TD.DESLOC_NOME ";
lQuery += " FROM DIARIAXTIPODESLOCAMENTO DT, TIPODESLOCAMENTO TD ";
lQuery += " WHERE DIATIPO_STATUS='A' ";
lQuery += " AND TD.DESLOC_STATUS='A' ";
lQuery += " AND DT.DESLOC_ID = TD.DESLOC_ID ";
lQuery += " AND DT.DESLOC_ID NOT IN (8) ";
lQuery += " AND DIA_ID = " + pDIA_ID + " ";
lQuery += " UNION ";
lQuery += " SELECT DISTINCT DT.DIA_ID, TD.DESLOC_ID, TD.DESLOC_NOME || ' - ' || DT.DIATIPO_OUTROS AS DESLOC_NOME ";
lQuery += " FROM DIARIAXTIPODESLOCAMENTO DT, TIPODESLOCAMENTO TD ";
lQuery += " WHERE DIATIPO_STATUS='A' ";
lQuery += " AND TD.DESLOC_STATUS='A' ";
lQuery += " AND DT.DESLOC_ID = TD.DESLOC_ID ";
lQuery += " AND DT.DESLOC_ID = 8 ";
lQuery += " AND DIA_ID = " + pDIA_ID + " ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllBibliotecapendenciasdevolucao2(
ConnectionInfo pInfo,
decimal ept_pesf_id,
string PES_NOME,
string data
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery += Biblioteca_EmprestimoQD.GetAllBibliotecapendenciasdevolucao2;
lQuery += @" WHERE e.ept_pesf_id=" + ept_pesf_id + @"
AND e.ept_id=b.ept_id
and e.ept_status='A'
AND B.IEPT_STATUS='A'
),e.ept_pesf_id,P.PES_NOME";
lQuery += Biblioteca_EmprestimoQD.GetAllBibliotecapendenciasdevolucaosub2;
lQuery += @" where e.ept_id=b.ept_id
AND e.ept_pesf_id=" + ept_pesf_id + @"
and e.ept_status='A'
AND B.IEPT_STATUS='A'
AND UPPER(PES_NOME) LIKE UPPER('%{0}%')
and f.pes_id= P.PES_ID
and e.ept_data_fim > to_date('" + data + "')";
lQuery = string.Format(lQuery, PES_NOME);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetMeusTRECHOS(
ConnectionInfo pInfo, decimal pDIA_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery += @" select A.DIATRE_ID,A.DIA_ID,F.UF_DESC AS UFORIGEM,B.CID_DESC AS ORIGEM ,F.UF_DESC AS UFDESTINO, E.CID_DESC AS DESTINO,A.DIATRE_DATA
from DIARIATRECHO A, CIDADE B ,CIDADE E,
DIARIA C,UNIDADEFEDERATIVA F,UNIDADEFEDERATIVA G
WHERE A.DIA_ID = C.DIA_ID
AND C.DIA_ID = A.DIA_ID
AND B.cid_id = A.cid_id_localorigem
AND E.cid_id = A.cid_id_localdestino
AND B.CID_STATUS='A'
AND E.CID_STATUS='A'
AND F.UF_STATUS='A'
AND A.DIATRE_STATUS = 'A'
AND F.UF_ID = B.UF_ID
AND G.UF_ID = B.UF_ID
AND A.DIA_ID = {0}";
lQuery = string.Format(lQuery, pDIA_ID);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllBIBLIOTECA_ITEMREVISTAID1(
ConnectionInfo pInfo,
string LV_ID,
decimal JRNL_REVISTA_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery += BIBLIOTECA_ITEMJRNL_REVISTAQD.GetAllBIBLIOTECA_ITEMLIVROID1;
lQuery += @" where il.JRNL_REVISTA_ID=lvr.JRNL_REVISTA_ID
and il.JRNL_REVISTA_ID=" + JRNL_REVISTA_ID + @"
and not exists(";
lQuery += BIBLIOTECA_ITEMJRNL_REVISTAQD.GetAllBIBLIOTECA_ITEMLIVROID1SUB;
lQuery += @"where ie.cod_item=il.ITEMJRNL_REVISTA_ID
and ie.ttab_id='{0}'
)";
lQuery = string.Format(lQuery, LV_ID);
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
/// <summary>
/// Altera Session NLS_COMP e NLS_SORT, para iguinorar acentos na pesquisa
/// </summary>
/// <returns></returns>
public static void AlterSessionBinary(ConnectionInfo pInfo)
{
SqlQuery lSqlQuery;
int i;
lSqlQuery = new SqlQuery(Instance.CreateDatabase(pInfo), "ALTER SESSION SET NLS_COMP=LINGUISTIC");
i = lSqlQuery.ExecuteNonQuery();
lSqlQuery = new SqlQuery(Instance.CreateDatabase(pInfo), "ALTER SESSION SET NLS_SORT=BINARY_AI");
i = lSqlQuery.ExecuteNonQuery();
}
/// <summary>
/// Retorna o count, espera já uma query de count
/// </summary>
/// <param name="pConnectionString">String de conexão com o banco</param>
/// <param name="pSelectQuery">Query para rodar (ex.: SELECT Count(PRV_ID) FROM Providers)</param>
/// <returns></returns>
public static decimal Count(ConnectionInfo pInfo, string pSelectQuery)
{
//TODO: Depois vai ter que criptografar pConnectionString e pSelectQuery
SelectCommand lSelect = new SelectCommand(pSelectQuery);
object lValue = lSelect.ReturnScalar(Instance.CreateDatabase(pInfo));
return lValue.DBToDecimal();
}
public static void LoadConnectionInfoScpj()
{
_ActiveConnectionScpj = ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings["ActiveConnectionStringSCPJ"]];
_ConnectionInfoScpj = new ConnectionInfo(
_ActiveConnectionScpj.ConnectionString,
(_ActiveConnectionScpj.ProviderName.ToLower() == "oracle") ? 0 : 1,
(ConfigurationManager.AppSettings["ApplicationServerMode"].ToLower() == "web") ? 0 : 1
);
}
public static DataTable GetAllPORT_BANNER(ConnectionInfo pInfo){
DataTable lReturn = new DataTable();
if (pInfo.BridgeMode == (int)BridgeMode.Internal){
lReturn = PORT_BANNERDo.GetAllPORT_BANNER(pInfo);
}
else{
// Chamada do WebServices
}
return lReturn;
}
public static OperationResult Update(DataFieldCollection pValues, ConnectionInfo pInfo) {
OperationResult lReturn = null;
if (pInfo.BridgeMode == (int)BridgeMode.Internal){
lReturn = PORT_BANNERDo.Update(pValues, pInfo);
}
else{
// Chamada do WebServices
}
return lReturn;
}
public static string GetLotacaoAcesso(string pSusr_id, ConnectionInfo pConnectionInfo)
{
string lQuery = "";
DataTable lTable;
lQuery = "SELECT COUNT(*) AS CONT FROM LOTACAO_USUARIO WHERE LOTUSU_SUSR = "******" AND LOTUSU_STATUS='A' ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pConnectionInfo));
return lTable.Rows[0]["CONT"].ToString();
}
public static DataTable GetOrdemBanner(ConnectionInfo pInfo, string pOrdem)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PORT_BANNERQD.qPORT_BANNERCount;
lQuery += " WHERE BAN_REGSTATUS ='A' AND BAN_ORDEM = " + pOrdem + " ORDER BY BAN_REGDATE ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllPORT_BANNER(ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PORT_BANNERQD.qPORT_BANNERList;
lQuery += " WHERE BAN_REGSTATUS ='A' ORDER BY BAN_ORDEM ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllPerfil(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaFuncaoQD.qPerfil;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllCORREGEDORIAIMG(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = CORREGEDORIAIMGQD.qCORREGEDORIAIMGList;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllSystemUser(ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = SystemUserQD.qSystemUserList;
lQuery += " WHERE SUSR_STATUS = 'A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}