/// <summary>
/// Наш MVVM Патерн
/// </summary>
/// <param name="detal"></param>
public DataDatalization(Detalizacia detal)
{
var logic = new Logica.Logica();
var contextlogic = new SobytieAndCommandContext.ContextCommand();
var sobytie = new SobytieAndCommandContext.SobytieReport();
var sobytiedbf = new SobytieAndCommandContext.SobytieDbfFile();
Service = new WpfBakcupStart.ContentBakcup.Service.VoidService();
Dialog = new VoidDialog(Service);
Years = new AddColection.AddColection().Years();
PanelUl = new SelectPanelUl();
PanelFl = new SelectPanelFl();
Trigers = new TrigersUse();
Tab = new TabControl();
IsSelectedFace = new DelegateCommand(() => Trigers.IsSelectFace());
ListFilesDbf = new ListFilesDbf();
ListReport = new AddColection.AddColection().Report();
Seath = new DelegateCommand(() => Dispatcher.CurrentDispatcher.Invoke(() => logic.Go(detal, Trigers, PanelUl, PanelFl, Years, ListFilesDbf, Tab, ListReport)));
RemoveReport = new DelegateCommand(() => contextlogic.RemoveReport(ListReport.Report, ListReport.ShemesFilesReport));
OpenReport = new DelegateCommand(() => contextlogic.OpenReport(ListReport.Report));
FileDropDrapReport = new DelegateCommand <object>(parameter => sobytie.MoveCopy(parameter, ListReport.Report));
FileOpenEvent = new DelegateCommand(() => sobytie.OpenReportEvent(ListReport.Report));
FileOpenDbf = new DelegateCommand((() => sobytiedbf.OpenDbfEvent(ListFilesDbf.FileDbf)));
FileDropDrapDbf = new DelegateCommand <object>(parameter => sobytiedbf.MoveCopyDbf(parameter, ListFilesDbf.FileDbf));
OpenDialogWcfBackup = new DelegateCommand <object>((parameter =>
{
Service.SelectDialog(Convert.ToString(parameter), Dialog);
}));
}
internal ObservableCollection <FileInfo[]> AddF(string inn, string god, Detalizacia detal)
{
var generatefile = new GenerateFindFile();
var seath = new SeathFile();
var tableFile = seath.SeathF(inn, god, detal);
return(generatefile.GeheratePath(tableFile, detal, god));
}
public void Go(Detalizacia detal, TrigersUse trigerselect, SelectPanelUl ul, SelectPanelFl fl, YearsDbf years, ListFilesDbf filedbf, Collections.ColectionTab.TabControl tab, ListFileReport report)
{
ReaderCommandDbfClient service = new ReaderCommandDbfClient("BasicHttpBinding_IReaderCommandDbf");
DispatcherHelper.Initialize();
Triger = trigerselect;
Ul = ul;
Fl = fl;
Yers = years;
Detal = detal;
ListFile = filedbf;
Report = report;
Tab = tab;
if (service.IsActive())
{
if (Yers.IsValidation())
{
if (Triger.IsCheked)
{
if (!Fl.IsValidation())
{
Triger.IsEnableButtonFl = false;
WorkerFl.WorkerReportsProgress = true;
WorkerFl.WorkerSupportsCancellation = true;
WorkerFl.DoWork += worker_DoworkFL;
WorkerFl.ProgressChanged += worker_progressChangeFL;
WorkerFl.RunWorkerCompleted += worker_RunWorkerCompleteFL;
WorkerFl.RunWorkerAsync();
}
}
else
{
if (!Ul.IsValidation())
{
Triger.IsEnableButtonUl = false;
WorkerUl.WorkerReportsProgress = true;
WorkerUl.WorkerSupportsCancellation = true;
WorkerUl.DoWork += worker_DoworkUL;
WorkerUl.ProgressChanged += worker_progressChangeUL;
WorkerUl.RunWorkerCompleted += worker_RunWorkerCompleteUL;
WorkerUl.RunWorkerAsync();
}
}
}
}
else
{
System.Windows.Forms.MessageBox.Show(
@"Ошибка сервис не может принять запрос в связи с резервным копированием");
}
}
/// <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);
}
/// <summary>
/// Запрос на выбор Физического лица по годам поступления
/// </summary>
/// <param name="sqlparam">Параметры используемые в выборке</param>
/// <param name="god">Год сведений</param>
/// <param name="detal">Форма для манипуляции с ней</param>
/// <returns>Возвращаем полученый ответ от Server</returns>
public DataSet ZaprosSql(List <string> sqlparam, string god, Detalizacia detal)
{
string sqlselect;
var q = new Qbe();
var goding = Convert.ToInt32(god);
switch (goding)
{
case 2012:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2012);
DataSet table2012 = q.Sqlfl(sqlselect, detal);
return(table2012);
case 2013:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2013);
DataSet table2013 = q.Sqlfl(sqlselect, detal);
return(table2013);
case 2014:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2014);
DataSet table2014 = q.Sqlfl(sqlselect, detal);
return(table2014);
case 2015:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2015);
DataSet table2015 = q.Sqlfl(sqlselect, detal);
return(table2015);
case 2016:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2016);
DataSet table2016 = q.Sqlfl(sqlselect, detal);
return(table2016);
case 2017:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2017);
DataSet table2017 = q.Sqlfl(sqlselect, detal);
return(table2017);
case 2018:
sqlselect = GenerateSqlZapros(sqlparam, SQLSvedFL2018);
DataSet table2018 = q.Sqlfl(sqlselect, detal);
return(table2018);
}
var tablezero = new DataSet();
return(tablezero);
}
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);
}
/// <summary>
/// Логика выбора года для выборки
/// </summary>
/// <param name="god">Сам год подачи файла выбирается пользователем</param>
/// <param name="sqlparam">Sql параметры запроса которые генерируются заранее</param>
/// <param name="detal">Прокидка формы для манипуляции с ней</param>
/// <returns>Возвращается таблица с данными для генерации путей к файлам</returns>
public DataSet Zaprosfilefl(string god, List <string> sqlparam, Detalizacia detal)
{
List <string> sqlselect = new List <string>();
var goding = Convert.ToInt32(god);
switch (goding)
{
case 2012:
DataSet table2012 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2012, sqlselect), detal);
return(table2012);
case 2013:
DataSet table2013 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2013, sqlselect), detal);
return(table2013);
case 2014:
DataSet table2014 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2014, sqlselect), detal);
return(table2014);
case 2015:
DataSet table2015 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2015, sqlselect), detal);
return(table2015);
case 2016:
DataSet table2016 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2016, sqlselect), detal);
return(table2016);
case 2017:
DataSet table2017 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2017, sqlselect), detal);
return(table2017);
case 2018:
DataSet table2018 = Sqlfl(GenerateSqlZapros(sqlparam, _fileDb2018, sqlselect), detal);
return(table2018);
default:
return(null);
}
}
public DataSet ZaprosSql(string inn, string god, Detalizacia detal)
{
var q = new Qbe();
var goding = Convert.ToInt32(god);
switch (goding)
{
case 2012:
DataSet table2012 = q.Sqlul(inn, goding, SqlQueriesUl2012, detal);
return(table2012);
case 2013:
DataSet table2013 = q.Sqlul(inn, goding, SqlQueriesUl2013, detal);
return(table2013);
case 2014:
DataSet table2014 = q.Sqlul(inn, goding, SqlQueriesUl2014, detal);
return(table2014);
case 2015:
DataSet table2015 = q.Sqlul(inn, goding, SqlQueriesUl2015, detal);
return(table2015);
case 2016:
DataSet table2016 = q.Sqlul(inn, goding, SqlQueriesUl2016, detal);
return(table2016);
case 2017:
DataSet table2017 = q.Sqlul(inn, goding, SqlQueriesUl2017, detal);
return(table2017);
case 2018:
DataSet table2018 = q.Sqlul(inn, goding, SqlQueriesUl2018, detal);
return(table2018);
}
var tablezero = new DataSet();
return(tablezero);
}
/// <summary>
/// Класс для раскладки таблиц и поиска файлов по следующим добавлением его ав переменную
/// </summary>
/// <param name="tablesql">Выборка SQL содержит путь и имена файлов</param>
/// <param name="detal">Наша основная WinForm для отражение в ней ошибок</param>
/// <param name="yers">Данная переменнная служит для генерации путей на MI файлы</param>
/// <returns>Возвращаем переменную ColectionFile</returns>
public ObservableCollection <FileInfo[]> GeheratePath(DataSet tablesql, Detalizacia detal, string yers)
{
foreach (DataTable table in tablesql.Tables)
{
if (table.Columns.Count == 2)
{
foreach (DataRow row in table.Rows)
{
AddFile(row.ItemArray[0].ToString().Trim(), row.ItemArray[1].ToString().Trim());
}
}
else
{
foreach (DataRow row in table.Rows)
{
AddFile(row.ItemArray[0].ToString().Trim(), row.ItemArray[1].ToString().Trim());
if (!string.IsNullOrWhiteSpace(row.ItemArray[2].ToString()))
{ //Надо попробовать раскладывать оринтируясь на ячейку t1.Автомат если 1 то dirresulauto если 0 то dirresul!!!!
DirectoryInfo dirresul = new DirectoryInfo(String.Format(Arhivator.Pathing.PathMiNdfl.PathResult, yers));
DirectoryInfo dirresulauto = new DirectoryInfo(String.Format(Arhivator.Pathing.PathMiNdfl.PathResultAuto, yers));
ColectionFile.Add(dirresul.GetFiles("*" + row.ItemArray[2].ToString().Trim() + "*", SearchOption.AllDirectories));
ColectionFile.Add(dirresulauto.GetFiles("*" + row.ItemArray[2].ToString().Trim() + "*", SearchOption.AllDirectories));
}
else
{
detal?.BeginInvoke(new MethodInvoker(delegate
{
detal.ErrorMI.Items.Add($@"На файл {row.ItemArray[1].ToString().Trim()} Отсутствует MI");
}));
}
}
}
}
var colectionfileinfo = new ObservableCollection <FileInfo[]>(ColectionFile.Where(filecolection => filecolection.Length != 0));
return(colectionfileinfo);
}
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;
}
}
internal ObservableCollection <FileInfo[]> AddF(string god, List <string> param, Detalizacia detal)
{
var generatefile = new GenareteFindFile.GenerateFindFile();
var seath = new ZaprosFileFl();
var tablefilefl = seath.Zaprosfilefl(god, param, detal);
return(generatefile.GeheratePath(tablefilefl, detal, god));
}
public SelectControlSqlZaprosUlOnFl(Detalizacia detal)
{
InitializeComponent();
DataContext = new DataDatalization(detal);
}
