private void show_Graph_Dowork(object sender, DoWorkEventArgs e)
{
DataTable[] dataTables = new DataTable[6];
try
{
dataTables = DB_control.DB_Show_Graph(tb_StartDate.Text, tb_EndDate.Text);
this.Invoke((MethodInvoker) delegate()
{
graph_form = new Graph_Form(dataTables);
graph_form.Show();
});
for (int i = 0; i < 6; i++)
{
dataTables[i].Clear();
}
GC.Collect();
}
catch (Exception ex)
{
Log("[" + ex.ToString() + "]" + DateTime.Now);
}
this.Invoke((MethodInvoker) delegate()
{
loading_Form.Close();
});
}
private void DB_select_DoWork(object sender, DoWorkEventArgs e)
{
try
{
BackgroundWorker worker = sender as BackgroundWorker;
GlobalData.query_argument args = e.Argument as GlobalData.query_argument;
swatch.Start();
DataTable dt;
dt = DB_control.DB_SELECT(args);
swatch.Stop();
string query_speed = Math.Round(Convert.ToDouble(swatch.ElapsedMilliseconds / 1000), 2).ToString();
swatch.Reset();
swatch.Start();
dgv_selectData.Invoke((MethodInvoker) delegate()
{
dgv_selectData.DataSource = dt;
dgv_selectData.Columns[0].DefaultCellStyle.Format = "yyyy/MM/dd HH:mm:ss";
dgv_selectData.Update();
});
swatch.Stop();
string ui_speed = Math.Round(Convert.ToDouble(swatch.ElapsedMilliseconds / 1000), 2).ToString();
lb_Query_speed.Invoke((MethodInvoker) delegate()
{
lb_Query_speed.Text = query_speed + " s, " + ui_speed + " s "
+ dt.Rows.Count.ToString() + " 행";
});
swatch.Reset();
this.Invoke((MethodInvoker) delegate()
{
loading.Close();
});
GC.Collect();
}
catch (Exception ex)
{
Log("[" + ex.ToString() + "]" + DateTime.Now);
}
}