public static DataTable gridRequis(string _rh)
    {
        using (OdbcConnection cnn = new OdbcConnection(ConfigurationManager.ConnectionStrings["HospubConn"].ToString()))
        {
            OdbcCommand cmm = cnn.CreateCommand();
            cmm.CommandText = "select c27labanoped,c27labareped, c27labpriped, c27labseqped, d27labrequis, " +
                              " i27labcodesp, c27labconsul, " +
                              " ic0nome " +
                              " from lab27, intc0 " +
                              " where i27labcpfmed = ic0cpf" +
                              " and i27labregist = " + _rh +
                              " order by d27labrequis desc";
            cnn.Open();
            OdbcDataReader dr1 = cmm.ExecuteReader();
            DataTable      dt  = new DataTable();
            dt.Columns.Add("Requisição", System.Type.GetType("System.String"));
            dt.Columns.Add("Data Cadastro", System.Type.GetType("System.String"));
            dt.Columns.Add("Consulta", System.Type.GetType("System.String"));
            dt.Columns.Add("Especialidade", System.Type.GetType("System.String"));
            dt.Columns.Add("Profissional", System.Type.GetType("System.String"));
            int count = 0;

            while (dr1.Read() && count <= 5)
            {
                string requis       = dr1.GetString(0) + dr1.GetString(1) + dr1.GetString(2) + dr1.GetString(3);
                string dtRequis     = calcidade.DataFormatada(dr1.GetString(4));
                string espec        = Especialidade.getespec(dr1.GetString(5));
                string consulta     = dr1.GetString(6);
                string profissional = dr1.GetString(7);
                dt.Rows.Add(new String[] { requis, dtRequis, consulta, espec, profissional });
                count++;
            }
            return(dt);
        }
    }
Esempio n. 2
0
    //Carrega agenda dp Paciente
    public static DataTable gridCarregaAgenda(string _rh)
    {
        using (OdbcConnection cnn = new OdbcConnection(ConfigurationManager.ConnectionStrings["HospubConn"].ToString()))
        {
            OdbcCommand cmm = cnn.CreateCommand();
            cmm.CommandText = "select am1106,am1101a, am1101b, am1101c, am1104, am1103 from am11 where am1110 = 1 and am1108 = " + _rh + " Order By am1106";
            cnn.Open();
            OdbcDataReader dr1 = cmm.ExecuteReader();
            DataTable      dt  = new DataTable();

            dt.Columns.Add("Data", System.Type.GetType("System.String"));
            dt.Columns.Add("Consulta", System.Type.GetType("System.String"));
            dt.Columns.Add("Especialidade", System.Type.GetType("System.String"));
            dt.Columns.Add("Profissional", System.Type.GetType("System.String"));

            while (dr1.Read())
            {
                string data = dr1.GetString(0);
                int    ano  = Convert.ToInt32(data.Substring(0, 4));
                int    mes  = Convert.ToInt32(data.Substring(4, 2));
                int    dia  = Convert.ToInt32(data.Substring(6, 2));
                data = dia + "/" + mes + "/" + ano;

                string consulta = /* dr1.GetString(1) + */ dr1.GetString(2) + dr1.GetString(3);
                string espec    = dr1.GetString(4);
                espec = Especialidade.getespec(espec);
                string profissional = Profissional.getNome(dr1.GetString(5));

                dt.Rows.Add(new String[] { data, consulta, espec, profissional });
            }
            return(dt);
        }
    }
    //Carrega agenda Demanda Paciente
    public static DataTable gridCarregaAgendaDemanda(string _rh)
    {
        string dtAtual = DateTime.Now.ToString("yyyyMMdd");

        using (OdbcConnection cnn = new OdbcConnection(ConfigurationManager.ConnectionStrings["HospubConn"].ToString()))
        {
            OdbcCommand cmm = cnn.CreateCommand();
            cmm.CommandText = "select am5605,am5602, am5608b, am5608c from am56 where am5613 = 1 and am5605 >= '" + dtAtual + "' and am5604 = " + _rh + " order By am5605 desc ";
            cnn.Open();
            OdbcDataReader dr1 = cmm.ExecuteReader();
            DataTable      dt  = new DataTable();

            dt.Columns.Add("Data", System.Type.GetType("System.String"));
            dt.Columns.Add("Consulta", System.Type.GetType("System.String"));
            dt.Columns.Add("Especialidade", System.Type.GetType("System.String"));
            //dt.Columns.Add("Status", System.Type.GetType("System.String"));

            while (dr1.Read())
            {
                string data = calcidade.DataFormatada(dr1.GetString(0));

                string espec  = dr1.GetString(1);
                string consul = dr1.GetString(2) + dr1.GetString(3);
                //string status = dr1.GetString(4);

                espec = Especialidade.getespec(espec);

                dt.Rows.Add(new String[] { data, consul, espec });
            }
            return(dt);
        }
    }
    // Carrega consultas realizadas nos últimos 6 meses
    public static DataTable gridCarregaAgendaPass(string _rh)
    {
        string sangue = "";
        string urina  = "";
        string fezes  = "";
        string rx     = "";
        string ecg    = "";
        string outros = "";

        using (OdbcConnection cnn = new OdbcConnection(ConfigurationManager.ConnectionStrings["HospubConn"].ToString()))
        {
            string dataPass = "";
            int    dtAtual  = Convert.ToInt32(DateTime.Now.ToString("yyyyMM"));
            int    dtAno    = Convert.ToInt32(DateTime.Now.ToString("yyyy"));
            int    dtMes    = Convert.ToInt32(DateTime.Now.ToString("MM"));
            if (dtMes <= 6)
            {
                dtMes = dtMes + 6;
                dtAno = dtAno - 1;

                if (dtMes <= 3)
                {
                    dataPass = Convert.ToString(dtAno) + "0" + Convert.ToString(dtMes);
                }
                else
                {
                    dataPass = Convert.ToString(dtAno) + Convert.ToString(dtMes);
                }
            }
            else
            {
                dtMes    = dtMes - 6;
                dataPass = Convert.ToString(dtAno) + "0" + Convert.ToString(dtMes);
            }


            OdbcCommand cmm = cnn.CreateCommand();
            //cmm.CommandText = "select am12121, am1212a, am1201a, am1201b, am1201c, am1204, am1203,am1210, am1208 from am12 where am12121 in(" + dataPass + "," + dtAtual + ")  and am1206 = " + _rh + " Order By am12121 desc";
            cmm.CommandText = "select am12121, am1212a, am1201a, am1201b, am1201c, am1204, " +
                              " am1203,am1210, am1208 from am12 where am1206 = " + _rh + " Order By am12121 desc";
            cnn.Open();
            OdbcDataReader dr1 = cmm.ExecuteReader();
            DataTable      dt  = new DataTable();

            dt.Columns.Add("Data", System.Type.GetType("System.String"));
            dt.Columns.Add("Consulta", System.Type.GetType("System.String"));
            dt.Columns.Add("Especialidade", System.Type.GetType("System.String"));
            dt.Columns.Add("Profissional", System.Type.GetType("System.String"));
            dt.Columns.Add("Saída", System.Type.GetType("System.String"));
            dt.Columns.Add("Recursos", System.Type.GetType("System.String"));
            dt.Columns.Add("Requisição", System.Type.GetType("System.String"));

            int count = 0;

            while (dr1.Read() && count <= 6)
            {
                string data = dr1.GetString(0);
                string ano  = data.Substring(0, 4);
                string mes  = data.Substring(4, 2);
                string dia  = dr1.GetString(1).TrimEnd('.');
                data = dia + "/" + mes + "/" + ano;

                string consulta   = dr1.GetString(2) + dr1.GetString(3) + dr1.GetString(4);
                string requisicao = ExmLab.getRequis(consulta);

                string espec = dr1.GetString(5);
                espec = Especialidade.getespec(espec);
                string profissional = Profissional.getNome(dr1.GetString(6));
                string saida        = dr1.GetString(7).TrimEnd('.');
                if (saida.Equals("0"))
                {
                    saida = "Faltou";
                }
                else if (saida.Equals("1"))
                {
                    saida = "Alta";
                }
                else if (saida.Equals("4"))
                {
                    saida = "Encam. Interno";
                }
                else if (saida.Equals("5"))
                {
                    saida = "Outros";
                }
                else if (saida.Equals("6"))
                {
                    saida = "Ret. Obrigatório";
                }
                else if (saida.Equals("7"))
                {
                    saida = "Retorno";
                }
                string recursos = dr1.GetString(8);
                if (recursos != "")
                {
                    sangue = recursos.Substring(1, 1);
                    if (sangue.Equals("1"))
                    {
                        sangue = "Sangue";
                    }
                    else
                    {
                        sangue = "";
                    }
                    urina = recursos.Substring(2, 1);
                    if (urina.Equals("1"))
                    {
                        urina = "Urina";
                    }
                    else
                    {
                        urina = "";
                    }
                    fezes = recursos.Substring(4, 1);
                    if (fezes.Equals("1"))
                    {
                        fezes = "Fezes";
                    }
                    else
                    {
                        fezes = "";
                    }
                    outros = recursos.Substring(9, 1);
                    if (outros.Equals("1"))
                    {
                        outros = "Outros";
                    }
                    else
                    {
                        outros = "";
                    }
                    ecg = recursos.Substring(10, 1);
                    if (ecg.Equals("1"))
                    {
                        ecg = "ECG";
                    }
                    else
                    {
                        ecg = "";
                    }
                    rx = recursos.Substring(8, 1);
                    if (rx.Equals("1"))
                    {
                        rx = "Raio-X";
                    }
                    else
                    {
                        rx = "";
                    }
                }
                recursos = sangue + " " + urina + " " + fezes + " " + outros + " " + ecg + " " + rx;
                recursos = recursos.TrimStart();
                recursos = recursos.TrimEnd();
                dt.Rows.Add(new String[] { data, consulta, espec, profissional, saida, recursos, requisicao });
                count++;
            }
            return(dt);
        }
    }