using COP; using COP.Enums; using COP.Info; using DocumentFormat.OpenXml.EMMA; using System.ComponentModel; using System.Linq.Expressions; using static COP.ExcelComponent; namespace TestComponents { public partial class FormTestComponents : Form { public FormTestComponents() { InitializeComponent(); Fill(); } private void Fill() { List items = new() { "Item 1", "Item 2", "Item 3", "Item 4", "Item 5" }; userCheckedListBox.FillList(items); } private void UserCheckedListBox_SelectedValueChanged(object sender, EventArgs e) { MessageBox.Show("Selected value changed"); } private void ButtonClear_Click(object sender, EventArgs e) { userCheckedListBox.ClearList(); } private void ButtonShowItems_Click(object sender, EventArgs e) { textBoxItems.Clear(); textBoxItems.Text = userCheckedListBox.SelectedValue; } private void ButtonShowDate_Click(object sender, EventArgs e) { try { textBoxShowDate.Clear(); textBoxShowDate.Text = userDateTimePicker.SelectedValue.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void UserDateTimePicker_ValueChanged(object sender, EventArgs e) { MessageBox.Show("Value changed"); DateTime? selectedDate = userDateTimePicker.SelectedValue; } private void UserTreeView_Load(object sender, EventArgs e) { List employees = new() { new Employee1 { Department = "Отдел1", Position = "Должность1", Name = "Сотрудник1" }, new Employee1 { Department = "Отдел2", Position = "Должность2", Name = "Сотрудник2" }, new Employee1 { Department = "Отдел1", Position = "Должность1", Name = "Сотрудник3" }, new Employee1 { Department = "Отдел2", Position = "Должность3", Name = "Сотрудник4" }, }; var Hierarchy = new List { "Department", "Name" }; foreach (var prop in employees[0].GetType().GetProperties()) { userTreeView.Hierarchy.Add(prop.Name); } try { userTreeView.PopulateTree(employees, Hierarchy); } catch (Exception ex) { MessageBox.Show(ex.Message); } } public class Employee1 { public string? Department { get; set; } public string? Position { get; set; } public string? Name { get; set; } } private void buttonSaveToExcel_Click(object sender, EventArgs e) { ExcelComponent excel = new(); List images = new() { new ImageInfo() { FilePath = "C:\\Users\\User\\Documents\\image1.jpg" }, new ImageInfo() { FilePath = "C:\\Users\\User\\Documents\\image2.jpg" }, new ImageInfo() { FilePath = "C:\\Users\\User\\Documents\\image3.jpg" } }; ExcelImageInfo info = new("C:\\Users\\User\\Documents\\test.xlsx", "My Document", images); try { excel.GenerateExcelWithImages(info); MessageBox.Show("Сохарнено успешно", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void buttonSaveTable_Click(object sender, EventArgs e) { ExcelTable table = new(); var data = new List { new Employee { Id = 1, Status = "Active", Name = "John", Surname = "Doe", Age = "30", Department = "IT", Position = "Manager" }, new Employee { Id = 2, Status = "Active", Name = "Jane", Surname = "Smith", Age = "35", Department = "Design", Position = "Senior" }, }; Dictionary, List), List)> headers = new() { { "Идентификатор", ((new List { "Id" }, new List {"Идентификатор"} ), new List { 30 } )}, { "Личные данные", ((new List { "Name", "Surname", "Age" }, new List { "Имя", "Фамилия", "Возраст" }), new List { 25, 25, 25 }) }, { "Статус", ((new List { "Status" }, new List { "Статус"}), new List { 30 } )}, { "Работа", ((new List < string > { "Department", "Position" } , new List < string > { "Отдел", "Должность" }), new List { 25, 25 } )} }; ExcelTableInfo info = new("C:\\Users\\User\\Documents\\testtable.xlsx", "My Document", data, headers); try { table.GenerateDocument(info); MessageBox.Show("Сохарнено успешно", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } public class Employee { public int? Id { get; set; } public string? Status { get; set; } = string.Empty; public string? Name { get; set; } = string.Empty; public string? Surname { get; set; } = string.Empty; public string? Age { get; set; } = string.Empty; public string? Department { get; set; } = string.Empty; public string? Position { get; set; } = string.Empty; } private void buttonSaveChart_Click(object sender, EventArgs e) { PieChart chart = new(); LegendPosition legend = new(); var data = new List() { new DataItem() { Name = "Data 1", Value = 10 }, new DataItem() { Name = "Data 2", Value = 20 }, new DataItem() { Name = "Data 3", Value = 30 }, new DataItem() { Name = "Data 4", Value = 40 } }; ExcelChartInfo info = new("C:\\Users\\User\\Documents\\testchart.xlsx", "My Document", "My Chart", legend, data); try { chart.GenerateDocument(info); MessageBox.Show("Сохарнено успешно", "Результат", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }