private void Names_TextChanged(object sender, EventArgs e) { Title = string.Format("{0} \"{1} {2} {3}\" [{4}]", LangMan.LS(LSID.LSID_Person), txtSurname.Text, txtName.Text, cmbPatronymic.Text, fPerson.GetXRefNum()); }
public override void Generate(bool show) { fPath = AppHost.StdDialogs.GetSaveFile("Excel files (*.xls)|*.xls"); if (string.IsNullOrEmpty(fPath)) { return; } Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("First Sheet"); IProgressController progress = AppHost.Progress; progress.ProgressInit(LangMan.LS(LSID.LSID_MIExport) + "...", fTree.RecordsCount); try { worksheet.Cells[1, 1] = new Cell("№"); worksheet.Cells[1, 2] = new Cell(LangMan.LS(LSID.LSID_Surname)); worksheet.Cells[1, 3] = new Cell(LangMan.LS(LSID.LSID_Name)); worksheet.Cells[1, 4] = new Cell(LangMan.LS(LSID.LSID_Patronymic)); worksheet.Cells[1, 5] = new Cell(LangMan.LS(LSID.LSID_Sex)); worksheet.Cells[1, 6] = new Cell(LangMan.LS(LSID.LSID_BirthDate)); worksheet.Cells[1, 7] = new Cell(LangMan.LS(LSID.LSID_DeathDate)); worksheet.Cells[1, 8] = new Cell(LangMan.LS(LSID.LSID_BirthPlace)); worksheet.Cells[1, 9] = new Cell(LangMan.LS(LSID.LSID_DeathPlace)); worksheet.Cells[1, 10] = new Cell(LangMan.LS(LSID.LSID_Residence)); worksheet.Cells[1, 11] = new Cell(LangMan.LS(LSID.LSID_Age)); worksheet.Cells[1, 12] = new Cell(LangMan.LS(LSID.LSID_LifeExpectancy)); ushort row = 1; int num = fTree.RecordsCount; for (int i = 0; i < num; i++) { GEDCOMRecord rec = fTree[i]; if (rec.RecordType == GEDCOMRecordType.rtIndividual) { GEDCOMIndividualRecord ind = (GEDCOMIndividualRecord)rec; if (fSelectedRecords == null || fSelectedRecords.IndexOf(rec) >= 0) { var parts = GKUtils.GetNameParts(ind); string sx = "" + GKUtils.SexStr(ind.Sex)[0]; row++; worksheet.Cells[row, 1] = new Cell(ind.GetXRefNum()); worksheet.Cells[row, 2] = new Cell(parts.Surname); worksheet.Cells[row, 3] = new Cell(parts.Name); worksheet.Cells[row, 4] = new Cell(parts.Patronymic); worksheet.Cells[row, 5] = new Cell(sx); worksheet.Cells[row, 6] = new Cell(GKUtils.GetBirthDate(ind, DateFormat.dfDD_MM_YYYY, false)); worksheet.Cells[row, 7] = new Cell(GKUtils.GetDeathDate(ind, DateFormat.dfDD_MM_YYYY, false)); worksheet.Cells[row, 8] = new Cell(GKUtils.GetBirthPlace(ind)); worksheet.Cells[row, 9] = new Cell(GKUtils.GetDeathPlace(ind)); worksheet.Cells[row, 10] = new Cell(GKUtils.GetResidencePlace(ind, fOptions.PlacesWithAddress)); worksheet.Cells[row, 11] = new Cell(GKUtils.GetAge(ind, -1)); worksheet.Cells[row, 12] = new Cell(GKUtils.GetLifeExpectancy(ind)); } } progress.ProgressStep(); } workbook.Worksheets.Add(worksheet); workbook.Save(fPath); #if !CI_MODE if (show) { ShowResult(); } #endif } finally { progress.ProgressDone(); } }