public static void RunQuery(
List <Tuple <string, string> > DBDescription,
string query,
DataBaseDelegateResults results)
{
Clear();
queryCount = DBDescription.Count;
for (int i = 0; i < queryCount; i++)
{
List <object> arguments = new List <object>();
arguments.Add(query);
arguments.Add(DBDescription[i].Item2);
arguments.Add(results);
arguments.Add(DBDescription[i].Item1);
backgroundWorkerRunQuery =
new BackgroundWorker();
backgroundWorkerRunQuery.DoWork +=
new DoWorkEventHandler(ThreadRunQuery_DoWork);
backgroundWorkerRunQuery.RunWorkerCompleted +=
new RunWorkerCompletedEventHandler(ThreadRunQuery_WorkerCompleted);
backgroundWorkerRunQuery.WorkerReportsProgress = true;
backgroundWorkerRunQuery.RunWorkerAsync(arguments);
}
}
private void Run(string text, DataBaseDelegateResults results, List <Tuple <string, string> > DBDescription)
{
RunQuery(
DBDescription,
text,
results
);
}
private void Run(string text, DataBaseDelegateResults results)
{
List <Tuple <string, string> > DBDescription =
GetConnectionStringFromCheckedBoxListDataBase();
Run(
text,
results,
DBDescription
);
}
//private static void ThreadRunQuery_WorkerCompletedToFile(object sender, RunWorkerCompletedEventArgs e)
//{
//}
private static void ThreadRunQuery_WorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (CheckWorkerCompleted(e))
{
List <object> results = e.Result as List <object>;
DataTable dataTable = results[1] as DataTable;
string log = results[0] as string;
string DBName = results[3] as string;
DataBaseDelegateResults SetResultsToPages =
results[2] as DataBaseDelegateResults;
SetResultsToPages(dataTable, log, DBName, "Current");
}
}
