/// <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; } }