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