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();
}
