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 GetNucleoByBairroCidadePessoa129(
decimal pPES_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = string.Format(NucleoQD.qNucleoLocalidade129, pPES_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetVisitasSocioEducativasByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = VisitasSocioEducativasQD.qVisitasSocioEducativasList;
lQuery += string.Format(" AND VTSCE.VTSCE_STATUS='A' AND VTSCE.DOC_ID = {0}", pDOC_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetUnidadeVaraInfracionalByID(
decimal pUVI_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = UnidadeVaraInfracionalQD.qUnidadeVaraInfracionalList;
lQuery += string.Format(" WHERE UVI_STATUS='A' and UVI_ID = {0}", pUVI_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAtendimentoByID(
decimal pATES_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = AtendimentoEstatisticoQD.qAllAtendimentoEstatistico;
lQuery += string.Format(" AND ATES.ATES_ID = {0} ", pATES_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAnexoItemRegistroMensalByIRMA_ID(
decimal pIRMA_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = AnexoItemRegistroMensalQD.qAnexoItemRegistroMensalList;
lQuery += string.Format(" WHERE ANXIRMA_STATUS = 'A' AND IRMA_ID = {0}", pIRMA_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAgendamentoProcessoByCondicao(
string pCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RelatoriosQd.qAgendamentoAtendimentoProcesso;
lQuery += pCondicao;
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetHistoricoViolenciaByPessoa(
decimal pPES_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = HistoricoViolenciaQD.qHistoricoViolenciaList;
lQuery += string.Format(" WHERE HISTVIO_STATUS='A' AND PES_ID = {0}", pPES_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetVisitasAcolhimentoByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = VisitasAcolhimentoQD.qVisitasAcolhimentoList;
lQuery += string.Format(" AND VTACO.VTACO_STATUS='A' AND VTACO.DOC_ID = {0}", pDOC_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetSituacaoEscolarByPessoa(
decimal pPES_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = SituacaoEscolarQD.qSituacaoEscolarList;
lQuery += string.Format(" WHERE STESC_STATUS='A' AND PES_ID = {0}", pPES_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetTextoOficioByID(
decimal pOFC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = string.Format(OficioQD.qLoadOficio, pOFC_ID);
//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 GetDocumentoAnexoByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = string.Format(DocumentoAnexoQD.qDocumentoAnexosAndDocumentosAnexadosToMe, pDOC_ID);
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(DocumentoAnexoQD._DOC_ID.Name, pDOC_ID, (ItemType)DocumentoAnexoQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAgendamentoByCondicao(
string pCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RelatoriosQd.qAgendamentoAtendimento;
lQuery += pCondicao;
//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 GetItensByTipoSeq(
decimal pTRM_ID,
decimal pIRM_ID,
decimal pTRMIRM_SEQ,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = TrmxIrmQD.qListTrmxIrm;
lQuery += " WHERE TRMIRM_STATUS='A'";
lQuery += string.Format(" AND TRM_ID = {0} AND IRM_ID != {1} AND TRMIRM_SEQ = {2}", pTRM_ID, pIRM_ID, pTRMIRM_SEQ);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery,pInfo.ConnectionString);
return lTable;
}
public static DataTable GetOficioListByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = OficioQD.qOficioDocumentoList;
lQuery += string.Format(" AND OFC.DOC_ID = {0}", pDOC_ID);
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(OficioQD._DOC_ID.Name, pDOC_ID, (ItemType)OficioQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAgendamentoByCondicao(
string pCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = AtendimentoEstatisticoQD.qAllAtendimentoEstatistico;
lQuery += pCondicao;
lQuery += " ORDER BY ATES.ATES_HORA, ATES.ATES_ID";
//13/11/2012 - Ricardo Almeida
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetProcessoExternoByCondicao(
string lCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentoAnexoQD.qDocumentoAnexoProcessoExterno;
lQuery += lCondicao;
//04/12/2012 - Ricardo Almeida
//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 GetDocumentoxClasseByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentoxClasseQD.qDocumentoxClasseList;
lQuery += string.Format(" WHERE DOCCLS_STATUS NOT IN ('I','E') AND DOC_ID = {0}", pDOC_ID);
lQuery += " ORDER BY DOCCLS_ID";
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(DocumentoxClasseQD._DOC_ID.Name, pDOC_ID, (ItemType)DocumentoxClasseQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetDeterminacaoSecretariaByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DeterminacaoSecretariaQD.qDeterminacaoSecretaria;
lQuery += string.Format(" WHERE DTMSEC_STATUS='A' AND DOC_ID = {0}", pDOC_ID);
lQuery += " ORDER BY DTMSEC_ID";
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(DeterminacaoSecretariaQD._DOC_ID.Name, pDOC_ID, (ItemType)DeterminacaoSecretariaQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetRegistroMensalAtividadeByDefensorCompetencia(
decimal pPESF_ID,
string pRMA_COMPETENCIA,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RegistroMensalAtividadeQD.qRegistroMensalAtividadeList;
lQuery += string.Format(" AND PESF.PESF_ID = {0} ", pPESF_ID);
if(pRMA_COMPETENCIA != "")
lQuery += string.Format(" AND RMA.RMA_COMPETENCIA = '{0}' ", pRMA_COMPETENCIA);
lQuery += "ORDER BY RMA.RMA_COMPETENCIA, RMA.RMA_ID";
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetVaraByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
Select.AlterSessionBinary(pInfo);
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = VaraQD.qVaraDocumento;
lQuery += string.Format(" AND DOC.DOC_ID = {0}", pDOC_ID);
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(DocumentoQD._DOC_ID.Name, pDOC_ID, (ItemType)DocumentoQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAudienciaByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = AudienciaQD.qAudienciaList;
lQuery += " WHERE AUD_STATUS='A'";
lQuery += string.Format(" AND DOC_ID = {0}", pDOC_ID);
lQuery += " ORDER BY AUD_ID";
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(AudienciaQD._DOC_ID.Name, pDOC_ID, (ItemType)AudienciaQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetEscalaByNucleoDia(
decimal pNUC_ID,
string pESC_DIA,
decimal pARATUA_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = EscalaQD.qEscalaAll;
lQuery += string.Format(" AND ESC.ESC_DIA = '{0}'", pESC_DIA);
lQuery += string.Format(" AND NUCARATUA.NUC_ID = {0}", pNUC_ID);
lQuery += string.Format(" AND NUCARATUA.ARATUA_ID = {0}", pARATUA_ID);
lQuery += " ORDER BY PES.PES_NOME";
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(EscalaQD._ESC_DIA.Name, pESC_DIA, (ItemType)EscalaQD._ESC_DIA.DBType);
//lSelect.Fields.Add(NucleoxAreaAtuacaoQD._NUC_ID.Name, pNUC_ID, (ItemType)NucleoxAreaAtuacaoQD._NUC_ID.DBType);
//lSelect.Fields.Add(NucleoxAreaAtuacaoQD._ARATUA_ID.Name, pARATUA_ID, (ItemType)NucleoxAreaAtuacaoQD._ARATUA_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAudienciasFuturasByNUC_ID(
string pCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RelatoriosQd.qAudienciasFuturas;
lQuery += pCondicao;
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetAtendimentoEstatisticoQuantitativoByCondicao(
string pCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = string.Format(RelatoriosQd.qAtendimentoEstatisticoQuantitativo, pCondicao);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetPessoaFuncaoServidorByCondicao(
string lCondicao,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaFuncaoQD.qPessoaFuncaoServidores;
lQuery += lCondicao;
lQuery += " ORDER BY PES.PES_NOME";
//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 GetSequenciaEscalaAtendimentoByNucleoAreaData(
decimal pNUC_ID,
decimal pATUA_ID,
string pData,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = EscalaQD.qEscalaDefensor;
lQuery += string.Format(" AND NUCARATUA.NUC_ID = {0} AND ESC.ESC_DIA = '{1}'", pNUC_ID, pData);
lQuery += string.Format(@" AND NUCARATUA.ARATUA_ID = (SELECT NA.ARATUA_ID FROM NUCLEOXAREAATUACAO NA, ATUACAO ATU
WHERE NA.NUCARATUA_ID = ATU.NUCARATUA_ID
AND NA.NUCARATUA_STATUS = 'A'
AND ATU.ATUA_ID = {0})", pATUA_ID);
lQuery += " ORDER BY ESC.ESC_SEQUENCIA";
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetSituacaoFamiliarResideBySTFAM_ID(
decimal pSTFAM_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = SituacaoFamiliarResideQD.qSituacaoFamiliarResideList;
lQuery += string.Format(" WHERE STFRES_STATUS='A' AND STFAM_ID = {0}", pSTFAM_ID);
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetInteressadoByDOC(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = InteressadoQD.qInteressadoAllTab;
lQuery += string.Format(" AND INTE.DOC_ID = {0} ORDER BY TINT.TINT_DESCRICAO, INTE.INTE_ID ", pDOC_ID);
//SelectCommand lSelect = new SelectCommand(lQuery);
//lSelect.Fields.Add(InteressadoQD._DOC_ID.Name, pDOC_ID, (ItemType)InteressadoQD._DOC_ID.DBType);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
public static DataTable GetProcessoExternoByDOC_ID(
decimal pDOC_ID,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = string.Format(DocumentoAnexoQD.qProcessoExterno, pDOC_ID);
//04/12/2012 - Ricardo Almeida
//SelectCommand lSelect = new SelectCommand(lQuery);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}