private void getLarButton_Click(object sender, EventArgs e)
{
//Переключение выбора пола
byte sex = 0;
String sexName = "";
String sheetName = "";//Задание имени страницы
if (manRB.Checked)
{
sex = RiskCalculator.SEX_MALE;
sexName = "Мужчины";
}
else if (womanRB.Checked)
{
sex = RiskCalculator.SEX_FEMALE;
sexName = "Женщины";
}
//Задание весовых коэффициентов для тканей (в нашем случае учитывается только влияние на лёгкие)
double wLung = 0.12;
//Задание возрастных границ и заполнение дозовых историй
int ages = Convert.ToInt32(maxAgeBox.Text) - Convert.ToInt32(minAgeBox.Text);
List<RiskCalculator.DoseHistoryRecord[]> listOfDoseHistories = new List<RiskCalculator.DoseHistoryRecord[]>();
for (int i = 0; i <= ages; i++)
{
listOfDoseHistories.Add(new RiskCalculator.DoseHistoryRecord[1]);
}
foreach (RiskCalculator.DoseHistoryRecord[] record in listOfDoseHistories)
{
for (int i = 0; i < record.Length; i++)
record[i] = new RiskCalculator.DoseHistoryRecord();
}
for (int i = 0; i <= ages; i++)
{
listOfDoseHistories[i][0].AgeAtExposure = Convert.ToInt16(Convert.ToInt32(minAgeBox.Text) + i);
listOfDoseHistories[i][0].AllSolidDoseInmGy = 1000;
listOfDoseHistories[i][0].LeukaemiaDoseInmGy = 1000;
listOfDoseHistories[i][0].LungDoseInmGy = 1000 / wLung;
}
//RiskCalculator.DoseHistoryRecord[] recordTest = listOfDoseHistories[0];
//RiskCalculatorLib.RiskCalculator calculator = new RiskCalculatorLib.RiskCalculator(sex, listOfDoseHistories[0][0].AgeAtExposure, ref recordTest, true);
//bool var = false;
////calculator.createEARSamples(1, ref var);
//calculator.createEARSamples(0, ref var);// - правильный вариант
//RiskCalculator.ValueBounds<RiskCalculator.LAR> value = calculator.getDetriment();
//testTextBox.Text = value.Value.AllCancers.ToString();
//Создание словаря, где ключ - возраст, а значение - LAR
Dictionary<short, double> resultList = new Dictionary<short, double>();
bool isIncidence = false;
for (int i = 0; i <= ages; i++)
{
RiskCalculator.DoseHistoryRecord[] record = listOfDoseHistories[i];
if (externalRB.Checked)
{
RiskCalculatorLib.RiskCalculator calculator = new RiskCalculatorLib.RiskCalculator(sex, listOfDoseHistories[i][0].AgeAtExposure, ref record, true);
if (larRB.Checked)
{
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getLAR(false, isIncidence).AllCancers);
}
if (detRB.Checked)
{
calculator.createEARSamples(0, ref isIncidence);
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getDetriment().Value.AllCancers);
}
sheetName = sexName + " Внешнее";
}
if (internalRB.Checked)
{
RiskCalculatorLib.RiskCalculator calculator = new RiskCalculatorLib.RiskCalculator(sex, listOfDoseHistories[i][0].AgeAtExposure, ref record, true);
if (larRB.Checked)
{
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getLAR(false, isIncidence).Lung);
}
if (detRB.Checked)
{
calculator.createEARSamples(0, ref isIncidence);
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getDetriment().Value.Lung);
}
sheetName = sexName + " Внутреннее";
}
}
//if (larRB.Checked)
//{
// testTextBox.Text = "LAR " + resultList.Count;
//}
//else if (detRB.Checked)
//{
// testTextBox.Text = "Det " + resultList.Count;
//}
//Вывод в Excel-файл
List<short> keyList = new List<short>(resultList.Keys);//Список ключей из словаря
//Инициализация Excel-файла
Excel.Application excelApp = new Excel.Application();
//excelApp.Visible = true;
excelApp.DisplayAlerts = true;
excelApp.StandardFont = "Times-New-Roman";
excelApp.StandardFontSize = 12;
//Создание рабочей книги с 4 страницами, в которые будет выводиться информация
excelApp.Workbooks.Add(Type.Missing);
Excel.Workbook excelWorkbook = excelApp.Workbooks[1];
excelApp.SheetsInNewWorkbook = 4;
Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets.get_Item(1);
excelWorksheet.Name = sheetName;
//Описываем ячейку А1 на странице
Excel.Range excelCells = excelWorksheet.get_Range("A1");
excelCells.VerticalAlignment = Excel.Constants.xlCenter;
excelCells.HorizontalAlignment = Excel.Constants.xlCenter;
excelCells.Borders.Weight = Excel.XlBorderWeight.xlThick;
excelCells.Value2 = "AgeAtExp";
//Описываем ячейку В1 на странице
excelCells = excelWorksheet.get_Range("B1");
excelCells.VerticalAlignment = Excel.Constants.xlCenter;
excelCells.HorizontalAlignment = Excel.Constants.xlCenter;
excelCells.Borders.Weight = Excel.XlBorderWeight.xlThick;
if (larRB.Checked)
excelCells.Value2 = "LAR";
else if (detRB.Checked)
excelCells.Value2 = "Det";
//Вывод в столбцы
for (int i = 2; i <= resultList.Count + 1; i++)
{
excelCells = (Excel.Range)excelWorksheet.Cells[i, "A"];
excelCells.Value2 = keyList[i - 2];
excelCells.Borders.ColorIndex = 1;
excelCells = (Excel.Range)excelWorksheet.Cells[i, "B"];
excelCells.Value2 = resultList[keyList[i - 2]];
excelCells.Borders.ColorIndex = 1;
}
char[] timeNameBuffer = DateTime.Now.ToString().ToCharArray();
for (int i = 0; i < timeNameBuffer.Length; i++)
{
if (timeNameBuffer[i] == ':')
timeNameBuffer[i] = '-';
}
String saveAs = "";
if (larRB.Checked)
{
if (externalRB.Checked)
saveAs = sexName + " внешнее (LAR)";
if (internalRB.Checked)
saveAs = sexName + " внутреннее (LAR)";
}
if (detRB.Checked)
{
if (externalRB.Checked)
saveAs = sexName + " внешнее (Det)";
if (internalRB.Checked)
saveAs = sexName + " внутреннее (Det)";
}
excelWorkbook.SaveAs(@Path.GetDirectoryName(Application.ExecutablePath) + "\\" + saveAs + "(" + new string(timeNameBuffer) + ").xlsx", //object Filename
Excel.XlFileFormat.xlOpenXMLWorkbook, //object FileFormat
Type.Missing, //object Password
Type.Missing, //object WriteResPassword
Type.Missing, //object ReadOnlyRecommended
Type.Missing, //object CreateBackup
Excel.XlSaveAsAccessMode.xlNoChange,//XlSaveAsAccessMode AccessMode
Type.Missing, //object ConflictResolution
Type.Missing, //object AddToMru
Type.Missing, //object TextCodepage
Type.Missing, //object TextVisualLayout
Type.Missing); //object Local
excelApp.Quit();
}
private void getLarButton_Click(object sender, EventArgs e)
{
//Переключение выбора пола
byte sex = 0;
String sexName = "";
String sheetName = "";//Задание имени страницы
if (manRB.Checked)
{
sex = RiskCalculator.SEX_MALE;
sexName = "Мужчины";
}
else if (womanRB.Checked)
{
sex = RiskCalculator.SEX_FEMALE;
sexName = "Женщины";
}
//Задание весовых коэффициентов для тканей (в нашем случае учитывается только влияние на лёгкие)
double wLung = 0.12;
//Задание возрастных границ и заполнение дозовых историй
int ages = Convert.ToInt32(maxAgeBox.Text) - Convert.ToInt32(minAgeBox.Text);
List <RiskCalculator.DoseHistoryRecord[]> listOfDoseHistories = new List <RiskCalculator.DoseHistoryRecord[]>();
for (int i = 0; i <= ages; i++)
{
listOfDoseHistories.Add(new RiskCalculator.DoseHistoryRecord[1]);
}
foreach (RiskCalculator.DoseHistoryRecord[] record in listOfDoseHistories)
{
for (int i = 0; i < record.Length; i++)
{
record[i] = new RiskCalculator.DoseHistoryRecord();
}
}
for (int i = 0; i <= ages; i++)
{
listOfDoseHistories[i][0].AgeAtExposure = Convert.ToInt16(Convert.ToInt32(minAgeBox.Text) + i);
listOfDoseHistories[i][0].AllSolidDoseInmGy = 1000;
listOfDoseHistories[i][0].LeukaemiaDoseInmGy = 1000;
listOfDoseHistories[i][0].LungDoseInmGy = 1000 / wLung;
}
//RiskCalculator.DoseHistoryRecord[] recordTest = listOfDoseHistories[0];
//RiskCalculatorLib.RiskCalculator calculator = new RiskCalculatorLib.RiskCalculator(sex, listOfDoseHistories[0][0].AgeAtExposure, ref recordTest, true);
//bool var = false;
////calculator.createEARSamples(1, ref var);
//calculator.createEARSamples(0, ref var);// - правильный вариант
//RiskCalculator.ValueBounds<RiskCalculator.LAR> value = calculator.getDetriment();
//testTextBox.Text = value.Value.AllCancers.ToString();
//Создание словаря, где ключ - возраст, а значение - LAR
Dictionary <short, double> resultList = new Dictionary <short, double>();
bool isIncidence = false;
for (int i = 0; i <= ages; i++)
{
RiskCalculator.DoseHistoryRecord[] record = listOfDoseHistories[i];
if (externalRB.Checked)
{
RiskCalculatorLib.RiskCalculator calculator = new RiskCalculatorLib.RiskCalculator(sex, listOfDoseHistories[i][0].AgeAtExposure, ref record, true);
if (larRB.Checked)
{
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getLAR(false, isIncidence).AllCancers);
}
if (detRB.Checked)
{
calculator.createEARSamples(0, ref isIncidence);
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getDetriment().Value.AllCancers);
}
sheetName = sexName + " Внешнее";
}
if (internalRB.Checked)
{
RiskCalculatorLib.RiskCalculator calculator = new RiskCalculatorLib.RiskCalculator(sex, listOfDoseHistories[i][0].AgeAtExposure, ref record, true);
if (larRB.Checked)
{
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getLAR(false, isIncidence).Lung);
}
if (detRB.Checked)
{
calculator.createEARSamples(0, ref isIncidence);
resultList.Add(listOfDoseHistories[i][0].AgeAtExposure, calculator.getDetriment().Value.Lung);
}
sheetName = sexName + " Внутреннее";
}
}
//if (larRB.Checked)
//{
// testTextBox.Text = "LAR " + resultList.Count;
//}
//else if (detRB.Checked)
//{
// testTextBox.Text = "Det " + resultList.Count;
//}
//Вывод в Excel-файл
List <short> keyList = new List <short>(resultList.Keys);//Список ключей из словаря
//Инициализация Excel-файла
Excel.Application excelApp = new Excel.Application();
//excelApp.Visible = true;
excelApp.DisplayAlerts = true;
excelApp.StandardFont = "Times-New-Roman";
excelApp.StandardFontSize = 12;
//Создание рабочей книги с 4 страницами, в которые будет выводиться информация
excelApp.Workbooks.Add(Type.Missing);
Excel.Workbook excelWorkbook = excelApp.Workbooks[1];
excelApp.SheetsInNewWorkbook = 4;
Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets.get_Item(1);
excelWorksheet.Name = sheetName;
//Описываем ячейку А1 на странице
Excel.Range excelCells = excelWorksheet.get_Range("A1");
excelCells.VerticalAlignment = Excel.Constants.xlCenter;
excelCells.HorizontalAlignment = Excel.Constants.xlCenter;
excelCells.Borders.Weight = Excel.XlBorderWeight.xlThick;
excelCells.Value2 = "AgeAtExp";
//Описываем ячейку В1 на странице
excelCells = excelWorksheet.get_Range("B1");
excelCells.VerticalAlignment = Excel.Constants.xlCenter;
excelCells.HorizontalAlignment = Excel.Constants.xlCenter;
excelCells.Borders.Weight = Excel.XlBorderWeight.xlThick;
if (larRB.Checked)
{
excelCells.Value2 = "LAR";
}
else if (detRB.Checked)
{
excelCells.Value2 = "Det";
}
//Вывод в столбцы
for (int i = 2; i <= resultList.Count + 1; i++)
{
excelCells = (Excel.Range)excelWorksheet.Cells[i, "A"];
excelCells.Value2 = keyList[i - 2];
excelCells.Borders.ColorIndex = 1;
excelCells = (Excel.Range)excelWorksheet.Cells[i, "B"];
excelCells.Value2 = resultList[keyList[i - 2]];
excelCells.Borders.ColorIndex = 1;
}
char[] timeNameBuffer = DateTime.Now.ToString().ToCharArray();
for (int i = 0; i < timeNameBuffer.Length; i++)
{
if (timeNameBuffer[i] == ':')
{
timeNameBuffer[i] = '-';
}
}
String saveAs = "";
if (larRB.Checked)
{
if (externalRB.Checked)
{
saveAs = sexName + " внешнее (LAR)";
}
if (internalRB.Checked)
{
saveAs = sexName + " внутреннее (LAR)";
}
}
if (detRB.Checked)
{
if (externalRB.Checked)
{
saveAs = sexName + " внешнее (Det)";
}
if (internalRB.Checked)
{
saveAs = sexName + " внутреннее (Det)";
}
}
excelWorkbook.SaveAs(@Path.GetDirectoryName(Application.ExecutablePath) + "\\" + saveAs + "(" + new string(timeNameBuffer) + ").xlsx", //object Filename
Excel.XlFileFormat.xlOpenXMLWorkbook, //object FileFormat
Type.Missing, //object Password
Type.Missing, //object WriteResPassword
Type.Missing, //object ReadOnlyRecommended
Type.Missing, //object CreateBackup
Excel.XlSaveAsAccessMode.xlNoChange, //XlSaveAsAccessMode AccessMode
Type.Missing, //object ConflictResolution
Type.Missing, //object AddToMru
Type.Missing, //object TextCodepage
Type.Missing, //object TextVisualLayout
Type.Missing); //object Local
excelApp.Quit();
}
