public void Print_Reestr(MySqlQueries mySqlQueries, string otdelenie, DateTimePicker dateTimePicker1, DateTimePicker dateTimePicker2, SaveFileDialog saveFileDialog, DialogResult dialog)
{
ExcelApplication ExcelApp = null;
Workbooks workbooks = null;
Workbook workbook = null;
Worksheet worksheet = null;
string fileName = null;
saveFileDialog.DefaultExt = "Книга Excel|*.xlsx";
saveFileDialog.Filter = "Книга Excel|*.xlsx|Книга Excel 93-2003|*.xls|PDF|*.pdf";
saveFileDialog.Title = "Сохранить реестр эпикризов как";
saveFileDialog.FileName = "Реестр эпикризов отделения " + otdelenie + " с " + dateTimePicker1.Value.ToShortDateString() + " по " + dateTimePicker2.Value.ToShortDateString();
saveFileDialog.InitialDirectory = Application.StartupPath + "\\Реестры эпикризов\\";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
fileName = saveFileDialog.FileName;
string id = Select_Text(MySqlQueries.Select_ID_Otdeleniya_ComboBox, null, otdelenie);
string date1 = dateTimePicker1.Value.Year.ToString() + '-' + dateTimePicker1.Value.Month.ToString() + '-' + dateTimePicker1.Value.Day.ToString();
string date2 = dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString() + '-' + dateTimePicker2.Value.Day.ToString();
DataTable data = Select_DataTable(MySqlQueries.Print_Reestr, id, date1, date2);
try
{
ExcelApp = new ExcelApplication();
workbooks = ExcelApp.Workbooks;
workbook = workbooks.Open(Application.StartupPath + "\\blanks\\reestr.xlsx");
worksheet = workbook.Worksheets.get_Item(1) as Worksheet;
ExcelApp.Cells[1, 1] = "Реестр выписных эпикризов отделения " + '"' + otdelenie + '"';
ExcelApp.Cells[2, 1] = "c " + dateTimePicker1.Value.ToShortDateString() + " по " + dateTimePicker2.Value.ToShortDateString();
int ExCol = 1;
int ExRow = 5;
for (int i = 0; i < data.Rows.Count - 0; i++)
{
ExCol = 1;
for (int j = 0; j < data.Columns.Count; j++)
{
ExcelApp.Cells[ExRow, ExCol] = data.Rows[i][j].ToString();
ExCol++;
}
ExRow++;
}
var cells = worksheet.get_Range("A4 ", "E" + (ExRow - 1).ToString());
cells.Borders[XlBordersIndex.xlInsideVertical].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlInsideHorizontal].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous;
workbook.SaveAs(fileName);
if (dialog == DialogResult.Yes)
{
ExcelApp.Quit();
}
if (dialog == DialogResult.No)
{
workbook.PrintPreview();
ExcelApp.Visible = true;
}
if (dialog == DialogResult.Cancel)
{
workbook.PrintOut();
ExcelApp.Quit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Marshal.ReleaseComObject(worksheet);
Marshal.ReleaseComObject(workbook);
Marshal.ReleaseComObject(workbooks);
Marshal.ReleaseComObject(ExcelApp);
}
}
}
public MySqlOperations(MySqlQueries sqlQueries)
{
this.MySqlQueries = sqlQueries;
}