Esempio n. 1
0
        private void FrmDashbord_Load(object sender, EventArgs e)
        {
            ImplementeConnexion.Instance.Initialise();
            nbragent.Text         = pro.NbreEnregistrement("Agent", "count(Id)").ToString();
            NbrePatient.Text      = pro.NbreEnregistrement("Patient where id is not null", "count(Id)").ToString();
            NbreConsultation.Text = pro.NbreEnregistrement("Liste_consultation", "count(Id)").ToString();
            examine.Text          = pro.NbreEnregistrement("liste_Examen", "count(Id)").ToString();

            entree.Text     = pro.NbreEnregistrement("Appro_Medicament", "sum(Qte) ").ToString();
            sortie.Text     = pro.NbreEnregistrement("Liste_Consommation where id is not null", "sum(Qte)").ToString();
            stockDispo.Text = (int.Parse(entree.Text) - int.Parse(sortie.Text)).ToString();

            try
            {
                chart1.Series["Entree"].IsValueShownAsLabel = true;
                d.Graphique(chart1, "Entree", "select Qte from Appro_Medicament ", "Produit", "Qte");

                chart1.Series["Sortie"].IsValueShownAsLabel = true;
                d.Graphique(chart1, "Sortie", "select Qte from Liste_Consommation ", "Patient", "Qte");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }


            fx.Picture_Rond(pan1);
            fx.Picture_Rond(pan2);
            timer1.Start();
        }
Esempio n. 2
0
        private void FrmStatistique_Load(object sender, EventArgs e)
        {
            ImplementeConnexion.Instance.Initialise();
            nbragent.Text         = pro.NbreEnregistrement("Agent", "count(Id)").ToString();
            NbrePatient.Text      = pro.NbreEnregistrement("Patient where id is not null", "count(Id)").ToString();
            NbreConsultation.Text = pro.NbreEnregistrement("Liste_consultation", "count(Id)").ToString();
            examine.Text          = pro.NbreEnregistrement("liste_Examen", "count(Id)").ToString();

            entree.Text     = pro.NbreEnregistrement("Appro_Medicament ", "sum(Qte)").ToString();
            sortie.Text     = pro.NbreEnregistrement("Liste_Consommation where id is not null", "sum(Qte)").ToString();
            stockDispo.Text = (int.Parse(entree.Text) - int.Parse(sortie.Text)).ToString();

            mtEntree.Text = pro.Montant("Liste_Paiement where id is not null and Etat=1", "sum(isnull(Paye,0)) ").ToString();
            mtSortie.Text = pro.Montant("V_Depense where id is not null and Etat=1", "sum(isnull(Montant,0)) ").ToString();
            mtDispo.Text  = (decimal.Parse(mtEntree.Text) - decimal.Parse(mtSortie.Text)).ToString();
            try
            {
                chart1.Series["Entree"].IsValueShownAsLabel = true;
                d.Graphique(chart1, "Entree", "select Qte from Appro_Medicament ", "Produit", "Qte");

                chart1.Series["Sortie"].IsValueShownAsLabel = true;
                d.Graphique(chart1, "Sortie", "select Qte from Liste_Consommation ", "Patient", "Qte");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            timer1.Start();
        }