示例#1
0
        private void GlobalClToolStripMenuItem_Click(object sender, EventArgs e)
        {
            MonoWindow form1 = new MonoWindow();

            form1.Show();
            Hide();
        }
示例#2
0
 public static void ShowMonoWindow()
 {
     if (monoWindow == null)
     {
         monoWindow = new MonoWindow();
         monoWindow.Show();
     }
     else
     {
         monoWindow.Show();
     }
 }
示例#3
0
        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();
        }