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 GetDeterminacaoSecretariaByNUC_ID(
decimal pNUC_ID,
decimal pPESF_ID,
decimal pDTMSEC_SITUACAO,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DeterminacaoSecretariaQD.qDeterminacaoSecretariaList;
lQuery += string.Format(" WHERE DTMSEC_STATUS='A' AND {0} = >>{0}", DeterminacaoSecretariaQD._NUC_ID.Name);
if (pPESF_ID != 0)
lQuery += string.Format(" AND DTMSEC_PESF_PEDIDO = {0}", pPESF_ID);
if (pDTMSEC_SITUACAO != 0)
lQuery += string.Format(" AND DTMSEC_SITUACAO = {0}", pDTMSEC_SITUACAO);
lQuery += " ORDER BY DTMSEC_ID";
SelectCommand lSelect = new SelectCommand(lQuery);
lSelect.Fields.Add(DeterminacaoSecretariaQD._NUC_ID.Name, pNUC_ID, (ItemType)DeterminacaoSecretariaQD._NUC_ID.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static LoginUserDo VerifyLogin(string pEUSR, string pEusr_Password, string pEusr_Type, ConnectionInfo pConnectionInfo)
{
bool lReturn;
string lQuery;
DataTable lTable;
lQuery = UsersQD.qUsersList;
lTable = new DataTable();
if (pEusr_Type == "1")//Portal Garagem
{
lQuery += String.Format(" WHERE {0} = >>{0} AND {1} = >>{1} ", UsersQD._USR_LOGIN.Name, UsersQD._USR_PASSWORD.Name);
lQuery += " AND USR_STATUS='A' ";
SelectCommand lSelect = new SelectCommand(lQuery);
pEusr_Password = APB.Framework.Encryption.Crypto.Encode(pEusr_Password);
lSelect.Fields.Add(UsersQD._USR_LOGIN.Name, pEUSR, (ItemType)UsersQD._USR_LOGIN.DBType);
lSelect.Fields.Add(UsersQD._USR_PASSWORD.Name, pEusr_Password, (ItemType)UsersQD._USR_PASSWORD.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pConnectionInfo));
}
lReturn = (lTable.Rows.Count > 0) ? true : false;
// User Accept, Check TP_ID
if (lReturn)
{
return new LoginUserDo((decimal)lTable.Rows[0]["USR_ID"], (string)lTable.Rows[0]["USR_LOGIN"]);
}
return null;
}
public static DataTable AutenticacaoNpj(ConnectionInfo pConnectionInfo, string pSusr_Login, string pSusr_Senha)
{
DataTable lTable = new DataTable();
string lQuery = "";
pSusr_Senha = APB.Framework.Encryption.Crypto.Encode(pSusr_Senha);
lQuery = SystemUserQD.qAutenticacaoNpj;
lQuery += String.Format(" WHERE {0} = >>{0} AND {1} = >>{1} ", SystemUserQD._SUSR_LOGIN.Name, SystemUserQD._SUSR_PASSWORD.Name);
lQuery += " AND A.PES_ID = B.PES_ID ";
lQuery += " AND B.PES_ID = C.PES_ID ";
lQuery += " AND C.PESF_STATUS = 'A' ";
lQuery += " AND A.SUSR_STATUS = 'A' ";
lQuery += " AND C.SET_ID = D.SET_ID ";
lQuery += " AND N.NUC_ID = D.NUC_ID ";
lQuery += " AND N.NUC_ID = SN.NUC_ID ";
lQuery += " AND A.SUSR_ID = SN.SUSR_ID ";
lQuery += " AND C.FUNC_ID = E.FUNC_ID ";
SelectCommand lSelect = new SelectCommand(lQuery);
lSelect.Fields.Add(SystemUserQD._SUSR_LOGIN.Name, pSusr_Login, (ItemType)SystemUserQD._SUSR_LOGIN.DBType);
lSelect.Fields.Add(SystemUserQD._SUSR_PASSWORD.Name, pSusr_Senha, (ItemType)SystemUserQD._SUSR_PASSWORD.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pConnectionInfo));
return lTable;
}
public static DataTable GetCountProcessoTamitacaoPedente(
decimal pCategoria,
string pLoginName,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
if (pCategoria == (decimal)Categoria.Tramitação)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoProcesso;
else if (pCategoria == (decimal)Categoria.TramitaçãoPetição)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoPeticao;
else if (pCategoria == (decimal)Categoria.TramitaçãoProcessoExterno)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoProcessoExterno;
else if (pCategoria == (decimal)Categoria.TramitaçãoOfício)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoOficio;
lQuery += " AND DOC.DOC_REGUSER = '******' ";
lQuery += " AND DOCTRAM.nuc_dest_id is null ";
//SelectCommand lSelect = new SelectCommand(lQuery);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAllTipoPessoa(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaQD.qTipoPessoa;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllNucleoxLocalidade(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = NucleoxLocalidadeQD.qNucleoxLocalidadeList;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllSector(ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = sectorQD.qsectorList;
lQuery += " WHERE SECT_STATUS = 'A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllTable(ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable;
lQuery = InformationSchemaQd.qAllTables;
lQuery += " ORDER BY TABLE_NAME";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllColumn(string pTABLE_NAME, ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable;
lQuery = string.Format(InformationSchemaQd.qAllColumn, pTABLE_NAME);
lQuery += " ORDER BY COLUMN_NAME";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllRelatorioAtualizacao(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RelatorioAtualizacaoQD.qRelatorioAtualizacaoList;
lQuery += " WHERE RLT_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllDocumentoxAssuntoPsicossocial(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentoxAssuntoPsicossocialQD.qDocumentoxAssuntoPsicossocialList;
lQuery += " WHERE DOCASSPS_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetUsuariosAlunoNpj(ConnectionInfo pInfo, string pNucleo)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = ALUNOXATENDIMENTONPJQD.qUsuariosNpj;
lQuery += " WHERE UG.GRP_ID = 1";
lQuery += " ORDER BY PES.PES_NOME ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllDocumentosApresentados(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentosApresentadosQD.qDocumentosApresentadosList;
lQuery += " WHERE DOCAP_STATUS NOT IN ('I','E') ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllVisitasSocioEducativas(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = VisitasSocioEducativasQD.qVisitasSocioEducativasList;
lQuery += " WHERE VTSCE_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllEEProcedimento(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = EEProcedimentoQD.qEEProcedimentoList;
lQuery += " WHERE EEPCD_STATUS='A' ORDER BY EEPCD_DESCRICAO";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllDocumentoxEEDestino(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentoxEEDestinoQD.qDocumentoxEEDestinoList;
lQuery += " WHERE DOCEEDST_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllCalendarioJuridico(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = CalendarioJuridicoQD.qCalendarioJuridicoList;
lQuery += " WHERE CLDJ_STATUS='A' ORDER BY CLDJ_DIA";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllPessoa(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaQD.qPessoaList;
lQuery += " WHERE PES_STATUS NOT IN ('I','E')";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllTipoInteressado(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = TipoInteressadoQD.qTipoInteressadoList;
lQuery += " WHERE TINT_STATUS='A' ORDER BY TINT_ID";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllAudienciaFutura(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = AudienciaFuturaQD.qAudienciaFuturaList;
lQuery += " WHERE AUDF_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllSecurityObjects(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = SecurityObjectsQD.qSecurityObjectsList;
lQuery += " WHERE SO_STATUS='A' ORDER BY SO_OBJECTID";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllVara(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = VaraQD.qVaraList;
lQuery += " WHERE VAR_STATUS='A' ORDER BY VAR_DESC";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllUnidadeFederativa(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaQD.qUnidadeFederativa;
lQuery += " WHERE UF_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllUnidadeVaraInfracional(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = UnidadeVaraInfracionalQD.qUnidadeVaraInfracionalDescricao;
lQuery += " WHERE UVI_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllTipoOficio(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = TipoOficioQD.qTipoOficioList;
lQuery += " WHERE TPOFC_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllCasaPenal(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = CasaPenalQD.qCasaPenalList;
lQuery += " WHERE CSP_STATUS='A' ORDER BY CSP_DESCRICAO";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetTipoOficioModeloAll(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = TipoOficioQD.qTipoOficio;
lQuery += " WHERE TPOFC.TPOFC_STATUS='A' ORDER BY TPOFC.TPOFC_DESCRICAO";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllAssuntoProcessual(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = AssuntoProcessualQD.qAssuntoProcessualList;
lQuery += " WHERE ASSPRC_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
public static DataTable GetAllConciliacao(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = ConciliacaoQD.qConciliacaoList;
lQuery += " WHERE CONC_STATUS NOT IN ('I','E')";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}