protected override void Start() { string dat = SearthCellFromMark("Выгрузка от:", false).StringCellValue; YM = (int)MyTools.StringDATE_In_intDate(dat.Substring(dat.IndexOf(':') + 1), MyTools.EInputDate.YM, MyTools.EInputDate.YM); TextBlock text = new TextBlock(); text.Background = Brushes.LightCoral; text.FontSize = 20; text.Text = dat; wpText.Children.Add(text); shows = new List <show>(); progressOpenFile openFile = new progressOpenFile(sheet.LastRowNum - StartRow, new Func <int, bool>( RowIndex => { IRow row = sheet.GetRow(RowIndex); int select = 0; Dictionary <string, decimal> value = new Dictionary <string, decimal>(); foreach (var one in ColumnsBook) { if (one.Key == col.select) { select = row.GetCell(one.Value).ToString().TryParseInt(); } else { if (one.Value > 0 && row.GetCell(one.Value).ToString() != "0") { value.Add(one.Key, row.GetCell(one.Value).ToString().TryParseDecimal()); } } } if (select != 0) { shows.Add(new show(select, value)); } return(true); })); _progress = new Progress_Form(openFile); _progress.ShowDialog(); DG.ItemsSource = shows; }
protected override void Start() { string dat = SearthCellFromMark("Дата начала: ", false).StringCellValue; YM = (int)MyTools.StringDATE_In_intDate(dat.Substring(dat.IndexOf(':') + 1), MyTools.EInputDate.YMDHMS, MyTools.EInputDate.YM); LoadSelection(); shows = new List <show>(); progressOpenFile openFile = new progressOpenFile(sheet.LastRowNum - StartRow, new Func <int, bool>( RowIndex => { IRow row = sheet.GetRow(RowIndex); calc[] _calc = null; Dictionary <string, object> value = new Dictionary <string, object>(); foreach (var one in ColumnsBook) { string val = row.GetCell(one.Value).ToString(); if (one.Key == col.ls) { if (!val.Contains('\'')) { throw new Exception($"Колонка {col.ls} не содержит символ: \'"); } val = val.Replace("\'", ""); _calc = calcs.Where(x => x.objecte.Accounts.Contains(val)).ToArray(); } if (_calc.Length == 0 && one.Key == col.inn) { _calc = calcs.Select(x => new { client = x.client, calc = x }).Where(x => x.client.INN == val).Select(x => x.calc).ToArray(); } value.Add(one.Key, val); } shows.Add(new show(_calc, value)); return(true); })); _progress = new Progress_Form(openFile); _progress.ShowDialog(); DG.ItemsSource = shows; }