/// <summary>
/// Выгрузка данных в Excel;
/// </summary>
/// <returns></returns>
public void createXLS()
{
ExcelClass TZExcel = new ExcelClass();
HashCode.HashCode.CheckFileByHash("техническое задание.xlt");
if (System.IO.File.Exists(Program.PathString + "\\техническое задание.xlt"))
{
try
{
TZExcel.OpenDocument(Program.PathString + "\\техническое задание.xlt");
TZExcel.Visible = false;
if ((BMPIsLoad == 1) || (BMPIsLoad == 3))
{
if (this.SCETCH1.Image != null)
{
using (TemporaryFile tempFile = new TemporaryFile())
{
this.SCETCH1.Image.Save(tempFile.FilePath.ToString(), System.Drawing.Imaging.ImageFormat.Bmp);
TZExcel.SelectCells(this.SCETCH1.Name, Type.Missing);
TZExcel.WritePictureToCell(tempFile.FilePath.ToString());
}
}
}
else if ((BMPIsLoad == 0) || (BMPIsLoad == 2))
{
if (this.SCETCH1.Image != null)
{
TZExcel.SelectCells(this.SCETCH1.Name, Type.Missing);
TZExcel.WritePictureToCell(SQLOracle.LoadImageToTemp("Select SCETCH1 FROM USP_TZ_DATA WHERE ID_DOC = '" + number + "'"));
}
}
if ((BMPIsLoad == 2) || (BMPIsLoad == 3))
{
if (this.SCETCH2.Image != null)
{
using (TemporaryFile tempFile = new TemporaryFile())
{
this.SCETCH2.Image.Save(tempFile.FilePath.ToString(), System.Drawing.Imaging.ImageFormat.Bmp);
TZExcel.SelectCells(this.SCETCH2.Name, Type.Missing);
TZExcel.WritePictureToCell(tempFile.FilePath.ToString());
}
}
}
else if ((BMPIsLoad == 0) || (BMPIsLoad == 1))
{
if (this.SCETCH2.Image != null)
{
TZExcel.SelectCells(this.SCETCH2.Name, Type.Missing);
TZExcel.WritePictureToCell(SQLOracle.LoadImageToTemp("Select SCETCH2 FROM USP_TZ_DATA WHERE ID_DOC = '" + number + "'"));
}
}
for (int i = 0; i < this.tabPage1.Controls.Count; i++)
{
if (this.tabPage1.Controls[i].Controls.Count == 0)
{
if ((this.tabPage1.Controls[i].GetType() == typeof(DateTimePicker)) || (this.tabPage1.Controls[i].GetType() == typeof(TextBox)) || (this.tabPage1.Controls[i].GetType() == typeof(ComboBox)))
{
TZExcel.SelectCells(this.tabPage1.Controls[i].Name, Type.Missing);
TZExcel.WriteDataToCell(this.tabPage1.Controls[i].Text.ToString());
}
}
else if (this.tabPage1.Controls[i].Controls.Count > 0)
{
ExcelExport(this.tabPage1.Controls[i], ref TZExcel);
}
}
for (int i = 0; i < this.tabPage2.Controls.Count; i++)
{
if (this.tabPage2.Controls[i].Controls.Count == 0)
{
if ((this.tabPage2.Controls[i].GetType() == typeof(DateTimePicker)) || (this.tabPage2.Controls[i].GetType() == typeof(TextBox)) || (this.tabPage2.Controls[i].GetType() == typeof(ComboBox)))
{
TZExcel.SelectCells(this.tabPage2.Controls[i].Name, Type.Missing);
TZExcel.WriteDataToCell(this.tabPage2.Controls[i].Text.ToString());
}
}
else if (this.tabPage2.Controls[i].Controls.Count > 0)
{
ExcelExport(this.tabPage2.Controls[i], ref TZExcel);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
finally
{
TZExcel.Visible = true;
TZExcel.Dispose();
}
}
}