/// <summary>
/// Собственно клас для запроса по файлам
/// </summary>
/// <param name="sqlselectall">Подаются все сгенерированые выборки</param>
/// <param name="detal">Наша форма для манипуляции</param>
/// <returns>Возвращаем данные для генерации путей к файлам</returns>
private DataSet Sqlfl(List <string> sqlselectall, Detalizacia detal)
{
var service = new ServiceTestIfns.ReaderCommandDbfClient("BasicHttpBinding_IReaderCommandDbf");
var table = new DataSet();
var i = 0;
foreach (string sqlselect in sqlselectall)
{
table.Tables.Add();
table = service.SqlFl(sqlselect, Arhivator.Pathing.ConnectString.Connection, table, i);
detal?.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarFl.Value += 10000; }));
i++;
}
detal?.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarFl.Value = 0; }));
return(table);
}
public DataSet Sqlul(string inn, int god, object[] qwering, Detalizacia detal)
{
var service = new ServiceTestIfns.ReaderCommandDbfClient("BasicHttpBinding_IReaderCommandDbf");
var table = new DataSet();
var i = 0;
var goding = Convert.ToString(god.ToString());
var proc = (100.0f / qwering.Count());
foreach (string sql in qwering)
{
table.Tables.Add();
table = service.SqlUl(inn, goding, sql, Arhivator.Pathing.ConnectString.Connection, table, i);
i++;
detal.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarUL.Value += ((int)(proc * 100.0f)); }));
}
detal.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarUL.Value = 0; }));
return(table);
}
public DataSet Sqlfl(string sqlSelect, Detalizacia detal)
{
var service = new ServiceTestIfns.ReaderCommandDbfClient("BasicHttpBinding_IReaderCommandDbf");
var table = new DataSet();
int i = 0;
string conect = Arhivator.Pathing.ConnectString.Connection;
try
{
table.Tables.Add();
table = service.SqlFl(sqlSelect, conect, table, i);
detal?.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarFl.Value += ((int)(10000)); }));
detal?.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarFl.Value = 0; }));
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
return(table);
}
internal DataSet SeathF(string inn, string god, Detalizacia detal)
{
try
{
var service = new ServiceTestIfns.ReaderCommandDbfClient("BasicHttpBinding_IReaderCommandDbf");
var table = new DataSet();
var i = 0;
var proc = (100.0f / FileDb.Count());
foreach (string sqlfile in FileDb)
{
table.Tables.Add();
table = service.SqlUl(inn, god, sqlfile, Arhivator.Pathing.ConnectString.Connection, table, i);
i++;
detal.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarUL.Value += ((int)(proc * 100.0f)); }));
}
detal.BeginInvoke(new MethodInvoker(delegate { detal.StatusBarUL.Value = 0; }));
return(table);
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
throw;
}
}