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 GetAllNOTICIAS( ConnectionInfo pInfo ) { string lQuery = ""; DataTable lTable = new DataTable(); lQuery = NOTICIASQD.qNOTICIASList; lQuery += " WHERE NOT_STATUS='A' AND NOT_TIPO=0 ORDER BY NOT_REGDATE DESC"; OracleDo lOracleDo = new OracleDo(); lTable = lOracleDo.Consulta(lQuery, pInfo.ConnectionString); return lTable; }
public static DataTable GetFun_SetByUsr_ID(ConnectionInfo pInfo, Decimal pSUSR_ID) { string lQuery = ""; DataTable lTable = new DataTable(); lQuery = SystemUserQD.qSystemUserList1; lQuery += @" WHERE A.PES_ID = B.PES_ID AND B.PES_ID = C.PES_ID AND C.PESF_STATUS = 'A' AND C.SET_ID = D.SET_ID and N.NUC_ID = D.NUC_ID AND C.FUNC_ID = E.FUNC_ID "; lQuery += String.Format(" AND A.SUSR_STATUS = 'A' AND A.SUSR_ID = {0}", pSUSR_ID); OracleDo lOracleDo = new OracleDo(); lTable = lOracleDo.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 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 GetNucleoByBairroCidadePessoaPreferencial129( decimal pPES_ID, ConnectionInfo pInfo ) { string lQuery = ""; DataTable lTable = new DataTable(); lQuery = string.Format(NucleoQD.qNucleoLocalidadePreferencial, pPES_ID); OracleDo lOra = new OracleDo(); lTable = lOra.Consulta(lQuery, pInfo.ConnectionString); return lTable; }
public static DataTable GetAtuacaoAtivaByPESF_ID( decimal pPESF_ID, ConnectionInfo pInfo ) { string lQuery = ""; DataTable lTable = new DataTable(); lQuery = AtuacaoQD.qAtuacaoPessoa; lQuery += string.Format(" AND ATUA.PESF_ID = {0} AND ATUA.ATUA_STATUS = 'A' ", pPESF_ID); OracleDo lOra = new OracleDo(); lTable = lOra.Consulta(lQuery, pInfo.ConnectionString); return lTable; }
public static DataTable GetNomeSetor( ConnectionInfo pInfo, String pSET_ID ) { string lQuery = ""; DataTable lTable = new DataTable(); lQuery = SETORQD.qNomeSetor; lQuery += @" WHERE SET_STATUS = 'A' AND SET_ID = " + pSET_ID; OracleDo lOracleDo = new OracleDo(); lTable = lOracleDo.Consulta(lQuery, pInfo.ConnectionString); return lTable; }
public static DataTable GetPessoaAtendimentoByCondicao( string pCondicao, ConnectionInfo pInfo ) { Select.AlterSessionBinary(pInfo); string lQuery = ""; DataTable lTable = new DataTable(); lQuery = PessoaQD.qPessoaAtendimentoList; lQuery += pCondicao; lQuery += " ORDER BY PES.PES_NOME"; //08/11/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 GetParentePessoaByID( decimal pPES_ID, ConnectionInfo pInfo ) { string lQuery = ""; DataTable lTable = new DataTable(); lQuery = string.Format(PessoaQD.qPessoaParente, pPES_ID); OracleDo lOra = new OracleDo(); lTable = lOra.Consulta(lQuery, pInfo.ConnectionString); return lTable; }