private void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel.Workbook excelappworkbook; Microsoft.Office.Interop.Excel.Workbooks excelappworkbooks; Microsoft.Office.Interop.Excel.Application excelapp; excelapp = new Microsoft.Office.Interop.Excel.Application(); excelapp.Visible = true; excelapp.SheetsInNewWorkbook = 1; excelapp.Workbooks.Add(Type.Missing); //Запрашивать сохранение excelapp.DisplayAlerts = true; //Получаем набор ссылок на объекты Workbook (на созданные книги) excelappworkbooks = excelapp.Workbooks; //Получаем ссылку на книгу 1 - нумерация от 1 excelappworkbook = excelappworkbooks[1]; //Ссылку можно получить и так, но тогда надо знать имена книг, //причем, после сохранения - знать расширение файла //excelappworkbook=excelappworkbooks["Книга 1"]; //Запроса на сохранение для книги не должно быть excelappworkbook.Saved = true; Microsoft.Office.Interop.Excel.Sheets excelsheets; Microsoft.Office.Interop.Excel.Worksheet excelworksheet; Microsoft.Office.Interop.Excel.Range excelcells; excelsheets = excelappworkbook.Worksheets; //Получаем ссылку на лист 1 excelworksheet = (Microsoft.Office.Interop.Excel.Worksheet)excelsheets.get_Item(1); excelcells = excelworksheet.get_Range("A1", "M33"); if (client != null) { int row = excelWriteHeaderLegalPerson(excelcells, excelworksheet); GetAllLegalPersonPoliciesCommand command = new GetAllLegalPersonPoliciesCommand(); List <InsurancePolicy> list = command.getAllLegalPersonPolicies(client); excelWriteMain(excelcells, excelworksheet, list, row); } if (individual != null) { int row = excelWriteHeaderIndividual(excelcells, excelworksheet); GetAllIndividualPoliciesCommand command = new GetAllIndividualPoliciesCommand(); List <InsurancePolicy> list = command.getallIndividualPolicies(individual); excelWriteMain(excelcells, excelworksheet, list, row); } }
private void policeNumberInput_TextChanged(object sender, EventArgs e) { insuranseCaseInput.Items.Clear(); Regex regex = new Regex("[1-9]{1}[0-9]*"); if (regex.IsMatch(policeNumberInput.Text)) { GetAllIndividualPoliciesCommand command = new GetAllIndividualPoliciesCommand(); int individualClientId = Int32.Parse(policeNumberInput.Text); Individual individualPerson = new Individual(); individualPerson.Id = individualClientId; List <InsurancePolicy> policyList = command.getallIndividualPolicies(individualPerson); foreach (InsurancePolicy policy in policyList) { insuranseCaseInput.Items.AddRange(policy.InsuranceCaseList.ToArray()); } } }
private void fillForIndividual() { richTextBox1.ReadOnly = true; //Since too much string appending go for string builder StringBuilder tableRtf = new StringBuilder(); //beginning of rich text format,dont customize this begining line tableRtf.Append(@"{\rtf1\adeflag1025\ansi\ansicpg1251\uc1\adeff31507\deff0\stshfdbch31506\stshfhich31506\stshfbi31507\deflang1049\deflangfe1049\themelang1049\themelangfe0\stshfloch31506 "); row(tableRtf, "Клиент:", individual.Surname + " " + individual.Name + " " + individual.SecondName); row(tableRtf, "УНН:", "№ " + individual.Id); row(tableRtf, "Адрес:", individual.Address); row(tableRtf, "Телефон:", "тел. " + individual.PhoneNumber); row(tableRtf, "Тип:", "физическое лицо"); //beginning of rich text format,dont customize this begining line tableRtf.Append(@"{\rtf1\adeflag1025\ansi\ansicpg1251 "); tableRtf.Append(@"\trowd"); tableRtf.Append(@"\cellx1500").AppendLine("Дата полиса"); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx3500").AppendLine("Категория полиса"); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx5000").AppendLine("Действоует до"); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx6500").AppendLine("Сумма полича"); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx8500").AppendLine("Стоимость полиса"); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx11000").AppendLine("Суммарные выплаты"); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\intbl \cell \row"); GetAllIndividualPoliciesCommand command = new GetAllIndividualPoliciesCommand(); List <InsurancePolicy> list = command.getallIndividualPolicies(individual); decimal sumPolicyAmount = 0; decimal sumPoliceCost = 0; decimal sumFullPayments = 0; foreach (InsurancePolicy l in list) { tableRtf.Append(@"{\rtf1\adeflag1025\ansi\ansicpg1251 "); tableRtf.Append(@"\trowd"); //A cell with width 1500. tableRtf.Append(@"\cellx1500").AppendLine("/" + l.SignDate.Day + "/" + l.SignDate.Month + "/" + l.SignDate.Year); tableRtf.Append(@"\intbl \cell"); //A cell with width 4000. tableRtf.Append(@"\cellx3500").AppendLine(l.Category.Name); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx5000").AppendLine("/" + l.ExpirationDate.Day + "/" + l.ExpirationDate.Month + "/" + l.ExpirationDate.Year); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx6500").AppendLine("$" + l.Amount); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx8500").AppendLine("$" + l.Cost); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\cellx11000").AppendLine("$" + l.FullPayments); tableRtf.Append(@"\intbl \cell"); tableRtf.Append(@"\intbl \cell \row"); sumPoliceCost += l.Cost; sumPolicyAmount += l.Amount; sumFullPayments += l.FullPayments; } lastRow(tableRtf, "ИТОГО", "$" + sumPolicyAmount, "$" + sumPoliceCost, "$" + sumFullPayments); tableRtf.Append(@"\pard"); tableRtf.Append(@"}"); richTextBox1.Rtf = tableRtf.ToString(); }
private void name_SelectedIndexChanged(object sender, EventArgs e) { dataGridView1.Visible = true; if (clientType.SelectedItem.Equals("юр. лицо")) { LegalPerson legalPerson = (LegalPerson)name.SelectedItem; GetAllLegalPersonPoliciesCommand command = new GetAllLegalPersonPoliciesCommand(); List <InsurancePolicy> legalPolicyList = command.getAllLegalPersonPolicies(legalPerson); dataGridView1.Columns.Add("CategoryName", "Категория"); dataGridView1.Columns.Add("PolicyCost", "Стоимость полиса"); dataGridView1.Columns.Add("PolicyAmount", "Сумма полиса"); dataGridView1.Columns.Add("SignDate", "Дата закл. договора"); dataGridView1.Columns.Add("ExpDate", "Дата оконч. договора"); dataGridView1.Columns.Add("Insurer", "Страховщик"); dataGridView1.Columns.Add("CaseList", "Страховые случаи"); dataGridView1.Rows.Clear(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.MultiSelect = false; dataGridView1.Dock = DockStyle.Fill; legalPolicyBindList = new BindingList <InsurancePolicy>(legalPolicyList); foreach (InsurancePolicy policy in legalPolicyBindList) { int rowNumber = dataGridView1.Rows.Add(); dataGridView1.Rows[rowNumber].Cells["CategoryName"].Value = policy.Category.Name; dataGridView1.Rows[rowNumber].Cells["PolicyCost"].Value = policy.Cost; dataGridView1.Rows[rowNumber].Cells["PolicyAmount"].Value = policy.Amount; dataGridView1.Rows[rowNumber].Cells["SignDate"].Value = policy.SignDate; dataGridView1.Rows[rowNumber].Cells["ExpDate"].Value = policy.ExpirationDate; dataGridView1.Rows[rowNumber].Cells["Insurer"].Value = policy.Insurer.Name + " " + policy.Insurer.SecondName + " " + policy.Insurer.Surname; String cases = ""; foreach (InsuranceCase cs in policy.InsuranceCaseList) { cases = cases + cs.InsuranceCaseName + " "; } dataGridView1.Rows[rowNumber].Cells["CaseList"].Value = cases; } clientType.Visible = false; name.Visible = false; } if (clientType.SelectedItem.Equals("физ. лицо")) { Individual individualPerson = (Individual)name.SelectedItem; GetAllIndividualPoliciesCommand command = new GetAllIndividualPoliciesCommand(); List <InsurancePolicy> individualPolicyList = command.getallIndividualPolicies(individualPerson); dataGridView1.Columns.Add("CategoryName", "Категория"); dataGridView1.Columns.Add("PolicyCost", "Стоимость полиса"); dataGridView1.Columns.Add("PolicyAmount", "Сумма полиса"); dataGridView1.Columns.Add("SignDate", "Дата закл. договора"); dataGridView1.Columns.Add("ExpDate", "Дата оконч. договора"); dataGridView1.Columns.Add("Insurer", "Страховщик"); dataGridView1.Columns.Add("CaseList", "Страховые случаи"); dataGridView1.Rows.Clear(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.MultiSelect = false; dataGridView1.Dock = DockStyle.Fill; individualPolicyBindList = new BindingList <InsurancePolicy>(individualPolicyList); foreach (InsurancePolicy policy in individualPolicyBindList) { int rowNumber = dataGridView1.Rows.Add(); dataGridView1.Rows[rowNumber].Cells["CategoryName"].Value = policy.Category.Name; dataGridView1.Rows[rowNumber].Cells["PolicyCost"].Value = policy.Cost; dataGridView1.Rows[rowNumber].Cells["PolicyAmount"].Value = policy.Amount; dataGridView1.Rows[rowNumber].Cells["SignDate"].Value = policy.SignDate; dataGridView1.Rows[rowNumber].Cells["ExpDate"].Value = policy.ExpirationDate; dataGridView1.Rows[rowNumber].Cells["Insurer"].Value = policy.Insurer.Name + " " + policy.Insurer.SecondName + " " + policy.Insurer.Surname; String cases = ""; foreach (InsuranceCase cs in policy.InsuranceCaseList) { cases = cases + cs.InsuranceCaseName + " "; } dataGridView1.Rows[rowNumber].Cells["CaseList"].Value = cases; } clientType.Visible = false; name.Visible = false; } }