private void GlobalClToolStripMenuItem_Click(object sender, EventArgs e) { MonoWindow form1 = new MonoWindow(); form1.Show(); Hide(); }
public static void ShowMonoWindow() { if (monoWindow == null) { monoWindow = new MonoWindow(); monoWindow.Show(); } else { monoWindow.Show(); } }
public void GlobalCucl(string pathGlobal, string columnName, string path) { pathGlobal = TextPath.abc; DataTable dt = new DataTable(); DataTable dtGlobal = new DataTable(); string stringcoonGlobal = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pathGlobal + ";" + "Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1;'"; OleDbConnection connGlobal = new OleDbConnection(stringcoonGlobal); string stringcoon = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + TextPath.path + ";" + "Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1;'"; OleDbConnection conn = new OleDbConnection(stringcoon); if (TextPath.SexCheck == false) { OleDbDataAdapter daGlobal = new OleDbDataAdapter("Select АТС0, АТД0, ЧСС0, АТС1, АТД1, ЧСС1, АТС2, АТД2, ЧСС2, АТС3, АТД3, ЧСС3, АТС4, АТД4, ЧСС4, АТС5, АТД5, ЧСС5 from [Жінки$] ", connGlobal); daGlobal.Fill(dtGlobal); OleDbDataAdapter da = new OleDbDataAdapter("Select " + TextPath.ClWoman + " from [" + rbtnWoman.Text + "$]", conn); da.Fill(dt); } else if (TextPath.SexCheck == true) { OleDbDataAdapter daGlobal = new OleDbDataAdapter("Select АТС0, АТД0, ЧСС0, АТС1, АТД1, ЧСС1, АТС2, АТД2, ЧСС2, АТС3, АТД3, ЧСС3, АТС4, АТД4, ЧСС4, АТС5, АТД5, ЧСС5 from [Чоловіки$]", connGlobal); daGlobal.Fill(dtGlobal); OleDbDataAdapter da = new OleDbDataAdapter("Select " + TextPath.ClMan + " from [" + rbtnMan.Text + "$]", conn); da.Fill(dt); } for (int k = 0; k < dtGlobal.Rows.Count; k++) { double min = 0; double nextMin = 0; List <double> SummClasters; MonoWindow form1 = new MonoWindow(); form1.EuclidSquare(k, dt, dtGlobal, out min, out nextMin, out SummClasters); int Cl = 0; double Dist = 0; int NextCl = 0; double NextDist = 0; for (int i = 0; i < SummClasters.Count; i++) { if (min == SummClasters[i]) { switch (i) { case 0: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 1: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 2: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 3: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 4: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 5: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 6: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; case 7: Cl = (i + 1); Dist = Math.Round(SummClasters[i], 2); break; } } } for (int i = 0; i < SummClasters.Count; i++) { if (nextMin == SummClasters[i]) { switch (i) { case 0: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 1: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 2: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 3: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 4: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 5: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 6: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; case 7: NextCl = (i + 1); NextDist = Math.Round(SummClasters[i], 2); break; } } } Instert(pathGlobal, (Cl), (Dist), (NextCl), (NextDist), columnName); } // conn.Close(); //Workbook workbook = new Workbook(); //Console.WriteLine(TextPath.abc); //workbook.LoadFromFile(TextPath.abc); //workbook.Save(); }