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; }