public Mersim getDataForHydrocondition(int idStudy, int year, int period, string hydrocondition) { Model model = new Model(); int hydroconditionId = getHydroconditionId(hydrocondition); IDataReader dataTotal = model.getScenario(idStudy, year, period, hydroconditionId); IDataReader dataThermal = model.getThermalDataForScenario(idStudy, year, period, hydroconditionId); IDataReader dataHydro = model.getHydroDataForScenario(idStudy, year, period, hydroconditionId); Mersim mersimOne = new Mersim(dataTotal, dataThermal, dataHydro); return mersimOne; }
public Mersim getDataForHydrocondition(int idStudy, int year, int period, string hydrocondition) { Model model = new Model(); int hydroconditionId = getHydroconditionId(hydrocondition); IDataReader dataTotal = model.getScenario(idStudy, year, period, hydroconditionId); IDataReader dataThermal = model.getThermalDataForScenario(idStudy, year, period, hydroconditionId); IDataReader dataHydro = model.getHydroDataForScenario(idStudy, year, period, hydroconditionId); Mersim mersimOne = new Mersim(dataTotal, dataThermal, dataHydro); return(mersimOne); }
public static void writeStudyToExcel(string fileName, int idStudy) { Model model = new Model(); Exc.Application ObjExcel = null; Exc.Workbook ObjWorkBook = null; Exc.Worksheet ObjWorkSheet = null; try { //Приложение самого Excel ObjExcel = new Exc.Application(); //Книга. ObjWorkBook = ObjExcel.Workbooks.Add(System.Reflection.Missing.Value); //Таблица. ObjWorkSheet = (Exc.Worksheet)ObjWorkBook.Sheets[1]; IDataReader study = model.getStudyForId(idStudy); IDataReader scenaries = model.getScanariosForStudy(idStudy); study.Read(); ObjExcel.Cells[1, 1] = study.GetValue(0).ToString(); ObjExcel.Cells[2, 1] = study.GetValue(1).ToString(); int rowNumber = 5; int marginRow = 2; while (scenaries.Read()) { ObjExcel.Cells[rowNumber, 1] = "Year:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(1).ToString(); ObjExcel.Cells[++rowNumber, 1] = "Period:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(2).ToString(); ObjExcel.Cells[++rowNumber, 1] = "Hydrocondition:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(3).ToString(); ObjExcel.Cells[++rowNumber, 1] = "Probality:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(4).ToString(); IDataReader hydroData = new Model().getHydroDataForScenario(idStudy, int.Parse(scenaries.GetValue(1).ToString()), int.Parse(scenaries.GetValue(2).ToString()), int.Parse(scenaries.GetValue(3).ToString())); rowNumber += marginRow; while (hydroData.Read()) { for (int i = 1; i < 16; i++) { ObjExcel.Cells[rowNumber, i] = hydroData.GetValue(i - 1).ToString(); } rowNumber++; } IDataReader thermalData = model.getThermalDataForScenario(idStudy, int.Parse(scenaries.GetValue(1).ToString()), int.Parse(scenaries.GetValue(2).ToString()), int.Parse(scenaries.GetValue(3).ToString())); rowNumber += marginRow; while (thermalData.Read()) { for (int i = 1; i < 16; i++) { ObjExcel.Cells[rowNumber, i] = thermalData.GetValue(i - 1).ToString(); } rowNumber++; } rowNumber += marginRow; } ObjWorkBook.SaveAs(fileName); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } finally { //Закрытие книгу Excel. ObjWorkBook.Close(); //Закрытие приложения Excel. ObjExcel.Quit(); //Обнуляем созданые объекты ObjWorkBook = null; ObjWorkSheet = null; ObjExcel = null; //Вызываем сборщик мусора для их уничтожения и освобождения памяти GC.Collect(); } }
public static void writeStudyToExcel(string fileName, int idStudy) { Model model = new Model(); Exc.Application ObjExcel=null; Exc.Workbook ObjWorkBook=null; Exc.Worksheet ObjWorkSheet=null; try { //Приложение самого Excel ObjExcel = new Exc.Application(); //Книга. ObjWorkBook = ObjExcel.Workbooks.Add(System.Reflection.Missing.Value); //Таблица. ObjWorkSheet = (Exc.Worksheet)ObjWorkBook.Sheets[1]; IDataReader study = model.getStudyForId(idStudy); IDataReader scenaries = model.getScanariosForStudy(idStudy); study.Read(); ObjExcel.Cells[1, 1] = study.GetValue(0).ToString(); ObjExcel.Cells[2, 1] = study.GetValue(1).ToString(); int rowNumber = 5; int marginRow = 2; while (scenaries.Read()) { ObjExcel.Cells[rowNumber, 1] = "Year:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(1).ToString(); ObjExcel.Cells[++rowNumber, 1] = "Period:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(2).ToString(); ObjExcel.Cells[++rowNumber, 1] = "Hydrocondition:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(3).ToString(); ObjExcel.Cells[++rowNumber, 1] = "Probality:"; ObjExcel.Cells[rowNumber, 2] = scenaries.GetValue(4).ToString(); IDataReader hydroData = new Model().getHydroDataForScenario(idStudy, int.Parse(scenaries.GetValue(1).ToString()), int.Parse(scenaries.GetValue(2).ToString()), int.Parse(scenaries.GetValue(3).ToString())); rowNumber += marginRow; while (hydroData.Read()) { for (int i = 1; i < 16; i++) { ObjExcel.Cells[rowNumber, i] = hydroData.GetValue(i - 1).ToString(); } rowNumber++; } IDataReader thermalData = model.getThermalDataForScenario(idStudy, int.Parse(scenaries.GetValue(1).ToString()), int.Parse(scenaries.GetValue(2).ToString()), int.Parse(scenaries.GetValue(3).ToString())); rowNumber += marginRow; while (thermalData.Read()) { for (int i = 1; i < 16; i++) { ObjExcel.Cells[rowNumber, i] = thermalData.GetValue(i - 1).ToString(); } rowNumber++; } rowNumber += marginRow; } ObjWorkBook.SaveAs(fileName); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } finally { //Закрытие книгу Excel. ObjWorkBook.Close(); //Закрытие приложения Excel. ObjExcel.Quit(); //Обнуляем созданые объекты ObjWorkBook = null; ObjWorkSheet = null; ObjExcel = null; //Вызываем сборщик мусора для их уничтожения и освобождения памяти GC.Collect(); } }