Example #1
0
        public RExporterResult GetChartPDFTest(DataSet ds, string sChartName, int id_map)
        {
            RExporterResult result  = new RExporterResult();
            string          rowData = string.Format("{0}\\input.csv", Environment.CurrentDirectory);

            string sJPGPath        = string.Format("{0}\\chart.pdf", Environment.CurrentDirectory);
            string sTestDunnResult = string.Format("{0}\\dunnTest.txt", Environment.CurrentDirectory);
            string sTestKwResult   = string.Format("{0}\\KwTest.txt", Environment.CurrentDirectory);

            exportToCSV(ds, rowData);

            executeR(string.Format("{0}\\DunnTest.R", Environment.CurrentDirectory), rowData, sTestDunnResult);
            result.DunnTest = File.ReadAllLines(sTestDunnResult);

            executeR(@".\KwTest.R", rowData, sTestKwResult);
            result.KwTest = File.ReadAllLines(sTestKwResult);

            int    df = result.GetKwTestDF();
            double kw = result.GetKwchiSquared();

            string testResult = result.GetKwchiDescription(); //formatKwTest(df, kw);

            string sScriptFile = setChartExporter(id_map);

            executeR(sScriptFile, rowData, sJPGPath, sChartName, testResult);
            result.ChartPath = sJPGPath;

            return(result);
        }
Example #2
0
        private void ExportRobotDataPDF()
        {
            SQL.ConnectionString = @"data source=WR-7-BASE-74\SQLEXPRESS;initial catalog=DoktoratRobot;Integrated Security=SSPI;";

            MapItem[] mapList       = SQL.DataProviderExport.GetExportMapList();
            string    sTempInputDir = string.Format("{0}\\TempInput", Environment.CurrentDirectory);
            string    sOutputDir    = string.Format("{0}\\Output", Environment.CurrentDirectory);



            foreach (var map in mapList)
            {
                ConfigItem[]  itemConfigList = SQL.DataProviderExport.GetExportConfigList(map);
                DataSet       ds;
                List <string> pdfsFile = new List <string>();
                List <string> dunnTest = new List <string>();
                List <string> kwTest   = new List <string>();
                List <string> LatexImageDescriptions = new List <string>();

                StringBuilder sLatexFile = new StringBuilder();

                double[] prawodpodobienstwMinimalnea = new double[] { 0, 3.8415, 5.9915, 7.8147, 9.4877, 11.0705, 12.5916 };
                double   alfa            = 0.05;
                string   sCombineNamePDF = "Robots " + map.MapName + ".pdf";
                string   sCombineNameTex = "Robots " + map.MapName + ".tex";

                sCombineNamePDF = sCombineNamePDF.Replace(" ", "_"); //usuniecie spacje w nazwie pliku wynikowym pdf
                sCombineNameTex = sCombineNameTex.Replace(" ", "_"); //usuniecie spcaji w nazwie poliku wynikowego tex

                if (Directory.Exists(sTempInputDir))
                {
                    Directory.Delete(sTempInputDir, true);
                    Directory.CreateDirectory(sTempInputDir);
                }
                else
                {
                    Directory.CreateDirectory(sTempInputDir);
                }


                if (!Directory.Exists(sOutputDir))
                {
                    Directory.CreateDirectory(sOutputDir);
                }


                for (int i = 0; i < itemConfigList.Length; i++)
                {
                    string sOutputPdfFile          = string.Format("{0}\\{1}.pdf", sTempInputDir, i.ToString());
                    string sChartTitel             = string.Format("{0}", itemConfigList[i].Name); // ""; //Gdy zajedzie potrzeba to nadamy w tym mijscy nazwy wykresu
                    string sLatexImageDescriptions = string.Format("Eksperymenty Roboty: Mapa {0} Konfiguracja: {1}", map.MapName, itemConfigList[i].Name);

                    ds = SQL.DataProviderExport.GetExportResult(itemConfigList[i].ConfigID);

                    ds = removeUnnecessaryData(ds, map.ID_Map);

                    RExporter r = new RExporter();

                    RExporterResult chartAndTestResult = r.GetChartPDFTest(ds, sChartTitel, map.ID_Map);

                    RExporterResultItem[] testResult = chartAndTestResult.GetDunnTestResult();
                    SQL.DataProviderExport.InsertDunnStatistic(map, itemConfigList[i], testResult);

                    File.Move(chartAndTestResult.ChartPath, sOutputPdfFile);

                    pdfsFile.Add(sOutputPdfFile);

                    int    df = chartAndTestResult.GetKwTestDF();
                    double kw = chartAndTestResult.GetKwchiSquared();

                    string outLatex = formatLatexFile(sChartTitel, string.Format("06_experimental_results/robot/img/{0}", sCombineNamePDF), i, alfa, prawodpodobienstwMinimalnea[df], df, kw, map.MapName);
                    sLatexFile.Append(outLatex);
                }

                concatAndAddContent(pdfsFile, string.Format("{0}\\{1}", sOutputDir, sCombineNamePDF));
                File.AppendAllText(string.Format("{0}\\{1}", sOutputDir, sCombineNameTex), sLatexFile.ToString());
            }

            //  MessageBox.Show(this, "Excel file created , you can find the file");
        }