Пример #1
0
        public MainForm()
        {
            InitializeComponent();

            webserviceTimer          = new Timer();
            webserviceTimer.Interval = 5000;
            webserviceTimer.Tick    += WebserviceTimer_Tick;


            //Instantiation du formulaire enfant
            import = new ImportForm();
            //Définition en formulaire inclus
            import.TopLevel = false;
            //Agrandissement à la taille du panel conteneur
            import.Dock = DockStyle.Fill;
            //Ajout du formulaire au panel principal
            pnlMain.Controls.Add(import);

            synthesis          = new SynthesisForm();
            synthesis.TopLevel = false;
            synthesis.Dock     = DockStyle.Fill;
            pnlMain.Controls.Add(synthesis);

            data          = new DataForm();
            data.TopLevel = false;
            data.Dock     = DockStyle.Fill;
            pnlMain.Controls.Add(data);

            sensor          = new SensorForm();
            sensor.TopLevel = false;
            sensor.Dock     = DockStyle.Fill;
            pnlMain.Controls.Add(sensor);

            refreshSensorMain();

            dtpStart.Value = new DateTime(DateTime.Now.Year, 1, 1);
            dtpEnd.Value   = DateTime.Now.AddDays(1);

            HideForms();
            synthesis.Show();
            synthesis.DisplaySynthesis();
            synthesis.chTemp_Load();
        }
Пример #2
0
        public void ExportDataPDF(string filePath)
        {
            FileStream fs = new FileStream(filePath, FileMode.Create);
            // Create an instance of the document class which represents the PDF document itself.
            Document doc = new Document(PageSize.A4, 25, 25, 30, 30);
            // Create an instance to the PDF file by creating an instance of the PDF
            // Writer class using the document and the filestream in the constructor.
            PdfWriter writer = PdfWriter.GetInstance(doc, fs);


            // Open the document to enable you to write to the document
            doc.Open();
            // Add a simple and wellknown phrase to the document in a flow layout manner
            doc.Add(new Paragraph("Rapport de données relatives à un capteur"));
            doc.Add(new Paragraph("" + Environment.NewLine));


            Form          form      = this.ParentForm;
            MainForm      main      = (MainForm)form;
            SynthesisForm synthesis = main.getSynthesis();

            doc.Add(new Paragraph("Nom du capteur : " + main.getSynthesis().tfLabel.Text));
            doc.Add(new Paragraph("UID du capteur : " + main.getSynthesis().tfUID.Text));
            doc.Add(new Paragraph("Date et heure du premier relevé : " + main.getSynthesis().tfdtStart.Text));
            doc.Add(new Paragraph("Date et heure du dernier relevé : " + main.getSynthesis().tfdtEnd.Text));
            doc.Add(new Paragraph("Nombre de relevés : " + main.getSynthesis().tfNbr.Text));
            doc.Add(new Paragraph("Amplitude temporelle des relevés : " + main.getSynthesis().tfAmplitude.Text));
            doc.Add(new Paragraph("Température Minimum / Moyenne / Maximum : " + main.getSynthesis().mlMinTempData.Text + " / " +
                                  main.getSynthesis().mlMedTempData.Text + " / " +
                                  main.getSynthesis().mlMaxTempData.Text));
            doc.Add(new Paragraph("Humidité Minimum / Moyenne / Maximum : " + main.getSynthesis().mlMinHumidData.Text + " / " +
                                  main.getSynthesis().mlMedHumidData.Text + " / " +
                                  main.getSynthesis().mlMaxHumidData.Text));


            MemoryStream chTempHumidImageBuffer = synthesis.getCHTempHumidImageBuffer();

            iTextSharp.text.Image iImage = iTextSharp.text.Image.GetInstance(chTempHumidImageBuffer.ToArray());
            iImage.ScaleToFit(doc.PageSize);
            iImage.SetAbsolutePosition(0, 250);
            doc.Add(iImage);
            doc.NewPage();

            PdfPTable table = new PdfPTable(5);

            table.HorizontalAlignment = 0;
            //leave a gap before and after the table
            table.SpacingBefore = 20f;
            table.SpacingAfter  = 30f;

            PdfPCell cell0 = new PdfPCell(new Phrase("Rapport"));

            cell0.Colspan             = 5;
            cell0.Border              = 0;
            cell0.HorizontalAlignment = 1;
            table.AddCell(cell0);
            table.AddCell("Nom du capteur");
            table.AddCell("UID du capteur");
            table.AddCell("Date-heure du relevé");
            table.AddCell("Température");
            table.AddCell("Humidité");


            DateTime start       = main.GetStartDate();
            DateTime end         = main.GetEndDate();
            String   startString = start.ToString("yyyy-MM-dd HH:mm:ss");
            String   endString   = end.ToString("yyyy-MM-dd HH:mm:ss");
            String   idSensor    = main.getSensor();
            String   query;
            String   optionalClause = "WHERE 1 ";

            if (idSensor != "")
            {
                optionalClause = "WHERE sensor.id = " + idSensor + "  ";
            }

            query = "SELECT  sensor.*, data.*" +
                    "FROM sensor INNER JOIN data " +
                    "ON data.sensor = sensor.id " +
                    optionalClause + " " +
                    "AND (data_date BETWEEN '" + startString + "' AND '" + endString + "') " +
                    "ORDER BY sensor ASC, data_date ASC";

            List <Dictionary <String, String> > resultset = new List <Dictionary <string, string> >();

            try
            {
                resultset = DBInteractor.QuickSelect(query);
            }
            catch (Exception ex)
            {
                MessageBox.Show("ERREUR : Impossible de se connecter à la base de données...\n\r\n\r" +
                                ex.Message + "\n\r" + ex.StackTrace);
            }

            foreach (Dictionary <String, String> line in resultset)
            {
                table.AddCell(line["label"].ToString());
                table.AddCell(line["uid"].ToString());
                table.AddCell(line["data_date"].ToString());
                table.AddCell(line["temperature"].ToString());
                table.AddCell(line["humidity"].ToString());
            }

            doc.Add(table);

            // Close the document
            doc.Close();

            try
            {
                // Close the writer instance
                writer.Close();
                // Always close open filehandles explicity
                fs.Close();
                Thread.Sleep(1000);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Erreur à l'enregistrement: " + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }